{"id":"https://openalex.org/W4403351119","doi":"https://doi.org/10.1145/3695080.3695132","title":"Research on Automated Database Health Check and Slow SQL Optimization","display_name":"Research on Automated Database Health Check and Slow SQL Optimization","publication_year":2024,"publication_date":"2024-07-26","ids":{"openalex":"https://openalex.org/W4403351119","doi":"https://doi.org/10.1145/3695080.3695132"},"language":"en","primary_location":{"id":"doi:10.1145/3695080.3695132","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3695080.3695132","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2024 International Conference on Cloud Computing and Big Data","raw_type":"proceedings-article"},"type":"conference-paper","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/A5069138088","display_name":"Xiaomin Tan","orcid":null},"institutions":[{"id":"https://openalex.org/I4210136246","display_name":"China Telecom (China)","ror":"https://ror.org/03jgnzt20","country_code":"CN","type":"company","lineage":["https://openalex.org/I4210136246"]},{"id":"https://openalex.org/I4387153335","display_name":"China Telecom","ror":"https://ror.org/05p67dv18","country_code":null,"type":"company","lineage":["https://openalex.org/I4387153335"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiaomin Tan","raw_affiliation_strings":["Intermediate Engineer, China Telecom Corporation Limited Research Institution, China"],"raw_orcid":"https://orcid.org/0009-0006-4512-0702","affiliations":[{"raw_affiliation_string":"Intermediate Engineer, China Telecom Corporation Limited Research Institution, China","institution_ids":["https://openalex.org/I4210136246","https://openalex.org/I4387153335"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5011098655","display_name":"Yuzhong Zhang","orcid":null},"institutions":[{"id":"https://openalex.org/I4210136246","display_name":"China Telecom (China)","ror":"https://ror.org/03jgnzt20","country_code":"CN","type":"company","lineage":["https://openalex.org/I4210136246"]},{"id":"https://openalex.org/I4387153335","display_name":"China Telecom","ror":"https://ror.org/05p67dv18","country_code":null,"type":"company","lineage":["https://openalex.org/I4387153335"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yuzhong Zhang","raw_affiliation_strings":["Senior Engineer, China Telecom Corporation Limited Research Institution, China"],"raw_orcid":"https://orcid.org/0009-0006-2930-7104","affiliations":[{"raw_affiliation_string":"Senior Engineer, China Telecom Corporation Limited Research Institution, China","institution_ids":["https://openalex.org/I4210136246","https://openalex.org/I4387153335"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"294","last_page":"299"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9624999761581421,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9624999761581421,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9556999802589417,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.953000009059906,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7833482027053833},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7260987162590027},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5720385909080505}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7833482027053833},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7260987162590027},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5720385909080505}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3695080.3695132","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3695080.3695132","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2024 International Conference on Cloud Computing and Big Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W2239081428","https://openalex.org/W2548760919","https://openalex.org/W2613206411","https://openalex.org/W2911464154","https://openalex.org/W3083560262","https://openalex.org/W3094011786","https://openalex.org/W3105457604","https://openalex.org/W3188222881","https://openalex.org/W4289533888","https://openalex.org/W6733403177"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052","https://openalex.org/W4402327032","https://openalex.org/W2382290278"],"abstract_inverted_index":{"Databases":[0],"are":[1,46,59,69],"the":[2,15,53,81,118],"foundation":[3],"of":[4,14,52,120],"application":[5],"services.":[6,23,122],"Low-quality":[7],"SQL":[8,57,75,94,104],"queries":[9,105],"leads":[10],"to":[11,48,78,83,100,112],"performance":[12],"bottlenecks":[13],"database,":[16],"which":[17,110],"in":[18,71,74],"turn":[19],"may":[20],"affect":[21],"other":[22],"The":[24,96],"research":[25,97],"focuses":[26],"on":[27,40],"developing":[28],"a":[29],"comprehensive":[30],"framework":[31],"that":[32],"enables":[33],"self-awareness,":[34],"self-optimization,":[35],"self-evaluation":[36],"for":[37,63,93],"databases":[38],"basing":[39],"anomaly":[41],"detection":[42],"and":[43,66,106,116],"experience.":[44],"Algorithms":[45],"used":[47,70],"automatically":[49],"detect":[50],"anomalies":[51],"database":[54,121],"resources.":[55],"Slow":[56],"statements":[58],"extracted":[60],"from":[61],"logs":[62],"trend":[64],"analysis":[65],"large":[67],"models":[68],"analyzing":[72],"changes":[73],"execution":[76],"plans":[77],"find":[79,101],"out":[80,102],"SQLs":[82],"be":[84],"optimized.":[85],"Finally,":[86],"an":[87],"Experiential":[88],"rule":[89],"library":[90],"is":[91,98],"decided":[92],"Optimization.":[95],"able":[99],"poor-performing":[103],"provide":[107],"optimization":[108],"recommendations,":[109],"helps":[111],"improve":[113],"working":[114],"efficiency":[115],"ensure":[117],"stability":[119]},"counts_by_year":[],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}