Configuration Guide

10.5

Back Next

Example

Your organization has the CUSTOMER base object for which you enable timeline. The CUSTOMER base object contains a record for John Smith who lived in the city of Los Angeles effective 31 January 2011 to 20 October 2013, currently lives in San Francisco effective 21 October 2013, and will live in Las Vegas effective 25 November 2015. The

MDM Hub

tracks past, present, and future changes to data, such as the address of John Smith.

Record with Past Data

The CUSTOMER base object contains the record for John Smith with a Los Angeles address where he resided in the past. The cross-reference table contains the record of John Smith with the period between which he lived in Los Angeles.

The cross-reference record for John Smith shows that he lived in Los Angeles in the past.

Rowid XREF	Rowid Object	Customer ID	First Name	Last Name	City	Period Start date	Period End Date
1	2	25	John	Smith	Los Angeles	January 31, 2011	October 20, 2013

The base object record for John Smith displays the best version of the truth (BVT) for the effective date that you specify, such as 12 February 2012.

Rowid Object	Customer ID	First Name	Last Name	City
2	25	John	Smith	Los Angeles

Record with Past and Present Data

The CUSTOMER base object contains the record for John Smith with an address that is the BVT for the date that you specify. The cross-reference table contains a record for John Smith. The cross-reference table shows the period between which he lived in Los Angeles and a record with the period between which he lived in San Francisco.

The cross-reference record for John Smith shows that he lived in Los Angeles in the past.

Rowid XREF	Rowid Object	Customer ID	First Name	Last Name	City	Period Start date	Period End Date
1	2	25	John	Smith	Los Angeles	January 31, 2011	October 20, 2013
2	2	25	John	Smith	San Francisco	October 21, 2013	November 24, 2015

The base object record for John Smith displays the BVT for the period that you specify, such as 12 February 2012.

Rowid Object	Customer ID	First Name	Last Name	City
2	25	John	Smith	Los Angeles

Record with Past, Present, and Future Data

The CUSTOMER base object contains the record for John Smith with an address that is the BVT for the date that you specify. The cross-reference table contains the record of John Smith with the period for which he lived in Los Angeles.

The cross-reference records for John Smith, who lived in Los Angeles, lives in San Francisco, and will live in Las Vegas from 25 November 2015.

Rowid XREF	Rowid Object	Customer ID	First Name	Last Name	City	Period Start date	Period End Date
1	2	25	John	Smith	Los Angeles	January 31, 2011	October 20, 2013
2	2	25	John	Smith	San Francisco	October 21, 2013	November 24, 2015
3	2	25	John	Smith	Las Vegas	November 25, 2015	null

The base object record for John Smith displays the BVT for the period that you specify, such as 12 February 2012.

Rowid Object	Customer ID	First Name	Last Name	City
2	25	John	Smith	Los Angeles

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

Example

Example

Record with Past Data

Record with Past and Present Data

Record with Past, Present, and Future Data