Abstract
With the increasing emphasis on data warehouse systems, the efficiency of complex analytical queries in such systems has become an important issue. Such queries posed challenging performance problems that initiated the use of parallel database systems and parallel algorithms in data warehouse environments. Many of these have been proposed in recent years but a review of the literature to our knowledge has not revealed any literature describing parallel methods with detailed cost models for aggregate data cube queries in a data warehouse environment. This paper presents a detailed cost model based on parallel methods for aggregate data cube queries. The detailed cost model enables us to study the behaviour and evaluate the performance of the three methods and thus identify the efficient parallel methods for aggregate data cube queries.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Acharya, S., Gibbons, P.B., Poosala, V., Ramaswarmy, S.: Join Synopses for Approximate Query Answering. In: Proceedings of ACM SIGMOD International Conference on Management of Data, pp. 275–286 (1999)
Chan, C.Y., Ioannidis, Y.E.: Hierarchical Cubes for Range_Sum Queries. In: Proceedings of International Conference on VLDB, Edinburgh, Scotland, September 1999, pp. 675–686 (1999)
Chaudhuri, S., Das, G., Datar, M., Motwani, R., Narasayya, V.: Overcoming Limitations of Sampling for Aggregation Queries. In: Proceedings of 17th International Conference on Data Engineering, Heidelberg, Germany (2001)
Datta, A., Moon, B.: A case for parallelism in data warehousing and OLAP. In: Proceedings of 9th International Workshop on Database Systems Applications (1998)
Goil, S., Choudhary, A.: Design and implementation of a scalable parallel system for multidimensional analysis and OLAP. In: 13th International and 10th Symposium on Parallel and Distributed Processing, IPPS/SPDP Proceedings, pp. 576–581 (1999)
Martens, H., Rahm, E., Stohr, T.: Dynamic Query Scheduling in Parallel Data Warehouses. In: Proceedings of 8th International conference on Euro-Par, Paderborn, Germany, pp. 321–331 (2002)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Tan, R.BN., Taniar, D., Lu, G. (2003). Efficient Execution of Parallel Aggregate Data Cube Queries in Data Warehouse Environments. In: Liu, J., Cheung, Ym., Yin, H. (eds) Intelligent Data Engineering and Automated Learning. IDEAL 2003. Lecture Notes in Computer Science, vol 2690. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-45080-1_95
Download citation
DOI: https://doi.org/10.1007/978-3-540-45080-1_95
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-40550-4
Online ISBN: 978-3-540-45080-1
eBook Packages: Springer Book Archive