Catalog model choice: queries first, shape second

Three hot queries decide the shape; growth, pagination, uniqueness and brand change pick the leaf (teaching numbers)

Catalog model choice: queries first, shape second Three hot queries decide the shape; growth, pagination, uniqueness and brand change pick the leaf (teaching numbers) 01 / Queries & constraints 02 / Relational branch 03 / Document branch 04 / Hybrid leaf Ask queries Shape data Pick leaf 3 hot queries · 3 reads decide · Queries & constraints › Ask queries 3 hot queries 3 reads decide Bounded growth? · unknown = unbounded · Queries & constraints › Ask queries · fork 1 Bounded growth? unknown = unbounded fork 1 Atomic brand? · 1 row, fresh read · Queries & constraints › Shape data · fork 2 Atomic brand? 1 row, fresh read fork 2 Tables + UNIQUE · join + (prod, user) · Relational branch › Shape data Tables + UNIQUE join + (prod, user) Keyset + upsert · id > last · Relational branch › Shape data Keyset + upsert id > last Relational first · 1-row change · Relational branch › Pick leaf · pick for mixed load Relational first 1-row change pick for mixed load Tiny embeds · thumb in, reviews out · Document branch › Ask queries Tiny embeds thumb in, reviews out N-doc rewrite · fan-out + window · Document branch › Shape data N-doc rewrite fan-out + window Doc read model · hot page only · Document branch › Shape data · narrow win Doc read model hot page only narrow win Tables + view · derive when hot · Hybrid leaf › Pick leaf · reports + hot page Tables + view derive when hot reports + hot page 1 atomic UPDATE mixed load derive when hot sets the test hot page only reviews stay out UNIQUE + upsert tiny: embed unbounded: ref Legend User UI Agent logic Context / trace External system