A Modern Approaches for Modeling Time-Varying Database Models

Authors

  • Nashwan Alromema Department of Information System, Faculty of Computing and Information Technology-Rabigh, King Abdulaziz University, Jeddah Saudi Arabia
  • Fahad Alotaibi Department of Information System, Faculty of Computing and Information Technology, King Abdulaziz University, Jeddah Saudi Arabia

DOI:

https://doi.org/10.21015/vtse.v14i2.552

Abstract

Time-varying data models store data related to time instances and offer different types of timestamping. These modeling approaches are considered as one of the most important parts of many database applications like metrological, banking, biomedical, accounting, scheduling, reservation systems, sensor based systems, real-time monitoring applications and applications involving maintenance of huge records. This research work introduces the state-of-the-art modeling approaches of Time-varying data. Furthermore we will show how to represent a running example using different approaches and give a comparison study of storage, and the ease of use of each model.

References

Date, C. J., Darwen, H., & Lorentzos, N. (2002). Temporal data & the relational model. Elsevier.‏

Anselma, L., Bottrighi, A., Montani, S., & Terenziani, P. (2013). Extending BCDM to cope with proposals and evaluations of updates. IEEE Transactions on Knowledge and Data Engineering, 25(3), 556-570.‏ DOI: https://doi.org/10.1109/TKDE.2011.170

Ariav, G. (1986). A temporally oriented data model. ACM Transactions on Database Systems (TODS), 11(4), 499-527. DOI: https://doi.org/10.1145/7239.7350

Arora, S. (2015, September). A comparative study on temporal database models: A survey. In Advanced Computing and Communication (ISACC), 2015 International Symposium on (pp. 161-167). IEEE.. DOI: https://doi.org/10.1109/ISACC.2015.7377335

Atay, C. (2016). An attribute or tuple timestamping in bitemporal relational databases. Turkish Journal of Electrical Engineering & Computer Sciences, 24(5), 4305-4321.‏ DOI: https://doi.org/10.3906/elk-1403-39

Saxena, V., Pratap, A. (2013). Performance comparison between relational and object-oriented databases. International Journal of Computer Applications, 71(22) doi:http://dx.doi.org/10.5120/12616-8275.

Garani, G. (2003). A temporal database model using nested relations (Doctoral dissertation, BIRKBECK COLLEGE).

Garani, G. A generalised relational data model. International Journal of Computer Systems Science and Engineering 2007; 11, 43-59.

AL-romema, N. (2010). Memory storage issues of temporal database applications on relational database management systems. Journal of Computer Science, 6(3). DOI: https://doi.org/10.3844/jcssp.2010.296.304

Jensen, C. S., Snodgrass, R. T., & Soo, M. D(1995). The tsql2 data model. Springer US; (pp. 157-240). DOI: https://doi.org/10.1007/978-1-4615-2289-8_10

Kumar, S. and Rishi, R. (2016a). Retrieval of Meteorological Data using Temporal Data Modeling. Indian Journal of Science and Technology, 9(37). DOI: https://doi.org/10.17485/ijst/2016/v9i37/99875

Kvet, M., Matiako, K. and Kvet, M.( 2014). Transaction management in fully temporal system. In Computer Modelling and Simulation (UKSim), UKSim-AMSS 16th International Conference on (pp. 148-153). IEEE. DOI: https://doi.org/10.1109/UKSim.2014.26

McKenzie Jr., and Snodgrass, R. T.(1991). Evaluation of relational algebras incorporating the time dimension in databases. ACM Computing Surveys (CSUR); 23(4), 501-543.‏ DOI: https://doi.org/10.1145/125137.125166

Terenziani, P. (2016a). Irregular indeterminate repeated facts in Temporal Relational Databases. IEEE Transactions on Knowledge and Data Engineering, 28(4), pp.1075-1079.‏ DOI: https://doi.org/10.1109/TKDE.2015.2509976

Noh, S.Y., and Gadia, S. K. (2008). Benchmarking temporal database models with interval-based and temporal element-based timestamping. J SYST SOFTWARE; 81(11):1931–1943. DOI: https://doi.org/10.1016/j.jss.2008.01.015

