One of the neat features in ER/Studio is the ability to easily perform impact analysis by tracing tables back to other tables and also back to their logical data model entity through the Where Used tab in the Table Editor. For this exercise, play with this feature and while you do, think of all of all of the possible uses for table lineage – what an awesome feature!

 

Key Points

·          The physical data model (PDM) is the logical data model compromised for specific software or hardware.

·          In ER/Studio, the physical data model must be based on an existing logical data model or reverse engineered from an existing database (such as the actual database or a data definition language such as SQL).

·          Denormalization is the process of selectively violating normalization rules and reintroducing redundancy into the model (and therefore, the database).

·          A star schema is when each set of tables that make up a dimension is flattened into a single table.

·          A view is a virtual table. It is a dynamic “view” or window into one or more tables (or other views) where the actual data is stored.

·          An index is a value and a pointer to instances of that value in a table.

·          Partitioning is when a table is split up into two or more tables. Vertical partitioning is when columns are split up and horizontal is when rows are split up.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset