arXivDaily arXiv每日学术速递 周一至周五更新
arXiv 1801.06396cs.DB
收藏

序不完全数据上可能答案与确定答案的计算

Computing Possible and Certain Answers over Order-Incomplete Data

Antoine Amarilli, Mouhamadou Lamine Ba, Daniel Deutch, Pierre Senellart

摘要:

本文研究了数据库的查询评估的复杂性,其关系是偏序的,这个问题通常会出现在组合或转换有序的数据从多个来源。我们专注于查询中的一个有用的片段的SQL,即正关系代数与聚合,其袋语义,我们扩展到偏序设置。我们的语义导致两个主要的计算问题的研究:查询答案的可能性和确定性。我们表明,这些问题分别是NP-完全和CONP-完全,但确定易处理的情况下,根据查询运算符或输入偏序。我们进一步引入了一个重复消除算子,并研究了它对复杂性结果的影响。

英文摘要:

This paper studies the complexity of query evaluation for databases whose relations are partially ordered; the problem commonly arises when combining or transforming ordered data from multiple sources. We focus on queries in a useful fragment of SQL, namely positive relational algebra with aggregates, whose bag semantics we extend to the partially ordered setting. Our semantics leads to the study of two main computational problems: the possibility and certainty of query answers. We show that these problems are respectively NP-complete and coNP-complete, but identify tractable cases depending on the query operators or input partial orders. We further introduce a duplicate elimination operator and study its effect on the complexity results.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