© Michael L. Perry 2020
M. L. PerryThe Art of Immutable Architecturehttps://doi.org/10.1007/978-1-4842-5955-9_10

10. SQL Databases

Michael L. Perry1 
(1)
Allen, TX, USA
 

Immutable models are all about constraints. An application must not modify data. It is disallowed from deleting or overwriting information. These constraints are the axioms upon which the mathematical structure of immutable architecture is built. Ensuring that these constraints are met is the responsibility of every layer of the application stack, right down to the data storage system.

An immutable model can be backed by any kind of data store. One of the most powerful, flexible, and popular forms of storage engine is the relational database. Translating the constraints of the immutable ...

Get The Art of Immutable Architecture: Theory and Practice of Data Management in Distributed Systems now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.