Time in Databases
Abdullah Uz Tansel is professor of Computer Information Systems at the Zicklin School of Business at Baruch College and Computer Science PhD program at the Graduate Center. His research interests are database management systems, temporal databases, data mining, and semantic web. Dr. Tansel published many articles in the conferences and journals of ACM and IEEE. Dr. Tansel has a pending patent application on semantic web. Currently, he is researching temporality in RDF and OWL, which are semantic web languages. Dr. Tansel served in program committees of many conferences and headed the editorial board that published the first book on temporal databases in 1993. He is also one the editors of the forth coming book titled Recommendation and Search in Social Networks to be published by Springer. He received BS, MS and PhD degrees from the Middle East Technical University, Ankara Turkey. He also completed his MBA degree in the University of Southern California. Dr. Tansel is a member of ACM and IEEE Computer Society.
No video of the event yet, sorry!
Big data is of interest to many applications and it naturally involves time. The presentation explores time ontology and addresses the subtle issues in managing temporal data and temporal knowledge: comparing database states at two different time points, capturing the periods for concurrent events and accessing to times beyond these periods, sequential semantics, handling multi-valued attributes, temporal grouping and coalescing, temporal integrity constraints, rolling the database to a past state and restructuring temporal data, etc. Having ranges as a data type PostgresSQL has a solid base in implementing a temporal database that can address many of these issues successfully.
- 50 min
- PGConf US 2017