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

Method and device for restarting in-memory database

A database and memory technology, applied in the field of communication, can solve the problems of long restart time of memory database, slow disk read and write speed, etc., and achieve the effect of shortening restart time and saving time

Active Publication Date: 2013-07-10
HUAWEI CLOUD COMPUTING TECH CO LTD
View PDF5 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, with the restart method of the prior art, data needs to be read and written from the disk during the restart process, and the read and write speed of the disk is relatively slow, so the restart time of the memory database is relatively long

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 and device for restarting in-memory database
  • Method and device for restarting in-memory database
  • Method and device for restarting in-memory database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0031] The embodiment of the present invention stores the data of the memory database in the shared memory segment, utilizes the fast read and write speed of the shared memory segment and the resident characteristic of the shared memory segment, and shortens the restart time of the memory database.

[0032] figure 1 It is a schematic flow diagram of Embodiment 1 of the method for restarting an in-memory database of the present invention, as shown in figure 1 ...

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

An embodiment of the invention provides a method and a device for restarting an in-memory database. A system starting control file corresponding to the in-memory database to be restarted is obtained, a key value is obtained from the system starting control file, a shared memory segment which stores data of the in-memory database to be restarted is determined according to the key value, the in-memory database to be restarted is restored in the shared memory segment according to table space data and system operation environment data which are stored in the shared memory segment during restarting, the table space data and the system operation environment data are not required to be obtained from a disc, and the time for obtaining of the table space data and the system operation environment data can be saved, so that the restarting time of the in-memory database can be shortened.

Description

technical field [0001] The embodiments of the present invention relate to communication technologies, and in particular to a method and device for restarting an in-memory database. Background technique [0002] In-memory databases can provide microsecond-level real-time response time. Therefore, in-memory databases are increasingly used in fields such as telecommunications and finance to store business data to be accessed in real time. [0003] When the memory database is restarted, the first step is to close the database service, stop all running transactions, copy the redo log data from the memory to the disk, and exit the database service; the second step is to start the database service, and the disk needs to be Load the tablespace data stored in the memory into the memory, and read the redo log data from the disk to complete the recovery of the memory database and provide external memory database access services. [0004] However, with the restart method in the prior a...

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
Inventor 彭勇飞姚理
Owner HUAWEI CLOUD COMPUTING TECH CO LTD
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