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
hc74a7f8db2c4b8d4
Venue
SIGMOD
Year
2001
Pagerank
0.00018609134
Overall Rank
418 | 97.20%
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
217 Efficient IR-Style Keyword Search over Relational Databases 2003 VLDB 0.00024454844
638 An Optimal and Progressive Algorithm for Skyline Queries 2003 SIGMOD 0.00015331662
672 Foundations of Preferences in Database Systems 2002 VLDB 0.00014922272
840 Minimal Probing: Supporting Expensive Predicates for Top-k Queries 2002 SIGMOD 0.00013544367
962 RankSQL: Query Algebra and Optimization for Relational Top-k Queries 2005 SIGMOD 0.00012818013
1,087 Regret-Minimizing Representative Databases 2010 VLDB 0.00012092041
1,377 Preference SQL - Design, Implementation, Experiences 2002 VLDB 0.00010866029
1,395 Efficient Computation of the Skyline Cube 2005 VLDB 0.00010791312
1,557 Ordering the Attributes of Query Results 2006 SIGMOD 0.000102612
1,773 Rank-aware Query Optimization 2004 SIGMOD 9.6683429e-05
2,397 Integrating DB and IR Technologies: What is the Sound of One Hand Clapping? * 2005 CIDR 8.5238625e-05
2,485 Processing a Large Number of Continuous Preference Top-k Queries 2012 SIGMOD 8.3954142e-05
2,545 Interactive Regret Minimization 2012 SIGMOD 8.3139128e-05
2,561 Answering Top-k Queries Using Views 2006 VLDB 8.2940439e-05
2,566 Stratified Computation of Skylines with Partially-Ordered Domains 2005 SIGMOD 8.2845085e-05
2,666 FleXPath: Flexible Structure and Full-Text Querying for XML 2004 SIGMOD 8.1527901e-05
2,893 Efficient Processing of Top-k Dominating Queries on Multi-Dimensional Data 2007 VLDB 7.8981754e-05
2,958 Answering Why-not Questions on Reverse Top-k Queries 2015 VLDB 7.80653e-05
3,070 Towards Robust Indexing for Ranked Queries 2006 VLDB 7.6831067e-05
3,340 Refreshing the Sky: The Compressed Skycube with Efficient Support for Frequent Updates 2006 SIGMOD 7.4045093e-05
3,380 Ad-hoc Top-k Query Answering for Data Streams 2007 VLDB 7.353368e-05
3,813 Querying Structured Text in an XML Database 2003 SIGMOD 7.0055814e-05
4,083 Learning User Preferences By Adaptive Pairwise Comparison 2015 VLDB 6.8143727e-05
4,616 Branch-and-Bound Algorithm for Reverse Top-k Queries 2013 SIGMOD 6.4983802e-05
4,651 Answering Top-k Queries with Multi-Dimensional Selections: The Ranking Cube Approach 2006 VLDB 6.4836419e-05
5,275 Efficient Approximation of Optimization Queries Under Parametric Aggregation Constraints 2003 VLDB 6.1985695e-05
5,359 Why Not Yet: Fixing a Top-k Ranking that Is Not Fair to Individuals 2023 VLDB 6.1608586e-05
5,487 Beyond Equi-joins: Ranking, Enumeration and Factorization 2021 VLDB 6.1085184e-05
5,788 k-Regret Queries with Nonlinear Utilities 2015 VLDB 5.9926479e-05
5,916 Reverse k-Ranks Query 2014 VLDB 5.9472799e-05
6,212 Efficient Detection of Empty-Result Queries 2006 VLDB 5.8469404e-05
6,761 Marrying Top-k with Skyline Queries: Relaxing the Preference Input while Producing Output of Controllable Size 2021 SIGMOD 5.6873442e-05
6,952 Supporting Ranking and Clustering as Generalized Order-By and Group-By 2007 SIGMOD 5.6338956e-05
7,324 Distributed Top-N Query Processing with Possibly Uncooperative Local Systems 2003 VLDB 5.5512232e-05
7,329 Anytime Measures for Top-k Algorithms 2007 VLDB 5.5485926e-05
7,795 On Efficient Top-k Query Processing in Highly Distributed Environments 2008 SIGMOD 5.4503179e-05
8,458 Efficient Top-K Processing Over Query-Dependent Functions 2008 VLDB 5.3324907e-05
8,809 Geometric Approaches for Top-k Queries 2017 VLDB 5.2711392e-05
9,002 Creating Top Ranking Options in the Continuous Option and Preference Space 2019 VLDB 5.23944e-05
9,181 Determining the Impact Regions of Competing Options in Preference Space 2017 SIGMOD 5.2115802e-05
9,298 A General Framework for Modeling and Processing Optimization Queries 2007 VLDB 5.1997281e-05
9,707 Towards Indexing Functions: Answering Scalar Product Queries 2014 SIGMOD 5.1357527e-05
9,762 A Generic Framework for Handling Uncertain Data with Local Correlations 2011 VLDB 5.1325223e-05
10,091 On m-Impact Regions and Standing Top-k Influence Problems 2021 SIGMOD 5.0806786e-05
11,880 tau-LevelIndex: Towards Efficient Query Processing in Continuous Preference Space 2022 SIGMOD 4.9769913e-05
12,628 Answering Top-k Queries Over a Mixture of Attractive and Repulsive Dimensions 2012 VLDB 4.9769913e-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.0019923528
44 The R+-Tree: A Dynamic Multi-Dimensional Index for Objects 1987 VLDB 0.00045319457
72 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.0003753293
172 Combining Fuzzy Information from Multiple Systems 1996 PODS 0.00026824625
342 The Onion Technique: Indexing for Linear Optimization Queries 2000 SIGMOD 0.00020520649
413 Fuzzy Queries in Multimedia Database Systems 1998 PODS 0.00018686769
532 Answering Recursive Queries Using Views 1997 PODS 0.00016821057
567 Answering Queries with Aggregation Using Views 1996 VLDB 0.00016264813
880 Rewriting Aggregate Queries Using Views 1999 PODS 0.00013274554
1,159 A Framework for Expressing and Combining Preferences 2000 SIGMOD 0.00011766742
2,128 Query Rewriting for Semistructured Data 1999 SIGMOD 8.9984814e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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