melsigl
commented
2 years ago ERP sample databases:
- AdventureWorks for Microsoft SQL Server as well as for PostgreSQL. Fictious bike parts dealer, database contains 68 tables (HR, sales, product, purchases), 5 schemas, around 300 employees, 500 products, 20,000 customers, and 31,000 sales.
- Wide World Importers. Also available for PostgreSQL. Documentation on Microsoft Docs. Fictitious company is a wholesale goods importer and distributor, primarily selling to resellers. Database contains four schemas (pruchase, sales, warehouse transactions, application). See database catalog for more information on schemas and tables.
- Northwind, also available for PostgreSQL. Another ERP sales sample database.
dominik-probst
Motivation Exercises are based on datasets. While every exercise could be based on its own dataset, one dataset used by all exercises groups (e.g. Association Rules, Classification, Clustering, Outlier) is desirable. For instance a sales dataset originated from some ERP/DWH system similar to the one dataset referenced in the book of Han et. al ("Data Mining").
Definition of Done Specify datasets for some lectures as well as one dataset that acts as a common theme throughout the semester.
Tasks