Data Generation Language: Value Library

Table of Content

Value Library

The "Value Library" is a set of well-known data. It can be used by pattern engine (see $Lib and $LibGroup functions) to make generated data more realistic.

Currently, the library¹ contains the following data sets:

Data set	Table Name	Data Columns	Values²
World cities	Cities	Name, Country, State (for US cities only), State Code (for US cities only)	1263
Closing sizes	Closingsizes	Name	11
Color set	Colors	Name	143
Companies list	Companies	Name, ShortName, Domain	673
Countries list	Countries	Name, Code2, Code3, Capital, Currency, CurrencyCode	246
Week days	Days	Name,Code2,Code3,Idx	7
Sample company departments	Departments	Name	15
File types	FileTypes	Name, MimeType, Description	60
First names	FirstNames	Name, Sex	5146
First names national	FirstName_National	Name, LatinName, Sex, Country	631
Full names	FullNames	Name	373
Gender	Gender	Name, Abbr, Code	5
Sample industries	Industries	Name	41
World languages	Languages	Name, Code2, Code3	143
Last Name Samples	LastNames	Name	370
Legal forms	LegalForms	Name	15
Months	Months	Name	12
MeasureUnits	Name,Code	Name	340
Name prefixes	NamePreffix	Name	7
Name suffixes	NameSuffix	Name	8
Nationality	Nationality	Name	85
Sample occupations or positions	Occupations	Name	74
Region	Region	Name	4
Streets list	Streets	Name, Country	9185
US States	US_States	Name, Code, Capital	52
Zip codes	ZipCodes	Name, Country	670

the library has SQLite 3 physical format and can be modified by DTM data Editor or any compatible tool
the library database version 10-jan-2016.

Note: for most library functions call you can skip default column name ("Name").