外文翻譯-sqlserver體系結(jié)構-文庫吧資料
2024-08-27 11:17本頁面
【正文】 PurposeThe Microsoft Open Database Connectivity (ODBC) interface is a C programming language interface that makes it possible for applications to access data from a variety of database management systems (DBMSs). The ODBC interface permits maximum interoperability—an application can access data in diverse DBMSs through a single interface. Furthermore, that application will be independent of any DBMS from which it accesses data. Users of the application can add software ponents called drivers, which interface between an application and a specific DBMS.Open Database Connectivity (ODBC) is a widely accepted application programming interface (API) for database access. It is based on the CallLevel Interface (CLI) specifications from X/Open and ISO/IEC for database APIs and uses Structured Query Language (SQL) as its database access language.ODBC is designed for maximum interoperability—that is, the ability of a single application to access different database management systems (DBMSs) with the same source code. Database applications call functions in the ODBC interface, which are implemented in databasespecific modules called drivers. The use of drivers isolates applications from databasespecific calls in the same way that printer drivers isolate word processing programs from printerspecific mands. Because drivers are loaded at run time, a user only has to add a new driver to access a new DBMS。Planning deployment, which includes analyzing the workload and remending an optimal index configuration for your SQL Server database.Creating the database and database objects, including tables, data integrity mechanisms, data entry and retrieval object(often stored procedure), appropriate indexes, and security.SQL SERVER ARCHITECTURE1. COMMUNICATIONSQL Server uses a layered munication architecture to isolate application from the underlying network and protocols. This architecture allows you to deploy the same application in different network environment. The ponents in the munication architecture include:Application、Database interface、 Network library .Clients and servers can use more than one NerLibrary concurrently, but they must use a mon network library in order to municate successfully. SQL Server support network protocol such as TCP/IP, Named pipes, Novell IPX/SPC, Banyan VINES/IP, and AppleTalk ADSP.Tabular data stream tabular data stream(TDS) is a application level protocol used for munication between the client and SQL Server. TDS packets are encapsulated in the network packets built for the protocol stack used by the Netlibraries. For example, if you use the windows Socket NetLibrary, then the TDS packets are encapsulated in the TCP/IP packets of underlying protocol.Open Data Services This is a ponent of SQL Server that handles network connections, passing client requests to SQL Server for processing and returning any result and replies to SQL Server client. Open Data Services automatically listens on all server NetLibraries that are installed on the server.2. APPLICATION DEVELOPMENTUsers access SQL Server through an application that is written with a data object interface or an API.SQL Server supports monly used and emerging database interfaces. It supports lowlevel native APIs, as well as easytouse data object interfaces. Application Programming InterfacesA database API defines h
環(huán)評公示相關推薦
鄂ICP備17016276號-1