Schema Evolution in Interactive Programming Systems

TL;DR

This paper explores schema evolution challenges in interactive programming systems beyond databases, proposing challenge problems and a framework to improve live programming and collaboration.

Contribution

It introduces a set of challenge problems and a layered framework for schema evolution in diverse interactive programming contexts, extending beyond traditional database scenarios.

Findings

Identifies schema evolution as a barrier to live programming and collaboration.

Defines layers and dimensions of schema evolution across contexts.

Provides challenge problems to guide future research.

Abstract

Many improvements to programming have come from shortening feedback loops, for example with Integrated Development Environments, Unit Testing, Live Programming, and Distributed Version Control. A barrier to feedback that deserves greater attention is Schema Evolution. When requirements on the shape of data change then existing data must be migrated into the new shape, and existing code must be modified to suit. Currently these adaptations are often performed manually, or with ad hoc scripts. Manual schema evolution not only delays feedback but since it occurs outside the purview of version control tools it also interrupts collaboration. Schema evolution has long been studied in databases. We observe that the problem also occurs in non-database contexts that have been less studied. We present a suite of challenge problems exemplifying this range of contexts, including traditional database programming as well as live front-end programming, model-driven development, and collaboration in computational documents. We systematize these various contexts by defining a set of layers and dimensions of schema evolution. We offer these challenge problems to ground future research on the general problem of schema evolution in interactive programming systems and to serve as a basis for evaluating the results of that research. We hope that better support for schema evolution will make programming more live and collaboration more fluid.