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.00018558415
Overall Rank
419 | 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.00024417824
640 An Optimal and Progressive Algorithm for Skyline Queries 2003 SIGMOD 0.00015286314
673 Foundations of Preferences in Database Systems 2002 VLDB 0.00014877371
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
1,092 Regret-Minimizing Representative Databases 2010 VLDB 0.00012052099
1,382 Preference SQL - Design, Implementation, Experiences 2002 VLDB 0.00010830552
1,401 Efficient Computation of the Skyline Cube 2005 VLDB 0.0001075604
1,558 Ordering the Attributes of Query Results 2006 SIGMOD 0.000102274
1,712 Rank-aware Query Optimization 2004 SIGMOD 9.7961248e-05
2,406 Integrating DB and IR Technologies: What is the Sound of One Hand Clapping? * 2005 CIDR 8.4962449e-05
2,495 Processing a Large Number of Continuous Preference Top-k Queries 2012 SIGMOD 8.3676654e-05
2,551 Interactive Regret Minimization 2012 SIGMOD 8.2864226e-05
2,566 Answering Top-k Queries Using Views 2006 VLDB 8.2679821e-05
2,573 Stratified Computation of Skylines with Partially-Ordered Domains 2005 SIGMOD 8.2576057e-05
2,677 FleXPath: Flexible Structure and Full-Text Querying for XML 2004 SIGMOD 8.1266688e-05
2,904 Efficient Processing of Top-k Dominating Queries on Multi-Dimensional Data 2007 VLDB 7.8723013e-05
2,975 Answering Why-not Questions on Reverse Top-k Queries 2015 VLDB 7.7807277e-05
3,078 Towards Robust Indexing for Ranked Queries 2006 VLDB 7.6577871e-05
3,346 Refreshing the Sky: The Compressed Skycube with Efficient Support for Frequent Updates 2006 SIGMOD 7.3804433e-05
3,391 Ad-hoc Top-k Query Answering for Data Streams 2007 VLDB 7.3290724e-05
3,819 Querying Structured Text in an XML Database 2003 SIGMOD 6.9825548e-05
4,105 Learning User Preferences By Adaptive Pairwise Comparison 2015 VLDB 6.7918403e-05
4,634 Branch-and-Bound Algorithm for Reverse Top-k Queries 2013 SIGMOD 6.476894e-05
4,668 Answering Top-k Queries with Multi-Dimensional Selections: The Ranking Cube Approach 2006 VLDB 6.4622135e-05
5,285 Efficient Approximation of Optimization Queries Under Parametric Aggregation Constraints 2003 VLDB 6.1819623e-05
5,374 Why Not Yet: Fixing a Top-k Ranking that Is Not Fair to Individuals 2023 VLDB 6.140487e-05
5,506 Beyond Equi-joins: Ranking, Enumeration and Factorization 2021 VLDB 6.0883761e-05
5,802 k-Regret Queries with Nonlinear Utilities 2015 VLDB 5.9728325e-05
5,930 Reverse k-Ranks Query 2014 VLDB 5.9276255e-05
6,224 Efficient Detection of Empty-Result Queries 2006 VLDB 5.828372e-05
6,780 Marrying Top-k with Skyline Queries: Relaxing the Preference Input while Producing Output of Controllable Size 2021 SIGMOD 5.6685383e-05
6,970 Supporting Ranking and Clustering as Generalized Order-By and Group-By 2007 SIGMOD 5.6152718e-05
7,342 Distributed Top-N Query Processing with Possibly Uncooperative Local Systems 2003 VLDB 5.5329816e-05
7,348 Anytime Measures for Top-k Algorithms 2007 VLDB 5.5302579e-05
7,810 On Efficient Top-k Query Processing in Highly Distributed Environments 2008 SIGMOD 5.4322963e-05
8,473 Efficient Top-K Processing Over Query-Dependent Functions 2008 VLDB 5.3148581e-05
8,826 Geometric Approaches for Top-k Queries 2017 VLDB 5.2539334e-05
9,020 Creating Top Ranking Options in the Continuous Option and Preference Space 2019 VLDB 5.2221152e-05
9,207 Determining the Impact Regions of Competing Options in Preference Space 2017 SIGMOD 5.1943724e-05
9,321 A General Framework for Modeling and Processing Optimization Queries 2007 VLDB 5.1825641e-05
9,739 Towards Indexing Functions: Answering Scalar Product Queries 2014 SIGMOD 5.1187707e-05
9,794 A Generic Framework for Handling Uncertain Data with Local Correlations 2011 VLDB 5.115551e-05
10,125 On m-Impact Regions and Standing Top-k Influence Problems 2021 SIGMOD 5.0638787e-05
11,924 tau-LevelIndex: Towards Efficient Query Processing in Continuous Preference Space 2022 SIGMOD 4.9605343e-05
12,671 Answering Top-k Queries Over a Mixture of Attractive and Repulsive Dimensions 2012 VLDB 4.9605343e-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.0019892478
44 The R+-Tree: A Dynamic Multi-Dimensional Index for Objects 1987 VLDB 0.00045231517
72 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.00037421163
170 Combining Fuzzy Information from Multiple Systems 1996 PODS 0.0002707332
344 The Onion Technique: Indexing for Linear Optimization Queries 2000 SIGMOD 0.00020463118
413 Fuzzy Queries in Multimedia Database Systems 1998 PODS 0.00018638335
534 Answering Recursive Queries Using Views 1997 PODS 0.0001677412
567 Answering Queries with Aggregation Using Views 1996 VLDB 0.00016228477
882 Rewriting Aggregate Queries Using Views 1999 PODS 0.00013239752
1,162 A Framework for Expressing and Combining Preferences 2000 SIGMOD 0.00011729702
2,140 Query Rewriting for Semistructured Data 1999 SIGMOD 8.9688891e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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