Free Trial

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


Share this Page URL
Help

Chapter 8: Logical and Extended Logical ... > Extended Logical Data Model Template - Pg. 293

Physical Implementation Extended Logical Data Model Template "There are not enough Indians in the world to defeat the Seventh Cavalry" George Armstrong Custer Having a Logical Data Model Template will allow your decision making to be as sharp as an arrow. You will be able to back up your decisions with the facts so you can toot your own big horn. Below is an example of an Extended Logical Data Model. The Value Access and Data Demographics have been collected. We can now use this to pick our Primary Indexes and Secondary Indexes. During the first pass at the table you should pick your potential Primary Indexes. Label them UPI or NUPI based on whether or not the column is unique. At this point in time, don`t look at the change rating. A great Primary Index will have: A Value Access frequency that is high