Geodesic
Embedding of the matrix profile concept into a relational DBMS for time series mining
Vestnik Ûžno-Uralʹskogo gosudarstvennogo universiteta. Seriâ Vyčislitelʹnaâ matematika i informatika, Tome 10 (2021) no. 3, pp. 72-87

Voir la notice de l'article provenant de la source Math-Net.Ru

Currently, large time series are used in a wide range of subject areas. Modern time series DBMSs (TSDBMS) offer, however, a modest set of built-in tools for data mining. The use of third-party time series mining systems to undesirable overhead costs for exporting data outside the TSDBMS, converting data and importing analysis results. At the same time, there is a topical issue of the embedding of data mining methods into relational DBMSs (RDBMS), which dominate the market of data management tools. However, there are still no developments of time series mining methods in RDBMS. The article proposes an approach to the management and mining of time series data within the RDBMS based on the matrix profile concept. A matrix profile is a data structure that, for each subsequence of a time series, stores the index of and the distance to its nearest neighbor. The matrix profile serves as the basis for detecting motifs, anomalies and other primitives of time series mining. The proposed approach is implemented in the PostgreSQL RDBMS. The experimental results showed a higher efficiency of the proposed approach compared to the TSDBMS InfluxDB and OpenTSDB.
Keywords: time series, PostgreSQL, InfluxDB, OpenTSDB.
Mots-clés : matrix profile 
@article{VYURV_2021_10_3_a4,
     author = {E. V. Ivanova and M. L. Zymbler},
     title = {Embedding of the matrix profile concept into a relational {DBMS} for time series mining},
     journal = {Vestnik \^U\v{z}no-Uralʹskogo gosudarstvennogo universiteta. Seri\^a Vy\v{c}islitelʹna\^a matematika i informatika},
     pages = {72--87},
     publisher = {mathdoc},
     volume = {10},
     number = {3},
     year = {2021},
     language = {ru},
     url = {http://geodesic.mathdoc.fr/item/VYURV_2021_10_3_a4/}
}
TY  - JOUR
AU  - E. V. Ivanova
AU  - M. L. Zymbler
TI  - Embedding of the matrix profile concept into a relational DBMS for time series mining
JO  - Vestnik Ûžno-Uralʹskogo gosudarstvennogo universiteta. Seriâ Vyčislitelʹnaâ matematika i informatika
PY  - 2021
SP  - 72
EP  - 87
VL  - 10
IS  - 3
PB  - mathdoc
UR  - http://geodesic.mathdoc.fr/item/VYURV_2021_10_3_a4/
LA  - ru
ID  - VYURV_2021_10_3_a4
ER  - 
%0 Journal Article
%A E. V. Ivanova
%A M. L. Zymbler
%T Embedding of the matrix profile concept into a relational DBMS for time series mining
%J Vestnik Ûžno-Uralʹskogo gosudarstvennogo universiteta. Seriâ Vyčislitelʹnaâ matematika i informatika
%D 2021
%P 72-87
%V 10
%N 3
%I mathdoc
%U http://geodesic.mathdoc.fr/item/VYURV_2021_10_3_a4/
%G ru
%F VYURV_2021_10_3_a4
E. V. Ivanova; M. L. Zymbler. Embedding of the matrix profile concept into a relational DBMS for time series mining. Vestnik Ûžno-Uralʹskogo gosudarstvennogo universiteta. Seriâ Vyčislitelʹnaâ matematika i informatika, Tome 10 (2021) no. 3, pp. 72-87. http://geodesic.mathdoc.fr/item/VYURV_2021_10_3_a4/