Logic log generation method, database backup/ restoration method and system

A database and logic technology, applied in the computer field, can solve the problem that the database management system cannot receive operation requests, and achieve the effect of improving backup efficiency, shortening backup time, and improving accuracy and reliability.

Active Publication Date: 2008-02-13
苏州贡湖精密制造产业发展有限公司
View PDF0 Cites 25 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] The embodiment of the present invention provides a logical log generation method, a database backup method, a recovery method, and a database backup system to solve the problem in the prior art that the database management system cannot receive new operation requests during the physical backup process

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
  • Logic log generation method, database backup/ restoration method and system
  • Logic log generation method, database backup/ restoration method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] An embodiment of the present invention provides a method for generating a logical log. When using this method to generate a logical log, first obtain the operation description contained in the operation request for operating the database; then generate a unique identification and operation type containing the operation object according to the operation description Identified logical log. In addition, when the logical log is generated, it may also include the coverage data of the coverage operation performed on the operation object. By adopting the method provided by the embodiment of the present invention, it can be realized that the operation result of the operation object after executing the logic log multiple times has nothing to do with the times of executing the logic log.

[0034] In the process of generating the logical log above, the operation description in the original operation request is converted into an operation description represented by a unique identif...

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 logical log generating method, which comprises: Acquiring the operation description included in the request of database operation; Generating a logical log comprising the only identified tag and the operation type tag of the operation object in accordance with the operation description; Wherein the operation type tag comprises a delete operation type tag or an overwriting operation type tag. Utilizing the logical log generating method, the invention also provides a database backup method and a database recovery method based on the logical log generating method. If the method provided in by the invention is used for physical backup of a database, the database can receive other operation requests, and physical backup data can be completely recovered when the database is recovered.

Description

technical field [0001] The invention relates to the field of computers, in particular to a logical log generation method, a database backup method, a recovery method and a database backup system. Background technique [0002] With the continuous development of computer technology, database backup has become an important means of saving database information, and database management system is a system used to manage a large number of database data. Currently used database backup methods mainly include physical backup and logical log backup. [0003] Physical backup is the process of copying the storage content of the database at a certain point in time to multiple storage devices such as tapes and disks for storage. It is the basic method used in database backup. If physical backup is used alone, the user must be prohibited from accessing the database during the backup process, that is, the database should be closed during the physical backup, otherwise if a user accesses the...

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/34
Inventor 方明唐金根郭育洲
Owner 苏州贡湖精密制造产业发展有限公司
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