Nothing Special   »   [go: up one dir, main page]

skip to main content
10.1145/2213836.2213927acmconferencesArticle/Chapter ViewAbstractPublication PagesmodConference Proceedingsconference-collections
demonstration

PrefDB: bringing preferences closer to the DBMS

Published: 20 May 2012 Publication History

Abstract

In this demonstration we present a preference-aware relational query answering system, termed PrefDB. The key novelty of PrefDB is the use of an extended relational data model and algebra that allow expressing different flavors of preferential queries. Furthermore, unlike existing approaches that either treat the DBMS as a black box or require modifications of the database core, PrefDB's hybrid implementation enables operator-level query optimizations without being obtrusive to the database engine. We showcase the flexibility and efficiency of PrefDB using PrefDBAdmin, a graphical tool that we have built aiming at assisting application designers in the task of building, testing and tuning queries with preferences.

References

[1]
IMDB movie database. http://www.imdb.com.
[2]
A. Arvanitis and G. Koutrika. Towards preference-aware relational databases. In ICDE, 2012 (to appear).
[3]
J. Chomicki. Preference formulas in relational queries. TODS, 28(4):427--466, 2003.
[4]
W. Kießling and G. Köstler. Preference SQL - design, implementation, experiences. In VLDB, pages 990--1001, 2002.
[5]
G. Koutrika and Y. E. Ioannidis. Personalization of queries in database systems. In ICDE, pages 597--608, 2004.
[6]
J. Levandoski, M. Mokbel, and M. Khalefa. FlexPref: A framework for extensible preference evaluation in database systems. In ICDE, pages 828--839, 2010.
[7]
C. Li, K. C.-C. Chang, I. F. Ilyas, and S. Song. RankSQL: Query algebra and optimization for relational top-k queries. In SIGMOD, pages 131--142, 2005.

Cited By

View all
  • (2014)PrefDBIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2013.2826:6(1430-1446)Online publication date: 1-Jun-2014
  • (2014)Taxonomy-based relaxation of query answering in relational databasesThe VLDB Journal — The International Journal on Very Large Data Bases10.1007/s00778-013-0350-x23:5(747-769)Online publication date: 1-Oct-2014

Index Terms

  1. PrefDB: bringing preferences closer to the DBMS

    Recommendations

    Comments

    Please enable JavaScript to view thecomments powered by Disqus.

    Information & Contributors

    Information

    Published In

    cover image ACM Conferences
    SIGMOD '12: Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data
    May 2012
    886 pages
    ISBN:9781450312479
    DOI:10.1145/2213836
    Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

    Sponsors

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 20 May 2012

    Permissions

    Request permissions for this article.

    Check for updates

    Author Tags

    1. preferences
    2. query personalization

    Qualifiers

    • Demonstration

    Conference

    SIGMOD/PODS '12
    Sponsor:

    Acceptance Rates

    SIGMOD '12 Paper Acceptance Rate 48 of 289 submissions, 17%;
    Overall Acceptance Rate 785 of 4,003 submissions, 20%

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • Downloads (Last 12 months)3
    • Downloads (Last 6 weeks)0
    Reflects downloads up to 18 Nov 2024

    Other Metrics

    Citations

    Cited By

    View all
    • (2014)PrefDBIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2013.2826:6(1430-1446)Online publication date: 1-Jun-2014
    • (2014)Taxonomy-based relaxation of query answering in relational databasesThe VLDB Journal — The International Journal on Very Large Data Bases10.1007/s00778-013-0350-x23:5(747-769)Online publication date: 1-Oct-2014

    View Options

    Login options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Media

    Figures

    Other

    Tables

    Share

    Share

    Share this Publication link

    Share on social media