I think a tool like this should be able to inspect the real database and model the columns statistically. If my salary info is distributed a certain way I would

I think a tool like this should be able to inspect the real database and model the columns statistically. If my salary info is distributed a certain way I would like the fake data to have the same distribution. A tool could also build language models of my text columns to generate random names that seem like real names. Ideally the tool could start to analyze relationships between tables and columns and produce data that preserved those relationships in a statistical way. For example if in production each customer has 5 orders on average then so could the test data. I'm not sure what you could do with clobs or xml data in columns but I guess some stuff would remain opaque. I could see this tool being useful to enable you to move your test code to the cloud w/o revealing any private data to third parties. Studying a model like this could also help new developers come up to speed on the system.