{"id":"https://openalex.org/W4387848894","doi":"https://doi.org/10.1145/3583780.3614731","title":"A Data-Driven Index Recommendation System for Slow Queries","display_name":"A Data-Driven Index Recommendation System for Slow Queries","publication_year":2023,"publication_date":"2023-10-21","ids":{"openalex":"https://openalex.org/W4387848894","doi":"https://doi.org/10.1145/3583780.3614731"},"language":"en","primary_location":{"id":"doi:10.1145/3583780.3614731","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3583780.3614731","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 32nd 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/A5072606426","display_name":"Gan Peng","orcid":null},"institutions":[{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Gan Peng","raw_affiliation_strings":["East China Normal University, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"East China Normal University, Shanghai, China","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102848994","display_name":"Peng Cai","orcid":"https://orcid.org/0009-0006-7468-7695"},"institutions":[{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Peng Cai","raw_affiliation_strings":["East China Normal University, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"East China Normal University, Shanghai, China","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5012886320","display_name":"Kaikai Ye","orcid":"https://orcid.org/0009-0008-4100-5859"},"institutions":[{"id":"https://openalex.org/I66867065","display_name":"East China Normal University","ror":"https://ror.org/02n96ep67","country_code":"CN","type":"education","lineage":["https://openalex.org/I66867065"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Kaikai Ye","raw_affiliation_strings":["East China Normal University, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"East China Normal University, Shanghai, China","institution_ids":["https://openalex.org/I66867065"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101641017","display_name":"Kai Li","orcid":"https://orcid.org/0009-0009-5885-3114"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kai Li","raw_affiliation_strings":["Meituan, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"Meituan, Shanghai, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101545294","display_name":"Jinlong Cai","orcid":"https://orcid.org/0009-0003-5669-1808"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jinlong Cai","raw_affiliation_strings":["Meituan, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"Meituan, Shanghai, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064157254","display_name":"Yufeng Shen","orcid":"https://orcid.org/0009-0002-4439-5801"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yufeng Shen","raw_affiliation_strings":["Meituan, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"Meituan, Shanghai, China","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101544169","display_name":"Han Su","orcid":"https://orcid.org/0009-0001-9408-0472"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Han Su","raw_affiliation_strings":["Meituan, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"Meituan, Shanghai, China","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5072606426"],"corresponding_institution_ids":["https://openalex.org/I66867065"],"apc_list":null,"apc_paid":null,"fwci":0.3903,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.57697539,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"5086","last_page":"5090"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"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"}},"topics":[{"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9980000257492065,"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/T12761","display_name":"Data Stream Mining Techniques","score":0.9973999857902527,"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/computer-science","display_name":"Computer science","score":0.8470957279205322},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.6858432292938232},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.6154061555862427},{"id":"https://openalex.org/keywords/construct","display_name":"Construct (python library)","score":0.5717808604240417},{"id":"https://openalex.org/keywords/service","display_name":"Service (business)","score":0.5122200846672058},{"id":"https://openalex.org/keywords/the-internet","display_name":"The Internet","score":0.5108644366264343},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4917745888233185},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.49030521512031555},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4413532018661499},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.3141452670097351}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8470957279205322},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.6858432292938232},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.6154061555862427},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.5717808604240417},{"id":"https://openalex.org/C2780378061","wikidata":"https://www.wikidata.org/wiki/Q25351891","display_name":"Service (business)","level":2,"score":0.5122200846672058},{"id":"https://openalex.org/C110875604","wikidata":"https://www.wikidata.org/wiki/Q75","display_name":"The Internet","level":2,"score":0.5108644366264343},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4917745888233185},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.49030521512031555},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4413532018661499},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3141452670097351},{"id":"https://openalex.org/C136264566","wikidata":"https://www.wikidata.org/wiki/Q159810","display_name":"Economy","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3583780.3614731","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3583780.3614731","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 32nd ACM International Conference on Information and Knowledge Management","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1882485028","display_name":null,"funder_award_id":"U22B2020","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G3317480652","display_name":null,"funder_award_id":"Science","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G7727208575","display_name":null,"funder_award_id":"Meituan","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G848032724","display_name":null,"funder_award_id":"Science","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W2295598076","https://openalex.org/W2396309311","https://openalex.org/W2950480046","https://openalex.org/W3095166039","https://openalex.org/W4294903983","https://openalex.org/W4312656534","https://openalex.org/W4317641440"],"related_works":["https://openalex.org/W2366107444","https://openalex.org/W4388145910","https://openalex.org/W1976205134","https://openalex.org/W2381570729","https://openalex.org/W4248336175","https://openalex.org/W3009369890","https://openalex.org/W2031260042","https://openalex.org/W2391445434","https://openalex.org/W4312490297","https://openalex.org/W2358812761"],"abstract_inverted_index":{"The":[0],"Database":[1],"Autonomy":[2],"Service":[3],"(DAS)":[4],"is":[5,32],"a":[6,15,45,60,78],"platform":[7],"designed":[8],"to":[9,33,37,76,84,109],"assist":[10],"database":[11,19,57],"administrators":[12],"in":[13,30,69],"managing":[14],"large":[16],"number":[17,62],"of":[18,26,48,53,55,63],"instances":[20],"within":[21],"major":[22],"internet":[23],"companies.":[24],"One":[25],"the":[27,39,70,111,115,127],"key":[28],"tasks":[29],"DAS":[31,71],"find":[34],"missing":[35],"indexes":[36,129],"improve":[38],"slow":[40,119],"query":[41],"execution.":[42],"In":[43,97],"Meituan,":[44],"vast":[46],"array":[47],"business":[49],"lines":[50],"deploy":[51],"tens":[52],"thousands":[54],"MySQL":[56],"instances.":[58],"Consequently,":[59],"great":[61],"human-generated":[64,94],"index":[65,80,90,95],"cases":[66],"are":[67],"accumulated":[68],"platform.":[72],"This":[73],"motivates":[74],"us":[75],"build":[77],"data-driven":[79],"recommendation":[81,116],"system,":[82],"referred":[83],"as":[85],"idxLearner,":[86],"which":[87],"can":[88,101],"learn":[89],"creation":[91],"knowledge":[92],"from":[93],"cases.":[96],"this":[98],"demonstration,":[99],"users":[100],"interact":[102],"with":[103],"idxLearner":[104],"by":[105],"choosing":[106],"source":[107],"databases":[108],"construct":[110],"training":[112,114],"data,":[113],"model,":[117],"inputting":[118],"queries":[120],"for":[121],"various":[122],"target":[123],"databases,":[124],"and":[125,130],"observing":[126],"recommended":[128],"their":[131],"evaluation":[132],"results.":[133]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1}],"updated_date":"2026-04-16T08:26:57.006410","created_date":"2025-10-10T00:00:00"}