How can i generate synthetic data for a relational database?

Question

what algorithms are used to generate synthetic but real data.

How can i generate synthetic (human) names without storing some sort of file for the names.

How can i also generate Binary large objects such as pictures that have the same characteristics as the real deal?

References to algorithms that i should use will be appreciated.

Answer 1

If you want it real, it can't be generated, because if you generate the data (such as a random number generator), it may not represent a real population of data.  Sorry, but the best I can suggest is to use a loop with a random number generator that creates a random number, then stores the random number in the database.  OR, you can use the random number generator, then use THAT number as a loop index counter, then create random numbers 1 through 26, replace the number with the alphabetic characters, and concatenate them through each iteration of the loop to make a long string, and that string of characters could represent a name.  But it will be gibberish.  But you could do that twice, once for the first name, again for the last name, and separate them with a space in the Name field that you store in the database.  Otherwise, there is no way to generate random REAL names.  Sorry.