keepcalculator

06 Numbers and Powers

Infinite Storage for Streaming Data: What Apps Can Do

Card No. 06·16175 · Updated · Standard formula, shown below

Total storage (TB) 3.65 TB
Approx. events stored
3,564,453,125 events
Result
Retention (days)
365 days
You entered
Data rate (GB/day)
10 GB/day
You entered
You enter
Retention (days), Data rate (GB/day)
You get
Total storage (TB), Approx. events stored
Rounding
2 dp · 0 dp

Infinite storage for streaming data means applications can keep every event ever recorded and query it at any time, unlocking capabilities that are impossible with finite retention. This article explains what changes when storage costs effectively drop to zero and history becomes unlimited, covering the practical benefits, technical realities, and trade-offs.

Formula

The calculator estimates the total storage needed for a streaming data pipeline over a given retention period. The formula is:

Total storage (TB) = (retention days × data rate GB/day) / 1000

Variables:

  • t – retention period in days (e.g., 365 for one year).
  • r – average data ingestion rate in gigabytes per day (e.g., 10 GB/day from IoT sensors).
  • Total storage – the resulting capacity in terabytes (TB), where 1 TB = 1000 GB.

The second output, “Approx. events stored,� assumes an average event size of 1 KB (1024 bytes) and shows how many individual records that storage represents. It is a rough estimate; real event sizes vary widely.

Worked Example

Using the default values: retention = 365 days, data rate = 10 GB/day.

  1. Total storage = (365 × 10) / 1000 = 3.65 TB
  2. Approx. events = (365 × 10 × 1e9) / 1024 ≈ 3.56 billion events

The calculator shows 3.65 TB and 3,564,453,125 events (rounded to 0 decimals). This means a modest 10 GB/day stream kept for a year fits on a single large hard drive.

Why Longer Histories Matter

Streaming data is generated continuously—from sensors, user clicks, financial transactions, server logs, and more. Traditional systems often retain only days or weeks of data because storage is expensive and querying large histories is slow. With infinite storage, the entire history becomes a first-class citizen. Applications can:

  • Train better machine learning models – more historical data reduces overfitting and captures rare patterns.
  • Run arbitrary time-travel queries – ask “what was the state of every user on this date?â€� without needing snapshots.
  • Detect slow-burn anomalies – subtle trends that span months or years become visible.
  • Comply with regulations – retain records for as long as required, even if rules change.
  • Enable instant replay – recreate the exact state of a system at any point in the past for debugging or audits.

How It Works Technically

Infinite storage is not a single technology but a combination of:

  • Object storage (like Amazon S3, Azure Blob, or Google Cloud Storage) that scales to exabytes and costs pennies per GB-month.
  • Columnar file formats (Parquet, ORC) that compress data heavily and allow efficient column pruning.
  • Distributed query engines (Presto, Trino, Spark) that scan petabytes in minutes by parallelizing across thousands of nodes.
  • Catalog and metadata layers (like Hive Metastore or AWS Glue) that keep track of millions of files.

Data is typically written in small batches (e.g., every minute) to object storage, then compacted into larger files for efficient reads. The query engine only reads the partitions and columns needed for a given query, so even huge histories can be queried in seconds to minutes.

Choosing the Right Approach

Not all infinite storage is the same. Consider:

  • Query latency – if you need sub-second responses, a data warehouse (like Snowflake or BigQuery) may be better than raw object storage.
  • Data format – compressed columnar formats (Parquet) are essential for cost and performance.
  • Partitioning strategy – partition by date and often by a high-cardinality key (e.g., user ID) to limit scans.
  • Data lifecycle – even with “infiniteâ€� storage, you may still want to move older data to cheaper tiers (like Glacier) if access is rare.
  • Schema evolution – choose a format that supports adding columns without rewriting everything (Parquet does).

Common Problems and Misconceptions

