Understand and Model Status for Data Warehousing, Business Rules, and Client Relationship Management

Status is a cornerstone of business processes and relationships and yet is rarely understood or modelled correctly.


  • What is status and why is it important?
  • How is it commonly modelled?
  • What we can learn from hierarchy models
  • Modelling temporal data Status Types and their models
  • Applying status models in DW, CRM, Business Rules

Client and account status are natural business concepts that are seldom modelled effectively. The reasons for this are varied, but can be overcome at the start saving effort and resources. Correctly modelled status gives us new, critical information for our Decision Support environment. It ensures accuracy of classifications needed for day to day dealing with our client relationships, enhancing effectiveness in both CRM and Business Rules contexts.

What Attendees will Learn

Learn to correctly model Status. Make your database capture history accurately. Derive data mart measures and facts from situations where none seem apparent. Establish a solid Status model without which it is impossible to know how to apply business rules. Understand and model Status to fully exploit this knowledge in Data Warehousing, Business Rules, and Client Relationship Management.


Henry Feinman is an independent consultant specialising in Systems and Information Architecture and Data Warehousing. He has 22 years of IT experience in Manufacturing, Financial, and Government sectors, working with Mainframe, Client/Server and N-tier implementations. Henry is an IRMAC member and works in the Toronto region.


Henry Feinman, Model Status for Success (zipped pdf)


Oct 16 2002


8:30 am - 11:30 am


The Ontario Club, 5th Floor, Commerce Court South 30 Wellington Street West (Bay and Wellington), Toronto

Leave a Reply

Your email address will not be published.