TPG - Home

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)

SELECT COUNT(*), eperiod
FROM employees
GROUP BY PERIOD WITH(eperiod);

count	eperiod
3	[01-01-2015, 15-06-2015)
4	[15-06-2015, 01-01-2017)
2	[01-01-2017, 01-01-2018)

SELECT COUNT(*), edepartment, eperiod
FROM employees
GROUP BY PERIOD WITH(eperiod) edepartment;

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.