Introduction to Time Series Databases

Type of course:

Digital learning, Lesson

Language:

Duration:

15 minutes

Workload:

1 hour

Proficiency:

Intermediate

Target:

Students, Workers

SUMMARY

Time Series Databases (TSDBs) are specialized databases that efficiently manage large volumes of time-stamped data, which is essential for monitoring, IoT, and sensor networks.

TSDBs come in two main types: SQL-based and NoSQL-based, with each offering distinct advantages. SQL databases are ideal for structured data and transactions, but may face scalability and performance challenges as the data grows. NoSQL databases, on the other hand, excel in scalability, flexibility, and performance for handling large datasets.

When selecting between SQL and NoSQL TSDBs, organizations need to consider data size, scalability, and query complexity to choose the optimal solution for their specific needs.

About The Author

Beia Consult International is a R&D performing SME, founded in 1991, and it is one of the leading providers of telecommunications equipment and solutions in Romania for enterprise cloud communications and telemetry. BEIA has gained experience in providing trainings for different verticals, such as: green and digital transformation, blue economy, resource efficiency in manufacturing, etc. by participating in different projects aiming to provide education and training to the users.

Ioana Petre is a telecommunications engineer having experience in R&D&I projects for more than 7 years.

Learning outcomes

Explain Time Series Database Concepts – By the end of this course, learners will describe the purpose, structure, and key features of TSDBs, including data compression, aggregation, and retrieval.
Compare SQL and NoSQL TSDBs – Within the course duration, learners will analyze and contrast SQL-based (e.g., MySQL, PostgreSQL) and NoSQL-based (e.g., InfluxDB, MongoDB) time series databases based on performance, scalability, and query capabilities.
Select the Best TSDB for a Use Case – By the end of the course, learners will evaluate real-world scenarios and justify the use of either SQL or NoSQL TSDBs based on data volume, query complexity, and scalability.