Hybrid Data Warehouse Development Method
DOI:
https://doi.org/10.32628/CSEIT21752Keywords:
Data Warehouse, Data Warehouse Methodology, Hybrid multi-dimensional Data model.Abstract
Building a data warehouse is a new discipline and has no concrete strategy for its development process. Currently there are three development approaches for building a data warehouse: Data driven. Goal-driven and User-driven. These development approaches are compared on the basis of certain parameters and by this comparison a new Hybrid multidimensional development methodology has been evolved. This Hybrid multi-dimensional Data model is a combination of Data driven methodology with Business driven which is Goal- driven methodology. We have stated in this paper that this model starts by collecting Business requirements and deriving Fact and Dimension tables along with its multiple constraints which defines their relations. After which a logical structure of the model can be built. Which in turn could be developed into a physical model and can be populated by data for Mining and Analysing. This new multidimensional model can be compared on the same parameters which were used to compare the stated three methodologies and thus we can come up with enhanced features.
References
- Franconi E., Introduction to Data Warehousing, Lecture Notes, http://www.inf.unibz.it/~franconi/teaching/2002/cs636/2 ,2002
- W. H. Inmon, “Building the Data Warehouse, 3th Edition”, John Wiley, 2002
- Watson, H., Haley, B.: Managerial Considerations. In Communications of the ACM, Vol. 41, No. 9 (1998)
- List, Beate, et al. "A comparison of data warehouse development methodologies case study of the process warehouse." International Conference on Database and Expert Systems Applications. Springer, Berlin, Heidelberg, 2002.
- Widom, J. Research Problems in Data Warehousing, in Proc. 4th Int. Conf. ‘on Information and Knowledge Management, 1995.
- Kimball, R. The data warehouse toolkit. John Wiley & Sons, 1996.
- McGuff, F. Data modeling for data warehouses. http://members.aol.com/fmcgufYdwmodel/dwmodel.htm, 1996
- Inmon, W. H.: Building the Data Warehouse. Wiley & Sons (1996)
- Golfarelli, M., Maio, D., Rizzi, S.: Conceptual Design of Data Warehouses from E/R Schemes. In: Proceedings of the 31st HICSS, IEEE Press (1998)
- Boehnlein, M., Ulbrich vom Ende, A.: Business Process Oriented Development of Data Warehouse Structures. In: Proceedings of Data Warehousing 2000, Physica Verlag (2000)
- Westerman, P.: Data Warehousing using the Wal-Mart Model, Morgan Kaufmann (2001)
- Poe, V.: Building a Data Warehouse for Decision Support. Prentice Hall (1996)
Downloads
Published
Issue
Section
License
Copyright (c) IJSRCSEIT

This work is licensed under a Creative Commons Attribution 4.0 International License.