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

One of the biggest areas of confusion in the logical/physical divide is the subject of normalization. Data managers have a tendency to want to implement the normalized logical model in the physical database to ensure data integrity, while developers have a tendency to want a denormalized schema in order to (ostensibly) simplify their coding and improve performance. There are, however, some very important things that need to be kept in mind here:

·         Normalization and denormalization are done for different reasons in the logical and physical realms. In logical modeling, normalization is done primarily to ensure that all business data requirements have been accurately captured and understood, ...

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