This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
Temporal Association Algebra: A Mathematical Foundation for Processing Object-Oriented Temporal Databases
May/June 1998 (vol. 10 no. 3)
pp. 389-408

Abstract—This paper describes an object-oriented temporal association algebra (called TA-algebra) which is intended to serve as a formal foundation for supporting a pattern-based query specification and processing paradigm. Different from the traditional table-and-attribute-based paradigm, the pattern-based paradigm views the intension of an object-oriented temporal database as a network of object classes interconnected by different association types and its extension as a network of associated temporal object instances. Consistent with this view, queries can be specified in terms of patterns of temporal object associations or nonassociations (i.e., linear, tree and network structures of object classes/objects with logical AND and OR branches). TA-algebra provides a set of algebraic operators for processing these patterns and allows the direct and/or indirect associations and/or nonassociations among temporal object instances to be more explicitly represented and maintained during processing than the traditional tabular representation of temporary or final query results. TA-algebra operators are based on time-interval and valid-time semantics and they preserve the closure property. The algebra is capable of operating on heterogeneous as well as homogeneous patterns of object associations. Both homogeneous and heterogeneous patterns are decomposed into a set of primitive temporal pattern instances for uniform treatment. This paper formally defines the TA-algebra operators and their mathematical properties. The applications of these operators in query decomposition and processing are illustrated by examples.

