Technical GlossaryData Engineering and AI Infrastructure

Star Schema

A classic analytical warehouse design with a central fact table surrounded by dimension tables.

The star schema is one of the most recognizable and practical designs in dimensional modeling. A measurement-focused fact table sits at the center, surrounded by dimension tables such as customer, time, product, or location. This structure provides strong advantages for BI tools and user-friendly querying. Because it balances simplicity, performance, and clarity, it is widely used in enterprise reporting.

Explore these concepts to continue your artificial intelligence journey.

See All

SÖZLÜK

🤖

veri-muhendisligi-ve-ai-altyapisi

ETL

A classic data integration approach in which data is extracted from source systems, transformed, and then loaded into a target analytical environment.

Explore

SÖZLÜK

🤖

veri-muhendisligi-ve-ai-altyapisi

ELT

A modern approach in which data is loaded into the target platform first, and transformations are performed later inside the storage or compute layer.

Explore

SÖZLÜK

🤖

veri-muhendisligi-ve-ai-altyapisi

Reverse ETL

An integration approach that moves curated data from analytics platforms back into operational systems.

Explore

See All

Star Schema

You Might Also Like

ETL

ELT

Reverse ETL

Subscribe to Newsletter