{"id":"https://openalex.org/W1493773376","doi":"https://doi.org/10.1109/icde.2015.7113302","title":"Meaningful keyword search in relational databases with large and complex schema","display_name":"Meaningful keyword search in relational databases with large and complex schema","publication_year":2015,"publication_date":"2015-04-01","ids":{"openalex":"https://openalex.org/W1493773376","doi":"https://doi.org/10.1109/icde.2015.7113302","mag":"1493773376"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2015.7113302","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2015.7113302","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE 31st International Conference on Data Engineering","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/A5084361876","display_name":"Mehdi Kargar","orcid":"https://orcid.org/0000-0001-6937-3508"},"institutions":[{"id":"https://openalex.org/I192455969","display_name":"York University","ror":"https://ror.org/05fq50484","country_code":"CA","type":"education","lineage":["https://openalex.org/I192455969"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Mehdi Kargar","raw_affiliation_strings":["Department of Electrical Engineering and Computer Science, School of Engineering York University, Lassonde, Toronto, Canada","Department of Electrical Engineering & Computer Science, Lassonde School of Engineering, York University, Toronto, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Electrical Engineering and Computer Science, School of Engineering York University, Lassonde, Toronto, Canada","institution_ids":["https://openalex.org/I192455969"]},{"raw_affiliation_string":"Department of Electrical Engineering & Computer Science, Lassonde School of Engineering, York University, Toronto, Canada","institution_ids":["https://openalex.org/I192455969"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5009394818","display_name":"Aijun An","orcid":"https://orcid.org/0000-0003-1765-5751"},"institutions":[{"id":"https://openalex.org/I192455969","display_name":"York University","ror":"https://ror.org/05fq50484","country_code":"CA","type":"education","lineage":["https://openalex.org/I192455969"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Aijun An","raw_affiliation_strings":["Department of Electrical Engineering and Computer Science, School of Engineering York University, Lassonde, Toronto, Canada","Department of Electrical Engineering & Computer Science, Lassonde School of Engineering, York University, Toronto, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Electrical Engineering and Computer Science, School of Engineering York University, Lassonde, Toronto, Canada","institution_ids":["https://openalex.org/I192455969"]},{"raw_affiliation_string":"Department of Electrical Engineering & Computer Science, Lassonde School of Engineering, York University, Toronto, Canada","institution_ids":["https://openalex.org/I192455969"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5105530330","display_name":"Nick Cercone","orcid":null},"institutions":[{"id":"https://openalex.org/I192455969","display_name":"York University","ror":"https://ror.org/05fq50484","country_code":"CA","type":"education","lineage":["https://openalex.org/I192455969"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Nick Cercone","raw_affiliation_strings":["Department of Electrical Engineering and Computer Science, School of Engineering York University, Lassonde, Toronto, Canada","Department of Electrical Engineering & Computer Science, Lassonde School of Engineering, York University, Toronto, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Electrical Engineering and Computer Science, School of Engineering York University, Lassonde, Toronto, Canada","institution_ids":["https://openalex.org/I192455969"]},{"raw_affiliation_string":"Department of Electrical Engineering & Computer Science, Lassonde School of Engineering, York University, Toronto, Canada","institution_ids":["https://openalex.org/I192455969"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000797802","display_name":"Parke Godfrey","orcid":"https://orcid.org/0000-0002-2082-1864"},"institutions":[{"id":"https://openalex.org/I192455969","display_name":"York University","ror":"https://ror.org/05fq50484","country_code":"CA","type":"education","lineage":["https://openalex.org/I192455969"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Parke Godfrey","raw_affiliation_strings":["Department of Electrical Engineering and Computer Science, School of Engineering York University, Lassonde, Toronto, Canada","Department of Electrical Engineering & Computer Science, Lassonde School of Engineering, York University, Toronto, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Electrical Engineering and Computer Science, School of Engineering York University, Lassonde, Toronto, Canada","institution_ids":["https://openalex.org/I192455969"]},{"raw_affiliation_string":"Department of Electrical Engineering & Computer Science, Lassonde School of Engineering, York University, Toronto, Canada","institution_ids":["https://openalex.org/I192455969"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035817202","display_name":"Jaroslaw Szlichta","orcid":"https://orcid.org/0000-0002-3382-2890"},"institutions":[{"id":"https://openalex.org/I39470171","display_name":"Ontario Tech University","ror":"https://ror.org/016zre027","country_code":"CA","type":"education","lineage":["https://openalex.org/I39470171"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Jaroslaw Szlichta","raw_affiliation_strings":["Faculty of Science, University of Ontario Institute of Technology, Oshawa, Canada","Faculty of Science, University of Ontario Institute of Technology,Oshawa,Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Science, University of Ontario Institute of Technology, Oshawa, Canada","institution_ids":["https://openalex.org/I39470171"]},{"raw_affiliation_string":"Faculty of Science, University of Ontario Institute of Technology,Oshawa,Canada","institution_ids":["https://openalex.org/I39470171"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5071285426","display_name":"Xiaohui Yu","orcid":"https://orcid.org/0000-0001-8170-2327"},"institutions":[{"id":"https://openalex.org/I192455969","display_name":"York University","ror":"https://ror.org/05fq50484","country_code":"CA","type":"education","lineage":["https://openalex.org/I192455969"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Xiaohui Yu","raw_affiliation_strings":["Department of Electrical Engineering and Computer Science, School of Engineering York University, Lassonde, Toronto, Canada","Department of Electrical Engineering & Computer Science, Lassonde School of Engineering, York University, Toronto, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Electrical Engineering and Computer Science, School of Engineering York University, Lassonde, Toronto, Canada","institution_ids":["https://openalex.org/I192455969"]},{"raw_affiliation_string":"Department of Electrical Engineering & Computer Science, Lassonde School of Engineering, York University, Toronto, Canada","institution_ids":["https://openalex.org/I192455969"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.3826,"has_fulltext":false,"cited_by_count":23,"citation_normalized_percentile":{"value":0.89326704,"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":"411","last_page":"422"},"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.9988999962806702,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9988999962806702,"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.9988999962806702,"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/T12016","display_name":"Web Data Mining and Analysis","score":0.9965999722480774,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8424372673034668},{"id":"https://openalex.org/keywords/information-schema","display_name":"Information schema","score":0.7114540338516235},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.6587156057357788},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6214163899421692},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5868273973464966},{"id":"https://openalex.org/keywords/probabilistic-database","display_name":"Probabilistic database","score":0.5471824407577515},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5342055559158325},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.5321048498153687},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.4987194538116455},{"id":"https://openalex.org/keywords/relevance","display_name":"Relevance (law)","score":0.49358904361724854},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.4401310682296753},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.423037588596344},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3710349202156067},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.3530876636505127},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.27949267625808716},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.2634078562259674},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.2566218078136444},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.17507755756378174}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8424372673034668},{"id":"https://openalex.org/C150012506","wikidata":"https://www.wikidata.org/wiki/Q6031185","display_name":"Information schema","level":5,"score":0.7114540338516235},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.6587156057357788},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6214163899421692},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5868273973464966},{"id":"https://openalex.org/C174539288","wikidata":"https://www.wikidata.org/wiki/Q7246853","display_name":"Probabilistic database","level":4,"score":0.5471824407577515},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5342055559158325},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.5321048498153687},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.4987194538116455},{"id":"https://openalex.org/C158154518","wikidata":"https://www.wikidata.org/wiki/Q7310970","display_name":"Relevance (law)","level":2,"score":0.49358904361724854},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.4401310682296753},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.423037588596344},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3710349202156067},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.3530876636505127},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.27949267625808716},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2634078562259674},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.2566218078136444},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.17507755756378174},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"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/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.2015.7113302","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2015.7113302","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE 31st International Conference on Data Engineering","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Partnerships for the goals","score":0.5099999904632568,"id":"https://metadata.un.org/sdg/17"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":33,"referenced_works":["https://openalex.org/W1975675300","https://openalex.org/W1981585544","https://openalex.org/W1983018368","https://openalex.org/W1985514943","https://openalex.org/W1989944922","https://openalex.org/W1998052044","https://openalex.org/W2020539781","https://openalex.org/W2029203225","https://openalex.org/W2032299694","https://openalex.org/W2047705935","https://openalex.org/W2089646370","https://openalex.org/W2096076988","https://openalex.org/W2098388305","https://openalex.org/W2117461391","https://openalex.org/W2117658379","https://openalex.org/W2121350579","https://openalex.org/W2123194427","https://openalex.org/W2125510575","https://openalex.org/W2142472956","https://openalex.org/W2148792468","https://openalex.org/W2148942721","https://openalex.org/W2159454657","https://openalex.org/W2162783807","https://openalex.org/W2162833734","https://openalex.org/W2164858177","https://openalex.org/W2169624745","https://openalex.org/W2171874178","https://openalex.org/W2295428206","https://openalex.org/W2404301904","https://openalex.org/W2950584515","https://openalex.org/W4231916799","https://openalex.org/W4298361997","https://openalex.org/W6685165322"],"related_works":["https://openalex.org/W962397878","https://openalex.org/W2911644013","https://openalex.org/W2406556412","https://openalex.org/W2707736662","https://openalex.org/W2153455914","https://openalex.org/W2185193035","https://openalex.org/W156948967","https://openalex.org/W2585783528","https://openalex.org/W37183439","https://openalex.org/W1851277853"],"abstract_inverted_index":{"Keyword":[0],"search":[1],"over":[2,122,155],"relational":[3],"databases":[4,15,39],"offers":[5],"an":[6],"alternative":[7],"way":[8],"to":[9,11,66,82,105,111,175,185],"SQL":[10,29],"query":[12],"and":[13,42,69,116,157,180],"explore":[14],"that":[16],"is":[17,50,72,90],"effective":[18],"for":[19,38,137],"lay":[20],"users":[21],"who":[22],"may":[23],"not":[24],"be":[25,131],"well":[26],"versed":[27],"in":[28,47,76,119],"or":[30],"the":[31,57,67,70,78,84,97,102,120,123,127,142,159,167,189,192],"database":[32],"schema.":[33],"This":[34,129],"becomes":[35],"more":[36],"pertinent":[37],"with":[40,134],"large":[41],"complex":[43],"schemas.":[44],"An":[45],"answer":[46],"this":[48],"context":[49],"a":[51,146,152,177,182],"join":[52,100],"tree":[53],"spanning":[54],"tuples":[55],"containing":[56],"query's":[58],"keywords.":[59],"As":[60],"there":[61],"are":[62],"potentially":[63],"many":[64],"answers":[65,85],"query,":[68],"user":[71,183],"often":[73],"only":[74],"interested":[75],"seeing":[77],"top-k":[79],"answers,":[80],"how":[81],"rank":[83,106],"based":[86],"on":[87,96],"their":[88],"relevance":[89,98,113],"of":[91,99,114,126,161,169,188,191],"paramount":[92],"importance.":[93],"We":[94,108,140],"focus":[95],"as":[101],"fundamental":[103],"means":[104,110],"answers.":[107,193],"devise":[109],"measure":[112],"relations":[115],"foreign":[117],"keys":[118],"schema":[121],"information":[124],"content":[125],"database.":[128],"can":[130],"done":[132],"offline":[133],"no":[135],"need":[136],"external":[138],"models.":[139],"compare":[141],"proposed":[143],"measures":[144,171],"against":[145,172],"gold":[147],"standard":[148],"we":[149,165],"derive":[150],"from":[151],"real":[153],"workload":[154],"TPC-E":[156],"evaluate":[158],"effectiveness":[160],"our":[162,170],"methods.":[163],"Finally,":[164],"test":[166],"performance":[168],"existing":[173],"techniques":[174],"demonstrate":[176],"marked":[178],"improvement,":[179],"perform":[181],"study":[184],"establish":[186],"naturalness":[187],"ranking":[190]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":5},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}