Data incremental backup and recovery method applied to data bank

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

Active Publication Date: 2009-02-25
INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF4 Cites 2 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

[0079] The following example describes that when the balance of a deposit account in the data warehouse and the account status 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 load update, and then at a certain time The entire process of restoring the balance of the deposit account to the state before loading the update.

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

[0081] After a period of time, due to the update of the account information in the enterprise online transaction processing system, the data warehouse system will incr...

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 warehousing, the commonly used data organization method is to use the 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] Because the main feature of data warehouse is the large amount of data and the relatively infrequent update of data attributes, the fact table and dimension table generally use time compression to store data, by adding the effective start date and Two fields of effective end date to indicate the time validity of the record, so that the same record within a period of time can be compressed into one record. [0004] As shown in Table 1 and Table 2, Table 1 shows the data w...

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 Patents(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