Multidimensional Data Modeling and Intelligent Query Processing for Enhanced Decision Support in Enterprise Data Warehouses
Abstract
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.
Keywords
Document Preview
Details