Refactoring Databases: Evolutionary Database Design (Hardcover)
暫譯: 重構資料庫：演進式資料庫設計 (精裝版)

Scott W. Ambler, Pramodkumar J. Sadalage

Refactoring Databases: Evolutionary Database Design (Hardcover)
  • 出版商: Addison Wesley
  • 出版日期: 2006-03-13
  • 定價: $2,275
  • 售價: 9.5 折 $2,161
  • 語言: 英文
  • 頁數: 384
  • 裝訂: Hardcover
  • ISBN: 0321293533
  • ISBN-13: 9780321293534
  • 相關分類: 資料庫、Refactoring

    • 立即出貨

買這商品的人也買了...

商品描述

Description  

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.

 

Table of Contents

About the Authors    xv

Forewords    xvii

Preface    xxi

Acknowledgments    xxvii

Chapter 1: Evolutionary Database Development    1

Chapter 2: Database Refactoring    13

Chapter 3: The Process of Database Refactoring    29

Chapter 4: Deploying into Production    49

Chapter 5: Database Refactoring Strategies    59

Chapter 6: Structural Refactorings    69

Chapter 7: Data Quality Refactorings    151

Chapter 8: Referential Integrity Refactorings    203

Chapter 9: Architectural Refactorings    231

Chapter 10: Method Refactorings    277

Chapter 11: Transformations    295

Appendix: The UML Data Modeling Notation    315

Glossary    321

References and Recommended Reading    327

Index    331

商品描述(中文翻譯)

描述
重構在各種開發專案中已證明其價值，幫助軟體專業人員改善系統設計、可維護性、可擴展性和性能。現在，領先的敏捷方法學家 Scott Ambler 和知名顧問 Pramodkumar Sadalage 首次介紹專門為資料庫系統設計的強大重構技術。

Ambler 和 Sadalage 展示了如何對表結構、數據、儲存過程和觸發器進行小的變更，可以顯著提升幾乎任何資料庫設計，而不改變語義。您將學會如何隨著源代碼的演變來發展資料庫架構，並在依賴迭代和敏捷方法論的專案中變得更加有效。

這本全面的指南和參考資料幫助您克服重構現實世界資料庫的實際障礙，涵蓋了資料庫重構的每一個基本概念。作者通過從頭到尾的範例，帶您了解如何重構簡單的獨立資料庫應用程式以及複雜的多應用程式場景。您將掌握重構資料庫架構的每一項任務，並發現即使在最複雜的生產環境中部署重構的最佳實踐。

本書的後半部分系統地涵蓋了五大類資料庫重構。您將學會如何使用重構來增強資料庫結構、數據質量和參考完整性；以及如何重構架構和方法。本書提供了一套廣泛的範例，使用 Oracle 和 Java 構建，並可輕鬆適應其他語言，如 C#、C++ 或 VB.NET，以及其他資料庫，如 DB2、SQL Server、MySQL 和 Sybase。

使用本書的技術和範例，您可以減少浪費、返工、風險和成本，並構建能夠平穩演變的資料庫系統，遠遠走向未來。

目錄
關於作者 xv
前言 xvii
序言 xxi
致謝 xxvii
第一章：演進式資料庫開發 1
第二章：資料庫重構 13
第三章：資料庫重構的過程 29
第四章：部署到生產環境 49
第五章：資料庫重構策略 59
第六章：結構重構 69
第七章：數據質量重構 151
第八章：參考完整性重構 203
第九章：架構重構 231
第十章：方法重構 277
第十一章：轉換 295
附錄：UML 數據建模符號 315
詞彙表 321
參考文獻與推薦閱讀 327
索引 331

類似商品