On-site & Public, Instructor-led, Hands-on IT Training
(International 01) 908.233.8900
  400+ Course Offerings:

Search for Course:

DW1015 Advanced Data Modeling
Duration4 Days
Delivery MethodInstructor Led, Hands-on Workshops
Public Price$1950.00

DESCRIPTION (Return to Top)

This workshop addresses all of the issues that trouble the experienced practicing data modeler:

  • How far to abstract in the data model
  • How to deal with time and history
  • How to deal with complex business rules, how to represent entity life histories
  • How to interrelate data and process models
  • How to reconcile data modeling concepts with object oriented concepts.

This is a workshop and relies on realistic exercises. You will learn how to apply leading edge data modeling principles to practical and difficult modeling situations. All of the exercises have been derived from real modeling situations.

This workshop emphasizes three things: 1. analysis of business rules to develop detailed understanding of the business; 2. expression of these in the data model; and 3. the use of these to verify the entity model. The entity model must support process requirements, editing and validation constraints, and time considerations.

Two types of business rules are distinguished: static rules that are represented in associations among entities; and dynamic rules which represent processing requirements. Non-procedural techniques for expressing rules, triggers, and automatic actions are examined.

The workshop focuses especially on comprehensive transaction discovery, complex event histories, state transition and time dependent constraints. The concepts of entity life cycle and compatible conventions for their specifications are introduced. So too are various entity abstraction techniques. As much as possible business rules are expressed against the minimal piece of data to which they are applicable. This provides a leading-edge basis for object-based application analysis and database systems development.

AUDIENCE (Return to Top)

Data analysts, data administrator, database designers, system analysts and designers, and other practicing data modelers.

TOPICS (Return to Top)
  • Review of Data Modeling
  • Business Rules
  • Creating Data Views
  • Modeling Time and Change
  • Abstraction in Data Modeling
  • Inheritance Rules
  • Flexibility in Models
  • Different Kinds of Relationships
  • Entity Life Histories
  • Process Discovery Methods
  • Model Reconciliation
  • Object Orientation Review
  • Data Design Compromises
  • Summary and Conclusion