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: 9108
Venue: VLDB
Year: 2002
Pagerank: 0.00011117197
Overall Rank: 1,338 | 90.83%
DOI: 10.1016/B978-155860869-6/50098-6

Incoming Non-self Citations Over Time

Authors

1. Werner Kießling (University of Augsburg)
2. Gerhard Köstler (Intershop Communications)

BibTeX Citation

@article{kieling_vldb02,
        title = {{Preference SQL - Design, Implementation, Experiences}},
        author = {Kießling, Werner and Köstler, Gerhard},
        journal = {PVLDB},
        series = {{VLDB} '02},
        doi = {10.1016/B978-155860869-6/50098-6},
        url = {https://doi.org/10.1016/B978-155860869-6/50098-6},
        year = {2002}
}

Incoming Citations (Sorted by Pagerank)

Showing 13 of 13 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
466	Automated Ranking of Database Query Results	2003	CIDR	0.00018014467
656	Foundations of Preferences in Database Systems	2002	VLDB	0.00015258172
1,938	Discovering Relative Importance of Skyline Attributes	2009	VLDB	9.4514785e-05
2,516	Stratified Computation of Skylines with Partially-Ordered Domains	2005	SIGMOD	8.4773324e-05
3,984	Learning User Preferences By Adaptive Pairwise Comparison	2015	VLDB	6.9739437e-05
5,164	Efficient Approximation of Optimization Queries Under Parametric Aggregation Constraints	2003	VLDB	6.3372067e-05
6,084	Efficient Detection of Empty-Result Queries	2006	VLDB	5.9830699e-05
7,177	Distributed Top-N Query Processing with Possibly Uncooperative Local Systems	2003	VLDB	5.6806091e-05
8,804	PAQO: A Preference-Aware Query Optimizer for PostgreSQL	2013	VLDB	5.3683187e-05
9,192	Efficient and Effective Cardinality Estimation for Skyline Family	2023	SIGMOD	5.3058708e-05
9,524	Output-sensitive Evaluation of Prioritized Skyline Queries	2015	SIGMOD	5.2555551e-05
12,070	SI2P: A Restaurant Recommendation System Using Preference Queries over Incomplete Information	2016	VLDB	5.093636e-05
12,320	PrefDB: Bringing Preferences Closer to the DBMS	2012	SIGMOD	5.093636e-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
243	Efficient Progressive Skyline Computation	2001	VLDB	0.00023495903
407	PREFER: A System for the Efficient Execution of Multiparametric Ranked Queries	2001	SIGMOD	0.00019021441
656	Foundations of Preferences in Database Systems	2002	VLDB	0.00015258172
1,134	A Framework for Expressing and Combining Preferences	2000	SIGMOD	0.00012035449

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,932	Multi-objective Query Processing for Database Systems	2004	VLDB
2	11,701	Preference Queries over Taxonomic Domains	2021	VLDB
3	7,642	A System for Management and Analysis of Preference Data	2014	VLDB
4	1,134	A Framework for Expressing and Combining Preferences	2000	SIGMOD
5	13,483	Supporting Hard Queries over Probabilistic Preferences	2020	VLDB
6	12,443	A Demonstration of FlexPref: Extensible Preference Evaluation Inside the DBMS Engine	2010	SIGMOD
7	5,256	Preferences: Putting More Knowledge into Queries	1987	VLDB
8	12,320	PrefDB: Bringing Preferences Closer to the DBMS	2012	SIGMOD
9	407	PREFER: A System for the Efficient Execution of Multiparametric Ranked Queries	2001	SIGMOD
10	656	Foundations of Preferences in Database Systems	2002	VLDB