demo_rules: Rules for data generation

Description Usage Format

Description

A dataset contains rules to generate attributes (columns) of tables (datasets)

Usage

1

Format

A dataframe with following variables

Table

Table (Dataset) Name for the result. Result is returned as list of dataframes, list names conform to Table values from rules.

Attribute

Attribute (Column) Name for generated result

Attribute.Length

Maximum length of attribute; mandatory for Number and optional fore Varchar

Attribute.Length

Maximum number of digits in decimal part of number; mandatry for Number

Attribute.Type

Data Type of attribute; can be Number, Date or Varchar. Date attributes must be in specific format "YYYYMMDD"

Evaluation.Sequence

Defines order in which attributes are being generated. Attributes without sequence receive Sequence = 0. In case Evaluation.Condition or Evaluation.Expression refer to other attributes it is important to define correct sequence.

Evaluation.Condition

Expresstion that returns either FALSE or TRUE; empty condition is treated as truth.

Value.Type

Defines the way how value is being generated. Can be of following values: Empty (Empty value); Fixed (Fixed value, the same for all records of dataset); Expression (Calculated value based on formula); Random (Randomly generated value); LOV (Value picked from list of values).

Fixed.Value./.Offset

Defines fixed value for Fixed value type or offset for Random value type, offset is being added to random value.

List.Of.Values

Name of list with values. List of values must be existing one for successful value generation

Random.Distribution

Name of random distribution; must be specified for attributes with Value.Type = Random

Mean

Random distribution mean; must be specified for attributes with Value.Type = Random

Standard.Dev

Random distribution standard deviation; must be specified for attributes with Value.Type = Random

Sign

Sign Type for randomly generated value; must be specified for attributes with Value.Type = Random. Sometimes it is important to have values of only specific sign. Possible values are: Any (keep avlue as it is); Not Negative (replace negative values with 0); Not Positive (replace positive values with 0); Flip Negative (replace negative values with positive counterparts); Flip Positive (replace positive values with negative counterparts);

Evaluation.Expression

Expression that returns value; must be specified for attributes with Value.Type = Expression


EvgenyPetrovsky/synthezator documentation built on May 23, 2019, 7:17 a.m.