Effects of aggregation and data size on query performance and memory requirements of a Data Warehouse

Author

Dubey, Anamika ; Kamal, Arman ; Gupta, S.C.

Author_Institution

Dept. of Electr. Eng., Indian Inst. of Technol. (BHU), Varanasi, India

fYear

2014

fDate

6-8 Feb. 2014

Firstpage

99

Lastpage

104

Abstract

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 Server 2008. 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.

Keywords

SQL; data warehouses; query processing; Microsoft SQL Server 2008; business intelligence development studio; grocery shop data warehouse; large data warehouse; memory requirements; query performance; query response time; red gate data generator tool; Aggregates; Logic gates; Servers; Data Aggregation; Data Warehouse; Dimensional Data Model; Microsoft SQL Server 2008; OLAP System;

fLanguage

English

Publisher

ieee

Conference_Titel

Optimization, Reliabilty, and Information Technology (ICROIT), 2014 International Conference on

Conference_Location

Faridabad

Print_ISBN

978-1-4799-3958-9

Type

conf

DOI

10.1109/ICROIT.2014.6798300

Filename

6798300