Write a Blog >>
ICSE 2020
Wed 24 June - Thu 16 July 2020
Sat 11 Jul 2020 00:24 - 00:36 at Silla - P27-Applications Chair(s): Ganesha Upadhyaya

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 Jul
Times are displayed in time zone: (UTC) Coordinated Universal Time change

00:00 - 01:00
00:00
12m
Talk
Big Code != Big Vocabulary: Open-Vocabulary Models for Source codeACM SIGSOFT Distinguished Paper AwardsArtifact ReusableTechnicalArtifact Available
Technical Papers
Rafael-Michael KarampatsisThe University of Edinburgh, Hlib BabiiFree University of Bozen-Bolzano, Romain RobbesFree University of Bozen-Bolzano, Charles SuttonGoogle Research, Andrea JanesFree University of Bozen-Bolzano
DOI Pre-print
00:12
12m
Talk
Engineering for a Science-Centric Experimentation PlatformSEIP
Software Engineering in Practice
Nikos DiamantopoulosNetflix, Inc., Jeffrey WongNetflix, Inc., David Issa MattosChalmers University of Technology, Ilias GerostathopoulosVrije Universiteit Amsterdam, Matthew WardropNetflix, Inc., Tobias MaoNetflix, Inc., Colin McFarlandNetflix, Inc.
00:24
12m
Talk
Managing data constraints in database-backed web applicationsArtifact ReusableTechnicalArtifact Available
Technical Papers
Junwen YangUniversity of Chicago, Utsav SethiUniversity of Chicago, Cong YanUniversity of Washington, Alvin CheungUniversity of California, Berkeley, Shan LuUniversity of Chicago
00:36
12m
Talk
Improving Data Scientist Efficiency with ProvenanceArtifact ReusableTechnicalArtifact Available
Technical Papers
Jingmei HuHarvard University, Jiwon JoungHarvard University, Maia JacobsHarvard University, Margo SeltzerUniversity of British Columbia, Krzysztof GajosHarvard University