A COMPREHENSIVE SURVEY TO DESIGN EFFICIENT DATA WAREHOUSE FOR BETTERMENT OF DECISION SUPPORT SYSTEMS FOR MANAGEMENT AND BUSINESS CORPORATES

Data warehousing (DWH) is an extensively used and crucial practice in business corporations that support the data analytic and decision-making process. But still there are some corporations based on domains like insurance and life-science which has a richness of data from their business process. But still these corporations lack usage of approaches/process that can handle data effectively, which makes them difficult to take right decision at right time. So, we have done research and study in this area and it was observed that DWH is the approach that can enable corporates to receive and integrate information from heterogeneous data sources and to query very large databases efficiently. After extensive research and study, we have identified 52 relevant papers on DWH and related areas. The purpose of the study is to make clear understanding on building of efficient DWH. We have explored and identified the priority areas of research and the research gaps in this area. The research gaps that have been identified can become a source of opportunities to start new lines of research, which can help to make more efficient DWH