~/talk

Harnessing the Power of Materialised Views in Cosmos DB

Talkat code.talks 2023 · 2023-09-14..09-15· [databases, cloud-infrastructure]
links:none on file
slides:none on file

Explains how Azure Cosmos DB uses Materialized Views (preview) to precompute and store query-specific documents, trading more expensive writes and storage for far cheaper, faster reads and fewer cross-partition queries. Shows implementation patterns using change feed + Azure Functions (output bindings and triggers), JSON/CLI deployment of view definitions, and alternatives for heavy processing like Apache Spark. Emphasizes partition-key design and RU cost math, and calls out current limits: no WHERE support in view definitions and no RBAC or CMK encryption for materialized views yet.

AI-written summary · about

  1. 0:00Introduction
  2. 3:01Azure Cosmos DB
  3. 6:32Account structure & partitioning
  4. 13:59Materialized views needed
  5. 18:40Change feed & event sourcing
  6. 24:05Materialized views benefits
  7. 28:44Demo: Azure Functions
  8. 32:01Built-in preview feature
  9. 33:51Limitations of feature
  10. 34:53Q&A
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.