外文翻譯-sqlserver體系結(jié)構(gòu)(存儲(chǔ)版)
【正文】 動(dòng)程序在運(yùn)行時(shí)被裝載，一個(gè)用戶可以僅增加一個(gè)新的驅(qū)動(dòng)程序訪問新的DBMS，不必要再編輯或者再連接應(yīng)用程序。 ODBC接口許可最大限度連機(jī)操作—任一應(yīng)用程序都能在不同的的DBMS（數(shù)據(jù)庫管理系統(tǒng)）中通過一個(gè)單一的接口訪問數(shù)據(jù)。本節(jié)介紹不同類型的存儲(chǔ)過程，描述存儲(chǔ)過程的處理，包括初始處理和后續(xù)執(zhí)行，并列出使用存儲(chǔ)過程的一些優(yōu)點(diǎn)。設(shè)計(jì)數(shù)據(jù)庫時(shí)，要保證數(shù)據(jù)庫正確迅速的執(zhí)行重要的功能。不管數(shù)據(jù)庫的規(guī)模和復(fù)雜性符合，實(shí)現(xiàn)一個(gè)數(shù)據(jù)庫通常都包括以下任務(wù)：但是，復(fù)雜的可能性增加，且這個(gè)方法對(duì)小型應(yīng)用程序較慢。這個(gè)設(shè)計(jì)在客戶機(jī)沒有足夠的資源處理業(yè)務(wù)邏輯時(shí)是很有用的。 SQL Server Server應(yīng)用程序計(jì)劃一個(gè)數(shù)據(jù)庫設(shè)計(jì)要求想建模的業(yè)務(wù)對(duì)象的知識(shí)，和用于表示這些業(yè)務(wù)功能的數(shù)據(jù)庫概念及特性。OLE DB 這是一個(gè)基于組件對(duì)象模型（COM）的數(shù)據(jù)訪問接口，它支持使用OLE DB的數(shù)據(jù)對(duì)象接口寫的應(yīng)用程序。TDS包封裝在為網(wǎng)絡(luò)庫使用的協(xié)議棧創(chuàng)建的網(wǎng)絡(luò)數(shù)據(jù)包中，例如，如果使用Windows sockets NetLibrary，則TDS數(shù)據(jù)包封裝在底層協(xié)議的TCP/IP數(shù)據(jù)包中。the ASP code easier to maintain. You can keep all of the SQL code together, on the server. You can use output parameters in a stored procedure, which allows you to returns going to do. This makes thet. In fact, if your mand doesn39。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 how to write an application to connect to a database and pass mands to the database. SQL Server provides native support for two main classes of database APIs, which in turn determine the data object interface that you can use. Use the database APIs to have more control over application behavior and performance.OLE DB This is a Component Object Model(COM)based data access interface. It supports application written using OLE DB or data object interface that use OLE DB. OLE DB can access data in SQL Server, other relational databases, and other data sources.Open Database Connectivity Open Database Connectivity(ODBC) is a calllevel interface. It directly access the SQL Server TDS protocol and supports applications or ponents that are written using ODBC or data object interface that use ODBC. ODBC can access data in SQL Server and other relational database, but generally it cannot be used to access other data sources. Data Object InterfacesIn general, data object interfaces are
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1