- Oggetto:
Temporal Data Bases
- Oggetto:
Academic year 2013/2014
- Course ID
- TDB2013
- Teacher
- Prof. Paolo Terenziani (Titolare del corso)
- Year
- 1° anno 2° anno 3° anno
- Type
- A scelta dello studente
- Credits/Recognition
- 2
- Course disciplinary sector (SSD)
- INF/01 - informatica
- Delivery
- Tradizionale
- Language
- Italiano
- Attendance
- Obbligatoria
- Type of examination
- Orale
- Oggetto:
Sommario del corso
- Oggetto:
Course objectives
The treatment of temporal aspects plays an important role in Databases. Since the 80’,
researchers have shown that, in order to properly cope with time, new techniques and extensions
to the standard DB approaches are needed, motivating the birth of a new area of reasearch:
“Temporal Databases”. After a brief motivating introduction, the course will survey some of the
main results of the area, with a specific focus on relational temporal DBs and their semantics.- Oggetto:
Results of learning outcomes
Knowledge of the main problems involved in the treatment of time in the area of databases, of the main solutions, and of the currently open issues.
Methodology for the development of a temporal database model: from the semantics to the representation/implementation
- Oggetto:
Program
(1) Introduction. A motivating introduction to Temporal Databases. In particular, the
limitation of classical approaches (e.g., SQL) to cope with time will be discussed.
(2) Description of the TSQL2 approach, a “reference” and “consensus” approach in the area
of Temporal Databases.
(3) Description of BCDM, a uniform model to cope with the semantics of Temporal
Databases
(4) Main issues in the development of semantic-based approaches to Temporal Databases.
Formal analysis of the most relevant properties of Temporal Database approaches
(5) Advanced temporal issues (e.g., multiple granularities, telic/atelic data, temporal
indeterminacy, temporal constraints and temporal reasoning)Suggested readings and bibliography
- Oggetto:
MAIN REFERENCE BOOK:
R.T. Snodgrass (editor), I. Ahn, G. Ariav, D. Batory, J. Clifford, C. Dyreson, R. Elmasri, F. Grandi, C. Jensen, W. Käfer, N. Kline, K. Kulkarni, C. Leung, N. Lorentzos, J. Roddick, A. Segev, M. Soo, S.M. Sripada, The Temporal Query Language TSQL2, Kluwer Academic Pub., 1995.
ADDITIONAL MATERIAL:
V. Brusoni, L. Console, B. Pernici, P. Terenziani. Qualitative and Quantitative Temporal Constraints and Relational Databases: Theory, Architecture, and Applications. IEEE Transactions on Knowledge and Data Engineering 11(6), 948-968, November/December 1999.
C. E. Dyreson and R. T. Snodgrass, “Supporting Valid-time Indeterminacy”, ACM Transactions on Database Systems, 23(1), March 1998, pp. 1-57.
P. Terenziani. Reasoning about time. Encyclopedia of Cognitive Science, ©Macmillan Reference Ltd, Vo.3, pp.869-874, London, 2003.
P. Terenziani, R. Snodgrass. Reconciling Point-based and Interval-based Semantics in Temporal Relational Databases: A Proper Treatment of the Telic/Atelic Distinction. IEEE Transactions on Knowledge and Data Engineering, 16(4), 540-551, 2004.
- Oggetto:
