Time Series, a Neglected Issue in Temporal Database Research?

Schmidt, Duri; Dittrich, Angelika Kotz; Dreyer, Werner; Marti, Robert W.

doi:10.1007/978-1-4471-3033-8_12

Cited by 18 publications

(5 citation statements)

References 2 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…They exemplify it using financial data. In [6] Calanda is compared with temporal systems designed for time series.…”

Section: Database Approachesmentioning

confidence: 99%

“…Bitemporal data manages historical data and events in databases by associating pairs of valid and transaction time intervals to data. Bitemporal data and time series data are not exactly the same, and so they cannot be treated interchangeably [6], however, there are some similarities that can be considered. DBMS research represents bitemporal data as relations extended with time intervals attributes and enlarge relational operations to deal with time related aspects [17,18].…”

Section: Database Approachesmentioning

confidence: 99%

“…Nonetheless, some authors [4,[6][7][8] notice that the use of SQL systems as a time series backend suffers from some drawbacks.…”

Section: Introductionmentioning

confidence: 99%

See 2 more Smart Citations

Formalism for a multiresolution time series database model

Serra

Vila-Marta

Escobet

2016

Information Systems

View full text Add to dashboard Cite

We formalise a specialised database management system model for time series using a multiresolution approach. These special purpose database systems store time series lossy compressed in a space-bounded storage. Time series can be stored at multiple resolutions, using distinct attribute aggregations and keeping its temporal attribute managed in a consistent way.\ud \ud The model exhibits a generic approach that facilitates its customisation to suit better the actual application requirements in a given context. The elements, the meaning of which depends on a real application, are of generic nature.\ud \ud Furthermore, we consider some specific time series properties that are a challenge in the multiresolution approach. We also describe a reference implementation of the model and introduce a use case based on real data.Peer ReviewedPostprint (author's final draft

show abstract

“…They exemplify it using financial data. In [6] Calanda is compared with temporal systems designed for time series.…”

Section: Database Approachesmentioning

confidence: 99%

Section: Database Approachesmentioning

confidence: 99%

See 1 more Smart Citation

Formalism for a multiresolution time series database model

Serra

Vila-Marta

Escobet

2016

Information Systems

View full text Add to dashboard Cite

show abstract

“…Based on the replication infrastructure described in section 5, we have realized a replication system as a component of Calanda [7,8], which is a special-purpose DBMS for the management of time series [26]. Calanda is developed and used within UBS, the largest Swiss bank.…”

Section: A Replication System For the Calanda Time Series Manage-mentmentioning

confidence: 99%

A meta model and an infrastructure for the non-transparent replication of object databases

Dreyer

Dittrich

2000

Proceedings of the Ninth International Conference on Information and Knowledge Management

Self Cite

View full text Add to dashboard Cite

non-transparent, partial and selective replication of databases. If object databases are used, appropriate replication systems have to cope with the additional complexity of object models. TodayÕs replication systems do not meet these requirements. Consequently, we introduce a meta model that specifies the abstract functionality which is needed for the non-transparent, partial and selective replication of object databases. This meta model allows incorporation of its replication concepts in a variety of object models. In addition, we present the design of a replication infrastructure, based on the meta model, which serves as the foundation for concrete realizations of object replication systems. The development of a replication system for a time series database management system proved the viability of the proposed solution.

show abstract

“…By this, they extend research done in the last decades where several dedicated mappings from design models to different database technologies following different data paradigms have been proposed, e.g., see (Gogolla 2005). However, currently there is a lack of approaches which deal with the explicit mapping of design models to time series databases which can be considered as a special type of temporal databases (Schmidt et al. 1995;Böhlen et al 2018).…”

Section: Introductionmentioning

confidence: 99%

Temporal Models on Time Series Databases.

Mazak¹,

Wolny²,

Gomez³

et al. 2020

JOT

View full text Add to dashboard Cite

With the emergence of Cyber-Physical Systems (CPS), several sophisticated runtime monitoring solutions have been proposed in order to deal with extensive execution logs. One promising development in this respect is the integration of time series databases that support the storage of massive amounts of historical data as well as to provide fast query capabilities to reason about runtime properties of such CPS. In this paper, we discuss how conceptual modeling can benefit from time series databases, and vice versa. In particular, we present how metamodels and their instances, i.e., models, can be partially mapped to time series databases. Thus, the traceability between design and simulation/runtime activities can be ensured by retrieving and accessing runtime information, i.e., time series data, in design models. On this basis, the contribution of this paper is four-fold. First, a dedicated profile for annotating design models for time series databases is presented. Second, a mapping for integrating the metamodeling framework EMF with InfluxDB is introduced as a technology backbone enabling two distinct mapping strategies for model information. Third, we demonstrate how continuous time series queries can be combined with the Object Constraint Language (OCL) for navigation through models, now enriched with derived runtime properties. Finally, we also present an initial evaluation of the different mapping strategies with respect to data storage and query performance. Our initial results show the efficiency of applying derived runtime properties as time series queries also for large model histories.

show abstract

Time Series, a Neglected Issue in Temporal Database Research?

Cited by 18 publications

References 2 publications

Formalism for a multiresolution time series database model

Formalism for a multiresolution time series database model

A meta model and an infrastructure for the non-transparent replication of object databases

Temporal Models on Time Series Databases.

Contact Info

Product

Resources

About