Developing a Data Model

Go Up to Data Modeling Fundamentals

The following overview outlines the ER/Studio Data Architect data model development process, which is an iterative process:

• Starting With a Basic Data Model
• Creating a Basic Data Model
• Reverse Engineering a Database
• Importing a File to Create a New Database
• Ensuring Data Integrity
• Automating Data Model Creation and Maintenance
• Fine Tuning the Data Model
• Securing the Data Model
• Preparing for Review and Implementation
• Maintaining the Data Model

Starting With a Basic Data Model

You can start from scratch or reverse engineer an existing database.

Creating a Basic Data Model

1. Create a new data model.
2. Add entities.
3. Define entity attributes.
4. Establish relationships between entities.
5. Assign keys.

Reverse Engineering a Database

Reverse engineer a database.

Importing a File to Create a New Database

Import data from a variety of sources to create a new database. See Importing a Model from an ERX File and Importing a Model from a SQL File for further details.

Ensuring Data Integrity

1. Ensure object names conform to business standards by creating and applying naming conventions.
2. Ensure data values are within a specified range or that they match a value defined in a list by defining reference values.
3. Ensure data input in tables or column is valid by add rules.

Automating Data Model Creation and Maintenance

1. Accelerate entity creation and updates by creating domains.
2. Assist user data entry by assigning default values.
3. Create macros to perform repetitive tasks.
4. Define default values for attributes, domains, and user datatypes.
5. Add reusable procedural logic.

Fine Tuning the Data Model

1. Validate the model.
2. Customize the datatype mappings.
3. Create user-defined datatypes for domains and attributes.
4. Generate a physical model.
5. Normalize to reduce data redundancy.
6. Denormalize to improve performance.

Securing the Data Model

1. Check the data model in to the Repository.
2. Prevent the data model from being updated or viewed by unauthorized persons by creating Users, Groups. and Roles and apply them to the data model. See Creating and Editing Database Users and Creating and Editing Database Roles for more information.
3. Prevent the database from being updated or viewed by unauthorized persons by creating Users and Roles and apply them to the data model. See Creating and Editing Database Users and Creating and Editing Database Roles for more information.
4. Specify data security information.

Preparing for Review and Implementation

1. Customize the model display.
2. Provide additional documentation for data model reviewers by creating attachments.
3. Document data lineage.
4. Create reports for distribution.
5. Make it easy for users to access the data by providing a dimensional mode.
6. Generate SQL to implement the database.

Maintaining the Data Model

1. Ensure the model is updated from the correct sources by documenting data lineage.
2. As the physical database is updated, synchronize the physical database model with the physical database.
3. As the physical database model is updated, synchronize the logical database with the physical database.
4. As updates are required, check out portions of the data model from the Repository.

See Also

• Data Modeling Concepts
• Customizing the Data Model