Improve random data generator so varchar2s are not random garbage

mwrynn / plsql-table

The mwrynn PL/SQL Table API - Provides a "table_obj" that is linked to a table; the object has many functions that perform convenient operations, such as disabling/enabling all indexes, generation of random dummy data (random garbage as well as randomly select parent keys for foreign key columns), dynamic query generation - especially useful to handle burdensome column lists

GNU General Public License v3.0

1 stars 1 forks source link

Improve random data generator so varchar2s are not random garbage #16

Open mwrynn opened 3 years ago

mwrynn commented 3 years ago

Make categories of strings and select random values from a predetermined list and/or random syllables/full words that at least look realistic:

first name
last name
full name
city name
US state name
country name
company name ("ABC Inc.", "Generic Co.", "Dummy LLC." etc.)
others?

Perhaps pass the function a cardinality/uniqueness parameter. i.e. do we want all values to be unique, or an acceptable percentage to be duplicates. So maybe something like: "generate 10000 full names, 2% can be duplicate" or 0% duplicate would mean unique.

mwrynn commented 2 years ago

Steps for supporting this fake data:

Obtain/create first name csv and place in a new csv/ dir
Obtain/create last name csv
Obtain/create state csv
Obtain/create city csv (columns are city and state)
Obtain/create fake (maybe just use real ones?) company names csv (columns are city and state)
Need script to create tables for these CSVs and load them
Flag on existing functions to select one of these types instead of random garbage? Need to figure that out.