O'Reilly logo

Refactoring Databases: Evolutionary Database Design by Pramod J. Sadalage, Scott W. Ambler

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9Architectural Refactorings

Architectural refactorings are changes that improve the overall manner in which external programs interact with a database. The architectural refactorings are as follows:

• Add CRUD Methods

• Add Mirror Table

• Add Read Method

• Encapsulate Table With View

• Introduce Calculation Method

• Introduce Index

• Introduce Read-Only Table

• Migrate Method From Database

• Migrate Method To Database

• Replace Method(s) With View

• Replace View With Method(s)

• Use Official Data Source

Add CRUD Methods

Introduce four stored procedures (methods) to implement the creation, retrieval, update, and deletion (CRUD) of the data representing a business entity. After these stored procedures are in place, access to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required