{"id":"https://openalex.org/W2121907031","doi":"https://doi.org/10.1145/1645953.1646143","title":"Structure-aware indexing for keyword search in databases","display_name":"Structure-aware indexing for keyword search in databases","publication_year":2009,"publication_date":"2009-11-02","ids":{"openalex":"https://openalex.org/W2121907031","doi":"https://doi.org/10.1145/1645953.1646143","mag":"2121907031"},"language":"en","primary_location":{"id":"doi:10.1145/1645953.1646143","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1645953.1646143","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":"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/A5100451576","display_name":"Guoliang Li","orcid":"https://orcid.org/0000-0002-1398-0621"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Guoliang Li","raw_affiliation_strings":["Tsinghua University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100951661","display_name":"Jianhua Feng","orcid":null},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jianhua Feng","raw_affiliation_strings":["Tsinghua University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100630868","display_name":"Jianyong Wang","orcid":"https://orcid.org/0000-0002-7555-170X"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jianyong Wang","raw_affiliation_strings":["Tsinghua University, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5100451576"],"corresponding_institution_ids":["https://openalex.org/I99065089"],"apc_list":null,"apc_paid":null,"fwci":1.4284,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.81438992,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"1453","last_page":"1456"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998000264167786,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998000264167786,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.998199999332428,"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/tuple","display_name":"Tuple","score":0.9300161600112915},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7836811542510986},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.5762797594070435},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5620499849319458},{"id":"https://openalex.org/keywords/keyword-search","display_name":"Keyword search","score":0.5343714356422424},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.46580153703689575},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4464266002178192},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.43119585514068604},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.42131370306015015},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.34015846252441406},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.14547550678253174},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.09178587794303894}],"concepts":[{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.9300161600112915},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7836811542510986},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.5762797594070435},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5620499849319458},{"id":"https://openalex.org/C2988412617","wikidata":"https://www.wikidata.org/wiki/Q7441656","display_name":"Keyword search","level":2,"score":0.5343714356422424},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.46580153703689575},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4464266002178192},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.43119585514068604},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.42131370306015015},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.34015846252441406},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.14547550678253174},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.09178587794303894},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1645953.1646143","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1645953.1646143","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"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.184.8450","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.184.8450","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://dbgroup.cs.tsinghua.edu.cn/ligl/papers/cikm2009-saint.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":8,"referenced_works":["https://openalex.org/W1981585544","https://openalex.org/W2096076988","https://openalex.org/W2098388305","https://openalex.org/W2117461391","https://openalex.org/W2121350579","https://openalex.org/W2132745220","https://openalex.org/W2149531250","https://openalex.org/W2169624745"],"related_works":["https://openalex.org/W4245395944","https://openalex.org/W2143551613","https://openalex.org/W2138823233","https://openalex.org/W1979740464","https://openalex.org/W2143345456","https://openalex.org/W119841348","https://openalex.org/W2057416894","https://openalex.org/W316061934","https://openalex.org/W4312445213","https://openalex.org/W2328984678"],"abstract_inverted_index":{"Most":[0],"of":[1,4,15,52],"existing":[2],"methods":[3,70,186],"keyword":[5,78,97,108,129],"search":[6,179],"over":[7],"relational":[8],"databases":[9],"find":[10],"the":[11,19,23,28,36,137,145,149,156,170],"Steiner":[12,24],"trees":[13,25],"composed":[14,51],"relevant":[16,54,158],"tuples":[17,55],"as":[18,86],"answers.":[20,159],"They":[21],"identify":[22,71,155],"by":[26],"discovering":[27],"rich":[29],"structural":[30,40,138],"relationships":[31,41,139],"between":[32,140],"tuples,":[33],"and":[34,45,67,135,153,169,181,183],"neglect":[35],"fact":[37],"that":[38,49,174],"such":[39],"can":[42,64],"be":[43,65,104],"pre-computed":[44],"indexed.":[46,68],"Tuple":[47,62],"units":[48,63,102,125,143],"are":[50,56],"most":[53],"proposed":[57],"to":[58,76,106,120,126,151],"address":[59,111],"this":[60,112,115],"problem.":[61],"precomputed":[66],"Existing":[69],"a":[72,90,96],"single":[73,91],"tuple":[74,92,101,124,142],"unit":[75,93],"answer":[77,95,107,128],"queries.":[79,109,130],"They,":[80],"however,":[81],"may":[82],"involve":[83],"false":[84],"negatives":[85],"in":[87,114,165],"many":[88],"cases":[89],"cannot":[94],"query.":[98],"Instead,":[99],"multiple":[100,122],"should":[103],"integrated":[105],"To":[110],"problem,":[113],"paper,":[116],"we":[117],"study":[118],"how":[119],"integrate":[121],"related":[123],"effectively":[127],"We":[131,147,160],"devise":[132],"novel":[133],"indices":[134,150],"incorporate":[136],"different":[141],"into":[144],"indices.":[146],"use":[148],"efficiently":[152],"progressively":[154],"top-k":[157],"have":[161],"implemented":[162],"our":[163,175],"method":[164],"real":[166],"database":[167],"systems,":[168],"experimental":[171],"results":[172],"show":[173],"approach":[176],"achieves":[177],"high":[178],"efficiency":[180],"accuracy,":[182],"outperforms":[184],"state-of-the-art":[185],"significantly.":[187]},"counts_by_year":[{"year":2018,"cited_by_count":1},{"year":2014,"cited_by_count":2},{"year":2012,"cited_by_count":2}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}