Chapter 7. Building for Maintainability

Designing databases that can easily be maintained is important. In the application development domain, developers learned that the most maintainable things are often the things with the simplest designs that support the current requirements. That also applies in the database world as well.

Building a maintainable database depends on developing only the minimum amount of behavior required to support the current needs of the applications that use a database design. The minimum amount of behavior required is that amount that is necessary to absorb and emit the information demanded by a database’s clients.

With databases, specifying only those behaviors that are actually needed is difficult, so hiding from ...

Get Test-Driven Database Development: Unlocking Agility now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.