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

High-performance relational database service based on nonvolatile storage system

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

Active Publication Date: 2020-01-07
上海孚典智能科技有限公司
View PDF3 Cites 3 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 based on nonvolatile storage system
  • High-performance relational database service based on nonvolatile storage system
  • High-performance relational database service based on nonvolatile 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 (see attached figure 2 ). 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, ...

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 memory (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-mentioned...

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