Scalability analysis of declustering methods for multidimensional range queries

IEEE Transactions on Knowledge and Data Engineering

Volumn 10, Issue 2, 1998, Pages 310-327

  Moon, Bongki ^a   Saltz, Joel H ^a,b  

^a University of Maryland ^*  (United States)

^b IEEE   (United States)

Author keywords

Disk Modulo; Fieldwise Xor; File declustering; Hilbert curve allocation method; Multiattribute access methods; Range query; Scalability

Indexed keywords

COMPUTER SIMULATION; DATA ACQUISITION; DATA STRUCTURES; FILE ORGANIZATION; MULTIPROCESSING SYSTEMS; QUERY LANGUAGES; RESPONSE TIME (COMPUTER SYSTEMS);

FILE DECLUSTERING METHOD; HILBERT CURVE ALLOCATION METHOD; MULTIATTRIBUTE ACCESS METHODS; SCALABILITY ANALYSIS;

DATABASE SYSTEMS;

EID: 0032028309     PISSN: 10414347     EISSN: None     Source Type: Journal    
DOI: 10.1109/69.683759     Document Type: Article

References (46)

1. K.A.S. Abdel-Ghaffar and A. El Abbadi, "Optimal Disk Allocation for Partial Match Queries," ACM Trans. Database Systems, vol. 18, no. 1, pp. 132-156, Mar. 1993.
2. C.K. Baru et al., "DB2 Parallel Edition," IBM Systems J., vol. 34, no. 2, pp. 292-322, Apr. 1995.
3. S. Berson, S. Ghandeharizadeh, R. Muntz, and X. Ju, "Staggered Striping in Multimedia Information Systems," Proc. ACM SIGMOD Conf., pp. 79-90, Minneapolis, Minn., May 1994.
4. H. Boral et al., "Prototyping Bubba, A Highly Parallel Database System," IEEE Trans. Knowledge and Data Eng., vol. 2, no. 1, pp. 4-24, Mar. 1990.
5. F. Carino and P. Kostamaa, "Exegesis of DBC/1012 and P-90 - Industrial Supercomputer Database Machines," Proc. PARLE 92, Parallel Architectures and Languages Europe, Lecture Notes on Computer Science, vol. 605, pp. 877-892, Springer-Verlag, Berlin, 1992.
6. V. Catania, A. Puliafito, S. Riccobene, and L. Vita, "Design and Performance Analysis of a Disk Array System," IEEE Trans. Computers, vol. 44, no. 10, pp. 1,236-1,247, Oct. 1995.
7. C. Chang, B. Moon, A. Acharya, C. Shock, A. Sussman, and J. Saltz, "Titan: A High-Performance Remote-Sensing Database," Technical Report CS-TR-3689 and UMIACS-TR-96-67, Univ. of Maryland, College Park, Md., Sept. 1996.
8. L.T. Chen and D. Rotem, "Declustering Objects for Visualization," Proc. 19th VLDB Conf., pp. 85-96, Dublin, Ireland, 1993.
9. G. Copeland, W. Alexander, E. Boughter, and T. Keller, "Data Placement in Bubba," Proc. ACM SIGMOD Conf., pp. 99-108, Chicago, June 1988.
10. P.F. Corbett and D.G. Feitelson, "Design and Implementation of the Vesta Parallel File System," Proc. SHPCC, Scalable High-Performance Computing Conf., pp. 63-70, Knoxville, Tenn., May 1994.
11. D. DeWitt and J. Gray, "Parallel Database Systems: The Future of High-Performance Database Systems," Comm. ACM, vol. 35, no. 6, pp. 85-98, June 1992.
12. D.J. DeWitt and S. Ghandeharizadeh, D.A. Schneider, A. Bricker, H.-I. Hsiao, and R. Rasmussen, "The Gamma Database Machine Project," IEEE Trans. Knowledge and Data Eng., vol. 2, no. 1, pp. 44-62, Mar. 1990.
13. D.J. DeWitt, M. Smith, and H. Boral, "A Single-User Performance Evaluation of the Teradata Database Machine," Proc. Second Workshop High-Performance Transaction Systems, pp. 245-176, Pacific Grove, Calif., Sept. 1987.
14. "Oracle Parallel Server in the Digital Environment," technical report, Orade, June 1994.
15. H.C. Du and J.S. Sobolewski, "Disk Allocation for Cartesian Product Files on Multiple-Disk Systems," ACM Trans. Database Systems, vol. 7, no. 1, pp. 82-101, Mar. 1982.
16. C. Faloutsos, "Multi-Attribute Hashing Using Gray Codes," Proc. ACM SIGMOD Conf., pp. 227-238, Washington D.C, May 1986.
17. C. Faloutsos and P. Bhagwat, "Declustering Using Fractals," Proc. Second Int'l Conf. Parallel and Distributed Information Systems, pp. 18-25, San Diego, Calif., Jan. 1993.
18. C. Faloutsos and D. Metaxas, "Disk Allocation Methods Using Error Correcting Codes," IEEE Trans. Computers, vol. 40, no. 8, pp. 907-914, Aug. 1991.
19. C. Faloutsos and S. Roseman, "Fractals for Secondary Key Retrieval," Proc. Eighth ACM SIGACT-SIGMOD-SIGART Symp. Principles Database Systems, pp. 247-252, Philadelphia, Mar. 1989.
20. M.T. Fang, R.C.T Lee, and C.C. Chang, "The Idea of De-Clustering and Its Applications," Proc. 12th VLDB Conf., pp. 181-188, Kyoto, Japan, 1986.
21. J.C. French, A.K. Jones, and J.L. Pfaltz, "Summary of the Final Report of the NSF Workshop on Scientific Database Management, SIGMOD Record, vol. 19, no. 4, pp. 32-40, Dec. 1990.
22. G.R. Ganger, B.L. Worthington, R.Y. Hou, and Y.N. Patt, "Disk Arrays: High-Performance, High-Reliability Storage Subsystems," Computer, vol. 27, no. 3, pp. 30-36, Mar. 1994.
23. S. Ghandeharizadeh and D.J. DeWitt, "Hybrid-Range Partitioning Strategy: A New Declustering Strategy for Multiprocessor Database Machines," Proc. 16th VLDB Conf., pp. 481-492, Brisbane, Australia, 1990.
24. S. Ghandeharizadeh, D.J. DeWitt, and W. Qureshi, "A Performance Analysis of Alternative Multi-Attribute Declustering Strategies," Proc. ACM SIGMOD Conf., pp. 195-204, San Diego, Calif., June 1992.
25. "The Tandem Performance Group: A Benchmark of Nonstop SQL on the Debit Credit Transaction," Proc. ACM SIGMOD Conf., pp. 337-341, Chicago, June 1988.
26. A. Guttman, "R-Trees: A Dynamic Index Structure for Spatial Searching," Proc. ACM SIGMOD Conf., pp. 47-57, Boston, June 1984.
27. B. Himatsingka and J. Srivastava, "Performance Evaluation of Grid Based Multi-Attribute Record Declustering Methods," Proc. 10th Int'l Conf. Data Eng., pp. 356-365, Houston, IEEE CS Press, Feb. 1994.
28. J.V. Huber, C.L. Elford, D.A. Reed, A.A. Chien, and D.S. Blumenthal, "PPFS: A High-Performance Portable Parallel File System," Proc. Ninth Int'l Conf. Supercomputing, pp. 385-394, Barcelona, Spain, July 1995.
29. H.V. Jagadish, "Linear Clustering of Objects with Multiple Attributes," Proc. ACM SIGMOD Conf., pp. 332-342, Atlantic City, N.J., May 1990.
30. B.W. Kernighan and S. Lin, "An Efficient Heuristic Procedure for Partitioning Graphs," Bell System Technical J., vol. 49, no. 2, pp. 291-307, Feb. 1970.
31. M.H. Kim and S. Pramanik, "Optimal File Distribution for Partial Match Retrieval," Proc. ACM SIGMOD Conf., pp. 173-182, Chicago, June 1988.
32. M.H. Kim and S. Pramanik, "On the Data Distribution Problems for Range Queries," Proc. Int'l Conf. Parallel Processing, pp. 191-194, Aug. 1989.
33. J. Li, J. Srivastava, and D. Rotem, "CMD: A Multidimensional Declustering Method for Parallel Database Systems," Proc. 18th VLDB Conf., pp. 3-14, Vancouver, B.C., Canada, 1992.
34. W.C. Lin, R.C.T. Lee, and H.C. Du, "Common Properties of Some Multi-Attribute File Systems," IEEE Trans. Software Eng., vol. 5, no. 2, pp. 160-174, Mar. 1979.
35. D.-R. Liu and S. Shekhar, "A Smilarity Graph-Based Approach to Declustering Problems and Its Application Towards Parallelizing Grid Files," Proc. 11th Int'l Conf. Data Eng., pp. 373-381, Taipei, Taiwan, Mar. 1995.
36. R.W. Marx, "The TIGER System: Yesterday, Today, and Tomorrow," Cartography and Geographic Information Systems, vol. 17, no. 1, pp. 89-97, 1990.
37. B. Moon, A. Acharya, and J. Saltz, "Study of Scalable Declustering Algorithms for Parallel Grid Files," Proc. 10th Int'l Parallel Processing Symp., pp. 434-440, Honolulu, Apr. 1996.
38. B. Moon, H.V Jagadish, C. Faloutsos, and J.H. Saltz, "Analysis of the Clustering Properties of Hilbert Space-Filling Curve," Technical Reports CS-TR-3611 and UMIACS-TR-96-20, Univ. of Maryland, College Park, Md., Mar. 1996
39. J. Nievergelt and H. Hinterberger, "The Grid File: An Adaptive, Symmetric Multikey File Structure," ACM Trans. Database Systems, vol. 9, no. 1, pp. 38-71, Mar. 1984.
40. J.A. Orenstein and T.H. Merrett, "A Class of Data Structures for Associative Searching," Proc. Third ACM SIGACT-SIGMOD Symp. Prindples Database Systems, pp. 181-190, Waterloo, Ont., Canada, Apr. 1984.
41. A.L.N. Reddy and P. Banerjee, "An Evaluation of Multiple-Disk I/O Systems," IEEE Trans. Computers, vol. 38, no. 12, pp. 1,680-1,690, Dec. 1989.
42. R.L. Rivest, "Partial Match Retrieval Algorithms," SIAM J. Computing, vol. 5, no. 1, pp. 19-50, Mar. 1976.
43. C.A. Shaffer, H. Samet, and R.C. Nelson, "QUILT: A Geographic Information System Based on Quadtrees," Int'l J. Geographical Information Systems, vol. 4, no. 2, pp. 103-131, 1990.
44. M. Stonebraker, "The Case for Shared Nothing," Quarterly Bulletin, IEEE CS Technical Committee Database Engineering, vol. 9, no. 1, pp. 4-9, Mar. 1986.
45. M. Stonebraker, "Sequoia 2000: A Reflection on the First Three Years," IEEE Computational Science and Eng., pp. 63-72, Winter 1994.
46. Y.Y. Sung, "Performance Analysis of Disk Modulo Allocation Method for Cartesian Product Files," IEEE Trans. Software Eng., vol. 13, no. 9, pp. 1,018-1,026, Sept. 1987.