DATA MODELING AND METADATA MODELING
WITH SYBASE POWER DESIGNER
Copyright KEYSOFT Solutions
[Link]
DATA MODEL AND DATA MODELING
• A data model is an abstract model that describes how
data is represented and used
• Data modeling is the analysis of data objects
• This is typically done to solve some business enterprise
requirement such as analyzing and separating different
process of the enterprise
Copyright KEYSOFT Solutions
[Link]
METADATA CREATION
• Metadata can be simply defined as a data about a
data
• This data is given importance as it involves in storing
and managing data pertaining to the models created
• It allows the most effective performance of data
warehouse
Copyright KEYSOFT Solutions
[Link]
ABOUT SYBASE POWERDESIGNER
• Data and metadata modeling tool
• Reverse engineering for RDBMS- this is done to develop a
data model based on existing database
• Multi Level Design- all in one design solution pertaining
different modeling facility for an Enterprise model
• Saves time while operating- Since Data and other
components are graphically created and reverse
engineered it takes very less time to generate output
• Easy interactive software
Copyright KEYSOFT Solutions
[Link]
CAN POWERDESIGNER BE USED BY AN
ENTIRE ENTERPRISE TECHINICAL TEAM?
Almost by all in an Enterprise IT division.
• Business Analysts
• Data analysts
• Database Administrators
• Developers
• Team Leaders
• Testers
Copyright KEYSOFT Solutions
[Link]
DESIGN CAPABILITIES OF POWERDESIGNER
• Requirement Model
• Conceptual data Model
• Business oriented data model
• Physical data model
• Object oriented data model
• Information Liquid data model
• XML model or a graphical model
Copyright KEYSOFT Solutions
[Link]
Copyright KEYSOFT Solutions
[Link]
REQUIREMENT MODEL
• The type of model which we need to create
according to enterprise requirements such as
requirements from Marketing department,
Production department…
• It gives the combination of all other different
models
• A model made up of different languages such as
Java, C#, Visual Basic.,
Copyright KEYSOFT Solutions
[Link]
CONCEPTUAL DATA MODEL
• Conceptual Data Model gives the formal
representation of data in its raw form
• With the help of Conceptual Data Model, a graphical
representation of an ER-diagram can be created
• It confirms the validity of the design
• Using a Conceptual Data Model we can create a
Physical Data Model and a Object oriented Model
Copyright KEYSOFT Solutions
[Link]
PHYSICAL DATA MODEL
• A Physical data model is used for designing and
creating structured queries, ER-Diagram etc…
• Plays an important role in creation of a Data
Warehouse as it helps in designing structure of a
Data Warehouse.
Copyright KEYSOFT Solutions
[Link]
BUSINESS PROCESS MODEL
• Business Process Modeling enables users to analyze
and understand the needs and flow of their
enterprise
• We use Conceptual data model (CDM) or physical
data model (PDM) to design relational data ,then
importing these data into Business process model
(BPM) which creates a situation for Enterprise
modeling to be done
• As every model has an option of changing their
process languages, the whole model content is
automatically generated according to the process
language which we select. Thus it becomes an
unique model which can be highlighted and used in
a specific model
Copyright KEYSOFT Solutions
[Link]
Copyright KEYSOFT Solutions
[Link]
OBJECT ORIENTED MODEL
Object Oriented Model is used for
• Creating code for C++ ,Visual Basics..
• Creating Physical, Conceptual and XML Model
• Creating standard object indicated graphics; which is a
graphical analysis of a scheme using signs and language
notations of the Unified Modeling Language (UML, a
standard object-oriented modeling)
• Generate and reverse engineer Java, C# and
PowerBuilder files
Copyright KEYSOFT Solutions
[Link]
INFORMATION LIQUIDITY MODEL
• Information Liquidity Model is a tool used for
ETL(Extract transfer and load) and EII (Enterprise
Information Integration)purpose
• Information Liquidity Model helps in designing data
transfer
• Information Liquidity Model helps in mapping different
models in the same page
• Information Liquidity Model helps to create reports and
print reports
Copyright KEYSOFT Solutions
[Link]
Copyright KEYSOFT Solutions
[Link]
eXTENSIBLE MARKUP LANGUAGE MODEL
• eXtensible Markup Language (XML) Model is used
to restrain application data
• XML helps in storing data in Plain Text Format
which helps in migrating data between
inappropriate systems
• XML is also used for creating & storing data in the
following formats:
• XSD (eXtensible schema definitions ),
• XDR (External Data representation) and
• DTD (Document type declaration).
Copyright KEYSOFT Solutions
[Link]
REPOSITORY WORK CYCLE
Copyright KEYSOFT Solutions
[Link]
BENEFITS OF POWERDESIGNER
• Metadata management
• Transformation of structural data
• Greater agility in IT performance in an organization
• Greater standard and compliance
• As an Enterprising software it sets up a high performance management
environment
• Impact analysis
• Gives an effective analysis in analyzing enterprise data by generating reports..
• Do less by hand and save time, money and efficiency
• Minimal work done with very less time taken to create Models
• Model driven management
• The entire process is done model wise, by using different models we can
understand and
align enterprise process
Copyright KEYSOFT Solutions
[Link]
ADVANTAGE OVER OTHER DATA
MODELING TOOLS
• Reverse engineering Database
• Transforming data from other RDBMS into PowerDesigner
Files
• Erwin conversion Database menu
• Provides an option of converting Erwin files
• Easy naming convention
• Provides easier ways to name tables and models
• Easy Model management
• Models created are easily managed and saved
• Language Support
• Languages such Java,C++,etc can be changed extensively using
PowerDesigner by using specific Design models
Copyright KEYSOFT Solutions
[Link]
For more presentations visit:
[Link]
Or mail us at questions@[Link]
For an exclusive
Forum on Business Intelligence visit:
[Link]
Copyright KEYSOFT Solutions
[Link]