Test-Driven Database Development: Unlocking Agility (Paperback)

The practice of Test-Driven Development (TDD) has helped thousands of software developers improve quality, agility, productivity, and speed. In Test-Driven Database Development , Max Guernsey, III shows how to adapt TDD to achieve the same powerful benefits in database design and development.

Guernsey first explains why TDD offers so much potential to database practitioners, and how to overcome obstacles such as the lack of conventional “testable classes.” You’ll learn how to use “classes of databases” to manage change more effectively; how to define testable database behaviors; how to maximize long-term maintainability by limiting a database’s current scope; and how to use “emergent design” to simplify future expansion.

Building on this foundation, the author guides you through implementing modern TDD processes and database refactoring. He presents practical techniques for improving legacy databases; for deviating from strict TDD when necessary; and for adapting TDD to applications that persist data in file systems, XML, or serialized objects. Guernsey shows how to

•  Build a simple infrastructure to track and standardize scripts and databases
•  Define a sustainable TDD process for database design
•  Safely change a design without losing data
•  Design new databases that are lighter, leaner, simpler, more testable, and easier to change
•  Reduce design costs by eliminating duplication
•  Gradually bring the benefits of TDD, agility, and modern design to legacy databases
•  Remediate errors that find their way into database designs
•  Isolate behaviors and avoid unwanted dependencies that cause tests to fail

With this book as a guide, you will learn how to apply the proven practice of TDD to your database needs, and organize and optimize your organization’s data for a significant competitive advantage.
 

Test-Driven Database Development is the newest title in the highly respected NetObjectives Lean-Agile Series.

測試驅動開發（TDD）的實踐幫助了成千上萬的軟體開發人員提高了品質、敏捷性、生產力和速度。在《測試驅動資料庫開發》一書中，Max Guernsey, III 展示了如何適應 TDD，以在資料庫設計和開發中獲得同樣強大的好處。

Guernsey 首先解釋了為什麼 TDD 對於資料庫從業人員具有如此大的潛力，以及如何克服缺乏傳統的“可測試類”的障礙。您將學習如何使用“資料庫類”更有效地管理變更；如何定義可測試的資料庫行為；如何通過限制資料庫的當前範圍來最大程度地提高長期可維護性；以及如何使用“新興設計”來簡化未來擴展。

在此基礎上，作者引導您實施現代 TDD 流程和資料庫重構。他提出了改進遺留資料庫的實用技術；在必要時偏離嚴格的 TDD；以及將 TDD 適應於在檔案系統、XML 或序列化對象中持久化數據的應用程序。Guernsey 展示了如何：

• 建立一個簡單的基礎設施來跟踪和標準化腳本和資料庫
• 為資料庫設計定義可持續的 TDD 流程
• 安全地更改設計而不丟失數據
• 設計更輕、更簡單、更易測試和更易於更改的新資料庫
• 通過消除重複來降低設計成本
• 逐步將 TDD、敏捷性和現代設計的好處帶給遺留資料庫
• 糾正進入資料庫設計的錯誤
• 隔離行為並避免導致測試失敗的不需要的依賴關係

有了這本書作為指南，您將學習如何將經過驗證的 TDD 實踐應用於您的資料庫需求，並組織和優化您組織的數據，獲得顯著的競爭優勢。

《測試驅動資料庫開發》是備受尊敬的 NetObjectives Lean-Agile 系列中的最新著作。