Datasets: Data for Databases!

Test Databases

The following are contrived example databases, which are useful for testing out research ideas. They are all made available in the XMLSQL format of the DBLibrary package, which should be used to import then into a database. Note that you show use the "Save link as" option to download the XMLSQL file to prevent your browser attempting to interpret the xml file.

Name Description XMLSQL file
university1 Database of staff and departments in which they work download
university2 download
university3 download
university4 download
university5 download
university6 download
ansisql A small database that uses a range of ANSI SQL datatypes download

Real Databases

For teaching and research in the area of databases, it is useful to have available medium sized databases (meaning data measured in MB, rather than KB or GB) containing `real-world' information to test languages and tools on practical problems. This is a collection of information about how to prepare a relational database from various datasets that have been made publicly available. The first three listed (relational) databases are available online within the Computing Department at Imperial College.