Fast joins using join indices

VLDB Journal

Volumn 8, Issue 1, 1999, Pages 1-24

  Li, Zhe ^a   Ross, Kenneth A ^a  

^a Columbia University ^*  (United States)

Author keywords

Decision support systems; Query processing

Indexed keywords

EID: 0033126032     PISSN: 10668888     EISSN: None     Source Type: Journal    
DOI: 10.1007/s007780050071     Document Type: Article

References (45)

1. Agrawal R, et al. (1994) Quest: A project on database mining. In: Snodgrass RT, Winslett M (eds) Proceedings of the 1994 ACM SIGMOD International Conference on Management of Data, Minneapolis, Minnesota, May 24-27, 1994. ACM Press 1994, SIGMOD Record 23(2), June 1994, p 514
2. Agrawal R, et al. (1994) Quest: A project on database mining. In: Snodgrass RT, Winslett M (eds) Proceedings of the 1994 ACM SIGMOD International Conference on Management of Data, Minneapolis, Minnesota, May 24-27, 1994. ACM Press 1994, SIGMOD Record 23(2), June 1994, p 514
3. Batory DS (1979) On searching transposed files. ACM Trans Database Syst 4(4):531-544
4. Bitton D, DeWitt DJ, Turbyfill C (1983) Benchmarking database systems: a systematic approach. In: Schkolnick M, Thanos C (eds) 9th International Conference on Very Large Data Bases, October 31-November 2, 1983, Florence, Italy, Proceedings. VLDB Endowment/Morgan Kaufmann, pp 8-19
5. Blakeley J, Martin N (1990) Join index, materialized view, and hybrid-hash join: a performance analysis. Proceedings of the Sixth Interntional Conference on Data Engineering, February 5-9, 1990, Los Angeles, California, USA, IEEE Computer Society, ISBN 0-8186-2025-0, pp 256-263
6. Blasgen M, Eswaran K (1977) Storage and access in relational data bases. IBM Syst J 16(4): 362-377
7. Bratbergsengen B (1984) Hashing methods and relational algebra operations. In: Dayal U, Schlageter G, Seng LH (eds) Tenth International Conference on Very Large Data Bases, August 27-31, 1984, Singapore, Proceedings. Morgan Kaufmann, ISBN 0-934613-16-8, pp 323-333
8. Brown K, et al. (1992) Resource allocation and scheduling for mixed database workloads. Technical Report 1095, University of Wisconsin, Madison, Wis.
9. Cheng JM, Haderle DJ, Hedges R, Iyer BR, Messinger T, Mohan C, Wang Y (1991) An efficient hybrid join algorithm: A DB2 prototype. Proceedings of the Seventh International Conference on Data Engineering, April 8-12, 1991, Kobe, Japan, IEEE Computer Society, ISBN 0-8186-2138-9, pp 171-180
10. Chou H, DeWitt DJ, Katz RH, Klug AC (1985) Design and implementation of the Wisconsin storage system. Software Pract Exper 15(10):943-962
11. Colby LS, Martin NL, Wehrmeister RM (1994) Query processing for decision support: The SQLmmp solution. Proceedings of the Third International Conference on Parallel and Distributed Information Systems (PDIS 94), Austin, Texas, September 28-30, 1994. IEEE-CS 1994, ISBN 0-8186-6400-2, pp 121-130
12. DeWitt DJ, et al. (1984) Implementation techniques for main memory database systems. In: Yormark B (ed) SIGMOD '84, Proceedings of Annual Meeting, Boston, Massachusetts, June 18-21, 1984. SIGMOD Record 14(2), pp 1-8
13. DeWitt DJ, et al. (1984) Implementation techniques for main memory database systems. In: Yormark B (ed) SIGMOD '84, Proceedings of Annual Meeting, Boston, Massachusetts, June 18-21, 1984. SIGMOD Record 14(2), pp 1-8
14. Dozier J (1992) Access to data in NASA's Earth Observing System. In: Stonebraker M (ed) Proceedings of the 1992 ACM SIGMOD International Conference on Management of Data, San Diego, California, June 2-5, 1992. SIGMOD Record 21(2), June 1992, p 1
15. Dozier J (1992) Access to data in NASA's Earth Observing System. In: Stonebraker M (ed) Proceedings of the 1992 ACM SIGMOD International Conference on Management of Data, San Diego, California, June 2-5, 1992. SIGMOD Record 21(2), June 1992, p 1
16. Graefe G (1992) Performance enhancements for hybrid hash join. Technical Report 606, University of Colorado, Boulder, Colo.
17. Graefe G, Linville A, Shapiro L (1994) Sort versus hash revisited. TKDE 6(6): 934-944
18. Gupta A, Mumick IS, editors (1997) Materialized Views. MIT Press, Cambridge, Mass., in press
19. Haas LM, Carey MJ, Livny M (1993) Seeking the truth about ad hoc join costs. Technical Report RJ9368, IBM Almaden Research Center, Almaden, N.J.
20. Haas LM, Carey MJ, Livny M, Shukla A (1997) Seeking the truth about ad hoc join costs. VLDB J 6(3):241-256
21. Hoare CAR (1962) Quicksort. Comput J 5(1):10-15
22. Kemper A, Moerkotte G (1990) Access support in object bases. In: Garcia-Molina H, Jagadish HV (eds) Proceedings of the 1990 ACM SIGMOD International Conference on Management of Data, Atlantic City, NJ, May 23-25, 1990. ACM Press 1990, SIGMOD Record 19(2), June 1990, pp 364-373
23. Kemper A, Moerkotte G (1990) Access support in object bases. In: Garcia-Molina H, Jagadish HV (eds) Proceedings of the 1990 ACM SIGMOD International Conference on Management of Data, Atlantic City, NJ, May 23-25, 1990. ACM Press 1990, SIGMOD Record 19(2), June 1990, pp 364-373
24. Kim W (1980) A new way to compute the product and join of relations. In: Chen PP, Sprowls RC (eds) Proceedings of the 19890 ACM SIGMOD International Conference on Management of Data, Santa Monica, California, May 14-16, 1980. ACM, New York 1980, pp 179-187
25. Kimball R, Strehlo K (1995) Why decision support fails and how to fix it. SIGMOD Rec 24(3):92-97
26. Kooi RP (1980) The Optimization of Queries in Relational Databases. PhD thesis, Department of Computer and Information Sciences, Case Western Reserve University, Cleveland, Ohio
27. Lei H, Ross KA (1998) Faster joins, self-joins and multi-way joins using join indices. Data and Knowledge Engineering 28(3): 277-298
28. Li Z, Ross K (1995) Federated query processing on the Net using information servers. manuscript
29. Li Z, Ross K (1996) Fast joins using join indices. Technical Report CUCS-032-96, Columbia University, N.Y.
30. Lu W, Han J (1992) Distance-associated join index for spatial range search. In: Golshani F (ed) Proceedings of the Eighth International Conference on Data Engineering, February 3-7, 1992, Tempe, Arizona, IEEE Computer Society, ISBN 0-8186-2545-7, pp 284-292
31. MacNicol R (1997) personal communication
32. Mishra P, Eich M (1992) Join processing in relational databases. Computing Surveys 24(1): 63-113
33. Mohan C, Haderie D, Wang Y, Cheng J (1990) Single table access using multiple indexes: optimization, execution and concurrency control techniques. In: Bancilhon F, Thanos C, Tsichritzis D (eds) Advances in Database Technology - EDBT'90. International Conference on Extending Database Technology, Venice, Italy, March 26-30, 1990, Proceedings. Lecture Notes in Computer Science, Vol 416, Springer, 1990, ISBN 3-540-52291-3 and 0-387-52291-3
34. Murphy MC, Rotem D (1993) Multiprocessor join scheduling. IEEE Trans Knowl Data Eng 5(2):322-338
35. O'Neill P, Graefe G (1995) Multi-table joins through bitmapped join indices. SIGMOD Record 24(3): 8-11
36. Ross KA (1995) Efficiently following object references for large object collections and small main memory. In: Ling TW, Mendelzon AO, Vielle L (eds) Deductive and object-oriented databases, Fourth International Conference, DOOD'95, Singapore, December 4-7, 1995, Proceedings. Lecture Notes in Computer Science, Vol 1013, Springer, 1995, ISBN 3-540-60608-4, pp 73-90
37. Rotem D (1991) Spatial join indices. In: Yu PS, Chen ALP (eds) Proceedings of the Eleventh International Conference on Data Engineering, March 6-10, 1995, Taipei, Taiwan. IEEE Computer Society, ISBN 0-8186-6910-1, pp 500-509
38. Shapiro LD (1986) Join processing in database systems with large main memories. TODS 11(3): 239-264
39. Shekita E, Carey MJ (1990) A performance evaluation of pointer-based joins. In: Garcia-Molina H, Jagadish HV (eds) Proceedings of the 1990 ACM SIGMOD International Conference on Management of Data, Atlantic City, NJ, May 23-25, 1990. ACM Press 1990, SIGMOD Record 19(2), June 1990, pp 300-311
40. Shekita E, Carey MJ (1990) A performance evaluation of pointer-based joins. In: Garcia-Molina H, Jagadish HV (eds) Proceedings of the 1990 ACM SIGMOD International Conference on Management of Data, Atlantic City, NJ, May 23-25, 1990. ACM Press 1990, SIGMOD Record 19(2), June 1990, pp 300-311
41. Silberschatz A, Korth H, Sudarshan S (1997) Database System Concepts, 3rd edition. McGraw Hill, New York
42. Stonebraker MR (1981) Operating system support for database management. Commun ACM 24(7):412-418
43. Valduriez P (1987) Join indices. ACM Trans Database Syst 12(2):218-246
44. Xie Z, Han J (1994) Join index hierarchies for supporting efficient navigations in object-oriented databases. In: Bocca JB, Jarke M, Zaniolo C (eds) Proceedings of the 10th Interntional Conference on Very Large Data Bases (VLDB'94), September 12-15, 1994, Santiago de Chile, Chile. Morgan Kaufmann, ISBN 1-55860-153-8, pp 522-533
45. Yao SB (1977) Approximating block accesses in database organizations. Commun ACM 20(4):260-261