Data Architecture

InBase President, Randy Weis, has developed a database architecture pattern that allows for the versioning of database objects, allowing the application to maintain and retrieve instances of an object "as of" any given point in time.  This also allows for proactive updates, retroactive updates, sandbox and hypothetical updates.  It also provides the ability to spread a business transaction across multiple physical units of work, many days, several tables and numerous rows, yet release/publish them all together in a small release transaction.  This pattern builds upon the bi-temporal pattern that he previously developed and implemented.

Randy, in collaboration with Dr. Tom Johnston of Mindful Data, Inc., another specialist in this space, are publishing a series in DM-Review, explaining the various Data History Patterns, leading up to the ultimate pattern.  Check out the series here, and give us your feedback.

Glossary for the Time and Time Again Series.

There is a lot of new terminology used in the Time and Time Again Series published in DM-Review.  So we have created a glossary of these terms.  See the Glossary Here.

 

Articles in the Time and Time Again Series.

 

Time and Time Again: Managing Time in Relational Databases,
  Part 1

Tom Johnston, Randall Weis

Article published in May 2007, in DM Review magazine

 

Time and Time Again: Managing Time in Relational Databases,
  Part 2 - Preliminaries

Tom Johnston, Randall Weis

Article published in May 2007, in DM Direct

 

Time and Time Again: Managing Time in Relational Databases,
  Part 3 - Version Patterns 1 and 2

Tom Johnston, Randall Weis

Article published in May 2007, in DM Direct

 

Time and Time Again: Managing Time in Relational Databases,
  Part 4 - Preliminaries to Version Pattern 3

Tom Johnston, Randall Weis

Article published in June 2007, in DM Direct

 

Time and Time Again: Managing Time in Relational Databases,
  Part 5: Version Pattern 3

Tom Johnston, Randall Weis

Article published in June 2007, in DM Direct

 

Time and Time Again: Managing Time in Relational Databases,
  Part 6: Version Pattern 4

Tom Johnston, Randall Weis

Article published in June 2007, in DM Direct

 

Time and Time Again: Managing Time in Relational Databases,
  Part 7: Completing Version Pattern 4

Tom Johnston, Randall Weis

Article published in July 2007, in DM Direct

 

Time and Time Again: Managing Time in Relational Databases,
  Part 8: Version Pattern 5

Tom Johnston, Randall Weis

Article published in August 2007, in DM Direct

 

Time and Time Again: Managing Time in Relational Databases,
  Part 9: Completing Version Pattern 5

Tom Johnston, Randall Weis

Article published in August 2007, in DM Direct

 

Time and Time Again: Managing Time in Relational Databases,
  Part 10 - Foreign Keys in Version Tables

Tom Johnston, Randall Weis

Article published in September 2007, in DM Direct

 

Time and Time again: Managing Time in Relational Databases,
  Part 11 - Foreign Keys in Versioned tables Continued

Tom Johnston, Randall Weis

Article published in October 2007, in DM Direct

 

Time and Time Again: Managing Time in Relational Databases,
  Part 12: Foreign Keys in Version Tables

Tom Johnston, Randall Weis

Article published in October 2007, in DM Direct

 

Time and Time Again: Managing Time in Relational Databases,
  Part 13 - A Roadmap of the Rest of This Series

Tom Johnston, Randall Weis

Article published in November 2007, in DM Direct

 

Time and Time Again: Managing Time in Relational Databases,
  Part 14 - Versioning with Surrogate Keys

Randall Weis, Tom Johnston

Article published in November 2007, in DM Direct

 

Time and Time Again: Managing Time in Relational Databases,
  Part 15 - For and Against Surrogate Keys

Tom Johnston, Randall Weis

Article published in December 2007, in DM Direct

 

Time and Time Again: Managing Time in Relational Databases,
  Part 16 - Physical Implementation of Version Pattern 1

Randall Weis, Tom Johnston

Article published in the December 21 2007 issue of DM Direct

 

Time and Time Again: Managing Time in Relational Databases,
  Part 17 - Physical Implementation of Version Pattern 2

Randall Weis, Tom Johnston

Article published in the January 4, 2008 issue of DM Direct

 

Time and Time Again: Managing Time in Relational Databases,
  Part 18 - Physical Implementation of Version Pattern 3

Randall Weis, Tom Johnston

Article published in the January 18, 2008 issue of DM Direct

 

Time and Time Again: Managing Time in Relational Databases,
  Part 19 - RI and Temporal RI

Tom Johnston, Randall Weis

Article published in the February 1, 2008 issue of DM Direct

 

Time and Time Again: Managing Time in Relational Databases,
  Part 20 - RI and Temporal RI (Continued)

Tom Johnston, Randall Weis

Article published in the February 15, 2008 issue of DM Direct

 

 

 

Send mail to webmaster@inbaseinc.com with questions or comments about this web site.
Copyright � 2005 InBase, Inc.