Method for optimizing performance of disk database by memory database technology

A database and memory technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as slow application access, performance degradation, database IO bottlenecks, etc., to prevent single point failures, improve performance, and avoid The effect of IO bottleneck

Inactive Publication Date: 2013-02-27
LANGCHAO ELECTRONIC INFORMATION IND CO LTD
View PDF3 Cites 19 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When the data stored in the disk database reaches a certain level, the database will have an IO bottleneck, the performance will be severely degraded, and the application's access will also wait slowly.

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 for optimizing performance of disk database by memory database technology

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] The method of the present invention is described in detail below with reference to the accompanying drawings.

[0017] Install and deploy in-memory databases and middleware applications on servers configured with large memory, then cache hotspot data (including read-only data and readable and writable data) stored in disk databases into memory, and configure corresponding data synchronization methods . At this time, if most of the data that the application needs to access the request is cached in the memory, then it only needs to operate in the memory, which eliminates the IO bottleneck caused by the disk operation, and at the same time, the changed data in the memory will be automatically synchronized To the disk database to ensure data reliability.

[0018] Step 1: Deploy in-memory database and middleware applications on servers with large memory;

[0019] Step 2: Configure the disk database, create a management user, and grant corresponding permissions;

[0020]...

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 method for optimizing the performance of a disk database by the memory database technology. Memory database and middleware applications are installed and allocated on a server with a large memory configuration, hotspot data stored in the disk database, including read-only data and readable and writable data, are cached in a memory unit, and a corresponding data synchronization mode is configured to automatically synchronizing the varying data in the memory unit to the disk database, therefore, the reliability of data is ensured. By the memory database technology, the hotspot data stored on the disk are ached in the memory unit and meanwhile the application is modified to configure the original data request to the memory unit instead of the disk, although the operation of the disk is changed into the operation of the memory unit. Therefore, the I/O bottle neck in the conventional disk database system is eliminated and the performance of the system is greatly improved.

Description

technical field [0001] The present invention relates to computer database management technology, specifically a method for optimizing disk database performance using memory database technology. Background technique [0002] The database is an important part of a large-scale application system. With the enrichment of application system functions and the passage of time, the data in the database will increase to varying degrees. Traditional databases are disk-based databases, such as oracle, db2 , SQL Server, etc. When the data stored in the disk database reaches a certain level, the IO bottleneck will appear in the database, the performance will be seriously degraded, and the application access will also wait slowly. [0003] Faced with this situation, in-memory databases and applications can be deployed on large-memory servers, and then use in-memory database technology to cache hotspot data stored in disks into memory, so as to eliminate disk IO bottlenecks and improve sys...

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 LANGCHAO ELECTRONIC INFORMATION IND CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap