{"id":"https://openalex.org/W2163101220","doi":"https://doi.org/10.1145/1645953.1646157","title":"Semantic queries in databases","display_name":"Semantic queries in databases","publication_year":2009,"publication_date":"2009-11-02","ids":{"openalex":"https://openalex.org/W2163101220","doi":"https://doi.org/10.1145/1645953.1646157","mag":"2163101220"},"language":"en","primary_location":{"id":"doi:10.1145/1645953.1646157","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1645953.1646157","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 18th ACM conference on Information and knowledge management","raw_type":"proceedings-article"},"type":"conference-paper","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/A5109215836","display_name":"Lipyeow Lim","orcid":null},"institutions":[{"id":"https://openalex.org/I117965899","display_name":"University of Hawai\u02bbi at M\u0101noa","ror":"https://ror.org/01wspgy28","country_code":"US","type":"education","lineage":["https://openalex.org/I117965899"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Lipyeow Lim","raw_affiliation_strings":["University of Hawaii at Manoa, Honolulu, HI, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Hawaii at Manoa, Honolulu, HI, USA","institution_ids":["https://openalex.org/I117965899"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063351917","display_name":"Haixun Wang","orcid":"https://orcid.org/0009-0007-0773-7004"},"institutions":[{"id":"https://openalex.org/I4210113369","display_name":"Microsoft Research Asia (China)","ror":"https://ror.org/0300m5276","country_code":"CN","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210113369"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Haixun Wang","raw_affiliation_strings":["Microsoft Research, Beijing, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Research, Beijing, China","institution_ids":["https://openalex.org/I4210113369"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100340921","display_name":"Min Wang","orcid":"https://orcid.org/0000-0002-5160-7852"},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Min Wang","raw_affiliation_strings":["IBM Research, Hawthorne, NY, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Research, Hawthorne, NY, USA","institution_ids":["https://openalex.org/I1341412227"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.4622,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.83649003,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1505","last_page":"1508"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9998000264167786,"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"}},"topics":[{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9998000264167786,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9980000257492065,"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/T11106","display_name":"Data Management and Algorithms","score":0.9954000115394592,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8755083680152893},{"id":"https://openalex.org/keywords/ontology","display_name":"Ontology","score":0.616460382938385},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.6033572554588318},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5823602080345154},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5577685832977295},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5467771291732788},{"id":"https://openalex.org/keywords/upper-ontology","display_name":"Upper ontology","score":0.5203670859336853},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4981050491333008},{"id":"https://openalex.org/keywords/ontology-based-data-integration","display_name":"Ontology-based data integration","score":0.4488971531391144},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.41239798069000244},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3249151110649109},{"id":"https://openalex.org/keywords/semantic-web","display_name":"Semantic Web","score":0.2698656916618347}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8755083680152893},{"id":"https://openalex.org/C25810664","wikidata":"https://www.wikidata.org/wiki/Q44325","display_name":"Ontology","level":2,"score":0.616460382938385},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.6033572554588318},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5823602080345154},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5577685832977295},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5467771291732788},{"id":"https://openalex.org/C78726541","wikidata":"https://www.wikidata.org/wiki/Q3882785","display_name":"Upper ontology","level":3,"score":0.5203670859336853},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4981050491333008},{"id":"https://openalex.org/C22550185","wikidata":"https://www.wikidata.org/wiki/Q7095047","display_name":"Ontology-based data integration","level":3,"score":0.4488971531391144},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.41239798069000244},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3249151110649109},{"id":"https://openalex.org/C2129575","wikidata":"https://www.wikidata.org/wiki/Q54837","display_name":"Semantic Web","level":2,"score":0.2698656916618347},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1645953.1646157","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1645953.1646157","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 18th ACM conference on Information and knowledge management","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4","score":0.4099999964237213}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W75991065","https://openalex.org/W161650195","https://openalex.org/W1548256243","https://openalex.org/W1572990282","https://openalex.org/W1762649963","https://openalex.org/W1817764486","https://openalex.org/W1915685105","https://openalex.org/W2000254854","https://openalex.org/W2038765730","https://openalex.org/W2066580290","https://openalex.org/W2103219113","https://openalex.org/W2160582691","https://openalex.org/W3010155376"],"related_works":["https://openalex.org/W2376314740","https://openalex.org/W1970676791","https://openalex.org/W2393185060","https://openalex.org/W2132457496","https://openalex.org/W2115982234","https://openalex.org/W2574819720","https://openalex.org/W2361207232","https://openalex.org/W3013849046","https://openalex.org/W2769449313","https://openalex.org/W2119615165"],"abstract_inverted_index":{"Supporting":[0],"semantic":[1,127],"queries":[2,67,91,128],"in":[3,19,72,80,129,169],"relational":[4,26,48,74,130,141],"databases":[5,131],"is":[6,62,186],"essential":[7],"to":[8,65,125,137,148,156],"many":[9,81],"advanced":[10],"applications.":[11],"Recently,":[12],"with":[13,29,50,132,194],"the":[14,22,44,57,73,154,165,176,179,184,190,195],"increasing":[15],"use":[16],"of":[17,46,112,135,161,192],"ontology":[18,32,71,88,139],"various":[20],"applications,":[21],"need":[23],"for":[24],"querying":[25,47],"data":[27,49,84],"together":[28],"its":[30,51,86],"related":[31,87],"has":[33,168],"become":[34],"more":[35],"urgent.":[36],"In":[37],"this":[38],"paper,":[39],"we":[40,152],"identify":[41],"and":[42,78,85,110,143,183],"discuss":[43],"problem":[45,58],"ontologies.":[52],"Two":[53],"fundamental":[54],"challenges":[55],"make":[56],"interesting.":[59],"First,":[60],"it":[61],"extremely":[63],"difficult":[64],"express":[66,149],"against":[68],"graph":[69],"structured":[70],"query":[75,115,166,181],"language":[76,146],"SQL,":[77],"second,":[79],"cases":[82],"where":[83],"are":[89,92],"complicated,":[90],"usually":[93],"not":[94],"precise,":[95],"that":[96,122,163],"is,":[97],"users":[98],"often":[99],"have":[100],"only":[101],"a":[102,107,119,158],"vague":[103],"notion,":[104],"rather":[105],"than":[106],"clear":[108],"understanding":[109],"definition,":[111],"what":[113],"they":[114],"for.":[116],"We":[117],"outline":[118],"query-by-example":[120],"approach":[121],"enables":[123],"us":[124],"support":[126],"ease.":[133],"Instead":[134],"endeavoring":[136],"incorporate":[138],"into":[140],"form":[142],"create":[144],"new":[145],"constructs":[147],"such":[150],"queries,":[151],"ask":[153],"user":[155,185],"provide":[157],"small":[159],"number":[160],"examples":[162,173],"satisfy":[164],"she":[167],"mind.":[170],"Using":[171],"these":[172],"as":[174],"seeds,":[175],"system":[177],"infers":[178],"exact":[180],"automatically,":[182],"therefore":[187],"shielded":[188],"from":[189],"complexity":[191],"interfacing":[193],"ontology.":[196]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":4}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}