As we have discussed that ETL tools are predominantly used to populate the warehouse. Architects need to create the model of the warehouse, which can be a daunting task if one needs to create it from scratch. So IBM has created some Industry Data Models based on the best practices in various industries. This gives a good starting point for the architects to design the target model. So rather than designing models from the beginning, one can purchase one of the IBM Industry Models in a format that is usable by InfoSphere Data Architect. In this manner, you can jump start the database design phase of the project and benefit from data modeling expertise in the specific industry (Like Retail, Telecom, Banking, Insurance, Health Care etc.).
While in some markets IBM Industry Models have become de facto standards, their purpose is not to standardize at the level of an industry, but to provide the basis for defining corporate standards. So that Standard practice is to scope the industry standard logical model to fit our requirements and build an appropriate data model that combines industry standards with customer specifics. An added advantage of the IBM Industry Models package for InfoSphere Data Architect is that it includes an Industry standard glossary model. This model populates the InfoSphere Business Glossary, complete with relationships (assigned assets) to the InfoSphere Data Architect logical model and generated physical data model.
Each comprehensive industry model contains the following items:
- Business terminology components to define and refine business requirements that improve communication between business and IT
- Business intelligence analysis templates that accelerate the collection of business reporting requirements for a top-down modeling approach
- Data warehouse design components to accelerate building out the database structures that support the business requirements
- Mappings between the business terminology, analysis templates, and design components that accelerate transforming business requirements into database designs
These proven industry model components provide the following benefits:
- Industry-specific content covering a wide range of standard industry business concepts and practices and also coverage of major regulatory requirements
- Extensive content and documented usage methodology to reduce project risk
- Project acceleration through the use of prebuilt models to reduce data modeling effort
Note on IBM InfoSphere Data Architect : IBM InfoSphere Data Architect is an enterprise data modeling and integration design tool. We can use it to discover, model, visualize, relate, and standardize diverse and distributed data assets, including dimensional models.
From a top-down approach, InfoSphere Data Architect can be used to design a logical model and automatically generate a physical data model from the logical source. Data definition language (DDL) scripts can be generated from the data model to create a database schema based on the design of the data model.