Refactoring Databases: Evolutionary Database Design (paperback) (Addison-Wesley Signature Series (Fowler))

3,66 valoración promedio
( 118 valoraciones por Goodreads )
 
9780321774514: Refactoring Databases: Evolutionary Database Design (paperback) (Addison-Wesley Signature Series (Fowler))

Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance. Now, for the first time, leading agile methodologist Scott Ambler and renowned consultant Pramodkumar Sadalage introduce powerful refactoring techniques specifically designed for database systems.

 

Ambler and Sadalage demonstrate how small changes to table structures, data, stored procedures, and triggers can significantly enhance virtually any database design–without changing semantics. You’ll learn how to evolve database schemas in step with source code–and become far more effective in projects relying on iterative, agile methodologies.

 

This comprehensive guide and reference helps you overcome the practical obstacles to refactoring real-world databases by covering every fundamental concept underlying database refactoring. Using start-to-finish examples, the authors walk you through refactoring simple standalone database applications as well as sophisticated multi-application scenarios. You’ll master every task involved in refactoring database schemas, and discover best practices for deploying refactorings in even the most complex production environments.

 

The second half of this book systematically covers five major categories of database refactorings. You’ll learn how to use refactoring to enhance database structure, data quality, and referential integrity; and how to refactor both architectures and methods. This book provides an extensive set of examples built with Oracle and Java and easily adaptable for other languages, such as C#, C++, or VB.NET, and other databases, such as DB2, SQL Server, MySQL, and Sybase.

 

Using this book’s techniques and examples, you can reduce waste, rework, risk, and cost–and build database systems capable of evolving smoothly, far into the future.

"Sinopsis" puede pertenecer a otra edición de este libro.

About the Author:

Scott W. Ambler is a software process improvement (SPI) consultant living just north of Toronto. He is founder and practice leader of the Agile Modeling (AM) (www.agilemodeling.com), Agile Data (AD) (www.agiledata.org), Enterprise Unified Process (EUP) (www.enterpriseunifiedprocess.com), and Agile Unified Process (AUP) (www.ambysoft.com/unifiedprocess) methodologies. Scott is the (co-)author of several books, including Agile Modeling (John Wiley & Sons, 2002), Agile Database Techniques (John Wiley & Sons, 2003), The Object Primer, Third Edition (Cambridge University Press, 2004), The Enterprise Unified Process (Prentice Hall, 2005), and The Elements of UML 2.0 Style (Cambridge University Press, 2005). Scott is a contributing editor with Software Development magazine (www.sdmagazine.com) and has spoken and keynoted at a wide variety of international conferences, including Software Development, UML World, Object Expo, Java Expo, and Application Development. Scott graduated from the University of Toronto with a Master of Information Science. In his spare time Scott studies the Goju Ryu and Kobudo styles of karate.

 

Pramod J. Sadalage is a consultant for ThoughtWorks, an enterprise application development and integration company. He first pioneered the practices and processes of evolutionary database design and database refactoring in 1999 while working on a large J2EE application using the Extreme Programming (XP) methodology. Since then, Pramod has applied the practices and processes to many projects. Pramod writes and speaks about database administration on evolutionary projects, the adoption of evolutionary processes with regard to databases, and evolutionary practices’ impact upon database administration, in order to make it easy for everyone to use evolutionary design in regards to databases. When he is not working, you can find him spending time with his wife and daughter and trying to improve his running.

 

Excerpt. © Reprinted by permission. All rights reserved.:

Refactoring Databases

Refactoring Databases

Evolutionary Database Design

Preface

Evolutionary, and often agile, software development methodologies, such as Extreme Programming (XP), Scrum, the Rational Unified Process (RUP), the Agile Unified Process (AUP), and Feature-Driven Development (FDD), have taken the information technology (IT) industry by storm over the past few years. For the sake of definition, an evolutionary method is one that is both iterative and incremental in nature, and an agile method is evolutionary and highly collaborative in nature. Furthermore, agile techniques such as refactoring, pair programming, Test-Driven Development (TDD), and Agile Model-Driven Development (AMDD) are also making headway into IT organizations. These methods and techniques have been developed and have evolved in a grassroots manner over the years, being honed in the software trenches, as it were, instead of formulated in ivory towers. In short, this evolutionary and agile stuff seems to work incredibly well in practice.

