Database Paper Browser

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
3275
Venue
SIGMOD
Year
2001
Pagerank
0.00022476798
Overall Rank
464 | 96.78%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 46 of 46 citing papers.

Rank Citing Paper Year Venue Pagerank
278 Efficient IR-Style Keyword Search over Relational Databases 2003 VLDB 0.00029322862
706 Foundations of Preferences in Database Systems 2002 VLDB 0.00017777858
746 An Optimal and Progressive Algorithm for Skyline Queries 2003 SIGMOD 0.00017212135
1,032 Preference SQL - Design, Implementation, Experiences 2002 VLDB 0.00014546409
1,070 Regret-Minimizing Representative Databases 2010 VLDB 0.00014274615
1,093 Minimal Probing: Supporting Expensive Predicates for Top-k Queries 2002 SIGMOD 0.00014123221
1,207 RankSQL: Query Algebra and Optimization for Relational Top-k Queries 2005 SIGMOD 0.0001327437
1,258 Ordering the Attributes of Query Results 2006 SIGMOD 0.00013001902
1,576 Efficient Computation of the Skyline Cube 2005 VLDB 0.00011278557
2,249 Rank-aware Query Optimization 2004 SIGMOD 9.1956569e-05
2,371 Efficient Processing of Top-k Dominating Queries on Multi-Dimensional Data 2007 VLDB 8.9443366e-05
2,604 Integrating DB and IR Technologies: What is the Sound of One Hand Clapping? * 2005 CIDR 8.4628537e-05
2,621 Interactive Regret Minimization 2012 SIGMOD 8.4408945e-05
2,707 FleXPath: Flexible Structure and Full-Text Querying for XML 2004 SIGMOD 8.265158e-05
2,873 Stratified Computation of Skylines with Partially-Ordered Domains 2005 SIGMOD 7.9777806e-05
2,936 Answering Top-k Queries Using Views 2006 VLDB 7.8579393e-05
2,967 Processing a Large Number of Continuous Preference Top-k Queries 2012 SIGMOD 7.7975455e-05
3,100 Answering Why-not Questions on Reverse Top-k Queries 2015 VLDB 7.5625111e-05
3,447 Towards Robust Indexing for Ranked Queries 2006 VLDB 7.082382e-05
3,454 Refreshing the Sky: The Compressed Skycube with Efficient Support for Frequent Updates 2006 SIGMOD 7.0770352e-05
3,665 Ad-hoc Top-k Query Answering for Data Streams 2007 VLDB 6.8631567e-05
3,671 Querying Structured Text in an XML Database 2003 SIGMOD 6.853634e-05
4,556 Learning User Preferences By Adaptive Pairwise Comparison 2015 VLDB 6.0815983e-05
4,718 Answering Top-k Queries with Multi-Dimensional Selections: The Ranking Cube Approach 2006 VLDB 5.9664602e-05
5,074 Branch-and-Bound Algorithm for Reverse Top-k Queries 2013 SIGMOD 5.7113169e-05
5,285 Efficient Approximation of Optimization Queries Under Parametric Aggregation Constraints 2003 VLDB 5.583298e-05
5,839 Why Not Yet: Fixing a Top-k Ranking that Is Not Fair to Individuals 2023 VLDB 5.3073497e-05
5,846 Efficient Detection of Empty-Result Queries 2006 VLDB 5.3052255e-05
5,906 k-Regret Queries with Nonlinear Utilities 2015 VLDB 5.274596e-05
5,963 Beyond Equi-joins: Ranking, Enumeration and Factorization 2021 VLDB 5.2485815e-05
6,219 Reverse k-Ranks Query 2014 VLDB 5.1458862e-05
6,656 Supporting Ranking and Clustering as Generalized Order-By and Group-By 2007 SIGMOD 4.9691233e-05
6,988 Marrying Top-k with Skyline Queries: Relaxing the Preference Input while Producing Output of Controllable Size 2021 SIGMOD 4.8665394e-05
7,133 Anytime Measures for Top-k Algorithms 2007 VLDB 4.8175888e-05
7,134 Distributed Top-N Query Processing with Possibly Uncooperative Local Systems 2003 VLDB 4.8174665e-05
7,434 On Efficient Top-k Query Processing in Highly Distributed Environments 2008 SIGMOD 4.7270401e-05
7,966 Efficient Top-K Processing Over Query-Dependent Functions 2008 VLDB 4.6089395e-05
8,581 Geometric Approaches for Top-k Queries 2017 VLDB 4.4874332e-05
8,812 Creating Top Ranking Options in the Continuous Option and Preference Space 2019 VLDB 4.4397776e-05
8,823 Determining the Impact Regions of Competing Options in Preference Space 2017 SIGMOD 4.4372904e-05
8,890 A General Framework for Modeling and Processing Optimization Queries 2007 VLDB 4.4235206e-05
9,377 Towards Indexing Functions: Answering Scalar Product Queries 2014 SIGMOD 4.344689e-05
9,433 A Generic Framework for Handling Uncertain Data with Local Correlations 2011 VLDB 4.3399748e-05
9,754 On m-Impact Regions and Standing Top-k Influence Problems 2021 SIGMOD 4.2856385e-05
11,369 tau-LevelIndex: Towards Efficient Query Processing in Continuous Preference Space 2022 SIGMOD 4.1905499e-05
12,143 Answering Top-k Queries Over a Mixture of Attractive and Repulsive Dimensions 2012 VLDB 4.1905499e-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.0032118946
24 The R+-Tree: A Dynamic Index For Multi-Dimensional Objects 1987 VLDB 0.00083300888
72 Combining Fuzzy Information from Multiple Systems 1996 PODS 0.00058498396
82 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.00054430106
171 Fuzzy Queries in Multimedia Database Systems 1998 PODS 0.00038843975
428 The Onion Technique: Indexing for Linear Optimization Queries 2000 SIGMOD 0.0002349868
533 Answering Recursive Queries Using Views 1997 PODS 0.00020767726
583 Answering Queries with Aggregation Using Views 1996 VLDB 0.00019705383
971 Rewriting Aggregate Queries Using Views 1999 PODS 0.00014915911
1,079 A Framework for Expressing and Combining Preferences 2000 SIGMOD 0.00014219622
2,397 Query Rewriting for Semistructured Data 1999 SIGMOD 8.8888995e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
2,967 Processing a Large Number of Continuous Preference Top-k Queries 2012 SIGMOD 7.7975455e-05
13,294 Supporting Hard Queries over Probabilistic Preferences 2020 VLDB -
9,376 Output-sensitive Evaluation of Prioritized Skyline Queries 2015 SIGMOD 4.344689e-05
1,258 Ordering the Attributes of Query Results 2006 SIGMOD 0.00013001902
1,317 Efficient Processing of Top-k Spatial Preference Queries 2011 VLDB 0.00012615781
8,537 A Query Engine for Probabilistic Preferences 2018 SIGMOD 4.4893996e-05
706 Foundations of Preferences in Database Systems 2002 VLDB 0.00017777858
4,804 A System for Management and Analysis of Preference Data 2014 VLDB 5.906327e-05
1,032 Preference SQL - Design, Implementation, Experiences 2002 VLDB 0.00014546409
12,131 PrefDB: Bringing Preferences Closer to the DBMS 2012 SIGMOD 4.1905499e-05