外文翻譯-sqlserver體系結(jié)構(gòu)(編輯修改稿)
2024-09-10 11:17 本頁面
【文章內(nèi)容簡介】 including tables, data integrity mechanisms, data entry and retrieval object(often stored procedure), appropriate indexes, and security.Testing and tuning the application and database. When you design a database, you want to ensure that the database performs important functions correctly and quickly. In conjunction with correct database design, correct use of indexes, RAID, and filegroups are essential to achieving good performance.Planning deployment, which includes analyzing the workload and remending an optimal index configuration for your SQL Server database.Administering the application after deployment, which includes configuring servers and clients, monitoring server performance, managing jobs, alerts, and operators, managing security, and managing database backup procedures. Procedures to Stored ProceduresThis section introduces the different types of stored procedures, describes how stored procedures are processed, both initially and on subsequent execution, and lists some of the advantages of using stored procedures. Stored ProceduresA stored procedure is a named collection of TransactSQL statements that is stored on the server. Stored procedures are a method of encapsulating repetitive tasks that executes efficiently. Stored procedures support userdeclared variables, conditional execution, and other powerful programming features. Microsoft SQL Server version supports five types of stored procedures:System Stored Procedures (sp_) Stored in the master database, system stores procedures (identified by type sp_prefix) provide an effective method to retrieve information from system tables. They allow system administration tasks that update system tables even though the administrators do not have permission to update the underlying tables directly. System stored procedures can be executed in any database.Local Stored Procedures Local stored procedures are created in individual user databases.Temporary Stored Procedures Temporary stored procedures can be local, with names that start with a double pound symbol () ——local temporary stored procedures are available within a single user session。 global temporary stored procedures are available for all user sessions.Remote Stored Procedures Remote stored procedures are a legacy feature of SQL Server environment. Extended stored procedures are typically identified by the xp_prefix. They are executed in a manner similar to that of stored procedures.6. ODBC 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—th
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1