Open Access Open Access  Restricted Access Subscription or Fee Access

Comparative Study of Data Warehouse Modeling Techniques

Atef Raslan, Ahmad Saleh

Abstract


The continuous increase in data volume and data sources leads to an urgent need for analyzing this data. Hence the importance of designing a data warehouse model corresponds to the needs of companies and it’s considered as a key element in most of the data Analysis Systems. There are two main approaches in building the DW. The first is the Top-Down approach or the enterprise model for Bill Inmon and the second approach to Kimball which called Bottom-Up approach or the dimensional model. Each one of these approaches is widely used in building DW with some differences in the design.

This paper highlights the difference between the two approaches and proposes recommendations for selecting the proper design.

Keywords


Data Warehouse, Top-Down, Bottom-Up, OLTP, OLAP and Data Mart.

Full Text:

PDF

References


B. Calabrese, “Data cleaning,” Encycl. Bioinforma. Comput. Biol. ABC Bioinforma., vol. 1–3, pp. 472–476, 2018, doi: 10.1016/B978-0-12-809633-8.20458-5.

L. Yessad, “Comparative Study of Data Warehouses Modeling Approaches: Inmon, Kimball and Data Vault,” pp. 95–99, 2016.

J. George, “A Comparative Study of Data Warehouse Architectures: Top Down Vs Bottom Up,” vol. 5, no. 9, pp. 43–46, 2019.

Tanmay Sinha, “OLAP vs. OLTP: What’s the Difference?” 2021. https://www.ibm.com/cloud/blog/olap-vs-oltp

P. Ponniah, Data Extraction, Transformation, and Loading, in Data Warehousing Fundamentals for it Professionals, Second Edition. 2012.

D. P. Du Plessis, “A data warehouse model for quicker and less expensive implementation,” ACM International Conference Proceeding Series. 2020. doi: 10.1145/3415088.3415116.

A. Gutiérrez and A. Marotta, “An Overview of Data Warehouse Design Approaches October 2000,” no. October, 2000.

G. Garani, A. V. Chernov, I. K. Savvas, and M. A. Butakova, “A Data Warehouse Approach for Business Intelligence,” Proc. - 2019 IEEE 28th Int. Conf. Enabling Technol. Infrastruct. Collab. Enterp. WETICE 2019, pp. 70–75, 2019, doi: 10.1109/WETICE.2019.00022.

Q. Yang, M. Ge, and M. Helfert, “Analysis of data warehouse architectures: Modeling and classification,” ICEIS 2019 - Proc. 21st Int. Conf. Enterp. Inf. Syst., vol. 2, pp. 604–611, 2019, doi: 10.5220/0007728006040611.

C. Ballard, D. Herreman, D. Schau, R. Bell, E. Kim, and A. Valencic, “Data Modeling Techniques for Data Warehouse,” Zenithresearch.Org.in, vol. 2, no. 2, pp. 195–196, 2012.

W. O’Connell, “Trends in Data Warehousing,” Proc. 2004 VLDB Conf., vol. 6, no. 8, p. 1224, 2004, doi: 10.1016/b978-012088469-8.50109-1.


Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 License.