IC Monday Seminar - Curbing Time Intervals in Database Systems
Event details
| Date | 07.02.2011 |
| Hour | 16:15 |
| Speaker | Prof. Michael Boehlen of the University of Zurich invited by Prof. Christoph Koch |
| Location |
INM 202
|
| Category | Conferences - Seminars |
Abstract:
A wide range of databases store time-varying data, and in relational databases the most common choice is to associate each tuple with a time interval. Processing tuples that are timestamped with intervals, however, turns out to be complex with many subtle issues. We present the requirements towards a database systems that wants to provide principled support for time intervals and then introduce unification as a new basic operator of a relational algebra. Unification provides systematic support for managing time intervals and has been integrated into the kernel of PostgreSQL to offer native database support for processing time-varying data. In the second part of the talk we look at database applications and describe how to comprehensively offer support for time-varying information in SQL through statement modifiers, which apply to all query language statements, e.g., queries, integrity constraints, assertions, views, and data manipulation statements. We conclude the talk by describing the solutions that commercial database systems are currently implementing to support time-varying data.
Bio:
Michael H. Böhlen received his M.Sc. and Ph.D. degrees from ETH Zürich in respectively 1990 and 1994. He is a professor in the Department of Computer Science at the University of Zürich where he heads the database technology group. Before joining the University of Zürich he was a faculty member at Aalborg University and the Free University of Bolzano.
His research interests include various aspects of data management, and have focused on time-varying information, data warehousing and analysis, and similarity search in hierarchical data. With his colleagues, he regularly publishes in the main database outlets. He served as a PC member for many international conferences (including SIGMOD, VLDB, ICDE and EDBT). Currently, he serves as an associate editor for the VLDB Journal and ACM TODS, and he is a member of the VLDB Endowment's Board of Trustees. He is a member of ACM and IEEE.
Practical information
- General public
- Free
Contact
- Christine Moscioni