O'Reilly logo

Data Resource Design by Michael Brackett

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

Chapter 9

DATA DENORMALIZATION

Data denormalization adjusts the data structure for implementation.

The description of proper data structures continues with the formal denormalization of data. Data denormalization covers both data deoptimization and data denormalization. Data deoptimization defines the deployment of data to multiple data sites and data denormalization defines the adjustment of data for optimum performance at those data sites based on specific criteria. Proper data denormalization helps achieve data resource reality.

Chapter 9 describes the process for formally deoptimizing the logical schema to the deployment schema, and denormalizing the deployment schema to the physical schema. Plain English is used to avoid all the mathematical ...

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