CN109254995A

CN109254995A - A method of utilizing cache synchronization data

Info

Publication number: CN109254995A
Application number: CN201810870408.2A
Authority: CN
Inventors: 王守金
Original assignee: Inspur General Software Co Ltd
Current assignee: Inspur General Software Co Ltd
Priority date: 2018-08-02
Filing date: 2018-08-02
Publication date: 2019-01-22

Abstract

The present invention provides a kind of method using cache synchronization data, belong to computer field, the present invention includes that configuration needs synchronous tables of data, according to configuration information record SQL action statement and stamp timestamp, client updates the timestamp in client-cache by the timestamp synchrodata with server correlation data table into local cache, after synchronously completing.By this method, client can be reduced to the amount of access of server data table, improve software operation efficiency.

Description

A method of utilizing cache synchronization data

Technical field

The present invention relates to Computer Applied Technology more particularly to a kind of methods using cache synchronization data.

Background technique

The database of business management software houses a large amount of tables of data, and client needs frequently to visit in user operation process Ask the data in server data table.If reading data from server database every time, a large amount of data are had from clothes Business device is transferred to client, causes database and network transmission to bear excessive, the client end response time extends, and influences user's body It tests.To reduce the access to server data table, a cache database can be established in client, in server database Data buffer storage is to client, and directly access data reduce network transmission to client in the buffer.It is synchronous to occur data again in this way The problem of, when the data in server database are changed, how automatic synchronization is into caching data on client library, to protect Newest data are accessed in card client at any time.

Summary of the invention

In order to solve the above technical problems, can pass through the invention proposes a kind of method using cache synchronization data This method automatic synchronization server data is to client.

The technical scheme is that

A method of using cache synchronization data, mainly comprise the steps that

1. configuration needs synchronous tables of data, it is saved in the PSPTABLEHISTORY table of server.

2. according to configuration information record SQL action statement and stamping timestamp:

(1) operation of data mainly includes: INSERT, UPDATE, DELETE these types mode, when user is to specified number After table handling, when clicking preservation, check the need for caching in the SQLPRIEVIEW event of datawindow.

(2) if checking PSPTABLEHISTORY has the corresponding data of current operation table, SQL record is serviced SQL Sentence is inserted into PSPSQLBUFFER table, and stamps timestamp.

3. client is by the timestamp synchrodata with server correlation data table into local cache:

(1) it first checks for client to automatically create if not whether there is or not PSPTABLEHISTORY table, and in client Timestamp stamps 1900-01-01, to carry out initial synchronisation.

(2) then the PSPTABLEHISTORY_LASTUPDATE of comparison client and server decides whether to carry out together Step synchronizes if client is later than server time stamp, otherwise asynchronous.

(3) according to the PSPSQLBUFFER table of the timestamp filtering server of client, SQL statement is extracted, in client It is executed in caching, it is synchronous to complete data.

4. updating the timestamp in client-cache after synchronously completing: after caching data on client synchronously completes, updating visitor Timestamp in the caching of family end is consistent with server.

The present invention includes two tables of data PSPTABLEHISTORY, PSPSQLBUFFER.

1. data buffer storage table PSPTABLEHISTORY

Field name	Type	Explanation
			PSPTABLEHISTORY_TABLENAME	varchar(20)	Data table name
PSPTABLEHISTORY_LASTUPDATE	varchar(20)	Recent renewal time
			PSPTABLEHISTORY_SFQY	char(1)	By no enabling

2. data value PSPSQLBUFFER

The beneficial effects of the invention are as follows

Method provided by the invention can reduce client to the amount of access of server, reduce network transmission pressure, work as clothes Data in business device database are changed, and automatic synchronization is into caching data on client library, to guarantee that client is visited at any time Ask newest data.

Detailed description of the invention

Fig. 1 shows the flow charts of client more new data；

Fig. 2 indicates the flow chart of client access data.

Specific embodiment

More detailed elaboration is carried out to the contents of the present invention below:

By taking synchronous meter ZWWLDW as an example,

1, data buffer storage table PSPTABLEHISTORY is created in server database, and is inserted into data: insert into PSPTABLEHISTORY values(‘ZWWLDW’,”,’1’)。

2, it checks the need for caching in the SQLPRIEVIEW event of client datawindow, if checked PSPTABLEHISTORY has the corresponding data of current operation table, then SQL statement is inserted into PSPSQLBUFFER table, and stamp Timestamp.

3, the PSPTABLEHISTORY_LASTUPDATE for comparing client and server decides whether to synchronize.

4, according to the PSPSQLBUFFER table of the timestamp filtering server of client, SQL statement is extracted, it is slow in client Middle execution is deposited, it is synchronous to complete data.

5, after caching data on client synchronously completes, the timestamp updated in client-cache is consistent with server.

Claims

1. a kind of method using cache synchronization data, it is characterised in that it is comprised the steps of:

1) configuration needs synchronous tables of data；

2) according to configuration information record SQL action statement and timestamp is stamped；

3) client is by the timestamp synchrodata with server correlation data table into local cache；

4) timestamp in client-cache is updated after synchronously completing.

2. according to the method described in claim 1, it is characterized by:

In step 1), configuration needs synchronous tables of data, is saved in the PSPTABLEHISTORY table of server.

3. according to the method described in claim 1, it is characterized by:

In step 2,

After user is to specified feature operation, when clicking preservation, checking in the SQLPRIEVIEW event of datawindow is It is no to need to cache；

If checking there are the corresponding data of current operation table in client table PSPTABLEHISTORY, SQL statement is inserted into Into server PS PSQLBUFFER table, and stamp timestamp.

4. according to the method described in claim 1, it is characterized by:

In step 3),

Client is first checked for whether there is or not PSPTABLEHISTORY table, is automatically created if not, and is beaten in client time stamp Upper 1900-01-01, to carry out initial synchronisation；

Then the PSPTABLEHISTORY_LASTUPDATE for comparing client and server decides whether to synchronize, if Client is later than server time stamp, then synchronizes, otherwise asynchronous；

According to the PSPSQLBUFFER table of the timestamp filtering server of client, SQL statement is extracted, is held in client-cache It is synchronous to complete data for row.

5. according to the method described in claim 1, it is characterized by:

In step 4), after caching data on client synchronously completes, the timestamp updated in client-cache is consistent with server.