通过Microsoft SQL Server 7.0 存取异构的数据（外文文献翻译）.doc

Accessing Heterogeneous Data with Microsoft SQL Server 7.0 Microsoft Corporation December 1998 Summary: This article addresses the strategies and techniques for transparently accessing data in a heterogeneous environment with Microsoft SQL Server 7.0. (27 printed pages Introduction Enterprise business applications increasingly are being designed to run in a distributed computing environment. In addition to distributing applications across a network of workstations, servers, and legacy mainframe systems, organizations are distributing applications across geographic boundaries, time zones, and divisions. As organizations evolve and grow, they often acquire a heterogeneous collection of computers, networks, and databases. As a result, these organizations need access to information and data from diverse enterprise business applications. For example, an organization may need to access the data residing on a UNIX workstation or an Oracle database in a way that is transparent to the end users. Transparent access is key to developing powerful distributed solutions that allow an organization to be responsive to the marketplace. Microsoft’s solution is the Universal Data Access (UDA) architecture: Figure 1. UDA architecture This document will address the strategies and techniques for transparently accessing data in a heterogeneous environment. Microsoft? SQL Server? version 7.0 is based on the UDA architecture, which is implemented by means of OLE DB. OLE DB is an interface specification that provides for distributed data access without regard to the source or format of the data. Oracle, in contrast, takes a universal server approach, in which all data must exist in a single repository and must be accessed using a single access language. The primary goal of SQL Server 7.0 is to take advantage of the capabilities offered through the UDA architecture, which allows data to exist in multiple formats and be accessed using many different methods. With the release of SQL Server 7.0,