Arseam

International Journal of Advances in Engineering & Scientific Research

DATA WAREHOUSE APPLICATIONS: A COMPREHENSIVE SURVEY

Monika Juneja

Assistant Professor, Department of Computer Science, Guru Nanak College, Sri Muktsar Sahib, Punjab, India,

ORCID: https://orcid.org/0000-0003-4742-1307

DOI : https://doi.org/10.5281/zenodo.7633088 Page No : 01-26

Published Online : 2022-12-30

Download Full Article : PDF Check for Updates

ABSTRACT

Aim of the Study: of Data warehouse in different Application Areas

Design / Methodology: More than 60 articles have been studied in the field of data warehouse with different keywords as applications of data warehouse, architecture of data warehouse and usage of data warehouse. The articles are searched from Google scholar search engine. Textual search is carried out to figure out the results.

Findings: Data Warehouse has provided a great support in many organizations by managing data from different sources. It structures information and helps organization in taking effective and efficient decisions.

Practical Implications: It is highly used technology as with the introduction of big data huge amount of information is generated on the daily basis and also data warehouse presents the information in highly organized, clean and integrated form as per the need of time. Organizations have huge amount of information and also all data is in different formats but it is difficult to take decision as it is not in the organized form and data warehouse helps in providing quality data which helps all organizations to further progress. All organizations either government or non-government can get benefit from it.

Originality/ Value: Study of different authors research work done by them is analyzed in a detailed level relevant to our usage of data warehouse and its applications. Information generated in the paper is highly accurate and reliable.

Keywords: Data warehouse, Decision Making, Information, Knowledge base, Architecture

Paper Type: Review Paper

REFERENCES

Abai, Zulkifli,Hani,Nur; et al., (2013), “User Requirement Analysis in Data Warehouse Design: A Review”, The 4th International Conference on Electrical Engineering and Informatics (ICEEI), Procedia Technology 11, pp. 801-806.doi: https://doi.org/10.1016/j.protcy.2013.12.261

Ahmad, Haji, Bt, Azizah; et al., (2016), “From Data Warehouse to Big Data: E-Government Initiatives”, IJISET - International Journal of Innovative Science, Engineering & Technology, Vol. 3 Issue 8, pp. 363-371.Retrieved from:https://ijiset.com/vol3/v3s8/IJISET_V3_I8_50.pdf

Brum,Luz,da,Moraes,Luciano; et al.,(2019), “Business Intelligence and Data Warehouse in Agrarian Sector: A Bibliometric Study”, Journal of Agricultural Science; Vol. 11, No. 2, pp. 353-368.doi: https://doi.org/10.5539/jas.v11n2p353

Bouaziz, Senda.,Nabli, Ahlem.;Gargouri,Faiez.,(2017), “From Traditional Data Warehouse to Real Time Data Warehouse”,doi: http://dx.doi.org/10.1007/978-3-319-53480-0_46

Bogojevic, P.,(2020), “Project Management in Data Warehouse Implementations: A Literature Review”,.https://doi.org/10.1109/ACCESS.2020.3045072

Chau, K, W; et al., (2002), “Application of Data Warehouse and Decision Support System in Construction Management”, Automation in Construction, Vol. 12, No. 2, pp. 213-224.doi: https://doi.org/10.1016/S0926-5805(02)00087-0

Dr. Jha, Rohini; (2020), “Review of Data Mining and Data Warehousing Implementation in E-Governance”, International Journal of Innovative Science and Research Technology”, Volume 5, Issue 10, pp. 18-28.Retrieved from:https://ijisrt.com/assets/upload/files/IJISRT20OCT033.pdf

D. Ahmed; et al., (2021), “Knowledge Management in Startups and SMEs: A Systematic Review”, https://www.researchgate.net/publication/350107567, pp.389-409.doi: http://dx.doi.org/10.1007/978-3-030-64987-6_22

Dabas,Abhishek; et al.,(2013), “Impact of Data Warehouse in Decision Making Process”, International Journal of Science and Research (IJSR), Volume 4 Issue 6, pp. 788-789.Retrieved from:https://www.ijsr.net/archive/v4i6/SUB155267.pdf

