{"id":"https://openalex.org/W2060511402","doi":"https://doi.org/10.1145/1871437.1871619","title":"OLAP-based query recommendation","display_name":"OLAP-based query recommendation","publication_year":2010,"publication_date":"2010-10-26","ids":{"openalex":"https://openalex.org/W2060511402","doi":"https://doi.org/10.1145/1871437.1871619","mag":"2060511402"},"language":"en","primary_location":{"id":"doi:10.1145/1871437.1871619","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1871437.1871619","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 19th ACM international 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/A5035134339","display_name":"Carlos Garcia-Alvarado","orcid":"https://orcid.org/0000-0002-9595-3861"},"institutions":[{"id":"https://openalex.org/I44461941","display_name":"University of Houston","ror":"https://ror.org/048sx0r50","country_code":"US","type":"education","lineage":["https://openalex.org/I44461941"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Carlos Garcia-Alvarado","raw_affiliation_strings":["University of Houston, Houston, TX, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Houston, Houston, TX, USA","institution_ids":["https://openalex.org/I44461941"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5079572598","display_name":"Zhibo Chen","orcid":"https://orcid.org/0000-0002-8525-5066"},"institutions":[{"id":"https://openalex.org/I44461941","display_name":"University of Houston","ror":"https://ror.org/048sx0r50","country_code":"US","type":"education","lineage":["https://openalex.org/I44461941"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zhibo Chen","raw_affiliation_strings":["University of Houston, Houston, TX, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Houston, Houston, TX, USA","institution_ids":["https://openalex.org/I44461941"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5031610238","display_name":"Carlos Ordo\u0144\u1ebdz","orcid":"https://orcid.org/0009-0005-1135-9726"},"institutions":[{"id":"https://openalex.org/I44461941","display_name":"University of Houston","ror":"https://ror.org/048sx0r50","country_code":"US","type":"education","lineage":["https://openalex.org/I44461941"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Carlos Ordonez","raw_affiliation_strings":["University of Houston, Houston, TX, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Houston, Houston, TX, USA","institution_ids":["https://openalex.org/I44461941"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I44461941"],"apc_list":null,"apc_paid":null,"fwci":2.7089,"has_fulltext":false,"cited_by_count":9,"citation_normalized_percentile":{"value":0.90562683,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1353","last_page":"1356"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9991000294685364,"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.9991000294685364,"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/T10203","display_name":"Recommender Systems and Techniques","score":0.9955999851226807,"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"}},{"id":"https://openalex.org/T10286","display_name":"Information Retrieval and Search Behavior","score":0.9916999936103821,"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/online-analytical-processing","display_name":"Online analytical processing","score":0.9384338855743408},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8553335666656494},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.7920385599136353},{"id":"https://openalex.org/keywords/sampling","display_name":"Sampling (signal processing)","score":0.5443013906478882},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.536376953125},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.5359896421432495},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.49410179257392883},{"id":"https://openalex.org/keywords/simple","display_name":"Simple (philosophy)","score":0.49123042821884155},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.47884654998779297},{"id":"https://openalex.org/keywords/a-priori-and-a-posteriori","display_name":"A priori and a posteriori","score":0.4481852054595947},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.4422873854637146},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.3067872226238251},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.30275335907936096}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.9384338855743408},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8553335666656494},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.7920385599136353},{"id":"https://openalex.org/C140779682","wikidata":"https://www.wikidata.org/wiki/Q210868","display_name":"Sampling (signal processing)","level":3,"score":0.5443013906478882},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.536376953125},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.5359896421432495},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.49410179257392883},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.49123042821884155},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.47884654998779297},{"id":"https://openalex.org/C75553542","wikidata":"https://www.wikidata.org/wiki/Q178161","display_name":"A priori and a posteriori","level":2,"score":0.4481852054595947},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.4422873854637146},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3067872226238251},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.30275335907936096},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C106131492","wikidata":"https://www.wikidata.org/wiki/Q3072260","display_name":"Filter (signal processing)","level":2,"score":0.0},{"id":"https://openalex.org/C31972630","wikidata":"https://www.wikidata.org/wiki/Q844240","display_name":"Computer vision","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1871437.1871619","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1871437.1871619","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 19th ACM international conference on Information and knowledge management","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W1966901553","https://openalex.org/W2027437447","https://openalex.org/W2052628356","https://openalex.org/W2071304174","https://openalex.org/W2121382017","https://openalex.org/W2130183999","https://openalex.org/W2137682733","https://openalex.org/W2146717104","https://openalex.org/W2171161922","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","https://openalex.org/W2363019959","https://openalex.org/W6138692","https://openalex.org/W1535822977","https://openalex.org/W23190051","https://openalex.org/W2367419170","https://openalex.org/W2377387014","https://openalex.org/W2382180329","https://openalex.org/W2375394542"],"abstract_inverted_index":{"Query":[0],"recommendation":[1],"is":[2,115],"an":[3,33,85,186],"invaluable":[4],"tool":[5],"for":[6,20,41,88],"enabling":[7],"users":[8,43],"to":[9,37,125,156,184],"speed":[10],"up":[11],"their":[12,78],"searches.":[13],"In":[14,64],"this":[15],"paper,":[16],"we":[17],"present":[18,82],"algorithms":[19,72],"generating":[21],"query":[22,39],"suggestions,":[23],"assuming":[24],"no":[25],"previous":[26],"knowledge":[27],"of":[28,48,70,77,102],"the":[29,42,46,49,52,56,59,62,106,109,119,142,162,172,179],"collection.":[30,63],"We":[31,80,95],"developed":[32],"online":[34,112],"OLAP":[35,113,145],"algorithm":[36,114,122],"generate":[38],"suggestions":[40],"based":[44],"on":[45,178],"frequency":[47],"keywords":[50,60],"in":[51,61,134,171],"selected":[53],"documents":[54],"and":[55,67,123,153,164,182],"correlation":[57],"between":[58,108,151],"addition,":[65],"performance":[66,90],"scalability":[68],"experiments":[69],"these":[71],"are":[73],"presented":[74],"as":[75,84,99],"proof":[76],"feasibility.":[79],"also":[81,116],"sampling":[83,168],"additional":[86],"approach":[87],"improving":[89],"by":[91],"using":[92,105],"approximate":[93],"results.":[94],"show":[96],"valid":[97],"recommendations":[98],"a":[100,138,147,175,190],"result":[101],"combinations":[103],"generated":[104],"correlations":[107],"keywords.":[110,140],"The":[111],"compared":[117],"with":[118,137,189],"well-known":[120],"Apriori":[121],"found":[124],"be":[126,185],"faster":[127],"only":[128],"when":[129],"simple":[130],"computations":[131],"were":[132],"performed":[133],"smaller":[135],"collections":[136],"few":[139,191],"On":[141],"other":[143],"hand,":[144],"showed":[146,169],"more":[148,158],"stable":[149],"behavior":[150],"collections,":[152],"allows":[154],"us":[155],"have":[157],"complex":[159],"policies":[160],"during":[161],"aggregation":[163],"term":[165],"combinations.":[166],"Additionally,":[167],"improvement":[170],"time":[173],"without":[174],"significant":[176],"change":[177],"suggested":[180],"queries,":[181],"proved":[183],"accurate":[187],"alternative":[188],"small":[192],"samples.":[193]},"counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2012,"cited_by_count":5}],"updated_date":"2026-06-26T08:34:08.712188","created_date":"2025-10-10T00:00:00"}