CHAPTER 11CREATING AN ABSTRACTION LAYER IN SQL SERVER
Our journey has brought us a long way, and now we’re near the end. At this point you should have a fully working physical database complete with all the appropriate indexes. This is the time when many database modelers stop their work and toss the database over the wall for the DBAs to implement and manage. If you choose that course, you may be just fine, but you might also be setting yourself up for failure. In its current state, access to the database will be pieced together by the application developers, and trust us when we tell you that most application developers do not understand how to access a database in the best way.
No, to be complete you have one more step, one last thing to build ...
Get A Developer’s Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
