Introduction


This chapter attempts to tie together all the loose ends that may be remaining in your exam preparation. Although we have covered a lot in the course of this book, there are still a few nooks and crannies left to go into.

In finalizing a system design for a business project, there are many considerations outside of the traditional database design structure. These other areas include the interaction with other Microsoft back-office systems, integration with third-party elements (within the data-handling arena and other forms of technology), and building a framework that can expand into the extra-large enterprise systems.

Microsoft SQL Server 2000 handles well in a distributed environment. All offices can gain access to the data they need in virtually any size organization. There are many tools for interoperating in a heterogeneous environment. These tools help to integrate multiple vendors and database products. SQL Server uses ODBC and OLE-DB functionality to gain access to virtually any data stored anywhere.

SQL Server makes an excellent back-end database server for an Internet or intranet site. SQL Server and IIS integrate well to make data accessible over the Internet in a number of formats, including XML, HTML, ADO, and ADO.Net. SQL Server even has an HTML creation wizard, although it is limited to creating static HTML pages based on schedules or data changes.

With SQL Server replication, data can be transferred quickly and flexibly from one server to another. Options are available to maintain updatable copies at all locations if desired. It is a good fit for an organization looking for a centralized point in which to store data relating to all parts of the organization with distribution capabilities that can make that data quickly available throughout the globe.

In business application development you must select an appropriate model for your entire setup. These separate models are referred to as tier systems. At times the choice of the number of tiers is accomplished based on all requirements of the business application being implemented.



    EXAM CRAM 2 Designing and Implementing Databases with SQL Server 2000 Enterprise
    MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition
    ISBN: 0789731061
    EAN: 2147483647
    Year: 2005
    Pages: 154

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net