CN1508703A - 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
- CN1508703A CN1508703A CNA021551782A CN02155178A CN1508703A CN 1508703 A CN1508703 A CN 1508703A CN A021551782 A CNA021551782 A CN A021551782A CN 02155178 A CN02155178 A CN 02155178A CN 1508703 A CN1508703 A CN 1508703A
- Authority
- CN
- China
- Prior art keywords
- data
- request
- database
- client
- server system
- 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.)
- Granted
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Computer And Data Communications (AREA)
Abstract
The invention provides a kind of databank accessing method in the client computer and server, the data requester sends out data accessing request to obtain the data in databank, the system process the request with following steps: (1) searches the data in the memory according to the data accessing request, the memory stores the high frequency data; (2) if the memory has the data requested, it reads the data and returns it to the data requester, otherwise, access the databank according to the request content and returns the result to the data requester, the system executes following steps with parallel mode to the step (1) and (2): (3) updates the data in memory with the correspondent data in the databank.
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 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)
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 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.
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) can dynamic change.
4. as any described data bank access method among the claim 1-3, it is characterized in that corresponding data are the at interval interior high data of request of data side's visiting frequency of a period of time.
5. 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 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.
6. client/server system as claimed in claim 5 is characterized in that, described Data Update administration module regularly upgrades memory buffer.
7. client/server system as claimed in claim 6 is characterized in that, the time interval of regularly upgrading memory buffer can dynamically change.
8. as any described client/server system among the claim 5-7, it is characterized in that corresponding data are the at interval interior high data of request of data side's visiting frequency of a period of time.
9. client/server system as claimed in claim 8, it is characterized in that, described client/server system is two layer architectures that comprise customer interface layer and data service layer, and described request of data side is the client computer that belongs to the customer interface layer, and described database belongs to data service layer.
10. client/server system as claimed in claim 8, 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, and described database belongs to data service layer.
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 true CN1508703A (en) | 2004-06-30 |
| CN1238792C 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) |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100371900C (en) * | 2006-01-19 | 2008-02-27 | 华为技术有限公司 | Method and system for synchronizing data |
| WO2010034201A1 (en) * | 2008-09-28 | 2010-04-01 | 北京易路联动技术有限公司 | Management method, system of internet personal data bank technology and network side device |
| 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 |
| CN103377264A (en) * | 2012-04-28 | 2013-10-30 | 阿里巴巴集团控股有限公司 | Method and device for generating account bills |
| CN103607312A (en) * | 2013-11-29 | 2014-02-26 | 广州华多网络科技有限公司 | Data request processing method and system for server system |
| CN104166820A (en) * | 2013-05-16 | 2014-11-26 | 北京畅游天下网络技术有限公司 | Data management method and system |
| CN107133326A (en) * | 2017-05-05 | 2017-09-05 | 广州千淘信息技术有限公司 | A kind of asynchronous data storehouse and its data processing method |
| CN107317855A (en) * | 2017-06-21 | 2017-11-03 | 努比亚技术有限公司 | A kind of data cache method, data request 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 |
| CN114710741A (en) * | 2005-08-12 | 2022-07-05 | 赛乐得科技(北京)有限公司 | Method and system for optimizing content delivery |
-
2002
- 2002-12-18 CN CN 02155178 patent/CN1238792C/en not_active Expired - Fee Related
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114710741B (en) * | 2005-08-12 | 2023-04-18 | 赛乐得科技(北京)有限公司 | Method and system for optimizing content delivery |
| CN114710741A (en) * | 2005-08-12 | 2022-07-05 | 赛乐得科技(北京)有限公司 | Method and system for optimizing content delivery |
| 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 |
| WO2010034201A1 (en) * | 2008-09-28 | 2010-04-01 | 北京易路联动技术有限公司 | Management method, system of internet personal data bank technology and network side device |
| CN103377264A (en) * | 2012-04-28 | 2013-10-30 | 阿里巴巴集团控股有限公司 | Method and device for generating account bills |
| 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 |
| CN104166820A (en) * | 2013-05-16 | 2014-11-26 | 北京畅游天下网络技术有限公司 | Data management method and system |
| CN103607312B (en) * | 2013-11-29 | 2017-02-15 | 广州华多网络科技有限公司 | Data request processing method and system for server system |
| CN103607312A (en) * | 2013-11-29 | 2014-02-26 | 广州华多网络科技有限公司 | 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 |
| CN107317855A (en) * | 2017-06-21 | 2017-11-03 | 努比亚技术有限公司 | A kind of data cache method, data request 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN1238792C (en) | 2006-01-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN1238792C (en) | Data bank accessing method and client machine/server system for realizing same | |
| US8046425B1 (en) | Distributed adaptive network memory engine | |
| US9086914B2 (en) | System and method for reducing startup cost of a software application | |
| CN100451976C (en) | Migration management based on massive data classified memory system | |
| US7644108B1 (en) | Network acceleration device cache supporting multiple historical versions of content | |
| CN109240946A (en) | The multi-level buffer method and terminal device of data | |
| CN1949220A (en) | Structuring system and method of network community dynamic list | |
| CN101042679A (en) | Method and system for maintenance memory consistency | |
| WO2011064742A1 (en) | Super-records | |
| CN1831824A (en) | Buffer data base data organization method | |
| CN101067820A (en) | Method for prefetching object | |
| EP4254187A1 (en) | Cross-organization & cross-cloud automated data pipelines | |
| CN117539915B (en) | Data processing method and related device | |
| CN118535578A (en) | Hash and LSM Tree-based hybrid index method and key value storage system | |
| CN113448897A (en) | Array structure and optimization method suitable for pure user mode remote direct memory access | |
| US7529891B2 (en) | Balanced prefetching exploiting structured data | |
| Choi et al. | A write-friendly approach to manage namespace of Hadoop distributed file system by utilizing nonvolatile memory | |
| US20220277006A1 (en) | Disaggregated Query Processing Utilizing Precise, Parallel, Asynchronous Shared Storage Repository Access | |
| CN1622056A (en) | Method for accessing files | |
| CN112445794A (en) | Caching method of big data system | |
| Wei et al. | Optimizing the B+ tree Index with Hotness Awareness and Adaptivity | |
| Chatzopoulos et al. | SPADE: Tuning scale-out OLTP on modern RDMA clusters | |
| Min et al. | SepHash: A Write-Optimized Hash Index On Disaggregated Memory via Separate Segment Structure | |
| CN117973558A (en) | SERVERLESS machine learning model training-oriented dynamic scalable data sharing system | |
| Hao | Large-Scale Key-Value Stores |
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 |