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: hdd948301ce366523
Venue: VLDB
Year: 2002
Pagerank: 0.00010871114
Overall Rank: 1,377 | 90.75%
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
474	Automated Ranking of Database Query Results	2003	CIDR	0.00017672562
671	Foundations of Preferences in Database Systems	2002	VLDB	0.00014929237
1,990	Discovering Relative Importance of Skyline Attributes	2009	VLDB	9.2454758e-05
2,566	Stratified Computation of Skylines with Partially-Ordered Domains	2005	SIGMOD	8.288424e-05
4,082	Learning User Preferences By Adaptive Pairwise Comparison	2015	VLDB	6.8176001e-05
5,269	Efficient Approximation of Optimization Queries Under Parametric Aggregation Constraints	2003	VLDB	6.2014805e-05
6,208	Efficient Detection of Empty-Result Queries	2006	VLDB	5.8497045e-05
7,320	Distributed Top-N Query Processing with Possibly Uncooperative Local Systems	2003	VLDB	5.5538431e-05
8,965	PAQO: A Preference-Aware Query Optimizer for PostgreSQL	2013	VLDB	5.2478925e-05
9,372	Efficient and Effective Cardinality Estimation for Skyline Family	2023	SIGMOD	5.1868213e-05
9,701	Output-sensitive Evaluation of Prioritized Skyline Queries	2015	SIGMOD	5.1381851e-05
12,363	SI2P: A Restaurant Recommendation System Using Preference Queries over Incomplete Information	2016	VLDB	4.9793485e-05
12,611	PrefDB: Bringing Preferences Closer to the DBMS	2012	SIGMOD	4.9793485e-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
256	Efficient Progressive Skyline Computation	2001	VLDB	0.00022981799
418	PREFER: A System for the Efficient Execution of Multiparametric Ranked Queries	2001	SIGMOD	0.00018617842
671	Foundations of Preferences in Database Systems	2002	VLDB	0.00014929237
1,158	A Framework for Expressing and Combining Preferences	2000	SIGMOD	0.00011772275

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,996	Multi-objective Query Processing for Database Systems	2004	VLDB
2	12,006	Preference Queries over Taxonomic Domains	2021	VLDB
3	7,795	A System for Management and Analysis of Preference Data	2014	VLDB
4	1,158	A Framework for Expressing and Combining Preferences	2000	SIGMOD
5	13,797	Supporting Hard Queries over Probabilistic Preferences	2020	VLDB
6	12,734	A Demonstration of FlexPref: Extensible Preference Evaluation Inside the DBMS Engine	2010	SIGMOD
7	5,372	Preferences: Putting More Knowledge into Queries	1987	VLDB
8	12,611	PrefDB: Bringing Preferences Closer to the DBMS	2012	SIGMOD
9	418	PREFER: A System for the Efficient Execution of Multiparametric Ranked Queries	2001	SIGMOD
10	671	Foundations of Preferences in Database Systems	2002	VLDB