Real-World Database Layouts
Now that we’ve covered the fundamentals of databases, let’s pull all of the concepts together and apply them to define the structure of the databases for three applications—simple, moderately complex, and complex—given a fixed number of disk drives, a set of application characteristics, and a set of requirements.
Simple Application Workload
Scenario: In this scenario a user has a very simple application that utilizes a backend SQL Server 2005 database as a data repository for a small application. The maximum database size is estimated to be 8 GB with the data access somewhat evenly distributed across all the tables, with an average 95 percent read and 5 percent write data access ratio. The user would like to protect the ...