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 ...

Get Refactoring Databases: Evolutionary Database Design 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.