Data Lifecycle

What happens to data from creation and collection through processing, consumption, retention, archival, and deletion.

Data has a lifecycle. It is created, collected, stored, processed, consumed, and eventually retained, archived, or deleted.

A good data system manages this entire lifecycle, not only the processing step. The lifecycle gives a broad view of what happens to data during its existence and why each stage needs an owner and a clear purpose.

Why the data lifecycle matters#

Source systems usually generate data for their own operational purpose first. An application records an order, a service writes a log, or a user uploads a file. That data may later be copied, transformed, reused, retained, or removed by other systems.

Thinking in lifecycle stages helps teams answer practical questions:

  • Where was this data created?
  • Who is responsible for it at each stage?
  • Which consumers depend on it?
  • How long should it remain available?
  • When and how should it be archived or deleted?

Mental model: the lifecycle of data#

Text
Data GenerationCollectionStorageProcessingConsumptionRetention / Archival / Deletion

This is a mental framework, not a strict implementation architecture. Real systems are not always linear: data may be processed several times, copied into multiple storage systems, reused by multiple consumers, or moved between hot and cold storage. Different data may also have different retention periods and deletion rules.

Core stages#

Data Generation#

Data generation is where data is created. Examples include application events, API requests, database transactions, user actions, logs, sensor measurements, and uploaded files.

The source system usually creates this data to support an operational task, not to satisfy every future analytical or reporting need.

Collection#

Collection captures data from its source and brings it into the data system. Possible methods include API requests, database reads, event or message systems, file ingestion, and scheduled extraction.

The collection stage is about obtaining the data reliably. The exact movement pattern can vary without changing the broader lifecycle model.

Storage#

Storage persists data so it can be used later. Examples include relational databases, analytical databases, object storage, data warehouses, and data lakes.

Storage choices often depend on access patterns, scale, cost, and retention requirements. Storage is one stage of the lifecycle, not its final destination.

Processing#

Processing converts raw or collected data into useful data. Operations may include validation, cleaning, normalization, filtering, joining, enrichment, and aggregation.

Processing may happen once or repeatedly throughout the lifecycle. For example, new source data may be cleaned first and later enriched when another reference dataset becomes available.

Consumption#

Consumption is when prepared data is used by dashboards, reports, machine learning systems, applications, APIs, analysts, or downstream data systems.

Data has value only when it can be reliably consumed. A technically correct dataset that is unavailable, undocumented, or too slow for its users is still a poor result.

Retention#

Retention defines how long data remains available. The decision may depend on business requirements, storage cost, compliance rules, audit requirements, and operational usefulness.

Not all data should be stored forever. Retention rules should be explicit and should identify what happens when the retention period ends.

Archival#

Archival moves older or rarely accessed data to cheaper or slower storage while keeping it available when needed.

Retention and archival are related but different:

  • Retention defines how long data should exist.
  • Archival defines how older data may be stored during that period.

Deletion#

Deletion permanently removes data at the end of its lifecycle, or sooner when the data is invalid, obsolete, or subject to a removal requirement.

Deletion may happen because a retention period expired, the data is no longer useful, or legal and privacy requirements require removal. It should be intentional, controlled, and traceable.

Data lifecycle vs. data pipeline#

A data lifecycle describes the stages data goes through during its existence. A data pipeline describes the technical process that moves and transforms data between systems or lifecycle stages.

For example, a lifecycle may look like this:

Text
Generation → Collection → Storage → Processing → Consumption → Archival

A pipeline operating inside that lifecycle may look like this:

Text
Orders API → ingestion job → raw storage → transformation → analytics table

The pipeline is one mechanism used within the lifecycle. The lifecycle is the broader concept: it also includes how data is created, used, retained, archived, and deleted.

Practical example: an e-commerce order#

Consider the lifecycle of an order record:

Text
Customer places an orderOrder is created in the application databaseOrder data is collectedStored in analytical storageProcessed and aggregatedUsed in sales reportsOlder records are archivedRecords are deleted according to the retention policy

Each step represents a lifecycle stage:

  • The customer action and database transaction are Data Generation.
  • Capturing the order for another system is Collection.
  • Persisting it in operational or analytical storage is Storage.
  • Cleaning and aggregating order data is Processing.
  • Sales reports are a Consumption use case.
  • Moving older records to long-term storage is Archival.
  • Removing records under the defined policy is Deletion.

Retention defines how long the order remains available and therefore controls when archival or deletion should occur. A pipeline may implement the collection and processing steps, but it does not represent the entire lifecycle.

Best practices#

  • Define ownership of data at each stage.
  • Preserve useful lineage and metadata.
  • Decide retention rules explicitly.
  • Avoid storing data forever by default.
  • Validate data before downstream consumption.
  • Separate operational storage from analytical use when appropriate.
  • Make archival and deletion intentional processes.
  • Design for traceability and reproducibility.

Common mistakes#

Treating storage as the final destination#

Data may still need validation, transformation, consumption, retention, or deletion after it has been stored.

Keeping everything forever#

Unlimited retention increases cost, complexity, and governance risk. Data should remain available for a reason, with a defined end to that period.

Deleting data without a defined policy#

Deletion should be predictable and controlled. Without a policy, teams may remove data too early, keep it too long, or be unable to explain what happened.

Mixing lifecycle concepts with pipeline architecture#

Raw, staging, and mart are possible pipeline or storage layers, not universal lifecycle stages. The lifecycle also covers generation, consumption, retention, archival, and deletion.

Ignoring downstream consumers#

A lifecycle is incomplete if the system does not consider who actually uses the data and what they need from it.

Quick reference#

StageResponsibility
GenerationData is created
CollectionData is captured
StorageData is persisted
ProcessingData is transformed
ConsumptionData is used
RetentionDefines how long data remains
ArchivalMoves older data to long-term storage
DeletionPermanently removes data

A data lifecycle describes what happens to data throughout its existence — from creation to consumption, retention, archival, and deletion.

See also#