A Modern Approaches for Modeling Time-Varying Database Models

Nashwan Alromema, Fahad Alotaibi


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.

Full Text:



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.‏

Ariav, G. (1986). A temporally oriented data model. ACM Transactions on Database Systems (TODS), 11(4), 499-527.

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..

Atay, C. (2016). An attribute or tuple timestamping in bitemporal relational databases. Turkish Journal of Electrical Engineering & Computer Sciences, 24(5), 4305-4321.‏

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).

Jensen, C. S., Snodgrass, R. T., & Soo, M. D(1995). The tsql2 data model. Springer US; (pp. 157-240).

Kumar, S. and Rishi, R. (2016a). Retrieval of Meteorological Data using Temporal Data Modeling. Indian Journal of Science and Technology, 9(37).

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.

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.‏

Terenziani, P. (2016a). Irregular indeterminate repeated facts in Temporal Relational Databases. IEEE Transactions on Knowledge and Data Engineering, 28(4), pp.1075-1079.‏

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.

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.

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

Sarda, N. L. (1990). Algebra and query language for a historical data model. The Computer Journal; 33(1), 11-18.‏

Chau, V.T.N. and Chittayasothorn, S. (2007). A temporal compatible object relational database system. In Proceedings 2007 IEEE SoutheastCon (pp. 93-98). IEEE.

Snodgrass, R. (June 1987 ). The Temporal Query Language TQUEL. ACM T DATABASE SYST 1987; 12(2):247.

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.‏

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.‏

Tansel, A. (2004). On handling time-varying data in the relational data model. INFORM SOFTWARE TECH; 46(2), 119-126.

‏Tansel, A. (2013).Modeling and Querying Temporal Data, Idea Group Inc 2006;

Terenziani, P. Coping with events in temporal relational databases. IEEE TKNOWL DATA EN, IEEE Transactions; 25(5), 1181-1185.‏

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).

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

Navathe, S. B., and Ahmed, R. (1989). A temporal relational model and a query language. Information Sciences, 49(1), 147-175.‏

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: http://dx.doi.org/10.21015/vtse.v14i2.552


  • There are currently no refbacks.