Managing data constraints in database-backed web applications
There are often constraints associated with data used in software, restricting data length, value, uniqueness, and other properties. These constraints are particularly crucial for the reliability, maintability, and usability of database-backed web applications, where a huge amount of structured data is expected to persist in database and serve web users throughout software upgrade and database migration. In this paper, our comprehensive study about where data constraints are expressed, what they are about, when they evolve, and how their violations are handled in Ruby on Rails applications demonstrates that real-world developers struggle at maintaining consistent data constraints and constraint checking across different components and different versions of web applications, which led to many real-world software reliability, maintanability, and usability problems. Guided by our study, we developed checking tools and API enhancements that can automatically detect and help fix problems in data-constraint specification and violation handling.
Sat 11 JulDisplayed time zone: (UTC) Coordinated Universal Time change
00:00 - 01:00
P27-ApplicationsSoftware Engineering in Practice / Technical Papers at Silla
Chair(s): Ganesha Upadhyaya Harmony.one
|Big Code != Big Vocabulary: Open-Vocabulary Models for Source codeTechnical|
Rafael-Michael Karampatsis The University of Edinburgh, Hlib Babii Free University of Bozen-Bolzano, Romain Robbes Free University of Bozen-Bolzano, Charles Sutton Google Research, Andrea Janes Free University of Bozen-BolzanoDOI Pre-print
|Engineering for a Science-Centric Experimentation PlatformSEIP|
Software Engineering in Practice
Nikos Diamantopoulos Netflix, Inc., Jeffrey Wong Netflix, Inc., David Issa Mattos Chalmers University of Technology, Ilias Gerostathopoulos Vrije Universiteit Amsterdam, Matthew Wardrop Netflix, Inc., Tobias Mao Netflix, Inc., Colin McFarland Netflix, Inc.
|Managing data constraints in database-backed web applicationsTechnical|
Junwen Yang University of Chicago, Utsav Sethi University of Chicago, Cong Yan University of Washington, Alvin Cheung University of California, Berkeley, Shan Lu University of Chicago
|Improving Data Scientist Efficiency with ProvenanceTechnical|
Jingmei Hu Harvard University, Jiwon Joung Harvard University, Maia Jacobs Harvard University, Margo Seltzer University of British Columbia, Krzysztof Gajos Harvard University