TDWI Advanced Data Modeling Techniques

A session at TDWI 2011 Europe Amsterdam

  • Jonathan G. Geiger

Tuesday 15th November, 2011

9:30am to 4:30pm (AMT)

Whether you are a business data modeler who represents data requirements as entities and relationships, or a physical data modeler more concerned with tables, columns, and indexes, you know that the hard stuff lies beneath the surface. Every data design, whether logical or technical, is challenged by one or more complex considerations-scalability, adaptability, performance, legacy and package databases, etc. Every data model raises questions. Advanced modeling techniques provide many of the answers.

Prerequisite: This course assumes completion of the course TDWI Data Modeling: Data Analysis and Design for BI and Data Warehousing Systems or equivalent understanding of entity-relationship modeling, dimensional modeling, and DW terms and concepts.

You Will Learn
When, where, and how to apply advanced modeling techniques, including:

Normalization and denormalization
Abstraction, patterns, and universal models
Generalization, specialization, and inheritance
Time and time dependency in the data model
States and state dependency in the data model
Recursion for lists, trees, and networks
Complementary models-process, state-transition, use cases, and event maps
Advanced indexing and outer join optimization
Data model validation and testing

Geared To

Data modelers with some practical experience
data architects
database developers

About the speaker

This person is speaking at this event.
Jonathan G. Geiger

Sign in to add slides, notes or videos to this session

Tell your friends!

View the schedule


See something wrong?

Report an issue with this session