DATA MODELING AND METADATA MODELING WITH SYBASE POWER DESIGNER
ww.keysoft.co.in
Copyright KEYSOFT Solutions
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
ww.keysoft.co.in
Copyright KEYSOFT Solutions
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
ww.keysoft.co.in
Copyright KEYSOFT Solutions
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
ww.keysoft.co.in
Copyright KEYSOFT Solutions
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
ww.keysoft.co.in
Copyright KEYSOFT Solutions
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
ww.keysoft.co.in
Copyright KEYSOFT Solutions
ww.keysoft.co.in
Copyright KEYSOFT Solutions
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.,
ww.keysoft.co.in
Copyright KEYSOFT Solutions
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
ww.keysoft.co.in
Copyright KEYSOFT Solutions
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.
ww.keysoft.co.in
Copyright KEYSOFT Solutions
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
ww.keysoft.co.in
Copyright KEYSOFT Solutions
ww.keysoft.co.in
Copyright KEYSOFT Solutions
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
ww.keysoft.co.in
Copyright KEYSOFT Solutions
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
ww.keysoft.co.in
Copyright KEYSOFT Solutions
ww.keysoft.co.in
Copyright KEYSOFT Solutions
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: • • •
ww.keysoft.co.in
XSD (eXtensible schema definitions ), XDR (External Data representation) and DTD (Document type declaration).
Copyright KEYSOFT Solutions
REPOSITORY WORK CYCLE
ww.keysoft.co.in
Copyright KEYSOFT Solutions
BENEFITS OF POWERDESIGNER •
Metadata management •
Transformation of structural data
•
Greater agility in IT performance in an organization
•
Greater standard and compliance •
•
Impact analysis •
•
Gives an effective analysis in analyzing enterprise data by generating reports..
Do less by hand and save time, money and efficiency •
•
As an Enterprising software it sets up a high performance management environment
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
ww.keysoft.co.in
Copyright KEYSOFT Solutions
ADVANTAGE OVER OTHER DATA MODELING TOOLS •
Reverse engineering Database •
•
Erwin conversion Database menu •
•
Provides easier ways to name tables and models
Easy Model management •
•
Provides an option of converting Erwin files
Easy naming convention •
•
Transforming data from other RDBMS into PowerDesigner Files
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
ww.keysoft.co.in
Copyright KEYSOFT Solutions
For more presentations visit: http://www.keysoft.co.in/downloads.aspx Or mail us at
[email protected]
For an exclusive Forum on Business Intelligence visit:
ww.keysoft.co.in
http://forums.keysoft.co.in
Copyright KEYSOFT Solutions