Authors:
Philipp Meisen
1
;
Diane Keng
2
;
Tobias Meisen
1
;
Marco Recchioni
3
and
Sabina Jeschke
1
Affiliations:
1
RWTH Aachen University, Germany
;
2
Santa Clara University, United States
;
3
Inform GmbH Aachen, Germany
Keyword(s):
Time Interval Data, Query Language, on-Line Analytical Processing, Distributed Query Processing.
Related
Ontology
Subjects/Areas/Topics:
Data Warehouses and OLAP
;
Databases and Information Systems Integration
;
Enterprise Information Systems
;
Query Languages and Query Processing
Abstract:
Nowadays, time interval data is ubiquitous. The requirement of analyzing such data using known techniques
like on-line analytical processing arises more and more frequently. Nevertheless, the usage of approved multidimensional
models and established systems is not sufficient, because of modeling, querying and processing
limitations. Even though recent research and requests from various types of industry indicate that the handling
and analyzing of time interval data is an important task, a definition of a query language to enable on-line
analytical processing and a suitable implementation are, to the best of our knowledge, neither introduced nor
realized. In this paper, we present a query language based on requirements stated by business analysts from
different domains that enables the analysis of time interval data in an on-line analytical manner. In addition,
we introduce our query processing, established using a bitmap-based implementation. Finally, we present a
performance analysi
s and discuss the language, the processing as well as the results critically.
(More)