| Home >Tutorial > Entity Relational Modeling vs. Dimensional Modeling > Data Modeling Overview |
|
| 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.
|
| |
|
