| |
Entity Relational Modeling
vs.
Dimensional Modeling
Data Modeling Overview
- A Data model is a conceptual representation of data structures(tables) required for a database and is very powerful in expressing and communicating the business requirements.
- Data model helps functional and technical team in designing the database.
Data Modeler Role
- Business Requirement Analysis: Interact with Business Analysts to get the functional requirements.
- Interact with end users and find out the reporting needs.
- Conduct interviews, brain storming discussions with project team to get additional requirements.
- Gather accurate data by data analysis and functional analysis.
Popular Data Modeling Tools
Tool Name |
Company Name |
| Erwin |
Computer Associates |
| Embarcadero |
Embarcadero Technologies |
| Rational Rose |
IBM Corporation |
| Power Designer |
Sybase Corporation |
| Oracle Designer |
Oracle Corporation |
Data Modeling Tool- Erwin
- What can be done with Erwin?
- Logical, Physical and dimensional data models can be created.
- Data Models can be created from existing systems(rdbms, dbms, files etc.).
- Different versions of a data model can be compared.
- Data model and database can be compared.
- SQl scripts can be generated to create databases from data model.
- Reports can be generated in different file formats like .html, .rtf, and .txt.
- Data models can be opened and saved in several different file types like .er1, .ert, .bpx, .xml, .ers, .sql, .cmt, .df, .dbf, and .mdb files.
- By using ModelMart, concurrent users can work on the same data model.
Back to Entity Relational Modeling vs. Dimensional Modeling Index
|
 |
