Definition
One query is contained in another if, independent of the values of the “stored data” (that is, database), the set of answers to the first query on the database is a subset of the set of answers to the second query on the same database. A formal definition of containment is as follows: denote with Q(D) the result of computing query Q over database D. A query Q 1 is said to be contained in a query Q 2, denoted by Q 1 ⊑ Q 2, if for all databases D, the set of tuples Q 1(D) is a subset of the set of tuples Q 2(D), that is, Q 1(D) ⊆ Q 2(D). This definition of containment, as well as the related definition of query equivalence, can be used to specify query containment and equivalence on databases conforming to both relational and nonrelational data models, including XML and object-oriented databases.
Historical Background
Testing for query containment on finite databases is, in general, co-recursively enumerable: The procedure is going through all possible databases and...
Recommended Reading
Abiteboul S, Hull R, Vianu V. Foundations of databases. Reading: Addison-Wesley; 1995.
Afrati FN, Li C, Mitra P. Rewriting queries using views in the presence of arithmetic comparisons. Theor Comput Sci. 2006;368(1–2):88–123.
Chandra AK, Merlin PM. Optimal implementation of conjunctive queries in relational data bases. In: Proceedings of 9th Annual ACM Symposium on Theory of Computing; 1977. p. 77–90.
Halevy AY. Answering queries using views: a survey. VLDB J. 2001;10(4):270–94,
Jayram TS, Kolaitis PG, Vee E. The containment problem for REAL conjunctive queries with inequalities. In: Proceedings of 25th ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems; 2006. p. 80–89.
Kanellakis PC. Elements of relational database theory. In: Handbook of theoretical computer science. Volume B: formal models and sematics (B). New York/Cambridge: Elsevier/MIT Press; 1990. p. 1073–156.
Kimelfeld B, Sagiv Y. Revisiting redundancy and minimization in an XPath fragment. In: Advances in Database Technology, Proceedings of 11th International Conference on Extending Database Technology; 2008. p. 61–72.
Klug AC. On conjunctive queries containing inequalities. J ACM. 1988;35(1):146–60.
Kolaitis PG, Vardi MY. Conjunctive-query containment and constraint satisfaction. J Comput Syst Sci. 2000;61(2):302–32.
Miklau G, Suciu D. Containment and equivalence for a fragment of XPath. J ACM. 2004;51(1):2–45.
Saraiya Y. Subtree elimination algorithms in deductive databases. Ph.D. thesis, Stanford University; 1991.
Ullman JD. CS345 lecture notes. http://infolab.stanford.edu/~ullman/cs345-notes.html.
Ullman JD. Principles of database and knowledge-base systems, vol. II. Rockville: Computer Science Press; 1989.
Ullman JD. The database approach to knowledge representation. In: Proceedings of 13th National Conference on Artificial Intelligence and 8th Innovative Applications of AI Conference, vol. 2; 1996. p. 1346–48.
Ullman JD. Information integration using logical views. Theor Comput Sci. 2000;239(2):189–210.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2017 Springer Science+Business Media LLC
About this entry
Cite this entry
Chirkova, R. (2017). Query Containment. In: Liu, L., Özsu, M. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4899-7993-3_1269-2
Download citation
DOI: https://doi.org/10.1007/978-1-4899-7993-3_1269-2
Received:
Accepted:
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4899-7993-3
Online ISBN: 978-1-4899-7993-3
eBook Packages: Springer Reference Computer SciencesReference Module Computer Science and Engineering