CN101931647B - Three-tier architecture based method for optimizing incremental update of system data - Google Patents
Three-tier architecture based method for optimizing incremental update of system data Download PDFInfo
- Publication number
- CN101931647B CN101931647B CN 201010247928 CN201010247928A CN101931647B CN 101931647 B CN101931647 B CN 101931647B CN 201010247928 CN201010247928 CN 201010247928 CN 201010247928 A CN201010247928 A CN 201010247928A CN 101931647 B CN101931647 B CN 101931647B
- Authority
- CN
- China
- Prior art keywords
- client
- data
- side program
- delta package
- server
- 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.)
- Active
Links
Images
Landscapes
- Stored Programmes (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention provides a three-tier architecture based method for optimizing incremental update of system data. The method is characterized in that the system comprises a database server, an application program server and a client program; after basic data is successfully downloaded by a client, the downloaded basic data generates a buffer file on the client, and when the client program starts next time and requests basic data update to the application program server, the application program server compares recorded operation time stamps, and downloads the changed data from the database server. Therefore, the time for updating the system basic data from the database server to the client is greatly shortened, and even is omitted, and the integral performance of the system is improved.
Description
[technical field]
The present invention relates to a kind of field of optimization method, especially software management system of the system data incremental update based on three-tier architecture.
[background technology]
Report to a higher authorities for approval and put on record in the system item process at business data of exploitation, because whole system must be launched business operation by wide area network, so the final development plan of determining is that system architecture adopts three layout layers, that is: client-side program (Client) ━ apps server (Application Server) ━ database server (Database Server), after different client-side program is connected to the apps server at center by wide area network, by with the data communication of apps server, thereby carry out the miscellaneous service operation.In this typical three layout layers, client is store data not, and behind each the startup, it all needs to upgrade all kinds of up-to-date basic datas by apps server from database server, launches all kinds of business operations on the basis of these basic datas afterwards., how efficiently these basic datas to be updated to client synchronously from database server side soon here, just to become the key of a technology.Be updated to synchronously in the process of client by wide area network in the basic data with server end, traditional way is after each client-side program starts, all be connected to first application server, then begin to download all basic datas in the local system internal memory, for oneself, after all operations is complete, withdraw from client-side program, these basic datas that are kept in the internal memory are also discharged fully/are destroyed, this be a kind of fairly simple also be solution comparatively intuitively.But this traditional technology realizes need can only being applicable to the few situation of data record amount of renewal, because when the basic data amount of need upgrading reaches 100,000,1,000,000 even greater number, download the needed time of these data by wide area network will be up to dozens of minutes even more than several hours at every turn, user must wait for during this, can not carry out business operation, this availability and user who has had a strong impact on program experiences.
[summary of the invention]
In order to overcome the shortcoming of above-mentioned technology, the present invention seeks to solve in the situation that need to upgrade a large amount of basic datas to client by wide area network, shorten even save this part data synchronization updating time, to improve the overall performance of system.
The present invention realizes like this, a kind of optimization method of the system data incremental update based on three-tier architecture, it is characterized in that: described three-tier architecture comprises database server, apps server, client-side program, and described optimization method is realized according to the following steps:
Step 10, client-side program start, and are connected to apps server;
Step 20, client-side program send to apps server with the last Data Update time;
Step 30, apps server contrast by the operating time stamp of record, are specially: the operation of all kinds of basic datas of database, all need record the last operation time, and namely each bar basic data all has unique operating time; The operating time of every basic data and described Data Update time are carried out the time contrast; If the basic data of client-side program has renewal, search the data that client-side program need to upgrade, and the data that will upgrade form delta package at database server, if the basic data of client-side program is not upgraded, directly begin the business operation of client-side program;
The delta package that step 40, client-side program downloading data storehouse server form;
Step 50, client-side program merge the delta package of download and the cache file of self, form new cache file, do being updated successfully sign again, then begin the business operation of client-side program.
Usefulness of the present invention is: can shorten largely the system-based data and be updated to the needed time of client from database server, even can ignore the time loss (when database server does not have Data Update) of this part, promoted the overall performance of system.This is for the system that maybe needs to be undertaken by wide area network Data Update based on three-tier architecture, and especially huge when the system data amount, extremely during poor efficiency, the present invention can obtain the overall performance of system the lifting of a matter to the traditional data update method.
[description of drawings]
Fig. 1 is three layer managing system communications rack compositions of embodiments of the invention.
Fig. 2 is the schematic flow sheet that data increment of the present invention upgrades optimization method.
[embodiment]
Below in conjunction with drawings and Examples the present invention is described further.
The software management system that Fig. 1 is based on three-tier architecture can be divided into three parts usually: the database server part: be that common Database Systems are installed, such as the SqlServer of common generation, Oracle, DB2 etc.
Apps server part: be to be responsible for concrete business realizing, in the middle of user program and database, play the effect of bridge, define and provide various interface for client program calls.Apps server (Application Server) can in same physical machine, also can be positioned on the different machines with database server (Database Server).
Client-side program part: be towards the end user, according to difference in functionality different client-side program can be arranged, but all must be connected to apps server, form hub-and-spoke configuration, and the various data-interfaces that encapsulated of invokes application server, realize business operation.If the database server side basic data has renewal, the employed related data of client must upgrade in time, guaranteeing the correctness of business datum, this also just why client-side program need the reason of online more new data.
Fig. 2 is the schematic flow sheet that data increment of the present invention upgrades optimization method.Concrete flow process is that minute following steps realize:
Step 10, client-side program start, and are connected to apps server;
Step 20, client-side program send to apps server with the last Data Update time;
Step 30, apps server contrast by the operating time stamp of record, if the basic data of client-side program has renewal, search the data that client-side program need to upgrade, and the data that will upgrade form delta package at database server, if the basic data of client-side program is not upgraded, directly begin the business operation of client-side program;
The delta package that step 40, client-side program downloading data storehouse server form;
Step 50, client-side program merge the delta package of download and the cache file of self, form new cache file, do being updated successfully sign again, then begin the business operation of client-side program.
Client-side program wherein, application server programs, database server all needs to carry out suitable function to be increased or structural adjustment, needs specifically to realize following at least function:
1. in database server side, every operation to all kinds of basic datas of database (comprising that record modification, record increase and record deletion) all needs to register the last operation time, and this is equivalent to each bar basic data record, all have unique operating time, be convenient to follow the tracks of;
2. after each client-side program starts, all need the last Data Update of the machine time is sent to apps server.The apps server program just can learn that by the operating time stamp comparison of record which data active client has not yet upgrade, and upgrades the delta package file thereby form.For different client-side program, the update package that returns is different.
3. if client terminal local does not have data buffer storage file (be linked to server for the first time, or the data buffer storage file being deleted), then need to download basic data full dose bag.This is to guarantee that in the minimum efficiency situation, efficient of the present invention still is not less than the efficient of traditional data update mode.
4. if the basic data of database server side has been carried out large batch of data modification or interpolation, certainly will cause that to return delta package excessive, if return delta package this moment, although reduced data download time, but obviously increased the delta package data returned and the merging time of local cache file.So when delta package is excessive, can directly return the full dose bag, to improve whole efficiency.
5. after the renewal delta package downloaded to client, needs and local basis data buffer storage file bag carried out the data merging and upgrade, and generate new basic data cache file, thereby finish Data Update.
In a word, the present invention can solve in the situation that need to upgrade a large amount of basic datas to client by wide area network, shortens even saves this part data synchronization updating time, to improve the overall performance of system.
The above only is preferred embodiment of the present invention, and all equalizations of doing according to the present patent application claim change and modify, and all should belong to covering scope of the present invention.
Claims (5)
1. optimization method based on the system data incremental update of three-tier architecture, it is characterized in that: described three-tier architecture comprises database server, apps server, client-side program, described optimization method is realized according to the following steps:
Step 10, client-side program start, and are connected to apps server;
Step 20, client-side program send to apps server with the last Data Update time;
Step 30, apps server contrast by the operating time stamp of record, are specially: the operation of all kinds of basic datas of database, all need record the last operation time, and namely each bar basic data all has unique operating time; Operating time and the described Data Update time of every basic data are carried out the time contrast; If the basic data of client-side program has renewal, search the data that client-side program need to upgrade, and the data that will upgrade form delta package at database server, if the basic data of client-side program is not upgraded, directly begin the business operation of client-side program;
The delta package that step 40, client-side program downloading data storehouse server form;
Step 50, client-side program merge the delta package of download and the cache file of self, form new cache file, do being updated successfully sign again, then begin the business operation of client-side program.
2. the optimization method of a kind of system data incremental update based on three-tier architecture according to claim 1, it is characterized in that: when described delta package is excessive, should directly form the full dose bag from database server, to improve the whole efficiency of system data increment, the conceptual data that described database server directly will upgrade client-side program forms the full dose bag, downloads for client-side program.
3. the optimization method of a kind of system data incremental update based on three-tier architecture according to claim 1, it is characterized in that: when described delta package and the cache file of self merge, if comprised the data record that database server newly increases in the delta package, then directly the data record in the delta package is added in the cache file of self.
4. the optimization method of a kind of system data incremental update based on three-tier architecture according to claim 1, it is characterized in that: when described delta package and the cache file of self merge, if comprised the data record after the database server modification change in the delta package, then delete first the legacy data record content in delta package corresponding to self cache file, again delta package is added in self cache file.
5. the optimization method of a kind of system data incremental update based on three-tier architecture according to claim 1, it is characterized in that: when described delta package and the cache file of self merge, if comprised the data record of database server deletion in the delta package, then should be the data record deletion in the delta package corresponding in self cache file.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201010247928 CN101931647B (en) | 2010-08-09 | 2010-08-09 | Three-tier architecture based method for optimizing incremental update of system data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201010247928 CN101931647B (en) | 2010-08-09 | 2010-08-09 | Three-tier architecture based method for optimizing incremental update of system data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101931647A CN101931647A (en) | 2010-12-29 |
| CN101931647B true CN101931647B (en) | 2013-02-06 |
Family
ID=43370572
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201010247928 Active CN101931647B (en) | 2010-08-09 | 2010-08-09 | Three-tier architecture based method for optimizing incremental update of system data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101931647B (en) |
Families Citing this family (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102801643A (en) * | 2011-05-27 | 2012-11-28 | 腾讯科技（深圳）有限公司 | Method and system for displaying user update information |
| CN103812849B (en) * | 2012-11-15 | 2018-12-07 | 腾讯科技（深圳）有限公司 | A kind of local cache update method, system, client and server |
| CN103825632B (en) * | 2012-11-16 | 2016-08-03 | 纬创资通股份有限公司 | The information fast synchronization method of application near-field communication |
| CN103853574B (en) | 2012-12-06 | 2015-09-16 | 腾讯科技（深圳）有限公司 | A kind of method and system of software upgrading |
| CN104317957B (en) * | 2014-11-11 | 2017-10-24 | 中国建设银行股份有限公司 | A kind of open platform of report form processing, system and report processing method |
| CN104935753A (en) * | 2015-07-03 | 2015-09-23 | 金陵科技学院 | Local-storage and synchronized method for mobile phone APP data |
| CN106469155A (en) * | 2015-08-17 | 2017-03-01 | 阿里巴巴集团控股有限公司 | A kind of basic data processing method, apparatus and system |
| CN105302895B (en) * | 2015-10-21 | 2018-11-27 | 浪潮通用软件有限公司 | A kind of data cache synchronization method, server and client side |
| CN106302753A (en) * | 2016-08-18 | 2017-01-04 | 福建天泉教育科技有限公司 | The method and system of client-side program incremental update |
| CN107171856A (en) * | 2017-06-21 | 2017-09-15 | 珠海信达九州科技有限公司 | A kind of method that instant communicating system organizational structure quickly updates |
| CN107800691A (en) * | 2017-10-12 | 2018-03-13 | 云巅（上海）网络科技有限公司 | The system and method for building application program on demand and accessing data trnascription is realized based on distributed storage mechanism |
| CN109471653B (en) * | 2018-09-29 | 2022-06-17 | 阿波罗智联(北京)科技有限公司 | Application program updating method, electronic device, server and storage medium |
| CN111245893B (en) * | 2019-12-28 | 2023-04-07 | 杭州拓深科技有限公司 | Performance-optimized mobile terminal operation and maintenance inspection task downloading method |
| CN112994955B (en) * | 2021-04-21 | 2021-08-10 | 恒生电子股份有限公司 | Upgrade package sending management method, incremental upgrade package preparation method and related device |
| CN113821525B (en) * | 2021-11-24 | 2022-02-25 | 北京金堤科技有限公司 | Data updating system and method, storage medium and electronic device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TW453083B (en) * | 1999-12-01 | 2001-09-01 | Inventec Corp | Method to download data from network terminals |
| CN1379335A (en) * | 2001-03-30 | 2002-11-13 | 松下电器产业株式会社 | Remote control program system |
| CN1690961A (en) * | 2004-04-30 | 2005-11-02 | 鸿富锦精密工业（深圳）有限公司 | Client program automatic updating system and method |
-
2010
- 2010-08-09 CN CN 201010247928 patent/CN101931647B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TW453083B (en) * | 1999-12-01 | 2001-09-01 | Inventec Corp | Method to download data from network terminals |
| CN1379335A (en) * | 2001-03-30 | 2002-11-13 | 松下电器产业株式会社 | Remote control program system |
| CN1690961A (en) * | 2004-04-30 | 2005-11-02 | 鸿富锦精密工业（深圳）有限公司 | Client program automatic updating system and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101931647A (en) | 2010-12-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101931647B (en) | Three-tier architecture based method for optimizing incremental update of system data | |
| CN101110788B (en) | Method and system for updating client software | |
| CN100549950C (en) | The dispositions method of distributed software system | |
| CN101770515B (en) | Data block comparison based data updating method | |
| CN101719073B (en) | Intelligent client-based on-demand downloading realization method | |
| CN104918114B (en) | A kind of operating system update method and device | |
| CN101546269B (en) | System and method capable of executing file version updating | |
| CN101697133A (en) | Software upgrading method, software upgrading system and client | |
| EP2021937A2 (en) | Techniques to perform gradual upgrades | |
| CN102291416A (en) | Two-way synchronizing method and system of client-side and server-side | |
| CN101464895A (en) | Method, system and apparatus for updating internal memory data | |
| CN103530150A (en) | Remote updating method for Linux operating system | |
| CN103177077B (en) | The storage of a kind of APK file and output intent | |
| CN105893115A (en) | Method and system for differential deployment of virtual machine | |
| CN100517229C (en) | Data version upgrading method | |
| WO2009117921A1 (en) | Distributed network management system, network management server and method | |
| CN110389766A (en) | HBase container cluster dispositions method, system, equipment and computer readable storage medium | |
| WO2013040906A1 (en) | Method and system for managing software version of base station | |
| CN102916974A (en) | Cluster configuration updating method | |
| CN102707690B (en) | Configuration data download method and download system | |
| CN1878366A (en) | Firmware update method for mobile phone | |
| CN110083372B (en) | Block chain data version upgrading method | |
| CN101877655A (en) | Network management system, network management server and method | |
| CN114942965A (en) | Method and system for accelerating synchronous operation of main database and standby database | |
| CN102201013B (en) | Vehicle state management method based on memory database |
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 | ||
| C56 | Change in the name or address of the patentee |
Owner name: FUJIAN STARNET E-VIDEO INFORMATION SYSTEM CO., LTD Free format text: FORMER NAME: FUZHOU STARNET EVIDEO INFORMATION SYSTEM CO., LTD. |
|
| CP01 | Change in the name or title of a patent holder |
Address after: Cangshan District of Fuzhou City, Fujian province 350000 to build a new town, Jinshan Road No. 618, juyuanzhou Industrial Park No. 19 building one or two layer Patentee after: Fujian Starnet e-Video Information System Co., Ltd. Address before: Cangshan District of Fuzhou City, Fujian province 350000 to build a new town, Jinshan Road No. 618, juyuanzhou Industrial Park No. 19 building one or two layer Patentee before: Fuzhou Starnet Evideo Information System Co., Ltd. |