Viqueira, J.R.R. and Lorentzos, N.A. (2007). SQL extension for spatio-temporal data. The VLDB Journal—The International Journal on Very Large Data Bases, 16(2), pp.179-200. DOI: https://doi.org/10.1007/s00778-005-0161-9

Novikov, B. A., and Gorshkova, E. A. (2008). Temporal databases: From theory to applications. PROGRAM COMPUT SOFT+; 34(1), 1-6.‏ DOI: https://doi.org/10.1134/S0361768808010015

Sarda, N. L. (1990). Algebra and query language for a historical data model. The Computer Journal; 33(1), 11-18.‏ DOI: https://doi.org/10.1093/comjnl/33.1.11

Chau, V.T.N. and Chittayasothorn, S. (2007). A temporal compatible object relational database system. In Proceedings 2007 IEEE SoutheastCon (pp. 93-98). IEEE. DOI: https://doi.org/10.1109/SECON.2007.342862

Snodgrass, R. (June 1987 ). The Temporal Query Language TQUEL. ACM T DATABASE SYST 1987; 12(2):247. DOI: https://doi.org/10.1145/22952.22956

Snodgrass, R. (2000). Developing Time-Oriented Database Applications in SQL, 1st edition, Morgan Kaufmann Publishers, Inc., San Francisco.

Steiner, A. A Generalization Approach to Temporal Data Models and their Implementations. A dissertation submitted to the SWISS FEDERAL INSTITUTE OF TECHNOLOGY, ZURICH, 1998.

Tansel, A. Adding time dimension to relational model and extending relational algebra. INFORM SYST 1986; 11(4), 343-355.‏ DOI: https://doi.org/10.1016/0306-4379(86)90014-1

Tansel, A., and Snodgrass, R. (1993).Temporal databases: Theory, design and implementation. Redwood City, CA: Benjamin Cummings.

Tansel, A. (2004) .Temporal data modeling and integrity constraints in relational databases. In Computer and Information Sciences-ISCIS; (pp. 459-469). Springer Berlin Heidelberg.‏ DOI: https://doi.org/10.1007/978-3-540-30182-0_47

Tansel, A. (2004). On handling time-varying data in the relational data model. INFORM SOFTWARE TECH; 46(2), 119-126. DOI: https://doi.org/10.1016/S0950-5849(03)00114-9

‏Tansel, A. (2013).Modeling and Querying Temporal Data, Idea Group Inc 2006; DOI: https://doi.org/10.4018/978-1-59140-560-3.ch063

Terenziani, P. Coping with events in temporal relational databases. IEEE TKNOWL DATA EN, IEEE Transactions; 25(5), 1181-1185.‏ DOI: https://doi.org/10.1109/TKDE.2011.265

Alromema, N., Rahim, M.S.M. and Albidewi, I., (2016). Performance Evaluation of Attribute and Tuple Timestamping In Temporal Relational Database. International Journal of Computer Science and Information Security (IJCSIS), 14(09). DOI: https://doi.org/10.1166/jctn.2017.6855

Zhang, Q. (2001). Object-oriented database systems in manufacturing: selection and applications. Industrial Management and Data Systems, Vol. 101 Iss: 3, pp.97–105. DOI: https://doi.org/10.1108/02635570110386553

Navathe, S. B., and Ahmed, R. (1989). A temporal relational model and a query language. Information Sciences, 49(1), 147-175.‏ DOI: https://doi.org/10.1016/0020-0255(89)90026-1

Petkovic, D. (2016). Temporal Data in Relational Database Systems: A Comparison. In New Advances in Information Systems and Technologies (pp. 13-23). Springer International Publishing. DOI: https://doi.org/10.1007/978-3-319-31232-3_2

Downloads

Published

2019-04-08

How to Cite

Alromema, N., & Alotaibi, F. (2019). A Modern Approaches for Modeling Time-Varying Database Models. VFAST Transactions on Software Engineering, 7(1), 25–32. https://doi.org/10.21015/vtse.v14i2.552

Issue

Vol. 7 No. 1 (2019): January-December

Section

Articles

License

Authors who publish with this journal agree to the following terms:

  1. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License (CC-By) that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
  2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
  3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).

                                      

This work is licensed under a Creative Commons Attribution  License CC BY