DBScholar

Back to papers

PREFER: A System for the Efficient Execution of Multiparametric Ranked Queries

Summary: PREFER enables efficient multiparametric ranked queries via materialized views that score tuples with weight-based functions in a pipelined plan. Space-aware view selector picks a bounded view set; prototype atop a DBMS shows faster preprocessing and query-time. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
3336
Venue
SIGMOD
Year
2001
Pagerank
0.00019021441
Overall Rank
407 | 97.21%
DOI
10.1145/375663.375690

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{hristidis_sigmod01,
        title = {{PREFER: A System for the Efficient Execution of Multiparametric Ranked Queries}},
        author = {Hristidis, Vagelis and Koudas, Nick and Papakonstantinou, Yannis},
        series = {{SIGMOD} '01},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/375663.375690},
        url = {https://dl.acm.org/doi/10.1145/375663.375690},
        year = {2001}
}

Incoming Citations (Sorted by Pagerank)

Showing 46 of 46 citing papers.

Rank Citing Paper Year Venue Pagerank
212 Efficient IR-Style Keyword Search over Relational Databases 2003 VLDB 0.000247733
623 An Optimal and Progressive Algorithm for Skyline Queries 2003 SIGMOD 0.00015684963
656 Foundations of Preferences in Database Systems 2002 VLDB 0.00015258172
827 Minimal Probing: Supporting Expensive Predicates for Top-k Queries 2002 SIGMOD 0.00013769938
973 RankSQL: Query Algebra and Optimization for Relational Top-k Queries 2005 SIGMOD 0.00012874284
1,072 Regret-Minimizing Representative Databases 2010 VLDB 0.0001230281
1,338 Preference SQL - Design, Implementation, Experiences 2002 VLDB 0.00011117197
1,360 Efficient Computation of the Skyline Cube 2005 VLDB 0.00011040203
1,526 Ordering the Attributes of Query Results 2006 SIGMOD 0.00010491673
1,759 Rank-aware Query Optimization 2004 SIGMOD 9.8160244e-05
2,359 Integrating DB and IR Technologies: What is the Sound of One Hand Clapping? * 2005 CIDR 8.698016e-05
2,427 Processing a Large Number of Continuous Preference Top-k Queries 2012 SIGMOD 8.5915976e-05
2,491 Interactive Regret Minimization 2012 SIGMOD 8.5086491e-05
2,516 Stratified Computation of Skylines with Partially-Ordered Domains 2005 SIGMOD 8.4773324e-05
2,525 Answering Top-k Queries Using Views 2006 VLDB 8.4653166e-05
2,616 FleXPath: Flexible Structure and Full-Text Querying for XML 2004 SIGMOD 8.339188e-05
2,827 Efficient Processing of Top-k Dominating Queries on Multi-Dimensional Data 2007 VLDB 8.0831263e-05
2,895 Answering Why-not Questions on Reverse Top-k Queries 2015 VLDB 7.9829449e-05
3,007 Towards Robust Indexing for Ranked Queries 2006 VLDB 7.8583548e-05
3,273 Refreshing the Sky: The Compressed Skycube with Efficient Support for Frequent Updates 2006 SIGMOD 7.5768045e-05
3,317 Ad-hoc Top-k Query Answering for Data Streams 2007 VLDB 7.5251856e-05
3,728 Querying Structured Text in an XML Database 2003 SIGMOD 7.1685118e-05
3,984 Learning User Preferences By Adaptive Pairwise Comparison 2015 VLDB 6.9739437e-05
4,514 Branch-and-Bound Algorithm for Reverse Top-k Queries 2013 SIGMOD 6.6500719e-05
4,587 Answering Top-k Queries with Multi-Dimensional Selections: The Ranking Cube Approach 2006 VLDB 6.6170389e-05
5,164 Efficient Approximation of Optimization Queries Under Parametric Aggregation Constraints 2003 VLDB 6.3372067e-05
5,278 Why Not Yet: Fixing a Top-k Ranking that Is Not Fair to Individuals 2023 VLDB 6.2856584e-05
5,593 Beyond Equi-joins: Ranking, Enumeration and Factorization 2021 VLDB 6.1552328e-05
5,654 k-Regret Queries with Nonlinear Utilities 2015 VLDB 6.1330869e-05
5,796 Reverse k-Ranks Query 2014 VLDB 6.0859929e-05
6,084 Efficient Detection of Empty-Result Queries 2006 VLDB 5.9830699e-05
6,636 Marrying Top-k with Skyline Queries: Relaxing the Preference Input while Producing Output of Controllable Size 2021 SIGMOD 5.8172769e-05
6,815 Supporting Ranking and Clustering as Generalized Order-By and Group-By 2007 SIGMOD 5.7652375e-05
7,177 Distributed Top-N Query Processing with Possibly Uncooperative Local Systems 2003 VLDB 5.6806091e-05
7,185 Anytime Measures for Top-k Algorithms 2007 VLDB 5.6779179e-05
7,631 On Efficient Top-k Query Processing in Highly Distributed Environments 2008 SIGMOD 5.5780405e-05
8,281 Efficient Top-K Processing Over Query-Dependent Functions 2008 VLDB 5.4574671e-05
8,665 Geometric Approaches for Top-k Queries 2017 VLDB 5.3884685e-05
8,825 Creating Top Ranking Options in the Continuous Option and Preference Space 2019 VLDB 5.3616725e-05
9,010 Determining the Impact Regions of Competing Options in Preference Space 2017 SIGMOD 5.3333957e-05
9,115 A General Framework for Modeling and Processing Optimization Queries 2007 VLDB 5.3215443e-05
9,525 Towards Indexing Functions: Answering Scalar Product Queries 2014 SIGMOD 5.2555551e-05
9,581 A Generic Framework for Handling Uncertain Data with Local Correlations 2011 VLDB 5.2528121e-05
9,900 On m-Impact Regions and Standing Top-k Influence Problems 2021 SIGMOD 5.1997534e-05
11,565 tau-LevelIndex: Towards Efficient Query Processing in Continuous Preference Space 2022 SIGMOD 5.093636e-05
12,331 Answering Top-k Queries Over a Mixture of Attractive and Repulsive Dimensions 2012 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 11 of 11 cited papers.

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

Rank Cited Paper Year Venue Pagerank
2 R-Trees: A Dynamic Index Structure For Spatial Searching 1984 SIGMOD 0.0020210012
42 The R+-Tree: A Dynamic Multi-Dimensional Index for Objects 1987 VLDB 0.00046170812
69 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.00038090878
170 Combining Fuzzy Information from Multiple Systems 1996 PODS 0.00027376361
333 The Onion Technique: Indexing for Linear Optimization Queries 2000 SIGMOD 0.0002089582
402 Fuzzy Queries in Multimedia Database Systems 1998 PODS 0.00019072958
515 Answering Recursive Queries Using Views 1997 PODS 0.00017177428
554 Answering Queries with Aggregation Using Views 1996 VLDB 0.00016580778
869 Rewriting Aggregate Queries Using Views 1999 PODS 0.00013503594
1,134 A Framework for Expressing and Combining Preferences 2000 SIGMOD 0.00012035449
2,114 Query Rewriting for Semistructured Data 1999 SIGMOD 9.1481121e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 2,427 Processing a Large Number of Continuous Preference Top-k Queries 2012 SIGMOD
2 13,483 Supporting Hard Queries over Probabilistic Preferences 2020 VLDB
3 9,524 Output-sensitive Evaluation of Prioritized Skyline Queries 2015 SIGMOD
4 1,526 Ordering the Attributes of Query Results 2006 SIGMOD
5 1,441 Efficient Processing of Top-k Spatial Preference Queries 2011 VLDB
6 8,743 A Query Engine for Probabilistic Preferences 2018 SIGMOD
7 656 Foundations of Preferences in Database Systems 2002 VLDB
8 7,642 A System for Management and Analysis of Preference Data 2014 VLDB
9 1,338 Preference SQL - Design, Implementation, Experiences 2002 VLDB
10 12,320 PrefDB: Bringing Preferences Closer to the DBMS 2012 SIGMOD