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
CN110928899AActive Publication Date: 2020-03-27中孚安全技术有限公司 +2
12 Cites 4 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
中孚安全技术有限公司
Publication Date
2020-03-27

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

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