tags:

views:

51

answers:

2
+1  Q: 

free public databases with non-trivial table structures?

I'm looking for some sample database data that I can use for testing and demonstrating a DB tool I am working on. I need a DB that has (preferably) many tables, and many foreign key relationships between the tables.

Ideally the data would be in SQL dump format, or at least in something that maintains the foreign key references, and could be easily imported into an RDBMS (MySQL or H2).

The dataset itself doesn't have to be huge (in fact, best if it's not). I thought about using the Stackoverflow Data Dump, but it's only about 5 tables.

+1  A: 

What about using the entire Wikipedia database?

webdestroya  2010-06-01 03:57:23
And if that's too big (quite possible), maybe the "current versions only" dump.
Matthew Flaschen  2010-06-01 03:59:18
Hmm, I actually considered that, but the *compressed* "pages-articles" archive is 5.7GB, is XML, and I'm not quite sure which tables it includes. I'm afraid it'll be a bit unwieldy.
Caffeine Coma  2010-06-01 04:14:47
@Caffeine Coma - The pages one only includes the pages table. And uncompressed I think it is rather huge. But you can get the other tables as well.
webdestroya  2010-06-01 04:16:03
+1  A: 

I should learn to RTFM- MySQL has a sample database for exactly this kind of thing. It's called Sakila. It's small, but it does have a good number of connected tables. I'm still eager to hear more suggestions though.

Caffeine Coma  2010-06-01 11:52:49
Maybe browse some of the open source projects on SourceForge to see if any of them come with a database you can use.
Martin Smith  2010-06-01 12:02:32

related questions

What language do you use for Postgresql triggers and stored procedures?
Are Multiple DataContext classes ever appropriate?
Which tools do people use to create Data Dictionaries?
Any experiences with Protocol Buffers?
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
How do I index a database field
How does database indexing work?
How do I connect to a database and loop over a recordset in C#?
Editing database records by multiple users
Object Oriented vs Relational Databases
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
Embedded Database for .net that can run off a network
Connect PHP to an AS/400
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
.NET Migrations Engine
Is there a version control system for database structure changes?
SQLite and XSD
How do I version my MS SQL database in SVN?
XSD DataSets and ignoring foreign keys
Flat File Databases in PHP
Throw Error In MySQL Trigger
Binary Data in MySQL