{"id":"https://openalex.org/W3089552543","doi":"https://doi.org/10.1145/3377811.3380375","title":"Managing data constraints in database-backed web applications","display_name":"Managing data constraints in database-backed web applications","publication_year":2020,"publication_date":"2020-06-27","ids":{"openalex":"https://openalex.org/W3089552543","doi":"https://doi.org/10.1145/3377811.3380375","mag":"3089552543"},"language":"en","primary_location":{"id":"doi:10.1145/3377811.3380375","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3377811.3380375","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3377811.3380375","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM/IEEE 42nd International Conference on Software Engineering","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3377811.3380375","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5103066770","display_name":"Junwen Yang","orcid":"https://orcid.org/0000-0003-0481-6982"},"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":"Junwen Yang","raw_affiliation_strings":["University of Chicago"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Chicago","institution_ids":["https://openalex.org/I40347166"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5086033051","display_name":"Utsav Sethi","orcid":"https://orcid.org/0009-0002-5865-6187"},"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":"Utsav Sethi","raw_affiliation_strings":["University of Chicago"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Chicago","institution_ids":["https://openalex.org/I40347166"]}]},{"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/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Cong Yan","raw_affiliation_strings":["University of Washington"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Washington","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5059427197","display_name":"Alvin Cheung","orcid":"https://orcid.org/0000-0001-6261-6263"},"institutions":[{"id":"https://openalex.org/I2803209242","display_name":"University of California System","ror":"https://ror.org/00pjdza24","country_code":"US","type":"education","lineage":["https://openalex.org/I2803209242"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alvin Cheung","raw_affiliation_strings":["University of California"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California","institution_ids":["https://openalex.org/I2803209242"]}]},{"author_position":"last","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"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.8193,"has_fulltext":true,"cited_by_count":9,"citation_normalized_percentile":{"value":0.86571842,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1098","last_page":"1109"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12479","display_name":"Web Application Security Vulnerabilities","score":0.9980999827384949,"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.9980999827384949,"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/T12127","display_name":"Software System Performance and Reliability","score":0.9973999857902527,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9969000220298767,"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.8390616178512573},{"id":"https://openalex.org/keywords/usability","display_name":"Usability","score":0.6239606142044067},{"id":"https://openalex.org/keywords/reliability","display_name":"Reliability (semiconductor)","score":0.5189751982688904},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5142111778259277},{"id":"https://openalex.org/keywords/data-integrity","display_name":"Data integrity","score":0.4740455150604248},{"id":"https://openalex.org/keywords/data-quality","display_name":"Data quality","score":0.463102787733078},{"id":"https://openalex.org/keywords/web-application","display_name":"Web application","score":0.4624718725681305},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.4134829342365265},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3473740816116333},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.22659441828727722}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8390616178512573},{"id":"https://openalex.org/C170130773","wikidata":"https://www.wikidata.org/wiki/Q216378","display_name":"Usability","level":2,"score":0.6239606142044067},{"id":"https://openalex.org/C43214815","wikidata":"https://www.wikidata.org/wiki/Q7310987","display_name":"Reliability (semiconductor)","level":3,"score":0.5189751982688904},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5142111778259277},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.4740455150604248},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.463102787733078},{"id":"https://openalex.org/C118643609","wikidata":"https://www.wikidata.org/wiki/Q189210","display_name":"Web application","level":2,"score":0.4624718725681305},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.4134829342365265},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3473740816116333},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.22659441828727722},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C176217482","wikidata":"https://www.wikidata.org/wiki/Q860554","display_name":"Metric (unit)","level":2,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.0},{"id":"https://openalex.org/C163258240","wikidata":"https://www.wikidata.org/wiki/Q25342","display_name":"Power (physics)","level":2,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3377811.3380375","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3377811.3380375","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3377811.3380375","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM/IEEE 42nd International Conference on Software Engineering","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3377811.3380375","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3377811.3380375","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3377811.3380375","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM/IEEE 42nd International Conference on Software Engineering","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1538450311","display_name":"CSR: Medium:Combating Distributed Concurrency Bugs in Cloud Systems","funder_award_id":"1563956","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G1952784096","display_name":"CAREER: Generating Application-Specific Database Management Systems","funder_award_id":"1651489","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G2551027135","display_name":"USING VERIFIED LIFTING TO OPTIMIZE LEGACY STENCIL CODES","funder_award_id":"DESC0016260","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"},{"id":"https://openalex.org/G2951368287","display_name":"SI2-SSE: An Ecosystem of Reusable Image Analytics Pipelines","funder_award_id":"1739419","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G2986590756","display_name":"BIGDATA: Collaborative Research: F: Holistic Optimization of Data-Driven Applications","funder_award_id":"1546543","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G3785592558","display_name":null,"funder_award_id":"FA8750-16-2-0032","funder_id":"https://openalex.org/F4320332180","funder_display_name":"Defense Advanced Research Projects Agency"},{"id":"https://openalex.org/G4161253729","display_name":"CSR: Medium:Collaborative Research:Holistic, Cross-Site, Hybrid System Anomaly Debugging for Large Scale Hosting Infrastructures","funder_award_id":"1514256","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G4451656","display_name":"BIGDATA: Collaborative Research: F: Holistic Optimization of Data-Driven Applications","funder_award_id":"1546083","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G4713059963","display_name":null,"funder_award_id":"FA8750","funder_id":"https://openalex.org/F4320332180","funder_display_name":"Defense Advanced Research Projects Agency"},{"id":"https://openalex.org/G5889228478","display_name":"CSR: Medium: Understanding and Automatically Adjusting Performance Sensitive Software Configurations","funder_award_id":"1764039","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G6237349253","display_name":"FMitF: Collaborative Research: User-Centered Verification and Repair of Trigger-Action Programs","funder_award_id":"1837120","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G8429701143","display_name":null,"funder_award_id":"FA8750-16-2-0032","funder_id":"https://openalex.org/F4320306084","funder_display_name":"U.S. Department of Energy"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320306084","display_name":"U.S. Department of Energy","ror":"https://ror.org/01bj3aw27"},{"id":"https://openalex.org/F4320308943","display_name":"Microsoft Research","ror":"https://ror.org/00d0nc645"},{"id":"https://openalex.org/F4320332180","display_name":"Defense Advanced Research Projects Agency","ror":"https://ror.org/02caytj08"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3089552543.pdf","grobid_xml":"https://content.openalex.org/works/W3089552543.grobid-xml"},"referenced_works_count":27,"referenced_works":["https://openalex.org/W2004188181","https://openalex.org/W2007237548","https://openalex.org/W2007842496","https://openalex.org/W2062666593","https://openalex.org/W2118731196","https://openalex.org/W2236986911","https://openalex.org/W2340417905","https://openalex.org/W2364861723","https://openalex.org/W2375206141","https://openalex.org/W2421547754","https://openalex.org/W2503947316","https://openalex.org/W2518442919","https://openalex.org/W2584709123","https://openalex.org/W2612177096","https://openalex.org/W2621453480","https://openalex.org/W2766208582","https://openalex.org/W2767894601","https://openalex.org/W2794933251","https://openalex.org/W2898350230","https://openalex.org/W2898912109","https://openalex.org/W2904268094","https://openalex.org/W2953181121","https://openalex.org/W2963046270","https://openalex.org/W2963426888","https://openalex.org/W2970508121","https://openalex.org/W3100118001","https://openalex.org/W4243417617"],"related_works":["https://openalex.org/W3041894995","https://openalex.org/W2146933441","https://openalex.org/W3089353361","https://openalex.org/W2083062572","https://openalex.org/W3175087045","https://openalex.org/W4310519870","https://openalex.org/W1485984927","https://openalex.org/W3081133439","https://openalex.org/W4387006424","https://openalex.org/W2945537679"],"abstract_inverted_index":{"Database-backed":[0],"web":[1,87],"applications":[2,11],"manipulate":[3],"large":[4],"amounts":[5],"of":[6,35,85,114],"persistent":[7],"data,":[8],"and":[9,21,33,60,77,83,101,110],"such":[10,108,115],"often":[12,57],"contain":[13],"constraints":[14,26,49,76],"that":[15,69,104],"restrict":[16],"data":[17,19,23,48,75],"length,":[18],"value,":[20],"other":[22],"properties.":[24],"Such":[25],"are":[27,50,54,64],"critical":[28],"in":[29],"ensuring":[30],"the":[31,112],"reliability":[32],"usability":[34],"these":[36],"applications.":[37,116],"In":[38],"this":[39],"paper,":[40],"we":[41,97],"present":[42],"a":[43],"comprehensive":[44],"study":[45],"on":[46],"where":[47],"expressed,":[51],"what":[52],"they":[53,58],"about,":[55],"how":[56,61],"evolve,":[59],"their":[62,86],"violations":[63],"handled.":[65],"The":[66],"results":[67],"show":[68],"developers":[70],"struggle":[71],"with":[72],"maintaining":[73],"consistent":[74],"checking":[78,99],"them":[79],"across":[80],"different":[81],"components":[82],"versions":[84],"applications,":[88],"leading":[89],"to":[90],"various":[91],"problems.":[92],"Guided":[93],"by":[94],"our":[95],"study,":[96],"developed":[98],"tools":[100],"API":[102],"enhancements":[103],"can":[105],"automatically":[106],"detect":[107],"problems":[109],"improve":[111],"quality":[113]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":2},{"year":2020,"cited_by_count":1}],"updated_date":"2026-08-06T08:24:18.245995","created_date":"2025-10-10T00:00:00"}