15.1 Origins of Data Warehousing

Beginning in the 1960s, many organizations started to use database technology to collect, store, and process massive amounts of their operational data. The primary purpose of these databases is to support current transactions using real-time processing. An operational database provides a view of the organization’s current operations. As data becomes outdated, old records are usually deleted or archived, and the operational database is refreshed and populated with more current data. In the 1980s, business leaders began to realize that historical data has value as well. In combination with current data, it can be used to help them make better business decisions. Decisions such as where to open a new store, what ...

Get Databases Illuminated, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.