DuckDB: The SQLite for Analytical Workloads
Explore DuckDB, the in-process analytical database that runs anywhere, handles columnar storage efficiently, and brings analytics to where your data lives.
Posts tagged with #analytics
Joins and Aggregations: SQL Patterns for Data Analysis
Master SQL joins and aggregation techniques for building efficient analytical queries in data warehouses and analytical databases.
Data Warehousing
OLAP vs OLTP comparison. Star and snowflake schemas, fact and dimension tables, slowly changing dimensions, and columnar storage in data warehouses.
Time-Series Databases: Handling Time-Ordered Data
How to handle time-ordered data with InfluxDB and TimescaleDB — covering downsampling, retention policies, high-cardinality tags, and IoT analytics at scale.