{"id":"https://openalex.org/W4366660538","doi":"https://doi.org/10.14778/3583140.3583141","title":"Leveraging Application Data Constraints to Optimize Database-Backed Web Applications","display_name":"Leveraging Application Data Constraints to Optimize Database-Backed Web Applications","publication_year":2023,"publication_date":"2023-02-01","ids":{"openalex":"https://openalex.org/W4366660538","doi":"https://doi.org/10.14778/3583140.3583141"},"language":"en","primary_location":{"id":"doi:10.14778/3583140.3583141","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3583140.3583141","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":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5100666863","display_name":"Xiaoxuan Liu","orcid":"https://orcid.org/0000-0002-7503-8359"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xiaoxuan Liu","raw_affiliation_strings":["University of California, Berkeley"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, Berkeley","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100639309","display_name":"Shuxian Wang","orcid":"https://orcid.org/0000-0001-8143-6436"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Shuxian Wang","raw_affiliation_strings":["University of California, Berkeley"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, Berkeley","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5012380170","display_name":"Mengzhu Sun","orcid":null},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mengzhu Sun","raw_affiliation_strings":["University of California, Berkeley"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, Berkeley","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5032733564","display_name":"Sicheng Pan","orcid":null},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sicheng Pan","raw_affiliation_strings":["University of California, Berkeley"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, Berkeley","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100447680","display_name":"Ge Li","orcid":"https://orcid.org/0000-0002-2605-7764"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ge Li","raw_affiliation_strings":["University of California, Berkeley"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, Berkeley","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5082972512","display_name":"Siddharth Jha","orcid":null},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Siddharth Jha","raw_affiliation_strings":["University of California, Berkeley"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, Berkeley","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101807460","display_name":"Cong Yan","orcid":"https://orcid.org/0009-0001-3596-4083"},"institutions":[{"id":"https://openalex.org/I4210164937","display_name":"Microsoft Research (United Kingdom)","ror":"https://ror.org/05k87vq12","country_code":"GB","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Cong Yan","raw_affiliation_strings":["Microsoft Research"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Research","institution_ids":["https://openalex.org/I4210164937"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103066770","display_name":"Junwen Yang","orcid":"https://orcid.org/0000-0003-0481-6982"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Junwen Yang","raw_affiliation_strings":["Meta"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Meta","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061448314","display_name":"Shan Lu","orcid":"https://orcid.org/0000-0002-0757-4600"},"institutions":[{"id":"https://openalex.org/I40347166","display_name":"University of Chicago","ror":"https://ror.org/024mw5h28","country_code":"US","type":"education","lineage":["https://openalex.org/I40347166"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Shan Lu","raw_affiliation_strings":["University of Chicago"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Chicago","institution_ids":["https://openalex.org/I40347166"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5059427197","display_name":"Alvin Cheung","orcid":"https://orcid.org/0000-0001-6261-6263"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alvin Cheung","raw_affiliation_strings":["University of California, Berkeley"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, Berkeley","institution_ids":["https://openalex.org/I95457486"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.8773,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.73787066,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":96},"biblio":{"volume":"16","issue":"6","first_page":"1208","last_page":"1221"},"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.9994999766349792,"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.9994999766349792,"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/T12016","display_name":"Web Data Mining and Analysis","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/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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8616711497306824},{"id":"https://openalex.org/keywords/exploit","display_name":"Exploit","score":0.6182734370231628},{"id":"https://openalex.org/keywords/rewriting","display_name":"Rewriting","score":0.6018682718276978},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6011559963226318},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.535156786441803},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.47548046708106995},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4420166313648224},{"id":"https://openalex.org/keywords/web-application","display_name":"Web application","score":0.42409494519233704},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4044259190559387},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3739137649536133},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2626611590385437},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.11263629794120789}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8616711497306824},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.6182734370231628},{"id":"https://openalex.org/C154690210","wikidata":"https://www.wikidata.org/wiki/Q1668499","display_name":"Rewriting","level":2,"score":0.6018682718276978},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6011559963226318},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.535156786441803},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.47548046708106995},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4420166313648224},{"id":"https://openalex.org/C118643609","wikidata":"https://www.wikidata.org/wiki/Q189210","display_name":"Web application","level":2,"score":0.42409494519233704},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4044259190559387},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3739137649536133},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2626611590385437},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.11263629794120789},{"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.14778/3583140.3583141","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3583140.3583141","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"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":19,"referenced_works":["https://openalex.org/W2006519067","https://openalex.org/W2066197965","https://openalex.org/W2102489964","https://openalex.org/W2111687586","https://openalex.org/W2239081428","https://openalex.org/W2421547754","https://openalex.org/W2439326083","https://openalex.org/W2536896242","https://openalex.org/W2751563242","https://openalex.org/W2794933251","https://openalex.org/W2911456401","https://openalex.org/W2953181121","https://openalex.org/W2964142859","https://openalex.org/W3030026364","https://openalex.org/W4206173014","https://openalex.org/W4229458497","https://openalex.org/W4234627795","https://openalex.org/W4291713239","https://openalex.org/W4300129074"],"related_works":["https://openalex.org/W3081572596","https://openalex.org/W2388669825","https://openalex.org/W988193086","https://openalex.org/W3118696700","https://openalex.org/W2362685264","https://openalex.org/W2380820245","https://openalex.org/W2350026801","https://openalex.org/W2386381555","https://openalex.org/W2380645807","https://openalex.org/W84373513"],"abstract_inverted_index":{"Exploiting":[0],"the":[1,37,52,56,81,96],"relationships":[2,26,43],"among":[3],"data":[4,13,25,28,42,83,112],"is":[5,14,92],"a":[6,66],"classical":[7],"query":[8,61,87],"optimization":[9],"technique.":[10],"As":[11],"persistent":[12],"increasingly":[15],"being":[16],"created":[17],"and":[18,60,117],"maintained":[19],"programmatically,":[20],"prior":[21],"work":[22],"that":[23,40,107],"infers":[24],"from":[27,114],"statistics":[29],"misses":[30],"an":[31,75],"important":[32],"opportunity.":[33],"We":[34],"present":[35],"Coco,":[36],"first":[38],"tool":[39],"identifies":[41],"by":[44],"analyzing":[45],"database-backed":[46],"applications.":[47],"Once":[48],"identified,":[49],"Coco":[50,73,108],"leverages":[51],"constraints":[53,84,113],"to":[54,78,85,95],"optimize":[55],"application's":[57],"physical":[58],"design":[59],"execution.":[62,88],"Instead":[63],"of":[64,69],"developing":[65],"fixed":[67],"set":[68],"predefined":[70],"rewriting":[71],"rules,":[72],"employs":[74],"enumerate-test-verify":[76],"technique":[77],"automatically":[79],"exploit":[80],"discovered":[82],"improve":[86,118],"Each":[89],"resulting":[90],"rewrite":[91],"provably":[93],"equivalent":[94],"original":[97],"query.":[98],"Using":[99],"14":[100],"real-world":[101,119],"web":[102],"applications,":[103],"our":[104],"experiments":[105],"show":[106],"can":[109],"discover":[110],"numerous":[111],"code":[115],"analysis":[116],"application":[120],"performance":[121],"significantly.":[122]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":2}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}