{"id":"https://openalex.org/W4393183713","doi":"https://doi.org/10.1145/3639319","title":"WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications","display_name":"WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications","publication_year":2024,"publication_date":"2024-03-12","ids":{"openalex":"https://openalex.org/W4393183713","doi":"https://doi.org/10.1145/3639319"},"language":"en","primary_location":{"id":"doi:10.1145/3639319","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3639319","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3639319","source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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 ACM on Management of Data","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/3639319","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5070199557","display_name":"Gansen Hu","orcid":"https://orcid.org/0009-0006-0468-3744"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Gansen Hu","raw_affiliation_strings":["Institute of Parallel and Distributed Systems, SEIEE, Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0006-0468-3744","affiliations":[{"raw_affiliation_string":"Institute of Parallel and Distributed Systems, SEIEE, Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101743342","display_name":"Zhaoguo Wang","orcid":"https://orcid.org/0000-0002-0220-5726"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhaoguo Wang","raw_affiliation_strings":["Institute of Parallel and Distributed Systems, SEIEE, Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":"https://orcid.org/0000-0002-0220-5726","affiliations":[{"raw_affiliation_string":"Institute of Parallel and Distributed Systems, SEIEE, Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5028552513","display_name":"Chuzhe Tang","orcid":"https://orcid.org/0000-0001-7757-5708"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chuzhe Tang","raw_affiliation_strings":["Institute of Parallel and Distributed Systems, SEIEE, Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":"https://orcid.org/0000-0001-7757-5708","affiliations":[{"raw_affiliation_string":"Institute of Parallel and Distributed Systems, SEIEE, Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041077637","display_name":"Jiahuan Shen","orcid":"https://orcid.org/0009-0003-1836-9770"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jiahuan Shen","raw_affiliation_strings":["Institute of Parallel and Distributed Systems, SEIEE, Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0003-1836-9770","affiliations":[{"raw_affiliation_string":"Institute of Parallel and Distributed Systems, SEIEE, Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5024129394","display_name":"Zhiyuan Dong","orcid":"https://orcid.org/0000-0002-8758-2378"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhiyuan Dong","raw_affiliation_strings":["Institute of Parallel and Distributed Systems, SEIEE, Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":"https://orcid.org/0000-0002-8758-2378","affiliations":[{"raw_affiliation_string":"Institute of Parallel and Distributed Systems, SEIEE, Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038644583","display_name":"S. S. Yao","orcid":"https://orcid.org/0009-0003-5143-8352"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Sheng Yao","raw_affiliation_strings":["Institute of Parallel and Distributed Systems, SEIEE, Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":"https://orcid.org/0009-0003-5143-8352","affiliations":[{"raw_affiliation_string":"Institute of Parallel and Distributed Systems, SEIEE, Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100406215","display_name":"Haibo Chen","orcid":"https://orcid.org/0000-0002-9720-0361"},"institutions":[{"id":"https://openalex.org/I183067930","display_name":"Shanghai Jiao Tong University","ror":"https://ror.org/0220qvk04","country_code":"CN","type":"education","lineage":["https://openalex.org/I183067930"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Haibo Chen","raw_affiliation_strings":["Institute of Parallel and Distributed Systems, SEIEE, Shanghai Jiao Tong University, Shanghai, China"],"raw_orcid":"https://orcid.org/0000-0002-9720-0361","affiliations":[{"raw_affiliation_string":"Institute of Parallel and Distributed Systems, SEIEE, Shanghai Jiao Tong University, Shanghai, China","institution_ids":["https://openalex.org/I183067930"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I183067930"],"apc_list":null,"apc_paid":null,"fwci":1.9732,"has_fulltext":true,"cited_by_count":3,"citation_normalized_percentile":{"value":0.88901443,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":97},"biblio":{"volume":"2","issue":"1","first_page":"1","last_page":"29"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12479","display_name":"Web Application Security Vulnerabilities","score":0.9997000098228455,"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/T12479","display_name":"Web Application Security Vulnerabilities","score":0.9997000098228455,"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/T10743","display_name":"Software Testing and Debugging Techniques","score":0.9994000196456909,"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"}},{"id":"https://openalex.org/T12016","display_name":"Web Data Mining and Analysis","score":0.9987999796867371,"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/scale","display_name":"Scale (ratio)","score":0.632896363735199},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6089949607849121},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.44269439578056335},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.353376567363739},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.1034279465675354},{"id":"https://openalex.org/keywords/cartography","display_name":"Cartography","score":0.06431412696838379}],"concepts":[{"id":"https://openalex.org/C2778755073","wikidata":"https://www.wikidata.org/wiki/Q10858537","display_name":"Scale (ratio)","level":2,"score":0.632896363735199},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6089949607849121},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.44269439578056335},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.353376567363739},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.1034279465675354},{"id":"https://openalex.org/C58640448","wikidata":"https://www.wikidata.org/wiki/Q42515","display_name":"Cartography","level":1,"score":0.06431412696838379}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3639319","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3639319","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3639319","source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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 ACM on Management of Data","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1145/3639319","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3639319","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3639319","source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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 ACM on Management of Data","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G7172231108","display_name":null,"funder_award_id":"62272304,62132014","funder_id":"https://openalex.org/F4320323817","funder_display_name":"Universitas Brawijaya"}],"funders":[{"id":"https://openalex.org/F4320323817","display_name":"Universitas Brawijaya","ror":"https://ror.org/01wk3d929"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4393183713.pdf","grobid_xml":"https://content.openalex.org/works/W4393183713.grobid-xml"},"referenced_works_count":61,"referenced_works":["https://openalex.org/W157156687","https://openalex.org/W196342399","https://openalex.org/W221832247","https://openalex.org/W1577231857","https://openalex.org/W1969460277","https://openalex.org/W1969548135","https://openalex.org/W1987647365","https://openalex.org/W1991069419","https://openalex.org/W2040851906","https://openalex.org/W2041176136","https://openalex.org/W2047694629","https://openalex.org/W2052987550","https://openalex.org/W2055116083","https://openalex.org/W2069171862","https://openalex.org/W2085925880","https://openalex.org/W2086658561","https://openalex.org/W2101000001","https://openalex.org/W2104993088","https://openalex.org/W2105079611","https://openalex.org/W2117387696","https://openalex.org/W2122532513","https://openalex.org/W2130473288","https://openalex.org/W2134440791","https://openalex.org/W2138788987","https://openalex.org/W2144344516","https://openalex.org/W2153876009","https://openalex.org/W2161306597","https://openalex.org/W2161818013","https://openalex.org/W2162436812","https://openalex.org/W2171956059","https://openalex.org/W2296669295","https://openalex.org/W2340838390","https://openalex.org/W2350778671","https://openalex.org/W2399381860","https://openalex.org/W2441695939","https://openalex.org/W2612808231","https://openalex.org/W2617348763","https://openalex.org/W2761236351","https://openalex.org/W2767894601","https://openalex.org/W2794632349","https://openalex.org/W2794933251","https://openalex.org/W2898912109","https://openalex.org/W2914209329","https://openalex.org/W2921740354","https://openalex.org/W2948175384","https://openalex.org/W2963723316","https://openalex.org/W2963741525","https://openalex.org/W3029703673","https://openalex.org/W3033653001","https://openalex.org/W3085921543","https://openalex.org/W3100791781","https://openalex.org/W3113108440","https://openalex.org/W3136655632","https://openalex.org/W3164278511","https://openalex.org/W3168937343","https://openalex.org/W3209407499","https://openalex.org/W4234542549","https://openalex.org/W4246691913","https://openalex.org/W4252081683","https://openalex.org/W4320166362","https://openalex.org/W6606430823"],"related_works":["https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W2358668433","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W2382290278","https://openalex.org/W2478288626","https://openalex.org/W4391913857","https://openalex.org/W2350741829","https://openalex.org/W2530322880"],"abstract_inverted_index":{"Modern":[0],"web":[1,99,150],"applications":[2,14,110,151],"use":[3],"databases":[4],"to":[5,40,107,159,166],"store":[6,17],"their":[7],"data.":[8],"When":[9],"processing":[10],"user":[11],"requests,":[12],"these":[13,42],"retrieve":[15],"and":[16,111,152,164],"data":[18],"in":[19],"the":[20,33,59,75,79,88,109,123,127,131,138,141],"database":[21,51,132],"server,":[22],"which":[23],"incurs":[24],"network":[25],"round":[26,29,43],"trips.":[27],"These":[28],"trips":[30,44],"significantly":[31],"increase":[32],"application's":[34],"latency.":[35],"Previous":[36],"approaches":[37],"have":[38],"attempted":[39],"reduce":[41,58],"by":[45,129],"prefetching":[46],"query":[47],"results":[48],"or":[49],"batching":[50],"accesses.":[52],"However,":[53],"neither":[54],"method":[55],"can":[56],"efficiently":[57],"latency":[60,162],"when":[61],"some":[62],"queries":[63,76],"depend":[64,77],"on":[65,78],"previous":[66],"queries'":[67],"results.":[68],"In":[69],"real-world":[70,98,149],"applications,":[71],"nearly":[72],"50%":[73],"of":[74,81,92,140],"result":[80],"other":[82],"queries.":[83],"This":[84],"paper":[85],"presents":[86],"WeBridge,":[87],"first":[89],"system":[90],"capable":[91],"synthesizing":[93],"stored":[94,113,124,142],"procedures":[95,114,125,143],"for":[96,115],"large-scale":[97],"applications.":[100],"First,":[101],"WeBridge":[102,156],"employs":[103],"concolic":[104],"execution":[105],"technique":[106],"analyze":[108],"generate":[112],"hot":[116],"program":[117],"paths.":[118],"Then,":[119],"it":[120,136],"seamlessly":[121],"integrates":[122],"into":[126],"application":[128],"extending":[130],"access":[133],"library.":[134],"Finally,":[135],"improves":[137],"efficiency":[139],"with":[144],"speculative":[145],"execution.":[146],"Evaluation":[147],"using":[148],"workloads":[153],"show":[154],"that":[155],"achieves":[157],"up":[158,165],"79.8%":[160],"median":[161],"reduction":[163],"2\u00d7":[167],"peak":[168],"throughput.":[169]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":2}],"updated_date":"2026-08-01T09:00:35.917206","created_date":"2025-10-10T00:00:00"}