🎁 New User? Get 20% off your first purchase with code NEWUSER20 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

SQL
Structured Query Language — the standard language for managing and querying data in relational databases.
Foreign Key
A column that creates a link between two tables by referencing the primary key of another table.
Cursor
A database object that enables row-by-row processing of query results, useful for operations that cannot be done in bulk.
Vacuum
A PostgreSQL maintenance operation that reclaims storage from dead tuples and updates statistics for the query planner.
CTE (Common Table Expression)
A temporary named result set defined within a SQL statement using the WITH clause, improving query readability and enabling recursion.
PostgreSQL
An advanced open-source relational database known for its reliability, feature richness, and standards compliance.
 View All Databases Terms →