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

Transaction Log Recording Method

A recording method and log technology, applied in special data processing applications, instruments, electrical and digital data processing, etc., can solve problems such as unsatisfactory results, impact on production activities, and failure of databases to work properly, so as to reduce the risk of data loss and reduce the number of users. The effect of expenses

Inactive Publication Date: 2011-12-21
HENAN SPLENDOR SCI & TECH
View PDF2 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] Databases have been widely used in various fields. The general structured query language provides software developers with simple and fast data storage operation methods, making data storage almost completely converted from file databases to relational databases; but in the actual application process of databases In the process, due to various reasons, such as network interruption, problems with the database itself, etc., the database cannot work normally, which has a great impact on our production activities
For this reason, technicians use various methods to make up for this hidden danger, but the results are not ideal enough.

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0014] The technical solutions of the present invention will be described in further detail below through specific implementation methods.

[0015] A method for recording a transaction log, the method comprising the following steps:

[0016] Step 1. The database changes from the connected state to the interrupted state, and the dump operation is performed, that is, the text data stream is obtained after serializing the data in the memory, and the text data stream is recorded in the transaction log. At this time, the storage mode is determined by the database The storage mode is converted to the transaction log storage mode;

[0017] Step 2. The database is in an interrupted state. At this time, the storage mode adopts the transaction log storage mode, and the storage operation only interacts with the transaction log;

[0018] Step 3, the database changes from the interrupted state to the connected state, and the submit operation is performed, that is, the data in the memory i...

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 method for recording a transaction log, which includes the following steps: the database changes from a connected state to an interrupted state, and performs a dump operation, that is, serializes the data in the memory to obtain a text data stream, and converts the text data The stream is recorded on the transaction log. At this time, the storage mode is converted from the database storage mode to the transaction log storage mode; the database is in an interrupted state. At this time, the storage mode adopts the transaction log storage mode, and the storage operation only interacts with the transaction log; the database is controlled by The interrupted state changes to the connected state, and the submit operation is performed, that is, the data in the memory is submitted to the database. At this time, the storage mode is converted from the transaction log storage mode to the database storage mode; the database is in the connected state. At this time, the storage mode adopts In the database storage mode, the storage operation only interacts with the database and deletes the corresponding local transaction log. The method has the advantages of being simple, fast and convenient to use.

Description

technical field [0001] The invention relates to a data storage and recording method, in particular to a transaction log recording method. Background technique [0002] Databases have been widely used in various fields. The general structured query language provides software developers with simple and fast data storage operation methods, making data storage almost completely converted from file databases to relational databases; but in the actual application process of databases In the process, due to various reasons, such as network interruption, problems with the database itself, etc., the database cannot work normally, which has a great impact on our production activities. For this reason, technicians make up for this hidden danger by various methods, but the effect is not ideal enough. Contents of the invention [0003] Aiming at the hidden danger that the database cannot be accessed, the invention provides a simple, fast and convenient transaction log recording method...

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
Inventor 宋新强何培峰刘燕栗海松琚军平黄鹏杰刘大庆
Owner HENAN SPLENDOR SCI & TECH
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