Unlock instant, AI-driven research and patent intelligence for your innovation.

Testing method and device of tool system based on database

A test method and test device technology, which are applied in the fields of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems such as data can not be adjusted, data preparation time and labor cost are large, and new data sources are inconvenient, etc. Achieve time and cost savings

Active Publication Date: 2016-04-20
ALIBABA GRP HLDG LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, when generating data through an existing data creation program (such as datafactory), it is inconvenient to add a new data source (data set), and it is also inconvenient to maintain. It is necessary to upload txt text; at the same time, the configured data cannot be adjusted, so , which needs to be configured at one time, which brings great inconvenience to actual use
However, by manually writing SQL statements to create data, the Cartesian set and assignment of certain fields are generally realized by writing loops to generate SQL statements. The data preparation time and labor costs are large, and there is no visual interface, and configuration and maintenance are not easy. convenient

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
  • Testing method and device of tool system based on database
  • Testing method and device of tool system based on database
  • Testing method and device of tool system based on database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0032] In order to make the above objects, features and advantages of the present application more obvious and comprehensible, the present application will be further described in detail below in conjunction with the accompanying drawings and specific implementation methods.

[0033] refer to figure 1 , figure 1 A flow chart of steps for a data generation method of the present application, including the following steps:

[0034] In the field selection step S110, select the data field to be configured in the table where data needs to be generated.

[0035] In practice, the data fields to be configured in the tables that need to generate data can be determined according to project requirements, such as wages, taxes, benefits in a table of a certain aspect of the financial system, or companies in a certain market and various companies in this market. Fields such as products operated by the company.

[0036] Constraint rules and data set allocation step S120, respectively deter...

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 database-based testing method and device for a tool system. The method includes the steps of selecting data fields to be configured in a chart requiring data generation; respectively determining constraint rules and corresponding tool data sets for each data field to be configured; generating data for each data field to be configured according to the constraint rules and the tool data sets; and generating an SQL (structured query language) file on the basis of the data; and introducing the SQL file to a system to be tested, and testing the system to be tested. The constraint rules are used to determine an array way of data in the tool data sets. The tool data sets include a common data set and a private data set. The common data set includes data universal to various items. The private data set includes data independently used for certain item. Data preparation process is simpler and is easier to operate by the method and device, and accordingly time and cost in data preparation are saved.

Description

technical field [0001] The application relates to the field of computer databases, in particular to a testing method and device for a database-based tool system. Background technique [0002] "Creating data" is a necessary work such as ETL testing. At present, data is usually generated by using a data creation program or manually writing SQL statements. [0003] However, when generating data through an existing data creation program (such as datafactory), it is inconvenient to add a new data source (data set), and it is also inconvenient to maintain. It is necessary to upload txt text; at the same time, the configured data cannot be adjusted, so , which needs to be configured at one time, which brings great inconvenience to actual use. However, by manually writing SQL statements to create data, the Cartesian set and assignment of certain fields are generally realized by writing loops to generate SQL statements. The data preparation time and labor costs are large, and there...

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/30
Inventor 曹攀
Owner ALIBABA GRP HLDG LTD