CN103970876A - Database server performance evaluation implementation method based on Informix - Google Patents
Database server performance evaluation implementation method based on Informix Download PDFInfo
- Publication number
- CN103970876A CN103970876A CN201410205277.8A CN201410205277A CN103970876A CN 103970876 A CN103970876 A CN 103970876A CN 201410205277 A CN201410205277 A CN 201410205277A CN 103970876 A CN103970876 A CN 103970876A
- Authority
- CN
- China
- Prior art keywords
- module
- performance
- program
- informix
- database server
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3409—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment
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
The present invention relates to the technology in the correlation computer fields such as informix database, SQL exploitation, (SuSE) Linux OS, c program exploitation, host computer system, relate in particular to a kind of based on informix database server performance assessment implementation method.
Background technology
Informix database is as a kind of significant data storehouse product, have widely and use in all trades and professions, database application is as the core of user's application, informix database SQL statement complexity, the quality that statement is write is larger on the impact of system performance, how its performance is always by users are paid close attention to, but testing tool scarcity to informix database, testing tool all can not effectively be assessed main frame correlation subsystem performance mostly, how better to carry out hardware performance assessment for business scale, select suitable hardware platform, the numerous database users' of puzzlement subject matter always.For this present situation, this method aims to provide one and is convenient to operation, and is easy to use, and conveniently test result is carried out to analysis and evaluation, standardized Informix test model.
Summary of the invention
The weak point existing for prior art, the invention provides a kind of based on informix database server performance assessment implementation method.
The invention provides a kind of based on informix database server performance assessment implementation method, its technical scheme that solve the technical problem employing is as follows: this Performance Evaluation implementation method adopts C language and SQL exploitation, host computer system that can compatible different frameworks, has proposed a performance evaluating standard model for informix Database Systems; This Performance Evaluation standardized model mainly comprises: start module, pressing creation module, outcome record module and performance monitoring module; Wherein,
Described startup module, according to pre-entering information, connection data storehouse, and the pressing creation program of Automatically invoked to infomix database automatically, logging program running log simultaneously, with the problem that helps to occur in user's routine analyzer operational process;
Described pressing creation module, facilitates user according to equipment situation, set pressure scale voluntarily, and automatically produce pressure according to user's setting scale, informix database is carried out to intensive access;
Described outcome record module, in the time that pressing creation module starts, starts outcome record module automatically, records at any time pressure program operation result and state, with the use of person's post analysis easy to use;
Described performance monitoring module, in the time that pressing creation module starts, startability monitoring module automatically, initiatively record the running status of equipment under test main molecules system, comprise cpu, internal memory, disk I/O and network, and be recorded in daily record, with the use of person's post analysis easy to use.
This Performance Evaluation implementation method can be widely used in current main-stream main frame, carries out performance evaluating for informix Database Systems; And this method more easily find application system rely operation bottom hardware environment exist performance issue, to help user better equipment performance to be carried out to Efficient Evaluation.
Beneficial effect based on informix database server performance assessment implementation method disclosed by the invention is:
This performance estimating method adopts C language and SQL exploitation, and convenient transplanting, and host computer system that can compatible different frameworks, can be widely used in current main-stream main frame, carries out performance evaluating for informix Database Systems.Realize standardization, the sequencing of informix Load Test Model, abandon the harmful effect that complicated SQL statement and programmer's level quality were brought Performance Evaluation for the later stage simultaneously, fill up the domestic blank for informix database pressure test tool and method, and become a kind of standardized model that can conveniently promote.
Brief description of the drawings
Accompanying drawing 1 is the test overall framework figure of this assessment implementation method.
Embodiment
Below by embodiment and accompanying drawing, be described in further details based on informix database server performance assessment implementation method of the present invention, do not cause limitation of the present invention.
Mentality of designing based on informix database server performance assessment implementation method of the present invention is: by simulating a kind of online trading system, generate initialization data and list structure, and according to test pressure requirement, generate test data and the pressure of corresponding scale, database is carried out to intensive access, and statistical test result, the performance performance according to test result assessment apparatus under specified pressure.This performance estimating method takes into full account that the quality that informix database SQL statement complexity, statement write is larger on the impact of system performance, and adopt C language and SQL to develop, convenient transplanting, and host computer system that can compatible different frameworks, can be widely used in current main-stream main frame, carry out performance evaluating for informix Database Systems; And this method more easily find application system rely operation bottom hardware environment exist performance issue, to help user better equipment performance to be carried out to Efficient Evaluation.
The logic design structure of this Performance Evaluation implementation method mainly comprises: start module, pressing creation module, outcome record module and performance monitoring module; Wherein,
Described startup module, according to pre-entering information, connection data storehouse, and the pressing creation program of Automatically invoked to infomix database automatically, logging program running log simultaneously, with the problem that helps to occur in user's routine analyzer operational process;
Described pressing creation module, facilitates user according to equipment situation, set pressure scale voluntarily, and automatically produce pressure according to user's setting scale, informix database is carried out to intensive access;
Described outcome record module, in the time that pressing creation module starts, starts outcome record module automatically, records at any time pressure program operation result and state, with the use of person's post analysis easy to use;
Described performance monitoring module, in the time that pressing creation module starts, startability monitoring module automatically, initiatively record the running status of equipment under test main molecules system, comprise cpu, internal memory, disk I/O and network, and be recorded in daily record, with the use of person's post analysis easy to use.
Embodiment:
Describe the bright described Performance Evaluation implementation method of we in detail with an embodiment below, the logic design structure of performance estimating method mainly comprises described in this embodiment: start module, pressing creation module, outcome record module and performance monitoring module;
Respectively the embodiment of four composition modules is described below:
1) starting module starts:
Start module and comprise start-up routine; According to described start-up routine prompting input database logon information and pressure scale, this program initial landing informix database, and generate list structure and primary data according to set pressure scale; Meanwhile, start-up routine calls other three modular programs: pressing creation modular program, outcome record program and performance monitoring program;
2) pressing creation module:
Pressing creation module comprises pressing creation modular program; After pressing creation modular program is started by start-up routine, according to pressure scale primary data, generate the database access request of corresponding scale, simulate dissimilar access module simultaneously database server is carried out to intensive access, informix database server is produced to larger access pressure, the ability of testing informix database server and bear pressure with this;
3) outcome record module:
Outcome record module comprises outcome record program; The startup under the calling of start-up routine of outcome record program, the database access request disposition that monitor force generation module generates, and record the result of every transaction, according to the predefined weight of program, provide test result score, and provide the DCO result of every transaction, to facilitate the use of post analysis;
4) performance monitoring module:
Performance monitoring module comprises performance monitoring program; Performance monitoring program is called by start-up routine, and is activated, and monitors constantly the performance data of measured data storehouse server, exports respectively the real-time performance data of tested server in the mode of daily record and figure, analyzes and adjust the use of pressure scale with person easy to use.
Accompanying drawing 1 is the test overall framework figure of this assessment implementation method, as shown in Figure 1, import test parameter into by booting script, and log in tested database server, call pressing creation module simultaneously, according to set pressure scale, generate corresponding scale data and pressure program, database server is pressurizeed; Call outcome record module records test result and test relevant information simultaneously, and the real-time performance monitor data of do as one likes energy monitoring module crawl measured data storehouse server, as the use of analysis.
The foregoing is only embodiments of the invention, within the spirit and principles in the present invention all, any amendment of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (6)
1. assess implementation method based on informix database server performance for one kind, it is characterized in that, this Performance Evaluation implementation method adopts C language and SQL exploitation, and host computer system that can compatible different frameworks, has proposed a performance evaluating standard model for informix Database Systems; This Performance Evaluation standardized model mainly comprises: start module, pressing creation module, outcome record module and performance monitoring module; Wherein,
Described startup module:
Comprise start-up routine; According to pre-entering information, connection data storehouse, and the pressing creation modular program of Automatically invoked to infomix database automatically, simultaneously logging program running log;
Described pressing creation module:
Comprise pressing creation modular program; Facilitate user according to equipment situation, set pressure scale voluntarily, and automatically produce pressure according to user's setting scale, informix database is carried out to intensive access;
Described outcome record module:
Comprise outcome record program; In the time that pressing creation module starts, automatically start outcome record module, record at any time pressing creation program operation result and state;
Described performance monitoring module:
Comprise performance monitoring program; In the time that pressing creation module starts, automatically startability monitoring module, initiatively records the running status of equipment under test main molecules system, comprises cpu, internal memory, disk I/O and network, and is recorded in daily record.
2. according to claim 1ly it is characterized in that based on informix database server performance assessment implementation method, the implementation procedure of described startup module is:
According to described start-up routine prompting input database logon information and pressure scale, this program initial landing informix database, and generate list structure and primary data according to set pressure scale; Meanwhile, start-up routine calls other three modular programs: pressing creation modular program, outcome record program and performance monitoring program.
3. according to claim 2ly it is characterized in that based on informix database server performance assessment implementation method, the implementation procedure of described pressing creation module is:
After pressing creation modular program is started by start-up routine, according to pressure scale primary data, generate the database access request of corresponding scale, simulate dissimilar access module simultaneously database server is carried out to intensive access, informix database server is produced to larger access pressure, the ability of testing informix database server and bear pressure with this.
4. according to claim 3ly it is characterized in that based on informix database server performance assessment implementation method, the implementation procedure of described outcome record module is:
The startup under the calling of start-up routine of outcome record program, the database access request disposition that monitor force generation module generates, and record the result of every transaction, according to the predefined weight of program, provide test result score, and provide the DCO result of every transaction, to facilitate the use of post analysis.
5. according to claim 4ly it is characterized in that based on informix database server performance assessment implementation method, the implementation procedure of described performance monitoring module is:
Performance monitoring program is called by start-up routine, and is activated, and monitors constantly the performance data of measured data storehouse server, exports respectively the real-time performance data of tested server in the mode of daily record and figure, analyzes and adjust the use of pressure scale with person easy to use.
6. according to claim 1 based on informix database server performance assessment implementation method, it is characterized in that, the course of work of this Performance Evaluation implementation method is: import test parameter into by booting script, and log in tested database server, call pressing creation module simultaneously, according to set pressure scale, generate corresponding scale data and pressure program, database server is pressurizeed; Call outcome record module records test result and test relevant information simultaneously, and the real-time performance monitor data of do as one likes energy monitoring module crawl measured data storehouse server, as the use of analysis.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410205277.8A CN103970876A (en) | 2014-05-15 | 2014-05-15 | Database server performance evaluation implementation method based on Informix |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410205277.8A CN103970876A (en) | 2014-05-15 | 2014-05-15 | Database server performance evaluation implementation method based on Informix |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103970876A true CN103970876A (en) | 2014-08-06 |
Family
ID=51240373
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410205277.8A Pending CN103970876A (en) | 2014-05-15 | 2014-05-15 | Database server performance evaluation implementation method based on Informix |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103970876A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104182340A (en) * | 2014-08-21 | 2014-12-03 | 浪潮(北京)电子信息产业有限公司 | Database compatibility test method and system |
| CN106610896A (en) * | 2015-10-27 | 2017-05-03 | 滴滴（中国）科技有限公司 | Adaptive pressure testing method and device |
| CN109165153A (en) * | 2018-09-06 | 2019-01-08 | 华泰证券股份有限公司 | A kind of performance test methods of high emulation securities business transaction class system |
| CN113342680A (en) * | 2021-06-29 | 2021-09-03 | 中国农业银行股份有限公司 | Asynchronous transaction performance testing method and system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102004693A (en) * | 2010-11-24 | 2011-04-06 | 北京世纪高通科技有限公司 | System performance test method and device |
| CN102999604A (en) * | 2012-11-20 | 2013-03-27 | 北京奇虎科技有限公司 | Method and device for detecting performance of database |
| CN103425683A (en) * | 2012-05-18 | 2013-12-04 | 上海宝信软件股份有限公司 | Database performance test system |
| CN103729361A (en) * | 2012-10-12 | 2014-04-16 | 百度在线网络技术（北京）有限公司 | Method and device for testing performance of database |
-
2014
- 2014-05-15 CN CN201410205277.8A patent/CN103970876A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102004693A (en) * | 2010-11-24 | 2011-04-06 | 北京世纪高通科技有限公司 | System performance test method and device |
| CN103425683A (en) * | 2012-05-18 | 2013-12-04 | 上海宝信软件股份有限公司 | Database performance test system |
| CN103729361A (en) * | 2012-10-12 | 2014-04-16 | 百度在线网络技术（北京）有限公司 | Method and device for testing performance of database |
| CN102999604A (en) * | 2012-11-20 | 2013-03-27 | 北京奇虎科技有限公司 | Method and device for detecting performance of database |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104182340A (en) * | 2014-08-21 | 2014-12-03 | 浪潮(北京)电子信息产业有限公司 | Database compatibility test method and system |
| CN104182340B (en) * | 2014-08-21 | 2017-05-31 | 浪潮(北京)电子信息产业有限公司 | Database compatibility method of testing and system |
| CN106610896A (en) * | 2015-10-27 | 2017-05-03 | 滴滴（中国）科技有限公司 | Adaptive pressure testing method and device |
| CN109165153A (en) * | 2018-09-06 | 2019-01-08 | 华泰证券股份有限公司 | A kind of performance test methods of high emulation securities business transaction class system |
| CN109165153B (en) * | 2018-09-06 | 2022-04-26 | 华泰证券股份有限公司 | Performance test method of high-simulation securities trade system |
| CN113342680A (en) * | 2021-06-29 | 2021-09-03 | 中国农业银行股份有限公司 | Asynchronous transaction performance testing method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9519571B2 (en) | Method for analyzing transaction traces to enable process testing | |
| CN105760286B (en) | Application database dynamic property detection method and detection device | |
| US11176028B2 (en) | System, method and storage device for CIM/E model standard compliance test | |
| US9183528B2 (en) | Generating a compliance data model for IT control | |
| CN105677556B (en) | A kind of dispatching automation main station system method for testing software and its platform | |
| CN103970876A (en) | Database server performance evaluation implementation method based on Informix | |
| CN101996131A (en) | Automatic test method and automatic test platform for graphic user interface (GUI) based on x extensive makeup language (XML) packaging key word | |
| CN103186439A (en) | Server test system and server stability test method | |
| CN102819404A (en) | Interface display method for BIOS (basic input/output system) | |
| WO2019019975A1 (en) | Method and device for cloud platform performance testing | |
| CN103761393B (en) | A kind of method setting up system real time power consumption model based on fine granularity performance counter | |
| CN110147315A (en) | Concurrency performance test method, device, computer equipment and storage medium | |
| CN105980957B (en) | Power monitoring system for virtual platform simulation | |
| CN109491883A (en) | Performance detects control methods and system simultaneously between applying under a kind of Android platform more | |
| CN103970663A (en) | Method for simulating physical devices | |
| CN109634867B (en) | Software testing method and device based on data simulation system and storage medium | |
| US10802852B1 (en) | Method for interactive embedded software debugging through the control of simulation tracing components | |
| EP3077910B1 (en) | Methods and apparatus to optimize platform simulation resource consumption | |
| CN111949493A (en) | Inference application-based power consumption testing method and device for edge AI server | |
| WO2011115983A1 (en) | Automated governance, risk management, and compliance integration | |
| Li et al. | Design and implementation of a library management system based on the web service | |
| Cámara et al. | Robustness evaluation of the rainbow framework for self-adaptation | |
| CN106033211B (en) | A kind of method and device of control gluing board rubber head cleaning | |
| CN107113539B (en) | Device agnostic power monitoring and profiling system | |
| Chen et al. | Design and implementation of cloud platform for nuclear accident simulation |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20140806 |
|
| WD01 | Invention patent application deemed withdrawn after publication |