Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. PREFERRED DATA ARCHITECTURE ... > PREFERRED PHYSICAL DATA ARCHITECTURE

PREFERRED PHYSICAL DATA ARCHITECTURE

The preferred physical data architecture can be developed when the preferred logical data architecture designation has been completed. The preferred physical data architecture is developed according to a formal set of data denormalization criteria. These data denormalization criteria were discussed in Chapter 3 and described in detail in Data Resource Simplexity.

The primary objective of formal data denormalization is to develop a physical data architecture that is optimum for a particular operating environment, without compromising the logical data architecture. Note that the entire data architecture is adjusted, not just the structure. The major problems with traditional data denormalization are that only structure is adjusted, and the logical data model is often compromised. The result is a data resource that does not have high quality and does not meet business needs.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint