CN1508703A - A database access method and client/server system for realizing the method - Google Patents

Abstract

Translated fromChinese

本发明提供一种客户机/服务器系统内的数据库访问方法，数据请求方通过发送数据访问请求来获取数据库内的数据，系统以下列步骤处理数据访问请求：(1)根据数据访问请求的内容查找存储器中存储的数据，其中存储器存储有访问请求频度高的数据；以及(2)如果存储器存储有被访问请求的数据，则读取该数据并返回给数据请求方，否则，根据该数据访问请求的内容访问数据库并将访问操作结果返回给数据请求方，并且，所述系统以与步骤(1)和(2)并行的方式定时执行下列步骤：(3)将存储器内存储的数据以数据库内相应的数据更新。上述方法减轻了数据库的访问压力并使得数据请求方对存储器的访问始终保持较高的命中率。

The invention provides a database access method in a client/server system. The data requester obtains data in the database by sending a data access request, and the system processes the data access request in the following steps: (1) Search according to the content of the data access request The data stored in the memory, wherein the memory stores data with a high frequency of access requests; and (2) if the memory stores data that is requested to be accessed, read the data and return it to the data requester, otherwise, access according to the data The requested content accesses the database and returns the access operation result to the data requester, and the system regularly executes the following steps in parallel with steps (1) and (2): (3) transfers the data stored in the memory to the database corresponding data updates. The above method reduces the access pressure of the database and enables the data requester to always maintain a high hit rate in accessing the memory.

Description

A kind of data bank access method and realize the client/server system of this method

Technical field

The present invention relates to client/server system and data bank access method, be specifically related in client/server (Client/Server is designated hereinafter simply as C/S) system, improve Database Systems visit stable and the method for response speed and the client/server system of this method of realization.

Background technology

Early stage client/server system adopts two layer architectures, it mainly is made up of client-side and database server side, wherein, client-side visits database by sending data access request, and database server side response data request of access, database is operated, and operating result is returned client-side.The shortcoming of this system architecture is that retractility is good inadequately, and along with the continuous increase of application program service logic and complicacy, the difficulty of its development is also more and more higher.In addition, the application program of moving on the client has also taken a large amount of system resource and Internet resources.

For this reason, the client/server system of three layers of (multilayer) architecture occurred, it can satisfy scalability (or extensibility) and Internet/Intranet uses.Fig. 1 is the synoptic diagram of three layers of (multilayer) architecture, in this three layers of (multilayer) structure, service logic from client-side and database server side extract composition independently one or more layers, so just formed the customer interface layer of client, middle Business Logic (can be refined as multilayer) and the data service layer of rear end.When running application on the client computer, middle Business Logic collaborative work with it, finish correspondent service logic, if desired, middle Business Logic will be to the database request data, this request of data 1 is transmitted to data service layer, returns Business Logic by this layer according to request of data 1 accessing database and with data query 2.

It is worthy of note that the level in the described client/server system of this instructions is divided the division that is not interpreted as physically with not answering narrow sense, and should be broadly interpreted as the division on the logic function.

But under above-mentioned two layers or three layers of (multilayer) architecture, because request of data is each time all wanted accessing database, be that data service layer all will be operated accordingly to database, therefore make the performance (for example processing speed or response time etc.) of system and the request of data quantity and the frequency of concurrent visit be inversely proportional to, and along with the data access demand the time little and often be in fluctuation status when big, thereby cause system stability relatively poor, under the extreme case of some overload, even can cause database processing speed to descend and then collapse, the client-side response is slow, do not respond or connect overtimely etc., this is intolerable to the client.In addition, when bearing googol according to visit pressure, system do not have simple and effective means to come the regulating system performance yet.

Summary of the invention

The purpose of this invention is to provide the data bank access method in a kind of client/server system, it can alleviate the pressure of database access effectively under multi-client, high-frequency data inquiry environment, guarantees the stable and response efficiency of total system.

In data bank access method of the present invention, the request of data square tube is crossed and is sent data access request and obtain data in the database, and described system is with following step process data access request:

(1) data of storing in the content search memory buffer according to data access request, wherein said buffer memory stores have the high data of request of access frequency in the database; And

(2) if described buffer memory stores has the data of accessed request, then read these data and return to request of data side, otherwise, return to request of data side according to the access to content database of this data access request and with the accessing operation result,

And described system is to carry out the following step with the parallel mode in step (1) and (2):

(3) with the data of described memory buffer stored with corresponding Data Update in the database.

In above-mentioned data bank access method, reasonablely be, system is execution in step (3) regularly, and being more preferably regularly, the time interval of execution in step (3) can dynamically change.

In above-mentioned data bank access method, reasonable is that corresponding data are the at interval interior high data of request of data side's visiting frequency of a period of time.

Another object of the present invention provides a kind of client/server system of realizing above-mentioned data bank access method, it can alleviate the pressure of database access effectively under multi-client, high-frequency data inquiry environment, guarantee the stable and response efficiency of total system.

