{"id":"https://openalex.org/W4386768937","doi":"https://doi.org/10.14778/3611540.3611557","title":"Real-Time Workload Pattern Analysis for Large-Scale Cloud Databases","display_name":"Real-Time Workload Pattern Analysis for Large-Scale Cloud Databases","publication_year":2023,"publication_date":"2023-08-01","ids":{"openalex":"https://openalex.org/W4386768937","doi":"https://doi.org/10.14778/3611540.3611557"},"language":"en","primary_location":{"id":"doi:10.14778/3611540.3611557","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3611540.3611557","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://vbn.aau.dk/ws/files/678702552/3611540.3611557.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5100365348","display_name":"Jiaqi Wang","orcid":"https://orcid.org/0000-0001-9445-5652"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jiaqi Wang","raw_affiliation_strings":["Zhejiang University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100460601","display_name":"Tianyi Li","orcid":"https://orcid.org/0000-0002-1145-2526"},"institutions":[{"id":"https://openalex.org/I891191580","display_name":"Aalborg University","ror":"https://ror.org/04m5j1k67","country_code":"DK","type":"education","lineage":["https://openalex.org/I891191580"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Tianyi Li","raw_affiliation_strings":["Aalborg University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Aalborg University","institution_ids":["https://openalex.org/I891191580"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5086865014","display_name":"Anni Wang","orcid":"https://orcid.org/0000-0003-3109-7514"},"institutions":[{"id":"https://openalex.org/I4210095624","display_name":"Alibaba Group (United States)","ror":"https://ror.org/00rn0m335","country_code":"US","type":"company","lineage":["https://openalex.org/I4210095624","https://openalex.org/I45928872"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Anni Wang","raw_affiliation_strings":["Alibaba Group"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Alibaba Group","institution_ids":["https://openalex.org/I4210095624"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063552937","display_name":"Xiaoze Liu","orcid":"https://orcid.org/0000-0002-9726-3397"},"institutions":[{"id":"https://openalex.org/I219193219","display_name":"Purdue University West Lafayette","ror":"https://ror.org/02dqehb95","country_code":"US","type":"education","lineage":["https://openalex.org/I219193219"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xiaoze Liu","raw_affiliation_strings":["Purdue University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Purdue University","institution_ids":["https://openalex.org/I219193219"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100605099","display_name":"Chen L\u00fc","orcid":"https://orcid.org/0000-0003-1927-2391"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Lu Chen","raw_affiliation_strings":["Zhejiang University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5120593407","display_name":"Jie Chen","orcid":"https://orcid.org/0000-0002-6701-084X"},"institutions":[{"id":"https://openalex.org/I4210095624","display_name":"Alibaba Group (United States)","ror":"https://ror.org/00rn0m335","country_code":"US","type":"company","lineage":["https://openalex.org/I4210095624","https://openalex.org/I45928872"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jie Chen","raw_affiliation_strings":["Alibaba Group"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Alibaba Group","institution_ids":["https://openalex.org/I4210095624"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101637104","display_name":"Jianye Liu","orcid":"https://orcid.org/0009-0006-3618-8596"},"institutions":[{"id":"https://openalex.org/I4210095624","display_name":"Alibaba Group (United States)","ror":"https://ror.org/00rn0m335","country_code":"US","type":"company","lineage":["https://openalex.org/I4210095624","https://openalex.org/I45928872"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jianye Liu","raw_affiliation_strings":["Alibaba Group"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Alibaba Group","institution_ids":["https://openalex.org/I4210095624"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5015427218","display_name":"Junyang Wu","orcid":"https://orcid.org/0000-0001-8587-1072"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Junyang Wu","raw_affiliation_strings":["Zhejiang University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100450470","display_name":"Feifei Li","orcid":"https://orcid.org/0009-0003-0770-5775"},"institutions":[{"id":"https://openalex.org/I4210095624","display_name":"Alibaba Group (United States)","ror":"https://ror.org/00rn0m335","country_code":"US","type":"company","lineage":["https://openalex.org/I4210095624","https://openalex.org/I45928872"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Feifei Li","raw_affiliation_strings":["Alibaba Group"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Alibaba Group","institution_ids":["https://openalex.org/I4210095624"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5006238145","display_name":"Yunjun Gao","orcid":"https://orcid.org/0000-0003-3816-8450"},"institutions":[{"id":"https://openalex.org/I76130692","display_name":"Zhejiang University","ror":"https://ror.org/00a2xv884","country_code":"CN","type":"education","lineage":["https://openalex.org/I76130692"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yunjun Gao","raw_affiliation_strings":["Zhejiang University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Zhejiang University","institution_ids":["https://openalex.org/I76130692"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":7.4606,"has_fulltext":true,"cited_by_count":18,"citation_normalized_percentile":{"value":0.97249456,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":97,"max":99},"biblio":{"volume":"16","issue":"12","first_page":"3689","last_page":"3701"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","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"}},"topics":[{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","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"}},{"id":"https://openalex.org/T12292","display_name":"Graph Theory and Algorithms","score":0.9969000220298767,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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.9961000084877014,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.7443281412124634},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.714856743812561},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.6762533783912659},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5775938034057617},{"id":"https://openalex.org/keywords/scale","display_name":"Scale (ratio)","score":0.5659409761428833},{"id":"https://openalex.org/keywords/scale-analysis","display_name":"Scale analysis (mathematics)","score":0.42091336846351624},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.21568939089775085},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.14328670501708984},{"id":"https://openalex.org/keywords/cartography","display_name":"Cartography","score":0.09082263708114624},{"id":"https://openalex.org/keywords/meteorology","display_name":"Meteorology","score":0.08298629522323608}],"concepts":[{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7443281412124634},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.714856743812561},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.6762533783912659},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5775938034057617},{"id":"https://openalex.org/C2778755073","wikidata":"https://www.wikidata.org/wiki/Q10858537","display_name":"Scale (ratio)","level":2,"score":0.5659409761428833},{"id":"https://openalex.org/C2775879016","wikidata":"https://www.wikidata.org/wiki/Q2845204","display_name":"Scale analysis (mathematics)","level":2,"score":0.42091336846351624},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.21568939089775085},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.14328670501708984},{"id":"https://openalex.org/C58640448","wikidata":"https://www.wikidata.org/wiki/Q42515","display_name":"Cartography","level":1,"score":0.09082263708114624},{"id":"https://openalex.org/C153294291","wikidata":"https://www.wikidata.org/wiki/Q25261","display_name":"Meteorology","level":1,"score":0.08298629522323608}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.14778/3611540.3611557","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3611540.3611557","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},{"id":"pmh:oai:pure.atira.dk:publications/e9484b1b-5064-42d3-8d1c-e5e71b517888","is_oa":true,"landing_page_url":"https://vbn.aau.dk/da/publications/e9484b1b-5064-42d3-8d1c-e5e71b517888","pdf_url":"https://vbn.aau.dk/ws/files/678702552/3611540.3611557.pdf","source":{"id":"https://openalex.org/S4306401731","display_name":"VBN Forskningsportal (Aalborg Universitet)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I891191580","host_organization_name":"Aalborg University","host_organization_lineage":["https://openalex.org/I891191580"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Wang, J, Li, T, Wang, A, Liu, X, Chen, L, Chen, J, Liu, J, Wu, J, Li, F & Gao, Y 2023, 'Real-timeWorkload Pattern Analysis for Large-scale Cloud Databases', Proceedings of the VLDB Endowment, vol. 16, no. 12, pp. 3689-3701. https://doi.org/10.14778/3611540.3611557","raw_type":"info:eu-repo/semantics/conferenceObject"}],"best_oa_location":{"id":"pmh:oai:pure.atira.dk:publications/e9484b1b-5064-42d3-8d1c-e5e71b517888","is_oa":true,"landing_page_url":"https://vbn.aau.dk/da/publications/e9484b1b-5064-42d3-8d1c-e5e71b517888","pdf_url":"https://vbn.aau.dk/ws/files/678702552/3611540.3611557.pdf","source":{"id":"https://openalex.org/S4306401731","display_name":"VBN Forskningsportal (Aalborg Universitet)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I891191580","host_organization_name":"Aalborg University","host_organization_lineage":["https://openalex.org/I891191580"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Wang, J, Li, T, Wang, A, Liu, X, Chen, L, Chen, J, Liu, J, Wu, J, Li, F & Gao, Y 2023, 'Real-timeWorkload Pattern Analysis for Large-scale Cloud Databases', Proceedings of the VLDB Endowment, vol. 16, no. 12, pp. 3689-3701. https://doi.org/10.14778/3611540.3611557","raw_type":"info:eu-repo/semantics/conferenceObject"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.6100000143051147}],"awards":[{"id":"https://openalex.org/G5410940137","display_name":null,"funder_award_id":"62025206","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G5916212369","display_name":"\u53cdTop-k\u7a7a\u95f4\u5173\u952e\u5b57\u67e5\u8be2\u53ef\u7528\u6027\u7814\u7a76","funder_award_id":"61972338","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G6456106688","display_name":null,"funder_award_id":"62102351","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4386768937.pdf","grobid_xml":"https://content.openalex.org/works/W4386768937.grobid-xml"},"referenced_works_count":38,"referenced_works":["https://openalex.org/W1185726409","https://openalex.org/W2011300314","https://openalex.org/W2068448124","https://openalex.org/W2112474496","https://openalex.org/W2227361507","https://openalex.org/W2258038925","https://openalex.org/W2294316975","https://openalex.org/W2295144739","https://openalex.org/W2295598076","https://openalex.org/W2439673131","https://openalex.org/W2492576631","https://openalex.org/W2584555500","https://openalex.org/W2612759782","https://openalex.org/W2801426799","https://openalex.org/W2970148517","https://openalex.org/W2970641574","https://openalex.org/W2971253019","https://openalex.org/W3008396642","https://openalex.org/W3013931120","https://openalex.org/W3031390801","https://openalex.org/W3035390927","https://openalex.org/W3083560262","https://openalex.org/W3099273181","https://openalex.org/W3102340269","https://openalex.org/W3149954208","https://openalex.org/W3154547779","https://openalex.org/W3165842875","https://openalex.org/W3176910252","https://openalex.org/W3192997470","https://openalex.org/W4205381461","https://openalex.org/W4205589654","https://openalex.org/W4281394493","https://openalex.org/W4281787155","https://openalex.org/W4289533899","https://openalex.org/W4300323401","https://openalex.org/W4319795207","https://openalex.org/W6733403177","https://openalex.org/W6800109784"],"related_works":["https://openalex.org/W2000785801","https://openalex.org/W986318368","https://openalex.org/W2384410913","https://openalex.org/W2352878646","https://openalex.org/W2004734601","https://openalex.org/W2287264064","https://openalex.org/W2130149817","https://openalex.org/W2547038763","https://openalex.org/W2365350080","https://openalex.org/W2394388677"],"abstract_inverted_index":{"Hosting":[0],"database":[1,19,47],"services":[2],"on":[3,128,206],"cloud":[4,60,77,197],"systems":[5,54],"has":[6,12],"become":[7],"a":[8,32,98],"common":[9],"practice.":[10],"This":[11,69],"led":[13],"to":[14,38],"the":[15,23,41,46,67,72,114,124,129,169,183,187,224,233,242],"increasing":[16],"volume":[17],"of":[18,45,75,86,226,235],"workloads,":[20],"which":[21,62],"provides":[22],"opportunity":[24],"for":[25,58,101,172],"pattern":[26,52,227],"analysis.":[27],"Discovering":[28],"workload":[29,51,73,103,170],"patterns":[30,74,104,117,171],"from":[31,119,215],"business":[33,165],"logic":[34],"perspective":[35],"is":[36,70],"conducive":[37],"better":[39],"understanding":[40],"trends":[42],"and":[43,112,122,142,153,167,181,210,231],"characteristics":[44],"system.":[48],"However,":[49],"existing":[50],"discovery":[53,228],"are":[55,63,79],"not":[56],"suitable":[57],"large-scale":[59,76,107],"databases":[61,78,198],"commonly":[64],"employed":[65],"by":[66,164,199,229,238],"industry.":[68],"because":[71],"generally":[80],"far":[81],"more":[82],"complicated":[83,106],"than":[84],"those":[85],"ordinary":[87],"databases.":[88],"In":[89],"this":[90],"paper,":[91],"we":[92],"propose":[93],"Alibaba":[94,216],"Workload":[95,158],"Miner":[96],"(AWM),":[97],"real-time":[99],"system":[100],"discovering":[102],"in":[105,196],"workloads.":[108],"AW":[109,221],"M":[110,222],"encodes":[111,143],"discovers":[113,168],"SQL":[115],"query":[116,140,163,194],"logged":[118],"user":[120],"requests":[121],"optimizes":[123,193],"querying":[125],"processing":[126,195],"based":[127],"discovered":[130,201],"patterns.":[131,202],"First,":[132],"Data":[133],"Collection":[134],"&":[135],"Preprocessing":[136],"Module":[137,160,178,192],"collects":[138,179],"streaming":[139],"logs":[141],"them":[144],"into":[145],"high-dimensional":[146],"feature":[147],"embeddings":[148],"with":[149,241],"rich":[150],"semantic":[151],"contexts":[152],"execution":[154],"features.":[155],"Next,":[156],"Online":[157],"Mining":[159],"separates":[161],"encoded":[162],"groups":[166],"each":[173],"group.":[174],"Meanwhile,":[175],"Offline":[176],"Training":[177],"labels":[180],"trains":[182],"classification":[184],"model":[185],"using":[186],"labels.":[188],"Finally,":[189],"Pattern-based":[190],"Optimizing":[191],"exploiting":[200],"Extensive":[203],"experimental":[204],"results":[205],"one":[207],"synthetic":[208],"dataset":[209],"two":[211],"real-life":[212],"datasets":[213],"(extracted":[214],"Cloud":[217],"databases)":[218],"show":[219],"that":[220],"enhances":[223],"accuracy":[225],"66%":[230],"reduce":[232],"latency":[234],"online":[236],"inference":[237],"22%,":[239],"compared":[240],"state-of-the-arts.":[243]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":5},{"year":2024,"cited_by_count":11}],"updated_date":"2026-07-02T09:51:11.867554","created_date":"2025-10-10T00:00:00"}