GetWiki
Database refactoring
ARTICLE SUBJECTS
being →
database →
ethics →
fiction →
history →
internet →
language →
linux →
logic →
method →
news →
policy →
purpose →
religion →
science →
software →
truth →
unix →
wiki →
ARTICLE TYPES
essay →
feed →
help →
system →
wiki →
ARTICLE ORIGINS
critical →
forked →
imported →
original →
Database refactoring
please note:
- the content below is remote from Wikipedia
- it has been imported raw for GetWiki
A database refactoring is a simple change to a database schema that improves its design while retaining both its behavioral and informational semantics. Database refactoring does not change the way data is interpreted or used and does not fix bugs or add new functionality. Every refactoring to a database leaves the system in a working state, thus not causing maintenance lags, provided the meaningful data exists in the production environment. A database refactoring is conceptually more difficult than a code refactoring; code refactorings only need to maintain behavioral semantics while database refactorings also must maintain informational semantics.A database schema is typically refactored for one of several reasons: - the content below is remote from Wikipedia
- it has been imported raw for GetWiki
- To develop the schema in an evolutionary manner in parallel with the evolutionary design of the rest of the system.
- To fix design problems with an existing legacy database schema. Database refactorings are often motivated by the desire for database normalization of an existing production database, typically to "clean up" the design of the database.
- To implement what would be a large (and potentially risky) change as a series of small, low-risk changes.
Categories of database refactoring
In 2006 Scott Ambler, Pramod Sadalage Scott Ambler, Pramod Sadalage Refactoring Databases: Evolutionary Database Design - Addison-Wesley Professional; 1st edition (March 3, 2006) - 384 p. - {{ISBN|978-0321774514}} describe the following categories of database refactoring:Scott Ambler Catalog of Database Refactorings - Agile Data - URL:weblink- Architecture Refactoring
A change which improves the overall manner in which external programs interact with a database.
- Structural Refactoring
A change to the table structure of your database schema.
- Data Quality Refactoring
A change which improves and/or ensures the consistency and usage of the values stored within the database.
- Referential Integrity Refactoring
A change which ensures that a referenced row exists within another table and/or that ensures that a row which is no longer needed is removed appropriately.
- Transformation
A change which changes the semantics of your database schema by adding new elements to it or by modifying existing elements.
- Method Refactoring
A change which improves the quality of a stored procedure, stored function, or trigger.
- Access Refactoring
A change which relates to data access.
Process of database refactoring
The process of database refactoring is the act of applying database refactorings to evolve an existing database schema (database refactoring is a core practice of evolutionary database design). There are three considerations that need to be taken into account:- How a single refactoring is implemented
- How database refactorings are tracked and shared within organizations
- How a series of database refactorings are applied
See also
References
{{Reflist}}External links
- Database Refactoring Website by Pramod Sadalage
- content above as imported from Wikipedia
- "Database refactoring" does not exist on GetWiki (yet)
- time: 7:14am EDT - Sat, May 18 2024
- "Database refactoring" does not exist on GetWiki (yet)
- time: 7:14am EDT - Sat, May 18 2024
[ this remote article is provided by Wikipedia ]
LATEST EDITS [ see all ]
GETWIKI 23 MAY 2022
The Illusion of Choice
Culture
Culture
GETWIKI 09 JUL 2019
Eastern Philosophy
History of Philosophy
History of Philosophy
GETWIKI 09 MAY 2016
GetMeta:About
GetWiki
GetWiki
GETWIKI 18 OCT 2015
M.R.M. Parrott
Biographies
Biographies
GETWIKI 20 AUG 2014
GetMeta:News
GetWiki
GetWiki
© 2024 M.R.M. PARROTT | ALL RIGHTS RESERVED