A frequent misconception is that infinite storage means zero cost. Storage is cheap but not free; the real cost is often in querying vast amounts of data. Scanning petabytes every time you ask a simple question is slow and expensive. Solutions include:

  • Pre-aggregation – compute daily/weekly summaries and store them alongside raw data.
  • Data skipping – use file statistics (min/max values) to skip irrelevant files.
  • Materialized views – maintain precomputed results for common queries.

Another issue is data quality: longer histories accumulate more schema drift, missing values, and duplicates. You need robust ingestion pipelines that handle late-arriving data and de-duplication.

Comparisons to Alternatives

Before “infinite� storage, teams used two main strategies:

  • Time-to-live (TTL) deletion – automatically delete data older than N days. Simple, but loses history forever.
  • Sampling – store only a fraction of events (e.g., 1% of users). Reduces cost but makes rare-event analysis impossible.

Infinite storage replaces both with full retention. Compared to a traditional data warehouse, object storage is cheaper but requires more engineering to query efficiently. Compared to a streaming platform like Kafka (which retains data only for a limited window), object storage is truly infinite but has higher latency (minutes vs. milliseconds).

Costs and Practical Limits

While storage is cheap, it is not zero. For example, storing 1 TB of data in standard object storage costs roughly $20–$25 per month (as of 2025). A stream generating 10 GB/day costs about $7.50/month for a year’s retention. But query costs can dominate: scanning 1 TB of data in a serverless query engine might cost $5–$10 per scan. If you run many queries, costs add up.

Practical limits also exist in metadata: managing billions of small files can overwhelm the catalog. The solution is to compact files into larger sizes (e.g., 100 MB–1 GB) and use partitioning to reduce the number of files per query.

Safety and Data Governance

Keeping data forever raises privacy and security concerns. You must ensure:

  • Access control – only authorized users can read sensitive fields.
  • Encryption – encrypt data at rest and in transit.
  • Data retention policies – even if you can store forever, you may be legally required to delete personal data after a certain period (e.g., GDPR).
  • Audit logs – track who accesses what, especially for regulated industries.

Infinite storage is not an excuse to ignore privacy; it’s a reason to implement fine-grained access controls and anonymization.

Frequently Asked Questions

Does “infinite� storage mean I never have to delete anything?

Technically yes, but legally and practically no. You may need to delete personal data to comply with privacy laws, and you may want to delete low-value data to reduce query costs and clutter. Infinite storage is about the capability, not a mandate.

How do I query data that is years old without it taking forever?

Use partitioning (by date and maybe by a key), columnar formats, and pre-aggregations. Also, design queries to scan only the necessary partitions and columns. With proper indexing and file pruning, queries over years of data can complete in seconds to minutes.

What’s the difference between infinite storage and a data lake?

A data lake is a storage system that holds raw data in native format, often on object storage. Infinite storage is a property you can give a data lake by not setting retention limits. So a data lake with no deletion policy is effectively infinite storage.

Can I use Kafka for infinite storage?

Kafka is designed for real-time streaming and typically retains data for a limited time (days to weeks) due to disk and performance constraints. For infinite storage, you would sink Kafka data to object storage and query it with a separate engine, not keep it in Kafka itself.

What are the hidden costs of infinite storage?

The main hidden cost is querying. Storage is cheap, but scanning huge datasets repeatedly can be expensive. Also, managing metadata, compaction, and data quality requires engineering time. Finally, egress costs can arise if you move data out of the cloud.

Is infinite storage the same as data warehousing?

No. A data warehouse is optimized for structured, aggregated data and fast queries. Infinite storage (like a data lake) can hold raw, unstructured data at lower cost, but queries are slower unless you add an engine like Presto or Snowflake on top. Many organizations use both.

Related

Formula used
in t | Retention (days) | days | 365 | 1 | 100000
in r | Data rate (GB/day) | GB/day | 10 | 0.001 | 1000000
out total | Total storage (TB) | TB | (t * r) / 1000 | 2
out events | Approx. events stored | events | (t * r * 1e9) / 1024 | 0

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.

More cards in this drawer

The whole Numbers and Powers drawer →