Performance of Querying Temporal Attributes in Object-Relational Databases

C. Kleiner; U. W. Lipeck

doi:10.1109/TIME.2002.1027475

Details

Original language	English
Title of host publication	Proceedings Ninth International Symposium on Temporal Representation and Reasoning
Editors	Michael Fisher, Alessandro Artale
Publisher	Institute of Electrical and Electronics Engineers Inc.
Pages	58-60
Number of pages	3
ISBN (print)	0-7695-1474-X
Publication status	Published - 2002
Event	9th International Symposium on Temporal Representation and Reasoning, TIME 2002 - Manchester, United Kingdom (UK) Duration: 7 Jul 2002 → 9 Jul 2002

Publication series

Name	Proceedings of the International Workshop on Temporal Representation and Reasoning
Volume	2002-January

Abstract

We evaluate a model for temporal data utilizing the benefits of object-relational database systems (ORDBS). In particular we show how attribute timestamping can be efficiently implemented in state-of-the-art ORDBS. The attribute timestamping concept is based on introducing user-specific types for temporal versions of datatypes. Moreover on the physical level we make use of user-defined index structures; in particular adapted spatial indexes based on generalized search trees are applied. These index structures greatly improve performance of important operators on both valid and bitemporal datatypes and show the effectiveness of this approach.

Keywords

Data models, Database systems, Indexing, Information systems, Object oriented modeling, Relational databases, Size measurement, Spatial databases, Spatial indexes

ASJC Scopus subject areas

Mathematics(all)
General Mathematics

Cite this

Performance of Querying Temporal Attributes in Object-Relational Databases. / Kleiner, C.; Lipeck, U. W.
Proceedings Ninth International Symposium on Temporal Representation and Reasoning. ed. / Michael Fisher; Alessandro Artale. Institute of Electrical and Electronics Engineers Inc., 2002. p. 58-60 1027475 (Proceedings of the International Workshop on Temporal Representation and Reasoning; Vol. 2002-January).

Research output: Chapter in book/report/conference proceeding › Conference contribution › Research › peer review

Kleiner, C & Lipeck, UW 2002, Performance of Querying Temporal Attributes in Object-Relational Databases. in M Fisher & A Artale (eds), Proceedings Ninth International Symposium on Temporal Representation and Reasoning., 1027475, Proceedings of the International Workshop on Temporal Representation and Reasoning, vol. 2002-January, Institute of Electrical and Electronics Engineers Inc., pp. 58-60, 9th International Symposium on Temporal Representation and Reasoning, TIME 2002, Manchester, United Kingdom (UK), 7 Jul 2002. https://doi.org/10.1109/TIME.2002.1027475

Kleiner, C., & Lipeck, U. W. (2002). Performance of Querying Temporal Attributes in Object-Relational Databases. In M. Fisher, & A. Artale (Eds.), Proceedings Ninth International Symposium on Temporal Representation and Reasoning (pp. 58-60). Article 1027475 (Proceedings of the International Workshop on Temporal Representation and Reasoning; Vol. 2002-January). Institute of Electrical and Electronics Engineers Inc.. https://doi.org/10.1109/TIME.2002.1027475

Kleiner C, Lipeck UW. Performance of Querying Temporal Attributes in Object-Relational Databases. In Fisher M, Artale A, editors, Proceedings Ninth International Symposium on Temporal Representation and Reasoning. Institute of Electrical and Electronics Engineers Inc. 2002. p. 58-60. 1027475. (Proceedings of the International Workshop on Temporal Representation and Reasoning). doi: 10.1109/TIME.2002.1027475

Kleiner, C. ; Lipeck, U. W. / Performance of Querying Temporal Attributes in Object-Relational Databases. Proceedings Ninth International Symposium on Temporal Representation and Reasoning. editor / Michael Fisher ; Alessandro Artale. Institute of Electrical and Electronics Engineers Inc., 2002. pp. 58-60 (Proceedings of the International Workshop on Temporal Representation and Reasoning).

Download

@inproceedings{e4eb5e4f8ab04cdcbd3f2823babb393c,

title = "Performance of Querying Temporal Attributes in Object-Relational Databases",

abstract = "We evaluate a model for temporal data utilizing the benefits of object-relational database systems (ORDBS). In particular we show how attribute timestamping can be efficiently implemented in state-of-the-art ORDBS. The attribute timestamping concept is based on introducing user-specific types for temporal versions of datatypes. Moreover on the physical level we make use of user-defined index structures; in particular adapted spatial indexes based on generalized search trees are applied. These index structures greatly improve performance of important operators on both valid and bitemporal datatypes and show the effectiveness of this approach.",

keywords = "Data models, Database systems, Indexing, Information systems, Object oriented modeling, Relational databases, Size measurement, Spatial databases, Spatial indexes",

author = "C. Kleiner and Lipeck, {U. W.}",

note = "Publisher Copyright: {\textcopyright} 2002 IEEE.; 9th International Symposium on Temporal Representation and Reasoning, TIME 2002 ; Conference date: 07-07-2002 Through 09-07-2002",

year = "2002",

doi = "10.1109/TIME.2002.1027475",

language = "English",

isbn = "0-7695-1474-X",

series = "Proceedings of the International Workshop on Temporal Representation and Reasoning",

publisher = "Institute of Electrical and Electronics Engineers Inc.",

pages = "58--60",

editor = "Michael Fisher and Alessandro Artale",

booktitle = "Proceedings Ninth International Symposium on Temporal Representation and Reasoning",

address = "United States",

}

Download

TY - GEN

T1 - Performance of Querying Temporal Attributes in Object-Relational Databases

AU - Kleiner, C.

AU - Lipeck, U. W.

PY - 2002

Y1 - 2002

N2 - We evaluate a model for temporal data utilizing the benefits of object-relational database systems (ORDBS). In particular we show how attribute timestamping can be efficiently implemented in state-of-the-art ORDBS. The attribute timestamping concept is based on introducing user-specific types for temporal versions of datatypes. Moreover on the physical level we make use of user-defined index structures; in particular adapted spatial indexes based on generalized search trees are applied. These index structures greatly improve performance of important operators on both valid and bitemporal datatypes and show the effectiveness of this approach.

AB - We evaluate a model for temporal data utilizing the benefits of object-relational database systems (ORDBS). In particular we show how attribute timestamping can be efficiently implemented in state-of-the-art ORDBS. The attribute timestamping concept is based on introducing user-specific types for temporal versions of datatypes. Moreover on the physical level we make use of user-defined index structures; in particular adapted spatial indexes based on generalized search trees are applied. These index structures greatly improve performance of important operators on both valid and bitemporal datatypes and show the effectiveness of this approach.

KW - Data models

KW - Database systems

KW - Indexing

KW - Information systems

KW - Object oriented modeling

KW - Relational databases

KW - Size measurement

KW - Spatial databases

KW - Spatial indexes

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

U2 - 10.1109/TIME.2002.1027475

DO - 10.1109/TIME.2002.1027475

M3 - Conference contribution

AN - SCOPUS:84948448208

SN - 0-7695-1474-X

T3 - Proceedings of the International Workshop on Temporal Representation and Reasoning

SP - 58

EP - 60

BT - Proceedings Ninth International Symposium on Temporal Representation and Reasoning

A2 - Fisher, Michael

A2 - Artale, Alessandro

PB - Institute of Electrical and Electronics Engineers Inc.

T2 - 9th International Symposium on Temporal Representation and Reasoning, TIME 2002

Y2 - 7 July 2002 through 9 July 2002

ER -

Research@Leibniz University