Temporal Data Management—An Overview

Michael Hanspeter Böhlen, Anton Dignös, Johann Gamper, Christian Søndergaard Jensen

Publikation: Bidrag til bog/antologi/rapport/konference proceedingKonferenceartikel i proceedingForskningpeer review

6 Citationer (Scopus)
24 Downloads (Pure)

Resumé

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, such as the representation of temporal intervals, temporal primary and foreign keys, and the support for so-called time-travel queries that enable access to past states.

This tutorial gives an overview of state-of-the-art research results and technologies for storing, managing, and processing temporal data in relational database management systems. Following an introduction that offers a historical perspective, we provide an overview of basic temporal database concepts. Then we survey the state-of-the-art in temporal database research, followed by a coverage of the support for temporal data in the current SQL standard and the extent to which the temporal aspects of the standard are supported by existing systems. The tutorial ends by covering a recently proposed framework that provides comprehensive support for processing temporal data and that has been implemented in PostgreSQL.
OriginalsprogEngelsk
TitelBusiness Intelligence and Big Data - 7th European Summer School, eBISS 2017, Tutorial Lectures
RedaktørerEsteban Zimanyi
Antal sider33
Vol/bind324
ForlagSpringer
Publikationsdato1 jan. 2018
Sider51-83
ISBN (Trykt)978-3-319-96654-0
ISBN (Elektronisk)978-3-319-96655-7
DOI
StatusUdgivet - 1 jan. 2018
BegivenhedEuropean Business Intelligence and Big Data Summer School -
Varighed: 2 jul. 20177 jul. 2017

Konference

KonferenceEuropean Business Intelligence and Big Data Summer School
Periode02/07/201707/07/2017
NavnLecture Notes in Business Information Processing
ISSN1865-1348

Fingerprint

Processing
Travel time
Data acquisition

Citer dette

Böhlen, M. H., Dignös, A., Gamper, J., & Jensen, C. S. (2018). Temporal Data Management—An Overview. I E. Zimanyi (red.), Business Intelligence and Big Data - 7th European Summer School, eBISS 2017, Tutorial Lectures (Bind 324, s. 51-83). Springer. Lecture Notes in Business Information Processing https://doi.org/10.1007/978-3-319-96655-7_3
Böhlen, Michael Hanspeter ; Dignös, Anton ; Gamper, Johann ; Jensen, Christian Søndergaard. / Temporal Data Management—An Overview. Business Intelligence and Big Data - 7th European Summer School, eBISS 2017, Tutorial Lectures. red. / Esteban Zimanyi. Bind 324 Springer, 2018. s. 51-83 (Lecture Notes in Business Information Processing).
@inproceedings{9d3ac9f1873041c08adfefe334e80277,
title = "Temporal Data Management—An Overview",
abstract = "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, such as the representation of temporal intervals, temporal primary and foreign keys, and the support for so-called time-travel queries that enable access to past states.This tutorial gives an overview of state-of-the-art research results and technologies for storing, managing, and processing temporal data in relational database management systems. Following an introduction that offers a historical perspective, we provide an overview of basic temporal database concepts. Then we survey the state-of-the-art in temporal database research, followed by a coverage of the support for temporal data in the current SQL standard and the extent to which the temporal aspects of the standard are supported by existing systems. The tutorial ends by covering a recently proposed framework that provides comprehensive support for processing temporal data and that has been implemented in PostgreSQL.",
author = "B{\"o}hlen, {Michael Hanspeter} and Anton Dign{\"o}s and Johann Gamper and Jensen, {Christian S{\o}ndergaard}",
year = "2018",
month = "1",
day = "1",
doi = "10.1007/978-3-319-96655-7_3",
language = "English",
isbn = "978-3-319-96654-0",
volume = "324",
series = "Lecture Notes in Business Information Processing",
publisher = "Springer",
pages = "51--83",
editor = "Esteban Zimanyi",
booktitle = "Business Intelligence and Big Data - 7th European Summer School, eBISS 2017, Tutorial Lectures",
address = "Germany",

}

Böhlen, MH, Dignös, A, Gamper, J & Jensen, CS 2018, Temporal Data Management—An Overview. i E Zimanyi (red.), Business Intelligence and Big Data - 7th European Summer School, eBISS 2017, Tutorial Lectures. bind 324, Springer, Lecture Notes in Business Information Processing, s. 51-83, European Business Intelligence and Big Data Summer School, 02/07/2017. https://doi.org/10.1007/978-3-319-96655-7_3

Temporal Data Management—An Overview. / Böhlen, Michael Hanspeter; Dignös, Anton; Gamper, Johann; Jensen, Christian Søndergaard.

Business Intelligence and Big Data - 7th European Summer School, eBISS 2017, Tutorial Lectures. red. / Esteban Zimanyi. Bind 324 Springer, 2018. s. 51-83 (Lecture Notes in Business Information Processing).

Publikation: Bidrag til bog/antologi/rapport/konference proceedingKonferenceartikel i proceedingForskningpeer review

TY - GEN

T1 - Temporal Data Management—An Overview

AU - Böhlen, Michael Hanspeter

AU - Dignös, Anton

AU - Gamper, Johann

AU - Jensen, Christian Søndergaard

PY - 2018/1/1

Y1 - 2018/1/1

N2 - 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, such as the representation of temporal intervals, temporal primary and foreign keys, and the support for so-called time-travel queries that enable access to past states.This tutorial gives an overview of state-of-the-art research results and technologies for storing, managing, and processing temporal data in relational database management systems. Following an introduction that offers a historical perspective, we provide an overview of basic temporal database concepts. Then we survey the state-of-the-art in temporal database research, followed by a coverage of the support for temporal data in the current SQL standard and the extent to which the temporal aspects of the standard are supported by existing systems. The tutorial ends by covering a recently proposed framework that provides comprehensive support for processing temporal data and that has been implemented in PostgreSQL.

AB - 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, such as the representation of temporal intervals, temporal primary and foreign keys, and the support for so-called time-travel queries that enable access to past states.This tutorial gives an overview of state-of-the-art research results and technologies for storing, managing, and processing temporal data in relational database management systems. Following an introduction that offers a historical perspective, we provide an overview of basic temporal database concepts. Then we survey the state-of-the-art in temporal database research, followed by a coverage of the support for temporal data in the current SQL standard and the extent to which the temporal aspects of the standard are supported by existing systems. The tutorial ends by covering a recently proposed framework that provides comprehensive support for processing temporal data and that has been implemented in PostgreSQL.

UR - http://www.scopus.com/inward/record.url?scp=85050259013&partnerID=8YFLogxK

U2 - 10.1007/978-3-319-96655-7_3

DO - 10.1007/978-3-319-96655-7_3

M3 - Article in proceeding

SN - 978-3-319-96654-0

VL - 324

T3 - Lecture Notes in Business Information Processing

SP - 51

EP - 83

BT - Business Intelligence and Big Data - 7th European Summer School, eBISS 2017, Tutorial Lectures

A2 - Zimanyi, Esteban

PB - Springer

ER -

Böhlen MH, Dignös A, Gamper J, Jensen CS. Temporal Data Management—An Overview. I Zimanyi E, red., Business Intelligence and Big Data - 7th European Summer School, eBISS 2017, Tutorial Lectures. Bind 324. Springer. 2018. s. 51-83. (Lecture Notes in Business Information Processing). https://doi.org/10.1007/978-3-319-96655-7_3