This tutorial introduced the development process to build a stable and flexible data model for an insurance data warehouse. The approach used as business templates the industry-specific concepts of the IBM Industry Model for Insurance Information Warehouse (IIW). The modeling itself is accomplished using the data modeling tool Information Data Architect (IDA) with the specific enhancement Enterprise Model Extender (EME). The appropriate design approach is described in the Data Warehousing Development Method (DWDM). You also read special hints about main artifacts of the development process. Understanding the description of the approach and the method prepared you to move through the major phases of this design process.
The method consists in general of four steps that moved from business objects and views to more and more technical objects. After you collected the requirements in phase 1, you built the business model in phase 2. The collection of the business requirements is done in cooperation with the business experts, who need to approve the resulting business model before you can continue the development process. In phases 1 and 2, you used business vocabulary and other EME-specific options of the IDA and EME tool environment. The tutorial explained the structure of these two conceptual models.
In phases 3 and 4, you built the logical data models (also called the enterprise model) from the business model. In phase 3, you built the logical model for the atomic part of the enterprise model, which is a normalized entity relationship (ER) model. In phase 4, you addressed a dimensional logical data model for data marts. This model is de-normalized and optimized for query and analysis performance. The sections that describe phases 3 and 4 offer the most important artifacts of the DWDM method and gave examples of how to customize some of these artifacts. These examples show best practice approaches to solving specific modeling tasks.
By following this clear roadmap of phases, you can deliver robust and stable data models that are also flexible enough to integrate new business requirements in the future.
This tutorial gave you a high-level understanding of Industry Models specifics. In future articles and tutorials on developerWorks, we will describe more about the IBM Industry Models. In particular, we plan to provide more detailed articles and tutorials on each of the four phases in the IIW data model development process with IDA and EME. We also plan to write an article that describes in detail the process of building a physical model out of an existing IIW logical model in the IDA and EME environment.