Re: Sample databases?

Thomas Lockhart wrote:
>  
> > Perhaps we can create a substantial test database? (Millions of records,
> > many tables, and a number of relations.) So when we see a problem, we
> > can all see it right away. I like "real world" data, because it is often
> > more organic than randomized test data, and brings out more issues. Take
> > index selection during a select, for instance.
> 
> The regression database is such a beast, but is not large enough for the
> millions of records kinds of tests.
> 
> Suggestions?
> 

maybe the Tiger database.  it's certainly big enough & freely
available.  if you're not familiar with tiger, it's a street database
from the census department.  you can find it at
ftp://ftp.linuxvc.com/pub/US-map.  it's in plain text format, but
trivial to import.  it's set up in several (at least a dozen tables)
which are heavily interrelated & sometimes in fairly complex ways.

-- 

Jeff Hoffmann
PropertyKey.com