{"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":68,"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":35.7,"width":248,"height":28.6,"fontSize":22,"fontFamily":1,"text":"Search Pipeline","originalText":"Search Pipeline","textAlign":"left","verticalAlign":"middle","containerId":"shape-0","lineHeight":1.3,"autoResize":false,"customData":{"revealStep":1}},{"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-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":128,"width":288,"height":150.4,"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":146,"width":248,"height":114.4,"fontSize":22,"fontFamily":1,"text":"Product DB\n(PostgreSQL) → CDC\n→ Kafka →\nElasticsearch","originalText":"Product DB\n(PostgreSQL) → CDC\n→ Kafka →\nElasticsearch","textAlign":"left","verticalAlign":"middle","containerId":"shape-2","lineHeight":1.3,"autoResize":false,"customData":{"revealStep":2}},{"angle":0,"strokeColor":"#a68a53","backgroundColor":"#fff7e6","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":322.4,"width":288,"height":550.8000000000001,"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":340.4,"width":248,"height":514.8000000000001,"fontSize":22,"fontFamily":1,"text":"1. Seller\ncreates/updates\nproduct in catalog\nDB\n2. CDC (Debezium)\ncaptures change from\nDB WAL\n3. Change event\npublished to Kafka\ntopic\n\"product-changes\"\n4. Search indexer\nconsumer reads\nevent\n5. Transforms into\nsearch document +\nindexes in\nElasticsearch","originalText":"1. Seller\ncreates/updates\nproduct in catalog\nDB\n2. CDC (Debezium)\ncaptures change from\nDB WAL\n3. Change event\npublished to Kafka\ntopic\n\"product-changes\"\n4. Search indexer\nconsumer reads\nevent\n5. Transforms into\nsearch document +\nindexes in\nElasticsearch","textAlign":"left","verticalAlign":"middle","containerId":"shape-4","lineHeight":1.3,"autoResize":false,"customData":{"revealStep":3}},{"angle":0,"strokeColor":"#9180ac","backgroundColor":"#f4effb","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"}],"updated":0,"link":null,"locked":false,"id":"shape-6","type":"rectangle","seed":479,"x":16,"y":917.2,"width":288,"height":236.20000000000002,"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":935.2,"width":248,"height":200.20000000000002,"fontSize":22,"fontFamily":1,"text":"Lag: 1-5 seconds\nfrom DB write to\nsearchable\n(acceptable — buyer\nwon't notice a\n5-second\ndelay)","originalText":"Lag: 1-5 seconds\nfrom DB write to\nsearchable\n(acceptable — buyer\nwon't notice a\n5-second\ndelay)","textAlign":"left","verticalAlign":"middle","containerId":"shape-6","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-9"}],"updated":0,"link":null,"locked":false,"id":"shape-8","type":"rectangle","seed":625,"x":16,"y":1197.4,"width":288,"height":121.8,"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-9","type":"text","seed":698,"x":36,"y":1215.4,"width":248,"height":85.8,"fontSize":22,"fontFamily":1,"text":"Search document\nstructure in\nElasticsearch:","originalText":"Search document\nstructure in\nElasticsearch:","textAlign":"left","verticalAlign":"middle","containerId":"shape-8","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-11"}],"updated":0,"link":null,"locked":false,"id":"shape-10","type":"rectangle","seed":771,"x":16,"y":1363.2,"width":288,"height":808.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-11","type":"text","seed":844,"x":36,"y":1381.2,"width":248,"height":772.2,"fontSize":22,"fontFamily":1,"text":"\"product_id\":\n\"prod-abc123\",\n\"title\": \"Wireless\nBluetooth\nHeadphones\",\n\"title_ngram\": \"wir\nwire wirel...\", // for\nautocomplete\n\"description\": \"Active\nnoise cancelling...\",\n\"brand\": \"SoundMax\",\n\"category\":\n[\"Electronics\",\n\"Audio\",\n\"Headphones\"],\n\"price\": 7999,\n\"rating_avg\": 4.3,\n\"rating_count\": 1847,\n\"in_stock\": true,\n\"seller_id\":\n\"seller-xyz\",\n\"is_prime\": true,\n\"created_at\":\n\"2025-06-15\",\n\"sales_rank\": 1234\n// for relevance\nboost","originalText":"\"product_id\":\n\"prod-abc123\",\n\"title\": \"Wireless\nBluetooth\nHeadphones\",\n\"title_ngram\": \"wir\nwire wirel...\", // for\nautocomplete\n\"description\": \"Active\nnoise cancelling...\",\n\"brand\": \"SoundMax\",\n\"category\":\n[\"Electronics\",\n\"Audio\",\n\"Headphones\"],\n\"price\": 7999,\n\"rating_avg\": 4.3,\n\"rating_count\": 1847,\n\"in_stock\": true,\n\"seller_id\":\n\"seller-xyz\",\n\"is_prime\": true,\n\"created_at\":\n\"2025-06-15\",\n\"sales_rank\": 1234\n// for relevance\nboost","textAlign":"left","verticalAlign":"middle","containerId":"shape-10","lineHeight":1.3,"autoResize":false,"customData":{"revealStep":6}},{"angle":0,"strokeColor":"#a68a53","backgroundColor":"#fff7e6","fillStyle":"solid","strokeWidth":1.5,"strokeStyle":"solid","roughness":0.7,"opacity":100,"version":1,"versionNonce":1,"isDeleted":false,"groupIds":["step-7"],"frameId":null,"roundness":null,"boundElements":[{"type":"text","id":"shape-13"}],"updated":0,"link":null,"locked":false,"id":"shape-12","type":"rectangle","seed":917,"x":16,"y":2215.4,"width":288,"height":293.40000000000003,"customData":{"revealStep":7}},{"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-7"],"frameId":null,"roundness":null,"boundElements":null,"updated":0,"link":null,"locked":false,"id":"shape-13","type":"text","seed":990,"x":36,"y":2233.4,"width":248,"height":257.40000000000003,"fontSize":22,"fontFamily":1,"text":"Ranking formula\n(simplified):\nscore =\ntext_relevance × 0.4\nsales_rank_boost ×\n0.25\nrating_score × 0.15\nrecency_boost × 0.1\nprime_boost × 0.1","originalText":"Ranking formula\n(simplified):\nscore =\ntext_relevance × 0.4\nsales_rank_boost ×\n0.25\nrating_score × 0.15\nrecency_boost × 0.1\nprime_boost × 0.1","textAlign":"left","verticalAlign":"middle","containerId":"shape-12","lineHeight":1.3,"autoResize":false,"customData":{"revealStep":7}}],"appState":{"viewBackgroundColor":"#fbfbf8","gridSize":null},"files":{}}