{"id":"https://openalex.org/W1966404343","doi":"https://doi.org/10.4018/jdwm.2012100103","title":"Efficient and Effective Aggregate Keyword Search on Relational Databases","display_name":"Efficient and Effective Aggregate Keyword Search on Relational Databases","publication_year":2012,"publication_date":"2012-10-01","ids":{"openalex":"https://openalex.org/W1966404343","doi":"https://doi.org/10.4018/jdwm.2012100103","mag":"1966404343"},"language":"en","primary_location":{"id":"doi:10.4018/jdwm.2012100103","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdwm.2012100103","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","raw_type":"journal-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/A5101907540","display_name":"Luping Li","orcid":"https://orcid.org/0009-0008-9121-9126"},"institutions":[{"id":"https://openalex.org/I98301712","display_name":"Baidu (China)","ror":"https://ror.org/03vs3wt56","country_code":"CN","type":"company","lineage":["https://openalex.org/I98301712"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Luping Li","raw_affiliation_strings":["Baidu, Inc., Beijing, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Baidu, Inc., Beijing, China","institution_ids":["https://openalex.org/I98301712"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5046976898","display_name":"Stephen Petschulat","orcid":null},"institutions":[{"id":"https://openalex.org/I3129535883","display_name":"Coquitlam College","ror":"https://ror.org/020r4kx11","country_code":"CA","type":"education","lineage":["https://openalex.org/I3129535883"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Stephen Petschulat","raw_affiliation_strings":["SAP Business Objects, Coquitlam, BC, Canada","SAP Business Objects, Coquitlam, BC, Canada#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SAP Business Objects, Coquitlam, BC, Canada","institution_ids":["https://openalex.org/I3129535883"]},{"raw_affiliation_string":"SAP Business Objects, Coquitlam, BC, Canada#TAB#","institution_ids":["https://openalex.org/I3129535883"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5051046852","display_name":"Guanting Tang","orcid":null},"institutions":[{"id":"https://openalex.org/I18014758","display_name":"Simon Fraser University","ror":"https://ror.org/0213rcc28","country_code":"CA","type":"education","lineage":["https://openalex.org/I18014758"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Guanting Tang","raw_affiliation_strings":["School of Computing Science, Simon Fraser University, Burnaby, BC, Canada","School of Computing Science, Simon Fraser University, Burnaby BC, Canada#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computing Science, Simon Fraser University, Burnaby, BC, Canada","institution_ids":["https://openalex.org/I18014758"]},{"raw_affiliation_string":"School of Computing Science, Simon Fraser University, Burnaby BC, Canada#TAB#","institution_ids":["https://openalex.org/I18014758"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5062247330","display_name":"Jian Pei","orcid":"https://orcid.org/0000-0002-2200-8711"},"institutions":[{"id":"https://openalex.org/I18014758","display_name":"Simon Fraser University","ror":"https://ror.org/0213rcc28","country_code":"CA","type":"education","lineage":["https://openalex.org/I18014758"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Jian Pei","raw_affiliation_strings":["School of Computing Science, Simon Fraser University, Burnaby, BC, Canada","School of Computing Science, Simon Fraser University, Burnaby BC, Canada#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computing Science, Simon Fraser University, Burnaby, BC, Canada","institution_ids":["https://openalex.org/I18014758"]},{"raw_affiliation_string":"School of Computing Science, Simon Fraser University, Burnaby BC, Canada#TAB#","institution_ids":["https://openalex.org/I18014758"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5071758024","display_name":"Wo-Shun Luk","orcid":null},"institutions":[{"id":"https://openalex.org/I18014758","display_name":"Simon Fraser University","ror":"https://ror.org/0213rcc28","country_code":"CA","type":"education","lineage":["https://openalex.org/I18014758"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Wo-Shun Luk","raw_affiliation_strings":["School of Computing Science, Simon Fraser University, Burnaby, BC, Canada","School of Computing Science, Simon Fraser University, Burnaby BC, Canada#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computing Science, Simon Fraser University, Burnaby, BC, Canada","institution_ids":["https://openalex.org/I18014758"]},{"raw_affiliation_string":"School of Computing Science, Simon Fraser University, Burnaby BC, Canada#TAB#","institution_ids":["https://openalex.org/I18014758"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.2477,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.51040283,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":"8","issue":"4","first_page":"41","last_page":"81"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"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.9998999834060669,"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.9991000294685364,"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.995199978351593,"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.8530856966972351},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.8452746868133545},{"id":"https://openalex.org/keywords/ranking","display_name":"Ranking (information retrieval)","score":0.7975939512252808},{"id":"https://openalex.org/keywords/keyword-search","display_name":"Keyword search","score":0.7688335180282593},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6783539652824402},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5821996927261353},{"id":"https://openalex.org/keywords/keyword-density","display_name":"Keyword density","score":0.4788525104522705},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4613478481769562},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.39233821630477905}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8530856966972351},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.8452746868133545},{"id":"https://openalex.org/C189430467","wikidata":"https://www.wikidata.org/wiki/Q7293293","display_name":"Ranking (information retrieval)","level":2,"score":0.7975939512252808},{"id":"https://openalex.org/C2988412617","wikidata":"https://www.wikidata.org/wiki/Q7441656","display_name":"Keyword search","level":2,"score":0.7688335180282593},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6783539652824402},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5821996927261353},{"id":"https://openalex.org/C57560718","wikidata":"https://www.wikidata.org/wiki/Q125627","display_name":"Keyword density","level":3,"score":0.4788525104522705},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4613478481769562},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.39233821630477905},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.4018/jdwm.2012100103","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdwm.2012100103","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.300.147","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.300.147","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.sfu.ca/~jpei/publications/Aggregate Keyword Search.pdf","raw_type":"text"},{"id":"pmh:oai:RePEc:igg:jdwm00:v:8:y:2012:i:4:p:41-81","is_oa":false,"landing_page_url":"https://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/jdwm.2012100103","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320334593","display_name":"Natural Sciences and Engineering Research Council of Canada","ror":"https://ror.org/01h531d29"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W95284390","https://openalex.org/W183716681","https://openalex.org/W1482214997","https://openalex.org/W1539585011","https://openalex.org/W1965667542","https://openalex.org/W1968339675","https://openalex.org/W1971684273","https://openalex.org/W1978394996","https://openalex.org/W2009688537","https://openalex.org/W2022480405","https://openalex.org/W2036385401","https://openalex.org/W2075657963","https://openalex.org/W2080240668","https://openalex.org/W2092103580","https://openalex.org/W2098388305","https://openalex.org/W2105481243","https://openalex.org/W2121350579","https://openalex.org/W2132087752","https://openalex.org/W2132701924","https://openalex.org/W2141737314","https://openalex.org/W2157076923","https://openalex.org/W2169624745","https://openalex.org/W2666600683","https://openalex.org/W3035692968","https://openalex.org/W4300945981","https://openalex.org/W6628905179"],"related_works":["https://openalex.org/W1496822620","https://openalex.org/W2197440050","https://openalex.org/W2614415116","https://openalex.org/W2265184183","https://openalex.org/W2466354565","https://openalex.org/W2011694694","https://openalex.org/W2084064431","https://openalex.org/W1603257948","https://openalex.org/W4308714738","https://openalex.org/W1964343189"],"abstract_inverted_index":{"Keyword":[0],"search":[1,18,37,97],"on":[2,19,42,98],"relational":[3,20,44,100],"databases":[4,21],"is":[5],"useful":[6],"and":[7,24,74,92,109,119],"popular":[8],"for":[9],"many":[10],"users":[11],"without":[12],"technical":[13],"background.":[14],"Recently,":[15],"aggregate":[16,35,61,95],"keyword":[17,36,62,96],"was":[22],"proposed":[23],"has":[25,64],"attracted":[26],"interest.":[27],"However,":[28],"two":[29,86],"important":[30],"problems":[31,87],"still":[32],"remain.":[33],"First,":[34],"can":[38],"be":[39],"very":[40],"costly":[41],"large":[43,99],"databases,":[45],"partly":[46],"due":[47],"to":[48,59,88],"the":[49,56,71,75,82,90],"lack":[50],"of":[51,94],"efficient":[52,76,105,121],"indexes.":[53],"Second,":[54],"finding":[55],"top-k":[57],"answers":[58],"an":[60,120],"query":[63],"not":[65],"been":[66],"addressed":[67],"systematically,":[68],"including":[69],"both":[70,107],"ranking":[72,117,122],"model":[73,118],"evaluation":[77,130],"methods.":[78],"In":[79],"this":[80],"paper,":[81],"authors":[83,113],"tackle":[84],"these":[85],"improve":[89],"efficiency":[91],"effectiveness":[93],"databases.":[101],"They":[102,124],"designed":[103],"indexes":[104],"in":[106],"size":[108],"construction":[110],"time.":[111],"The":[112],"propose":[114],"a":[115,127],"general":[116],"algorithm.":[123],"also":[125],"report":[126],"systematic":[128],"performance":[129],"using":[131],"real":[132],"data":[133],"sets.":[134]},"counts_by_year":[{"year":2017,"cited_by_count":2},{"year":2015,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}