Abstract
Nowadays, we are surrounded by the plenty of technical equipment. Information are not produced on daily granularity, but this approach has been moved to seconds or milliseconds. However, these data amount has to be processed, stored and provided in reliable form and required processing time. In principle, any technical equipment generates data that are important and should be stored in fast accessible form. This paper proposes new complex table classification in the time-limited validity environment with emphasis of the effectivity of treatment, recovery and information retrieval. These data significantly influence decision making process. We focus on different types of table definition, their characteristics, and suitability for the use. Then, we introduce our approach, which core part forms column level temporal granularity, which has been defined in recent past. Main part of this paper is to define end compare hybrid system for various data update frequency and rate supported by performance comparison.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Date, C.J.: Date on Database. Apress, New York (2006)
Date, C.J., Darwen, H., Lorentzos, N.A.: Temporal Data and the Relational Model. Morgan Kaufmann, San Francisco (2003)
Date, C.J.: Logic and Databases – The Roots of Relational Theory. Trafford Publishing, Victoria (2007)
Johnston, T., Weis, R.: Managing Time in Relational Databases. Morgan Kaufmann, San Francisco (2010)
Kimball, R.: The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. John Wiley & Sons, New York (1996)
Kvassay, M., Zaitseva, E., Kostolny, J., Levashenko, V.: Importance analysis of multi-state systems based on integrated direct partial logic derivatives. In: 2015 International Conference on Information and Digital Technologies, pp. 183–195 (2015)
Kvet, M., Matiaško, K.: Temporal Context Manager. In: SDOT, Žilina, pp. 93–103 (2015)
Kvet, M., Matiaško, K.: Transaction Management. In: CISTI, Barcelona, pp. 868–873 (2014)
Kvet, M., Matiaško, K., Kvet, M.: Complex time management in databases. Cent. Eur. J. Comput. Sci. 4(4), 269–284 (2014)
Matiaško, K., Vajsová, M., Zábovský, M., Chochlík, M.: Database systems. EDIS, pp. 283–341 (2008). ISBN: 9788080708207
Snodgrass, R.: Developing Time-Oriented Database Applications in SQL. Morgan Kaufmann Publishers, San Francisco (2000)
Acknowledgement
This publication is the result of the project implementation:
Centre of excellence for systems and services of intelligent transport, ITMS 26220120028 supported by the Research & Development Operational Programme funded by the ERDF and Centre of excellence for systems and services of intelligent transport II., ITMS 26220120050 supported by the Research & Development Operational Programme funded by the ERDF. This paper is also the result of the project implementation Center of translational medicine, ITMS 26220220021.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2017 Springer International Publishing AG
About this paper
Cite this paper
Kvet, M., Matiasko, K. (2017). Time as the Important Factor of the Data Retrieval – Table Type Classification. In: Rocha, Á., Correia, A., Adeli, H., Reis, L., Costanzo, S. (eds) Recent Advances in Information Systems and Technologies. WorldCIST 2017. Advances in Intelligent Systems and Computing, vol 569. Springer, Cham. https://doi.org/10.1007/978-3-319-56535-4_50
Download citation
DOI: https://doi.org/10.1007/978-3-319-56535-4_50
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-56534-7
Online ISBN: 978-3-319-56535-4
eBook Packages: EngineeringEngineering (R0)