Skip to search boxSkip to navigationSkip to main content

The Five-Minute Rule for the Cloud: Caching in Analytics Systems

  • Kira Duwe
    ,
  • Angelos Anadiotis
    ,
  • Andrew Lamb
    ,
  • Lucas Lersch
    ,
  • Boaz Leskes
    ,
  • Daniel Ritter
  • Laboratory of Cognitive Neuroscience, EPFL
    ,
  • Oracle Corporation
    ,
  • InfluxData
    ,
  • Amazon Web Services AI Labs
    ,
  • MotherDuck
    ,
  • SAP Research
Research Output:
Conference Article in Proceeding or Book/Report chapter
Article in proceedings
Peer-review

Open access

Publication Information

Output type

Research Output:
Conference Article in Proceeding or Book/Report chapter
Article in proceedings
Peer-review

Original language

English

Publication milestones

  • Published - 2025

Publication status

Published - 2025

Publisher

Conference on Innovative Data Systems Research

Host publication title

Conference on Innovative Data Systems Research

Abstract

For almost 40 years, Gray and Putzolu’s five-minute rule has helped quickly guide system architects to the break-even point between memory caching and direct local storage access. We believe similar rules of thumb are needed for object caches and storage in disaggregated cloud database system designs. However, it is not straightforward to adapt the established rules to the cloud as they presume fixed hardware, while, in the cloud, resources are dynamic and costs are determined by usage. This paper reviews requirements driving object caches, analyzes the design space, defines a cost model, and proposes new rules of thumb to help system designers determine when caches become cost-effective for analytical workloads in the cloud. While perhaps unsurprising, our analysis on AWS shows that caches are beneficial when a system makes (1) two requests per hour for latency-sensitive workloads, or (2) seven requests per second for non-latency-sensitive workloads. These results are consistent with and help explain the near ubiquity of object store caches in cloud analytics systems.

Related Event

Title

Conference on Innovative Data Systems Research

Event type

Conference

Degree of recognition

International event

Date

19/01/2025 - 22/01/2025

Location

AmsterdamNetherlands