#

cumulative-table-design

Here are 2 public repositories matching this topic...

Hanagojiv / Cumulative_Table_Design

Modeling your data in cumulative fashion would help aggregate data over time, typically at a specific grain(daily, weekly, yearly, etc). It is designed to optimize performance for analytical queries that require pre-aggregated data, such as trends or summaries over time.

postgresql bootcamp dataengineering cumulative-table-design

Updated Dec 11, 2024

joelquartey / retail-sales-sql-project

A SQL-only ETL data infrastructure

views sql functions postgresql data-warehouse data-modeling stored-procedures triggers common-table-expression slowly-changing-dimension cumulative-table-design dimensional-data-modeling

Updated Feb 24, 2025
PLpgSQL

Improve this page

Add a description, image, and links to the cumulative-table-design topic page so that developers can more easily learn about it.

Curate this topic

Add this topic to your repo

To associate your repository with the cumulative-table-design topic, visit your repo's landing page and select "manage topics."