The Complexity of Querying Indefinite Data about Linearly Ordered Domains

In applications dealing with ordered domains, the available data is frequently indefinite. While the domain is actually linearly ordered, only some of the order relations holding between points in the data are known. Thus, the data provides only a partial order, and query answering involves determining what holds under all the compatible linear orders. In this paper we study the complexity of evaluating queries in logical databases containing such indefinite information. We show that in this context queries are intractable even under the data complexity measure, but identify a number of PTIME subproblems. Data complexity in the case of monadic predicates is one of these PTIME cases, but for disjunctive queries the proof is nonconstructive, using well-quasi-order techniques. We also show that the query problem we study is equivalent to the problem of containment of conjunctive relational database queries containing inequalities. One of our result implies that the latter is?p2-complete, solving an open problem of Klug (J. Assoc. Comput. Mach.35, No. 1 (1988), 146?160).

[1]  Ron Shamir,et al.  Complexity and algorithms for reasoning about time: a graph-theoretic approach , 1993, JACM.

[2]  Moshe Y. Vardi Querying Logical Databases , 1986, J. Comput. Syst. Sci..

[3]  J. Kruskal An Overview of Sequence Comparison: Time Warps, String Edits, and Macromolecules , 1983 .

[4]  Henry A. Kautz,et al.  Constraint propagation algorithms for temporal reasoning: a revised report , 1989 .

[5]  Jean-Louis Lassez,et al.  Querying constraints , 1990, PODS '90.

[6]  R. V. D. Meyden The complexity of querying indefinite information: defined relations, recursion and linear order , 1992 .

[7]  Raymond Reiter,et al.  Towards a Logical Reconstruction of Relational Database Theory , 1982, On Conceptual Modelling.

[8]  L. Thorne McCarty,et al.  Reasoning About Indefinite Actions , 1992, KR.

[9]  James F. Allen Maintaining knowledge about temporal intervals , 1983, CACM.

[10]  Peter van Beek,et al.  Exact and approximate reasoning about temporal relations 1 , 1990, Comput. Intell..

[11]  M. Golumbic Algorithmic graph theory and perfect graphs , 1980 .

[12]  Michael R. Fellows,et al.  Nonconstructive Advances in Polynomial-Time Complexity , 1987, Inf. Process. Lett..

[13]  Manolis Koubarakis,et al.  Dense Time and Temporal Constraints with != , 1992, KR.

[14]  Ron van der Meyden Recursively Indefinite Databases , 1993, Theor. Comput. Sci..

[15]  E. C. Milner Basic WQO- and BQO-Theory , 1985 .

[16]  Michael R. Fellows,et al.  Nonconstructive tools for proving polynomial-time decidability , 1988, JACM.

[17]  Gabriel M. Kuper,et al.  Constraint Query Languages , 1995, J. Comput. Syst. Sci..

[18]  Anthony C. Klug On conjunctive queries containing inequalities , 1988, JACM.

[19]  Wilfred J. Hansen,et al.  Data structures in Pascal , 1986 .

[20]  Harry B. Hunt,et al.  Processing Conjunctive Predicates and Queries , 1980, VLDB.

[21]  Michael L. Brodie,et al.  On Conceptual Modelling , 1984, Topics in Information Systems.

[22]  Serge Abiteboul,et al.  On the Representation and Querying of Sets of Possible Worlds , 1991, Theor. Comput. Sci..

[23]  Yoav Shoham,et al.  A propositional modal logic of time intervals , 1991, JACM.

[24]  Chen C. Chang,et al.  Model Theory: Third Edition (Dover Books On Mathematics) By C.C. Chang;H. Jerome Keisler;Mathematics , 1966 .

[25]  Ashok K. Chandra,et al.  Optimal implementation of conjunctive queries in relational data bases , 1977, STOC '77.

[26]  David S. Johnson,et al.  Computers and Intractability: A Guide to the Theory of NP-Completeness , 1978 .

[27]  Joseph B. Kruskal,et al.  The Theory of Well-Quasi-Ordering: A Frequently Discovered Concept , 1972, J. Comb. Theory A.