Call of database stored procedures during Website construction of the People's Bank of China

I. INTRODUCTION
With the gradual development of the central branch computer network of the People's Bank of China and the implementation of the second phase of the Intranet project, most central branches have established internal networks (intranets ), provides network services such as file transmission, email, and simple WEB.
For the central branch of the People's Bank of China, website construction requires various digital information such as reports, accounts, reports, analysis, and other text information, and various office automation information such as official document processing and conference notifications, audio, image, video conferencing, and other multimedia information. How to make full use of existing information resources and computer network technology to build information websites within the People's Bank of China and provide timely, accurate and diverse information services for financial supervision and policies, to a large extent, it is inseparable from the support of databases. At the same time, the construction of the website of the People's Bank of China is a system project and landmark project. It represents the image of a bank and reflects the spirit of technology. There are a large number of departments involved in website construction and maintenance, and there are many coordination relationships and high technical complexity, this requires the use of database technology to build a dynamic, interactive, and efficient website to meet the requirements of the information age.
Database Stored Procedure (Stored-Procedure) is a mature technology for large databases such as SYBASE, ORACLE, INFORMIX, and microsoft sqlserver, it is a encapsulated process composed of some or more SQL statements and control statements. It resides in the database and can be called by the customer application, it can also be called from another process or trigger. By using variables and conditions, its parameters can be passed and returned. In B/S (browser/server) mode, when the website client executes complex tasks and processes large and complex SQL statements, the stored procedure provides many conveniences and advantages, it can meet the needs of website construction.
II. Advantages of Using Stored procedures
1. Faster running
In the website database server, interactive SQL commands are usually used to establish a pre-compilation process for the database server before each execution. After the first execution, after optimization and compilation, it is stored in the high-speed cache. In the next operation, it can be executed directly from the high-speed cache, saving the optimization and compilation stages for future execution, it saves a lot of time for the execution process, and uses the stored procedure to speed up the execution.
2. Reduced network load
When a client sends a request to execute a stored procedure, only the commands that execute the stored procedure are transmitted over the internal network. When they arrive at the database server, they run the stored procedure, the client only receives the returned results or status information on the internet. Therefore, the communication between the client and the server is minimized, greatly reducing the network load. It shortens the time required by users and avoids users' boring waiting.
 
3. Convenient team development
During website programming, calling stored procedures such as PHP and ASP can reduce the difficulty of constructing complex SQL statements in program development. Due to the reusability and sharing of stored procedures, this allows the stored procedure to be used repeatedly and shared by multiple users. It is used repeatedly during development and brings great convenience to the team development of the website, it also makes the site easier to maintain and update.