[1] I. Ahn, "SQL+T: A Temporal Query Language," Proc. Int'l Workshop Infrastructure for Temporal Databases, R. Snodgrass, ed., pp. B1-15,Arlington, Texas, June 1993.
[2] M. Numao and S. Morishita, "Cooperative Scheduling and its Application to Steelmaking Processes," IEEE Trans. Industrial Electronics, Vol. 38, No. 2, 1991, pp. 150-155.
[3] J.F. Allen, “Maintaining Knowledge about Temporal Intervals,” Comm. ACM, vol. 26, no. 11, pp. 832–843, 1983.
[4] H.H.M. Chen and S.Y.W. Su, "Temporal Association Algebra: A Mathematical Foundation for Temporal Object-Oriented Knowledge Bases," technical report, Database Systems R&D Center, Univ. of Florida, Gainesville, May 1993.
[5] Y.H. Chen and S.Y.W. Su, "Identification- and Elimination-Based Query Processing Techniques for Object-Oriented Databases," J. Parallel and Distributed Computing, vol. 28,, pp. 130-148, 1995.
[6] Y.H. Chen and S.Y.W. Su, "Implementation and Evaluation of Parallel Query Processing Algorithms and Data Partitioning Heuristics in Object-Oriented Databases," J. Distributed and Parallel Databases, vol. 4, pp. 107-142, 1996.
[7] T.S. Cheng and S.K. Gadia, "An Object-Oriented Model for Temporal Databases," Proc. Int'l Workshop Infrastructure for Temporal Databases, R. Snodgrass, ed., pp. N1-19,Arlington, Texas, June 1993.
[8] J. Clifford and A. Tansel, "On an Algebra for Historical Relational Databases: Two Views," Proc. ACM SIGMOD Conf., 1985.
[9] J. Clifford and A. Croker, "The Historical Relational Data Model (HRDM) and Algebra Based on Lifespans," Proc. Int'l Conf. Data Engineering, pp. 528-537,Los Angeles, Calif., IEEE CS Press, Feb. 1987.
[10] U. Dayal, "Queries and Views in an Object-Oriented Data Model," Proc. Second Workshop Database Programming Languages, pp. 35-58,Gleneden Beach, Ore., June 1989.
[11] U. Dayal and G.T.J. Wuu, "A Uniform Approach to Processing Temporal Queries," Int'l Conf. Very Large Data Bases, pp. 407-418,Vancouver, B.C., Canada, 1992.
[12] R. Elmasri and S.B. Navathe, Fundamentals of Database Systems, Benjamin/Cummings, Houston, 1989.
[13] D. Whitfield and M.L. Soffa, "Automatic Generation of Global Optimizers," Proc. ACM SIGPLAN'91 Conf. Programming Language Design and Implementation (PLDI'91), pp. 120-129,Toronto, Canada, June 1991.
[14] S.K. Gadia, "A Homogeneous Relational Model and Query Languages for Temporal Databases," ACM Trans. Database Systems, vol. 13, no. 4, pp. 418-448, Dec. 1988.
[15] S.K. Gadia and G. Bhargava, "SQL-Like Seamless Query of Temporal Data," Proc. Int'l Workshop Infrastructure for Temporal Databases, R. Snodgrass, ed., pp. P1-31,Arlington, Texas, June 1993.
[16] M. Gemis, J. Paredaens, I. Thyssens, and J. Van den Bussche, "GOOD: A Graph-Oriented Object Database System," ACM SIGMOD Conf., pp. 505-510,Washington D.C., May 1993.
[17] I.A. Goralwalla and M.T. Ozsu, "Temporal Extensions to a Uniform Behavioral Object Model," Proc. Int'l Workshop Infrastructure for Temporal Databases, R. Snodgrass, ed., pp. z1-10,Arlington, Texas, June 1993,.
[18] M. Gyssens, J. Paredaens, J. Van den Bussche, and D. Van Gucht, "A Graph-Oriented Object Database Model," IEEE Trans. Knowledge and Data Eng., vol. 6, no. 4, pp. 572-586, 1994.
[19] S.J. Hyun and S.Y.W. Su, "Time-Alignment Operations in Temporal Query Processing," J. Information Sciences, to appear.
[20] S.J. Hyun and S.Y.W. Su, "Parallel Query Processing Strategies for Object-Oriented Temporal Databases," Int'l Conf. Parallel and Distributed Information Systems (PDIS),Miami Beach, Fla., Dec. 1996.
[21] A Consensus Test Suite of Temporal Database Queries, C.S. Jensen et al., eds., Inst. for Electronic Systems, Aalborg Univ., Denmark, Nov. 1993.
[22] C.S. Jensen, J. Clifford, R. Elmasri, S.K. Gadia, P. Hayes and S. Jajodia, eds., "A Glossary of Temporal Database Concepts," ACM SIGMOD Record, vol. 23, no. 1, pp. 52-64, Mar. 1994.
[23] W. Käfer, "Temporal Selection, Temporal Projection, and Temporal Join Revised," Proc. Int'l Workshop Infrastructure for Temporal Databases, R. Snodgrass, ed., pp. U1-20,Arlington, Texas, June 1993.
[24] L.E. McKenzie, Jr. and R.T. Snodgrass, “Evaluation of Relational Algebras Incorporating the Time Dimension in Databases,” ACM Computing Surveys, vol. 23, no. 4, pp. 501–543, 1991.
[25] S.B. Navathe and R. Ahmed, "A Temporal Relational Model and a Query Language," Information Sciences, vol. 48, no. 2, pp. 57-73, 1989.
[26] J. Paredaens, P. Peelman, and L. Tanca, "G-Log: A Graph-Based Query Language," IEEE Trans. Knowledge and Data Eng., vol. 7, no. 3, pp. 436-453, 1995.
[27] E. Rose and A. Segev, "TOODM-A Temporal Object-Oriented Data Model with Temporal Constraints," Proc. Int'l Conf. ER Approach, pp. 205-229, 1991.
[28] E. Rose and A. Segev, "TOOA: A Temporal Object-Oriented Algebra," Proc. European Conf. O-O Programming,Kaiserslautern, Germany, Lecture Notes in Computer Science 707, pp. 297-325. Springer-Verlag, July 1993.
[29] E. Rose and A. Segev, "TOOSQL: A Temporal Object-Oriented Query Language," Proc. Int'l Conf. ER Approach, pp. 122-136,Arlington, Texas, 1993.
[30] A. Segev and A. Shoshani, "Logical Modeling of Temporal Data," Proc. ACM SIGMOD Conf. Management of Data, pp. 454-466, May 1987.
[31] A. Segev and A. Shoshani, "A Temporal Data Model Based on Time Sequence," Temporal Databases: Theory, Design, and Implementation, ch. 11, A. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev, and R. Snodgrass, eds. Benjamin/Cummings, 1993.
[32] D. Shipman, "The Functional Data Model and the Data Language DAPLEX," ACM TODS, vol. 6, no. 1, 1981.
[33] R. Snodgrass and I. Ahn, "A Taxonomy of Time in Databases," Proc. ACM SIGMOD Conf., 1985.
[34] R.T. Snodgrass, “The Temporal Query Language TQuel,” ACM Trans. Database Systems, vol. 12, no. 2, pp. 247–298, 1987.
[35] R. Snodgrass, "Temporal Object Oriented Databases: A Critical Comparison," Modern Database Systems: The Object Model, Interoperability, and Beyond, ch.. 19, W. Kim, ed., pp. 386-408. Addison-Wesley/ACM Press, 1995.
[36] S.Y.W. Su and H.H.M. Chen, "A Temporal Knowledge Representation Model OSAM*/T and Its Query Language OQL/T," Proc. Int'l Conf. VLDB, pp. 431-441,Barcelona, Spain, 1991.
[37] S.Y.W. Su and H. Lam, "An Object-Oriented Knowledge Base Management System for Supporting Advanced Applications," Int'l Hong Kong Computer Soc. Database Workshop, pp. 3-22,Hong Kong, Dec. 1992.
[38] S.Y.W. Su, M. Guo, and H. Lam, "Association Algebra: A Mathematical Foundation for Processing Object-Oriented Databases," IEEE Trans. Knowledge and Data Eng., vol. 5, no. 5, pp. 775-798, Oct. 1993.
[39] S.Y.W. Su, H. Lam, S. Eddula, J. Arroyo, N. Prasad, and R. Zhuang, "OSAM*.KBMS: An Object-Oriented Knowledge Base Management System for Supporting Advanced Applications," ACM SIGMOD Conf., pp. 540-541,Washington D.C., May 1993.
[40] A.U. Tansel, "Adding Time Dimension to Relational Model and Extending Relational Algebra," Information Systems, vol. 11, no. 4, pp. 343-355, 1986.
[41] A.U. Tansel, "SQLT: A Temporal Extension to SQL," Proc. Int'l Workshop Infrastructure for Temporal Databases, R. Snodgrass, ed., Arlington, Tex., pp. II1-14, June 1993.
[42] G. Wuu and U. Dayal, "A Uniform Model for Temporal Object-Oriented Databases," Proc. IEEE Conf. Data Eng., pp. 584-593, Feb. 1992.

Index Terms:
Object-oriented temporal database, temporal data organizations, temporal association algebra, pattern-based temporal data processing.
Citation:
Stanley Y.W. Su, Soon J. Hyun, Hsin-Hsing M. Chen, "Temporal Association Algebra: A Mathematical Foundation for Processing Object-Oriented Temporal Databases," IEEE Transactions on Knowledge and Data Engineering, vol. 10, no. 3, pp. 389-408, May-June 1998, doi:10.1109/69.687975
Usage of this product signifies your acceptance of the Terms of Use.