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.0010679903
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 245 citing papers.

Rank Citing Paper Year Venue Pagerank
51 Efficient Query Evaluation on Probabilistic Databases 2004 VLDB 0.00042926566
81 XRANK: Ranked Keyword Search over XML Documents 2003 SIGMOD 0.00036330407
189 Milvus: A Purpose-Built Vector Data Management System 2021 SIGMOD 0.0002585319
217 Efficient IR-Style Keyword Search over Relational Databases 2003 VLDB 0.00024454844
270 BLINKS: Ranked Keyword Searches on Graphs 2007 SIGMOD 0.00022588961
290 ObjectRank: Authority-Based Keyword Search in Databases 2004 VLDB 0.00021944946
293 Bidirectional Expansion For Keyword Search on Graph Databases 2005 VLDB 0.00021933539
315 Worst-Case Optimal Join Algorithms: Techniques, Results, and Open Problems 2018 PODS 0.00021236408
474 Automated Ranking of Database Query Results 2003 CIDR 0.00017665834
507 Supporting Incremental Join Queries on Ranked Inputs 2001 VLDB 0.00017093562
524 Supporting Top-k Join Queries in Relational Databases 2003 VLDB 0.00016902116
555 SageDB: A Learned Database System 2019 CIDR 0.0001650754
565 Distributed Top-K Monitoring 2003 SIGMOD 0.00016288995
576 Quality and Efficiency in High Dimensional Nearest Neighbor Search 2009 SIGMOD 0.00016118297
672 Foundations of Preferences in Database Systems 2002 VLDB 0.00014922272
674 Efficient Similarity Search and Classification via Rank Aggregation 2003 SIGMOD 0.00014886449
715 Data Integration with Uncertainty 2007 VLDB 0.00014552507
740 PathSim: Meta Path-Based Top-K Similarity Search in Heterogeneous Information Networks 2011 VLDB 0.00014326575
818 Finding k-Dominant Skylines in High Dimensional Space 2006 SIGMOD 0.00013666302
840 Minimal Probing: Supporting Expensive Predicates for Top-k Queries 2002 SIGMOD 0.00013544367
942 SPARK: Top-k Keyword Query in Relational Databases 2007 SIGMOD 0.00012950177
962 RankSQL: Query Algebra and Optimization for Relational Top-k Queries 2005 SIGMOD 0.00012818013
1,145 Efficient Diversity-Aware Search 2011 SIGMOD 0.00011818487
1,232 Efficient Query Processing in Geographic Web Search Engines 2006 SIGMOD 0.00011406666
1,293 Finding Related Tables in Data Lakes for Interactive Data Science 2020 SIGMOD 0.00011144991
1,374 Neighborhood Based Fast Graph Search in Large Networks 2011 SIGMOD 0.00010875727
1,379 Designing Fair Ranking Schemes 2019 SIGMOD 0.00010859038
1,397 Ranking Queries on Uncertain Data: A Probabilistic Threshold Approach 2008 SIGMOD 0.00010787659
1,441 Continuous Monitoring of Top-k Queries over Sliding Windows 2006 SIGMOD 0.00010638056
1,446 Finding and Approximating Top-k Answers in Keyword Proximity Search 2006 PODS 0.00010625633
1,476 Diversifying Top-K Results 2012 VLDB 0.00010546498
1,477 Efficient Processing of Top-k Spatial Preference Queries 2011 VLDB 0.00010546245
1,535 Top-k Query Evaluation with Probabilistic Guarantees 2004 VLDB 0.00010326646
1,557 Ordering the Attributes of Query Results 2006 SIGMOD 0.000102612
1,565 Keyword Proximity Search in Complex Data Graphs 2008 SIGMOD 0.00010216262
1,635 Efficient Search for the Top-k Probable Nearest Neighbors in Uncertain Databases 2008 VLDB 0.00010012676
1,643 Relaxing Join and Selection Queries 2006 VLDB 0.00010001728
1,726 Beyond Worst-case Analysis for Joins with Minesweeper 2014 PODS 9.7857214e-05
1,739 Extending Autocompletion To Tolerate Errors 2009 SIGMOD 9.7448851e-05
1,759 Structured Querying of Web Text: A Technical Challenge 2007 CIDR 9.7090189e-05
1,773 Rank-aware Query Optimization 2004 SIGMOD 9.6683429e-05
1,813 Joins via Geometric Resolutions: Worst-case and Beyond 2015 PODS 9.5759542e-05
1,858 Efficient Retrieval of the Top-k Most Relevant Spatial Web Objects 2009 VLDB 9.4893333e-05
1,887 Probabilistic Ranking of Database Query Results 2004 VLDB 9.4295364e-05
2,008 IO-Top-k: Index-access Optimized Top-k Query Processing 2006 VLDB 9.1956849e-05
2,009 PIQL: Success-Tolerant Query Processing in the Cloud 2012 VLDB 9.1949132e-05
2,048 On the Integration of Structure Indexes and Inverted Lists 2004 SIGMOD 9.1227281e-05
2,120 Fast Set Intersection in Memory 2011 VLDB 9.0077549e-05
2,215 Effective Phrase Prediction 2007 VLDB 8.8154455e-05
2,232 Real-time Targeted Influence Maximization for Online Advertisements 2015 VLDB 8.7958389e-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
111 Optimizing Multi-Feature Queries for Image Databases 2000 VLDB 0.00032668973
172 Combining Fuzzy Information from Multiple Systems 1996 PODS 0.00026824625
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 3,653 Best Position Algorithms for Top-k Queries 2007 VLDB
2 1,535 Top-k Query Evaluation with Probabilistic Guarantees 2004 VLDB
3 2,649 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,845 Optimal and General Out-of-Order Sliding-Window Aggregation 2019 VLDB
6 3,567 Progressive and Selective Merge: Computing Top-K with Ad-hoc Ranking Functions 2007 SIGMOD
7 3,303 Optimal and Approximate Computation of Summary Statistics for Range Aggregates 2001 PODS
8 849 Aggregation and Ordering in Factorised Databases 2013 VLDB
9 12,605 Optimal Top-k Generation of Attribute Combinations based on Ranked Lists 2012 SIGMOD
10 8,197 Distributed Threshold Querying of General Functions by a Difference of Monotonic Representation 2011 VLDB