Effects of Aggregation and Data Size on Query Performance and Memory Requirements of a Data Warehouse

Alok Dubey; Archana Kamal; Suresh C. Gupta; IEEE

Conference proceeding

Effects of Aggregation and Data Size on Query Performance and Memory Requirements of a Data Warehouse

Alok Dubey, Archana Kamal, Suresh C. Gupta and IEEE

PROCEEDINGS OF THE 2014 INTERNATIONAL CONFERENCE ON RELIABILTY, OPTIMIZATION, & INFORMATION TECHNOLOGY (ICROIT 2014), pp.99-104

01/01/2014

Abstract

Computer Science

Computer Science, Interdisciplinary Applications

Engineering

Engineering, Electrical & Electronic

Science & Technology

Technology

Aggregation is a key technique to enhance query response time in a large data warehouse. This paper analyzes its effects on query performance and memory requirements. A grocery shop data warehouse has been designed for simulation purpose using Red Gate Data Generator tool along with the Business Intelligence Development Studio of Microsoft SQL Server2008. For a desired performance gain, the requirements on aggregate and its impact on memory usage has been studied. The effects of variation in size of base cube of a Data Warehouse on memory requirement and performance gain have also been analyzed.

Metrics

1 Record Views

Details

Title: Effects of Aggregation and Data Size on Query Performance and Memory Requirements of a Data Warehouse
Creators - without role: Alok Dubey - Indian Institute of Technology BHU
Archana Kamal - Indian Institute of Technology BHU
Suresh C. Gupta - Indian Institute of Technology BHU
IEEE
Publication Details: PROCEEDINGS OF THE 2014 INTERNATIONAL CONFERENCE ON RELIABILTY, OPTIMIZATION, & INFORMATION TECHNOLOGY (ICROIT 2014), pp.99-104
Publisher: IEEE
Number of pages: 6
Identifiers: 9917884908331
Academic Unit: Jazan University
Language: English
Resource Type: Conference proceeding