Database server performance evaluation implementation method based on Informix

An implementation method and database technology, applied in the implementation field of server performance evaluation based on Informix database, can solve the problems of inability to host related subsystem performance evaluation, lack of test tools, etc., and achieve the effect of convenient promotion and easy transplantation

Inactive Publication Date: 2014-08-06
LANGCHAO ELECTRONIC INFORMATION IND CO LTD
View PDF4 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] As an important database product, Informix database is widely used in all walks of life. Database application is the core of user application. Informix database SQL statement is complex, and the pros and cons of statement writing have a great impact on system performance. How its performance has always been The majority of users are conce

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
  • Database server performance evaluation implementation method based on Informix

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0021] The method for implementing performance evaluation described in this invention will be described in detail below with an embodiment. The logic design structure of the performance evaluation method described in this embodiment mainly includes: a start-up module, a pressure generation module, a result recording module and a performance monitoring module;

[0022] The following describes the implementation of the four constituent modules:

[0023] 1) Start the module start:

[0024] The start-up module includes a start-up program; according to the start-up program prompts to input database login information and pressure scale, the program first logs into the Informix database, and generates table structure and initial data according to the set pressure scale; meanwhile, the start-up program calls three other module programs : Pressure generating module program, result recording program and performance monitoring program;

[0025] 2) Pressure generation module:

[0026] T...

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 server performance evaluation implementation method based on Informix. The C programming language and the SQL are used for development, the method is compatible with host systems of different structures, and a performance evaluation standard model is provided for an Informix data system; the performance evaluation standard model mainly comprises a starting module, a pressure generating module, a result recording module and a performance monitoring module; the performance evaluation method achieves standardization and routinization of an Informix pressure testing model, meanwhile avoids harmful effects on later performance evaluation of complex SQL statements and programmer levels, is convenient to transplant, and is compatible with the host systems of different structures.

Description

technical field [0001] The invention relates to technologies related to computer fields such as Informix database, SQL development, Linux operating system, C program development, host computer system, etc., and particularly relates to a method for realizing performance evaluation of a server based on Informix database. Background technique [0002] As an important database product, Informix database is widely used in all walks of life. Database application is the core of user application. Informix database SQL statement is complex, and the pros and cons of statement writing have a great impact on system performance. How its performance has always been The majority of users are concerned, but there is a lack of testing tools for the informix database. Most of the testing tools cannot effectively evaluate the performance of host-related subsystems. How to better evaluate hardware performance for business scale and choose a suitable hardware platform has always been a problem. ...

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/30G06F11/28
CPCG06F11/3409
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