Time series databases overview

S.V. Gavrikova


This article examines time series as a data type, its use in the Internet of Things (IoT), and the most popular time series storage platforms (time series databases). Currently, the Internet of Things is in dire need of efficient and optimized time series databases and management systems to deal with heterogeneous data. Time series database management systems (DBMS) are the second most popular category on db-engines.com. The basis for the selection of databases for analysis was mainly the top part of the db-engines.com DBMS rating. The article discusses database structures, data aggregation capabilities, scaling flexibility, storage optimization, security, the ability to use auxiliary tools, query syntax, including examples with time series obtained from sensors. The main goal of this work is to study real-life platforms with their pros and cons, highlight the need for an informed approach to choosing a tool, as well as the critical importance of finding innovative technologies for storing time series for the future of the entire digital society.

Full Text:

PDF (Russian)


Smirnov, Sergej Vladislavovich “Bazy dannyh vremennyh rjadov.Paket Data Guide”:Ucheb.-metod.posobie / Otv.red.M.I.Lugachev; "Vsesojuz.jekon.ob-vo. Centr “Jekonomicheskaja kibernetika”,Jekon.fak.i dr. M. : Izd-vo Mosk.un-ta, 1991. c.7

Brillindzher, David R. “Vremennye rjady : Obrabotka dannyh i teorija” / D.R. Brillindzher ; Per. s angl. A.V. Bulinskogo, I.G. Zhurbenko ; Pod red. A.N. Kolmogorova M. : Mir, 1980. -S.7, 13, 19, 49.

Grigor'ev, Jurij Aleksandrovich “Reljacionnye bazy dannyh i sistemy NoSQL” : ucheb. posobie. / Grigor'ev Ju. A., Plutenko A. D., Pluzhnikova O. Ju.. - Blagoveshhensk : Amur. gos. un-t, 2018. -S. 19, 304-307, 323, 331-337.

Arhipenkov, Sergej Jakovlevich. “Hranilishha dannyh : Ot koncepcii do vnedrenija” / S.Arhipenkov,D.Golubev,O.Maksimenko;Pod.red.S.Arhipenkova M. : Dialog-MIFI, 2002. 1: c.23-25

Namiot D. E. Bazy dannyh vremennyh rjadov i sredstva obrabotki //Aktual'nye problemy sistemnoj i programmnoj inzhenerii: Materialy. – 2015. – S. 151-158.

Oficial'nyj sajt: https://www.influxdata.com/ Data dostupa: 18.07.23

DB Engines Oficial'nyj sajt: https://db-

engines.com/en/ranking/time+series+dbms Data dostupa: 2.10.23

Kdb Oficial'nyj sajt: https://code.kx.com/q4m3/14_Introduction_to_Kdb%2B/ Data dostupa: 18.08.23

OpenTSDB Oficial'nyj sajt: http://opentsdb.net/overview.html Data dostupa: 29.07.23

Prometeus Oficial'nyj sajt: https://prometheus.io/docs/prometheus/latest/storage/ Data dostupa: 2.08.23

TimeScale Oficial'nyj sajt: https://www.timescale.com/products Data dostupa: 12.08.23

Amazon S3 Oficial'nyj sajt: https://aws.amazon.com/ru/s3/ ,Data dostupa: 16.08.23

Daily U.S Equity Matched Volumes (millions, includes CS2), NYSE Dostupno: https://www.nyse.com/markets/us-equity-volumes Data dostupa: 16.03.23

PostgreSQL, The Time-Series Database You Want by Chris Engelbert. Dostupno: https://www.youtube.com/watch?v=k1xVlS6hdxU Data dostupa: 20.08.23

PostgreSQL Oficial'nyj sajt: https://www.postgresql.org/ Data dostupa: 18.08.23

T. W. Wlodarczyk. Overview of Time Series Storage and Processing in a Cloud Environment. In Proceedings of the 2012 IEEE 4th International Conference on Cloud Computing Technology and Science (CloudCom), pages 625–628. IEEE Computer Society, 2012

