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

High performance relational database service system based on non-volatile storage system

A non-volatile storage and non-volatile technology applied in the information field to achieve high availability and ensure data integrity

Active Publication Date: 2020-11-24
上海孚典智能科技有限公司
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This type of application involves a large amount of data query and cache, management, indexing and query, which poses new challenges to the performance of relational database systems
Especially in the edge computing scenario, it is necessary to consider the balance of power consumption, performance and stability. Simply using high-capacity memory and high-speed SSD hard disk cannot solve the above problems.

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
  • High performance relational database service system based on non-volatile storage system
  • High performance relational database service system based on non-volatile storage system
  • High performance relational database service system based on non-volatile storage system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] The present invention is realized by two parts of hardware and software, and the hardware part is realized by NVRAM equipment, and the current Optane NVRAM system of Intel Corporation can be adopted. The system connects with the x86 server through the PCIe interface, and its hardware device drivers support mainstream Linux and Windows systems. Therefore, it can be easily realized on the current mainstream data platform.

[0038]The software system is based on the mainstream InnoDB storage engine, which is the core storage engine of various widely used relational databases including MySQL DB and Maria DB. Provide memory data management driver for InnoDB data storage engine (NVRAM driver, see attached figure 1 ) to replace its original memory data management module. By introducing the management and operation capabilities of NVRAM as a data buffer layer, the data structure cache of the docking memory is replaced by the file system with NVRAM, which improves I / O efficien...

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 technology for accelerating the performance of a traditional relational database through a nonvolatile storage system. The method aims at the requirements of a relational database system widely applied to various information system software related to cloud computing and the Internet of Things for performance improvement at present. A nonvolatile storage system is introduced, and by accelerating an intermediate cache system of the relational database (through nonvolatile storage), the overall performance of the database is improved under the condition that both the response speed and the data security are considered. The method comprises the following two innovations: 1, an NVRAM (Non-Volatile Random Access Memory) is applied on a database read-write cache; 2, theproblem of high availability of data is solved by maintaining a core data structure of the relational database through NVRAM resources; the invention has good applicability in the aspect of enhancingthe efficiency of cloud computing and Internet of Things edge computing systems.

Description

technical field [0001] The invention belongs to the field of information technology, and in particular relates to a data management system for supporting cloud computing and edge computing, which uses non-volatile storage (NVRAM) technology to improve the I / O performance of a relational database system. Background technique [0002] In recent years, with the rapid development of cloud computing and edge computing technology and the continuous landing of related applications, intelligent data applications based on data analysis and processing have begun to increase rapidly. This type of application involves a large amount of data query and cache, management, indexing and query, which poses new challenges to the performance of relational database systems. Especially in the edge computing scenario, under the need to consider the balance of power consumption, performance and stability, simply using high-capacity memory and high-speed SSD hard disk cannot solve the above-mentione...

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 Patents(China)
IPC IPC(8): G06F16/2455G06F16/28
CPCG06F16/24552G06F16/284
Inventor 赵继胜吴宇
Owner 上海孚典智能科技有限公司