CN103425683A - Database performance test system - Google Patents
Database performance test system Download PDFInfo
- Publication number
- CN103425683A CN103425683A CN201210157738XA CN201210157738A CN103425683A CN 103425683 A CN103425683 A CN 103425683A CN 201210157738X A CN201210157738X A CN 201210157738XA CN 201210157738 A CN201210157738 A CN 201210157738A CN 103425683 A CN103425683 A CN 103425683A
- Authority
- CN
- China
- Prior art keywords
- test case
- database
- test
- target database
- module
- 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.)
- Granted
Links
Images
Landscapes
- Debugging And Monitoring (AREA)
Abstract
The invention discloses a database performance test system. The database performance test system comprises a test case creating module, a test executing module and a data analysis reporting module, wherein the test case creating module is used for determining a current test case group which comprises one or more operation types of test cases; the test executing module is used for conducting concurrent test on a target database according to all the test cases in the current test case group determined by the test data creating module and obtaining the score of each test case in the current test case group on the target database; the data analysis reporting module is used for calculating out the total score of the target database according to set weight of all the operation types on the basis of the scores of all the operation types of test cases in the current test case group on the target database. The database performance test system can self-define test data and test cases, rapidly and easily test database performance, and conduct comparison test on various types of databases.
Description
Technical field
The present invention relates to computer technology, particularly a kind of database performance measurement system.
Background technology
Along with constantly expanding and extending of information system management degree, the database new product of all big enterprises emerges in an endless stream, and for the client, same application program, how to judge the performance difference that uses the same kind database on different server, how to judge the performance difference that uses distinct type data-base on same server, become a major issue.
Normally adopt the third-party testing instrument to carry out database performance measurement.Common third-party testing instrument, although include the module of database performance measurement, but can not cover all type of database on the one hand, can not meet the demand of doing contrast test between the multiple types of data storehouse, on the other hand owing to not being the special testing tool for database, the inconvenience part is arranged in the use, particularly difficulty seems in the realization of user concurrent test, and common third-party testing instrument is the method for scrnario testing, substantially be fixed as certain scene, test case is also fixed, because benchmark is consistent, the client can not self-defined test data and test case.
Summary of the invention
The technical problem to be solved in the present invention is to provide a kind of database performance measurement system, can self-defined test data and test case, and simple test database performance fast, and can compare test to the multiple types of data storehouse.
For solving the problems of the technologies described above, database performance measurement system of the present invention, it comprises a test case creation module, a testing execution module, a data analysis report module;
Described test case creation module, for determining current test case group, current test case group comprises the test case of one or more action types;
Described testing execution module, each test case concurrent test target database for the current test case group definite according to the test data creation module, obtain the score of each test case on target database in current test case group;
Described data analysis report module, for the score of test case on target database of the various action types according to current test case group, obtain the overall score of target database according to the setting weight calculation of various action types.
Described testing execution module, can be for each test case concurrent test target database of the current test case group determined according to the test data creation module, obtain score on target database of each test case in current test case group and maximum response time, Best-case Response Time, average response time;
Described data analysis report module, can be by the test case of the various action types of target database overall score, current test case group the score on target database and maximum response time, Best-case Response Time, average response time, export to test report file.
The database performance measurement system can also comprise a test case memory module, a database summary module;
Described test case memory module, preserve a set of acquiescence test case; This cover is given tacit consent to test case, comprises the test case of one or more action types;
Described test case creation module, the course of work can be as follows:
101. bring into operation;
102. output database type selecting prompting;
103. according to one or more target database types of setting, the type of database of user's input is verified, if the verification passes, carry out step 104, otherwise carry out step 111;
104. export target database user verification tip;
105. the target database user profile of user's input is sent to target database, if target database is verified, carry out step 106, otherwise carry out step 111;
106. described target database user profile is stored into to the database summary module, and output database connects the voucher prompting;
107. input the database connection voucher of target database the user after, the linking objective database, if successful connection connects voucher by the database of user's input and stores the database summary module into, and the output test case is selected to point out;
108. if the user selects acquiescence,, using this cover acquiescence test case in described test case memory module as current test case group, then carry out step 111; Otherwise carry out step 109;
109. output backup path prompting;
110., behind the path of each backup test example that receives user's input, a plurality of backup test examples under each path are formed to a set of test case as current test case group, and the establishment information of this cover test case are saved in log pattern;
111. exit the test data creation module;
Described current test case group, can comprise grouping inquiry transaction, associated subquery affairs, sequence inquiry transaction, recursive query affairs, connect inquiry transaction, simply upgrade affairs, the complicated test case that upgrades one or more action types in affairs.
The target database type of described setting can be relevant database.
Described relevant database can be oracle database, DB2 database or MySQL database;
Described target database user profile, can comprise as data library manager account, password.
Described testing execution module, can be for each test case concurrent test target database of the current test case group definite according to the test data creation module, obtain score on target database of each test case in current test case group and maximum response time, Best-case Response Time, average response time, the course of work of testing execution module is as follows:
201. bring into operation;
202. output number of concurrent prompting;
203., after the number of concurrent that receives user's input, target database user profile, the database transferred in the database summary module connect voucher, are connected to target database, and the prompting of output process execution time;
204. after the execution time of each concurrent process that receives user's input, equal the process of number of concurrent with number, the test case of the various action types in the current test case group that the test case creation module is determined moves on target database;
205. if the current time deducts the execution time of this process that the start time of a process of a test case is more than or equal to, finish this process of this test case;
206., after each process that the test case of the various action types in current test case group moves on target database all finishes, according to the test result of each process of each test case, by the corresponding computational logic of various action types of setting, obtain the score of each test case on target database and maximum response time, Best-case Response Time, average response time;
207. exit testing execution module;
The database performance measurement system can also comprise a log pattern;
Described testing execution module, in step 202, if the lock file of the definite current test case group of test data creation module is arranged in log pattern, carry out step 207, otherwise generate the lock file of the definite current test case group of test data creation module and be saved in log pattern, and output number of concurrent prompting;
In step 205, if the current time deducts the execution time of this process that the start time of a process of a test case is more than or equal to, finish this process of this test case, and the start time of this process of this test case, execution time and test result are saved in log pattern;
In step 206, and the score on target database and maximum response time, Best-case Response Time, average response time are saved in log pattern by each test case, and the lock file of the current test case group in log pattern is deleted, make this test case group revert to the concurrent test executable state.
The database performance measurement system can also comprise a test data cleaning module;
Described data analysis report module, the score of test case on target database according to the various action types of the current test case group in log pattern, obtain the overall score of target database according to the setting weight calculation of various action types, score by the test case of the various action types of target database overall score, current test case group on target database and maximum response time, Best-case Response Time, average response time, export to test report file;
Described test data cleaning module, for the data that produce in test process log pattern and database summary module before cleaning.
Preferably, if in step 203, the number of concurrent of user's input is greater than the preset proportion of CPU sum in target database, in step 204, after the execution time of each concurrent process that receives user's input, equal the process of the preset proportion of CPU sum in target database with number, the test case of the various action types in the current test case group that the test case creation module is determined moves on target database.
Preferably, described preset proportion is between 90% to 95%.
Preferably, the described execution time at 300s between 900s.
Preferably, the database performance measurement system, be to utilize script sentence to build.
Database performance measurement system of the present invention, be set with the test case creation module of plurality of target type of database by operation, user's selected target type of database is also inputted associated databases connection voucher, just can carry out performance test to the multiple types of data storehouse, thereby realize the contrast test of the performance in the multiple types of data storehouse under same testing standard; By operation test case creation module, the user can also select to give tacit consent to test case as current test case, or selects to import the backup test example as current test case from each path, and the user can consider the self-defined test case of actual application scenarios; The current test case group that operation test case creation module is determined, the test case that can comprise multiple action type, thereby can the test packet inquiry, associated subquery, sequence inquiry, recursive query, connection inquiry, simply upgrade, the various affairs such as complicated renewal, test index is comprehensive;
By the operation testing execution module, the test datas such as the number of concurrent that the user can self-defined process and execution time, can control the test duration flexibly, thus simple test database performance fast; After the testing execution module operation, can in log pattern, create the lock file of current test case group, be carried out by other users to prevent current test case, affect test result simultaneously.
Testing execution module is in the concurrent test process, each process is recently control process is exited by current time and its start time, rather than adopt each process execution same time to come the control process to exit, the ideal time that such mode makes the time of test more approach the user, do not affect the effect of test simultaneously yet, can more accurate test database performance.
The data analysis report module, export to the information of test report file after operation, score and other detecting information of test case on target database that comprises the multiple action type of target database overall score, current test case group, be convenient to the user and do concrete analysis with regard to every affairs, and be convenient to the quality that the user contrasts the different target database performance.
The accompanying drawing explanation
In order to be illustrated more clearly in technical scheme of the present invention, below the accompanying drawing that will use required for the present invention is briefly described, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain according to these accompanying drawings other accompanying drawing.
Fig. 1 is database performance measurement system one embodiment schematic diagram of the present invention;
Fig. 2 is the workflow diagram of the test case creation module in database performance measurement system one embodiment of the present invention;
Fig. 3 is the workflow diagram of the testing execution module in database performance measurement system one embodiment of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the present invention's part embodiment, rather than whole embodiment.Should be appreciated that preferred embodiment described herein, only for description and interpretation the present invention, is not intended to limit the present invention.And, in the situation that do not conflict, embodiment and the feature in embodiment in the present invention can combine mutually.Embodiment based in the present invention, the every other embodiment that those of ordinary skills obtain, belong to the scope of protection of the invention.
Embodiment mono-
The database performance measurement system, as shown in Figure 1, comprise a test case memory module, a test case creation module, a testing execution module, a data analysis report module, a log pattern, a database summary module, a test data cleaning module.Preferably, the database performance measurement system, to utilize script sentence to build, because script is common and the operating system contact is tight, and cross-platform, code quantity is few, without compiler, utilize script sentence to build the database performance measurement system, can greatly increase the test dirigibility, shorten test period.
Described test case memory module, preserve a set of acquiescence test case, this cover acquiescence test case comprises grouping inquiry transaction, associated subquery affairs, sequence inquiry transaction, recursive query affairs, connects inquiry transaction, simply upgrades affairs, complicatedly upgrade one or more in the action type test cases such as affairs;
Described test case creation module, for determining current test case group, current test case group comprises grouping inquiry transaction, associated subquery affairs, sequence inquiry transaction, recursive query affairs, connects inquiry transaction, simply upgrades affairs, complicatedly upgrade one or more in the action type test cases such as affairs;
The course of work of test case creation module is as shown in Figure 2:
101. bring into operation;
102. output database type selecting prompting;
103. according to one or more target database types of setting, the type of database of user's input is verified, if the verification passes, carry out step 104, otherwise carry out step 111; The target database type of described setting can be oracle database, DB2 database or the general relevant database of MySQL database;
104. export target database user verification tip;
105. the target database user profile (as data library manager account, password) of user's input is sent to target database, if target database is verified, carry out step 106, otherwise carry out step 111;
106. described target database user profile is stored into to the database summary module, and output database connects the voucher prompting; Database connects voucher, is the connected mode of database, and different databases has different connected modes, as oracle needs the network profile name of preparation tnsname(database in advance), as db2 need provide Alias;
107. input the database connection voucher of target database the user after, the linking objective database, if successful connection connects voucher by the database of user's input and stores the database summary module into, and the output test case is selected to point out;
108. if the user selects acquiescence,, using this cover acquiescence test case in described test case memory module as current test case group, then carry out step 111; Otherwise carry out step 109;
109. output backup path prompting;
110., behind the path of each backup test example that receives user's input, a plurality of backup test examples under each path are formed to a set of test case as current test case group, and the establishment information of this cover test case are saved in log pattern;
111. exit the test data creation module;
Described testing execution module, each test case concurrent test target database for the current test case group definite according to the test data creation module, obtain other detecting informations such as score on target database of each test case in current test case group and maximum response time, Best-case Response Time, average response time, the course of work of testing execution module as shown in Figure 3:
201. bring into operation;
If 202. the lock file of the definite current test case group of test data creation module is arranged in log pattern, carry out step 207, otherwise generate the lock file of the definite current test case group of test data creation module and be saved in log pattern, and output number of concurrent prompting;
203., after the number of concurrent that receives user's input, target database user profile, the database transferred in the database summary module connect voucher, are connected to target database, and the prompting of output process execution time;
204. after the execution time of each concurrent process that receives user's input, equal the process of number of concurrent with number, the test case of the various action types in the current test case group that the test case creation module is determined moves on target database;
205. if the current time deducts the execution time of this process that the start time of a process of a test case is more than or equal to, finish this process of this test case, and the start time of this process of this test case, execution time and test result are saved in log pattern;
After 206. each process that the test case of the various action types in current test case group moves on target database all finishes, obtain score and the maximum response time of each test case on target database according to the test result of each process of each test case by the corresponding computational logic of various action types of setting, Best-case Response Time, other detecting informations such as average response time, and by each test case the score on target database and maximum response time, Best-case Response Time, other detecting informations such as average response time are saved in log pattern, and the lock file of the current test case group in log pattern is deleted, make this test case group revert to the concurrent test executable state,
207. exit testing execution module;
Preferably, in the course of work of testing execution module, if in step 203, the number of concurrent of user's input is greater than the preset proportion of CPU sum in target database, in step 204, after the execution time of each concurrent process that receives user's input, equal the process of the preset proportion of CPU sum in target database with number, the test case of the various action types in the current test case group that the test case creation module is determined moves on target database.
Owing to needing reserve part CPU for operating system self-management coherent system resource in target database, otherwise test is by unstable and inaccurate common, self-management consumes low as AIX operating system, need to retain the CPU more than 5% in target database, self-management consumes higher as windows operating system, need to retain the CPU more than 5% in target database, so preferred, described preset proportion is between 90% to 95%.
Due to for can Quick for stable service as AIX operating system, stable service just can be provided usually in 300s, for can provide stable service need certain hour as windows operating system, stable service just can be provided usually in 900s, time lengthening afterwards, the test effect is basically identical, thus the execution time of each concurrent process of user input preferably at 300s between 900s, so that quick, stable test database performance.
Described data analysis report module, (comprise the grouping inquiry transaction according to the various action types of the current test case group in log pattern after operation, associated subquery affairs, the sequence inquiry transaction, the recursive query affairs, connect inquiry transaction, the simple affairs of upgrading, one or more in complicated renewal affairs) the score of test case on target database, obtain the overall score of target database according to the setting weight calculation of various action types, by the target database overall score, score and the maximum response time of the test case of the multiple action type of current test case group on target database, Best-case Response Time, other detecting informations such as average response time export to test report file,
Test report file one embodiment, as shown in table 1:
Table 1
In this embodiment, operation test case creation module, create or definite current embodiment group that comprises the test case of seven kinds of action types; The operation testing execution module, utilize the test case concurrent test target database of seven kinds of action types in current test case group, obtain the score of test case on target database of seven kinds of action types and reach other detecting informations such as maximum response time, Best-case Response Time, average response time; The Operational Data Analysis reporting modules, the score of test case on target database according to the setting weight of seven kinds of action types, seven kinds of action types, calculate the overall score of target database, and export to test report file;
Described test data cleaning module, the data that produce in log pattern and database summary module in test process before cleaning after operation.
Database performance measurement system of the present invention, be set with the test case creation module of plurality of target type of database by operation, user's selected target type of database is also inputted associated databases connection voucher, just can carry out performance test to the multiple types of data storehouse, thereby realize the contrast test of the performance in the multiple types of data storehouse under same testing standard; By operation test case creation module, the user can also select to give tacit consent to test case as current test case, or selects to import the backup test example as current test case from each path, and the user can consider the self-defined test case of actual application scenarios; The current test case group that operation test case creation module is determined, the test case that can comprise multiple action type, thereby can the test packet inquiry, associated subquery, sequence inquiry, recursive query, connection inquiry, simply upgrade, the various affairs such as complicated renewal, test index is comprehensive;
By the operation testing execution module, the test datas such as the number of concurrent that the user can self-defined process and execution time, can control the test duration flexibly, thus simple test database performance fast; After the testing execution module operation, can in log pattern, create the lock file of current test case group, be carried out by other users to prevent current test case, affect test result simultaneously.
Testing execution module is in the concurrent test process, each process is recently control process is exited by current time and its start time, rather than adopt each process execution same time to come the control process to exit, the ideal time that such mode makes the time of test more approach the user, do not affect the effect of test simultaneously yet, can more accurate test database performance.
The data analysis report module, export to the information of test report file after operation, score and other detecting information of test case on target database that comprises the multiple action type of target database overall score, current test case group, be convenient to the user and do concrete analysis with regard to every affairs, and be convenient to the quality that the user contrasts the different target database performance.
The foregoing is only preferred embodiment of the present invention, in order to limit the present invention, within the spirit and principles in the present invention not all, any modification of making, be equal to replacement, improvement etc., within all should being included in the scope of protection of the invention.
Claims (13)
1. a database performance measurement system, is characterized in that, comprises a test case creation module, a testing execution module, a data analysis report module;
Described test case creation module, for determining current test case group, current test case group comprises the test case of one or more action types;
Described testing execution module, each test case concurrent test target database for the current test case group definite according to the test data creation module, obtain the score of each test case on target database in current test case group;
Described data analysis report module, for the score of test case on target database of the various action types according to current test case group, obtain the overall score of target database according to the setting weight calculation of various action types.
2. database performance measurement system according to claim 1, is characterized in that,
Described testing execution module, for each test case concurrent test target database of the current test case group determined according to the test data creation module, obtain score on target database of each test case in current test case group and maximum response time, Best-case Response Time, average response time;
Described data analysis report module, the score by the test case of the various action types of target database overall score, current test case group on target database and maximum response time, Best-case Response Time, average response time, export to test report file.
3. database performance measurement system according to claim 1, is characterized in that,
The database performance measurement system also comprises a test case memory module, a database summary module;
Described test case memory module, preserve a set of acquiescence test case; This cover is given tacit consent to test case, comprises the test case of one or more action types;
Described test case creation module, the course of work is as follows:
101. bring into operation;
102. output database type selecting prompting;
103. according to one or more target database types of setting, the type of database of user's input is verified, if the verification passes, carry out step 104, otherwise carry out step 111;
104. export target database user verification tip;
105. the target database user profile of user's input is sent to target database, if target database is verified, carry out step 106, otherwise carry out step 111;
106. described target database user profile is stored into to the database summary module, and output database connects the voucher prompting;
107. input the database connection voucher of target database the user after, the linking objective database, if successful connection connects voucher by the database of user's input and stores the database summary module into, and the output test case is selected to point out;
108. if the user selects acquiescence,, using this cover acquiescence test case in described test case memory module as current test case group, then carry out step 111; Otherwise carry out step 109;
109. output backup path prompting;
110., behind the path of each backup test example that receives user's input, a plurality of backup test examples under each path are formed to a set of test case as current test case group, and the establishment information of this cover test case are saved in log pattern;
111. exit the test data creation module.
4. database performance measurement system according to claim 3, is characterized in that,
Described current test case group, comprise grouping inquiry transaction, associated subquery affairs, sequence inquiry transaction, recursive query affairs, connect inquiry transaction, simply upgrade affairs, the complicated test case that upgrades one or more action types in affairs.
5. database performance measurement system according to claim 3, is characterized in that,
The target database type of described setting is relevant database.
6. database performance measurement system according to claim 5, is characterized in that,
Described relevant database is oracle database, DB2 database or MySQL database;
Described target database user profile, comprise data base administrator's account, password.
7. according to the described database performance measurement system of claim 3 to 6 any one, it is characterized in that,
Described testing execution module, each test case concurrent test target database for the current test case group definite according to the test data creation module, obtain score on target database of each test case in current test case group and maximum response time, Best-case Response Time, average response time, the course of work of testing execution module is as follows:
201. bring into operation;
202. output number of concurrent prompting;
203., after the number of concurrent that receives user's input, target database user profile, the database transferred in the database summary module connect voucher, are connected to target database, and the prompting of output process execution time;
204. after the execution time of each concurrent process that receives user's input, equal the process of number of concurrent with number, the test case of the various action types in the current test case group that the test case creation module is determined moves on target database;
205. if the current time deducts the execution time of this process that the start time of a process of a test case is more than or equal to, finish this process of this test case;
206., after each process that the test case of the various action types in current test case group moves on target database all finishes, according to the test result of each process of each test case, by the corresponding computational logic of various action types of setting, obtain the score of each test case on target database and maximum response time, Best-case Response Time, average response time;
207. exit testing execution module.
8. database performance measurement system according to claim 7, is characterized in that,
The database performance measurement system also comprises a log pattern;
Described testing execution module, in step 202, if the lock file of the definite current test case group of test data creation module is arranged in log pattern, carry out step 207, otherwise generate the lock file of the definite current test case group of test data creation module and be saved in log pattern, and output number of concurrent prompting;
In step 205, if the current time deducts the execution time of this process that the start time of a process of a test case is more than or equal to, finish this process of this test case, and the start time of this process of this test case, execution time and test result are saved in log pattern;
In step 206, and the score on target database and maximum response time, Best-case Response Time, average response time are saved in log pattern by each test case, and the lock file of the current test case group in log pattern is deleted, make this test case group revert to the concurrent test executable state.
9. database performance measurement system according to claim 8, is characterized in that,
The database performance measurement system also comprises a test data cleaning module;
Described data analysis report module, the score of test case on target database according to the various action types of the current test case group in log pattern, obtain the overall score of target database according to the setting weight calculation of various action types, score by the test case of the various action types of target database overall score, current test case group on target database and maximum response time, Best-case Response Time, average response time, export to test report file;
Described test data cleaning module, for the data that produce in test process log pattern and database summary module before cleaning.
10. database performance measurement system according to claim 7, is characterized in that,
If in step 203, the number of concurrent of user's input is greater than the preset proportion of CPU sum in target database, in step 204, after the execution time of each concurrent process that receives user's input, equal the process of the preset proportion of CPU sum in target database with number, the test case of the various action types in the current test case group that the test case creation module is determined moves on target database.
11. database performance measurement system according to claim 10, is characterized in that,
Described preset proportion is between 90% to 95%.
12. database performance measurement system according to claim 7, is characterized in that,
The described execution time at 300s between 900s.
13. according to the described database performance measurement system of claim 1 to 6 any one, it is characterized in that,
The database performance measurement system is to utilize script sentence to build.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201210157738.XA CN103425683B (en) | 2012-05-18 | 2012-05-18 | Database performance test system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201210157738.XA CN103425683B (en) | 2012-05-18 | 2012-05-18 | Database performance test system |
Publications (2)
Publication Number | Publication Date |
---|---|
CN103425683A true CN103425683A (en) | 2013-12-04 |
CN103425683B CN103425683B (en) | 2018-06-01 |
Family
ID=49650441
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201210157738.XA Active CN103425683B (en) | 2012-05-18 | 2012-05-18 | Database performance test system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN103425683B (en) |
Cited By (17)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103970876A (en) * | 2014-05-15 | 2014-08-06 | 浪潮电子信息产业股份有限公司 | Database server performance evaluation implementation method based on Informix |
CN105389401A (en) * | 2015-12-25 | 2016-03-09 | 北京奇虎科技有限公司 | Method and device for testing performance of database |
CN105429826A (en) * | 2015-12-25 | 2016-03-23 | 北京奇虎科技有限公司 | Fault detection method and device for database cluster |
CN105446825A (en) * | 2014-06-12 | 2016-03-30 | 阿里巴巴集团控股有限公司 | Database test method and device |
CN105975603A (en) * | 2016-05-11 | 2016-09-28 | 深圳市永兴元科技有限公司 | Database performance test method and device |
CN106383779A (en) * | 2016-08-31 | 2017-02-08 | 天津南大通用数据技术股份有限公司 | Database adaptation pressure test method and device |
CN106445763A (en) * | 2016-09-09 | 2017-02-22 | 中国南方电网有限责任公司电网技术研究中心 | Power distribution and utilization big data platform test method and system |
US10073866B2 (en) | 2015-05-08 | 2018-09-11 | International Business Machines Corporation | Dynamic test case prioritization for relational database systems |
CN108959574A (en) * | 2018-07-06 | 2018-12-07 | 环旭电子股份有限公司 | A kind of test data analysis method and system |
CN109271453A (en) * | 2018-10-22 | 2019-01-25 | 阿里巴巴集团控股有限公司 | A kind of determination method and apparatus of database volume |
CN110046163A (en) * | 2019-04-12 | 2019-07-23 | 网宿科技股份有限公司 | A kind of data retrieval method and system |
CN110147328A (en) * | 2019-05-24 | 2019-08-20 | 深圳市网心科技有限公司 | A kind of database performance measurement method, system, electronic equipment and storage medium |
CN110334005A (en) * | 2019-05-24 | 2019-10-15 | 平安普惠企业管理有限公司 | Graphic data base screening technique and device, storage medium, electronic equipment |
CN110716910A (en) * | 2019-10-14 | 2020-01-21 | 中国建设银行股份有限公司 | Log management method, device, equipment and storage medium |
CN110737594A (en) * | 2019-09-19 | 2020-01-31 | 武汉迎风聚智科技有限公司 | Database standard conformance testing method and device for automatically generating test cases |
CN111767269A (en) * | 2020-06-24 | 2020-10-13 | 苏州紫焰网络科技有限公司 | Health detection method, device and equipment of database instance and storage medium |
CN112486793A (en) * | 2020-12-21 | 2021-03-12 | 北京安兔兔科技有限公司 | Operation performance testing method and device, electronic equipment and storage medium |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101887465A (en) * | 2010-07-30 | 2010-11-17 | 南开大学 | Method for evaluating pure XML engine of relational database system |
US20110055633A1 (en) * | 2009-08-31 | 2011-03-03 | Martin Vecera | Declarative Test Execution |
US20110296383A1 (en) * | 2010-05-27 | 2011-12-01 | Michael Pasternak | Mechanism for Performing Dynamic Software Testing Based on Test Result Information Retrieved in Runtime Using Test Result Entity |
-
2012
- 2012-05-18 CN CN201210157738.XA patent/CN103425683B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20110055633A1 (en) * | 2009-08-31 | 2011-03-03 | Martin Vecera | Declarative Test Execution |
US20110296383A1 (en) * | 2010-05-27 | 2011-12-01 | Michael Pasternak | Mechanism for Performing Dynamic Software Testing Based on Test Result Information Retrieved in Runtime Using Test Result Entity |
CN101887465A (en) * | 2010-07-30 | 2010-11-17 | 南开大学 | Method for evaluating pure XML engine of relational database system |
Non-Patent Citations (3)
Title |
---|
武海平等: "通用海量数据库性能测试***的设计与实现", 《清华大学学报》 * |
肖盼等: "基于SQL语言执行效能的关系数据库性能测试研究", 《计算机与数据工程》 * |
马跃: "基于TPC-C标准的数据库基准性能测试工具的研究与实现", 《中国优秀硕博士学位论文全文数据库》 * |
Cited By (24)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103970876A (en) * | 2014-05-15 | 2014-08-06 | 浪潮电子信息产业股份有限公司 | Database server performance evaluation implementation method based on Informix |
CN105446825A (en) * | 2014-06-12 | 2016-03-30 | 阿里巴巴集团控股有限公司 | Database test method and device |
CN105446825B (en) * | 2014-06-12 | 2020-08-11 | 阿里巴巴集团控股有限公司 | Database testing method and device |
US10073866B2 (en) | 2015-05-08 | 2018-09-11 | International Business Machines Corporation | Dynamic test case prioritization for relational database systems |
US10083191B2 (en) | 2015-05-08 | 2018-09-25 | International Business Machines Corporation | Dynamic test case prioritization for relational database systems |
CN105389401B (en) * | 2015-12-25 | 2019-05-31 | 北京奇虎科技有限公司 | Database performance measurement method and apparatus |
CN105389401A (en) * | 2015-12-25 | 2016-03-09 | 北京奇虎科技有限公司 | Method and device for testing performance of database |
CN105429826A (en) * | 2015-12-25 | 2016-03-23 | 北京奇虎科技有限公司 | Fault detection method and device for database cluster |
CN105975603A (en) * | 2016-05-11 | 2016-09-28 | 深圳市永兴元科技有限公司 | Database performance test method and device |
CN106383779A (en) * | 2016-08-31 | 2017-02-08 | 天津南大通用数据技术股份有限公司 | Database adaptation pressure test method and device |
CN106445763A (en) * | 2016-09-09 | 2017-02-22 | 中国南方电网有限责任公司电网技术研究中心 | Power distribution and utilization big data platform test method and system |
CN108959574A (en) * | 2018-07-06 | 2018-12-07 | 环旭电子股份有限公司 | A kind of test data analysis method and system |
CN109271453A (en) * | 2018-10-22 | 2019-01-25 | 阿里巴巴集团控股有限公司 | A kind of determination method and apparatus of database volume |
CN109271453B (en) * | 2018-10-22 | 2021-08-27 | 创新先进技术有限公司 | Method and device for determining database capacity |
CN110046163A (en) * | 2019-04-12 | 2019-07-23 | 网宿科技股份有限公司 | A kind of data retrieval method and system |
CN110334005A (en) * | 2019-05-24 | 2019-10-15 | 平安普惠企业管理有限公司 | Graphic data base screening technique and device, storage medium, electronic equipment |
CN110147328A (en) * | 2019-05-24 | 2019-08-20 | 深圳市网心科技有限公司 | A kind of database performance measurement method, system, electronic equipment and storage medium |
CN110147328B (en) * | 2019-05-24 | 2023-07-18 | 深圳市网心科技有限公司 | Database performance test method, system, electronic equipment and storage medium |
CN110737594A (en) * | 2019-09-19 | 2020-01-31 | 武汉迎风聚智科技有限公司 | Database standard conformance testing method and device for automatically generating test cases |
CN110737594B (en) * | 2019-09-19 | 2021-02-05 | 武汉迎风聚智科技有限公司 | Database standard conformance testing method and device for automatically generating test cases |
CN110716910A (en) * | 2019-10-14 | 2020-01-21 | 中国建设银行股份有限公司 | Log management method, device, equipment and storage medium |
CN110716910B (en) * | 2019-10-14 | 2022-10-14 | 中国建设银行股份有限公司 | Log management method, device, equipment and storage medium |
CN111767269A (en) * | 2020-06-24 | 2020-10-13 | 苏州紫焰网络科技有限公司 | Health detection method, device and equipment of database instance and storage medium |
CN112486793A (en) * | 2020-12-21 | 2021-03-12 | 北京安兔兔科技有限公司 | Operation performance testing method and device, electronic equipment and storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN103425683B (en) | 2018-06-01 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN103425683A (en) | Database performance test system | |
US9703692B2 (en) | Development supporting system | |
Ganapathi et al. | Statistics-driven workload modeling for the cloud | |
US10067754B2 (en) | Software service notifications based upon software usage, configuration, and deployment topology | |
US10452625B2 (en) | Data lineage analysis | |
US9405662B2 (en) | Process for displaying test coverage data during code reviews | |
CN107729227B (en) | Application program test range determining method, system, server and storage medium | |
CN104679717A (en) | Method and management system of elastic cluster deployment | |
Chen et al. | From tpc-c to big data benchmarks: A functional workload model | |
CN110830234B (en) | User traffic distribution method and device | |
CN102880543B (en) | For the test data supply chain manager of integration testing platform | |
CN107797914A (en) | Code process method, apparatus and code delivery system | |
WO2016010908A1 (en) | System and method for self-optimizing a user interface to support the execution of a business process | |
US20160371177A1 (en) | Method for determining an amount of available resources ensuring a quality user experience | |
CN112486491A (en) | Page generation method and device, computer equipment and storage medium | |
CN111309586A (en) | Command testing method, device and storage medium thereof | |
CN110865806B (en) | Code processing method, device, server and storage medium | |
US20140053144A1 (en) | Service environment upgrades based on upgrade health of service units | |
US11416801B2 (en) | Analyzing value-related data to identify an error in the value-related data and/or a source of the error | |
CN112486532A (en) | Method and device for managing configuration file, electronic equipment and storage medium | |
CN107229487B (en) | Code processing method and device | |
CN114881521A (en) | Service evaluation method, device, electronic equipment and storage medium | |
CN109558153B (en) | Method, device and system for determining version consistency | |
CN109669668B (en) | Method and device for realizing simulated transaction execution in system performance test | |
CN111767222A (en) | Data model verification method and device, electronic equipment and storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |