Title :
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
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;
Conference_Titel :
Optimization, Reliabilty, and Information Technology (ICROIT), 2014 International Conference on
Conference_Location :
Faridabad
Print_ISBN :
978-1-4799-3958-9
DOI :
10.1109/ICROIT.2014.6798300
