Optimizing the Performance of Data Warehouse by Query Cache Mechanism.
C. H. Anwar ul HassanMuhammad HammadMueen UddinJawaid IqbalJawad SahiSaddam HussainSyed Sajid UllahPublished in: IEEE Access (2022)
Keyphrases
- data warehouse
- query execution
- data sources
- olap queries
- query processing
- data warehousing
- bitmap indices
- query workloads
- view selection
- data management
- decision support
- business intelligence
- data mining
- materialized views
- databases
- data cube
- data integration
- data warehouse design
- view maintenance
- database
- query optimization
- response time
- user queries
- aggregate queries
- requirement analysis
- cost model
- on line analytical processing
- data marts
- data partitioning
- query result
- multidimensional data
- data analysis
- query evaluation
- star schema
- multi dimensional
- query plan
- range queries
- data structure
- aggregate views
- metadata
- multidimensional data model
- information sources
- efficient processing
- queries involving
- query rewriting
- fact table
- incremental view maintenance
- efficient query processing