Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
skip to main content
10.1145/1514894.1514904acmotherconferencesArticle/Chapter ViewAbstractPublication PagesedbtConference Proceedingsconference-collections
research-article
Free access

Query languages for data exchange: beyond unions of conjunctive queries

Published: 23 March 2009 Publication History

Abstract

The class of unions of conjunctive queries (UCQ) has been shown to be particularly well-behaved for data exchange; its certain answers can be computed in polynomial time (in terms of data complexity). However, this is not the only class with this property; the certain answers to any Datalog program can also can be computed in polynomial time. The problem is that both UCQ and Datalog do not allow negated atoms, as adding an unrestricted form of negation to these languages yields to intractability.
In this paper, we propose a language called DatalogC(≠) that extends Datalog with a restricted form of negation, and study some of its fundamental properties. In particular, we show that the certain answers to a DatalogC(≠) program can be computed in polynomial time (in terms of data complexity), and that every union of conjunctive queries with at most one inequality or negated relational atom per disjunct, can be efficiently rewritten as a DatalogC(≠) program in the context of data exchange. Furthermore, we show that this is also the case for a syntactic restriction of the class of unions of conjunctive queries with at most two inequalities per disjunct. This syntactic restriction is given by two conditions that are optimal, in the sense that computing certain answers becomes intractable if one removes any of them. Finally, we provide a thorough analysis of the combined complexity of computing certain answers to DatalogC(≠) programs and other related query languages. In particular, we show that this problem is Exptime-complete for DatalogC(≠), even if one restricts to conjunctive queries with single inequalities, which is a fragment of DatalogC(≠) by the result mentioned above. Furthermore, we show that the combined complexity is CoNexptime-complete for the case of conjunctive queries with k inequalities, for every k ≥ 2.

References

[1]
S. Abiteboul, and O. Duschka. Answering queries using materialized views. Gemo report 383.
[2]
S. Abiteboul, R. Hull, and V. Vianu. Foundations of databases. Addison-Wesley, 1995.
[3]
F. N. Afrati, C, Li, and V. Pavlaki. Data exchange in the presence of arithmetic comparisons. In EDBT, pages 487--498, 2008.
[4]
M. Arenas, P. Barceló, R. Fagin, and L. Libkin. Locally consistent transformations and query answering in data exchange. In PODS, pages 229--240, 2004.
[5]
C. Beeri, and M. Y. Vardi. A proof procedure for data dependencies. Journal of the ACM, 31(4):718--741, 1984.
[6]
A. Deutsch, A. Nash, and J. B. Remmel. The chase revisited. In PODS, pages 149--158, 2008.
[7]
R. Fagin, P. Kolaitis, L. Popa, W. C. Tan. Composing schema mappings: Second-order dependencies to the rescue. In PODS, pages 83--94, 2004.
[8]
R. Fagin, P. G. Kolaitis, R. J. Miller, L. Popa. Data exchange: semantics and query answering. Theoretical Computer Science, 336(1):89--124, 2005.
[9]
R. Fagin, P. G. Kolaitis, and L. Popa. Data exchange: getting to the core. ACM Transactions on Database Systems, 30(1):174--210, 2005.
[10]
G. Gottlob, C. Papadimitriou. On the complexity of single-rule datalog queries. Information and Computation, 183(1):104--122, 2003.
[11]
P. Kolaitis. Schema mappings, data exchange, and metadata management. In PODS, pages 61--75, 2005.
[12]
P. Kolaitis, J. Panttaja, and W.-C. Tan. The complexity of data exchange. In PODS, pages 30--39, 2006.
[13]
T. Imielinski, W. Lipski. Incomplete information in relational databases. Journal of the ACM 31, 761--791, 1984.
[14]
M. Lenzerini. Data integration: A theoretical perspective. In PODS, pages 233--246, 2002.
[15]
L. Libkin. Elements of Finite Model Theory. Springer, 2004.
[16]
L. Libkin. Data exchange and incomplete information. In PODS, pages 60--69, 2006.
[17]
L. Libkin, C. Sirangelo. Data exchange and schema mappings in open and closed worlds. In PODS, pages 139--148, 2008.
[18]
A. Mądry. Data exchange: On the complexity of answering queries with inequalities. Information Processing Letters, 94(6):253--257, 2005.
[19]
M. Y. Vardi. The complexity of relational query languages. In STOC, pages 137--146, 1982.

Cited By

View all

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Other conferences
ICDT '09: Proceedings of the 12th International Conference on Database Theory
March 2009
334 pages
ISBN:9781605584232
DOI:10.1145/1514894
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 23 March 2009

Permissions

Request permissions for this article.

Check for updates

Qualifiers

  • Research-article

Funding Sources

Conference

EDBT/ICDT '09
EDBT/ICDT '09: EDBT/ICDT '09 joint conference
March 23 - 25, 2009
St. Petersburg, Russia

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)48
  • Downloads (Last 6 weeks)12
Reflects downloads up to 30 Aug 2024

Other Metrics

Citations

Cited By

View all

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Get Access

Login options

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media