System and method for accessing database and registration, booking and online shopping system

Abstract

The invention relates to a system and method for accessing a database and a registration, ticket booking and online shopping system. The system includes: a network server, a read and write database server and a client; wherein, the client and the network server are connected through a network, and the network server is respectively connected with the read and write database servers; the client sends a read and write database request to the network server; Obtain the returned data from the web server; the web server obtains the data required by the read database server or merges the read database request from the read database server and provides it to the client; according to the write database request or merged write database request, modify the corresponding data in the write database server, And provide the modification result to the client; the write database server periodically provides the database stored by itself to the read database server, so that the databases stored by the two are kept in sync. The invention can reduce the number of visits of a single server and prevent the server from being paralyzed by a huge number of visits.

Description

technical field [0001] The invention relates to the technical field of network access to databases, in particular to a system and method for accessing a database and a system for registration, booking and online shopping. Background technique [0002] With the development of Internet technology, new things such as online registration, online booking, online shopping, etc. that perform certain operations through the Internet emerge in an endless stream, and their common technical basis is the network access technology of the database. In this technology, the database is stored in the server, and the external client submits a database read request and a write database request to the server through the network, and completes the read operation and write operation of the database respectively. The characteristic of this technology is that the type of access is relatively single, basically only two kinds of requests to read the database and write requests to the database, but the...

AI Technical Summary

Problems solved by technology

The characteristic of this technology is that the types of access are relatively single, basically only two kinds of requests to read the database and write requests to the database, but the amount of access is large and randomly distributed in time

In this way, when a huge number of read and write database requests are submitted to the server at the same time, it is easy to cause the server to be paralyzed, and what follows is not only the continuous refresh operation of the client to submit more requests to the server, but also further increase the server capacity. workload, prolong the response time of the server, and worse, may cause confusion in the database, causing huge losses to customers and merchants

The existing method to prevent the server from being paralyzed is to improve the configuration of the server, thereby improving its response speed, and completing the continuous reading and writing server requests in the shortest possible time. However, the current server manufacturing level is far from being able to meet the huge The response requirements when a large number of clients submit requests at the same time, and because the above-mentioned huge amount of access is often concentrated in a short period of time (such as Christmas, National Day, New Year's Day and other holidays), in the rest of the time, the server's network access The amount is relatively small, this way of improving server configuration will also cause waste of resources and increase of cost

Images