外文翻譯-sqlserver體系結(jié)構(gòu)(已修改)
2024-08-31 11:17 本頁面
【正文】 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 easier to use than database APIs but may not expose as much functionality as an API.ActiveX Data Objects Microsoft ActiveX Data Object(ADO) encapsulate the OLE DB API in a simplified object model that reduces application development and maintenance costs. ADO can be used from Microsoft Visual Basic, Visual basic for applications, Active Server Pages(ASP), and the Microsoft Internet Explorer scripting object model.Remote Data Object Remote Data Object(ROD) map over and encapsulate the ODBC API. RDO can be used from Visual Basic and Visual Basic for applications. WITH SQL SERVER Designing An Application For SQL ServerPlanning a database design requires knowledge of the business functions that you want to model and database concepts and feature
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1