A Review on Data Warehousing Concepts, Challenges and Applications

Authors

  • Dr. L. C. Manikandan  CSE, Valia Koonambaikulathamma College of Engineering & Technology, Trivandrum, Kerala, India
  • Dr. R. K. Selvakumar  CSE, CVR College of Engineering, Hyderabad, Telungana, India

DOI:

https://doi.org/10.32628/CSEIT239015

Keywords:

Data Warehousing, OLAP Server, OLE-DB, ODBC, ROLAP, JDBC, MOLAP

Abstract

Data warehousing (DW) is a technique for gathering and organizing data from many sources to produce valuable business insights. Business executives can methodically organize, comprehend, and apply their data by adopting data warehousing, which offers structures and tools. This paper's goal is to introduce new learners to the fundamental ideas of DW, as well as its challenges and applications.

References

  1. Vaibhav Singh and Ashwini Ghate,”A Review: Analysis on Data Warehousing and Data Mining”, International Journal for Research & Development in Technology, Vol.8, Issue.1. July 2017.
  2. A.R.Arunachalam and S.Srigowthem,  “A Study on Data Warehouse Architecture”,  International Journal of Pure and Applied Mathematics, Vol.116,  No. 13,  pp.273-275, 2017.
  3. Muhammad Arif, Ghulam Mujtaba, “A Survey: Data Warehouse Architecture”, International Journal of Hybrid Information Technology.  Vol.8, No. 5, pp. 349-356, 2015.
  4. Dishek Mankad and Preyash Dholakia, “The Study on Data Warehouse Design and Usage”, International Journal of Scientific and Research Publications, Vol.3, Issue.3, March 2013.
  5. Jiawei Han, Micheline Kamber and Jian Pei, “Data Mining Concepts and Techniques”, Third Edition, Morgan Kaufmann Publishers is an imprint of Elsevier, 2012.
  6. Song G, Yang D, Lin Z, Tang S, Wang T, Xie K, “Active real time data warehouse concepts, problems and applications”, Journal of Computer Research and Development, 44(suppl.), pp.441-446, 2007.
  7. Mohanty.S.,” Data warehousing design, development and best practice”, New Delhi, Tata McGraw-Hill.
  8. Sandeep Singh and Sona Malhotra, “Data Warehouse and its Methods”, Journal of Global Research in Computer Science, Vol.2, No. 5, May 2011.
  9. Ralph Kimball, Margy Ross, “The Data Warehouse Toolkit”, Wiley Computer Publishing, 2ndedition, pp.79-85, 2002.
  10. Inmon W.H, “Building the Data Warehouse”, John Wiley, 1992.
  11. https://www.javatpoint.com/data-warehouse-architecture

IInternational Journal of Scientific Research in Computer Science, Engineering and Information Technology

Downloads

Published

2023-02-28

Issue

Volume 9, Issue 1, January-February-2023

Section

Research Articles

License

Copyright (c) IJSRCSEIT

Creative Commons License

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

How to Cite

[1]
Dr. L. C. Manikandan, Dr. R. K. Selvakumar, " A Review on Data Warehousing Concepts, Challenges and Applications" International Journal of Scientific Research in Computer Science, Engineering and Information Technology(IJSRCSEIT), ISSN : 2456-3307, Volume 9, Issue 1, pp.25-31, January-February-2023. Available at doi : https://doi.org/10.32628/CSEIT239015