Equivalence of queries combining set and bag-set semantics

The query equivalence problem has been studied extensively for set-semantics and, more recently, for bag-set semantics. However, SQL queries often combine set and bag-set semantics. For example, an SQL query that returns a multiset of elements may call a subquery or view that returns a set of elements. As another example, in SQL one can compute a multiset-union of queries, each of which returns a set of answers. This paper presents combined semantics, which formally models query evaluation combining set and bag-set semantics. The equivalence problem for queries evaluated under combined semantics is studied. A sufficient condition for equivalence is presented. For several important common classes of queries necessary and sufficient conditions for equivalence are presented. Categories and Subject Descriptors H.2.3 [Database Management]: Languages--Query languages; H.3.3 [Information Storage and Retrieval]: Information Search and Retrieval--Query formulation General Terms Languages, Theo...

• Type: Conference
• Year: 2006
• Where: PODS
• Authors: Sara Cohen
• Keywords: Bag-set Semantics, Database, Keywords Bag Semantics, PODS 2006, Query Equivalence Problem