Hybrid Data Warehouse Development Method

Authors

  • Pooja D. Kavishwar  Department of Computer Science, Shivaji Science College, Congress Nagar, Nagpur, Maharashtra, India
  • Dr. S. R. Pande  Department of Computer Science, Shivaji Science College, Congress Nagar, Nagpur, Maharashtra, India

DOI:

https://doi.org/10.32628/CSEIT21752

Keywords:

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

  1. Franconi E., Introduction to Data Warehousing, Lecture Notes, http://www.inf.unibz.it/~franconi/teaching/2002/cs636/2 ,2002
  2. W. H. Inmon, “Building the Data Warehouse, 3th Edition”, John Wiley, 2002
  3. Watson, H., Haley, B.: Managerial Considerations. In Communications of the ACM, Vol. 41, No. 9 (1998)
  4. 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.
  5. Widom, J. Research Problems in Data Warehousing, in Proc. 4th Int. Conf. ‘on Information and Knowledge Management, 1995.
  6. Kimball, R. The data warehouse toolkit. John Wiley & Sons, 1996.
  7. McGuff, F. Data modeling for data warehouses. http://members.aol.com/fmcgufYdwmodel/dwmodel.htm, 1996
  8. Inmon, W. H.: Building the Data Warehouse. Wiley & Sons (1996)
  9. Golfarelli, M., Maio, D., Rizzi, S.: Conceptual Design of Data Warehouses from E/R Schemes. In: Proceedings of the 31st HICSS, IEEE Press (1998)
  10. Boehnlein, M., Ulbrich vom Ende, A.: Business Process Oriented Development of Data Warehouse Structures. In: Proceedings of Data Warehousing 2000, Physica Verlag (2000)
  11. Westerman, P.: Data Warehousing using the Wal-Mart Model, Morgan Kaufmann (2001)
  12. Poe, V.: Building a Data Warehouse for Decision Support. Prentice Hall (1996)

Downloads

Published

2021-10-30

Issue

Section

Research Articles

How to Cite

[1]
Pooja D. Kavishwar, Dr. S. R. Pande, " Hybrid Data Warehouse Development Method" International Journal of Scientific Research in Computer Science, Engineering and Information Technology(IJSRCSEIT), ISSN : 2456-3307, Volume 7, Issue 5, pp.09-15, September-October-2021. Available at doi : https://doi.org/10.32628/CSEIT21752