#Oracle adventureworks database code#
#Oracle adventureworks database download#

DBpedia - Wikipedia data export project.- US federal government data collection, see also Sunlight Labs.OMDB - Open Media database, ~30MB compressed, 300MB when loaded.Freebase - Various wiki style data on places/people/things - ~600MB compressed.Benchmarking databases such as DBT-2 or TPC-H can be used as samples.MGI use PostgreSQL in production, providing direct protocol access to researchers, so the custom format dump is not an afterthought. MGI is the international database resource for the laboratory mouse, providing integrated genetic, genomic, and biological data to facilitate the study of human health and disease. Custom format dump, 1.9GB compressed, but restored database is tens of GB in size.

#Oracle adventureworks database code#

The code in some of the views demonstrates effective techniques for querying XML data. In addition to being a well-rounded OLTP sample, it is also a good choice to demonstrate ETL into a data warehouse. So it's big enough to be interesting, but not unwieldy. It represents a fictitious bicycle parts wholesaler with a hierarchy of nearly 300 employees, 500 products, 20000 customers, and 31000 sales each having an average of 4 line items. The result is 68 tables containing HR, sales, product, and purchasing data organized across 5 schemas. AdventureWorks 2014 for Postgres - Scripts to set up the OLTP part of the go-to database used in training classes and for sample apps on the Microsoft stack.Copy CSV data, with appropriate munging:Д¬OPY land_registry_price_paid_uk FROM '/path/to/pp-complete.csv' with (format csv, encoding 'win1252', header false, null '', quote ''', force_null (postcode, saon, paon, street, locality, city, district)) If schema changes/field added, consult: Д¬REATE TABLE land_registry_price_paid_uk(

#Oracle adventureworks database download#

Download file 'pp-complete.csv', which has all records.

The land registry file from has details of land sales in the UK, going back several decades, and is 3.5GB as of August 2016 (this applies only to the 'complete' file, 'pp-complete.csv').

PgFoundry had a collection of Postgres-compatible sample databases but it has not been updated since 2008.

Pagila is a more idiomatic Postgres port of Sakila.

Sakila has been ported to many databases including Postgres.

MySQL has a popular sample database named Sakila.

This has the advantage of being built-in and supporting a scalable data generator.

One trivial sample that PostgreSQL ships with is the Pgbench. A good intro to popular ones that includes discussion of samples available for other databases is Sample Databases for PostgreSQL and More (2006). Many database systems provide sample databases with the product.