{"id":"https://openalex.org/W4413792304","doi":"https://doi.org/10.1145/3764583","title":"Unveiling Logic Bugs in SPJG Query Optimizations within DBMS","display_name":"Unveiling Logic Bugs in SPJG Query Optimizations within DBMS","publication_year":2025,"publication_date":"2025-08-28","ids":{"openalex":"https://openalex.org/W4413792304","doi":"https://doi.org/10.1145/3764583"},"language":"en","primary_location":{"id":"doi:10.1145/3764583","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3764583","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3764583","source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"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":"ACM Transactions on Database Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3764583","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5072228670","display_name":"Xiu Tang","orcid":"https://orcid.org/0000-0001-8611-0283"},"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":true,"raw_author_name":"Xiu Tang","raw_affiliation_strings":["Zhejiang University","Zhejiang University, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Zhejiang University","institution_ids":["https://openalex.org/I76130692"]},{"raw_affiliation_string":"Zhejiang University, Hangzhou, China","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109156225","display_name":"Shi-Jie Yang","orcid":null},"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":"Shijie Yang","raw_affiliation_strings":["Zhejiang University","Zhejiang University, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Zhejiang University","institution_ids":["https://openalex.org/I76130692"]},{"raw_affiliation_string":"Zhejiang University, Hangzhou, China","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5017672363","display_name":"Sai Wu","orcid":"https://orcid.org/0000-0002-7903-1496"},"institutions":[{"id":"https://openalex.org/I168879160","display_name":"Zhejiang University of Science and Technology","ror":"https://ror.org/05mx0wr29","country_code":"CN","type":"education","lineage":["https://openalex.org/I168879160"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Sai Wu","raw_affiliation_strings":["College of Computer Science and Technology, Zhejiang University","College of Computer Science and Technology, Zhejiang University, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"College of Computer Science and Technology, Zhejiang University","institution_ids":["https://openalex.org/I168879160"]},{"raw_affiliation_string":"College of Computer Science and Technology, Zhejiang University, Hangzhou, China","institution_ids":["https://openalex.org/I168879160"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5011200911","display_name":"Dongxiang Zhang","orcid":"https://orcid.org/0000-0002-9964-2470"},"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":"Dongxiang Zhang","raw_affiliation_strings":["Zhejiang University","Zhejiang University, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Zhejiang University","institution_ids":["https://openalex.org/I76130692"]},{"raw_affiliation_string":"Zhejiang University, Hangzhou, China","institution_ids":["https://openalex.org/I76130692"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101741069","display_name":"Wenchao Zhou","orcid":"https://orcid.org/0009-0002-2689-6020"},"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"]},{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN","US"],"is_corresponding":false,"raw_author_name":"Wenchao Zhou","raw_affiliation_strings":["Alibaba Group","Alibaba Group, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Alibaba Group","institution_ids":["https://openalex.org/I4210095624"]},{"raw_affiliation_string":"Alibaba Group, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"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"]},{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN","US"],"is_corresponding":false,"raw_author_name":"Feifei Li","raw_affiliation_strings":["Alibaba Group","Alibaba Group, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Alibaba Group","institution_ids":["https://openalex.org/I4210095624"]},{"raw_affiliation_string":"Alibaba Group, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100389286","display_name":"Gang Chen","orcid":"https://orcid.org/0000-0002-7483-0045"},"institutions":[{"id":"https://openalex.org/I168879160","display_name":"Zhejiang University of Science and Technology","ror":"https://ror.org/05mx0wr29","country_code":"CN","type":"education","lineage":["https://openalex.org/I168879160"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Gang Chen","raw_affiliation_strings":["College of Computer Science and Technology, Zhejiang University","College of Computer Science and Technology, Zhejiang University, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"College of Computer Science and Technology, Zhejiang University","institution_ids":["https://openalex.org/I168879160"]},{"raw_affiliation_string":"College of Computer Science and Technology, Zhejiang University, Hangzhou, China","institution_ids":["https://openalex.org/I168879160"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5072228670"],"corresponding_institution_ids":["https://openalex.org/I76130692"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.26369673,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"51","issue":"1","first_page":"1","last_page":"35"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9988999962806702,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9988999962806702,"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/T10772","display_name":"Distributed systems and fault tolerance","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/T10743","display_name":"Software Testing and Debugging Techniques","score":0.9979000091552734,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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.875967264175415},{"id":"https://openalex.org/keywords/debugging","display_name":"Debugging","score":0.669124960899353},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6387557983398438},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.48014160990715027},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.44847699999809265},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4427169859409332},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.42750805616378784},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.35178524255752563},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3235360383987427},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2974253296852112},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.20824623107910156}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.875967264175415},{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.669124960899353},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6387557983398438},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.48014160990715027},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.44847699999809265},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4427169859409332},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.42750805616378784},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.35178524255752563},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3235360383987427},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2974253296852112},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.20824623107910156}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3764583","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3764583","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3764583","source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"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":"ACM Transactions on Database Systems","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1145/3764583","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3764583","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3764583","source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"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":"ACM Transactions on Database Systems","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1121271761","display_name":null,"funder_award_id":"Program","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G2087396116","display_name":null,"funder_award_id":"China","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G3085993365","display_name":null,"funder_award_id":"(Grant No.","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/G5994120800","display_name":null,"funder_award_id":"Natural","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G7726157001","display_name":null,"funder_award_id":"Grant No.","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"},{"id":"https://openalex.org/F4320338464","display_name":"Natural Science Foundation of Zhejiang Province","ror":"https://ror.org/01h0zpd94"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4413792304.pdf","grobid_xml":"https://content.openalex.org/works/W4413792304.grobid-xml"},"referenced_works_count":42,"referenced_works":["https://openalex.org/W109452506","https://openalex.org/W180578187","https://openalex.org/W190884830","https://openalex.org/W1570990937","https://openalex.org/W1810256132","https://openalex.org/W1854679880","https://openalex.org/W1989009626","https://openalex.org/W1992730709","https://openalex.org/W2011039300","https://openalex.org/W2016432059","https://openalex.org/W2022431239","https://openalex.org/W2032167079","https://openalex.org/W2049251595","https://openalex.org/W2061253631","https://openalex.org/W2065793351","https://openalex.org/W2071678949","https://openalex.org/W2077443691","https://openalex.org/W2099525917","https://openalex.org/W2101566835","https://openalex.org/W2112100340","https://openalex.org/W2140100614","https://openalex.org/W2141933093","https://openalex.org/W2166549982","https://openalex.org/W2170737051","https://openalex.org/W2171831739","https://openalex.org/W2299503697","https://openalex.org/W2439326083","https://openalex.org/W2761359361","https://openalex.org/W2797054769","https://openalex.org/W2970388188","https://openalex.org/W3040734868","https://openalex.org/W3099032206","https://openalex.org/W3105233790","https://openalex.org/W3106731144","https://openalex.org/W3139337630","https://openalex.org/W3142348832","https://openalex.org/W3177116918","https://openalex.org/W4235969523","https://openalex.org/W4238083723","https://openalex.org/W4380433204","https://openalex.org/W4394769417","https://openalex.org/W4399156224"],"related_works":["https://openalex.org/W2096359267","https://openalex.org/W3125756434","https://openalex.org/W2184296057","https://openalex.org/W4256058599","https://openalex.org/W2362460270","https://openalex.org/W1793997780","https://openalex.org/W2392799717","https://openalex.org/W2538384344","https://openalex.org/W185198413","https://openalex.org/W2901901036"],"abstract_inverted_index":{"Generation-based":[0],"testing":[1,53,146],"techniques":[2,138],"have":[3],"proven":[4],"effective":[5,222],"in":[6,10,223,231,246,249,252,256],"detecting":[7,57],"logic":[8,58,225],"bugs":[9,59,226,239,245],"DBMS,":[11,70],"often":[12],"stemming":[13],"from":[14,61,113,128],"the":[15,73,93,140,167,178,185,194],"improper":[16],"implementation":[17],"of":[18,96,121,180,227],"query":[19,65,98,173,202,229],"optimizers.":[20],"However,":[21],"existing":[22],"generation-based":[23],"debugging":[24],"tools":[25],"predominantly":[26],"rely":[27],"on":[28,207],"random":[29,199],"testing,":[30],"which":[31,118],"tends":[32],"to":[33,101,131,139,143],"overlook":[34],"critical":[35],"error-prone":[36,181],"areas":[37],"such":[38],"as":[39,187],"multi-table":[40,97],"joining":[41],"and":[42,81,85,148,183,192,197,214,254],"grouped":[43,122],"aggregation.":[44],"In":[45],"this":[46],"article,":[47],"we":[48],"propose":[49],"TQS,":[50],"a":[51,68,132,145,150],"novel":[52],"framework":[54],"targeted":[55],"at":[56],"arising":[60],"SPJG":[62,228],"(Select-Project-Join-Group":[63],"By)":[64],"optimizations.":[66],"Given":[67],"target":[69],"TQS":[71,206,220],"achieves":[72],"goal":[74],"with":[75],"two":[76],"key":[77,94],"components:":[78],"Data-guided":[79],"Schema":[80],"Query":[82,87],"Generation":[83],"(DSG)":[84],"Knowledge-guided":[86],"Space":[88],"Exploration":[89],"(KQE).":[90],"DSG":[91,109,160],"addresses":[92],"challenge":[95],"debugging:":[99],"how":[100],"generate":[102,144],"ground-truth":[103],"(query,":[104],"result)":[105],"pairs":[106],"for":[107,153,201],"verification.":[108],"utilizes":[110],"data":[111,116,120,127,129],"derived":[112],"dimensionally":[114],"aggregated":[115],"cubes,":[117,182],"store":[119],"metric":[123],"columns.":[124],"It":[125,235],"maps":[126],"cubes":[130],"wide":[133,141],"table,":[134],"applies":[135],"database":[136,232],"normalization":[137],"table":[142],"schema":[147],"maintains":[149],"bitmap":[151],"index":[152],"result":[154],"tracking.":[155],"To":[156,170],"improve":[157],"debug":[158],"efficiency,":[159],"also":[161],"artificially":[162],"inserts":[163],"some":[164],"noises":[165],"into":[166],"generated":[168],"data.":[169],"avoid":[171],"repetitive":[172],"space":[174],"search,":[175],"KQE":[176],"guides":[177],"generation":[179],"forms":[184],"problem":[186],"isomorphic":[188],"graph":[189,195],"set":[190],"discovery":[191],"combines":[193],"embedding":[196],"weighted":[198],"walk":[200],"generation.":[203],"We":[204],"evaluated":[205],"four":[208],"popular":[209],"DBMSs:":[210],"MySQL,":[211,247],"MariaDB,":[212,250],"TiDB,":[213,253],"PolarDB.":[215],"Experimental":[216],"results":[217],"show":[218],"that":[219],"is":[221],"finding":[224],"optimization":[230],"management":[233],"systems.":[234],"successfully":[236],"detected":[237],"226":[238],"within":[240],"24":[241],"hours,":[242],"including":[243],"63":[244],"52":[248],"68":[251],"43":[255],"PolarDB,":[257],"respectively.":[258]},"counts_by_year":[],"updated_date":"2026-03-18T14:38:29.013473","created_date":"2025-10-10T00:00:00"}