Chapter 2 DATABASE DESIGN FOR SQL SERVER 2000
Chapter 2 DATABASE DESIGN FOR SQL SERVER 2000 97 ESSENCE OF THE CASE: . Current data design is devoid of fast access. . Jones & Sons handles more clients each day and the processing is getting difficult. . They need a re-creation of the data model. CASE STUDY: JONES & SONS source through the use of OLE-DB and ODBC drivers, which are available for most common databases. SQL Server can move data to and from these sources using Data Transformation Services (DTS), replication, and linked server operations. SQL Server can act as a gateway to any number of data sources and either handle a copy of the data itself or pass the processing to the third-party source. The capability of SQL Server to act with almost any third-party source means that existing applications can continue to function in the environment undisturbed while SQL Server applications can also make use of the same data. SCENARIO Starting as a small local bead trading company, Jones & Sons now exports and imports beads nationwide with headquarters in Detroit. Jones knew that the company would expand sometime in the distant future and so didn t worry too much about the inventory storage design he would use. His slothfulness backfired on him. There are many client interactions each day, and the current system, a poor inventory storage design created at an extremely low cost by one of the junior developers in town, just can t handle the volume. Jones and his staff have decided to implement a new design based on the original groundwork already existing. They hire you to implement a new database design that will expedite access and reduce data redundancy. ANALYSIS You request a copy of the original database design to see the flaws placed in it by the previous developer. You spot numerous defects affecting the design, some of which defy the
For reliable and cheap web hosting services please check javaweb hosting website.