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

Method and System for Optimizing Database Parameters

A database and parameter technology, applied in the database field, can solve the problems of not achieving the effect of tuning, time-consuming, etc., and achieve the effect of automatic database optimization

Active Publication Date: 2017-07-07
CHINA TELECOM CORP LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the method of manually implementing database tuning, the tuning result is related to the professional quality of the database engineer, the tuning process often takes a long time, and even the tuning effect cannot be achieved

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 and System for Optimizing Database Parameters
  • Method and System for Optimizing Database Parameters
  • Method and System for Optimizing Database Parameters

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] 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. It should be noted that the relative arrangement of components and steps set forth in these embodiments does not limit the scope of the invention unless specifically stated otherwise.

[0051] The following description of at least one exemplary embodiment is merely illustrative in nature and in no way taken as limiting the invention, its application or uses. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0052] Techniques, methods, and devices known to those of ordinary skill in the relevant art may not be disc...

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 database parameter optimization method and system. The method includes: selecting a plurality of sample values ​​of database performance parameters, performing a typical application pressurization operation on the database, and obtaining server performance index parameter values ​​as teacher values ​​corresponding to the sample values; The teacher value is fuzzified to form multiple input samples; the fuzzy neural network is constructed, and multiple input samples are used to train the fuzzy neural network; according to the tuning model corresponding to the trained fuzzy neural network, the server performance of the database with predetermined values ​​is selected The index parameter value is used as the input of the tuning model, and the database performance parameter value as the optimization result is calculated to adjust the database performance parameter of the database. The technical scheme provided by the invention realizes the automatic optimization of the database, and avoids the cumbersome operation steps caused by relying on the experience value of engineers and manual optimization in the prior art.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method and system for optimizing database parameters. Background technique [0002] With the development of database technology, especially the development of relational database technology, relational databases have been used in domestic government departments, telecommunications, postal services, public security, finance, insurance, energy and electricity, transportation, science and education, petrochemical, aerospace, etc. , civil aviation and other industries. As the business volume of enterprises increases, the load carried by enterprise IT systems becomes heavier and heavier. Since the database system is one of the key systems of the enterprise IT system, the performance of the database system affects the quality of the external services provided by the enterprise. In order to obtain good database system performance, one of the effective methods is to perform database tuning, ...

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): G06F17/30G06N3/02
CPCG06F16/217G06N3/043
Inventor 朱源何忠江邓丽华薛尽飞王丹
Owner CHINA TELECOM CORP LTD