EstiyanDwipriyoko; et al., (2021),”Wireless Scoreboard Technology Architecture for Athlete Performance Data Warehouse at Multiple Table Sports Games”, Journal of Physics: Conference Series,doi:http://dx.doi.org/10.1088/1742-6596/1764/1/012058

Goyal, Monika; et al., (2012), “Applications of Data Mining in Higher Education”, IJCSI International Journal of Computer Science Issues, Vol. 9, Issue 2, No 1, pp. 113-120.Retrieved from: https://www.proquest.com/openview/3c36474b5814da46aa7331a36df77893/1?pq-origsite=gscholar&cbl=55228

Gosain, Anjana; Heena, (2015), “Literature Review of Data model Quality metrics of Data Warehouse”, International Conference on Intelligent Computing, Communication &Convergence,Procedia Computer Science 48, pp.236 – 243. doi: https://doi.org/10.1016/j.procs.2015.04.176

Gupta,Abhishek; Sahayadhas, Arun; (2020), “A Comprehensive Survey to Design Efficient Data Warehouse for Betterment of Decision Support Systems for Management and Business Corporates”, International Journal of Management (IJM) Volume 11, Issue 7, pp.463-471.Retrieved from:https://sdbindex.com/Documents/index/00000011/00000-00364

Hamoud, Khalaf, Alaa, Alaa, et al.,(2018), “Clinical data warehouse: a review”, Iraqi Journal for Computers and Informatics, Vol. [44], Issue [2], pp.1-11.doi: http://dx.doi.org/10.25195/2017/4424

Hassan, Ahmad., (2021), “Review of industries need to depend on data warehouse for decision making and taking benefit from IT”, pp.1-10 https://www.researchgate.net/publication/352329611.

Intrapairot; et al., (1998), “Adoption and diffusion of data warehousing technology: A system dynamics approach”, Jour, https://www.researchgate.net/publication/229052984, pp. 1-11. Retrieved from: https://proceedings.systemdynamics.org/1998/PROCEED/00000.PDF

Koshiya, B, Kruti; (2017), “Review on Data Warehouse: As Prerequisite Aspect of Business Decision Making Activity”, IJSRD - International Journal for Scientific Research & Development| Vol. 4, Issue 11, pp. 681-683.Retrieved from:https://ijsrd.com/Article.php?manuscript=IJSRDV4I110306

Kusiak, A; et al.,(2006), “Data Mining in Manufacturing: A Review”, Journal of Manufacturing Science and Engineering, Volume 128, pp. 969-976.doi: https://doi.org/10.1115/1.2194554

Kauppi; et al.,(2013), “Should we try out for the major leagues? A call for research in sport operations management”, International Journal of Operations & Production Management, Vol. 33 No. 10,Retrieved from:https://www.emerald.com/insight/content/doi/10.1108/IJOPM-11-2011-0418/full/html

Khnaisser, C; Lavoie, L; Diab, H;Ethier, JF; (2015), “Data Warehouse Design Methods Review: Trends, Challenges and Future Directions for the Healthcare Domain”, New Trends in Databases and Information Systems, ADBIS, Communications in Computer and Information Science, vol 539. Springer, Cham.doi: http://dx.doi.org/10.1007/978-3-319-23201-0_10

Moalla,Imen; et al.,(2017), “Data warehouse design approaches from social media: review and comparison”, Soc. Netw. Anal. Min,doi: http://dx.doi.org/10.1007%2Fs13278-017-0423-8

Mirabedini, Shirin; (2014), “The Role of Data warehousing in Educational Data Analysis”, Journal of Novel Applied Sciences, 3(5), pp. 1439-1445.Retrieved from:https://jnasci.org/wp-content/uploads/2014/12/1439-1445.pdf

Nave, M; et al., (2018), “A Decision Support System Framework to Track Consumer Sentiments in Social Media”, Journal of Hospitality Marketing and Management. 27 (6),doi: http://dx.doi.org/10.1080/19368623.2018.1435327