In the seminal book Refactoring, Martin Fowler describes a refactoring as a small change to your source code that improves its design without changing its semantics. In other words, you improve the quality of your work without breaking or adding anything. In the book, Martin discusses the idea that just as it is possible to refactor your application source code, it is also possible to refactor your database schema. However, he states that database refactoring is quite hard because of the significant levels of coupling associated with databases, and therefore he chose to leave it out of his book.

Since 1999 when Refactoring was published, the two of us have found ways to refactor database schemas. Initially, we worked separately, running into each other at conferences such as Software Development (http://www.sdexpo.com) and on mailing lists (http://www.agiledata.org/feedback.html). We discussed ideas, attended each other's conference tutorials and presentations, and quickly discovered that our ideas and techniques overlapped and were highly compatible with one another. So we joined forces to write this book, to share our experiences and techniques at evolving database schemas via refactoring.

The examples throughout the book are written in Java, Hibernate, and Oracle code. Virtually every database refactoring description includes code to modify the database schema itself, and for some of the more interesting refactorings, we show the effects they would have on Java application code. Because all databases are not created alike, we include discussions of alternative implementation strategies when important nuances exist between database products. In some instances we discuss alternative implementations of an aspect of a refactoring using Oracle-specific features such as the SE,T UNUSED or RENAME TO commands, and many of our code examples take advantage of Oracle's COMMENT ON feature. Other database products include other features that make database refactoring easier, and a good DBA will know how to take advantage of these things. Better yet, in the future database refactoring tools will do this for us. Furthermore, we have kept the Java code simple enough so that you should be able to convert it to C#, C++, or even Visual Basic with little problem at all.

Why Evolutionary Database Development?

Evolutionary database development is a concept whose time has come. Instead of trying to design your database schema up front early in the project, you instead build it up throughout the life of a project to reflect the changing requirements defined by your stakeholders. Like it or not, requirements change as your project progresses. Traditional approaches have denied this fundamental reality and have tried to "manage change," a euphemism for preventing change, through various means. Practitioners of modern development techniques instead choose to embrace change and follow techniques that enable them to evolve their work in step with evolving requirements. Programmers have adopted techniques such as TDD, refactoring, and AMDD and have built new development tools to make this easy. As we have done this, we have realized that we also need techniques and tools to support evolutionary database development.

Advantages to an evolutionary approach to database development include the following:

  1. You minimize waste. An evolutionary, just-in-time (JIT) approach enables you to avoid the inevitable wastage inherent in serial techniques when requirements change. Any early investment in detailed requirements, architecture, and design artifacts is lost when a requirement is later found to be no longer needed. If you have the skills to do the work up front, clearly you must have the skills to do the same work JIT.

  2. You avoid significant rework. As you will see in Chapter 1, "Evolutionary Database Development," you should still do some initial modeling up front to think major issues through, issues that could potentially lead to significant rework if identified late in the project; you just do not need to investigate the details early.

  3. You always know that your system works. With an evolutionary approach, you regularly produce working software, even if it is just deployed into a demo environment, which works. When you have a new, working version of the system every week or two, you dramatically reduce your project's risk.

  4. You always know that your database design is the highest quality possible. This is exactly what database refactoring is all about: improving your schema design a little bit at a time.

  5. You work in a compatible manner with developers. Developers work in an evolutionary manner, and if data professionals want to be effective members of modern development teams, they also need to choose to work in an evolutionary manner.

  6. You reduce the overall effort. By working in an evolutionary manner, you only do the work that you actually need today and no more.

There are also several disadvantages to evolutionary database development:

  1. Cultural impediments exist. Many data professionals prefer to follow a serial approach to software development, often insisting that some form of detailed logical and physical data models be created and baselined before programming begins. Modern methodologies have abandoned this approach as being too inefficient and risky, thereby leaving many data professionals in the cold. Worse yet, many of the "thought leaders" in the data community are people who cut their teeth in the 1970s and 1980s but who missed the object revolution of the 1990s, and thereby missed gaining experience in evolutionary development. The world changed, but they did not seem to change with it. As you will learn in this book, it is not only possible for data professionals to work in an evolutionary, if not agile, manner, it is in fact a preferable way to work.

  2. Learning curve. It takes time to learn these new techniques, and even longer if you also need to change a serial mindset into an evolutionary one.

  3. Tool support is still evolving. When Refactoring was published in 1999, no tools supported the technique. Just a few years later, every single integrated development environment (IDE) has code-refactoring features built right in to it. At the time of this writing, there are no database refactoring tools in existence, although we do include all the code that you need to implement the refactorings by hand. Luckily, the Eclipse Data Tools Project (DTP) has indicated in their project prospectus the need to develop database-refactoring functionality in Eclipse, so it is only a matter of time before the tool vendors catch up.

Agility in a Nutshell

Although this is not specifically a book about agile software development, the fact is that database refactoring is a primary technique for agile developers. A pro...

"Sobre este título" puede pertenecer a otra edición de este libro.

Los mejores resultados en AbeBooks

1.

Ambler, Scott JSadalage, Pramodkumar J.
Editorial: Prentice Hall
ISBN 10: 0321774515 ISBN 13: 9780321774514
Nuevos Cantidad: > 20
Librería
INDOO
(Avenel, NJ, Estados Unidos de America)
Valoración
[?]

Descripción Prentice Hall. Estado de conservación: New. Brand New. Nº de ref. de la librería 0321774515

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 33,46
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 2,95
A Estados Unidos de America
Destinos, gastos y plazos de envío

2.

Scott J. Ambler, Pramodkumar J. Sadalage
Editorial: Pearson Education (US), United States (2011)
ISBN 10: 0321774515 ISBN 13: 9780321774514
Nuevos Paperback Cantidad: 10
Librería
Book Depository hard to find
(London, Reino Unido)
Valoración
[?]

Descripción Pearson Education (US), United States, 2011. Paperback. Estado de conservación: New. Language: English . This book usually ship within 10-15 business days and we will endeavor to dispatch orders quicker than this where possible. Brand New Book. Refactoring has proven its value in a wide range of development projects-helping software professionals improve system designs, maintainability, extensibility, and performance. Now, for the first time, leading agile methodologist Scott Ambler and renowned consultant Pramodkumar Sadalage introduce powerful refactoring techniques specifically designed for database systems. Ambler and Sadalage demonstrate how small changes to table structures, data, stored procedures, and triggers can significantly enhance virtually any database design-without changing semantics. You ll learn how to evolve database schemas in step with source code-and become far more effective in projects relying on iterative, agile methodologies. This comprehensive guide and reference helps you overcome the practical obstacles to refactoring real-world databases by covering every fundamental concept underlying database refactoring. Using start-to-finish examples, the authors walk you through refactoring simple standalone database applications as well as sophisticated multi-application scenarios. You ll master every task involved in refactoring database schemas, and discover best practices for deploying refactorings in even the most complex production environments. The second half of this book systematically covers five major categories of database refactorings. You ll learn how to use refactoring to enhance database structure, data quality, and referential integrity; and how to refactor both architectures and methods. This book provides an extensive set of examples built with Oracle and Java and easily adaptable for other languages, such as C#, C++, or , and other databases, such as DB2, SQL Server, MySQL, and Sybase. Using this book s techniques and examples, you can reduce waste, rework, risk, and cost-and build database systems capable of evolving smoothly, far into the future. Nº de ref. de la librería BTE9780321774514

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 49,94
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

3.

Scott J Ambler, Pramod J. Sadalage
Editorial: Addison-Wesley Professional (2006)
ISBN 10: 0321774515 ISBN 13: 9780321774514
Nuevos Paperback Cantidad: 1
Librería
Ergodebooks
(RICHMOND, TX, Estados Unidos de America)
Valoración
[?]

Descripción Addison-Wesley Professional, 2006. Paperback. Estado de conservación: New. 1. Nº de ref. de la librería DADAX0321774515

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 50,36
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,37
A Estados Unidos de America
Destinos, gastos y plazos de envío

4.

Scott J Ambler; Pramod J. Sadalage
Editorial: Addison-Wesley Professional (2006)
ISBN 10: 0321774515 ISBN 13: 9780321774514
Nuevos Paperback Primera edición Cantidad: 1
Librería
Irish Booksellers
(Rumford, ME, Estados Unidos de America)
Valoración
[?]

Descripción Addison-Wesley Professional, 2006. Paperback. Estado de conservación: New. book. Nº de ref. de la librería M0321774515

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 56,48
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

5.

Scott J Ambler; Pramod J. Sadalage
Editorial: Addison-Wesley Professional (2006)
ISBN 10: 0321774515 ISBN 13: 9780321774514
Nuevos Tapa blanda Cantidad: > 20
Librería
Palexbooks
(Sanford, NC, Estados Unidos de America)
Valoración
[?]

Descripción Addison-Wesley Professional, 2006. Estado de conservación: New. Brand new! Please provide a physical shipping address. Nº de ref. de la librería 9780321774514

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 58,21
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 2,53
A Estados Unidos de America
Destinos, gastos y plazos de envío

6.

Ambler, Scott J; Sadalage, Pramod J.
Editorial: Addison-Wesley Professional
ISBN 10: 0321774515 ISBN 13: 9780321774514
Nuevos PAPERBACK Cantidad: 3
Librería
BarristerBooks
(Lawrence, KS, Estados Unidos de America)
Valoración
[?]

Descripción Addison-Wesley Professional. PAPERBACK. Estado de conservación: New. 0321774515 BRAND NEW W/FAST SHIPPING! This item is: Refactoring Databases: Evolutionary Database Design (paperback), 1st Ed., 2006, by Ambler, Scott J^Sadalage, Pramod J.; FORMAT: Paperback; ISBN: 9780321774514. Choose Expedited for fastest shipping! Our 98%+ rating proves our commitment! We cannot ship to PO Boxes/APO address. To avoid ordering the wrong item, please check your item's ISBN number!. Nº de ref. de la librería P9780321774514

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 62,15
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

7.

Ambler, Scott J./ Sadalage, Pramodkumar J.
Editorial: Addison-Wesley Professional (2011)
ISBN 10: 0321774515 ISBN 13: 9780321774514
Nuevos Paperback Cantidad: 1
Librería
Revaluation Books
(Exeter, Reino Unido)
Valoración
[?]

Descripción Addison-Wesley Professional, 2011. Paperback. Estado de conservación: Brand New. 1st edition. 384 pages. 9.20x7.00x0.90 inches. In Stock. Nº de ref. de la librería zk0321774515

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 66,40
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 6,66
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

8.

Ambler, Scott J, Sadalage, Pramod J.
Editorial: Addison-Wesley Professional (2006)
ISBN 10: 0321774515 ISBN 13: 9780321774514
Nuevos Paperback Cantidad: 2
Librería
Murray Media
(North Miami Beach, FL, Estados Unidos de America)
Valoración
[?]

Descripción Addison-Wesley Professional, 2006. Paperback. Estado de conservación: New. Never used!. Nº de ref. de la librería P110321774515

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 74,10
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 1,68
A Estados Unidos de America
Destinos, gastos y plazos de envío

9.

Ambler, Scott J, Sadalage, Pramod J.
Editorial: Addison-Wesley Professional (2006)
ISBN 10: 0321774515 ISBN 13: 9780321774514
Nuevos Cantidad: 1
Librería
Nearfine Books
(Brooklyn, NY, Estados Unidos de America)
Valoración
[?]

Descripción Addison-Wesley Professional, 2006. Estado de conservación: new. Shiny and new! Expect delivery in 20 days. Nº de ref. de la librería 9780321774514-1

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 73,02
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,38
A Estados Unidos de America
Destinos, gastos y plazos de envío

10.

Scott J. Ambler
ISBN 10: 0321774515 ISBN 13: 9780321774514
Nuevos Paperback Cantidad: 1
Librería
AussieBookSeller
(SILVERWATER, NSW, Australia)
Valoración
[?]

Descripción 2006. Paperback. Estado de conservación: New. Paperback. Refactoring has proven its value in a wide range of development projects-helping software professionals improve system designs, maintainability, extensibility, and performance.Shipping may be from our Sydney, NSW warehouse or from our UK or US warehouse, depending on stock availability. 384 pages. 0.598. Nº de ref. de la librería 9780321774514

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 54,94
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 31,23
De Australia a Estados Unidos de America
Destinos, gastos y plazos de envío