Captain Kube teaches Phippy the fundamentals of tri-temporal database modeling through a journalism exercise. Zee reflects on favorite books over time, including new favorites discovered during "Book Week".
Join them on their adventure as they collect facts and try to discover each of the three dimensions of journalistic time.
Below is my current understanding of the interrelationships between concepts. Please reach out if you notice anything incorrect: [email protected]
The biggest question is where the epistemological time period fits in.
| _ | Standard temporal model (Snodgass and Ahn 1986) | Enhanced temporal taxonomy (Nascimento and Eich 1995) | Asserted Versioning (Johnston and Weis 2010) | Asserted Versioning (Johnston and Weis 2010) | SQL:2011 | Tritemporal theory of time (Johnston 2014) |
|---|---|---|---|---|---|---|
| # of temporal dimensions | bi-temporal | tri-temporal | bi-temporal | bi-temporal | bi-temporal | tri-temporal |
| temporal axis 1 | valid time | valid time | effective time | ontological time period | application time | state time |
| temporal axis 2 | transaction time | transaction time | epistemological time period* | system time | inscription time | |
| temporal axis 3 | decision time | assertion time | epistemological time period* | speech act time |
Thanks to the Cloud Native Computing Foundation for making Phippy, Zee, and their friends available under the Creative Commons Attribution License (CC-BY). Visit phippy.io to find their other adventures.
Artwork in the public domain or licensed for non-commercial or commercial use:
- Red journal: all-free-download.com
- Chalkboard: 123RF.com
- Outside background: iStockphoto.com
- Flatland book cover: rawpixel.com
All other artwork licensed from Storyblocks.com
- Abbott, E. (1884). Flatland: A romance of many dimensions. London: Seeley & Co.
- Johnston, T. (2014). Bitemporal data: Theory and practice. Amsterdam: Morgan Kaufmann an imprint of Elsevier.
- Johnston, T., Weis, R. (2010). Managing Time in Relational Databases: How to Design, Update and Query Temporal Data. Morgan Kaufmann.
- Nascimento, M., Eich, M. (1995) Decision Time in Temporal Databases. In Proceedings of the Second International Workshop on Temporal Representation and Reasoning. pp. 157-162
- Snodgrass, R., Ahn, I. (1986) Temporal Databases. IEEE Computer 19(9). pp. 35–42.
- Temporal database. (2020, October 27). Retrieved November 30, 2020, from https://en.wikipedia.org/wiki/Temporal_database