Abstract
A join of two relations in real databases is usually much smaller than their Cartesian product. This means that most of the combinations of tuples in the crossproduct of the respective relations do not appear together in the join result. We characterize these missing combinations as ranges of attributes that do not appear together and present experimental results on their discovery from real data sets. We then explore potential applications of this knowledge to query optimization. By modeling empty joins as materialized views, we show how knowledge of these regions can be used to improve query performance.
This is a preview of subscription content, log in via an institution to check access.
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
S. Ceri, P. Fraternali, S. Paraboschi, and L. Tanca. Automatic generation of production rules for integrity maintenance. TODS, 19(3):367–422, 1994.
S. Ceri and J. Widom. Deriving production rules for constraint maintanance. In Proceedings of the 16 th VLDB, pages 577–589, Brisbane, Australia, 1990.
U. Chakravarthy, J. Grant, and J. Minker. Logic-based approach to semantic query optimization. ACM TODS, 15(2):162–207, June 1990.
S. Chaudhuri, R. Krishnamurthy, S. Potamianos, and K. Shim. Optimizing queries with materialized views. In Proceedings of the 11th ICDE, pages 190–200, Taipei, Taiwan, 1995. IEEE Computer Society.
I-Min. A. Chen and R. C. Lee. An approach to deriving object hierarchies from database schema and contents. In Proceedings of the 6th ISMIS, pages 112–121, Charlotte, NC, 1991.
Q. Cheng, J. Gryz, F. Koo, C. Leung, L. Liu, X. Qian, and B. Schiefer. Implementation of two semantic query optimization techniques in DB2 UDB. In Proc. of the 25th VLDB, pages 687–698, Edinburgh, Scotland, 1999.
W. Chu, R. C. Lee, and Q. Chen. Using type inference and induced rules to provide intensional answers. In Proc. of the 7th ICDE, pages 396–403, Kobe, Japan, 1991.
S. Dar, M. Franklin, B. Jonsson, D. Srivastava, and M. Tan. Semantic data caching and replacement. In Proc. of 22nd VLDB, pages 330–341, Bombay, India, 1996.
J. Edmonds, J. Gryz, D. Liang, and R. J. Miller. Mining for empty rectangles in large data sets. In Proceedings of the 8th ICDT, pages 174–188, London, UK, 2001.
P. Godfrey, J. Gryz, and C. Zuzarte. Exploiting constraint-like data characterizations in query optimization. In Proceedings of Sigmod, pages 582–592, Santa Barbara, CA, 2001.
J. Gryz, B. Schiefer, J. Zheng, and C. Zuzarte. Discovery and application of check constraints in DB2. In Proceedings of ICDE, pages 551–556, Heidelberg, Germany, 2001.
A. Gupta and I. S. Mumick. Maintenance of materialized views: Problems, techniques, and applications. Data Engineering Bulletin, 18(2):3–18, 1995.
M.T. Hammer and S.B. Zdonik. Knowledge-based query processing. Proc. 6th VLDB, pages 137–147, October 1980.
J. Han, Y. Cai, and N. Cercone. Knowledge discovery in databases: An attributeoriented approach. In Proceedings of the 18th VLDB, pages 547–559, Vancouver, Canada, 1992.
C. N. Hsu and C. A. Knoblock. Using inductive learning to generate rules for semantic query optimization. In Advances in Knowledge Discovery and Data Mining, pages 425–445. AAAI/MIT Press, 1996.
M. Jarke, J. Clifford, and Y. Vassiliou. An optimizing PROLOG front-end to a relational query system. In SIGMOD, pages 296–306, 1984.
J.J. King. Quist: A system for semantic query optimization in relational databases. In Proc. 7th VLDB, pages 510–517, Cannes, France, September 1981.
A. Y. Levy, A. O. Mendelzon, Y. Sagiv, and D. Srivastava. Answering queries using views. In Proceedings of the 14th PODS, pages 95–104, San Jose, California, 1995. ACM Press.
S. Shekar, B. Hamidzadeh, A. Kohli, and M. Coyle. Learning transformation rules for semantic query optimization. TKDE, 5(6):950–964, December 1993.
S.T. Shenoy and Z.M. Ozsoyoglu. Design and implementation of a semantic query optimizer. IEEE Transactions on Knowledge and Data Engineering, 1(3):344–361, September 1989.
M.D. Siegel. Automatic rule derivation for semantic query optimization. In Proceedings of the 2nd International Conference on Expert Database Systems, pages 371–386, Vienna, Virginia, 1988.
D. Srivastava, S. Dar, H.V. Jagadish, and A. Levy. Answering queries with aggregation using views. In Proceedings of the 22nd VLDB, pages 318–329, Bombay, India, 1996.
Clement T. Yu and Wei Sun. Automatic knowledge acquisition and maintenance for semantic query optimization. IEEE Transactions on Knowledge and Data Engineering, 1(3):362–375, September 1989.
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
Gryz, J., Liang, D. (2002). Query Optimization via Empty Joins. In: Hameurlain, A., Cicchetti, R., Traunmüller, R. (eds) Database and Expert Systems Applications. DEXA 2002. Lecture Notes in Computer Science, vol 2453. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-46146-9_70
Download citation
DOI: https://doi.org/10.1007/3-540-46146-9_70
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-44126-7
Online ISBN: 978-3-540-46146-3
eBook Packages: Springer Book Archive