Containerization-based relational database optimization method and device

An optimization method and database technology, applied in the field of database optimization, can solve problems such as application system performance improvement, achieve the effects of improving I/O efficiency, preventing access speed decline, and solving read-write efficiency and data security issues

Active Publication Date: 2021-01-29
SUZHOU LANGCHAO INTELLIGENT TECH CO LTD
View PDF3 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] With the continuous expansion of the business involved in the database application system, the continuous increase in the number of database users, the gradual increase in the processing business volume, the rapid growth of the database mass storage, the performance problems of the database have become more and more prominent, and the rapid growth of the data volume is the database The main driving force of performance optimization research. Small-scale databases generally do not have performance...

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
  • Containerization-based relational database optimization method and device
  • Containerization-based relational database optimization method and device
  • Containerization-based relational database optimization method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] 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.

[0045] Such as Figure 1~3 As shown, the present invention provides a container-based relational database optimization method and device, including: the monitoring method, including:

[0046] S1. Obtain a database access request, judge based on the database access request, and optimize the database according to the judgment result and through the database cache;

[0047] S2. Perform real-time monitoring of whether the database buffer memory or CPU usage is hi...

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 discloses a containerization-based relational database optimization method and device, and the method comprises the steps: obtaining a database access request, carrying out the judgmentbased on the database access request, and carrying out database optimization through a database buffer according to a judgment result, and monitoring whether the memory or CPU utilization rate of thedatabase buffer is higher than a preset threshold value or not in real time, recording a log and sending a log notification when the memory or CPU utilization rate is higher than the preset thresholdvalue, receiving the log notification and analyzing the log to judge changed data, and performing transverse/longitudinal expansion on the database buffer according to a preset value in configuration.

Description

technical field [0001] The present invention relates to the field of database optimization, and more specifically, the present invention relates to a container-based relational database optimization method and device. Background technique [0002] Database computing originated in the 1960s. From the initial simple file system processing to the current database system that handles a large amount of complex data, the application field has also penetrated into all aspects of life. Today, database technology has become a data storage Indispensable tools for managing, sharing and processing data. [0003] With the continuous expansion of the business involved in the database application system, the continuous increase in the number of database users, the gradual increase in the processing business volume, the rapid growth of the database mass storage, the performance problems of the database have become more and more prominent, and the rapid growth of the data volume is the datab...

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): G06F16/21G06F9/455G06F16/2455G06F16/28
CPCG06F16/217G06F16/284G06F16/285G06F16/24552G06F9/45558
Inventor 刘黎陈天石秦凯新
Owner SUZHOU LANGCHAO INTELLIGENT TECH 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