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

Basic data generation method and device and test data generation method and device

A basic data and data generation technology, applied in the field of data processing, can solve the problems that the test data cannot reflect the dependencies between data, the rules are limited, and the test data generation efficiency is low

Active Publication Date: 2015-05-13
联动优势电子商务有限公司
View PDF7 Cites 36 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] When using the above-mentioned first method to enter test data, the generation efficiency of test data is low; when using the above-mentioned second method to randomly generate data, due to the limited rules specified by the script, the entered test data cannot reflect the dependencies between the data

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
  • Basic data generation method and device and test data generation method and device
  • Basic data generation method and device and test data generation method and device
  • Basic data generation method and device and test data generation method and device

Examples

Experimental program
Comparison scheme
Effect test

example 1

[0143] Example 1: To generate employees' birth dates within the range of 1960 to 1990, define the syntax:

[0144] "X": "birthday", indicating that X corresponds to the "birthday" field;

[0145] "Ref": "null", if the generated data dependent field is null, it means that it does not depend on other fields;

[0146] "Scope": "19600101<=X<=19901231", indicating that the generation range is from January 1, 1960 to December 31, 1990

[0147] "Type": "date", the target generation type is date type, and the default format is "YYYY-MM-DD"

[0148] "Format": "YYYY / MM / DD", set the generated format, if not specified, use the default format;

example 2

[0149] Example 2: Generate employee ID number, use birthday to generate the result and convert it into the year, month, and day in the middle of the ID number, define the syntax:

[0150] "X": "identification", indicating that X corresponds to the "identification" field;

[0151] "Ref": "birthday", specifying that when X is generated, it depends on the generation result of the "birthday" field;

[0152] "Scope": "tochar(rand(100000,900000),'######')+Ref+tochar(rand(1000,9000),'####')", refers to the use of the first six and the last four Random number generation, rand is a random function, the range of numbers in parentheses is the range of random number generation, and the generated random numbers are directly converted into characters. During the conversion process, there are not enough digits in the front to fill with zeros, and the reference field is assembled in the middle to generate;

[0153] "Type": "char", the target generation type is character type;

[015...

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 basic data generation method and device and a test data generation method and device. Configuration information of a data table is obtained from a service database; a data dictionary is configured according to the configuration information of the data table in the service database, wherein the data dictionary includes definition information of test data fields; data generation strategy is configured aimed at the test data fields, wherein dependent constraint conditions between the test data fields are defined in the data dictionary and / or the data generation strategy; the test data are generated according to the data dictionary and the data generation strategy, and the generated test data are stored in N basic data pools, wherein N is larger than 1, the test data stored in the basic data pools meet the uniqueness requirement, and the types of the test data stored in different basic data pools are different. Basic data of the test data can be generated according to the dependent relationship between the data, and the dependent relationship between the data is embodied.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a method for generating basic data, a method for generating test data and a device thereof. Background technique [0002] A Data Warehouse (DW) is a strategic collection of all types of data that support decision-making at all levels of an enterprise. The data in the data warehouse is processed through data warehouse technology (Extract-Transform-Load, ETL), that is, on the basis of extracting and cleaning the original scattered database data, and then processing, summarizing and sorting through the system. Data warehouse technology is used to describe the process of extracting, transforming, and loading data from the source to the destination. [0003] Business Intelligence (BI) is used to effectively integrate the existing data in the enterprise, quickly and accurately provide reports and propose decision-making basis. BI system construction performs a large amount of...

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 Applications(China)
IPC IPC(8): G06F17/30G06F9/44
CPCG06F16/25
Inventor 赵军姜名峰陈飞
Owner 联动优势电子商务有限公司
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com