Configuration optimization system and method for Sybase ASE database

A configuration optimization and database technology, applied in the field of database configuration, can solve problems such as high difficulty in database configuration, complex combination of configuration parameters, and heavy workload

Active Publication Date: 2015-12-09
LANGCHAO ELECTRONIC INFORMATION IND CO LTD
View PDF5 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The present invention aims at the problems of numerous SybaseASE database configuration parameters, complex configuration parameter combinations, manual configuration, high database configuration difficulty, heavy workload, and low efficie...

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
  • Configuration optimization system and method for Sybase ASE database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] The present invention will be further described in conjunction with the accompanying drawings.

[0030] The present invention is exemplified with specific implementation methods. For example, the system of the present invention can be implemented based on JAVA to realize cross-platform characteristics. The system of the present invention and SybaseASE are connected through JDBC drivers and communicate through TCP / IP.

[0031] First, a SybaseASE database configuration optimization system is established, including a console module, a configuration library module, a rule library module, a configuration loading execution module, a benchmark test case library module, a test case execution module, and a performance analysis module; the connections of each module are as follows:

[0032] Wherein the first communication port of the console module is connected to the first communication port of the configuration library module, the second communication port of the console module ...

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 configuration optimization system and method for a Sybase ASE database, pertaining to the field of database configuration. The method comprises following steps: expressing expert knowledge configured by the Sybase ASE database through a configuration library, a rule base, a case library for benchmark tests; starting, stopping and dynamically adjusting parameters by configuring a loading and executing module to directly drive the Sybase ASE database; utilizing the case library for benchmark tests to test performance of the case library under specific workload; obtaining a group of configuration parameter combination in accord with the user requirement by continuously adjusting input of the configuration library and the rule base for performance analyses; and eliminating the explosion of number for parameter combinations caused by simple permutation and combination by generating combinations of configuration parameters via guidance of rules in order to greatly decrease workload for configuration of the Sybase ASE database, reduce configuration difficulty and provide guiding effect of optimizing performance of the ASE database.

Description

technical field [0001] The invention discloses a database configuration optimization system and method, belonging to the field of database configuration; specifically, a SybaseASE database configuration optimization system and method. Background technique [0002] SybaseASE, the full name of AdaptiveServerEnterprise, is provided by Sybase, a world-renowned infrastructure provider, and is the flagship database product of Sybase. ASE is the abbreviation of Adaptive Server Enterprise. SybaseASE database is a large-scale relational database based on client / server architecture developed by SAP. It is widely used in the field of online transaction processing and is used in industries such as finance, railways, and courts. SybaseASE provides database capabilities, and also provides self-management, automatic failover support functions, and a large number of performance optimization and adjustment features, which can save a lot of operating costs. Of course, whether it reflects th...

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/25
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