Architecture Data models enterprise data models data warehouse models industry data models generic data models best practice data models Erwin Allfusion data models HP Oracle EDS

The ADRM Architecture consists of:

> 3-level data model architecture
> Industry best-practices content
> Comprehensive design, attribution and definitions

For each industry, an Enterprise Model consisting of approximately 350 entities and 2,500 attributes is developed with complete definitions, attribution and data relationships that are representative of a best-of-breed company in that industry.

Detailed Business Area Models providing more detail are constructed from a selected core of entities from the Enterprise Model. Business Area Models provide the comprehensive coverage of the subject that is addressed as an integrated 'thumbnail' of data in the Enterprise Model.

Business Area Models provide the comprehensive coverage and granularity of data for development of applications and data marts. They also provide the framework of reference data for design of the data warehouse.

The Data Warehouse and Data Mart models are derived from the Enterprise and Business Area Models in either 3NF or star schema format. This overall top-down data architecture facilitates several different potential design alternatives:

> Single data warehouse design
> Data warehouse feeding individual data marts
> Data marts in conjunction with a data warehouse

Since the models have a common data architecture based upon common entities, they can be easily integrated with other industry models or used to build additional business area or application models.

A top-down data architecture based upon common data elements insures that data can be applied consistently across the entire organization regardless of requirements.

The ADRM development approach has proven to dramatically cut development time, increase productivity, reduce costs and provide the benefits of a comprehensive modeling effort at greatly reduced cost.

"ADRM Vertical Industry Data Models"
(212KB pdf)