Oficial'nyj sajt: https://graphiteapp.org/ Data dostupa: 24.08.23

Alternatives to Time Series Databases, HAZELCAST. Dostupno: https://hazelcast.com/glossary/time-series-database/#:~:text=Relational%20database%20management%20systems%20 Data dostupa: 02.09.23

Prezentacija “Prometheus kak time series database”, Timur Nurutdinov (Lamoda) Dostupno: https://youtu.be/5g6NAKzTKTs Data dostupa: 15.05.23

Yandex Cloud Oficial'nyj sajt: https://cloud.yandex.com/en/services/ydb Data dostupa: 15.09.23

Yandex Clickhouse Oficial'nyj sajt: https://yandex.ru/dev/clickhouse/ Data dostupa: 15.09.23

RAID-massivy, studme.org Dostupno: https://studme.org/97217/informatika/raid-massivy Data dostupa: 23.09.23

Oficial'naja dokumentacija: https://graphite.readthedocs.io/en/latest/whisper.html , https://graphite.readthedocs.io/en/latest/functions.htm Data dostupa: 23.08.23

“Model' Hol'ta-Uintersa: Matematicheskie aspekty i komp'juternaja realizacija” © 2016 M.G. Semenenko, kandidat fiziko-matematicheskih nauk, docent kafedry «Vysshaja matematika» L.A. Untilova, starshij prepodavatel' kafedry «Jekonomika i organizacija proizvodstva» Kaluzhskij filial Moskovskogo gosudarstvennogo tehnicheskogo universiteta imeni N.Je. Baumana, Kaluga (Rossija) Dostupno: https://www.vektornaukieconomika.ru/jour/article/view/208/200 Data dostupa: 8.10.23

AWS Oficial'naja dokumentacija: https://docs.aws.amazon.com/pdfs/lambda/latest/dg/lambda-dg.pdf Data dostupa: 7.09.23

Clickhouse SQL Oficial'nyj sajt: https://clickhouse.com/docs/en/sql-reference Data dostupa: 7.09.23

MongoDB Oficial'naja dokumentacija: https://www.mongodb.com/docs/v7.0/core/timeseries/timeseries-procedures/#std-label-manual-timeseries-collection-create Data dostupa: 10.09.23

Oficial'nyj sajt: https://www.mongodb.com/use-cases/internet-of-things Data dostupa: 2.09.23

Harizopoulos S., Abadi D.J., Madden S., Stonebraker M. OLTP through the looking glass, and what we found there // Making Databases Work: the Pragmatic Wisdom of Michael Stonebraker / Ed. by Brodie M.L. ACM / Morgan & Claypool, 2019. P. 409–439. DOI: 10.1145/3226595.3226635.

Queiroz-Sousa P.O., Salgado A.C. A review on OLAP technologies applied to information networks // ACM Trans. Knowl. Discov. Data. 2020. Vol. 14, no. 1. P. 8:1–8:25. DOI: 10.1145/3370912.

Ivanova E.V., Cymbler M.L. “Obzor sovremennyh sistem obrabotki vremennyh rjadov” // Vestnik JuUrGU. Serija: Vychislitel'naja matematika i informatika. 2020. T. 9, No 4. S. 79–97. DOI: 10.14529/cmse200406.

«Gorilla: A Fast, Scalable, In-Memory Time Series Database» Tuomas Pelkonen, Scott Franklin, Justin Teller, Paul Cavallaro, Qi Huang, Justin Meza, Kaushik Veeraraghavan Dostupno: http://www.vldb.org/pvldb/vol8/p1816-teller.pdf Data dostupa: 8.10.23

HBASE Oficial'nyj sajt: http://hbase.org/ Data dostupa: 2.10.23

HighCharts https://www.highcharts.com/ Data dostupa: 2.10.23


  • There are currently no refbacks.

Abava  Кибербезопасность IT congress 2023

ISSN: 2307-8162