By Scott W. Ambler

Refactoring has confirmed its price in quite a lot of improvement projects-helping software program pros enhance procedure designs, maintainability, extensibility, and function. Now, for the 1st time, prime agile methodologist Scott Ambler and popular advisor Pramodkumar Sadalage introduce strong refactoring innovations particularly designed for database systems.Ambler and Sadalage reveal how small alterations to desk constructions, facts, saved methods, and triggers can considerably improve nearly any database design-without altering semantics. you will how one can evolve database schemas in keeping with resource code-and turn into way more powerful in tasks counting on iterative, agile methodologies.This entire advisor and reference is helping you triumph over the sensible stumbling blocks to refactoring real-world databases by way of masking each primary inspiration underlying database refactoring. utilizing start-to-finish examples, the authors stroll you thru refactoring basic standalone database functions in addition to refined multi-application situations. you will grasp each job interested in refactoring database schemas, and detect top practices for deploying refactorings in even the main advanced construction environments.The moment half this ebook systematically covers 5 significant different types of database refactorings. you are going to the way to use refactoring to augment database constitution, info caliber, and referential integrity; and the way to refactor either architectures and techniques. This bookprovides an in depth set of examples equipped with Oracle and Java and simply adaptable for different languages, reminiscent of C#, C++, or VB.NET, and different databases, reminiscent of DB2, SQL Server, MySQL, and Sybase.Using this book's options and examples, you could decrease waste, transform, danger, and cost-and construct database platforms in a position to evolving easily, a long way into the long run.

Show description

Read or Download Refactoring Databases: Evolutionary Database Design PDF

Best structured design books

Java(tm) for S/390® and AS/400® COBOL Programmers

The e-book should still specialize in Java on AS400. additionally it makes use of visible Age that's outmoded should still use Websphere as a substitute. the code isn't transparent because it attempts to match COBOL(structure programing) with Java(Object orientated

Web Work: Information Seeking and Knowledge Work on the World Wide Web

This booklet brings jointly 3 nice motifs of the community society: the looking and utilizing of knowledge through participants and teams; the construction and alertness of information in enterprises; and the elemental transformation of those actions as they're enacted on the net and the realm broad internet.

On the Move to Meaningful Internet Systems 2007: OTM 2007 Workshops: OTM Confederated International Workshops and Posters, AWeSOMe, CAMS, OTM Academy Doctoral Consortium, MONET, OnToContent, ORM, PerSys, PPN, RDDS, SSWS, and SWWS 2007, Vilamoura, Portugal

This two-volume set LNCS 4805/4806 constitutes the refereed court cases of 10 overseas workshops and papers of the OTM Academy Doctoral Consortium held as a part of OTM 2007 in Vilamoura, Portugal, in November 2007. The 126 revised complete papers provided have been rigorously reviewed and chosen from a complete of 241 submissions to the workshops.

Dynamic Data-Driven Environmental Systems Science: First International Conference, DyDESS 2014, Cambridge, MA, USA, November 5-7, 2014, Revised Selected Papers

This e-book constitutes the refereed court cases of the 1st overseas convention on Dynamic Data-Driven Environmental structures technological know-how, DyDESS 2014, held in Cambridge, MA, united states, in November 2014.

Additional resources for Refactoring Databases: Evolutionary Database Design

Sample text

When the problem is eventually discovered, the report may need to be updated to reflect the new format. Similarly, with respect to behavioral semantics, the goal is to keep the black-box functionality the sameany source code that works with the changed aspects of your database schema must be reworked to accomplish the same functionality as before. For example, if you apply Introduce Calculation Method (page 245), you may want to rework other existing stored procedures to invoke that method rather than implement the same logic for that calculation.

Common code smells include switch statements, long methods, duplicated code, and feature envy. Similarly, there are common database smells that indicate the potential need to refactor it (Ambler 2003). These smells include the following: Multipurpose column. If a column is being used for several purposes, it is likely that extra code exists to ensure that the source data is being used the "right way," often by checking the values of one or more other columns. An example is a column used to store either someone's birth date if he or she is a customer or the start date if that person is an employee.

However, what he did not realize was that the column already exists in the Customer table, which is arguably the wrong place for it to beEddy had identified the problem correctly, but had misidentified the solution. Based on her knowledge of the existing database schema, and her understanding of the problem identified by Eddy, Beverley instead suggests that they apply the Move Column (page 103) refactoring. Sometimes the Data Is Elsewhere Your database is likely not the only source of data within your organization.

Download PDF sample

Rated 4.14 of 5 – based on 40 votes