Preference SQL - Design, Implementation, Experiences

Summary: Preference SQL extends SQL with a partial-order preference model and Pareto/skyline operators for soft constraints. The optimizer rewrites preferences into SQL for cross-platform deployment and reports experiences in m-commerce and a large-scale job portal. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 8917
Venue: VLDB
Year: 2002
Pagerank: 0.00014557349
Overall Rank: 1,030 | 92.84%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Werner Kießling
2. Gerhard Köstler

Incoming Citations (Sorted by Pagerank)

Showing 13 of 13 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
427	Automated Ranking of Database Query Results	2003	CIDR	0.0002352637
707	Foundations of Preferences in Database Systems	2002	VLDB	0.00017782998
1,998	Discovering Relative Importance of Skyline Attributes	2009	VLDB	9.824482e-05
2,866	Stratified Computation of Skylines with Partially-Ordered Domains	2005	SIGMOD	7.9844444e-05
4,564	Learning User Preferences By Adaptive Pairwise Comparison	2015	VLDB	6.0819005e-05
5,299	Efficient Approximation of Optimization Queries Under Parametric Aggregation Constraints	2003	VLDB	5.5796719e-05
5,834	Efficient Detection of Empty-Result Queries	2006	VLDB	5.3103189e-05
7,136	Distributed Top-N Query Processing with Possibly Uncooperative Local Systems	2003	VLDB	4.8220711e-05
8,793	PAQO: A Preference-Aware Query Optimizer for PostgreSQL	2013	VLDB	4.4505944e-05
9,452	Output-sensitive Evaluation of Prioritized Skyline Queries	2015	SIGMOD	4.339214e-05
11,190	Efficient and Effective Cardinality Estimation for Skyline Family	2023	SIGMOD	4.1945683e-05
11,869	SI2P: A Restaurant Recommendation System Using Preference Queries over Incomplete Information	2016	VLDB	4.1945683e-05
12,123	PrefDB: Bringing Preferences Closer to the DBMS	2012	SIGMOD	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 4 of 4 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
262	Efficient Progressive Skyline Computation	2001	VLDB	0.00029987552
465	PREFER: A System for the Efficient Execution of Multiparametric Ranked Queries	2001	SIGMOD	0.00022455702
707	Foundations of Preferences in Database Systems	2002	VLDB	0.00017782998
1,080	A Framework for Expressing and Combining Preferences	2000	SIGMOD	0.00014217619

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
2,346	Multi-objective Query Processing for Database Systems	2004	VLDB	8.9919258e-05
11,503	Preference Queries over Taxonomic Domains	2021	VLDB	4.1945683e-05
4,803	A System for Management and Analysis of Preference Data	2014	VLDB	5.9107061e-05
1,080	A Framework for Expressing and Combining Preferences	2000	SIGMOD	0.00014217619
13,281	Supporting Hard Queries over Probabilistic Preferences	2020	VLDB	-
12,248	A Demonstration of FlexPref: Extensible Preference Evaluation Inside the DBMS Engine	2010	SIGMOD	4.1945683e-05
4,515	Preferences: Putting More Knowledge into Queries	1987	VLDB	6.1192913e-05
12,123	PrefDB: Bringing Preferences Closer to the DBMS	2012	SIGMOD	4.1945683e-05
465	PREFER: A System for the Efficient Execution of Multiparametric Ranked Queries	2001	SIGMOD	0.00022455702
707	Foundations of Preferences in Database Systems	2002	VLDB	0.00017782998