A Methodological Framework for Data Warehouse Design

Abstract

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.

Extracted Key Phrases

4 Figures and Tables

Statistics

0102030'99'01'03'05'07'09'11'13'15'17
Citations per Year

205 Citations

Semantic Scholar estimates that this publication has 205 citations based on the available data.

See our FAQ for additional information.

Cite this paper

@inproceedings{Golfarelli1998AMF, title={A Methodological Framework for Data Warehouse Design}, author={Matteo Golfarelli and Stefano Rizzi}, year={1998} }