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: 2014-06-11
CHINA TELECOM CORP LTD
View PDF5 Cites 24 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 method and a system for optimizing database parameters. The method comprises the following steps: selecting a plurality of sample values of database performance parameters, and carrying out typical application pressurization operation on a database to obtain server performance index parameter values as teacher values corresponding to the sample values; carrying out fuzzification processing operation on each sample value and the corresponding teacher value through a fuzzy subordinating degree function so as to form a plurality of input samples; constructing a fuzzy neural network, and using the input samples to train the fuzzy neural network; selecting the server performance index parameter values with a preset numeric value of the database as the input of an adjusting and optimizing model according to the adjusting and optimizing model corresponding to the trained fuzzy neural network, and computing the database performance parameter values as optimization results so as to adjust the database performance parameters of the database. Through the technical scheme provided by the invention, automatic optimization of the database is realized, and complicated operation steps caused by empirical value depending on an engineer and manual adjusting and optimizing implementation in the prior art are prevented.

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