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

Method for restoring data table content deleted mistakenly

A data table and accidental deletion technology, applied in the field of database management, can solve problems such as impossible restoration, time-consuming, scene restrictions, etc., and achieve the effect of saving physical storage space, saving time and manpower

Inactive Publication Date: 2014-03-05
HIGHGO SOFTWARE
View PDF5 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] However, both of the above two methods have the following defects: the master-standby database switching technology has scene limitations, that is, after misoperation, the master-standby database must not have been synchronized; and manual restoration not only consumes a lot of time, but also reduces the efficiency of restoring data , and cannot guarantee the correctness and integrity of the restored data content, especially when a large amount of data is accidentally deleted, the restoration becomes almost impossible

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
  • Method for restoring data table content deleted mistakenly
  • Method for restoring data table content deleted mistakenly
  • Method for restoring data table content deleted mistakenly

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0045] A method for restoring contents of a data table deleted by mistake, comprising the following steps:

[0046] (1) The database file management module obtains the name of the database table through the restore command input by the user or DBA in the database system, such as postgres=#selectoperation_undo("table_name"); query the system category table, and get the corresponding table name according to the obtained database table name The name and path of the table file of the database table; all system tables are automatically maintained by the database system, and the system category table records the table and almost all fields or the contents of similar tables. When performing creation or other operations involving table structure, the system will automatically create, modify, delete, etc.;

[0047] (2) Open the database table file; if the opening is successful, proceed to step (3); if the opening fails, the program returns failure;

[0048] (3) Read a file page in the...

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 method for restoring data table content deleted mistakenly. External storage management of a database is responsible for the interaction process of the database and external storage media. Table file management is the most important part in external storage management of the database, all table files in the database correspond to only one database table, and each table file is stored in a disk in a certain structure. Meanwhile, content of the table files is stored according to certain rules. When a tuple in the database table is deleted, the database will change the corresponding marker bit in the corresponding table file. According to the method, tuple content which is deleted is restored by reading and analyzing the files of the database. The method is applied to the field of computer technologies and databases so as to protect the content of the database table and prevent the situation that due to misoperations of database administers, users and other database operation class programs, the content of the database table is deleted accidentally.

Description

technical field [0001] The invention relates to a method for restoring contents of a data table deleted by mistake, and belongs to the technical field of database management. Background technique [0002] There are two ways to restore data accidentally deleted in existing traditional databases: [0003] 1. If the database uses backup technology, you can switch to the standby database. The premise of doing this is: after the accidental deletion of data, the primary and secondary databases are not synchronized; [0004] 2. By obtaining the operation logs in the background of the database system, according to the occurrence time of misoperations, find the corresponding operation and data logs, and then manually insert them into the database one by one for restoration. [0005] However, both of the above two methods have the following defects: the master-standby database switching technology has scene limitations, that is, after misoperation, the master-standby database must no...

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
IPC IPC(8): G06F17/30
CPCG06F16/21G06F11/1402
Inventor 孙京本卢健
Owner HIGHGO SOFTWARE
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com