No, the Inmon methodology does not specifically advocate for dimensional modeling. The Inmon methodology, also known as the "Corporate Information Factory" (CIF) or "Enterprise Data Warehouse" (EDW) approach, is a data warehouse design methodology developed by Bill Inmon. It emphasizes building a centralized, integrated data warehouse that serves as the single source of truth for an organization's data.
In the Inmon methodology, the data warehouse is designed using a normalized relational model. It focuses on capturing and integrating data from various operational systems into a consistent and comprehensive structure. The data is organized into subject-oriented, atomic-level tables that represent the entities and relationships within the organization.
On the other hand, dimensional modeling is a design technique commonly associated with Ralph Kimball's approach to data warehousing, known as the Kimball methodology. Dimensional modeling involves structuring the data warehouse around two primary types of tables: fact tables and dimension tables. Fact tables contain numerical measures or metrics, while dimension tables provide descriptive attributes for analyzing the data. This approach is optimized for query performance and facilitates intuitive data analysis.
While the Inmon methodology does not prescribe the use of dimensional modeling, it does not prohibit it either. In practice, organizations implementing the Inmon methodology may choose to incorporate dimensional modeling techniques within specific sections or data marts of their overall data warehouse architecture. This decision depends on the specific requirements and preferences of the organization.