Temporal Data Performance Optimization using Preprocessing Layer

Michal Kvet 1 * , Karol Matiasko 1

Journal of Information Systems Engineering & Management, Volume 3, Issue 2, Article No: 13.

https://doi.org/10.20897/jisem.201813

OPEN ACCESS

Download Full Text (PDF) Cite this article

Abstract

Temporal databases forming intelligent information systems store wide range of data structures with significant data amount evolved over the time. In this paper, history of temporal models is described with regards on their usage a limitations. Performance is important part and main technology characteristics and must be handled with emphasis. Therefore, we propose two layers extending the optimizer evaluations by transforming the original user query. Preprocessing layer deals with undefined states as well as condition management of the query, which is transformed based on defined index structures and data dictionary statistics. The aim is to improve performance highlighting conversions and reducing condition evaluations. Therefore, index access paths are used, which are reflected also in the Experiment section of this paper.

Keywords

temporal database, validity, undefined state, MaxValueTime, UndefTypeValue, index, optimizer preprocessing

HTML

References

Citation

Kvet, M., and Matiasko, K. (2018). Temporal Data Performance Optimization using Preprocessing Layer. Journal of Information Systems Engineering & Management, 3(2), 13. https://doi.org/10.20897/jisem.201813