Answering Queries Using Views with Arithmetic Comparisons

Summary: Novel algorithm to compute maximally-contained rewritings (MCRs) for conjunctive queries with arithmetic comparisons (CQACs) over dense orders, handling left/right semi-interval-comparison predicates. Shows finite unions of CQACs can be insufficient, identifies cases where datalog suffices, and proves decidability of equivalent rewritings. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: 1265
Venue: PODS
Year: 2002
Pagerank: 6.2484907e-05
Overall Rank: 5,361 | 63.22%
DOI: 10.1145/543613.543641

Incoming Non-self Citations Over Time

Authors

1. Foto Afrati (National Technical University of Athens)
2. Chen Li (University of California Irvine)
3. Prasenjit Mitra (Stanford University)

BibTeX Citation

@inproceedings{afrati_pods02,
        address = {New York, NY, USA},
        series = {{PODS} '02},
        title = {{Answering Queries Using Views with Arithmetic Comparisons}},
        url = {https://dl.acm.org/doi/10.1145/543613.543641},
        doi = {10.1145/543613.543641},
        booktitle = {Proceedings of the {ACM} {SIGMOD} Symposium on {Principles} of {Database} {Systems}},
        publisher = {Association for Computing Machinery},
        author = {Afrati, Foto and Li, Chen and Mitra, Prasenjit},
        year = {2002}
}

Incoming Citations (Sorted by Pagerank)

Showing 4 of 4 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,991	Views and Queries: Determinacy and Rewriting	2005	PODS	9.344653e-05
3,392	Complete Yet Practical Search for Minimal Query Reformulations Under Constraints	2014	SIGMOD	7.4515019e-05
9,225	Queries with Arithmetic on Incomplete Databases	2020	PODS	5.3035385e-05
11,910	Catching Numeric Inconsistencies in Graphs	2018	SIGMOD	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 15 of 15 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
69	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.00038090878
117	Querying Heterogeneous Information Sources Using Source Descriptions	1996	VLDB	0.00032192665
171	Optimizing Queries across Diverse Data Sources	1997	VLDB	0.00027363924
225	Complexity of Answering Queries Using Materialized Views	1998	PODS	0.00024101949
328	An Adaptive Query Execution System for Data Integration*	1999	SIGMOD	0.00021081317
515	Answering Recursive Queries Using Views	1997	PODS	0.00017177428
616	Parallel Evaluation of Recursive Rule Queries	1986	PODS	0.00015712636
633	The Complexity of Querying Indefinite Data about Linearly Ordered Domains (Preliminary Version)	1992	PODS	0.00015560958
913	A Scalable Algorithm for Answering Queries Using Views	2000	VLDB	0.00013253821
953	On the Equivalence of Recursive and Nonrecursive Datalog Programs	1992	PODS	0.00012997935
1,489	Constraint Checking with Partial Information	1994	PODS	0.00010612225
1,543	Data Warehouse Configuration	1997	VLDB	0.00010413384
2,527	Rewriting Queries Using Views in Description Logics	1997	PODS	8.4625195e-05
3,801	On the Complexity of the Containment Problem for Conjunctive Queries with Built-in Predicates	1998	PODS	7.1130194e-05
4,287	Optimization of Run-time Management of Data Intensive Web Sites	1999	VLDB	6.7803604e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	10,154	Fine-Grained Dichotomies for Conjunctive Queries with Minimum or Maximum	2026	PODS
2	225	Complexity of Answering Queries Using Materialized Views	1998	PODS
3	9,403	Materializing Views with Minimal Size To Answer Queries	2003	PODS
4	4,445	View-Based Query Containment	2003	PODS
5	7,121	Query Evaluation using Overlapping Views: Completeness and Efficiency	2006	SIGMOD
6	1,031	Answering Queries Using Limited External Query Processors	1996	PODS
7	69	Answering Queries Using Views (Extended Abstract)	1995	PODS
8	2,527	Rewriting Queries Using Views in Description Logics	1997	PODS
9	869	Rewriting Aggregate Queries Using Views	1999	PODS
10	12,029	Bounded Query Rewriting Using Views	2016	PODS