Unlock instant, AI-driven research and patent intelligence for your innovation.

Database journal recording method, device and system

A database and log technology, applied in the database field, can solve the problems of high price and large capacity of flash memory array

Active Publication Date: 2015-01-07
HUAWEI TECH CO LTD
View PDF6 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Since the database logs of transactions performed by all computing nodes are recorded on the flash array, the required flash array has a large capacity and a high price

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 journal recording method, device and system
  • Database journal recording method, device and system
  • Database journal recording method, device and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0046] figure 2 It is the cluster database system 200 of the first embodiment of the present invention. The cluster database system 200 includes computing nodes 212 , 214 and 216 , a master coordinator 222 , a backup coordinator 224 , an Infiniband (IB) 204 , a fiber channel 206 , and a cache 208 . In one embodiment, the cache 208 is a disk. The disk 208 stores data in the cluster database system 200 . Compute nodes 212 , 214 , and 216 perform transactions, such as computing or reading and writing operations on data stored on disk 208 . The master coordinator node 222 manages the communication among the computing nodes 212 , 214 and 216 . The standby coordinating node 224 replaces the primary coordinating node 222 when the primary coordinating node 222 fails, and completes the functions of the primary coordinating node 222 in a non-failure state. Computing nodes 212 , 214 and 216 , between the primary coordinating node 222 and the standby coordinating node 224 , and betwe...

Embodiment 2

[0048] image 3 is a schematic flowchart of a method for recording database logs according to the second embodiment of the present invention. to combine figure 2 right image 3 to describe.

[0049] In step 302 , the main coordinating node 222 receives the transaction log sent by the computing node in the database system 200 , such as the computing node 212 , and records the transaction log in the primary cache 232 . Primary cache 232 is associated with primary coordinating node 222 . In one embodiment, primary cache 232 is located within primary coordinating node 222 . In another embodiment, the primary cache 232 is located outside the primary coordinating node 222 . A transaction log is a database log that records a corresponding transaction.

[0050] In step 304 , after recording the transaction log in the primary cache 232 , the primary coordinating node 222 sends primary feedback information to the computing node 212 to enable the computing node 212 to execute the ...

Embodiment 3

[0062] Figure 4 is a schematic flowchart of a method for recording database logs according to the third embodiment of the present invention.

[0063] In step 402 , the computing node 212 sends the transaction log corresponding to the transaction to the master coordinating node 222 before executing the transaction, so that the master coordinating node 222 records the transaction log on the primary cache 232 . Primary cache 232 is associated with primary coordinating node 222 . In one embodiment, primary cache 232 is located within primary coordinating node 222 . In another embodiment, the primary cache 232 is located outside the primary coordinating node 222 . In one embodiment, the read and write latency of the main cache 232 is not greater than microsecond (us) level. For example, the primary cache 232 is any one of the following storage media: flash memory (Flash Memory) and phase change memory (Phase Change Memory, PCM). A transaction log is a database log that records...

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 database journal recording method, device and system. The database journal recording method includes that a main coordinating node receives transaction journal sent by a computational node in a database system and records the transaction journal in a main cache, wherein the main cache is associated with the main coordinating node, and the transaction journal is database journal which records the corresponding transaction; after recording the transaction journal in the main cache, the main coordinating node sends main feedback information to the computational node so as to enable the computational node to execute the corresponding transaction, wherein the main feedback information indicates that the main coordinating node finishes recording the transaction journal in the main cache; after recording the transaction journal in the main cache, the main coordinating node writes the transaction journal in a low memory, wherein the main cache is a non-volatile memory device which has the first type of storage speed, the low memory is a non-volatile memory device which has the second type of storage speed, and the first type of storage speed is higher than the second type of storage speed.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method, device and system for recording database logs. Background technique [0002] Before executing a transaction (such as modifying data in the database) in the database system, the database log for executing the transaction will be recorded first, so that when the device in the database system crashes, the database log can be used to restore data. figure 1 Shown is a prior art clustered database system 100 . Cluster database system 100 includes compute nodes 112 , 114 and 116 , coordinator nodes 122 and 124 , mesh channel 106 and flash array 108 . Before the computing node, such as 112 , executes the transaction, the computing node 112 records the corresponding database log in the flash memory array 108 through the mesh channel 106 . Since the database logs of transactions executed by all computing nodes are recorded on the flash memory array, the required flash memory array has ...

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/30
CPCG06F16/1815
Inventor 宋扉叶涛肖宇雷
Owner HUAWEI TECH CO LTD