Temporal Data Management - An Overview

@inproceedings{Bhlen2017TemporalDM,
  title={Temporal Data Management - An Overview},
  author={Michael H. B{\"o}hlen and Anton Dign{\"o}s and Johann Gamper and Christian S. Jensen},
  booktitle={eBISS},
  year={2017}
}
Despite the ubiquity of temporal data and considerable research on the effective and efficient processing of such data, database systems largely remain designed for processing the current state of some modeled reality. More recently, we have seen an increasing interest in the processing of temporal data that captures multiple states of reality. The SQL:2011 standard incorporates some temporal support, and commercial DBMSs have started to offer temporal functionality in a step-by-step manner… 
Database Technology for Processing Temporal Data
TLDR
A proposal for a more fundamental and comprehensive solution for sequenced temporal queries, which allows a tight integration into relational database systems, thereby taking advantage of existing query optimization and evaluation technologies.
Indexing Temporal Relations for Range-Duration Queries
TLDR
RD-INDEX is a grid structure in the two-dimensional space, representing the position on the timeline and the duration of timestamps, respectively, and performs better than the baselines on rangeduration queries, for which it is explicitly designed.
Modeling and querying facts with period timestamps in data warehouses
TLDR
An extensive empirical evaluation on synthetic and real-world datasets and the analysis of the query execution plans reveal that the period model is the best choice in terms of runtime and space for all four query classes.
A Disciplined Approach to Temporal Evolution and Versioning Support in JSON Data Stores
TLDR
This chapter proposes a disciplined approach, named Temporal JSON Schema (τJSchema), for the temporal management of JSON documents that guarantees logical and physical data independence and provides a low-impact solution since it requires neither updates to existing JSON documents nor extensions to related JSON technologies.
Advances in Databases and Information Systems: 24th European Conference, ADBIS 2020, Lyon, France, August 25–27, 2020, Proceedings
TLDR
This extended abstract aims at providing a concise overview about the state of the art in processing temporal and time series data as well as to discuss open research problems and challenges.
Window-Slicing Techniques Extended to Spanning-Event Streams
TLDR
This work extends streams to events that come with a duration, denoted as spanning events, and proposes a new structure for dealing with slices in such an environment, and proves that the technique is both correct and effective to deal with such spanning events.
Leveraging range joins for the computation of overlap joins
TLDR
This work presents an approach where overlap joins are formulated as unions of range joins, which are more general purpose joins compared to overlap joins, i.e., are useful in their own right, and are supported well by B+-trees.
A New query method for the temporal RDF Model RDFMT Based on SPARQL
TLDR
A query method SPARQLMT for the RDFMT is illustrated by extending SParQL and given the semantics and syntax of SPARQ, the official query language of the standard RDF model.
HINT: A Hierarchical Index for Intervals in Main Memory
TLDR
This paper proposes HINT, a novel and efficient in-memory index for intervals, with a focus on interval overlap queries, which are a basic component of many search and analysis tasks.
Processing Temporal and Time Series Data: Present State and Future Challenges
TLDR
This extended abstract aims at providing a concise overview about the state of the art in processing temporal and time series data as well as to discuss open research problems and challenges.
...
...

References

SHOWING 1-10 OF 113 REFERENCES
Comprehensive and Interactive Temporal Query Processing with SAP HANA
TLDR
This prototype combines an in-memory column store and a novel, generic temporal index structure named Timeline Index which achieves predictable and interactive query performance for a wide range of temporal query types and data sizes.
A Comparison of Different Forms of Temporal Data Management
TLDR
This article examines the creation and manipulation of temporal data using built-in temporal logic and compares its performance with the performance of equivalent hand-coded applications.
How Would You Like to Aggregate Your Temporal Data?
TLDR
A general framework of temporal aggregation concepts is provided, and the abilities of five approaches to the design of temporal query languages with respect to temporal aggregation are discussed.
An algebraic framework for temporal attribute characteristics
TLDR
This contribution demonstrates that it is possible to provide built-in temporal support while making less rigid assumptions about the data and without jeopardizing the degree of the support, which moves temporal support closer to practical applications.
Extending the Kernel of a Relational DBMS with Comprehensive Support for Sequenced Temporal Queries
TLDR
This article demonstrates how it is possible to extend the relational database engine to achieve a full-fledged, industrial-strength implementation of sequenced temporal queries, which intuitively are queries that are evaluated at each time point.
Modern Temporal Data Models: Strengths and Weaknesses
TLDR
This article presents the temporalData model of the ANSI SQL standard on one side and the data model of an existing relational DBMS on the other, and compares their support of several temporal concepts.
Timeline index: a unified data structure for processing queries on temporal data in SAP HANA
TLDR
The Timeline Index is developed as a novel, unified data structure that efficiently supports temporal operators such as temporal aggregation, time travel, and temporal joins and provides flexibility in physical design; e.g., it supports any kind of compression scheme, which is crucial for main memory column stores.
Temporal data and the relational model
TLDR
This book provides an in-depth description of the foundations and principles on which those temporal DBMSs will be built and describes a truly relational approach to the temporal data problem.
Efficient Temporal Coalescing Query Support in Relational Database Systems
TLDR
It is concluded that temporal queries can be best supported by OLAP functions supported in the current SQL:2003 standards, and is demonstrated that the current RDBMS are mature enough to directly support efficient temporal queries.
Sweeping-Based Temporal Aggregation
TLDR
A family of plane-sweeping algorithms are presented that extend the set of operators supported by Timeline-Index-based databases to temporal aggregation on fixed intervals, such as a sliding windows or GROUP BY ROLLUP aggregation, and improve the existing algorithm for computing MIN/MAX temporal aggregates on constant intervals.
...
...