Qualitative and quantitative temporal constraints and relational databases: theory, architecture, and applications

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.