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.

Learn More About This Topic

Database Design & Modeling Fundamentals

Related reading

PostgreSQL Database Setup: The Complete Guide

Related reading

MongoDB Fundamentals: Building Scalable NoSQL Applications with Document Databases

Related reading

Related Terms

CTE (Common Table Expression)

A temporary named result set defined within a SQL statement using the WITH clause, improving query readability and enabling recursion.

An advanced open-source relational database known for its reliability, feature richness, and standards compliance.

Structured Query Language — the standard language for managing and querying data in relational databases.

An open-source, in-memory data store used as a database, cache, message broker, and queue with sub-millisecond response times.

Full-Text Search

A technique for searching natural language text in databases using word stemming, ranking, and relevance scoring.

A query that transforms rows into columns, creating a pivot table view of aggregated data.

View All Databases Terms →