This Article 
 Bibliographic References 
 Add to: 
Qualitative and Quantitative Temporal Constraints and Relational Databases: Theory, Architecture, and Applications
November/December 1999 (vol. 11 no. 6)
pp. 948-894

Abstract—Many different applications in different areas need to deal with both: 1) databases, in order to take into account large amounts of structured data, and 2) quantitative and qualitative temporal constraints about such data. In this paper, we propose an approach that extends: 1) temporal databases, and 2) artificial intelligence temporal reasoning techniques and integrate them in order to face such a need. Regarding temporal reasoning, we consider some results that we proved recently about efficient query answering in the Simple Temporal Problem framework and we extend them in order to deal with partitioned sets of constraints and to support relational database operations. Regarding databases, we extend the relational model in order to consider also qualitative and quantitative temporal constraints both in the data (data expressiveness) and in the queries (query expressiveness). We then propose a modular architecture integrating a relational database with a temporal reasoner. We also consider classes of applications that fit into our approach and consider patient management in a hospital as an example.

[1] J.F. Allen, “Maintaining Knowledge about Temporal Intervals,” Comm. ACM, vol. 26, no. 11, pp. 832–843, 1983.
[2] J. Allen, “Time and Time Again: The Many Ways to Represent Time,” Proc. Int'l J. Intelligent Systems, vol. 6, no. 4, pp. 341–355, 1991.
[3] R. Arthur and J. Stillman, “Temporal Reasoning for Planning and Scheduling,” Technical report, AI Lab, General Electric Research Center, 1992.
[4] Knowledge and Decision in Health Telematics, P. Barahona and J.P. Christensen, eds., IOS Press, 1994.
[5] M. Baudinet,M. Niézette, and P. Wolper,"On the representation of infinite temporal data and queries (extended abstract)," Proc. ACM Symp. Principles of Database Systems, pp. 280-290,Denver, May 1991.
[6] V. Brusoni, L. Console, F. Molino, G. Molino, E. Nicolosi, and P. Terenziani, “Clinical-Mate: A Manager of Temporal Databases for Clinical Applications, J. Am. Medical Informatics Assn., p. 893, 1997.
[7] V. Brusoni, L. Console, B. Pernici, and P. Terenziani, “LaTeR: A General Purpose Manager of Temporal Information,” Methodologies for Intelligent Systems, pp. 255–264, vol. 8,Lecture Notes in Computer Science, Springer Verlag, vol. 869, 1994.
[8] V. Brusoni, L. Console, B. Pernici, and P. Terenziani, “Extending Temporal Relational Databases to Deal with Imprecise and Qualitative Temporal Information,” J. Clifford and A. Tuzhilin, eds., Recent Advances of Temporal Databases, pp. 3-22, 1995.
[9] V. Brusoni, L. Console, B. Pernici, and P. Terenziani, “Qualitative and Quantitative Temporal Constraints and Relational Databases: Theory, Architecture, and Applications,” extended technical report, Dip. di Informatica, Universitàdi Torino, 1998.
[10] V. Brusoni, L. Console, B. Pernici, and P. Terenziani, “LaTeR: An Efficient, General-Purpose Manager of Temporal Information,” IEEE Expert, vol. 12, no. 4, pp. 56-64, 1997.
[11] V. Brusoni, L. Console, and P. Terenziani, “On the Computational Complexity of Querying Bounds on Differences Constraints,” Artificial Intelligence, vol. 74, no. 2, pp. 367-379, 1995.
[12] V. Brusoni, L. Console, and P. Terenziani, “A Temporal Reasoner Dealing with Non Pointisable Temporal Constraints,” technical report, Dip. Informatica, Universitàdi Torino, 1996.
[13] V. Brusoni, L. Console, P. Terenziani, and D. Theseider Dupré, “An Efficient Algorithm for Temporal Abduction,” Lecture Notes in Computer Science, vol. 1,321, pp. 195–206, Springer-Verlag, 1997.
[14] J. Chomicki, Temporal Query Languages: A Survey Proc. Temporal Logic, First Int'l Conf., D.M. Gabbay and H.J. Ohlbach, eds., pp. 506-534, 1994.
[15] J. Chomicki and D. Toman, "Implementing Temporal Integrity Constraints Using an Active DBMS," IEEE Trans. Knowledge and Data Eng., vol. 7, no., 4, pp. 566-581, Aug. 1995.
[16] Recent Advances in Temporal Databases, J. Clifford and A. Tuzhilin, eds., Springer Verlag, 1995.
[17] E. Davis, “Constraint Propagation With Interval Labels,” Artificial Intelligence, vol. 32, pp. 281–331, 1987.
[18] J. de Haan and L. Schubert, “Inference in a Topically Organised Semantic Net,” Proc. AAAI 86, pp. 161–165, St. Paul, Minn., 1986.
[19] T. Dean and D.V. McDermott, "Temporal Data Base Management," Artificial Intelligence J., vol. 32, pp. 1-55, 1987.
[20] R. Dechter, I. Meiri, and J. Pearl, “Temporal Constraint Networks,” Artificial Intelligence, vol. 49, pp. 61–95, 1991.
[21] C.E. Dyreson and R.T. Snodgrass,“Valid-time indeterminacy,” Proc. Int’l Conf. Data Eng., pp. 335-343,Vienna, Austria, Apr. 1993.
[22] S.K. Gadia, S. Nair, and Y. Poor, "Incomplete Information in Relational Temporal Databases," Proc. 18th Int'l Conf. Very Large Data Bases, pp. 395-406, 1992.
[23] D. Lenat and R.V. Guha, Building Large Knowledge-Based Systems. Addison-Wesley, 1990.
[24] T. Imielinski and W. Lipski Jr.,“Incomplete information in relational databases,” J. ACM, vol. 31, no. 4, pp. 761-791, 1984.
[25] P.C. Kanellakis, G.M. Kuper, and P.Z. Revesz, Constraint Query Languages J. Computer and System Sciences, vol. 51, no. 1, pp. 26-52, 1995.
[26] H. Kautz and P. Ladkin, “Integrating Metric and Qualitative Temporal Reasoning,” Proc. AAAI '91, pp. 241–246, 1991.
[27] J. Koomen, “The TIMELOGIC Temporal Reasoning System,” Technical Report No. 231, Computer Science Dept., Univ. of Rochester, Rochester, N.Y., Mar. 1989.
[28] M. Koubarakis,“Database models for infinite and indefinite temporal information,” Information Systems, vol. 19, no. 2, pp. 141-173, 1994.
[29] M. Koubarakis, “The Complexity of Query Evaluation in Indefinite Temporal Constraint Databases,” Theoretical Computer Science, vol. 171, pp.25–60, 1997.
[30] 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.
[31] I. Meiri, “Combining Qualitative and Quantitative Constraints in Temporal Reasoning,” Proc. AAAI '91, pp. 260–267, 1991.
[32] S.A. Miller and L.K. Schubert, “Time Revisited,” Computational Intelligence, vol. 6, pp. 108–118, 1990.
[33] I. Motakis and C. Zaniolo, “Composite Temporal Events in Active Databases: A Formal Semantics,” J. Clifford and A. Tuzhilin, eds., Recent Advances in Temporal Databases, pp. 332–354, Springer Verlag, 1995.
[34] S. Parsons, “Current Approaches to Handling Imperfect Information in Data and Knowledge Bases,” IEEE Trans. Knowledge and Data Eng., vol. 8, pp. 353-372, 1996.
[35] “Wide Esprit Project,” no. 20280,, 1995.
[36] R.T. Snodgrass, “The Temporal Query Language TQuel,” ACM Trans. Database Systems, vol. 12, no. 2, pp. 247–298, 1987.
[37] R.T. Snodgrass, "Temporal Databases," Proc. Int'l Conf. GIS: From Space to Territory, vol. 639of Lecture Notes in Computer Science, pp. 22-64. Springer-Verlag, Sept. 1992.
[38] The TSQL2 Temporal Query Language. R.T. Snodgrass, ed., Kluwer Academic Publishers, 1995.
[39] J.F. Sowa, Conceptual Structures: Information Processing in Mind and Machine, Addison-Wesley, Reading, Mass., 1984.
[40] R.P. Stanley, Enumerative Combinatorics, Wadsworth and Brooks/Cole, 1986.
[41] A. Tansel et al. Temporal Databases: Theory, Design, and Implementation. Database Systems and Applications Series, Benjamin/Cummings, 1993.
[42] P. VanBeek, “Temporal Query Processing with Indefinite Information,” Artificial Intelligence in Medicine, vol. 3, pp. 325–339, 1991.
[43] L. Vila, “A Survey on Temporal Reasoning in Artificial Intelligence,” AI Comm., vol. 7, pp. 4–28, Mar. 1994.
[44] M. Vilain and H. Kautz, “Constraint Propagation Algorithms for Temporal Reasoning,” Proc. AAAI '86, pp. 377–382, 1986.
[45] M. Vilain, H. Kautz, and P. VanBeek, “Constraint Propagation Algorithms for Temporal Reasoning: A Revised Report,” D.S. Weld and J. de Kleer, eds., Readings in Qualitative Reasoning About Physical Systems, pp. 373–381, Morgan Kaufmann, 1989.
[46] E. Yampratoom and J. Allen, “Performance of Temporal Reasoning Sytems,” SIGART Bull., vol. 4, no. 3, pp. 26–29, 1993.

Index Terms:
Artificial intelligence, temporal relational databases, temporal reasoning, temporal constraint propagation, qualitative and quantitative temporal constraints, integration.
Vittorio Brusoni, Luca Console, Paolo Terenziani, Barbara Pernici, "Qualitative and Quantitative Temporal Constraints and Relational Databases: Theory, Architecture, and Applications," IEEE Transactions on Knowledge and Data Engineering, vol. 11, no. 6, pp. 948-894, Nov.-Dec. 1999, doi:10.1109/69.824613
Usage of this product signifies your acceptance of the Terms of Use.