Re: tool to generate dummy data

If DSS type data is acceptable, go to www.tpc.org and get the tpc-d toolkit. You can download it for free after a free registration. It consists of source "c" that makes two utilities: a data generator and a query generator. Also it has some ddl scripts to build a small schema - eight tables, I recall.

The data generator allows you to create integrity-consistent relational data that is sized as a fraction of an arbitraty base size of about 1 gigabyte. That is, you can generate a size of .1 and get ~100 megabytes of data. The query generator then creates all tpc-d queries with predicates that make sense for the randomly generated data.

Great benchmarking tool. Just like the real guys!

Roger Snowden

winman9793_at_my-dejanews.com wrote:
>
> Hello...
> Does anyone know of a tool to generate dummy data?
>
> I've just checked out Platinum's TestBytes, which (if it was working
> correctly, and had a better interface) would be the ticket...are there
> similar products to this out there?
>
> thanks,
> Win Lockwood
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Feb 26 1999 - 02:12:14 CET