Abstract
In this paper we give a new efficient approach called dynamic bucketing to query and cluster very large data sets, a topic of great theoretical and practical significance. We partition data into equal-width buckets and further partition dense buckets into sub-buckets as needed by efficiently reclaiming and allocating memory space. The bucketing process dynamically adapts to the input order and distribution of input data sets. We propose a new data structure called the structure trees for storing aggregation information such as histograms of the buckets and sub-buckets. Since we only store the count values, the data structure is highly aggregated, concise, and very suitable for data sets with a large number of records. We also provide new query evaluation and data clustering algorithms based on the structure trees. Our simulation results show that our approach is superior to the current leading approaches in terms of the accuracy and performance.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
K. Alsabti, S. Ranka, and V. Singh, “A One-Pass Algorithm Accurately Estimating Quantiles for Disk-Resident Data”, Proc. 23rd VLDB Conference, Athens, Greece, 1997.
Rakesh Agrawal, Arun Swami, “A One-Pass Space-Efficient Algorithm for Finding Quantiles,” Proc. of the Seventh International Conference on Management of Data (COMAD), Prune, India, 1995.
M. Blum, R.W. Floyd, V.R. Pratt, R.L. Rivest, R.E. Tarjan, “Time Bounds for Selection,” JCSS 7, 1973, pp. 448–461.
Tomas Feder, Rajeev Motwani, Rina Panigrahy, Chris Olston, and Jennifer Widom, “Computing the Median with Uncertainty,” Proceedings of the Thirty-second Annual ACM Symposium on Theory of Computing 2000.
Lixin Fu, S. Rajasekran, “Novel Algorithms for Computing Medians and Other Quantiles of Disk-Resident Data,” International Database Engineering & Application Symposium, Grenoble, France, 2001.
J. Gray, S. Chaudhuri, A. Bosworth, A. Layman, D. Reichart, M. Venkatrao, F. Pellow, and H. Pirahesh, “Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals,” Data Mining and Knowledge Discovery, vol. 1, pp. 29–53, 1997.
R. Jain and I. Chlamtac, “The P 2 Algorithm for Dynamic Calculation for Quantiles and Histograms without Storing Observations,” CACM28, 1985, pp. 1076–1085.
J. M. Hellerstein, P. J. Haas, and H. J. Wang. “Online Aggregation,” Proc. ACM SIGMOD International Confon Management of Data, pages 171–182, May 1997.
Ching-Tien Ho, Rakesh Agrawal, Nimrod Megiddo, and Ramakrishnan Srikant, “Range queries in OLAP data cubes,” ACM SIGMOD Record, Proceedings of the ACM SIGMOD international conference on Management of Data. June 1997, Volume 26, Issue 2.
Ching-Tien Ho, Jehoshua Bruck, and Rakesh Agrawal, “Partial-sum queries in OLAP data cubes using covering codes,” Proceedings of the sixteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems, May 1997.
G. S. Manku, S. Rajagopalan, and B. G. Lindsay, “Approaxiate Medians and other Quantiles in One Pass and with Limited Memory”, Proc. ACM SIGMOD Conference, 1998.
J. I. Munro and M. S. Paterson, “Selection and Sorting with Limited Storage”, Theoretical Computer Science, vol. 12, pp. 315–323, 1980.
S. Rajasekaran, “Selection Algorithms for Parallel Disk Systems”, Proc. International Conference on High Performance Computing, 1998. Also to appear in Journal of Parallel and Distributed Computing.
J. S. Vitter and E. A. M. Shriver, “Algorithms for Parallel Memory I: Two-Level Memories”, Algorithmica, 1994.
Yi-Leh Wu, Divyakant Agrawal, and Amr El Abbadi, “Using wavelet decomposition to support progressive and approximate range-sum queries over data cubes,” Proceedings of the ninth international conference on Information knowledge management CIKM 2000. November 2000.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2002 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Fu, L. (2002). Querying and Clustering Very Large Data Sets Using Dynamic Bucketing Approach. In: Meng, X., Su, J., Wang, Y. (eds) Advances in Web-Age Information Management. WAIM 2002. Lecture Notes in Computer Science, vol 2419. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45703-8_26
Download citation
DOI: https://doi.org/10.1007/3-540-45703-8_26
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-44045-1
Online ISBN: 978-3-540-45703-9
eBook Packages: Springer Book Archive