O'Reilly logo

Building the Agile Database: How to Build a Successful Application Using Agile Without Sacrificing Data Management by Larry Burns

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Refactoring the physical database design is also usually an easy thing to do, especially if you have a modeling tool that lets you maintain both the logical and physical models in a single model file. In most good modeling tools, changes to one model will automatically be reflected in the other, unless the change is marked as “logical only” or “physical only”. In this case, the DBA only needs to verify that the physical model is correct, making any necessary changes to datatypes and lengths from the domain defaults in the logical model. For example, an attribute denoted as a “Code” in the logical model may default to, say, varchar(4) in the physical model; this may need to be changed by the DBA to something like, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required