🎁 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

Deadlock
A situation where two or more transactions permanently block each other by each holding locks that the other needs.
Foreign Key
A column that creates a link between two tables by referencing the primary key of another table.
Schema
The structure definition of a database including tables, columns, data types, relationships, indexes, and constraints.
Window Function
An SQL function that performs calculations across a set of rows related to the current row without collapsing the result set.
Trigger
A database object that automatically executes a specified function when certain events (INSERT, UPDATE, DELETE) occur on a table.
ORM (Object-Relational Mapping)
A technique that lets you interact with a database using object-oriented code instead of writing raw SQL queries.
 View All Databases Terms →