{"id":"https://openalex.org/W2159454657","doi":"https://doi.org/10.1145/1559845.1559917","title":"Keyword search in databases","display_name":"Keyword search in databases","publication_year":2009,"publication_date":"2009-06-29","ids":{"openalex":"https://openalex.org/W2159454657","doi":"https://doi.org/10.1145/1559845.1559917","mag":"2159454657"},"language":"en","primary_location":{"id":"doi:10.1145/1559845.1559917","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1559845.1559917","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 ACM SIGMOD International Conference on Management of data","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/A5046220908","display_name":"Lu Qin","orcid":"https://orcid.org/0000-0001-6068-5062"},"institutions":[{"id":"https://openalex.org/I177725633","display_name":"Chinese University of Hong Kong","ror":"https://ror.org/00t33hh48","country_code":"CN","type":"education","lineage":["https://openalex.org/I177725633"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Lu Qin","raw_affiliation_strings":["The Chinese University of Hong Kong, Hong Kong, China"],"affiliations":[{"raw_affiliation_string":"The Chinese University of Hong Kong, Hong Kong, China","institution_ids":["https://openalex.org/I177725633"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075642293","display_name":"Jeffrey Xu Yu","orcid":"https://orcid.org/0000-0002-9738-827X"},"institutions":[{"id":"https://openalex.org/I177725633","display_name":"Chinese University of Hong Kong","ror":"https://ror.org/00t33hh48","country_code":"CN","type":"education","lineage":["https://openalex.org/I177725633"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jeffrey Xu Yu","raw_affiliation_strings":["The Chinese University of Hong Kong, Hong Kong, China"],"affiliations":[{"raw_affiliation_string":"The Chinese University of Hong Kong, Hong Kong, China","institution_ids":["https://openalex.org/I177725633"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5037530341","display_name":"Lijun Chang","orcid":"https://orcid.org/0000-0002-6830-3900"},"institutions":[{"id":"https://openalex.org/I177725633","display_name":"Chinese University of Hong Kong","ror":"https://ror.org/00t33hh48","country_code":"CN","type":"education","lineage":["https://openalex.org/I177725633"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Lijun Chang","raw_affiliation_strings":["The Chinese University of Hong Kong, Hong Kong, China"],"affiliations":[{"raw_affiliation_string":"The Chinese University of Hong Kong, Hong Kong, China","institution_ids":["https://openalex.org/I177725633"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5046220908"],"corresponding_institution_ids":["https://openalex.org/I177725633"],"apc_list":null,"apc_paid":null,"fwci":22.9709,"has_fulltext":false,"cited_by_count":129,"citation_normalized_percentile":{"value":0.9967789,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"681","last_page":"694"},"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.9997000098228455,"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.9997000098228455,"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.9987000226974487,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.995199978351593,"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/tuple","display_name":"Tuple","score":0.8470175266265869},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.801924467086792},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.7128937244415283},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6927579045295715},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.619522750377655},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.49274399876594543},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.44661468267440796},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.4404970109462738},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.42744386196136475},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.41050541400909424},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.34677523374557495},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.14683428406715393},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.1424959897994995},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.12598314881324768}],"concepts":[{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.8470175266265869},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.801924467086792},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.7128937244415283},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6927579045295715},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.619522750377655},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.49274399876594543},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.44661468267440796},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.4404970109462738},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.42744386196136475},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.41050541400909424},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.34677523374557495},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.14683428406715393},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.1424959897994995},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.12598314881324768}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1559845.1559917","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1559845.1559917","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 ACM SIGMOD International Conference on Management of data","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":35,"referenced_works":["https://openalex.org/W1523307303","https://openalex.org/W1538786304","https://openalex.org/W1539585011","https://openalex.org/W1970709149","https://openalex.org/W1981585544","https://openalex.org/W1989944922","https://openalex.org/W1990223473","https://openalex.org/W1991271936","https://openalex.org/W1996668544","https://openalex.org/W2015372451","https://openalex.org/W2070032453","https://openalex.org/W2096076988","https://openalex.org/W2098388305","https://openalex.org/W2098416578","https://openalex.org/W2106105896","https://openalex.org/W2107105629","https://openalex.org/W2117461391","https://openalex.org/W2121350579","https://openalex.org/W2121832290","https://openalex.org/W2143361337","https://openalex.org/W2147491059","https://openalex.org/W2148942721","https://openalex.org/W2151912509","https://openalex.org/W2153485419","https://openalex.org/W2158237121","https://openalex.org/W2162162443","https://openalex.org/W2162833734","https://openalex.org/W2164858177","https://openalex.org/W2165150232","https://openalex.org/W2169624745","https://openalex.org/W2171874178","https://openalex.org/W2294626234","https://openalex.org/W2951321531","https://openalex.org/W6649757190","https://openalex.org/W6684375356"],"related_works":["https://openalex.org/W3030674916","https://openalex.org/W1982455124","https://openalex.org/W1575529579","https://openalex.org/W2476511644","https://openalex.org/W2898886863","https://openalex.org/W2505630977","https://openalex.org/W3022423983","https://openalex.org/W316061934","https://openalex.org/W1988380406","https://openalex.org/W41949812"],"abstract_inverted_index":{"Keyword":[0],"search":[1,13],"in":[2,18,33,67,135,188],"relational":[3,120,150],"databases":[4],"(RDBs)":[5],"has":[6],"been":[7],"extensively":[8],"studied":[9],"recently.":[10],"A":[11],"keyword":[12,16],"(or":[14],"a":[15,23,82,92,96,103,117,136,146,162,177],"query)":[17],"RDBs":[19],"is":[20,114,171],"specified":[21],"by":[22],"set":[24,118],"of":[25,60,86,119,140,149,157],"keywords":[26,55],"to":[27,81,115,145,154,172],"explore":[28],"the":[29,50,53,106,158,181],"interconnected":[30,71,182],"tuple":[31,72,94,183],"structures":[32,73,184],"an":[34,68,131,141,174],"RDB":[35,175],"that":[36,88],"cannot":[37],"be":[38,75],"easily":[39],"identified":[40],"using":[41,128,185],"SQL":[42,129],"on":[43,130,138],"RDBMS.":[44],"In":[45,105],"brief,":[46],"it":[47],"finds":[48],"how":[49],"tuples":[51,66,87],"containing":[52],"given":[54],"are":[56,89,109],"connected":[57,78],"via":[58],"sequences":[59],"connections":[61],"(foreign":[62],"key":[63],"references)":[64],"among":[65],"RDB.":[69],"Such":[70],"can":[74],"found":[76],"as":[77,176],"trees":[79],"up":[80],"certain":[83],"size,":[84],"sets":[85],"reachable":[90],"from":[91],"root":[93],"within":[95,102],"radius,":[97],"or":[98,134],"even":[99],"multi-center":[100],"subgraphs":[101],"radius.":[104],"literature,":[107],"there":[108],"two":[110],"main":[111],"approaches.":[112],"One":[113],"generate":[116],"algebra":[121,151],"expressions":[122,152],"and":[123,179],"evaluate":[124],"every":[125],"such":[126],"expression":[127],"RDBMS":[132,142],"directly":[133],"middleware":[137,163],"top":[139],"indirectly.":[143],"Due":[144],"large":[147],"number":[148],"needed":[153],"process,":[155],"most":[156],"existing":[159],"works":[160],"take":[161],"approach":[164],"without":[165],"fully":[166],"utilizing":[167],"RDBMSs.":[168],"The":[169],"other":[170],"materialize":[173],"graph":[178],"find":[180],"graph-based":[186],"algorithms":[187],"memory.":[189]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":6},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":5},{"year":2015,"cited_by_count":10},{"year":2014,"cited_by_count":14},{"year":2013,"cited_by_count":11},{"year":2012,"cited_by_count":25}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}