Topic

#Data Engineering

9 posts tagged “Data Engineering”.

The Lycoris Team The Lycoris Team · · 4 min read

Data Warehouse vs Data Lake: What's the Difference?

A data warehouse stores structured, pre-modeled data optimized for queries; a data lake stores raw data of any shape. When each one fits.

#Databases #Data Engineering #Backend
The Lycoris Team The Lycoris Team · · 4 min read

Star Schema vs Snowflake Schema: Which to Use

Star schema denormalizes dimensions into flat tables for fast queries; snowflake schema normalizes them to save space. How to choose for your warehouse.

#Databases #Data Engineering #Backend
Chisato Chisato · · 4 min read

Time-Series Databases Explained

A time-series database is optimized for timestamped data — metrics, sensor readings, prices. How it differs from general-purpose databases.

#Databases #Data Engineering #Backend
The Lycoris Team The Lycoris Team · · 5 min read

What Is a Graph Database?

A graph database stores data as nodes and relationships instead of tables, making deeply connected queries fast instead of a chain of costly joins.

#Databases #Data Engineering #Backend
Chisato Chisato · · 4 min read

ETL vs ELT: How Modern Data Pipelines Work

ETL transforms data before loading it into a warehouse; ELT loads raw data first and transforms it inside the destination. How the two approaches differ.

#Databases #Data Engineering #Backend
The Lycoris Team The Lycoris Team · · 4 min read

Data Lakehouse Explained: What It Is and How It Works

A data lakehouse combines a data lake's cheap object storage with a data warehouse's transactional guarantees and schema. How the architecture works.

#Databases #Data Engineering #Backend
The Lycoris Team The Lycoris Team · · 4 min read

Columnar vs. Row-Oriented Databases

Row-oriented databases store each record together on disk; columnar databases store each column together. The layout decides which workloads are fast.

#Databases #Data Engineering #Backend
The Lycoris Team The Lycoris Team · · 4 min read

What Is Change Data Capture (CDC)? Explained

Change data capture streams row-level inserts, updates, and deletes out of a database in real time, powering sync pipelines, caches, and event-driven systems.

#Databases #Data Engineering #Backend

← All topics