The Community for Technology Leaders
Green Image
Issue No. 06 - June (2014 vol. 26)
ISSN: 1041-4347
pp: 1532-1543
Biao Qin , Sch. of Inf., Renmin Univ. of China, Beijing, China
Shan Wang , Sch. of Inf., Renmin Univ. of China, Beijing, China
Xiaofang Zhou , Sch. of Inf., Renmin Univ. of China, Beijing, China
Xiaoyong Du , Sch. of Inf., Renmin Univ. of China, Beijing, China
ABSTRACT
This paper investigates the problem of efficiently computing responsibility for lineages of conjunctive queries with inequalities on databases. We classify the lineages of a class of queries with inequalities, called IQ queries, into path and composite lineages. We first compile path lineages into lineage graphs and transform lineage graphs into matrices. Then we reduce the problem of computing responsibility for path lineages to the shortest path problem, which can be solved by the dynamic programming algorithm in PTIME. We further prove composite lineages can be decomposed into path lineages for computing responsibility. Thus, our first main result shows it is in PTIME to compute responsibility for lineages of IQ queries. We generalize the previous results on dichotomy of responsibility analysis for lineages of conjunctive queries with equalities, now in the presence of inequalities. After decomposing composite lineages into path lineages, the data population needed for computing responsibility decreases more than one order of magnitude. Thus, our algorithm can efficiently compute responsibility for composite lineages. In order to compute responsibility for lineages in general, we introduce a greedy algorithm, consisting of a reduction to the set cover problem. Finally, we demonstrate the benefits of the proposed algorithms with extensive experimental results.
INDEX TERMS
Databases, Algorithm design and analysis, Heuristic algorithms, Dynamic programming, Equations, Linear matrix inequalities, Shortest path problem,greedy algorithm, Lineage, responsibility, conjunctive queries with inequalities, dynamic programming algorithm
CITATION
Biao Qin, Shan Wang, Xiaofang Zhou, Xiaoyong Du, "Responsibility Analysis for Lineages of Conjunctive Queries with Inequalities", IEEE Transactions on Knowledge & Data Engineering, vol. 26, no. , pp. 1532-1543, June 2014, doi:10.1109/TKDE.2013.58
637 ms
(Ver 3.3 (11022016))