Method and system for automatically optimizing configuration of database

Active Publication Date: 2018-11-23
INSPUR BEIJING ELECTRONICS INFORMATION IND
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In particular, the DB2 database has many configuration parameters, the number reaches more than a few hundred, the dependencies between configuration parameters are not clear, and there are many configuration

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 automatically optimizing configuration of database
  • Method and system for automatically optimizing configuration of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0048] The core of the present invention is to provide a method for automatically optimizing the configuration of the database, which is applied to the DB2 database. The method can greatly reduce the database configuration workload and reduce the difficulty of configuration.

[0049] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. 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.

[0050] Among them, the DB2 database is a large-scale relational da...

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 present invention discloses an automatic optimization configuration method and system of a database, applied to a DB2 database. The method comprises: establishing a configuration base, a rule base, and a benchmark test case base according to a rule of the DB2 database; obtaining a configuration parameter of the configuration base according to a category in the configuration base; selecting a running benchmark test case from the benchmark test case base; setting a parameter value according to the rule base, and forming a configuration parameter combination according to a permutation and combination strategy; modifying a DB2 database startup configuration file according to each configuration parameter combination, and running the benchmark testing case, to obtain a test result of each configuration parameter combination, and performing analysis by using the test result of each configuration parameter combination according to work load corresponding to each configuration parameter combination, to obtain an analysis result; and obtaining an optimized configuration parameter combination of the DB2 database according to the analysis result. According to the automatic optimization configuration method, the configuration difficulty can be reduced.

Description

technical field [0001] The invention relates to the field of information processing, in particular to a method and system for automatically optimizing configuration of a database. Background technique [0002] The database performance gap before and after database configuration optimization may reach 10 times, or even 100 times. Moreover, whether the database configuration reflects the characteristics of the business system and whether it is optimally matched with the business load will directly affect the performance of the database. Therefore, database optimization configuration is a difficult problem. In particular, DB2 database has many configuration parameters, the number reaches more than several hundred, the dependencies between configuration parameters are not clear, and there are many configuration parameter combinations. Finding the best parameter combination suitable for business load is a difficult problem. If manual configuration is adopted, the database confi...

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): G06F17/30
CPCG06F16/21G06F16/284
Inventor 杨治康玉琢陈昌浩
Owner INSPUR BEIJING ELECTRONICS INFORMATION IND
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