One of the attributes of the data warehouse environment is that it contains history; thus, the structure of the data warehouse reflects that dimension of the data.

The first implication of this attribute is that data in the warehouse is stored in units of snapshots. Once the snapshot has been taken and recorded properly, there is no need to ever go back and revisit it. The second implication of the data warehouse being a historical structure is that many records are placed in the data warehouse; and unlike a transaction-oriented database where currency of data is placed at a premium, there is no distinction made between older data and newer data in the data warehouse.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access