Click to learn more about author Ravi Shankar. Back in the 1980s, when databases first enabled us to store megabytes of data, we were enthralled because we could store what seemed to be large volumes of data in a single place. Since then, we continue to try to collect our data in a single place for […]
The Virtual Operational Data Store Demystified
The Virtual Operational Data Store (VODS) can be appreciated by anyone who needs to get somewhere on time. For example, a commuter benefits from an intelligent application like Waze, to find out where traffic is backed up (say from a major accident) and to suggest alternate routes. Drivers benefit when intelligent transportations coordinate traffic lights […]
Data Warehouses Should Stage Source Data
Click here to learn more about author Michael Blaha. A data warehouse is a database that is dedicated to data analysis and reporting. It combines data from multiple operational applications and provides one location for decision-support data. A warehouse should have one staging table for each source table or file. Warehouse Data Flow As the […]