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
1227
Venue
PODS
Year
2001
Pagerank
0.0010828372
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 244 citing papers.

Rank Citing Paper Year Venue Pagerank
50 Efficient Query Evaluation on Probabilistic Databases 2004 VLDB 0.00043596705
77 XRANK: Ranked Keyword Search over XML Documents 2003 SIGMOD 0.00037048607
212 Efficient IR-Style Keyword Search over Relational Databases 2003 VLDB 0.000247733
272 BLINKS: Ranked Keyword Searches on Graphs 2007 SIGMOD 0.00022695855
285 ObjectRank: Authority-Based Keyword Search in Databases 2004 VLDB 0.00022365284
286 Milvus: A Purpose-Built Vector Data Management System 2021 SIGMOD 0.00022357911
302 Bidirectional Expansion For Keyword Search on Graph Databases 2005 VLDB 0.00021963347
321 Worst-Case Optimal Join Algorithms: Techniques, Results, and Open Problems 2018 PODS 0.00021283186
466 Automated Ranking of Database Query Results 2003 CIDR 0.00018014467
499 Supporting Incremental Join Queries on Ranked Inputs 2001 VLDB 0.00017431827
509 Supporting Top-k Join Queries in Relational Databases 2003 VLDB 0.00017220967
550 Distributed Top-K Monitoring 2003 SIGMOD 0.0001663758
568 SageDB: A Learned Database System 2019 CIDR 0.0001641553
581 Quality and Efficiency in High Dimensional Nearest Neighbor Search 2009 SIGMOD 0.00016153395
656 Foundations of Preferences in Database Systems 2002 VLDB 0.00015258172
690 Efficient Similarity Search and Classification via Rank Aggregation 2003 SIGMOD 0.0001492934
699 Data Integration with Uncertainty 2007 VLDB 0.0001487423
731 PathSim: Meta Path-Based Top-K Similarity Search in Heterogeneous Information Networks 2011 VLDB 0.00014537965
792 Finding k-Dominant Skylines in High Dimensional Space 2006 SIGMOD 0.00013979615
827 Minimal Probing: Supporting Expensive Predicates for Top-k Queries 2002 SIGMOD 0.00013769938
930 SPARK: Top-k Keyword Query in Relational Databases 2007 SIGMOD 0.0001312728
973 RankSQL: Query Algebra and Optimization for Relational Top-k Queries 2005 SIGMOD 0.00012874284
1,153 Efficient Diversity-Aware Search 2011 SIGMOD 0.0001193423
1,212 Efficient Query Processing in Geographic Web Search Engines 2006 SIGMOD 0.00011647465
1,303 Finding Related Tables in Data Lakes for Interactive Data Science 2020 SIGMOD 0.0001123653
1,363 Ranking Queries on Uncertain Data: A Probabilistic Threshold Approach 2008 SIGMOD 0.00011025316
1,394 Neighborhood Based Fast Graph Search in Large Networks 2011 SIGMOD 0.0001093153
1,429 Finding and Approximating Top-k Answers in Keyword Proximity Search 2006 PODS 0.00010811133
1,441 Efficient Processing of Top-k Spatial Preference Queries 2011 VLDB 0.00010778831
1,454 Diversifying Top-K Results 2012 VLDB 0.00010739504
1,513 Continuous Monitoring of Top-k Queries over Sliding Windows 2006 SIGMOD 0.00010530872
1,519 Top-k Query Evaluation with Probabilistic Guarantees 2004 VLDB 0.00010513777
1,526 Ordering the Attributes of Query Results 2006 SIGMOD 0.00010491673
1,542 Keyword Proximity Search in Complex Data Graphs 2008 SIGMOD 0.00010421046
1,597 Designing Fair Ranking Schemes 2019 SIGMOD 0.00010246472
1,605 Efficient Search for the Top-k Probable Nearest Neighbors in Uncertain Databases 2008 VLDB 0.00010229844
1,636 Relaxing Join and Selection Queries 2006 VLDB 0.00010156479
1,699 Beyond Worst-case Analysis for Joins with Minesweeper 2014 PODS 9.975915e-05
1,701 Extending Autocompletion To Tolerate Errors 2009 SIGMOD 9.9707165e-05
1,728 Structured Querying of Web Text: A Technical Challenge 2007 CIDR 9.9098087e-05
1,759 Rank-aware Query Optimization 2004 SIGMOD 9.8160244e-05
1,819 Efficient Retrieval of the Top-k Most Relevant Spatial Web Objects 2009 VLDB 9.6810907e-05
1,844 Probabilistic Ranking of Database Query Results 2004 VLDB 9.6314187e-05
1,857 Joins via Geometric Resolutions: Worst-case and Beyond 2015 PODS 9.6047945e-05
1,967 IO-Top-k: Index-access Optimized Top-k Query Processing 2006 VLDB 9.3804693e-05
1,969 PIQL: Success-Tolerant Query Processing in the Cloud 2012 VLDB 9.3749819e-05
2,006 On the Integration of Structure Indexes and Inverted Lists 2004 SIGMOD 9.3190255e-05
2,176 Effective Phrase Prediction 2007 VLDB 9.0172465e-05
2,199 Real-time Targeted Influence Maximization for Online Advertisements 2015 VLDB 8.9668012e-05
2,200 Efficient Network-Aware Search in Collaborative Tagging Sites 2008 VLDB 8.9664473e-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
108 Optimizing Multi-Feature Queries for Image Databases 2000 VLDB 0.00033228866
170 Combining Fuzzy Information from Multiple Systems 1996 PODS 0.00027376361
Previous Page 1 / 1 Next

Semantically Similar Papers

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