CN1238792C - Data bank accessing method and client machine/server system for realizing same - Google Patents
Data bank accessing method and client machine/server system for realizing same Download PDFInfo
- Publication number
- CN1238792C CN1238792C CN 02155178 CN02155178A CN1238792C CN 1238792 C CN1238792 C CN 1238792C CN 02155178 CN02155178 CN 02155178 CN 02155178 A CN02155178 A CN 02155178A CN 1238792 C CN1238792 C CN 1238792C
- Authority
- CN
- China
- Prior art keywords
- data
- request
- database
- access
- client
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired - Fee Related
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Computer And Data Communications (AREA)
Abstract
The present invention provides a database access method in a client / server system. A data requester obtains data in a database by sending a data access request, and the system processes the data access request by the following steps that (1) the data stored in a memory is searched according to the data access request, wherein the data with high access request frequency is stored in the memory; (2) if the data with the access request is stored in the memory, the data is read and is returned to the data requester; otherwise, the database is accessed according to the content of the data access request, and results of access operation is returned to the data requester; besides, the system executes the following steps in a definite time method with the concurrence mode of the step (1) and the step (2): (3) the data stored in the memory is updated by the corresponding data in the database. The method reduces the access pressure of the database, and the access of the data requester to the memory is always in a high hit rate.
Description
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 the transmission data access request and is obtained the interior data of database, and described access method comprises with following step process data access request:
(1) data of storing in the memory buffer of content search between described database and described request of data side 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 access method is to carry out the following step with the parallel mode in step (1) and (2):
(3) with a period of time in the database at interval in the high data of request of data side's visiting frequency with the Data Update of described memory buffer stored.
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) is dynamic change.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 between described request of data side and described database, is used for the high data of request of access frequency in the stored data base;
The request of data administration module, link to each other with described request of data side, described memory buffer and described database, be used for the data of storing according to the content search memory buffer of data access request, if described buffer memory stores has the data of accessed request, then read these data and return to request of data side, otherwise, this data access request is delivered to database, return to request of data side according to the access to content database of this data access request and with the accessing operation result;
The Data Update administration module, link to each other with described memory buffer and described database, be used for with the parallel mode of request of data administration module with a period of time in the database at interval in the high data of request of data side's visiting frequency with the Data Update of described memory buffer stored.
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 is dynamic change.
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 (8)
1. data bank access method, request of data square tube are crossed and are sent data access request and obtain data in the database, it is characterized in that described access method comprises the following steps the deal with data request of access:
(1) data of storing in the memory buffer of content search between described database and described request of data side 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 access method is to carry out the following step with the parallel mode in step (1) and (2):
(3) with a period of time in the database at interval in the high data of request of data side's visiting frequency with the Data Update of described memory buffer stored.
2. data bank access method as claimed in claim 1 is characterized in that, described system is execution in step (3) regularly.
3. data bank access method as claimed in claim 2 is characterized in that, regularly the time interval of execution in step (3) is dynamic change.
4. client/server system, described system comprises the request of data side that obtains data and the database of storage data, described request of data square tube is crossed and is sent data access request and obtain data in the database, it is characterized in that described system comprises:
Memory buffer between described request of data side and described database, is used for the high data of request of access frequency in the stored data base;
The request of data administration module, link to each other with described request of data side, described memory buffer and described database, be used for the data of storing according to the content search memory buffer of data access request, if described buffer memory stores has the data of accessed request, then read these data and return to request of data side, otherwise, this data access request is delivered to database, return to request of data side according to the access to content database of this data access request and with the accessing operation result;
The Data Update administration module, link to each other with described memory buffer and described database, be used for with the parallel mode of request of data administration module with a period of time in the database at interval in the high data of request of data side's visiting frequency with the Data Update of described memory buffer stored.
5. client/server system as claimed in claim 4 is characterized in that, described Data Update administration module regularly upgrades memory buffer.
6. client/server system as claimed in claim 5 is characterized in that, the time interval of regularly upgrading memory buffer is dynamic change.
7. as each described client/server system among the claim 4-6, it is characterized in that, described client/server system is two layer architectures that comprise customer interface layer and data service layer, described request of data side is the client computer that belongs to the customer interface layer, described database belongs to data service layer, and described memory buffer, request of data administration module and Data Update administration module are between described client computer and described database.
8. as each described client/server system among the claim 4-6, it is characterized in that, described client/server system is the multi-tier systematic structure that comprises customer interface layer, Business Logic and data service layer, described request of data side is the business logic processing module that belongs to Business Logic, described database belongs to data service layer, and described memory buffer, request of data administration module and Data Update administration module are between described business logic processing module and described database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 02155178 CN1238792C (en) | 2002-12-18 | 2002-12-18 | Data bank accessing method and client machine/server system for realizing same |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 02155178 CN1238792C (en) | 2002-12-18 | 2002-12-18 | Data bank accessing method and client machine/server system for realizing same |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1508703A CN1508703A (en) | 2004-06-30 |
| CN1238792C true CN1238792C (en) | 2006-01-25 |
Family
ID=34235771
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 02155178 Expired - Fee Related CN1238792C (en) | 2002-12-18 | 2002-12-18 | Data bank accessing method and client machine/server system for realizing same |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1238792C (en) |
Families Citing this family (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7603131B2 (en) * | 2005-08-12 | 2009-10-13 | Sellerbid, Inc. | System and method for providing locally applicable internet content with secure action requests and item condition alerts |
| CN100371900C (en) * | 2006-01-19 | 2008-02-27 | 华为技术有限公司 | Method and system for synchronizing data |
| CN101046807B (en) * | 2006-03-31 | 2010-04-14 | 华为技术有限公司 | Method and device of storing data readed imformation |
| CN101452422B (en) * | 2007-11-29 | 2011-03-30 | 联芯科技有限公司 | Chip data read-write method, corresponding apparatus and system |
| CN101685528A (en) * | 2008-09-28 | 2010-03-31 | 北京易路联动技术有限公司 | Internet individual data banking technology management method, system and network side devices |
| CN103377264B (en) * | 2012-04-28 | 2016-12-14 | 阿里巴巴集团控股有限公司 | A kind of method and device generating bill |
| CN104166820B (en) * | 2013-05-16 | 2017-09-29 | 北京畅游天下网络技术有限公司 | A kind of data managing method and system |
| CN103607312B (en) * | 2013-11-29 | 2017-02-15 | 广州华多网络科技有限公司 | Data request processing method and system for server system |
| CN107133326A (en) * | 2017-05-05 | 2017-09-05 | 广州千淘信息技术有限公司 | A kind of asynchronous data storehouse and its data processing method |
| CN107317855B (en) * | 2017-06-21 | 2020-09-08 | 上海志窗信息科技有限公司 | Data caching method, data requesting method and server |
| CN108153825A (en) * | 2017-12-07 | 2018-06-12 | 石化盈科信息技术有限责任公司 | Data access method and device |
| CN111464582A (en) * | 2019-01-22 | 2020-07-28 | 广州艾美网络科技有限公司 | High-concurrency data system, data processing method, storage medium and computer equipment |
| CN114064582A (en) * | 2021-10-13 | 2022-02-18 | 宁波三星智能电气有限公司 | Data interaction method and intelligent terminal using same |
-
2002
- 2002-12-18 CN CN 02155178 patent/CN1238792C/en not_active Expired - Fee Related
Also Published As
| Publication number | Publication date |
|---|---|
| CN1508703A (en) | 2004-06-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN1238792C (en) | Data bank accessing method and client machine/server system for realizing same | |
| CN100451976C (en) | Migration management based on massive data classified memory system | |
| CN101354726B (en) | Method for managing memory metadata of cluster file system | |
| US9086914B2 (en) | System and method for reducing startup cost of a software application | |
| AU2002312508B2 (en) | Storage system having partitioned migratable metadata | |
| CN101252589B (en) | Data buffer apparatus and network storage system using the same and buffer method | |
| US8725793B2 (en) | Architectural pattern for persistent web application design | |
| US8046425B1 (en) | Distributed adaptive network memory engine | |
| US7644108B1 (en) | Network acceleration device cache supporting multiple historical versions of content | |
| US9244980B1 (en) | Strategies for pushing out database blocks from cache | |
| CN109240946A (en) | The multi-level buffer method and terminal device of data | |
| CN1949220A (en) | Structuring system and method of network community dynamic list | |
| Canim et al. | Buffered Bloom Filters on Solid State Storage. | |
| EP2502167A1 (en) | Super-records | |
| CN101404649A (en) | Data processing system based on CACHE and its method | |
| CN1818887A (en) | Built-in file system realization based on SRAM | |
| US7529891B2 (en) | Balanced prefetching exploiting structured data | |
| CN116821054A (en) | Distributed key value storage system based on computation unloading mechanism | |
| Choi et al. | A write-friendly approach to manage namespace of Hadoop distributed file system by utilizing nonvolatile memory | |
| CN114895850A (en) | Method for optimizing writing of data lake | |
| CN112445794A (en) | Caching method of big data system | |
| CN1622056A (en) | Method for accessing files | |
| Sun et al. | A storage computing architecture with multiple NDP devices for accelerating compaction performance in LSM-tree based KV stores | |
| CN117973558A (en) | SERVERLESS machine learning model training-oriented dynamic scalable data sharing system | |
| CN115080609A (en) | Method and system for realizing high-performance and high-reliability business process engine |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| ASS | Succession or assignment of patent right |
Owner name: BEIJING EQUITY EXCHANGE CO., LTD. Free format text: FORMER OWNER: HUAWEI TECHNOLOGY CO LTD Effective date: 20120323 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| COR | Change of bibliographic data |
Free format text: CORRECT: ADDRESS; FROM: 518057 SHENZHEN, GUANGDONG PROVINCE TO: 100033 XICHENG, BEIJING |
|
| TR01 | Transfer of patent right |
Effective date of registration: 20120323 Address after: 100033, No. 17, Finance Street, Beijing, Xicheng District Patentee after: Beijing property right Bats Exchange Inc Address before: 518057 HUAWEI road user service center building, Shenzhen science and Technology Park, Guangdong Patentee before: Huawei Technologies Co., Ltd. |
|
| C17 | Cessation of patent right | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20060125 Termination date: 20121218 |