Agile Database Techniques: Effective Strategies for the Agile Software Developer

  • 7h 24m
  • Scott W. Ambler
  • John Wiley & Sons (US)
  • 2003

An agile database administrator (DBA) has the difficult task of focusing on data-oriented issues, including traditional database administration as well as any application development involving data. Agile DBAs also collaborate with enterprise professionals to ensure that the efforts of the project team reflect enterprise realities. Scott Ambler has written this invaluable book from the point of view of an agile DBA, enabling you to learn the techniques that agile DBAs use to work effectively on evolutionary (iterative and incremental) software projects.

With every chapter you’ll be introduced to essential facets of data-oriented activities such as:

  • The basics of object orientation, relational databases, data modeling, and how to deal with legacy data issues
  • Database refactoring, an evolutionary technique that enables you to improve your database design in small steps
  • Mapping objects to relational databases, performance tuning, database encapsulation, and supporting tools
  • Implementation techniques and strategies such as concurrency control, security access control, finding objects in relational databases, referential integrity, and the effective use of XML
  • Strategies and advice for individuals who want to become agile software developers and organizations that want to adopt agile techniques

About the Author

Scott W. Ambler is a senior consultant with Ronin International, Inc., a firm specializing in helping organizations to adopt new software-development techniques. Scott is a senior contributing editor with Software Development and the (co)author of numerous books, including Agile Modeling, Mastering EJB, Second Edition, and The Object Primer.

In this Book

  • Agile Database Techniques—Effective Strategies for the Agile Software Developer
  • Foreword by Jon Kern
  • Foreword by Douglas K. Barry
  • Introduction
  • The Agile Data Method
  • From Use Cases to Databases — Real-World UML
  • Data Modeling 101
  • Data Normalization
  • Class Normalization
  • Relational Database Technology, Like It or Not
  • The Object-Relational Impedance Mismatch
  • Legacy Databases — Everything You Need to Know But Are Afraid to Deal With
  • Vive L’ Évolution
  • Agile Model-Driven Development (AMDD)
  • Test-Driven Development (TDD)
  • Database Refactoring
  • Database Encapsulation Strategies
  • Mapping Objects to Relational Databases
  • Performance Tuning
  • Tools for Evolutionary Database Development
  • Implementing Concurrency Control
  • Finding Objects in Relational Databases
  • Implementing Referential Integrity and Shared Business Logic
  • Implementing Security Access Control
  • Implementing Reports
  • Realistic XML
  • How You Can Become Agile
  • Bringing Agility into Your Organization
  • References and Suggested Reading
SHOW MORE
FREE ACCESS