Tom Johnston
Tom Johnston is an independent consultant specializing in enterprise data architecture, and in relational, object-oriented and data warehouse modeling in various industries, including telecommunications, health care, banking, retailing and transportation. He can be reached at tjohnston@acm.org, and his Web site is www.MindfulData.org.
Recent Stories From this Author
Time and Time Again: Managing Time in Relational Databases - A Revised Roadmap
July 16, 2008 I will present a side-by-side series of inserts, updates and deletes against non-temporal tables and against corresponding...
Time and Time Again
July 2, 2008 We are pleased to welcome Tom as our newest online columnist. This column is a continuation of his previous articles and will...
Time and Time Again: Managing Time in Relational Databases, Part 28 - A Revised Roadmap
June 12, 2008 We will summarize what we've done so far and proceed to develop an amended roadmap.
Time and Time Again: Managing Time in Relational Databases, Part 27 - Original and Temporal Inserts (Concluded)
May 21, 2008 We will proceed now to a discussion of original and temporal inserts.
Time and Time Again - Managing Time in Relational Databases, Part 26: Points in Time and Periods of Time
May 9, 2008 Previous discussions require another digression into how to use pairs of dates to represent periods of time.
Time and Time Again: Managing Time in Relational Databases, Part 25 - Original and Temporal Inserts
April 29, 2008 We turn to temporal integrity constraints as they apply to insert and to upsert transactions.ü
Time and Time Again - Managing Time in Relational Databases, Part 24: Original and Temporal Updates (Concluded)
April 9, 2008 As this series continues, context becomes increasingly important so that the thread of the discussion is not lost.
Time and Time Again: Managing Time in Relational Databases, Part 23 - Original and Temporal Updates
March 25, 2008 This article continues our discussion reviewing temporal RI rules.
Time and Time Again: Managing Time in Relational Databases - Part 22: Original and Temporal Deletes
March 6, 2008 This article completes our discussion of delete transactions.
Time and Time Again: Managing Time in Relational Databases, Part 21 - Enforcement Time Options for Temporal RI
February 22, 2008 In this article we continue our discussion of temporal integrity constraints on a database.
