AM8: Data Modeling Masterclass
Share this Session:
  Graham Witt   Graham C Witt
Associate Director


Monday, April 29, 2013
08:30 AM - 11:45 AM

Level:  Intermediate

This masterclass covers the following topics:

1. The data modelling process

  • Why do data modelling?
  • Getting the vocabulary right
  • Conceptual, logical & physical data models
    - How do they differ?
    - Conceptual data model characteristics
    - Converting a conceptual data model to a logical data model
  • Data model review
  • Managing model change
  • Data naming standards
  • Data model quality criteria
2. Generalisation:
  • What is generalisation?
  • Entity generalisation
  • Attribute generalisation
  • Relationship generalisation
  • Supertypes and subtypes
  • Implementing subtypes
  • Roles
  • Recursive relationships: hierarchies, taxonomies, etc
3. Modelling for rules:
  • What is a (business) rule?
  • Types of rules
  • Discovering and verifying rules
  • Documenting rules
  • Implementing rules
  • Some specialized rule types
4. The time dimension:
  • Things to consider when recording time
  • Time variance: recording change
    - Bi-temporal data
  • Temporal rules and constraints
  • The impact of time on rules

Graham has over 30 years of experience in assisting organizations to acquire relevant and effective IT solutions. Clients include the NSW Land & Property Management Authority, Sydney Water, the Australian Securities & Investments Commission, and NSW WorkCover. He has developed specialist expertise in business requirements, architectures, information management, user interface design, data modelling, relational database design, data quality, business rules and the use of metadata repositories & CASE tools. He has provided data modelling and business rules training to clients including banks, utilities, and government in Australia and North America. He co-authored the textbook "Data Modeling Essentials" with Graeme Simsion, and has presented at conferences in Australia, the US, the UK and France. He is currently writing a series of articles on natural language business rule statement development for the Business Rule Community website at and has just had a new book published by Elsevier: "Writing Effective Business Rules".

Close Window