Application of Data Warehouse in Real Life: State-of-the-art Survey from User Preferences’ Perspective

In recent years, due to increase in data complexity and manageability issues, data warehousing has attracted a great deal of interest in real life applications especially in business, finance, healthcare and industries. As the importance of retrieving the information from knowledge-base cannot be denied, data warehousing is all about making the information available for decision making. Data warehouse is accepted as the heart of the latest decision support systems. Due to the eagerness of data warehouse in real life, the need for the design and implementation of data warehouse in different applications is becoming crucial. Information from operational data sources are integrated by data warehousing into a central repository to start the process of analysis and mining of integrated information and primarily used in strategic decision making by means of online analytical processing techniques (OLAP). Despite the applications of data warehousing techniques in number of areas, there is no comprehensive literature review for it. This survey paper is an effort to present the applications of data warehouse in real life. It focuses to help the scholars knowing the analysis of data warehouse applications in number of domains. This survey provides applications, case studies and analysis of data warehouse used in various domains based on user preferences.

@article{Shahid2016,
  title     = {Application of Data Warehouse in Real Life: State-of-the-art Survey from User Preferences’ Perspective},
  journal   = {International Journal of Advanced Computer Science and Applications},
  volume    = {7},
  number    = {4},
  year      = {2016},
  publisher = {The Science and Information Organization},
  author    = {Muhammad Bilal Shahid and Umber Sheikh and Basit Raza and Qaisar Javaid},
  doi       = {10.14569/IJACSA.2016.070455},
  url       = {https://doi.org/10.14569/IJACSA.2016.070455}
}