Onut S; et al., (2008), “Customer Relationship Management in Banking Sector and A Model Design for Banking Performance Enhancement”, Unifying Themes in Complex Systems IV,Retrieved from:https://link.springer.com/chapter/10.1007/978-3-540-73849-7_41

Pramudianto, F; et al., (2016), “Peer Review Data Warehouse: Insights from Different Systems”, EDM, pp.1-5.Retrieved from:https://citeseerx.ist.psu.edu/document?repid=rep1&type=pdf&doi=69f3b063be52915b9ff8ed1ae187fb3d59e93ddc

Pablo C. de; et al; (2021), “Proposal of a Data Warehouse for Scholarly Institutions built on Institutional Repositories”, Retrieved from:https://repositoriosdigitales.mincyt.gob.ar/vufind/Record/SEDICI_29f2469dd413cb694497dff9d7ff9f37

Pushpam, Amali, C; et al.,(2017), “Overview on Data Mining in Social Media”, International Journal of Computer Sciences and Engineering, Vol.5(11),. doi: http://dx.doi.org/10.26438/ijcse/v5i11.147157

Rao, G; et al., (2011), “Framework to integrate business intelligence and knowledge management in banking industry”, Review of Business and Technology Research Vol. 4, No. 1, pp.1-14.doi: https://doi.org/10.48550/arXiv.1109.0614

Rasheed, Umair; Sarwar, M.; RamzanTalib, (2014), “A Review on Data Warehouse Management”, International Journal of Engineering Sciences & Research Technology, pp.1247-1251.Retrieved from:https://www.academia.edu/6591423/A_Review_on_Data_Warehouse_Management

Rizvi, Ali, Sayed.; Kushwaha, Pradeep.,(2021), “How Data Warehouse and ETL Process Overcome the Storage of Heterogeneous Data and Play an Important Role in Decision Making”, International Journal of Advanced Research in Science, Communication and Technology (IJARSCT),Volume 7, Issue 1, pp100-104.doi: https://ijarsct.co.in/A1614.pdf

Ramadhan, A. F; Jaafar, N.I;Tajudeen, F. P., (2021), “Data governance and its scientific outlook in Indonesia: A literature review”, Journal of Management Information and Decision Sciences, 24(3), pp. 1-10.Retrieved from:https://www.abacademies.org/articles/data-governance-and-its-scientific-outlook-in-indonesia-a-literature-review-10334.html

Schubart, JR;Einbinder, JS; (2000),“Evaluation of a data warehouse in an academic health sciences center”, Int J Med Inform,60(3),doi: https://doi.org/10.1016/S1386-5056(00)00126-X

Solodovnikova, D.; Niedrite, L. and Svilpe, L. (2021), “Managing Evolution of Heterogeneous Data Sources of a Data Warehouse”, International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-758-509-8; ISSN 2184-4992, pp 105-117.doi: http://dx.doi.org/10.5220/0010496601050117

Shahid,Bilal,Muhammad; et al., (2016), “Application of Data Warehouse in Real Life: State-ofthe-art Survey from Us”, (IJACSA) International Journal of Advanced Computer Science and Applications, Vol. 7, No. 4, pp.415-426.

Sachin, Chaudhary; et al.,(2011), “A Critical Review of Data Warehouse”, Global Journal of Business Management and Information Technology, Volume 1, Number 2 (2011), pp. 95-103.Retrieved from:https://www.apiit.edu.in/downloads/all%20chapters/CHAPTER-104.pdf

Santoso, Willyanto, Leo; Yulia, (2017), “Data Warehouse with Big Data Technology for Higher Education”, 4th Information Systems International Conference, ISICO, Bali, Indonesia, Procedia Computer Science 124, pp. 93-99. doi: https://doi.org/10.1016/j.procs.2017.12.134

