A Method for Restoring Heterogeneous Database Backup Files

A technology for backing up files and restoring methods, which is applied in electrical digital data processing, redundant data error detection in operations, instruments, etc. Utilization, the effect of reducing backup costs

Active Publication Date: 2019-12-10
STATE GRID CORP OF CHINA +3
View PDF9 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] The purpose of the present invention is to overcome the deficiencies in the prior art, provide a method for restoring backup files of heterogeneous databases, and solve the technical problem that heterogeneous data cannot be effectively backed up and restored in the prior art

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A Method for Restoring Heterogeneous Database Backup Files
  • A Method for Restoring Heterogeneous Database Backup Files
  • A Method for Restoring Heterogeneous Database Backup Files

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0069] The invention provides a backup file recovery method of a heterogeneous database, including: designing a metadata model, normalizing and transforming data in a heterogeneous source database, and storing the metadata model through an XML file; proposing a DELTA based on K-medoids clustering The compression algorithm first performs clustering preprocessing on the data blocks, and divides the data blocks with high similarity into one category. Use the DELTA compression algorithm to compress the same type of data blocks; restore the data based on the "SQL reproduction method", read the database version of the restoration end according to the configuration file, and convert the metadata model into the SQL statement supported by the corresponding version of the database according to the conversion rules. Import the database after data consistency detection to realize the stable backup and recovery functions of heterogeneous databases.

[0070] The present invention will be fu...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a backup file recovery method for a heterogeneous database. The method includes the following steps that normalized transformation is conducted on data in the heterogeneous database, a DELTA compression algorithm of K-Medoids clustering is adopted for clustering preprocessing of data blocks, and the data blocks high in similarity are divided into a class; the DELTA compression algorithm is used for compression of the data blocks of the same class, data recovery is conducted based on 'SQL reappearance method', a recovery-end database version is read according to the configuration file, according to the transformation rule, a metadata model is transformed into SQL statements which a database with the corresponding version supports, after data consistency detection, the SQL statements are introduced into the database, and the stable backup and recovery functions of the heterogeneous database are achieved. Through extension of a mapping rule, multiple source databases can be supported, backup of the heterogeneous database is achieved, efficient file compression is supported, and the cost of backup is reduced.

Description

technical field [0001] The invention relates to a method for restoring backup files of heterogeneous databases, and belongs to the technical field. Background technique [0002] In recent years, with the development of information technology, information management system has been greatly popularized. With their fast, efficient, and convenient features, they have become a platform for information release and information trading, and further promote the digitization and informatization process of the entire society. Various information systems have built today's "information world". [0003] The development of all walks of life is inseparable from "data": product data, customer data, financial data, etc. The survival and development of enterprises are increasingly dependent on IT systems. Due to computer viruses, network intrusion, physical damage, manual operation errors and other reasons, large-scale destruction of information data will not only make the information system...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F11/14
CPCG06F11/1469
Inventor 刘赛杨华飞聂庆节刘嘉华刘军张磊马悦皎缪骞云张翼张迎星
Owner STATE GRID CORP OF CHINA
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap