CN105404633B - A kind of client-based database multi-point backup system and its backup method - Google Patents
A kind of client-based database multi-point backup system and its backup method Download PDFInfo
- Publication number
- CN105404633B CN105404633B CN201410469106.6A CN201410469106A CN105404633B CN 105404633 B CN105404633 B CN 105404633B CN 201410469106 A CN201410469106 A CN 201410469106A CN 105404633 B CN105404633 B CN 105404633B
- Authority
- CN
- China
- Prior art keywords
- data
- database
- update
- client
- database 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
Abstract
The present invention relates to database technical fields, specially a kind of client-based database multi-point backup system and its backup method, its can on heterogeneous database multi-point backup data, realize backup storage, it includes database server and client, database server can run different database products, installation database access interface in client, client is communicated by network and database server, at database server access address and data base read-write account are provided for client, in client installation database multi-point backup software, database multi-point backup software accesses database server using data base read-write account and writes data to database server.
Description
Technical field
The present invention relates to database technical field, specially a kind of client-based database multi-point backup system and its
Backup method.
Background technology
In database application field, database purchase relational data is the important infrastructure that data are preserved and utilized.
Significant data needs multiple spot to preserve, to reduce the risk that Single Point of Faliure causes loss of data.
On the IT infrastructure that many enterprises provide information system deployment in different cloud computing service quotient, by information
The data that system generates, while be stored on the server of different IT service providers, it backups each other, reduces information system and stop fortune
Capable risk.The database environment that different IT service providers provide is not quite similar, and needs the database multiple spot for being suitble to such case
Standby system and mechanism.
The features such as specification, technical specification, the interface of same database product are identical, and provide corresponding data backup work
Tool and method, it is more guaranteed in terms of data backup.Characteristic is different between disparate databases product, especially the hair of cloud computing
, there are many databases based on cloud, information system is disposed in different cloud platforms, then need blanket data in exhibition
Multi-point backup mechanism and method and corresponding system deployment design.
Invention content
To solve the above-mentioned problems, the present invention provides a kind of client-based database multi-point backup systems and its standby
Part method, being capable of multi-point backup data, realization backup storage on heterogeneous database.
Its technical solution is such：A kind of client-based database multi-point backup method, which is characterized in that in institute
It states and provides access address and data base read-write account for the client at database server, in the client installation data
Library multi-point backup software, the database multi-point backup software access the database server simultaneously using data base read-write account
Data are write to the database server, write data include the following steps：
（1）It is ready to need newer data；
（2）It is updated the data into database server, obtains update result；
（3）If the data update success on database server, this update terminate；If update is unsuccessful,
By data buffer storage in persistent storage device, it is data cached including database preserve Status Flag and data record group into；
（4）If there is updating the unsuccessful data being cached in persistent storage device, read from persistent storage device
It is data cached, it is updated the data according to database flag to corresponding database server, and obtain update result；
（5）After update operation, if update data cached in check and inspection persistent storage device is as a result, all numbers
The data have all been stored according to library server, then have deleted the data cached in persistent storage device；If update is unsuccessful, to holding
Data cached preservation mark is configured in storage long, to reflect latest update situation, for being used during next update.
It is further characterized by the step of, write data（1）In, it is ready to deposit persistently after needing newer data
It is cached in storage equipment, step（3）In if on database server data update success after delete persistent storage device
Upper corresponding data cached, this update terminates.
A kind of client-based database multi-point backup system, which is characterized in that it includes database server and visitor
Family end, the database server can run different database products, installation database access interface in the client,
The client is communicated by network with the database server.
It is further characterized by the database server is database server or the deployment for being deployed in enterprises
In the database server on cloud computing platform；
Server of the database server for the database product of multiple operation different structures；
The data stored in the database server are consistent to the logical view model of user.
After scheme using the present invention, without disposing synchronizing software in database side, installation database is more at client
Point backup software, can provide a kind of convenient means for the database multi-point backup between heterogeneous database, applied widely.
Description of the drawings
Fig. 1 is present system deployment architecture schematic diagram；
Fig. 2 updates the data step schematic diagram for client software into 3 database servers；
Fig. 3 is database information and data cached logical recording format schematic diagram；
Fig. 4 backs up schematic diagram again for client software with the data that persistent storage caches.
Specific embodiment
As shown in Figure 1, a kind of client-based database multi-point backup system, can including 3 database servers
To run different database products, installation database access interface in client, client passes through network and database service
It can be the equipment such as PC, notebook, tablet, smart mobile phone that device, which carries out communication customer end, possess the ability for accessing network, Neng Gouan
Database access interface is filled, to obtain the ability for accessing database server, client installs windows by taking notebook as an example
Operating system, and installation database access interface environment, database multi-point backup software access number using database access interface
According to library server；Database server is the number for being deployed in the database server of enterprises or being deployed on cloud computing platform
According to library server；Database server can run disparate databases product, the data pair stored in two database servers
The logical view model of user is consistent.
As shown in Figure 2, a kind of client-based database multi-point backup method is client at database server
Access address and data base read-write account are provided, in client installation database multi-point backup software, database multi-point backup is soft
Part accesses database server using data base read-write account and writes data to database server, and data packets include following step
Suddenly：
（1）Database address and account information are obtained, is ready to need newer data；
（2）It is updated the data into 3 database servers, obtains update result；
（3）It is data cached including database flag by data buffer storage in persistent storage device if update is unsuccessful
With data record group into；
（4）If the data update success on database server, this update terminate.
As shown in Figure 3, database information and data cached logical recording format schematic diagram.Client software needs to preserve number
According to library information, the information such as database IP address, account can be stored in local, and database is current according to such structure
State recorded, the use of database positioning field can be defined flexibly, to facilitate the Function Extension of client software.
For example whether the data in database of record are last states, can also record whether current database can be used.
In Fig. 3, data cached logical recording format defines a data structure, and provide for client temporal data
The Status of Backups of one record.In data structure in addition to comprising the data record in database to be saved in, this is further comprised
The database of item record preserves status information, and the preservation state of this record in the database is recorded, facilitates client
Software backs up data record again.The present invention only provides the logical format of data definition, and data specifically store realization
Mode does not limit, and can realize there are many method, for example puts in the local database, with XML tissue storages etc., specific implementation
When, suitable method can be selected.
As shown in Figure 4, client software can back up the data being not backed up in persistent storage again, and client is soft
Part is data cached in proper moment, scanning persistent storage device, carries out backup operation.The newer strategy of proper moment is by reality
Apply personnel's decision, the present invention does not limit concrete measure, can periodically update or network is unobstructed, database is normal
It can be updated in the case of.Again the step of backing up is as follows：
（1）For client software from persistent storage, data cached interrecord structure as shown in Figure 3 reads data；
（2）Check that database corresponding with data record preserves Status Flag, into the database for also not preserving the data
Back up the data；
（3）Check backup operation as a result, seeing in all databases whether all save data；
（4）If it is not, then the database preservation Status Flag that update persistent storage is data cached；If it is, it deletes
Have backed up the data record of completion；
（5）Wait for next backup.
Claims (2)
- A kind of 1. client-based database multi-point backup method, which is characterized in that at the database server be institute It states client and access address and data base read-write account is provided, it is described in the client installation database multi-point backup software Database multi-point backup software accesses the database server and to the database server using data base read-write account Data are write, write data include the following steps：（1）It is ready to need newer data；（2）It is updated the data into database server, obtains update result；（3）If the data update success on database server, this update terminate；If update is unsuccessful, by number According to being buffered in persistent storage device, it is data cached including database preserve Status Flag and data record group into；（4）If there is updating the unsuccessful data being cached in persistent storage device, caching is read from persistent storage device Data update the data, and obtain update result according to database flag to corresponding database server；（5）After update operation, if update data cached in check and inspection persistent storage device is as a result, all databases Server has all stored the data, then deletes the data cached in persistent storage device；If update is unsuccessful, to persistently depositing Data cached preservation mark is configured in storage, to reflect latest update situation, for being used during next update.
- 2. a kind of client-based database multi-point backup method according to claim 1, which is characterized in that described to write The step of data（1）In, it is ready to be cached in persistent storage device after needing newer data, step（3）In if Corresponding data cached in deletion persistent storage device after data update success on database server, this update terminates.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410469106.6A CN105404633B (en) | 2014-09-16 | 2014-09-16 | A kind of client-based database multi-point backup system and its backup method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410469106.6A CN105404633B (en) | 2014-09-16 | 2014-09-16 | A kind of client-based database multi-point backup system and its backup method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105404633A CN105404633A (en) | 2016-03-16 |
| CN105404633B true CN105404633B (en) | 2018-06-19 |
Family
ID=55470123
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410469106.6A Active CN105404633B (en) | 2014-09-16 | 2014-09-16 | A kind of client-based database multi-point backup system and its backup method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105404633B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113984067B (en) * | 2021-10-28 | 2023-04-11 | 福建省海峡智汇科技有限公司 | Navigation automation system based on distributed technology |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6564215B1 (en) * | 1999-12-16 | 2003-05-13 | International Business Machines Corporation | Update support in database content management |
| CN101876924A (en) * | 2009-04-30 | 2010-11-03 | 升东网络科技发展(上海)有限公司 | Database fault automatic detection and transfer method |
| CN102567438A (en) * | 2010-09-28 | 2012-07-11 | 迈塔斯威士网络有限公司 | Method for providing access to data items from a distributed storage system |
| CN103886091A (en) * | 2014-04-01 | 2014-06-25 | 无锡科技职业学院 | Database synchronization method based on record marks |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8655985B2 (en) * | 2010-11-15 | 2014-02-18 | International Business Machines Corporation | Content delivery using multiple sources over heterogeneous interfaces |
-
2014
- 2014-09-16 CN CN201410469106.6A patent/CN105404633B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6564215B1 (en) * | 1999-12-16 | 2003-05-13 | International Business Machines Corporation | Update support in database content management |
| CN101876924A (en) * | 2009-04-30 | 2010-11-03 | 升东网络科技发展(上海)有限公司 | Database fault automatic detection and transfer method |
| CN102567438A (en) * | 2010-09-28 | 2012-07-11 | 迈塔斯威士网络有限公司 | Method for providing access to data items from a distributed storage system |
| CN103886091A (en) * | 2014-04-01 | 2014-06-25 | 无锡科技职业学院 | Database synchronization method based on record marks |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105404633A (en) | 2016-03-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11461296B2 (en) | Systems and methods for database management using append-only storage devices | |
| CN105549905B (en) | A kind of method that multi-dummy machine accesses distributed objects storage system | |
| JP5756394B2 (en) | Computer program, system, and method for restoring a restore set of files from backup objects stored in a sequential backup device | |
| JP6381570B2 (en) | A program for restoring data objects from a backup device | |
| KR101922044B1 (en) | Recovery technique of data intergrity with non-stop database server redundancy | |
| CN103607312A (en) | Data request processing method and system for server system | |
| US8762347B1 (en) | Method and apparatus for processing transactional file system operations to enable point in time consistent file data recreation | |
| CN105868056B (en) | Obtain the method, apparatus and secure virtual machine of deleted document in Windows virtual machine | |
| CN102023816A (en) | Object storage policy and access method of object storage system | |
| CN104104582B (en) | A kind of data storage path management method, client and server | |
| CN102272751A (en) | Data integrity in a database environment through background synchronization | |
| CN105808449A (en) | Virtual storage image version management method and system for virtual machine | |
| CN106446075A (en) | Page request processing method and apparatus | |
| CN104079600B (en) | File memory method, device, access client and meta data server system | |
| CN109271367A (en) | Distributed file system multinode snapshot rollback method and system | |
| US9483213B1 (en) | Virtual media changers | |
| CN107169126A (en) | A kind of log processing method and relevant device | |
| CN107332966A (en) | A kind of backup method of address list information | |
| CN105404633B (en) | A kind of client-based database multi-point backup system and its backup method | |
| US10372688B2 (en) | Moving data within a distributed data storage system using virtual file links | |
| CN116010164A (en) | Method, device and system for backing up data | |
| US8805942B2 (en) | Storing and partitioning email messaging data | |
| CN103714089A (en) | Method and system of rolling back cloud database | |
| CN105162891A (en) | Data storage method based on IP network | |
| CN103491124A (en) | Method for processing multimedia message data and distributed cache system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20190412 Address after: 100007 Unit 922 Gehua Building, No. 1 Qinglong Hutong, Dongcheng District, Beijing Patentee after: SINOCARBON INNOVATION & INVESTMENT Co.,Ltd. Address before: 511458 X1301-C6040 (Cluster Registration) (JM) No. 106 Fengze East Road, Guangzhou, Guangdong Province Patentee before: Zhi Xiao 2 (Guangzhou) Technology Co.,Ltd. Effective date of registration: 20190412 Address after: 511458 X1301-C6040 (Cluster Registration) (JM) No. 106 Fengze East Road, Guangzhou, Guangdong Province Patentee after: Zhi Xiao 2 (Guangzhou) Technology Co.,Ltd. Address before: 214028 No. 8 Xinxi Road, New District, Wuxi City, Jiangsu Province Patentee before: Wuxi Professional College of Science and Technology |