Stolba N., List B. ,(2005), “Extending the Data Warehouse with Company External Data from Competitors' Websites — A Case Study in the Banking Sector”, In: Schelp J., Winter R. (eds) Auf demWegzur Integration Factory. Physica-Verlag HD, https://doi.org/10.1007/3-7908-1612-4_14, pp. 277-293. Retrieved from:https://www.springerprofessional.de/en/extending-the-data-warehouse-with-company-external-data-from-com/1406598

Vuong, M, Ngo; et al., (2018), “An Efficient Data Warehouse for Crop Yield Prediction”, 14th International Conference on Precision Agriculture, Montreal, Quebec, Canada, pp.1-14.doi: https://doi.org/10.48550/arXiv.1807.00035

Wongthongtham, P.; et al.,(2015), “Ontology and trust-based data warehouse in new generation of business intelligence: State-of-the-art, challenges, and opportunities”, IEEE 13th International Conference on Industrial Informatics (INDIN),doi: http://doi.org/10.1109/INDIN.2015.7281780

Wisniewski, F, Mary; et al., (2003), “Development of a Clinical Data Warehouse for Hospital Infection Control”, Journal of the American Medical Informatics Association Volume 10 Number 5, pp. 454-462.doi: http://dx.doi.org/10.1197/jamia.M1299

Xiaobing Yu.,(2021), “The Application of Data Warehouse in Teaching Management in Colleges and Universities”, Journal of Physics: Conference Series, doi:10.1088/1742-6596/1738/1/012090, pp.1-7.doi: http://dx.doi.org/10.1088/1742-6596/1738/1/012090

Xu, Wei; et al., (2020), “Analyzing social media data and performance comparison with traditional database, data warehouse, and MapReduce approaches”, Creative Components, https://lib.dr.iastate.edu/creativecomponents/568, pp. 1-44.Retrieved from:https://dr.lib.iastate.edu/handle/20.500.12876/17142/

Yan et al., (2015), “The Research on Sports Training Aids System Based on Data Warehouse Technology”, 4th National Conference on Electrical, Electronics and Computer Engineering (NCEECE), pp.1670-1674.doi: https://dx.doi.org/10.2991/nceece-15.2016.302

CITE THIS ARTICLE AS: Juneja M (2022), “Data Warehouse Applications: A Comprehensive Survey”, International Journal of Advances in Engineering & Scientific Research, Volume 9, Issue 1, 2022, pp 01-26 , DOI : https://doi.org/10.5281/zenodo.7633088

Article View: 244
PDF Download: 57

REFERENCES

Bouaziz, Senda.,Nabli, Ahlem.;Gargouri,Faiez.,(2017), “From Traditional Data Warehouse to Real Time Data Warehouse”,doi: http://dx.doi.org/10.1007/978-3-319-53480-0_46

Bogojevic, P.,(2020), “Project Management in Data Warehouse Implementations: A Literature Review”,.https://doi.org/10.1109/ACCESS.2020.3045072

Hassan, Ahmad., (2021), “Review of industries need to depend on data warehouse for decision making and taking benefit from IT”, pp.1-10 https://www.researchgate.net/publication/352329611.

Kusiak, A; et al.,(2006), “Data Mining in Manufacturing: A Review”, Journal of Manufacturing Science and Engineering, Volume 128, pp. 969-976.doi: https://doi.org/10.1115/1.2194554

Moalla,Imen; et al.,(2017), “Data warehouse design approaches from social media: review and comparison”, Soc. Netw. Anal. Min,doi: http://dx.doi.org/10.1007%2Fs13278-017-0423-8

Schubart, JR;Einbinder, JS; (2000),“Evaluation of a data warehouse in an academic health sciences center”, Int J Med Inform,60(3),doi: https://doi.org/10.1016/S1386-5056(00)00126-X

Submission Instruction

Call for Paper

Submit Paper Online

Join Editorial Board

Author Guidelines

Indexed in

DATA WAREHOUSE APPLICATIONS: A COMPREHENSIVE SURVEY

Aims and Objectives

Ethics Policy

Peer Review Policy

Call for Paper

Conference

Instruction To Review

Guide To Authors