Data Collection and Life Cycle

operational data store

repository of transactional data from multiple sources; interim between data source and data warehouse

data warehouse

very large data repositories that are centralized and used for reporting and analysis rather than transaction purposes

data mart

like a data warehouse but focused on a specific purpose; subset of a data warehouse

data lake

similar to a data warehouse but containing both structured and unstructured data, mostly in raw or natural form

ETL

extract, transform, load; more specific method for collecting existing data to answer a specific question

definition

define what data a business needs and where to capture it

capture

obtain the data by creating internally or capturing it from an external source

preparation

determine whether data is complete, clean, current, encrypted, and user-friendly

synthesis

bridge between preparation and usage; not always a necessary step

analytics and usage

practical use by the organization to create reports and inform decisions

publication

data shared with external users

archival

data moved from active to passive systems to free up storage resources

purging

data is completely removed from storage systems