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

Data generation method and system

A data generation and data technology, applied in the database field, can solve problems such as incompleteness, incomplete test data, and long time consumption, and achieve the effect of improving quality and input efficiency

Active Publication Date: 2013-07-03
TENCENT TECH (BEIJING) CO LTD
View PDF4 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In the process of realizing the present invention, the inventor found that when using the prior art to input test data, the input process is cumbersome and time-consuming, and the efficiency of test data input is low; The specified rules are limited, which will make the input test data incomplete and incomplete, resulting in a large difference between the input data and the expected goal

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
  • Data generation method and system
  • Data generation method and system
  • Data generation method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0020] The embodiment of the present invention provides a data generation method, such as figure 1 As shown, the method includes:

[0021] 101. The data generation system analyzes configuration information of data in the current database, and acquires data generation rules according to the configuration information.

[0022] Specifically, the configuration information includes the configuration information of the data table in the database, or the configuration information preset by the user; wherein, the configuration information of the data table includes the field information of the data table in the current database, and the field information Including information such as the field name, type, length, comment, default value, attribute, self-increment type, constraint, etc. of the field; the user-preset configuration information is set by the user to represent the data generation rules that meet the user's needs.

[0023] 102. The data generation system generates data acco...

Embodiment 2

[0027] The embodiment of the present invention provides a data generation method, such as figure 2 As shown, the method includes:

[0028] 201. The data generation system acquires the configuration information of the data table in the database, the configuration information includes the field information of each field in the data table, and the field information includes the field name, type, length, comment, and default value of the field , attributes, auto-increment types, constraints and other information.

[0029] It is worth noting that the data generation system can also obtain user-preset configuration information to determine data generation rules. Specifically, the configuration information preset by the user is set by the user, and is used to represent the data generation rule set by the user.

[0030] 202. The data generation system analyzes the field information of each field in the data table, specifically including analyzing the field name of each field, and o...

Embodiment 3

[0056] An embodiment of the present invention provides a data generation system capable of implementing the above method embodiments, such as image 3 As shown, the data generation system includes:

[0057] An analysis unit 31, configured to analyze the configuration information of the data in the current database, and obtain data generation rules according to the configuration information;

[0058] The generation unit 32 is configured to generate data according to the data generation rule.

[0059] Further, such as Figure 4 As shown, the data generation system also includes a first acquisition unit 33 or a second acquisition unit 34, wherein:

[0060] The first acquiring unit 33 is configured to acquire configuration information of a data table in the database, the configuration information includes field information of each field in the data table, and the field information includes field names of each field in the database; or

[0061] The second acquiring unit 34 is c...

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 data generation method and a system, which relate to the field of database, and aims to solve the problem that the test data recorded by the prior art is imperfect and incomplete, resulting in large difference between the recorded data and the anticipated target. The data generation method provided by the invention comprises the following steps: analyzing the configuration information of the data in a current database; acquiring data generation rule according to the configuration information; and generating data according to the data generation rule. The data generation method and system is applicable to the field of database, and is used for data generation.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method and system for generating data. Background technique [0002] Database (Database, DB) is a long-term storage in the computer, organized, shareable, unified management of data collection, is a computer software system to store and manage data according to the data structure. At present, commonly used databases include Oracle database, SQL (Structured Query Language, Structured Query Language) database, Sybase database, and the like. [0003] Software testing refers to the use of testing tools to conduct functional and performance testing of products according to testing plans and processes. In the process of software testing, it is necessary to enter the test data into the database. At present, there are mainly two methods for inputting test data. One method is to input item by item through the software interface (or directly write SQL statements), that is, manually input the t...

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/30
Inventor 黄长标
Owner TENCENT TECH (BEIJING) 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