Pro SQL Server 2008 Relational Database Design and Implementation

CHAPTER 11Considering Data Access Strategies

Arguments are to be avoided; they are always vulgar and often convincing.

—Oscar Wilde

At this point in the process of covering the topic of database design, we have designed and implemented the database, devised effective security and indexing strategies, and taken care of all of the other bits and pieces that go along with these tasks. The next logical step is to decide on the data-access strategy and how best to implement and distribute data-centric business logic (of course, in reality, design is not really a linear process, as performance tuning and indexing require a test plan, and this usually requires that some form of UI has been created to get an idea of how the data is going to be accessed). ...