Database performance testing system

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

Active Publication Date: 2018-06-01
SHANGHAI BAOSIGHT SOFTWARE CO LTD
View PDF3 Cites 0 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 testing system
  • Database performance testing system
  • Database performance testing 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 testing system, which includes a test case creation module, a test execution module, and a data analysis report module; the test case creation module is used to determine the current test case group, and the current test case group includes one or Test cases of multiple operation types; the test execution module is used to concurrently test the target database for each test case in the current test case group determined by the test data creation module, and obtain the results of each test case in the current test case group on the target database Score: The data analysis report module is used to calculate the total score of the target database according to the set weights of various operation types according to the scores of the test cases of various operation types in the current test case group on the target database. The database performance testing system of the present invention can customize test data and test cases, can quickly and simply test database performance, and can perform comparative tests 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
Patent Type & Authority Patents(China)
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 Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap