4: Bitemporality with XTDB – Neptune Assignment
This is the bitemporal instalment of the XTDB "choose your own adventure" tutorial series.
You need to get XTDB running before you can use it.
Arrival on Neptune
You enter the Neptunian atmosphere and your communications panel lights up.
It is our honour to welcome you to the planet, Neptune.
If you are visiting for business reasons, please present your manifest.
Otherwise, have your visa ready for inspection.
- Poseidon Republic of Wealth
The government is asking to see your flight manifest.
Choose your path:
On your way down to the landing site, you take the time to read the XTDB manual.
One or more documents can be inserted into XTDB via a put transaction at a specific valid-time. The valid-time can be any time (past, future or present).
If no valid-time is provided, XTDB will default to the transaction time, i.e. the present. Each document survives until it is deleted or a new version of it is added.
- XTDB manual Read More
You are happy with what you have read, and in anticipation of the assignment, you define the standalone node.
Upon landing on the ice giant, your communications panel lights up indicating that the job ticket is available.
Back fill insurance documents
We have lost a lot of our records in a flood. I think it is prudent to start storing our data digitally. It is important to track policy holders' level of cover at the time of the incident. We have read a lot about the conveniences of XTDB's bitemporality in this situation. We need you to help us get up and running. Please send someone quickly though - the waters are rising.
Outside your ship, you are met by a panicked looking Lyndon.
Thank goodness you’re here.
We need you to show us how to put our customers' information into XTDB in order of time. Working with insurance claims, we should be able to easily look back in time at what type of coverage the customer had at the time of the incident.
Are you able to help us?
- Lyndon Mercia-York
Choose your path:
Lyndon gives you some data for a client that you can use as an example. Coast Insurance need to know what kind of cover each customer has and if it was valid at a given time.
You show them how to ingest a document using a
valid-time so that the information is backdated to when the customer took the cover out.
The company needs to know the history of insurance for each cover. You show them how to use the bitemporality of XTDB to do this.
This is the insurance that the customer had last year. Along with the start
valid-time you use an end
valid-time so as not to affect the most recent version of the document.
This is the previous insurance plan. Again, you use a start and end
There was a period when the customer was not covered,
and before that the customer was on a promotional plan.
Queries through time
You now show them a few queries. You know that you can query XTDB as of a given
valid-time. This shows the state of XTDB at that time.
First you chose a date that the customer had full cover:
Next you show them a query for a the customer in a time when they had a different type of cover:
And finally you show them a time when the customer had no cover at all.
Confident in their ability to put the remainder of their records into XTDB, Lyndon thanks you.
I can’t believe we’ve not digitized sooner. There was a huge push to start using more paper as the Neptune tree population was getting out of control from the accelerated terraforming, but since all these floods I’m not sure paper was the right choice."
- Lyndon Mercia-York
You say goodbye to Lyndon and head back to the spaceport.
Back at your spaceship, you check your communications panel. There is a new assignment waiting for you.
We have assigned you a quick task on Saturn helping a small company who are having some problems keeping their records in order.
This shouldn’t take long, but don’t forget they will still need to see your manifest.
— Helios Banking Inc.
You add the new badge to your manifest
Countdown to liftoff to the ringed planet. See you soon.
This repo is mounted by: Clojure