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

Method for completing data base performance test by using automatic procedure

An automatic program and database technology, applied in the direction of electrical digital data processing, software testing/debugging, special data processing applications, etc., can solve problems such as waste, large manpower and material resources, complexity, etc., to shorten test time, reduce test difficulty, The effect of improving accuracy

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

AI Technical Summary

Problems solved by technology

Simulates the generation of random queries, much more complex than most OLTP transactions, including a wide variety of operational and selectivity constraints, generating a high density of activity on the database server side of the system under test, subject to certain ingress and scale implemented in the database, implemented with limitations due to synchronization with the online product database
[0004] For such a complex test model, it will take a lot of manpower and material resources to manually test step by step, and the accuracy of the test results cannot be guaranteed in these complex manual operations

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
  • Method for completing data base performance test by using automatic procedure

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] Referring to the accompanying drawings, the content of the present invention will be described with specific examples for its implementation and working process.

[0019] The structure of TPCHAuto is divided into 6 parts, which are designed according to the surface type object, and the relationship between classes and classes is handled by the specific class structure:

[0020] MainFrame class: Undertake the interaction between the user and TPCHDriver, including labels, buttons, text areas, etc., and respond to events. Users can set parameters such as DBMS type, database connection information, and data size (SF) here. The test progress information and test result information can be dynamically displayed in the interface.

[0021] DataCreater class: According to the data volume level SF specified by the user, check whether the hard disk space meets the requirements for loading data, and then call DBGEN to generate data and load data.

[0022] DbControl class: Implemen...

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 provides a method for completing a data base performance test by using an automatic program, and belongs to the technical field of data base performance test application of computers. According to the method, a new data base operation system is developed, and the TPC-H is adopted as a test benchmark to test and measure the ability, about inquiry and decision support, of the data base operation system. In order to improve test efficiency, simplify operation and shorten test time, the java programming language is used to develop the automatic program TPCHAuto, and a user can use the automatic tool to complete whole test required by a TPC-H model.

Description

[0001] technical field [0002] The invention relates to the technical field of computer database performance test application, in particular to a method for completing database performance test by using an automatic program. Background technique [0003] TPC Benchmark H (TPC-H) is a benchmark for decision support, which consists of a series of query and parallel data modification for business applications. The queries chosen in the benchmark and the data that make up the database are commercially broadly representative and easy to implement. This benchmark addresses three aspects of decision support systems. Analyze large volumes of data; execute highly complex queries; answer critical, often unanswered business questions. TPC-H evaluates the performance of various decision support systems by executing a series of queries against standard databases in a controlled environment. Simulates the generation of random queries, much more complex than most OLTP transactions,...

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): G06F11/36G06F17/30
Inventor 张远斌
Owner LANGCHAO ELECTRONIC INFORMATION IND 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