Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data backup method and device based on data models

A data backup and data model technology, applied in the database field, can solve problems such as inaccurate and incomplete data to be backed up, and achieve the effects of improving correctness and integrity, ensuring integrity, and ensuring accurate analysis

Active Publication Date: 2014-03-26
ADVANCED NEW TECH CO LTD
View PDF4 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The technical problem to be solved in this application is to provide a data backup method based on a data model to solve the problem of inaccurate and incomplete data to be backed up in the data backup process of 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
  • Data backup method and device based on data models
  • Data backup method and device based on data models
  • Data backup method and device based on data models

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0130] Corresponding to the method provided in Embodiment 1 of a data model-based data backup method of the present application, see Figure 5 , the present application also provides a data model-based data backup device embodiment 1, in this embodiment, the device may include:

[0131] The creating module 501 is configured to create a data model identifier and a corresponding current data model according to the data to be backed up in the current database.

[0132] refer to Figure 6 As shown, the creating module 501 may specifically include:

[0133] Receiving sub-module 601, configured to receive keywords of data to be backed up input by the user;

[0134] A search submodule 602, configured to search for all associated data tables associated with the keyword in the current database;

[0135] The first judging submodule 603 is used to judge whether there is an external reference in the associated data table;

[0136] The first import submodule 604 is used to import the a...

Embodiment 2

[0152] Corresponding to the method provided in Embodiment 2 of a data model-based data backup method of the present application, see Figure 8 , the present application also provides a data model-based data backup device embodiment 2, in this embodiment, the device may include:

[0153] The format conversion module 801 is configured to convert the format of the data in the data backup file according to different business scenarios of the current application.

[0154] The import module 802 is configured to import the data backup file into the target database according to the data format of the target database.

[0155] The import module 802 can be specifically configured to: import the data backup file into the target database according to the data format of the target database in the same transaction.

[0156] This embodiment can not only ensure the correctness and integrity of data backup, but also avoid the occurrence of dirty data when importing data backup files later, en...

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 data backup method and device based on data models. The method comprises establishing data model identities and corresponding current data models according to current data to be backed up in a database; receiving the identities of the current data; analyzing the corresponding current data models according to the current data models to obtain current structured query language (SQL) of the current data models; triggering the current SQL to be executed in the current database; taking the executing result of the current SQL as the data backup files corresponding to the data to be backed up. The data backup method and device based on the data models can solve the problems of inaccuracy and incompletion of data to be backed up during the data backup process in the prior art and guarantee the accuracy and completion of data.

Description

technical field [0001] The present application relates to the database field, in particular to a data model-based data backup method and device. Background technique [0002] Database (Database) is a warehouse that organizes, stores and manages data according to the data structure. There are many types of databases, from the simplest tables that store various data to large database systems that can store massive data. Has been widely used. With the development of the database business and the improvement of the complexity of the system using the database, the backup of the database is becoming more and more common. In a complex system, for the maintainability and efficiency of the system, data belonging to an entity (such as user information, user orders, user bills, user personalized configuration, etc.) are often stored in different tables of the database. The data corresponding to independent entities in these tables is called the data model. [0003] In the current pr...

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
CPCG06F11/1448G06F16/212
Inventor 骆桢轩
Owner ADVANCED NEW TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products