🎁 New User? Get 20% off your first purchase with code NEWUSER20 · ⚡ Instant download · 🔒 Secure checkout Register Now →
Menu

Categories

Databases Intermediate

What is Time-Series Database?

A database optimized for storing and querying timestamped data points like metrics, sensor readings, and event logs.

Time-series databases are specialized for data that arrives sequentially over time. They optimize for high write throughput, time-range queries, and downsampling/aggregation. Examples include TimescaleDB (PostgreSQL extension), InfluxDB, Prometheus (for metrics), and QuestDB. Key features include automatic partitioning by time, built-in aggregation functions (moving averages, percentiles), data retention policies, and compression. They are essential for IoT, monitoring, financial data, and any application tracking changes over time.

Related Terms

Schema
The structure definition of a database including tables, columns, data types, relationships, indexes, and constraints.
Connection String
A formatted string containing all parameters needed to establish a connection to a database server.
Materialized View
A database object that stores the precomputed result of a query, offering faster reads at the cost of periodic refresh.
Stored Procedure
A precompiled collection of SQL statements stored in the database that can be executed as a single unit.
Write-Ahead Log (WAL)
A technique where changes are first written to a log before being applied to the database, ensuring crash recovery and data integrity.
Upsert
A database operation that inserts a new row if it does not exist, or updates the existing row if it does.
 View All Databases Terms →