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

Restoring method and system of MDB file data

A file data and recovery method technology, applied in the field of MDB file data recovery methods and systems, can solve the problems of irrecoverable, no physical deletion and logical deletion of the ACCESS database, and unrecoverable tables, and achieves high accuracy.

Active Publication Date: 2016-06-08
XIAMEN MEIYA PICO INFORMATION
View PDF3 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Microsoft does not and will not provide a binary organization method in MDB format. The existing research data at home and abroad also say that records and tables deleted by mistake in MDB cannot be recovered, because the ACCESS database itself does not have physical deletion and logical deletion. Conceptual, once deleted it cannot be 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
  • Restoring method and system of MDB file data
  • Restoring method and system of MDB file data
  • Restoring method and system of MDB file data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0103] Please refer to Figure 1-Figure 3 ,as well as Figure 9 , the present embodiment provides a recovery method of MDB file data, comprising:

[0104] S1: Determine whether the MDB file is in the Jet format by judging the header signature of the MDB file; obtain the MDB file in the Jet format, so only the MDB file in the Jet format will store the initialization data including the relevant pages of the table, which belongs to the real database file, rather than other files posing as a database file by modifying the file name; preferably, it can also be judged in conjunction with the version information of the MDB file to improve the accuracy of judgment;

[0105] S2: determine the table where the data to be recovered is located before deletion;

[0106] S3: Analyze the system table MSysObjects of the MDB file, and obtain the offset address of the table definition page of the table; because MSysObjects is a system table, its location and column / field definitions are known,...

Embodiment 2

[0130] Please refer to Figure 5 , this embodiment is a further extension of Embodiment 1, and the similarities will not be described again. The difference is that a table may correspond to more than one data page; when the method of obtaining the data page corresponding to the table based on the index page, Just need to consider to analyze data page according to offset address in step S72, in the process of obtaining deleted MDB file data, may encounter the problem that needs to analyze overflow data; In this case, just need to go to other data page Query to obtain the data information of deleted records; the specific instructions are as follows:

[0131] It should be noted that the offset identification bit here is the signature identification bit;

[0132] Since the length of two bytes at the signature identification bit 0xC in the data page stores the number of records in the page, after that is the offset address of each 2-byte record. Because the length of the page is ...

Embodiment 3

[0142] see Figure 6 , on the basis of Embodiment 1, this embodiment provides a recovery system for MDB file data, including:

[0143] The first obtaining module 1 is used to obtain the MDB file in Jet format;

[0144] Determination module 2, used to determine the table where the deleted data was located before deletion;

[0145] Parsing module 3, for parsing the system table of the MDB file;

[0146] The second obtaining module 4 is used to obtain the form definition page of the form;

[0147] The third obtaining module 5 is used to obtain all data pages of the form;

[0148] The fourth obtaining module 6 is used to obtain the deletion record of the deleted data according to the signature identification bit of the offset address recorded in the data page;

[0149] The fifth obtaining module 7 is configured to obtain deleted data corresponding to the deleted record according to the offset address of the deleted record and the column definition information.

[0150] Prefer...

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 restoring method and system of MDB file data. The method comprises the steps that an MDB file in a Jet format is obtained; a table where deleted data is located before being deleted is determined; a system table of an MDB file is analyzed, and a table definition page of the table is obtained; the table definition page is analyzed, and column definition information of the table is obtained; a data page of the table is obtained; a deletion record of the deleted data is obtained according to the signature identification position of an offset address recorded in the data page; the deleted data corresponding to the deletion record is obtained according to the offset address of the deletion record and the column definition information. According to the restoring method and system of the MDB file data, the problem that existing MDB file data cannot be restored after being deleted is solved, and the data is restored by means of structural information of an MDB itself; the advantages of being high in accuracy and rapid in data restoration are achieved, data is priceless, an effective method is provided for restoring the data deleted by mistake, and leeway is left for error operation; meanwhile, the integrity of restored data can be guaranteed, and the data loss does not exist.

Description

technical field [0001] The invention relates to the field of database file data analysis and processing, in particular to a recovery method and system for MDB file data. Background technique [0002] The MicrosoftJET database developed by MicrosoftOfficeAccess software provides an MDB database file format. The ACCESS database itself does not provide the function of deleting records and restoring deleted tables, because it is a real-time added and reorganized database, and there is no way to buffer all deleted records. [0003] Microsoft does not and will not provide a binary organization method in MDB format. The existing research data at home and abroad also say that records and tables deleted by mistake in MDB cannot be recovered, because the ACCESS database itself does not have physical deletion and logical deletion. Conceptually, once deleted, it cannot be restored. That is to say, for the deleted data, if the backup data is not considered, the only way to restore it i...

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): G06F11/14G06F17/30
CPCG06F11/1448G06F16/21G06F2201/80
Inventor 张宇卉沈长达吴少华滕达
Owner XIAMEN MEIYA PICO INFORMATION
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