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

Data page access method, storage engine and computer readable storage medium

An access method and data page technology, applied in the field of communication, to achieve the effect of increasing concurrency and improving performance

Active Publication Date: 2018-11-06
ZTE CORP
View PDF4 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, the purpose of the embodiments of the present invention is to provide a data page access method, an NVM-based database storage engine, and a computer-readable storage medium to solve how to use NVM hardware non-volatile, byte-addressable, large-scale New features such as capacity and low latency, the problem of designing a high-performance database storage engine

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
  • Data page access method, storage engine and computer readable storage medium
  • Data page access method, storage engine and computer readable storage medium
  • Data page access method, storage engine and computer readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0020] Such as figure 1 As shown, the first embodiment of the present invention provides a data page access method, the method comprising:

[0021] Step S11: storing the mirrored data pages of the buffer pool on the NVM.

[0022] In this embodiment, the database storage engine is reconstructed to adopt a hierarchical storage structure, and each level uses a different storage medium.

[0023] Please refer to figure 2 As shown, the L0 layer uses NVM, and the L1 layer can use HDD or SSD (Solid State Drives, solid state drive); the L0 layer and the buffer pool (Buffer Pool) both include k data pages, namely Page1-Pagek; the L1 layer includes n Data pages, that is, Page1-Page n, where n>k. Store the mirrored data pages of the buffer pool on NVM, remove the redo log buffer (Redo Log Buffer) in the existing relational database, and increase concurrency.

[0024] When the database is started for the first time, the NVM of the L0 layer is formatted according to the size of 16Kb, c...

no. 2 example

[0052] Such as Figure 5 As shown, the second embodiment of the present invention provides a database storage engine based on NVM, and the storage engine includes: a memory 21, a processor 22, and a database stored on the memory 21 and operable on the processor 22. A data page access program, when the data page access program is executed by the processor 22, it is used to implement the steps of the data page access method described below:

[0053] Storing mirrored data pages of the buffer pool on the non-volatile memory NVM;

[0054] According to the write access of the data page, the data page in the buffer pool is modified, and the page number, undo log information and modification log information of the data page are stored in a preset dynamic array.

[0055] When the data page access program is executed by the processor 22, it is also used to implement the following steps of the data page access method:

[0056] According to the read-only access of the data page, determi...

no. 3 example

[0077] The third embodiment of the present invention provides a computer-readable storage medium, where a data page access program is stored on the computer-readable storage medium, and when the data page access program is executed by a processor, it is used to implement the method described in the first embodiment. The steps of the data page access method.

[0078] It should be noted that the computer-readable storage medium in this embodiment belongs to the same idea as the method in the first embodiment, and its specific implementation process is detailed in the method embodiment, and the technical features in the method embodiment are all described in this embodiment. Correspondingly applicable, no more details here.

[0079] The computer-readable storage medium in the embodiment of the present invention removes the redo log buffer in the existing relational database by storing the mirrored data pages of the buffer pool on the NVM, and the redo log recording process is als...

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 present invention discloses a data page access method, an NVM-based database storage engine, and a computer readable storage medium. The method comprises the following steps: storing a mirrored data page of a buffer pool on a nonvolatile memory NVM; modifying the data page in the buffer pool according to the write access of the data page, and storing the page number, undo log information, andmodified log information of the data page in a preset dynamic array. According to the data page access method, the NVM-based database storage engine, and the computer readable storage medium in the invention, the redo log buffer in the existing relational database is removed by storing the mirrored data page of the buffer pool on the NVM, and the redo log recording process is removed in the data page modification process, thereby increasing the concurrency and improving the performance of the database storage engine.

Description

technical field [0001] The present invention relates to the field of communication technology, in particular to a data page access method, an NVM-based database storage engine, and a computer-readable storage medium. Background technique [0002] The traditional relational database system is disk-oriented, and its main architecture is based on a two-layer storage hierarchy built on HDD (Hard Disk Drive) and DRAM (Dynamic Random Access Memory). Therefore, the I / O (Input / Output, input / output) between the slow HDD and the high-speed DRAM becomes the main performance bottleneck in the whole system. With the emergence of 3D XPoint technology, the industrialization of new non-volatile storage hardware featuring non-volatility, large capacity, low latency, high concurrent access capabilities, and byte addressing has become a reality. The new storage environment integrated into NVM (NonVolatile memory, non-volatile memory) is expected to bridge the performance gap between CPU (Cent...

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
CPCG06F16/2455G06F16/28G06F16/21G06F16/22
Inventor 闫宗帅屠要峰黄震江高洪杨洪章王涵毅陈河堆韩银俊郭斌
Owner ZTE CORP
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