sample_data

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
sample_data [2017/11/29 15:44] davidsample_data [2025/03/27 15:42] (current) – external edit 127.0.0.1
Line 1: Line 1:
 {{tag>sample_data}} {{tag>sample_data}}
  
 +Oracle (MySQL)
 +  * Sakila (DVD Rental, MySQL Sample): [[https://dev.mysql.com/doc/sakila/en/|Sakila Sample Database]] (licensed under the New BSD license)
 +  * Employees Sample Database: [[https://dev.mysql.com/doc/employee/en/|Employees Sample Database]] (licensed under the Creative Commons Attribution-Share Alike 3.0 Unported License)
 +
 +Jaffle shop (dbt sample):
 +  * [[https://github.com/dbt-labs/jaffle-shop]]
 +  * [[https://github.com/dbt-labs/jaffle-shop-classic]]
 +
 +General mixed data:
   * Wikimedia, data dumps: https://dumps.wikimedia.org/   * Wikimedia, data dumps: https://dumps.wikimedia.org/
 +  * https://en.wikiversity.org/wiki/Database_Examples
   * [[https://www.re3data.org/repository/r3d100010960|UCI Machine Learning Repository]]   * [[https://www.re3data.org/repository/r3d100010960|UCI Machine Learning Repository]]
 +
 +Adventure Works:
 +  * [[https://github.com/patricgruber/mysql-adventure-works-dw|mysql-adventure-works-dw]] - The Adventure Works Datawarehouse ported to MySQL
 +  * [[https://github.com/NorfolkDataSci/adventure-works-postgres|adventure-works-postgres]] - AdventureWorks for Postgres
 +
 +https://www.kaggle.com/datasets
 +  * https://www.kaggle.com/tunguz/big-five-personality-test
 +
 +Notes:
 +  * https://stackoverflow.com/questions/236478/where-i-can-download-sample-database-which-can-be-used-as-data-warehouse
 +  * https://www.sqlchick.com/entries/2011/10/3/places-to-download-sample-data.html
 +  * https://www.researchgate.net/figure/Sample-sales-data-warehouse-schema_fig2_221524861
 +  * https://www.quora.com/Where-can-I-get-huge-sample-data-for-data-warehouse-design
 +  * https://www.mysqltutorial.org/mysql-sample-database.aspx/
 +  * https://www3.ntu.edu.sg/home/ehchua/programming/sql/SampleDatabases.html
 +  * https://wiki.postgresql.org/wiki/Sample_Databases
 +
 +====== Mine ======
 +
 +  * [[https://github.com/d-roman-halliday/sql-and-data-notes-and-samples/tree/main/sample_and_test_data/simple_shop_model|Simple Shop Model]]
 +  * https://github.com/d-roman-halliday/simple_shop_data_generator - generator
  
 ---- ----
  • sample_data.1511970255.txt.gz
  • Last modified: 2025/03/27 15:42
  • (external edit)