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

dc.contributor.author	Dubey A.; Kamal A.; Gupta S.C.
dc.date.accessioned	2025-05-24T09:20:54Z
dc.description.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. © 2014 IEEE.
dc.identifier.doi	https://doi.org/10.1109/ICROIT.2014.6798300
dc.identifier.uri	http://172.23.0.11:4000/handle/123456789/14548
dc.relation.ispartofseries	ICROIT 2014 - Proceedings of the 2014 International Conference on Reliability, Optimization and Information Technology
dc.title	Effects of aggregation and data size on query performance and memory requirements of a Data Warehouse

Collections