Basic data generation method and device and test data generation method and device
What is Al technical title?
Al technical title is built by PatSnap Al team. It summarizes the technical point description of the patent document.
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
This helps you quickly interpret patents by identifying the three key elements:
Problems solved by technology
Method used
Benefits of technology
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
Click on the blue label to locate the original text in one second.
Reading with bidirectional positioning of images and text.
Smart Image
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
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
Application Date:The date an application was filed.
Publication Date:The date a patent or application was officially published.
First Publication Date:The earliest publication date of a patent with the same application number.
Issue Date:Publication date of the patent grant document.
PCT Entry Date:The Entry date of PCT National Phase.
Estimated Expiry Date:The statutory expiry date of a patent right according to the Patent Law, and it is the longest term of protection that the patent right can achieve without the termination of the patent right due to other reasons(Term extension factor has been taken into account ).
Invalid Date:Actual expiry date is based on effective date or publication date of legal transaction data of invalid patent.
Login to view more 
Login to view more