Methodological Framework for Data Warehouse Design

13 years 10 months ago
Methodological Framework for Data Warehouse Design
Though designing a data warehouse requires techniques completely different from those adopted for operational systems, no significant effort has been made so far to develop a complete and consistent design methodology for data warehouses. In this paper we outline a general methodological framework for data warehouse design, based on our Dimensional Fact Model (DFM). After analyzing the existing information system and collecting the user requirements, conceptual design is carried out semi-automatically starting from the operational database scheme. A workload is then characterized in terms of data volumes and expected queries, to be used as the input of the logical and physical design phases whose output is the final scheme for the data warehouse. Keywords Data warehouse, design methodology, conceptual model.
Matteo Golfarelli, Stefano Rizzi
Added 05 Aug 2010
Updated 05 Aug 2010
Type Conference
Year 1998
Authors Matteo Golfarelli, Stefano Rizzi
Comments (0)