Communications - Scientific Letters of the University of Zilina 2014, 16(1):97-104 | DOI: 10.26552/com.C.2014.1.97-104

Column Level Uni -Temporal Data

Michal Kvet1, Karol Matiasko1
1 Department of Informatics, Faculty of Management Science and Informatics, University of Zilina, Slovakia

The basic paradigm of conventional database systems is based on the current valid data processing. However, today's database systems should provide also management for historical and future valid data. Standard temporal model, using object level, stores the whole object data after the insert or update operation, although only some attributes changed their values. This paper deals with the principle of temporal data modelling based on the column level, not the whole object, describes the structure and principles of required methods, procedures, functions and triggers to provide functionality of the system. All designed and implemented solutions are compared with the existing solutions.

Keywords: conventional database, temporal database, column level temporal data, fully temporal model

Published: February 28, 2014  Show citation

ACS AIP APA ASA Harvard Chicago Chicago Notes IEEE ISO690 MLA NLM Turabian Vancouver
Kvet, M., & Matiasko, K. (2014). Column Level Uni -Temporal Data. Communications - Scientific Letters of the University of Zilina, 16(1), 97-104. doi: 10.26552/com.C.2014.1.97-104
Share...
Download citation
  • BibTeX (.bib)
  • Bookends (.ris)
  • EasyBib (.ris)
  • EndNote (.enw)
  • EndNote 8 (.xml)
  • ISI WoS (.isi)
  • Medlars (.medlars)
  • Mendeley (.ris)
  • MODS (.xml)
  • Papers (.ris)
  • RefWorks (.txt)
  • RefManager (.ris)
  • RIS (.ris)
  • MS Word (.xml)
  • Zotero (.ris)
    • Open full article

    References

    1. MATIASKO, K., VAJSOVA, M., ZABOVSKY, M., CHOCHLIK, M.: Database systems. EDIS, 2008. ISBN: 9788080708207
    2. DATE, C.: Date on Database. Apress, 2006. ISBN: 9781590597460
    3. JOHNSON, T., WEIS, R.: Managing Time in Relational Databases. Morgan Kaufmann, 2010. ISBN: 9780123750419
    4. SNODGRASS, R.: Developing Time-Oriented Database Applications in SQL. Morgan Kaufmann Publishers, San Francisco, 2000.
    5. KVET, M., LIESKOVSKY, A., MATIASKO, K.: Uni-temporal and Bi-temporal Table. IEEE Conference Digital Technologies 2013, Zilina, ISBN: 9781479909223. Go to original source...
    6. SNODGRASS, R.: Developing Time-Oriented Database Applications in SQL, Morgan Kaufmann, 1999. ISBN: 1558604367.
    7. KVET, M., MATIASKO, K.: Temporal Data Management. Conference IARIA ICCGI 2013, Nice, ISBN: 9781612082837 Go to original source...
    8. KVET, M., LIESKOVSKY, A., MATIASKO, K.: Temporal Data Modelling. IEEE Conference ICCSE 2013, Colombo, 9781467344623 Go to original source...
    9. KVET, M., MATIASKO, K.: Conventional and Temporal Table - Temporal Table Model. Conference ARSA, Zilina, 2012. ISBN: 9788055406060 Go to original source...
    10. KVET, M., MATIASKO, K.: Temporal Data Modeling - Future Valid Data Processing. Conference DICTAP 2013, Ostrava, ISBN: 978989130609 Go to original source...
    11. KVET, M., MATIASKO, K.: Management of Temporal System - Column Level. Intern. J. of New Computer Architectures and their Applications, vol. 3, No. 3, 2013. ISSN: 22209085.

    This is an open access article distributed under the terms of the Creative Commons Attribution 4.0 International License (CC BY 4.0), which permits use, distribution, and reproduction in any medium, provided the original publication is properly cited. No use, distribution or reproduction is permitted which does not comply with these terms.


    Return to the content