{"type":"excalidraw","version":2,"source":"https://AwesomeSystemDesign.dev","elements":[{"angle":0,"strokeColor":"#6577aa","backgroundColor":"#eef1fc","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-1"],"frameId":null,"roundness":null,"boundElements":[{"type":"text","id":"shape-1"}],"updated":0,"link":null,"locked":false,"id":"shape-0","type":"rectangle","seed":41,"x":16,"y":16,"width":288,"height":93.2,"customData":{"revealStep":1}},{"angle":0,"strokeColor":"#394557","backgroundColor":"transparent","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-1"],"frameId":null,"roundness":null,"boundElements":null,"updated":0,"link":null,"locked":false,"id":"shape-1","type":"text","seed":114,"x":36,"y":34,"width":248,"height":57.2,"fontSize":22,"fontFamily":1,"text":"Command\n\"PlaceOrder\"","originalText":"Command\n\"PlaceOrder\"","textAlign":"left","verticalAlign":"middle","containerId":"shape-0","lineHeight":1.3,"autoResize":false,"customData":{"revealStep":1}},{"angle":0,"strokeColor":"#6577aa","backgroundColor":"#eef1fc","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-2"],"frameId":null,"roundness":null,"boundElements":[{"type":"text","id":"shape-3"}],"updated":0,"link":null,"locked":false,"id":"shape-2","type":"rectangle","seed":187,"x":16,"y":153.2,"width":288,"height":236.20000000000002,"customData":{"revealStep":2}},{"angle":0,"strokeColor":"#394557","backgroundColor":"transparent","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-2"],"frameId":null,"roundness":null,"boundElements":null,"updated":0,"link":null,"locked":false,"id":"shape-3","type":"text","seed":260,"x":36,"y":171.2,"width":248,"height":200.20000000000002,"fontSize":22,"fontFamily":1,"text":"Read Model 2\n\"Customer History\"\n\nDenormalized for\ncustomer lookups\n\nElasticsearch","originalText":"Read Model 2\n\"Customer History\"\n\nDenormalized for\ncustomer lookups\n\nElasticsearch","textAlign":"left","verticalAlign":"middle","containerId":"shape-2","lineHeight":1.3,"autoResize":false,"customData":{"revealStep":2}},{"angle":0,"strokeColor":"#6577aa","backgroundColor":"#eef1fc","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-3"],"frameId":null,"roundness":null,"boundElements":[{"type":"text","id":"shape-5"}],"updated":0,"link":null,"locked":false,"id":"shape-4","type":"rectangle","seed":333,"x":16,"y":433.4,"width":288,"height":264.8,"customData":{"revealStep":3}},{"angle":0,"strokeColor":"#394557","backgroundColor":"transparent","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-3"],"frameId":null,"roundness":null,"boundElements":null,"updated":0,"link":null,"locked":false,"id":"shape-5","type":"text","seed":406,"x":36,"y":451.4,"width":248,"height":228.8,"fontSize":22,"fontFamily":1,"text":"Read Model 1\n\"Order Dashboard\"\n\nMaterialized view\noptimized for\noperator queries\n\nPostgreSQL","originalText":"Read Model 1\n\"Order Dashboard\"\n\nMaterialized view\noptimized for\noperator queries\n\nPostgreSQL","textAlign":"left","verticalAlign":"middle","containerId":"shape-4","lineHeight":1.3,"autoResize":false,"customData":{"revealStep":3}},{"angle":0,"strokeColor":"#6577aa","backgroundColor":"#eef1fc","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-4"],"frameId":null,"roundness":null,"boundElements":[{"type":"text","id":"shape-7"},{"type":"arrow","id":"shape-8"}],"updated":0,"link":null,"locked":false,"id":"shape-6","type":"rectangle","seed":479,"x":16,"y":742.2,"width":288,"height":93.2,"customData":{"revealStep":4}},{"angle":0,"strokeColor":"#394557","backgroundColor":"transparent","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-4"],"frameId":null,"roundness":null,"boundElements":null,"updated":0,"link":null,"locked":false,"id":"shape-7","type":"text","seed":552,"x":36,"y":760.2,"width":248,"height":57.2,"fontSize":22,"fontFamily":1,"text":"Command\n\"PlaceOrder\"","originalText":"Command\n\"PlaceOrder\"","textAlign":"left","verticalAlign":"middle","containerId":"shape-6","lineHeight":1.3,"autoResize":false,"customData":{"revealStep":4}},{"angle":0,"strokeColor":"#6577aa","backgroundColor":"transparent","fillStyle":"solid","strokeWidth":2,"strokeStyle":"solid","roughness":0.4,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-4"],"frameId":null,"roundness":null,"boundElements":null,"updated":0,"link":null,"locked":false,"id":"shape-8","type":"arrow","seed":625,"x":36,"y":849.4000000000001,"width":0,"height":28,"points":[[0,0],[0,28]],"lastCommittedPoint":null,"startBinding":{"elementId":"shape-6","focus":0,"gap":14},"endBinding":{"elementId":"shape-9","focus":0,"gap":14},"startArrowhead":null,"endArrowhead":"arrow","elbowed":false,"customData":{"revealStep":4}},{"angle":0,"strokeColor":"#628572","backgroundColor":"#edf5ee","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-4"],"frameId":null,"roundness":null,"boundElements":[{"type":"text","id":"shape-10"},{"type":"arrow","id":"shape-8"}],"updated":0,"link":null,"locked":false,"id":"shape-9","type":"rectangle","seed":698,"x":16,"y":891.4000000000001,"width":288,"height":121.8,"customData":{"revealStep":4}},{"angle":0,"strokeColor":"#394557","backgroundColor":"transparent","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-4"],"frameId":null,"roundness":null,"boundElements":null,"updated":0,"link":null,"locked":false,"id":"shape-10","type":"text","seed":771,"x":36,"y":909.4000000000001,"width":248,"height":85.8,"fontSize":22,"fontFamily":1,"text":"Domain Model\n(validate, apply\nbusiness rules)","originalText":"Domain Model\n(validate, apply\nbusiness rules)","textAlign":"left","verticalAlign":"middle","containerId":"shape-9","lineHeight":1.3,"autoResize":false,"customData":{"revealStep":4}},{"angle":0,"strokeColor":"#6577aa","backgroundColor":"#eef1fc","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-5"],"frameId":null,"roundness":null,"boundElements":[{"type":"text","id":"shape-12"}],"updated":0,"link":null,"locked":false,"id":"shape-11","type":"rectangle","seed":844,"x":16,"y":1057.2,"width":288,"height":236.20000000000002,"customData":{"revealStep":5}},{"angle":0,"strokeColor":"#394557","backgroundColor":"transparent","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-5"],"frameId":null,"roundness":null,"boundElements":null,"updated":0,"link":null,"locked":false,"id":"shape-12","type":"text","seed":917,"x":36,"y":1075.2,"width":248,"height":200.20000000000002,"fontSize":22,"fontFamily":1,"text":"Read Model 3\n\"Analytics\"\n\nAggregated\nfor charts\n\nClickHouse","originalText":"Read Model 3\n\"Analytics\"\n\nAggregated\nfor charts\n\nClickHouse","textAlign":"left","verticalAlign":"middle","containerId":"shape-11","lineHeight":1.3,"autoResize":false,"customData":{"revealStep":5}},{"angle":0,"strokeColor":"#628572","backgroundColor":"#edf5ee","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-6"],"frameId":null,"roundness":null,"boundElements":[{"type":"text","id":"shape-14"}],"updated":0,"link":null,"locked":false,"id":"shape-13","type":"rectangle","seed":990,"x":16,"y":1337.4,"width":288,"height":1237.2,"customData":{"revealStep":6}},{"angle":0,"strokeColor":"#394557","backgroundColor":"transparent","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-6"],"frameId":null,"roundness":null,"boundElements":null,"updated":0,"link":null,"locked":false,"id":"shape-14","type":"text","seed":1063,"x":36,"y":1355.4,"width":248,"height":1201.2,"fontSize":22,"fontFamily":1,"text":"Separate Write\nModel from Read\nModel\n\nWrite Side\n(Commands):\n\nv (event published)\n\"OrderPlaced\" event\n\nRead Side (Queries):\n\nWhy CQRS:\n• Write model:\nnormalized, optimized\nfor consistency +\nrules\n• Read models:\ndenormalized, each\noptimized for specific\nquery\n• Scale reads and\nwrites independently\n• Different storage\ntechnologies for\ndifferent query\npatterns\n• Read models are\nREBUILT from\nevents (eventual\nconsistency)\n\nTradeoff: Eventual\nconsistency between\nwrite and read sides\nTypical lag: 100-500\nms (acceptable for\ndashboards, search)\nNOT acceptable for:\n\"did my payment go\nthrough?\" (use write\nDB)","originalText":"Separate Write\nModel from Read\nModel\n\nWrite Side\n(Commands):\n\nv (event published)\n\"OrderPlaced\" event\n\nRead Side (Queries):\n\nWhy CQRS:\n• Write model:\nnormalized, optimized\nfor consistency +\nrules\n• Read models:\ndenormalized, each\noptimized for specific\nquery\n• Scale reads and\nwrites independently\n• Different storage\ntechnologies for\ndifferent query\npatterns\n• Read models are\nREBUILT from\nevents (eventual\nconsistency)\n\nTradeoff: Eventual\nconsistency between\nwrite and read sides\nTypical lag: 100-500\nms (acceptable for\ndashboards, search)\nNOT acceptable for:\n\"did my payment go\nthrough?\" (use write\nDB)","textAlign":"left","verticalAlign":"middle","containerId":"shape-13","lineHeight":1.3,"autoResize":false,"customData":{"revealStep":6}}],"appState":{"viewBackgroundColor":"#fbfbf8","gridSize":null},"files":{}}