Adaptive index utilization in memory-resident structural joins

IEEE Transactions on Knowledge and Data Engineering

Volumn 19, Issue 6, 2007, Pages 772-788

  He, Bingsheng ^a   Luo, Qiong ^a   Choi, Byron ^b  

^a HONG KONG UNIVERSITY OF SCIENCE AND TECHNOLOGY   (Hong Kong)

^b NANYANG TECHNOLOGICAL UNIVERSITY   (Singapore)

Author keywords

Adaptive query processing; Index utilization; Memory resident systems; Structural joins

Indexed keywords

ADAPTIVE ALGORITHMS; ADAPTIVE SYSTEMS; DATABASE SYSTEMS; INDEXING (OF INFORMATION); PROBLEM SOLVING; QUERY PROCESSING; XML;

ADAPTIVE QUERY PROCESSING; INDEX UTILIZATION; MEMORY RESIDENT SYSTEMS; STRUCTURAL JOINS;

DATA STORAGE EQUIPMENT;

EID: 34247615159     PISSN: 10414347     EISSN: None     Source Type: Journal    
DOI: 10.1109/TKDE.2007.190616     Document Type: Article

References (37)

1. IA-32 Intel Architecture Optimization Reference Manual, ftp://download.intel.com/design/Pentium4/manuals/24896611.pdf, 2006.
2. S. Al-Khalifa, H. Jagadish, N. Koudas, J. Patel, D. Srivastava, and Y. Wu, "Structural Joins: A Primitive for Efficient XML Query Pattern Matching," Proc. 18th Int'l Conf. Data Eng. (ICDE '02), 2002.
3. G. Antoshenkov, "Query Processing in DEC Rdb: Major Issues and Future Challenges," IEEE Data Eng. Bull., vol. 16, no. 4, pp. 42-52, 1993.
4. G. Antoshenkov, "Dynamic Optimization of Index Scans Restricted by Booleans," Proc. 12th Int'l Conf. Data Eng. (ICDE '96), 1996.
5. G. Antoshenkov and M. Ziauddin, "Query Processing and Optimization in Oracle RDB," VLDB J., vol. 5, no. 4, pp. 229-237, 1996.
6. R. Avnur and J.M. Hellerstein, "Eddies: Continuously Adaptive Query Processing," Proc. ACM SIGMOD Int'l Conf. Management of Data (SIGMOD '00), 2000.
7. S. Babu and P. Bizarro, "Adaptive Query Processing in the Looking Glass," Proc. Second Biennial Conf. Innovative Data Systems Research (CIDR '05), 2005.
8. R. Berrendorf, H. Ziegler, and B. Mohr, "PCL: Performance Counter Library," http://www.fz-juelich.de/zam/PCL/, 2006.
9. P. Bohannon, P. McIlroy, and R. Rastogi, "Main-Memory Index Structures with Fixed-Size Partial Keys," Proc. ACM SIGMOD Int'l Conf. Management of Data (SIGMOD '01), 2001.
10. N. Bruno, N. Koudas, and D. Srivastava, "Holistic Twig Joins: Optimal XML Pattern Matching," Proc. ACM SIGMOD Int'l Conf. Management of Data (SIGMOD '02), 2002.
11. S. Chen, P.B. Gibbons, and T.C. Mowry, "Improving Index Performance through Prefetching," Proc. ACM SIGMOD Int'l Conf. Management of Data (SIGMOD '01), 2001.
12. 2 Stack: Bottom-Up Processing of Generalized Tree Pattern Queries over XML Documents," Proc. 32nd Int'l Conf. Very Large Data Bases (VLDB '06), 2006.
13. T. Chen, J. Lu, and T.W. Ling, "On Boosting Holism in XML Twig Pattern Matching Using Structural Indexing Techniques," Proc. ACM SIGMOD Int'l Conf. Management of Data (SIGMOD '05), 2005.
14. J.M. Cheng, D.J. Haderle, R. Hedges, B.R. Iyer, T. Messinger, C. Mohan, and Y. Wang, "An Efficient Hybrid Join Algorithm: A DB2 Prototype," Proc. Seventh Int'l Conf. Data Eng. (ICDE '91), 1991.
15. S.-Y. Chien, V.J. Tsotras, C. Zaniolo, and D. Zhang, "Efficient Structural Joins on Indexed XML Documents," Proc. 28th Int'l Conf. Very Large Data Bases (VLDB '02), 2002.
16. D. Comer, "Ubiquitous B-Tree," ACM Computing Surveys, vol. 11, no. 2, pp. 121-137, 1979.
17. S. Elnaffar, W. Powley, D. Benoit, and P. Martin, "Today's DBMSs: How Autonomic Are They?" Proc. 14th Int'l Conf. Database and Expert Systems Applications (DEXA '03), 2003.
18. T. Grust, M. van Keulen, and J. Teubner, "Staircase Join: Teach a Relational DBMS to Watch Its Axis Steps," Proc. 29th Int'l Conf. Very Large Data Bases (VLDB '03), 2003.
19. P.J. Haas and J.M. Hellerstein, "Ripple Joins for Online Aggregation," Proc. ACM SIGMOD Int'l Conf. Management of Data (SIGMOD '99), 1999.
20. R.A. Hankins and J.M. Patel, "Effect of Node Size on the Performance of Cache-Conscious B+-Trees," Proc. ACM Int'l Conf. Measurement and Modeling of Computer Systems (SIGMETRICS '03), 2003.
21. J. Hellerstein, M. Franklin, S. Chandrasekaran, A. Deshpande, K. Hildrum, S. Madden, V. Raman, and M. Shah, "Adaptive Query Processing: Technology in Evolution," IEEE Data Eng. Bull., vol. 23, no. 2, pp. 7-18, 2000.
22. J. Hennessy and D. Patterson, Computer Architecture: A Quantitative Approach, second ed. Morgan Kaufman, 1996.
23. H. Jiang, H. Lu, W. Wang, and B. Ooi, "XR-Tree: Indexing XML Data for Efficient Structural Join," Proc. 19th Int'l Conf. Data Eng. (ICDE '03), 2003.
24. H. Jiang, W. Wang, H. Lu, and J.X. Yu, "Holistic Twig Joins on Indexed XML Documents," Proc. 29th Int'l Conf. Very Large Data Bases (VLDB '03), 2003.
25. K. Kim, S.K. Cha, and K. Kwon, "Optimizing Multidimensional Index Trees for Main Memory Access," Proc. ACM SIGMOD Int'l Conf. Management of Data (SIGMOD '01), 2001.
26. T.J. Lehman and M.J. Carey, "Query Processing in Main Memory Database Management Systems," Proc. ACM SIGMOD Int'l Conf. Management of Data (SIGMOD '86), 1986.
27. J. Lu, T.W. Ling, C.-Y. Chan, and T. Chen, "From Region Encoding to Extended Dewey: On Efficient Processing of XML Twig Pattern Matching," Proc. 31st Int'l Conf. Very Large Data Bases (VLDB '05), 2005.
28. S. Manegold, P. Boncz, and M. Kersten, "Generic Database Cost Models for Hierarchical Memory Systems," Proc. 28th Int'l Conf. Very Large Data Bases (VLDB '02), 2002.
29. T.S.P. Organization, "SAX: Simple API for XML," http://www.saxproject.org, 2006.
30. +-Trees Cache Conscious in Main Memory," Proc. ACM SIGMOD Int'l Conf. Management of Data (SIGMOD '00), 2000.
31. A. Shatdal and J.F. Naughton, "Adaptive Parallel Aggregation Algorithms," Proc. ACM SIGMOD Int'l Conf. Management of Data (SIGMOD '95), 1995.
32. S. Sipani, K. Verma, J.A. Miller, and B. Aleman-Meza, "Designing a High-Performance Database Engine for the 'Db4XML' Native XML Database System," J. System and Software, vol. 69, nos. 1-2, pp. 87-104, 2004.
33. A. Skelley, "DB2 Advisor: An Optimizer Smart Enough to Recommend Its Own Indexes," Proc. 16th Int'l Conf. Data Eng. (ICDE '00), 2000.
34. M. Stillger, G.M. Lohman, V. Markl, and M. Kandil, "LEO - DB2's LEarning Optimizer," VLDB J., pp. 19-28, 2001.
35. "XMark-An XML Benchmark Project," http://monetdb.cwi.nl/xml/ index.html, 2006.
36. "XML Data Repository," http://www.cs.washington.edu/research/ xmldatasets/, 2006.
37. C. Zhang, J. Naughton, D. DeWitt, Q. Luo, and G. Lohman, "On Supporting Containment Queries in Relational Database Management Systems," Proc. ACM SIGMOD Int'l Conf. Management of Data (SIGMOD '00), 2001.