{"id":"https://openalex.org/W2168976073","doi":"https://doi.org/10.1145/2000824.2000829","title":"A survey on representation, composition and application of preferences in database systems","display_name":"A survey on representation, composition and application of preferences in database systems","publication_year":2011,"publication_date":"2011-08-01","ids":{"openalex":"https://openalex.org/W2168976073","doi":"https://doi.org/10.1145/2000824.2000829","mag":"2168976073"},"language":"en","primary_location":{"id":"doi:10.1145/2000824.2000829","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2000824.2000829","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5042740371","display_name":"Kostas Stefanidis","orcid":"https://orcid.org/0000-0003-1317-8062"},"institutions":[{"id":"https://openalex.org/I177725633","display_name":"Chinese University of Hong Kong","ror":"https://ror.org/00t33hh48","country_code":"HK","type":"education","lineage":["https://openalex.org/I177725633"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Kostas Stefanidis","raw_affiliation_strings":["Chinese University of Hong Kong, Hong Kong"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Chinese University of Hong Kong, Hong Kong","institution_ids":["https://openalex.org/I177725633"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5012623045","display_name":"Georgia Koutrika","orcid":"https://orcid.org/0000-0002-7377-0116"},"institutions":[{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Georgia Koutrika","raw_affiliation_strings":["IBM Almaden Research Center"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center","institution_ids":["https://openalex.org/I4210085935"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5047515620","display_name":"Evaggelia Pitoura","orcid":"https://orcid.org/0000-0002-3775-4995"},"institutions":[{"id":"https://openalex.org/I194019607","display_name":"University of Ioannina","ror":"https://ror.org/01qg3j183","country_code":"GR","type":"education","lineage":["https://openalex.org/I194019607"]}],"countries":["GR"],"is_corresponding":false,"raw_author_name":"Evaggelia Pitoura","raw_affiliation_strings":["University of Ioannina, Ioannina, Greece"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Ioannina, Ioannina, Greece","institution_ids":["https://openalex.org/I194019607"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":21.1088,"has_fulltext":false,"cited_by_count":136,"citation_normalized_percentile":{"value":0.99677731,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":100},"biblio":{"volume":"36","issue":"3","first_page":"1","last_page":"45"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9969000220298767,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11596","display_name":"Constraint Satisfaction and Optimization","score":0.9923999905586243,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8257172107696533},{"id":"https://openalex.org/keywords/perspective","display_name":"Perspective (graphical)","score":0.7390974164009094},{"id":"https://openalex.org/keywords/preference","display_name":"Preference","score":0.6746362447738647},{"id":"https://openalex.org/keywords/representation","display_name":"Representation (politics)","score":0.5576589703559875},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5534442663192749},{"id":"https://openalex.org/keywords/database-theory","display_name":"Database theory","score":0.4867801368236542},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4820064604282379},{"id":"https://openalex.org/keywords/composition","display_name":"Composition (language)","score":0.45474833250045776},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4511812925338745},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.4496144652366638},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.42816266417503357},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.3349917531013489},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.23729756474494934}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8257172107696533},{"id":"https://openalex.org/C12713177","wikidata":"https://www.wikidata.org/wiki/Q1900281","display_name":"Perspective (graphical)","level":2,"score":0.7390974164009094},{"id":"https://openalex.org/C2781249084","wikidata":"https://www.wikidata.org/wiki/Q908656","display_name":"Preference","level":2,"score":0.6746362447738647},{"id":"https://openalex.org/C2776359362","wikidata":"https://www.wikidata.org/wiki/Q2145286","display_name":"Representation (politics)","level":3,"score":0.5576589703559875},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5534442663192749},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.4867801368236542},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4820064604282379},{"id":"https://openalex.org/C40231798","wikidata":"https://www.wikidata.org/wiki/Q1333743","display_name":"Composition (language)","level":2,"score":0.45474833250045776},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4511812925338745},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4496144652366638},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.42816266417503357},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.3349917531013489},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.23729756474494934},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C94625758","wikidata":"https://www.wikidata.org/wiki/Q7163","display_name":"Politics","level":2,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C175444787","wikidata":"https://www.wikidata.org/wiki/Q39072","display_name":"Microeconomics","level":1,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/2000824.2000829","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2000824.2000829","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.297.4808","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.297.4808","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.uoi.gr/~pitoura/distribution/tods11.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.707.3346","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.707.3346","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://users.ics.forth.gr/%7Ekstef/docs/tods11.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","id":"https://metadata.un.org/sdg/16","score":0.7400000095367432}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":129,"referenced_works":["https://openalex.org/W29392426","https://openalex.org/W90634997","https://openalex.org/W96699891","https://openalex.org/W97884140","https://openalex.org/W114019344","https://openalex.org/W115861246","https://openalex.org/W602980269","https://openalex.org/W1501488077","https://openalex.org/W1510817841","https://openalex.org/W1521226446","https://openalex.org/W1525228843","https://openalex.org/W1527862858","https://openalex.org/W1551818730","https://openalex.org/W1576835806","https://openalex.org/W1580205347","https://openalex.org/W1580944449","https://openalex.org/W1600378142","https://openalex.org/W1600580971","https://openalex.org/W1618166823","https://openalex.org/W1809222622","https://openalex.org/W1835538174","https://openalex.org/W1850437073","https://openalex.org/W1856746784","https://openalex.org/W1966010233","https://openalex.org/W1967661515","https://openalex.org/W1972541019","https://openalex.org/W1972685434","https://openalex.org/W1976505338","https://openalex.org/W1993503466","https://openalex.org/W2002699418","https://openalex.org/W2003017965","https://openalex.org/W2006025120","https://openalex.org/W2009688537","https://openalex.org/W2013885128","https://openalex.org/W2014214819","https://openalex.org/W2015342680","https://openalex.org/W2018177083","https://openalex.org/W2019002417","https://openalex.org/W2019565841","https://openalex.org/W2020919487","https://openalex.org/W2024927461","https://openalex.org/W2027752285","https://openalex.org/W2040584916","https://openalex.org/W2041882671","https://openalex.org/W2047221353","https://openalex.org/W2051834357","https://openalex.org/W2061555293","https://openalex.org/W2063244649","https://openalex.org/W2067092194","https://openalex.org/W2068322169","https://openalex.org/W2070475178","https://openalex.org/W2078686663","https://openalex.org/W2086174602","https://openalex.org/W2093087759","https://openalex.org/W2093570553","https://openalex.org/W2093979658","https://openalex.org/W2094320135","https://openalex.org/W2096547754","https://openalex.org/W2096768134","https://openalex.org/W2096898303","https://openalex.org/W2098647484","https://openalex.org/W2100579822","https://openalex.org/W2101390300","https://openalex.org/W2102998034","https://openalex.org/W2104947511","https://openalex.org/W2108699731","https://openalex.org/W2113295349","https://openalex.org/W2113838273","https://openalex.org/W2114660707","https://openalex.org/W2116434582","https://openalex.org/W2116936708","https://openalex.org/W2118708781","https://openalex.org/W2119745643","https://openalex.org/W2120130223","https://openalex.org/W2121612399","https://openalex.org/W2126431245","https://openalex.org/W2126500482","https://openalex.org/W2127003315","https://openalex.org/W2127782281","https://openalex.org/W2129247233","https://openalex.org/W2129521002","https://openalex.org/W2131103246","https://openalex.org/W2131381130","https://openalex.org/W2132867658","https://openalex.org/W2134172828","https://openalex.org/W2134206624","https://openalex.org/W2134644026","https://openalex.org/W2137304183","https://openalex.org/W2138077241","https://openalex.org/W2138271690","https://openalex.org/W2139273822","https://openalex.org/W2140715253","https://openalex.org/W2141137858","https://openalex.org/W2141649964","https://openalex.org/W2143331230","https://openalex.org/W2143682328","https://openalex.org/W2145068111","https://openalex.org/W2147035797","https://openalex.org/W2148292077","https://openalex.org/W2150107436","https://openalex.org/W2150176719","https://openalex.org/W2150693557","https://openalex.org/W2150804723","https://openalex.org/W2153487405","https://openalex.org/W2157149485","https://openalex.org/W2161547991","https://openalex.org/W2162129814","https://openalex.org/W2163119517","https://openalex.org/W2165113460","https://openalex.org/W2166855749","https://openalex.org/W2166916904","https://openalex.org/W2167248071","https://openalex.org/W2168821561","https://openalex.org/W2170188482","https://openalex.org/W2170896764","https://openalex.org/W2171960770","https://openalex.org/W2172118809","https://openalex.org/W2174235632","https://openalex.org/W2249418430","https://openalex.org/W3101685505","https://openalex.org/W3145072800","https://openalex.org/W4211002515","https://openalex.org/W4254335296","https://openalex.org/W4300491437","https://openalex.org/W6603943499","https://openalex.org/W6632219655","https://openalex.org/W6674506788","https://openalex.org/W6675223770","https://openalex.org/W7074725593"],"related_works":["https://openalex.org/W584886505","https://openalex.org/W1989645082","https://openalex.org/W1502610062","https://openalex.org/W2168681435","https://openalex.org/W2607324466","https://openalex.org/W1560442284","https://openalex.org/W2027162968","https://openalex.org/W4298247711","https://openalex.org/W2105333333","https://openalex.org/W2895113758"],"abstract_inverted_index":{"Preferences":[0],"have":[1,18,94],"been":[2,95],"traditionally":[3],"studied":[4],"in":[5,24,69,86,120,134],"philosophy,":[6],"psychology,":[7],"and":[8,10,50,66,122,148],"economics":[9],"applied":[11],"to":[12,43,112,127],"decision":[13],"making":[14],"problems.":[15],"Recently,":[16],"they":[17,31],"attracted":[19],"the":[20,44,56,87],"attention":[21],"of":[22,46,89,101,108],"researchers":[23,133],"other":[25],"fields,":[26],"such":[27],"as":[28,129],"databases":[29],"where":[30],"capture":[32],"soft":[33],"criteria":[34],"for":[35,116,132],"queries.":[36,91],"Databases":[37],"bring":[38],"a":[39,53,73,98,114,130],"whole":[40],"fresh":[41],"perspective":[42,121],"study":[45,100,140],"preferences,":[47],"both":[48],"computational":[49,74],"representational.":[51],"From":[52,72],"representational":[54],"perspective,":[55,75],"central":[57],"question":[58],"is":[59,104,111],"how":[60,80],"we":[61,76,81],"can":[62,77,82],"effectively":[63],"represent":[64],"preferences":[65,85],"incorporate":[67],"them":[68],"database":[70,90,135],"querying.":[71],"look":[78],"at":[79],"efficiently":[83],"process":[84],"context":[88],"Several":[92],"approaches":[93],"proposed":[96],"but":[97],"systematic":[99],"these":[102],"works":[103,119],"missing.":[105],"The":[106],"purpose":[107],"this":[109],"survey":[110],"provide":[113],"framework":[115],"placing":[117],"existing":[118],"highlight":[123],"critical":[124],"open":[125],"challenges":[126],"serve":[128],"springboard":[131],"systems.":[136],"We":[137],"organize":[138],"our":[139],"around":[141],"three":[142],"axes:":[143],"preference":[144,146,149],"representation,":[145],"composition,":[147],"query":[150],"processing.":[151]},"counts_by_year":[{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":6},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":6},{"year":2018,"cited_by_count":7},{"year":2017,"cited_by_count":14},{"year":2016,"cited_by_count":11},{"year":2015,"cited_by_count":22},{"year":2014,"cited_by_count":25},{"year":2013,"cited_by_count":19},{"year":2012,"cited_by_count":12}],"updated_date":"2026-08-26T07:47:46.906454","created_date":"2025-10-10T00:00:00"}