Multidimensional Data Modeling and Intelligent Query Processing for Enhanced Decision Support in Enterprise Data Warehouses
Keywords:
Multidimensional modeling, OLAP, query optimization, decision support systems, enterprise data warehouse, intelligent processing, materialized viewsAbstract
Enterprise Data Warehouses (EDWs) have become pivotal in organizational decision-making, demanding not only robust data integration but also intelligent, efficient query handling. This paper presents a short yet comprehensive investigation into how multidimensional data modeling combined with intelligent query processing techniques such as materialized views, OLAP operations, and semantic optimization can bolster decision support capabilities. A modular framework for query reformation and result prediction is also proposed. Empirical results and visual models illustrate performance improvements in query latency and insight generation.
References
Kimball, R., & Ross, M. (2002). The Data Warehouse Toolkit. Wiley. 2(1)
Inmon, W. H. (2005). Building the Data Warehouse. Prentice Hall. 3(2)
Chaudhuri, S., & Dayal, U. (1997). An Overview of Data Warehousing and OLAP Technology. IEEE TKDE, 9(6)
Sarawagi, S., & Stonebraker, M. (1994). Efficient Organization of Large Multidimensional Databases. VLDB Journal, 3(4)
Bellatreche, L., et al. (2000). Materialized View Selection by Query Clustering in OLAP Environments. DKE, 7(3)
Gupta, A., & Mumick, I. (1999). Maintenance of Materialized Views. ACM Computing Surveys, 5(2)
Widom, J. (1995). Research Problems in Data Warehousing. ICDE, 5(1)
Agrawal, R., et al. (1996). On the Computation of Multidimensional Aggregates. VLDB, 6(4)
Golfarelli, M., Rizzi, S. (1998). Designing the Data Warehouse. DSS Journal, 3(1)
Berson, A., & Smith, S. J. (1997). Data Warehousing, Data Mining & OLAP. McGraw Hill. 2(3)
Han, J., & Kamber, M. (2000). Data Mining: Concepts and Techniques. Morgan Kaufmann. 4(2)
Vassiliadis, P. (1998). Modeling ETL Activities. DOLAP Conference, 5(2)
Shukla, A., Deshpande, P. (2001). Materialized View Selection for Multidimensional Data. SIGMOD Record, 7(1)
Baralis, E., & Widom, J. (1997). Adaptive Query Optimization. VLDB Journal, 4(1)
Golfarelli, M., Rizzi, S. (2009). A Survey on Temporal Data Warehousing. ACM Journal of Data and Information Quality, 6(2)
Wang, X., & Zhou, Y. (2006). Semantic Caching for Query Optimization. ICDE Conference, 5(3)
