{"id":"https://openalex.org/W1964773105","doi":"https://doi.org/10.1145/1529282.1529633","title":"CPref-SQL: a query language supporting conditional preferences","display_name":"CPref-SQL: a query language supporting conditional preferences","publication_year":2009,"publication_date":"2009-03-08","ids":{"openalex":"https://openalex.org/W1964773105","doi":"https://doi.org/10.1145/1529282.1529633","mag":"1964773105"},"language":"en","primary_location":{"id":"doi:10.1145/1529282.1529633","doi":"https://doi.org/10.1145/1529282.1529633","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1529282.1529633","pdf_url":null,"source":{"id":"https://openalex.org/S4306417581","display_name":"ACM Symposium on Applied Computing","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 ACM symposium on Applied Computing","raw_type":"proceedings-article"},"volume":null,"type":"conference-paper","is_traditional":true,"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/A5113628057","display_name":"Sandra de Amo","orcid":"https://orcid.org/0000-0001-5734-2595","observed_orcids":["https://orcid.org/0000-0001-5734-2595"]},"institutions":[{"id":"https://openalex.org/I80850581","display_name":"Universidade Federal de Uberl\u00e2ndia","ror":"https://ror.org/04x3wvr31","country_code":"BR","type":"education","lineage":["https://openalex.org/I80850581"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Sandra de Amo","raw_affiliation_strings":["Federal University of Uberlandia, Uberlandia, Brazil"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Federal University of Uberlandia, Uberlandia, Brazil","institution_ids":["https://openalex.org/I80850581"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5017091427","display_name":"Marcos Roberto Ribeiro","orcid":"https://orcid.org/0000-0001-5331-8360","observed_orcids":["https://orcid.org/0000-0001-5331-8360"]},"institutions":[{"id":"https://openalex.org/I80850581","display_name":"Universidade Federal de Uberl\u00e2ndia","ror":"https://ror.org/04x3wvr31","country_code":"BR","type":"education","lineage":["https://openalex.org/I80850581"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Marcos Roberto Ribeiro","raw_affiliation_strings":["Federal University of Uberlandia, Uberlandia, Brazil"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Federal University of Uberlandia, Uberlandia, Brazil","institution_ids":["https://openalex.org/I80850581"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I80850581"],"apc_list":null,"apc_paid":null,"fwci":1.0872,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.75869525,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"1573","last_page":"1577"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.5952000021934509,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.5952000021934509,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.25999999046325684,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.054999999701976776,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/preference-queries","display_name":"preference queries","score":0.7110000252723694},{"id":"https://openalex.org/keywords/preference-inference","display_name":"preference inference","score":0.5899999737739563},{"id":"https://openalex.org/keywords/sql-extension","display_name":"SQL extension","score":0.621999979019165},{"id":"https://openalex.org/keywords/database-query-languages","display_name":"database query languages","score":0.41200000047683716}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8116565942764282},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6736530661582947},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5085448026657104},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.49784111976623535},{"id":"https://openalex.org/C171018156","wikidata":"https://www.wikidata.org/wiki/Q7370306","display_name":"Rotation formalisms in three dimensions","level":2,"score":0.46781420707702637},{"id":"https://openalex.org/C2781249084","wikidata":"https://www.wikidata.org/wiki/Q908656","display_name":"Preference","level":2,"score":0.4677484333515167},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.41529732942581177},{"id":"https://openalex.org/C73301696","wikidata":"https://www.wikidata.org/wiki/Q5469984","display_name":"Formalism (music)","level":3,"score":0.41302090883255005},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.35446667671203613},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.341339111328125},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.24063551425933838},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.1163274347782135},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.09432041645050049},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"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/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C558565934","wikidata":"https://www.wikidata.org/wiki/Q2743","display_name":"Musical","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1529282.1529633","doi":"https://doi.org/10.1145/1529282.1529633","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1529282.1529633","pdf_url":null,"source":{"id":"https://openalex.org/S4306417581","display_name":"ACM Symposium on Applied Computing","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 ACM symposium on Applied Computing","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":16,"referenced_works":["https://openalex.org/W1501488077","https://openalex.org/W2002699418","https://openalex.org/W2019002417","https://openalex.org/W2027939084","https://openalex.org/W2033933009","https://openalex.org/W2092251403","https://openalex.org/W2114660707","https://openalex.org/W2120130223","https://openalex.org/W2122317131","https://openalex.org/W2122871448","https://openalex.org/W2126500482","https://openalex.org/W2148009266","https://openalex.org/W2165150232","https://openalex.org/W2170188482","https://openalex.org/W2221389368","https://openalex.org/W4235794864"],"related_works":["https://openalex.org/W2290159233","https://openalex.org/W2610689010","https://openalex.org/W2503127377","https://openalex.org/W1501488077","https://openalex.org/W2404499668","https://openalex.org/W7061215538","https://openalex.org/W2400818018","https://openalex.org/W1969304716","https://openalex.org/W3080581444","https://openalex.org/W2168089964"],"abstract_inverted_index":{"Nowadays,":[0],"the":[1,40,57,61,65,68],"need":[2],"for":[3],"incorporating":[4],"preference":[5,49,79,113,121,132],"querying":[6],"in":[7,15,39,56,64,74,81,114],"database":[8,44,66],"technology":[9],"is":[10],"a":[11,16,95,103,128,135],"very":[12],"important":[13],"issue":[14],"variety":[17],"of":[18,29,131],"applications":[19],"ranging":[20],"from":[21],"e-commerce":[22],"to":[23,36,83,93,108,116,126],"personalized":[24,85],"search":[25],"engines.":[26],"A":[27],"lot":[28],"recent":[30],"research":[31],"work":[32],"has":[33,70],"been":[34,54,71],"dedicated":[35],"this":[37,89],"topic":[38],"artificial":[41],"intelligence":[42],"and":[43,51,110],"communities.":[45],"Several":[46],"formalisms":[47],"allowing":[48],"reasoning":[50],"specification":[52],"have":[53],"proposed":[55],"AI":[58],"field.":[59],"On":[60],"other":[62],"hand,":[63],"field":[67],"interest":[69],"focused":[72],"mainly":[73],"extending":[75],"standard":[76],"SQL":[77,118],"with":[78,112,119,134],"facilities":[80],"order":[82,115],"provide":[84],"query":[86],"answering.":[87],"In":[88],"paper,":[90],"we":[91],"propose":[92],"build":[94],"bridge":[96],"between":[97],"these":[98],"two":[99],"approaches,":[100],"by":[101],"using":[102],"logic":[104],"formalism":[105],"originally":[106],"designed":[107],"specify":[109],"reason":[111],"extend":[117],"conditional":[120],"constructors.":[122],"Such":[123],"constructors":[124],"allow":[125],"express":[127],"large":[129],"class":[130],"statements":[133],"ceteris-paribus":[136],"semantics.":[137]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2026-11-12T12:28:57.059296","created_date":"2016-06-24T00:00:00"}