{"id":377,"date":"2021-01-24T17:30:09","date_gmt":"2021-01-24T16:30:09","guid":{"rendered":"http:\/\/florian-wenzel.net\/?post_type=portfolio&#038;p=377"},"modified":"2021-01-24T17:30:09","modified_gmt":"2021-01-24T16:30:09","slug":"preference-sql","status":"publish","type":"portfolio","link":"https:\/\/florian-wenzel.net\/?portfolio=preference-sql","title":{"rendered":"Preference SQL"},"content":{"rendered":"<p class=\"pv-accomplishment-entity__date t-14\">Sep 2009 \u2013 Feb 2017<\/p>\n<p class=\"pv-accomplishment-entity__description t-14\">Preference SQL is an ongoing research project at the Chair for Databases and Information Systems at the University of Augsburg. It is a Java middleware that connects to any SQL database system and provides a Best-Matches-Only (BMO) search paradigm based on preferences. For this purpose, Standard SQL is extended with a PREFERRING clause to add preferences in the form of strict partial orders as soft constraints.<br \/>\nThe system provides a parser, algebraic and cost-based optimizer, and specialized evaluation algorithms. It integrates into any given application, avoids empty results and mitigates flooding. Furthermore, it adds a means of personalization by providing a rich set of tools for user modeling via preference constructors.<\/p>\n","protected":false},"featured_media":0,"menu_order":2009,"template":"","portfolio_categories":[34],"portfolio_tags":[],"class_list":["post-377","portfolio","type-portfolio","status-publish","hentry","portfolio_categories-projects"],"acf":[],"_links":{"self":[{"href":"https:\/\/florian-wenzel.net\/index.php?rest_route=\/wp\/v2\/portfolio\/377","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/florian-wenzel.net\/index.php?rest_route=\/wp\/v2\/portfolio"}],"about":[{"href":"https:\/\/florian-wenzel.net\/index.php?rest_route=\/wp\/v2\/types\/portfolio"}],"version-history":[{"count":1,"href":"https:\/\/florian-wenzel.net\/index.php?rest_route=\/wp\/v2\/portfolio\/377\/revisions"}],"predecessor-version":[{"id":378,"href":"https:\/\/florian-wenzel.net\/index.php?rest_route=\/wp\/v2\/portfolio\/377\/revisions\/378"}],"wp:attachment":[{"href":"https:\/\/florian-wenzel.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=377"}],"wp:term":[{"taxonomy":"portfolio_categories","embeddable":true,"href":"https:\/\/florian-wenzel.net\/index.php?rest_route=%2Fwp%2Fv2%2Fportfolio_categories&post=377"},{"taxonomy":"portfolio_tags","embeddable":true,"href":"https:\/\/florian-wenzel.net\/index.php?rest_route=%2Fwp%2Fv2%2Fportfolio_tags&post=377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}