DBScholar

Back to papers

Optimal Aggregation Algorithms for Middleware [Extended Abstract]

Summary: Introduces TA, proved instance-optimal for top-k under any monotone aggregation on every database with only constant-size buffers. Gives optimal variants when random access is costly/impossible and contrasts TA's deterministic worst-case optimality and low memory vs. Fagin's Algorithm. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID
h3bbb91e1e77f20ee
Venue
PODS
Year
2001
Pagerank
0.0010688884
Overall Rank
5 | 99.97%
DOI
10.1145/375551.375567

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{fagin_pods01,
        address = {New York, NY, USA},
        series = {{PODS} '01},
        title = {{Optimal Aggregation Algorithms for Middleware [Extended Abstract]}},
        url = {https://dl.acm.org/doi/10.1145/375551.375567},
        doi = {10.1145/375551.375567},
        booktitle = {Proceedings of the {ACM} {SIGMOD} Symposium on {Principles} of {Database} {Systems}},
        publisher = {Association for Computing Machinery},
        author = {Fagin, Ronald and Lotem, Amnon and Naor, Moni},
        year = {2001}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 246 citing papers.

Rank Citing Paper Year Venue Pagerank
51 Efficient Query Evaluation on Probabilistic Databases 2004 VLDB 0.00042804864
81 XRANK: Ranked Keyword Search over XML Documents 2003 SIGMOD 0.00036224963
181 Milvus: A Purpose-Built Vector Data Management System 2021 SIGMOD 0.00026425782
217 Efficient IR-Style Keyword Search over Relational Databases 2003 VLDB 0.00024417824
272 BLINKS: Ranked Keyword Searches on Graphs 2007 SIGMOD 0.00022559588
292 ObjectRank: Authority-Based Keyword Search in Databases 2004 VLDB 0.00021888861
294 Bidirectional Expansion For Keyword Search on Graph Databases 2005 VLDB 0.00021884041
318 Worst-Case Optimal Join Algorithms: Techniques, Results, and Open Problems 2018 PODS 0.00021178303
478 Automated Ranking of Database Query Results 2003 CIDR 0.00017612826
505 Supporting Top-k Join Queries in Relational Databases 2003 VLDB 0.00017162373
511 Supporting Incremental Join Queries on Ranked Inputs 2001 VLDB 0.00017061618
550 SageDB: A Learned Database System 2019 CIDR 0.00016525249
565 Distributed Top-K Monitoring 2003 SIGMOD 0.00016238411
578 Quality and Efficiency in High Dimensional Nearest Neighbor Search 2009 SIGMOD 0.00016079505
673 Foundations of Preferences in Database Systems 2002 VLDB 0.00014877371
674 Efficient Similarity Search and Classification via Rank Aggregation 2003 SIGMOD 0.00014872783
718 Data Integration with Uncertainty 2007 VLDB 0.00014507333
741 PathSim: Meta Path-Based Top-K Similarity Search in Heterogeneous Information Networks 2011 VLDB 0.00014302
820 Finding k-Dominant Skylines in High Dimensional Space 2006 SIGMOD 0.00013621724
840 Minimal Probing: Supporting Expensive Predicates for Top-k Queries 2002 SIGMOD 0.00013521251
941 RankSQL: Query Algebra and Optimization for Relational Top-k Queries 2005 SIGMOD 0.00012938573
947 SPARK: Top-k Keyword Query in Relational Databases 2007 SIGMOD 0.00012910239
1,146 Efficient Diversity-Aware Search 2011 SIGMOD 0.00011779564
1,239 Efficient Query Processing in Geographic Web Search Engines 2006 SIGMOD 0.00011374405
1,268 Finding Related Tables in Data Lakes for Interactive Data Science 2020 SIGMOD 0.00011243615
1,378 Neighborhood Based Fast Graph Search in Large Networks 2011 SIGMOD 0.00010848501
1,385 Designing Fair Ranking Schemes 2019 SIGMOD 0.00010823535
1,403 Ranking Queries on Uncertain Data: A Probabilistic Threshold Approach 2008 SIGMOD 0.00010753743
1,447 Continuous Monitoring of Top-k Queries over Sliding Windows 2006 SIGMOD 0.00010604169
1,450 Finding and Approximating Top-k Answers in Keyword Proximity Search 2006 PODS 0.00010593808
1,478 Diversifying Top-K Results 2012 VLDB 0.00010511781
1,480 Efficient Processing of Top-k Spatial Preference Queries 2011 VLDB 0.00010511472
1,539 Top-k Query Evaluation with Probabilistic Guarantees 2004 VLDB 0.00010292787
1,558 Ordering the Attributes of Query Results 2006 SIGMOD 0.000102274
1,566 Keyword Proximity Search in Complex Data Graphs 2008 SIGMOD 0.00010183731
1,641 Efficient Search for the Top-k Probable Nearest Neighbors in Uncertain Databases 2008 VLDB 9.9814769e-05
1,649 Relaxing Join and Selection Queries 2006 VLDB 9.9699016e-05
1,712 Rank-aware Query Optimization 2004 SIGMOD 9.7961248e-05
1,734 Beyond Worst-case Analysis for Joins with Minesweeper 2014 PODS 9.7545941e-05
1,751 Extending Autocompletion To Tolerate Errors 2009 SIGMOD 9.7128647e-05
1,769 Structured Querying of Web Text: A Technical Challenge 2007 CIDR 9.6796356e-05
1,821 Joins via Geometric Resolutions: Worst-case and Beyond 2015 PODS 9.5466386e-05
1,867 Efficient Retrieval of the Top-k Most Relevant Spatial Web Objects 2009 VLDB 9.4581343e-05
1,897 Probabilistic Ranking of Database Query Results 2004 VLDB 9.3988624e-05
2,018 PIQL: Success-Tolerant Query Processing in the Cloud 2012 VLDB 9.1687512e-05
2,019 IO-Top-k: Index-access Optimized Top-k Query Processing 2006 VLDB 9.1666472e-05
2,058 On the Integration of Structure Indexes and Inverted Lists 2004 SIGMOD 9.0944201e-05
2,136 Fast Set Intersection in Memory 2011 VLDB 8.9790795e-05
2,212 Real-time Targeted Influence Maximization for Online Advertisements 2015 VLDB 8.8427023e-05
2,232 Effective Phrase Prediction 2007 VLDB 8.7867154e-05
Previous Page 1 / 5 Next

Outgoing Citations (Sorted by Pagerank)

Showing 2 of 2 cited papers.

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

Rank Cited Paper Year Venue Pagerank
110 Optimizing Multi-Feature Queries for Image Databases 2000 VLDB 0.00032662513
170 Combining Fuzzy Information from Multiple Systems 1996 PODS 0.0002707332
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 3,623 Best Position Algorithms for Top-k Queries 2007 VLDB
2 1,539 Top-k Query Evaluation with Probabilistic Guarantees 2004 VLDB
3 2,658 A Geometric Approach to Monitoring Threshold Functions Over Distributed Data Streams 2006 SIGMOD
4 566 On Computing Correlated Aggregates Over Continual Data Streams 2001 SIGMOD
5 5,861 Optimal and General Out-of-Order Sliding-Window Aggregation 2019 VLDB
6 3,578 Progressive and Selective Merge: Computing Top-K with Ad-hoc Ranking Functions 2007 SIGMOD
7 3,312 Optimal and Approximate Computation of Summary Statistics for Range Aggregates 2001 PODS
8 848 Aggregation and Ordering in Factorised Databases 2013 VLDB
9 12,648 Optimal Top-k Generation of Attribute Combinations based on Ranked Lists 2012 SIGMOD
10 8,213 Distributed Threshold Querying of General Functions by a Difference of Monotonic Representation 2011 VLDB