Native bitemporal support for SPANNER?

Google Cloud Database
,
1

Hi there,

Does Spanner have any native bitemporal support? I worked with bitemporal modeling on relational databases and the performance for some queries was heavily affected by the lack of native support for bitemporality, making it unacceptable in some cases. I know there are Crux and Datomic which are designed from the ground up to embrace bitemporality, I would love to have both native bitemporality in Spanner and all the other amazing benefits of Spanner (SaaS).

Thanks

2

I’m not aware of a Cloud Spanner native feature for Bitemporal tables, problably you should have to implement it by your own.

Also I’d suggest to explore Bigtable since as explained in documentation[1] it’s a good fit for: "

Time-series data, such as CPU and memory usage over time for multiple servers.

"

By design Bigtable keeps tracks of historical changes of your data and is also SaaS.

1- Bigtable overview | Cloud Bigtable Documentation | Google Cloud

1 Like