In client/server system of the present invention, described system comprises request of data side that obtains data and the database of storing data, and described request of data square tube is crossed the transmission data access request and obtained the interior data of database, and described system comprises:

Memory buffer is used for the high data of request of access frequency in the stored data base;

The request of data administration module, be used for the data of storing,, then read these data and return to request of data side if described buffer memory stores has the data of accessed request according to the content search memory buffer of data access request, otherwise, this data access request is delivered to database processing;

The Data Update administration module, be used for with the parallel mode of request of data administration module with the data of described memory buffer stored with corresponding Data Update in the database.

In above-mentioned client/server system, described Data Update administration module regularly upgrades memory buffer, is more preferably, and the time interval of regularly upgrading memory buffer can dynamically change.

In above-mentioned client/server system, reasonable is that corresponding data are the at interval interior high data of request of data side's visiting frequency of a period of time.

In the client/server system of the data bank access method of the invention described above and this method of realization, the data of frequent access are stored in the memory buffer and call for request of data side, therefore alleviated access of database pressure, set up the update mechanism of memory buffer content in addition, make request of data side remain higher hit rate, guaranteed the stable and response efficiency of total system performance the visit of memory buffer.

Description of drawings

Fig. 1 is the synoptic diagram of the client/server system of multi-tier systematic structure.

Fig. 2 is the synoptic diagram according to the client/server system of a preferred embodiment of the present invention.

Embodiment

At a client/server system, generally, the request call frequency of data is not equally distributed in the database, and wherein the visiting frequency of a part of data is higher, and the visiting frequency of some is lower in addition, even the extremely low data of visiting frequency are also arranged.Core concept of the present invention is exactly that this part data that visiting frequency is higher copy in the memory buffer from database, and on the one hand when request of data side's visit data, accesses buffer at first, if this storer is not stored the data that need call, then transfer accessing database, access of database pressure be will alleviate greatly thus, system handles speed and stability improved; On the other hand, because the data in the database are dynamic changes, therefore in order to make request of data side obtain newer data content, also set up the update mechanism of memory buffer, the content in the memory buffer is upgraded in timing or not timing.

Core concept of the present invention and client/server system are that employing two layer architectures or three layers of (multilayer) architecture are irrelevant, in two layer architectures, request of data side is client computer, and in three layers of (multilayer) architecture, request of data side is the logic business processing module in the logic business layer.Memory buffer, data request processing process and Data Update processing procedure are classified an independently level separately as with regard to the logic function that is realized, no matter be in two layer architectures or three layers of (multilayer) architecture, it all between request of data side and database, below is called the data buffering layer with this layer.

In said method, it is two parallel processes of finishing that data request processing in the data buffering layer and Data Update are handled, and renewal process can adopt variety of way, for example in irregular mode, in the time of can significantly reducing in the hit rate of accesses buffer, the visiting frequency interior at interval according to a period of time upgrades memory buffer, request of data side's visiting frequency higher data is transferred to memory buffer replacement data wherein from database, and for example in periodic manner, can upgrade the data of memory buffer with the visiting frequency higher data according to pre-set time interval.

Below by Fig. 2 a preferred embodiment of the present invention is described, in this embodiment, client/server system adopts two layer architectures, therefore the request of data side here is the client computer in the customer interface layer, database is positioned at data service layer.

As shown in Figure 2, this system comprises the database of a plurality of client computer and one storage mass data, according to principle of the present invention, between the client computer of common double-layer structure and database a middle layer that is called the data buffering pond is set.This data buffering pond comprises high capacity memory buffer and two administration modules, wherein, preserves the more frequent data of client requests in the memory buffer, and Data Update administration module and request of data administration module are realized function separately concurrently.The Data Update administration module is regularly to data base querying visiting frequency higher data, and database root be it is investigated data that the request of inquiry returns its storage to refresh the data in the memory buffer, and the time interval of refreshing can preestablish and dynamically change.The request of data of request of data administration module subscribing client, at first accesses buffer if read, then returns to client computer with reading of data with the data of the request of reading, otherwise the request of then will reading is given to database and is handled accordingly.Database reads required data and the result is returned client computer after receiving the request of reading.

In said system, also can not adopt regularly method for updating, but can significantly reduce in the hit rate of accesses buffer the time, the visiting frequency interior at interval according to a period of time upgrades memory buffer, and request of data side's visiting frequency higher data is transferred to memory buffer replacement data wherein from database.In addition, client/server system in the above-mentioned example adopts two layer architectures, but can extend to three layers of (multilayer) architecture fully, in three layers of (multilayer) architecture, request of data side is the logic business processing module in the logic business layer, and the data buffering pond is between logic business processing module and database.

In said method and system, most request of data can be satisfied in the data buffering pond, thereby makes access of database pressure can not produce big fluctuation with the variation of request of data number formulary amount, has guaranteed the stable operation of system.In addition, most request of data all in the data buffering pond speed faster memory buffer obtain data, saved database query operations consuming time, so the response speed of system is very fast.At last, also can regulate access of database pressure by the renewal speed that changes data in the memory buffer, for example, when database access pressure is big, can suitably increase renewal frequency, improve the hit rate of memory buffer, alleviate access of database pressure, otherwise, can reduce renewal frequency, avoid the data of frequent updating memory buffer.

