Data structure capable of realizing data back-up and restoration of different types of databases and realization method

A data structure and data backup technology, which is applied in the field of database applications, can solve the problems that databases cannot be backed up and restored, backup content cannot be customized by customers, and cross-database migration cannot be performed, so as to avoid data loss, facilitate storage and retention, and reduce size Effect

Inactive Publication Date: 2011-05-18
INSPUR COMMON SOFTWARE
View PDF3 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The backup and recovery tool of the database itself is the overall backup of the database, and the backup content cannot be customized by customers. More importantly, the backup and recovery between databases of different manufacturers cannot be performed, and cross-database migration cannot be performed.

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
  • Data structure capable of realizing data back-up and restoration of different types of databases and realization method
  • Data structure capable of realizing data back-up and restoration of different types of databases and realization method
  • Data structure capable of realizing data back-up and restoration of different types of databases and realization method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment approach

[0032] as attached figure 1 As shown, the present invention can realize in the implementation method of data backup recovery across different types of databases, the data in the source database stores a group of data storage files according to the table LSTABN of the information of the tables that need to be backed up in the record database; The information recorded in LSTABN that needs to restore the table is parsed from the data storage file and restored to the target database.

Embodiment

[0034] 1. Define the LSTABN table structure, which is used to store user-defined data content that needs to be backed up and restored.

[0035] The specific instructions are as follows:

[0036] System number (F_XTBH): identifies which system the data object belongs to, which is convenient for classified management.

[0037] Data object (F_TABN): the name of the data object that needs to be backed up and restored, for example: personnel table, credential table;

[0038] F_TABN and F_XTBH constitute the unique index of the LSTABN table.

[0039] Table Distinguished Name (F_NAME): Description and description of F_TABN.

[0040] Table sequence number (F_ORDE): the sequence number when the backup is restored.

[0041] Roll-out columns (F_COLS): Define the columns of the tables that need to be backed up and restored, if all the columns are represented by *.

[0042] Number of rows transferred out (F_RANG): The maximum number of rows in the storage file that the table transfers ...

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 data structure capable of realizing data back-up and restoration of different types of databases and a realization method, belonging to the application field of the databases. The data structure comprises the following properties of system number, data object name, data structure, type, chart serial number, turn rows and turn line number and is used for recording data chart information of a database which needs to be copied and restored. Every line of data in the data structure identifies the figure in the data base which needs to be copied. Compared with the prior art, the data structure capable of realizing data back-up and restoration of different types of databases and the realization method have the characteristics of being simple and universal and not being limited by development platforms and the like, are wildly applied to the back-up and restoration work of the database of an enterprise information system and have favorable popularization and application values.

Description

technical field [0001] The invention relates to the field of database application, in particular to a data structure and a realization method capable of realizing data backup and recovery across different types of databases. Background technique [0002] Enterprise management software users need to frequently perform database backup and recovery, and these backups are often selective and need to be customizable. It is also common for users to migrate data across database versions when they need to replace the database. The backup and recovery tools of the database itself are all database backups, and the backup content cannot be customized by customers. More importantly, backup and recovery between databases of different manufacturers cannot be performed, and cross-database migration cannot be performed. Contents of the invention [0003] The technical task of the present invention is to provide a data structure and an implementation method that can realize data backup an...

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): G06F17/30G06F11/14
Inventor 任彦青
Owner INSPUR COMMON SOFTWARE
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