How to use bitemporal functions: a hands-on guide
Henrietta Dombrovskaya is a database researcher and developer with over 35 years of academic and industrial experience. She holds a Ph.D. in Computer Science from the University of Saint Petersburg, Russia. At present she is
- Director of Data Analytics at BrokerX, Chicago IL
- Local Organizer of the Chicago PostgreSQL User Group
- Active community member, a frequent speaker at the PostgreSQL Conferences
- A researcher focused on developing efficient interactions between applications and databases; publications include Proceedings of EDBT 2014 Athens, ICDE 2016 in Helsinki and SOFSEM 2020 Limassol
- A winner of the “Technologist of the Year” 2019 award of the Illinois Technology Association
- An author of PostgreSQL Query Optimization book
No video of the event yet, sorry!
We have been developing the pg_bitemporal library for over six years. It started as a proof of concept; however, it has been used in the industrial setting at Braviant Holdings for the past four years. Responding to practical business needs, several functions not included in the original specs were added along with bitemporal integrity constraints support. Significant performance improvements were made. There is a definite business demand in the two-dimensional time support, and pg_bitemporal can cover a significant area of business needs. However, the usage of the functions is not always intuitive, and developers often need extensive onboarding before starting using this functionality. Responding to popular demand, we developed a quick tutorial that demonstrates the advantages of using bitemporal data representation vs. traditional tables following one simple test case.
- 2022 January 20 16:10 PST
- 50 min
- Silicon Valley 2022