General database backup method and system

A technology for backing up systems and databases, applied in the field of databases, which can solve the problems of database backup depending on the installation environment and low security, and achieve the effects of saving disk space, ensuring security, and high compression ratio

Active Publication Date: 2020-03-27
中孚安全技术有限公司 +2
View PDF12 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of the present invention is to provide a general database backup method and system, aiming to solve the problem of database backup relying on the installation environment and low security in the prior art, to realize not relying on the database installation environment, to improve code compatibility, and to ensure the security of backup data. safety

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
  • General database backup method and system
  • General database backup method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] In order to clearly illustrate the technical features of the present solution, the present invention will be described in detail below through specific implementation methods and in conjunction with the accompanying drawings. The following disclosure provides many different embodiments or examples for implementing different structures of the present invention. To simplify the disclosure of the present invention, components and arrangements of specific examples are described below. Furthermore, the present invention may repeat reference numerals and / or letters in different instances. This repetition is for the purpose of simplicity and clarity and does not in itself indicate a relationship between the various embodiments and / or arrangements discussed. It should be noted that components illustrated in the figures are not necessarily drawn to scale. Descriptions of well-known components and processing techniques and processes are omitted herein to avoid unnecessarily lim...

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 provides a general database backup method and system. According to the method, the corresponding system tables are inquired according to the database types, the table names needing to bebacked up are read, all the field types and the field values are read according to the table names and spliced into the corresponding statements, the statements are combined, optimized, compressed into character strings and encrypted, and data backup of different database types is achieved. The method does not depend on a database installation environment, does not depend on specific database types and versions, is high in code compatibility, can encrypt database backup file contents and ensure the security of backup data, and in addition, the file contents are compressed by adopting a GZIP compression technology, so that the compression ratio is relatively high, and the disk space of a server can be greatly saved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a general database backup method and system. Background technique [0002] In order to ensure the reliability of the application system and prevent data loss due to database corruption, it is necessary to regularly back up the data of the application system. [0003] Common database backup operations need to rely on the installation environment of the database, and use the backup command of the database itself to operate. The corresponding application service and database service are deployed on different servers. The compatibility is not good enough, and the backup file is not compressed and encrypted, and the security is not good enough. , and not easy to store. [0004] Therefore, there is an urgent need for a general database backup method to improve the compatibility of different servers. Contents of the invention [0005] The purpose of the present invention is to pro...

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 Applications(China)
IPC IPC(8): G06F16/242G06F16/2455G06F11/14G06F21/60
CPCG06F16/2433G06F16/2455G06F11/1448G06F21/602Y02D10/00
Inventor 苗功勋张庆亮姚丛颖袁浩崔新安
Owner 中孚安全技术有限公司
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