Sample databases

This is a convenience translation - license texts remain in their English originals; the German version of this page is authoritative.

The DI² demo environment hosts established, freely available sample databases. This page lists the datasets used, their licenses and the required attributions.

Last updated: 3 May 2026

1. What this is about

DI² is an ETL generator. So that demo walkthroughs work against real schemas - and so that generator output stays verifiable against data-type variety (jsonb, geometry, partitioned tables, triggers, views) - six established sample databases run alongside the app on the DI² demo infrastructure.

All datasets listed here are available under open licenses and are used without modification. The canonical repo reference with full license texts lives in third-party-notices.md.

2. Pagila (PostgreSQL)

PostgreSQL port of the Sakila schema with DVD-rental data. Provides jsonb, partitioned tables and full-text search as a test surface.

• Source: github.com/devrimgunduz/pagila
• License: PostgreSQL License (BSD-style) · functionally equivalent to MIT
• Copyright: Devrim Gündüz; derived from Sakila © 2006 MySQL AB / Mike Hillyer

3. PostGIS NYC Workshop (PostgreSQL)

Geospatial data for New York City - neighborhoods, streets, subway stations, census blocks, homicides - in SRID 26918 (NAD83 / UTM zone 18N).

• Source: postgis.net/workshops/postgis-intro
• License: CC-BY-SA 3.0 US
• Copyright (workshop): © 2012-2023 Paul Ramsey, Mark Leslie and PostGIS contributors

4. WideWorldImporters (Microsoft SQL Server)

Microsoft B2B wholesaler sample with geography columns, temporal tables and stored procedures.

• Source: github.com/microsoft/sql-server-samples
• License: MIT License
• Copyright: © Microsoft Corporation

5. AdventureWorks 2022 (Microsoft SQL Server)

Classic Microsoft OLTP sample DB for retail / HR / production.

• Source: learn.microsoft.com/sql/samples/adventureworks
• License: MIT License
• Copyright: © Microsoft Corporation

6. Sakila (MySQL)

MySQL-native DVD-rental schema with triggers, views and stored procedures. Enables direct cross-dialect comparisons to Pagila.

• Source: dev.mysql.com/doc/sakila
• License: New BSD License (3-clause) - applies to the SQL files
• Copyright: © 2006, MySQL AB

The BSD 3-clause prohibits creating an endorsement impression with the name MySQL AB / Sakila contributors. DI² therefore names Sakila factually as a sample DB used - without a MySQL logo or “powered by” wording.

7. Natural Earth (MySQL - Country/City)

Country / city / population data worldwide with correct UTF-8 diacritics. Replaces the originally intended MySQL World DB, whose Oracle license would have prohibited redistribution.

• Source: naturalearthdata.com
• License: Public Domain

Made with Natural Earth. Free vector and raster map data @ naturalearthdata.com.

8. Trademark notices

The logos and brand glyphs shown on this page and on the homepage are the property of their respective trademark holders. DI² uses them exclusively for identifying purposes - no sponsorship, no endorsement, no business relationship is implied thereby.

• PostgreSQL and the elephant logo are registered trademarks of the PostgreSQL Community Association of Canada. Logo SVG path sourced from the Simple Icons project (CC0 for the path data).
• Microsoft and SQL Server are trademarks of the Microsoft Corporation. Microsoft's brand guidelines prohibit third-party use of the SQL Server logo. DI² therefore shows a generic database icon instead (lucide-react, ISC license) in the brand colour of SQL Server.
• MySQL and the dolphin logo (“Sakila”) are trademarks of the Oracle Corporation. Logo SVG path sourced from the Simple Icons project (CC0 for the path data). DI² is not affiliated with Oracle or the MySQL project.
• PostGIS is a trademark of the OSGeo Foundation / the PostGIS project.

Full license texts and repo reference: third-party-notices.md in the repository root. Questions or notes on attributions: Legal notice & contact.