Claims (10)

Translated fromChinese

1.一种数据库访问方法，数据请求方通过发送数据访问请求来获取数据库内的数据，其特征在于，所述系统以下列步骤处理数据访问请求：1. A database access method, the data requester obtains the data in the database by sending a data access request, it is characterized in that the system processes the data access request with the following steps:(1)根据数据访问请求的内容查找缓冲存储器中存储的数据，其中所述缓冲存储器存储有数据库内访问请求频度高的数据；以及(1) Searching for data stored in the buffer memory according to the content of the data access request, wherein the buffer memory stores data with high frequency of access requests in the database; and(2)如果所述缓冲存储器存储有被访问请求的数据，则读取该数据并返回给数据请求方，否则，根据该数据访问请求的内容访问数据库并将访问操作结果返回给数据请求方，(2) If the buffer memory stores the data requested by access, read the data and return it to the data requester, otherwise, access the database according to the content of the data access request and return the access operation result to the data requester,并且，所述系统以与步骤(1)和(2)并行的方式执行下列步骤：And, the system executes the following steps in parallel with steps (1) and (2):(3)将所述缓冲存储器内存储的数据以数据库内相应的数据更新。(3) Updating the data stored in the buffer memory with the corresponding data in the database.2.如权利要求1所述的数据库访问方法，其特征在于，所述系统定时执行步骤(3)。2. The database access method according to claim 1, wherein the system executes step (3) regularly.3.如权利要求2所述的数据库访问方法，其特征在于，定时执行步骤(3)的时间间隔可以动态变化。3. The database access method according to claim 2, characterized in that the time interval for regularly executing step (3) can be changed dynamically.4.如权利要求1-3中任意一项所述的数据库访问方法，其特征在于，所述相应的数据为一段时间间隔内数据请求方访问频度高的数据。4. The database access method according to any one of claims 1-3, wherein the corresponding data is data with high access frequency by the data requester within a period of time.5.一种客户机/服务器系统，所述系统包括获取数据的数据请求方和存储数据的数据库，所述数据请求方通过发送数据访问请求来获取数据库内的数据，其特征在于，所述系统包含：5. A client/server system, the system includes a data requester for obtaining data and a database for storing data, the data requester obtains data in the database by sending a data access request, it is characterized in that the system Include:缓冲存储器，用于存储数据库内访问请求频度高的数据；Buffer memory for storing data with high frequency of access requests in the database;数据请求管理模块，用于根据数据访问请求的内容查找缓冲存储器中存储的数据，如果所述缓冲存储器存储有被访问请求的数据，则读取该数据并返回给数据请求方，否则，将该数据访问请求送至数据库处理；The data request management module is used to search the data stored in the buffer memory according to the content of the data access request, if the buffer memory stores the data requested for access, read the data and return it to the data requester, otherwise, the Data access requests are sent to the database for processing;数据更新管理模块，用于以与数据请求管理模块并行的方式将所述缓冲存储器内存储的数据以数据库内相应的数据更新。The data update management module is used to update the data stored in the buffer memory with corresponding data in the database in parallel with the data request management module.6.如权利要求5所述的客户机/服务器系统，其特征在于，所述数据更新管理模块定时更新缓冲存储器。6. The client/server system according to claim 5, wherein the data update management module regularly updates the buffer memory.7.如权利要求6所述的客户机/服务器系统，其特征在于，定时更新缓冲存储器的时间间隔可以动态改变。7. The client/server system according to claim 6, wherein the time interval for regularly updating the buffer memory can be changed dynamically.8.如权利要求5-7中任意一项所述的客户机/服务器系统，其特征在于，所述相应的数据为一段时间间隔内数据请求方访问频度高的数据。8. The client/server system according to any one of claims 5-7, wherein the corresponding data is data with high access frequency by the data requester within a period of time.9.如权利要求8所述的客户机/服务器系统，其特征在于，所述客户机/服务器系统为包含客户界面层和数据服务层的两层体系结构，所述数据请求方为属于客户界面层的客户机，所述数据库属于数据服务层。9. client computer/server system as claimed in claim 8, is characterized in that, described client computer/server system is the two-layer architecture that comprises client interface layer and data service layer, and described data request party is to belong to client interface layer client, the database belongs to the data service layer.10.如权利要求8所述的客户机/服务器系统，其特征在于，所述客户机/服务器系统为包含客户界面层、业务逻辑层和数据服务层的多层体系结构，所述数据请求方为属于业务逻辑层的业务逻辑处理模块，所述数据库属于数据服务层。10. client computer/server system as claimed in claim 8 is characterized in that, described client computer/server system is to comprise the multilayer architecture of client interface layer, business logic layer and data service layer, and described data requester It is a business logic processing module belonging to the business logic layer, and the database belongs to the data service layer.

Images