Database table recovery system

A technology for recovering systems and tables, applied in memory systems, data processing applications, electrical digital data processing, etc., can solve problems such as work interruption

Inactive Publication Date: 2003-05-28
COMP ASSOC THINK INC
View PDF0 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] This shortcoming causes total interruption of work while the table area is being restored

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
  • Database table recovery system
  • Database table recovery system
  • Database table recovery system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0013] figure 1 is a diagram of a table area with two dependent tables according to one embodiment of the invention. The table area 10 is divided into four columns: column A, column B, column C and column D. In addition, the table area 10 is divided into five pages: a first page, a second page, a third page, a fourth page and a fifth page. The boundaries of each column run evenly across each row and page. Each page is uniform in size, but can include a different number of rows if necessary, depending on the number of characters in the variable column area on each row. For example, if each page contains 4,096 bytes of data, one page may contain two rows with a total of 4,096 bytes of variable area, while another page may contain four rows with a total of 4,096 bytes of variable area. change area. Thus, the exemplary first page includes four rows, the exemplary second page includes two rows, the exemplary third page includes three rows, the exemplary fourth page includes fou...

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

A system and method for recovering a database table (200) that depends on a tablespace (206) receives a backup copy (202) of the tablespace (206) and reads log records (204) associated with the table (200). The system then applies the log records (204) to the backup copy (202) and builds new table data pages from the backup copy (202). Finally, the system scans (214) the new table data pages for records of the first table and updates the table from the records.

Description

field of invention [0001] The present invention relates generally to database recovery systems, and more particularly to systems and methods for recovering database tables without requiring recovery of the entire database. Background of the invention [0002] Databases, such as IBM's DB2, can use tables subordinate to the table area. The table area contains all the semi-permanent data in the database, and the table contains the user's updates and modifications to that data. Users access data from the table area by creating a subset of that data in the table, and then modify and update the table data. Users periodically update the database to rewrite data in the table areas where there is tabular data. [0003] One problem that occurs when a user updates data in a form is that the updated data may not be correct, for example due to a power outage during the form update, an error during data entry or other common error causes. In this case, since corrupted data must not be ...

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): G06F12/00G06F11/14
CPCG06F11/1471G06F2201/80Y10S707/99948
Inventor 克里斯托弗·F·帕克
Owner COMP ASSOC THINK INC
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