Stack Rover Tech

Projects / ETL Data Warehouse

Case studyPublic

Open source

ETL Data Warehouse

A star-schema warehouse fed by an automated pipeline.

Reports off the transactional database, rebuilt safely on every run.

github.com/IgliHoxha
Aggregations read straight from the loaded star schema, synthetic data, from the project's README.

In the picture: Aggregations read straight from the loaded star schema, synthetic data, from the project's README.

Type
Open source
Status
Public
Stack
PHP, Symfony, Doctrine, MariaDB, Docker

Why we built it

Reports run on a transactional database slow it down and lie about history.

What it does

An automated Symfony ETL pipeline that builds and refreshes a star-schema warehouse.

How it is built

PHP, Doctrine and MariaDB, all in Docker.

Decisions worth noting

Facts and dimensions are rebuilt idempotently, so a failed run can simply run again.

All projectsOr write to hello@stackrover.tech