Temporal data modelling and integrity constraints in relational databases*

References

• C. Bettini, S. Jajodia, and S. Wang, Time Granularities in Databases, Data Mining and Temporal Reasoning, Springer Verlag, Berlin, 1998.
   Google Scholar
• M.H. Bohlen, Valid time integrity constraints, Technical Report TR-94-30, Department of Computer Science, University of Arizona, Tucson, AZ, 1994.
   Google Scholar
• M. H. Bohlen, R. T. Snodgrass, and M. D. Soo, Coalescing in temporal databases, Proceedings of International Conference on Very Large Databases, 1996, pp. 180–191.
   Google Scholar
• J. Chomicki, Efficient checking of temporal integrity constraints using bounded history encoding, ACM Trans. Database Syst. 20(2) (1995), pp. 149–186.
   Web of Science ®Google Scholar
• J. Chomicki, and D. Toman, Implementing temporal integrity constraints using an active DBMS, IEEE Trans. Data Know. Eng. 7(4) (1995), pp. 566–582.
   Web of Science ®Google Scholar
• J. Clifford, and A.U. Tansel, On an algebra for historical relational databases: Two views. Proceedings of ACM SIGMOD International Conference on Management of Data, 1985, pp. 247–265.
   Google Scholar
• J. Clifford, A. Croker, and A. Tuzhilin, On completeness of historical data models, ACM Trans. Database Syst. 19(1) (1994), pp. 64–116.
   Web of Science ®Google Scholar
• J. Clifford, A. Croker, F. Grandi, and A. Tuzhilin, On temporal grouping, in Recent Advances in Temporal Databases, Clifford J. and A. Tuzhilin, ed., Springer-Verlag, Berlin, 1995, pp. 194–213.
   Google Scholar
• S.K. Gadia, A homogeneous relational model and query languages for temporal databases, ACM Trans. Database Syst. 13(4) (1988), pp. 418–448.
   Web of Science ®Google Scholar
• S.K. Gadia, Temporal databases: A prelude to parametric data, in Temporal Databases: Theory, Design, and Implementation, A.U. Tansel, eds., Benjamin/Cummings, 1993. pp. 28–66.
   Google Scholar
• S.K. Gadia, and S.S. Nair, Algebraic identities and query optimization in a parametric model for relational temporal databases, IEEE Trans. Knowl. Data Eng. 10(5) (1988), pp. 793–807.
   Google Scholar
• M. Gertz, and U­W Lipeck, Temporal integrity constraints in temporal databases, in Proceedings of the Workshop on Recent Advances in Temporal Databases, J. Clifford and A. Tuzhilin, ed., Springer Verlag Publishing, Berlin, 1995, pp. 77–92.
   Google Scholar
• I.A. Goralwalla, Y. Leontiev, M.T. Özsu, D. Szafron, and C. Combi, Temporal granularity: Completing the puzzle, J. Intell. Inf. Syst. 16(1) (2001), pp. 41–63.
   Web of Science ®Google Scholar
• F. Li, K. Yi, and W. Le, Top-k queries on temporal data, VLDB J. 19(5) (2010), pp. 715–733.
   Web of Science ®Google Scholar
• C.S. Jensen, R.T. Snodgrass, and M.D. Soo, Extending the existing dependency theory to temporal databases, IEEE Trans. Knowl. Data Eng. 8(4) (1996), pp. 563–582.
   Web of Science ®Google Scholar
• K. Kulkarni, and J.-E. Michels, Temporal features in SQL: 2011, SIGMOD Rec. 41(3) (2012), pp. 34–43.
   Web of Science ®Google Scholar
• N. Mahmood, A. Burney, and K. Ahsan, A logical temporal relational data model, IJCSI Int. J. Comput. Sci. Issues 7(1) (January 2010), pp. 1–9.
   Google Scholar
• Z.M. Ozsoyoglu, and L.-Y. Yuan, A new normal form for nested relations, ACM Trans. Database Syst. 12(1) (1987), pp. 111–136.
   Web of Science ®Google Scholar
• D. Plexousakis, Compilation and simplification of temporal integrity constraints, Rules in Database Systems, LNCS 985 (1995), pp. 260–276.
   Google Scholar
• F. Rizzolo, and A.A. Vaisman, Temporal XML: Modeling, indexing and query processing, VLDB. J. 17 (2008), pp. 1179–1212.
   Web of Science ®Google Scholar
• R. Snodgrass, The temporal query language Tquel, ACM Trans. Database Syst. 12(2) (1987), pp. 247–298.
   Web of Science ®Google Scholar
• R. Snodgrass, Developing Time Oriented Applications in SQL, Morgan Kaufmann, 2000.
   Google Scholar
• A.U. Tansel, J. Clifford, S.K. Gadia, S. Jajodia, A. Segev, and R.T. Snodgrass, Temporal Databases: Theory, Design, and Implementation, Benjamin/Cummings, Red Wood City, CA, 1993.
   Google Scholar
• A.U. Tansel, Temporal relational data model, IEEE Trans. Knowl. Data Eng. 9(3) (1997), pp. 464–479.
   Web of Science ®Google Scholar
• A.U. Tansel, and E. Tin, Expressive power of temporal relational query languages, IEEE Trans. Knowl. Data Eng. 9(1) (1997), pp. 120–134.
   Web of Science ®Google Scholar
• A.U. Tansel, Temporal data modeling and integrity constraints in relational databases, Proc. ISCIS (2004), pp. 459–469.
   Google Scholar
• D. Toman, Point-based vs. interval-based temporal query languages, Proc. ACM PODS (1986), pp. 58–67.
   Google Scholar
• V. Vianu, Dynamic functional dependencies and database aging, J. ACM 34(1) (1987), pp. 28–59.
   Web of Science ®Google Scholar
• J. Wijsen, Temporal FDs on complex objects, ACM Trans. Database Syst. 24(1) (1999), pp. 127–176.
   Web of Science ®Google Scholar
• L. Wei, R.T. Snodgrass, D. Shiyan, V.K. Gattu, and A. Kasthurirangan, Efficient sequenced temporal integrity checking, Proceedings of the 17th International Conference on Data Engineering, 2001, pp. 131–140.
   Google Scholar
• H. ZhangH. Beng, K. Tan, L. Zhang, X. Lin, X. Wang, C. Zhang, and H. Mei, Checking enforcement of integrity constraints in database applications based on code patterns, J. Syst. Softw. 84 (2011), pp. 2253–2264.
   Web of Science ®Google Scholar