Data incremental backup and recovery method applied to data bank

A technology of incremental backup and data warehouse, applied in the field of data warehouse, can solve the problems of slow backup speed, long time consumption, low processing efficiency, etc., and achieve the effect of improving efficiency, improving availability, and small storage space

Active Publication Date: 2007-11-07
INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF0 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Due to the large amount of data in the data warehouse, generally massive data, the processing efficiency of the full backup method is very low, the backup speed is very slow, it takes a long time, and even the normal business processing of the system needs to be stopped to perform data backup and recovery. It has a great impact on production and seriously affects the system's 24-hour service

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 incremental backup and recovery method applied to data bank
  • Data incremental backup and recovery method applied to data bank
  • Data incremental backup and recovery method applied to data bank

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0082] The following example describes that when the balance and account status of a deposit account in the data warehouse are updated, the data warehouse management tool uses the incremental backup and recovery method to simultaneously generate the BEFORE IMAGE and AFTER IMAGE corresponding to this loading update, and then at a certain moment The entire process of restoring the balance of the deposit account to the state before the update was loaded.

[0083] Table 3 shows that there is currently a time-compressed balance fact table in the data warehouse. The business significance represented by the records in the table is the balance of account 1 from 2000-1-1 to 2000-1-10 It is 1,000 yuan, and the balance from 2000-1-11 to now is 2,000 yuan, and the account status is also valid at present.

[0084] account

balance

Account Status

data date

1

3000

efficient

2000-1-21

1

4000

freeze

2000-1-31

[00...

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

This invention discloses a backup and resuming method for data increment used in database, which utilizes an updated before image and after image of data recording based on time compression to back up and resume data increment, in which, it's not necessary for the data backup process to back up loaded result of a database and realize increment backup of the system by backing up the before image and after image.

Description

technical field [0001] The invention relates to the technical field of data warehouses, in particular to a method for incremental backup and recovery of data applied to data warehouses. Background technique [0002] In the field of data warehouse, the commonly used data organization method is to use star schema architecture, with various dimensions on the fact table as the core, supplemented by various information dimensions, to support the data warehouse architecture of dimensional modeling. [0003] Since the main feature of the data warehouse is the large amount of data, the update frequency of data attributes is relatively low, so in general, both the fact table and the dimension table use the time compression method to store data, by adding the effective start date and The two fields of effective end date represent the time validity of the record, so that the same record within a period of time can be compressed into one record. [0004] account balance ...

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 INDUSTRIAL AND COMMERCIAL BANK 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