{"id":"https://openalex.org/W2166306255","doi":"https://doi.org/10.1145/1183614.1183747","title":"Information retrieval from relational databases using semantic queries","display_name":"Information retrieval from relational databases using semantic queries","publication_year":2006,"publication_date":"2006-01-01","ids":{"openalex":"https://openalex.org/W2166306255","doi":"https://doi.org/10.1145/1183614.1183747","mag":"2166306255"},"language":"en","primary_location":{"id":"doi:10.1145/1183614.1183747","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1183614.1183747","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th ACM international conference on Information and knowledge management  - CIKM '06","raw_type":"proceedings-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/A5110500429","display_name":"Anand Ranganathan","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Anand Ranganathan","raw_affiliation_strings":["IBM T.J. Watson Research Center, NY"],"affiliations":[{"raw_affiliation_string":"IBM T.J. Watson Research Center, NY","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100412085","display_name":"Zhen Liu","orcid":"https://orcid.org/0000-0003-1610-2338"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zhen Liu","raw_affiliation_strings":["IBM T.J. Watson Research Center, NY"],"affiliations":[{"raw_affiliation_string":"IBM T.J. Watson Research Center, NY","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5110500429"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.9036,"has_fulltext":false,"cited_by_count":11,"citation_normalized_percentile":{"value":0.81679362,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"820","last_page":"820"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9991999864578247,"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.9991999864578247,"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.9961000084877014,"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.9934999942779541,"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.8191016912460327},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.7690072059631348},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5738714933395386},{"id":"https://openalex.org/keywords/relational-calculus","display_name":"Relational calculus","score":0.4391217529773712},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.37843576073646545},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.35508492588996887}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8191016912460327},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.7690072059631348},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5738714933395386},{"id":"https://openalex.org/C99436015","wikidata":"https://www.wikidata.org/wiki/Q1722436","display_name":"Relational calculus","level":4,"score":0.4391217529773712},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.37843576073646545},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.35508492588996887}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1183614.1183747","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1183614.1183747","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 15th ACM international conference on Information and knowledge management  - CIKM '06","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":41,"referenced_works":["https://openalex.org/W19269161","https://openalex.org/W170090413","https://openalex.org/W186894488","https://openalex.org/W958104571","https://openalex.org/W1481846757","https://openalex.org/W1511167820","https://openalex.org/W1533669818","https://openalex.org/W1553800766","https://openalex.org/W1563943179","https://openalex.org/W1566081901","https://openalex.org/W1599024310","https://openalex.org/W1599136438","https://openalex.org/W1603311785","https://openalex.org/W1762649963","https://openalex.org/W1812636409","https://openalex.org/W1841600705","https://openalex.org/W1847745151","https://openalex.org/W1895933264","https://openalex.org/W1898667154","https://openalex.org/W1911678285","https://openalex.org/W1940888119","https://openalex.org/W1963741421","https://openalex.org/W1966302589","https://openalex.org/W1978799369","https://openalex.org/W1987996059","https://openalex.org/W1999817920","https://openalex.org/W2014123073","https://openalex.org/W2092883046","https://openalex.org/W2094320135","https://openalex.org/W2101491706","https://openalex.org/W2105106523","https://openalex.org/W2109993265","https://openalex.org/W2114561888","https://openalex.org/W2135408592","https://openalex.org/W2155307279","https://openalex.org/W2221284261","https://openalex.org/W2259045331","https://openalex.org/W2278120009","https://openalex.org/W2308408047","https://openalex.org/W2855643225","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2085988990","https://openalex.org/W2005835473","https://openalex.org/W2056340443","https://openalex.org/W60748262","https://openalex.org/W1510134535","https://openalex.org/W2378275298","https://openalex.org/W1487241321","https://openalex.org/W2156787493","https://openalex.org/W4362564457","https://openalex.org/W2767499799"],"abstract_inverted_index":{"Relational":[0],"databases":[1,73],"are":[2,17,82,120],"widely":[3],"used":[4],"today":[5],"as":[6],"a":[7,31,56,100,147],"mechanism":[8],"for":[9,20],"providing":[10],"access":[11],"to":[12,39,77,123],"structured":[13],"data.":[14],"They,":[15],"however,":[16],"not":[18],"suitable":[19],"typical":[21],"information":[22],"finding":[23],"tasks":[24],"of":[25,103,117,139,149],"end":[26],"users.":[27],"There":[28],"is":[29],"often":[30],"semantic":[32,61,79,101],"gap":[33,62],"between":[34],"the":[35,42,49,75,104,124,137],"queries":[36,43,80,95],"users":[37],"want":[38],"express":[40,93],"and":[41,106,127,151],"that":[44,58,81,119],"can":[45],"be":[46],"answered":[47],"by":[48],"database.":[50],"In":[51],"this":[52,60],"paper,":[53],"we":[54],"propose":[55],"system":[57,70,131,141],"bridges":[59],"using":[63,146],"domain":[64],"knowledge":[65],"contained":[66],"in":[67,84,96],"ontologies.":[68,153],"Our":[69],"extends":[71],"relational":[72,144],"with":[74],"ability":[76],"answer":[78],"represented":[83],"SPARQL,":[85,97],"an":[86],"emerging":[87],"Semantic":[88],"Web":[89],"query":[90,126],"language.":[91],"Users":[92],"their":[94],"based":[98],"on":[99,142],"model":[102],"data,":[105],"they":[107],"get":[108],"back":[109],"semantically":[110,121],"relevant":[111,122],"results.":[112,134],"We":[113,135],"define":[114],"different":[115],"categories":[116],"results":[118],"users'":[125],"show":[128],"how":[129],"our":[130,140],"retrieves":[132],"these":[133],"evaluate":[136],"performance":[138],"sample":[143],"databases,":[145],"combination":[148],"standard":[150],"custom":[152]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1}],"updated_date":"2026-02-25T23:00:34.991745","created_date":"2025-10-10T00:00:00"}