🎁 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

Data Warehouse
A centralized repository optimized for analytical queries that integrates data from multiple operational sources.
Stored Procedure
A precompiled collection of SQL statements stored in the database that can be executed as a single unit.
Schema
The structure definition of a database including tables, columns, data types, relationships, indexes, and constraints.
Database Proxy
A middleware server that sits between applications and databases, providing connection pooling, load balancing, and query routing.
Window Function
An SQL function that performs calculations across a set of rows related to the current row without collapsing the result set.
Database Backup
The process of creating copies of database data to protect against data loss from failures, corruption, or human error.
 View All Databases Terms →