Temporal PostgreSQL

Sequenced temporal queries that are queries executed at each time point, pose a substantial challenges in temporal query processing. The goal of this project is to provide exhaustive support for such queries inside of PostgreSQL.

Examples

ename edepartment eperiod
John Shipment [01-01-2015, 01-01-2017)
Sam Management [01-01-2015, 01-01-2017)
Ann Shipment [15-06-2015, 01-01-2018)
Joe Production [01-01-2015, 01-01-2018)
count eperiod
3 [01-01-2015, 15-06-2015)
4 [15-06-2015, 01-01-2017)
2 [01-01-2017, 01-01-2018)
count edepartment eperiod
1 Shipment [01-01-2015, 15-06-2015)
2 Shipment [15-06-2015, 01-01-2017)
1 Shipment [01-01-2017, 01-01-2018)
1 Management [01-01-2015, 01-01-2017)
1 Production [01-01-2015, 01-01-2018)

Prototype

Try out our prototype that you can find in the code section. For any comments or feedback please contact us.