ParentFull threadmjul·Snodgrass wrote a whole book on that topic: Developing Time-Oriented Database Applications in SQL (1999).It is available as PDF on his publications page:https://www2.cs.arizona.edu/~rts/publications.htmlView on HN