🎁 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

Redis
An open-source, in-memory data store used as a database, cache, message broker, and queue with sub-millisecond response times.
JOIN
An SQL operation that combines rows from two or more tables based on a related column between them.
Database Connection Pooling
A technique that maintains a cache of database connections for reuse, reducing the overhead of creating new connections.
Data Warehouse
A centralized repository optimized for analytical queries that integrates data from multiple operational sources.
Migration
A version-controlled change to a database schema that can be applied and reversed systematically.
Materialized View
A database object that stores the precomputed result of a query, offering faster reads at the cost of periodic refresh.
 View All Databases Terms →