外文翻譯-sqlserver體系結(jié)構(gòu)-在線瀏覽
2024-09-24 11:17本頁面
【正文】 soft Access are an example for this design.NTier Processing is divided among a database server, an application server, and clients,. This approach separates logic from data services, and you easily can add more application servers or database servers as needed. However, the potential for plexity increases, and this approach may be slower for small applications.Multitiered enterprise application and applications developed with transaction processing monitors are examples for this design.Internet Processing is divided into three layers, with the business and presentation services residing on the Web server and the clients using simple browsers. Any client that has a browser can be supported, and software does not need to be maintained on the client.An example of this design is a Web site thar uses several Web servers to manage connections to clients and a single SQL Server database that services requests for data. A SQL SERVER DATABASEImplementing a SQL Server database means planning, creating, and maintaining a number of interrelated ponents.The nature and plexity of a database application, as well as the process of planning it, can very greatly. For example, a database can be relatively simple, designed for use by a single person, or it can be large and plex, designed to handle all the banking transactions for hundreds of thousands of client.Regardless of the size and plexity of the database, implementing a database usually involves:Designing the database so that your application use hardware optimally and allows for future grows, identifying and modeling database objects and application logic, and specifying the types of information for each object and type of relationship.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.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 create
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1