Optimization using tuple subsumption
A tuple t1 of relation R subsumes tuple t2 of R, with respect to a query Q if for every database, tuple t1 derives all, and possibly more, answers to query Q than derived by tuple t2. Therefore, the subsumed tuple t2 can be ignored with respect to Q in the presence of tuple t1 in relation R. This property finds use in a large number of problems. For instance: during query optimization subsumed tuples can be ignored thereby avoiding the computation of redundant answers; the size of cached information in distributed and object oriented systems can be reduced by omitting subsumed tuples; constraints need not be checked and rules need not be recomputed when provably subsumed updates are made. We give algorithms for deciding efficiently when a tuple subsumes another tuple for queries that use arbitrary mathematical functions. We characterize queries for which, whenever a set of tuples T subsumes a tuple t then one of the tuples in T also subsumed t, yielding efficiently verifiable cases of subsumption.
KeywordsDistinguished Point Integrity Constraint Query Optimization Constraint Language Constraint Check
Unable to display preview. Download preview PDF.
- [CS94]Surajit Chaudhuri and Kyuseok Shim. Including Group-By in Query Optimization. To appear in Proceedings of the Twentieth International Conference on Very Large Databases (VLDB), 1994.Google Scholar
- [GSUW94]Ashish Gupta, Shuky Sagiv, Jeffrey D. Ullman, and Jennifer Widom. Constraint Checking with Partial Information. In Proceedings of the Thirteenth Symposium on Principles of Database Systems (PODS), 1994.Google Scholar
- [GW93]Ashish Gupta and Jennifer Widom. Local Checking of Global Integrity Constraints. In Proceedings of ACM SIGMOD 1993 International Conference on Management of Data, pages 49–59.Google Scholar
- [LS93]A.Y. Levy and Y. Sagiv. Queries independent of updates. In Proceedings of the Nineteenth International Conference on Very Large Data Bases, pages 171–181, Dublin, Ireland, August 1993.Google Scholar
- [TH93]Sanjai Tiwari and H. C. Howard. Constraint Management on Distributed AEC Databases. In Fifth International Conference on Computing in Civil and Building Engineering, pages 1147–1154. ASCE, 1993.Google Scholar
- [U1189]J. D. Ullman. Principles of Database and Knowledge-Base Systems, volume 2. Computer Science Press, New York, 1989.Google Scholar