Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Database performance test system

A test system and database technology, applied in the computer field, can solve problems such as inconvenience in use, inability to customize test data and test cases, and inability to cover database types, and achieve the effect of comprehensive test indicators.

Active Publication Date: 2013-12-04
SHANGHAI BAOSIGHT SOFTWARE CO LTD
View PDF3 Cites 23 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Although common third-party testing tools include database performance testing modules, on the one hand they cannot cover all types of databases, and cannot meet the needs of comparative testing between multiple types of databases; on the other hand, they are not specifically designed for databases. Test tools have many inconveniences in use, and it is particularly difficult to implement user concurrent testing. Moreover, the common third-party testing tools are scene testing methods, which are basically fixed to a certain scene, and the test cases are also fixed. Because The benchmark is consistent, and customers cannot customize test data and test cases

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 performance test system
  • Database performance test system
  • Database performance test system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0058] Database performance testing system, such as figure 1 As shown, it includes a test case storage module, a test case creation module, a test execution module, a data analysis report module, a log module, a database summary module, and a test data cleaning module. Preferably, the database performance testing system is constructed by using script statements. Because the script language is usually closely related to the operating system, and it is cross-platform, the number of codes is small, and no compiler is needed. Using script statements to construct the database performance testing system can greatly increase the number of tests. Flexibility, shorten the test cycle.

[0059] The test case storage module stores a set of default test cases, which include grouping query transactions, associated sub-query transactions, sort query transactions, recursive query transactions, connection query transactions, simple update transactions, complex update transactions, etc. One or...

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 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 [0001] The invention relates to computer technology, in particular to a database performance testing system. Background technique [0002] With the continuous expansion and extension of information management, new database products of major manufacturers emerge in an endless stream. For customers, how to judge the performance difference of using the same type of database on different servers for the same application program? The difference in performance using different types of databases on the same server has become an important issue. [0003] Usually, third-party testing tools are used for database performance testing. Although common third-party testing tools include database performance testing modules, on the one hand they cannot cover all types of databases, and cannot meet the needs of comparative testing between multiple types of databases; on the other hand, they are not specifically designed for databases. Test tools have many inconveniences in ...

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/00
Inventor 辛旻敖士孟伟李曼
Owner SHANGHAI BAOSIGHT SOFTWARE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products