This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Native bitemporal support for SPANNER?

Posted on 08-16-2021 09:31 AM
jfbaro
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

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

0 1 216
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
hectorjacales
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

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