{"id":16370,"date":"2024-09-25T17:13:09","date_gmt":"2024-09-26T00:13:09","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=16370"},"modified":"2025-06-13T21:54:21","modified_gmt":"2025-06-14T04:54:21","slug":"simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/","title":{"rendered":"JSON\uc5d0\uc11c \uc2e4\uc2dc\uac04 \ubd84\uc11d \uac04\uc18c\ud654\ud558\uae30: \uce74\ud3a0\ub77c \uceec\ub7fc\ud615 \ub300 ClickHouse"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">\ub370\uc774\ud130\uc758 \uc6d0\ud65c\ud55c \ud750\ub984\uc744 \ubcf4\uc7a5\ud558\ub294 \uac83\uc740 \ud6a8\uacfc\uc801\uc778 \ubd84\uc11d\uacfc \uc758\uc0ac\uacb0\uc815\uc744 \uc704\ud574 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. \uc624\ub298\ub0a0\uc5d0\ub294 \ub370\uc774\ud130\uac00 \ube44\uc815\ud615\ud654\ub418\uace0 \uc911\ucca9\ub418\ub294 \uacbd\uc6b0\uac00 \ub9ce\uae30 \ub54c\ubb38\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc120\ud0dd\uc774 \ucc98\ub9ac \ud6a8\uc728\uc131\uacfc \ucffc\ub9ac \uc131\ub2a5\uc744 \ucd5c\uc801\ud654\ud558\ub294 \ub370 \uc911\uc694\ud55c \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\uc774 \ube14\ub85c\uadf8 \uac8c\uc2dc\ubb3c\uc5d0\uc11c\ub294 NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc778 MongoDB\uc5d0\uc11c \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc778 ClickHouse\ub85c \ub370\uc774\ud130\ub97c \uc218\uc9d1\ud558\ub294 \ud504\ub85c\uc138\uc2a4\ub97c \uc0b4\ud3b4\ubd05\ub2c8\ub2e4. <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/products\/analytics\/\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uce74\ud3a0\ub77c \uceec\ub7fc<\/a>\ub77c\ub294 NoSQL \ubd84\uc11d \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \ud544\uc694\ud55c \uc804\ucc98\ub9ac, \uc218\uc9d1 \ud6c4 \uc870\uc778\uc744 \uc704\ud55c \ucffc\ub9ac \ud6a8\uc728\uc131, \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \ubcc0\uacbd\uc744 \ucc98\ub9ac\ud558\ub294 \ubc29\uc2dd\uc5d0 \ucd08\uc810\uc744 \ub9de\ucd9c \uac83\uc785\ub2c8\ub2e4. \ub610\ud55c, \uc911\ucca9\ub41c \ub370\uc774\ud130 \uc791\uc5c5\uc744 \uac04\uc18c\ud654\ud558\uc5ec ClickHouse\uc640 \uac19\uc740 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubcf5\uc7a1\uc131\uc5d0 \ube44\ud574 \uc800\uc7a5\uacfc \ucffc\ub9ac\uac00 \ub354 \uc26c\uc6cc\uc9c0\ub294 Capella Columnar\uc758 \ud65c\uc6a9 \ubc29\ubc95\uc744 \ubcf4\uc5ec\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<hr \/>\n<p><strong>TL;DR<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">ClickHouse\ub294 \uc911\ucca9\ub41c \ub370\uc774\ud130\uc758 \uc911\ucca9 \ud574\uc81c\ub85c \uc778\ud574 \ub370\uc774\ud130 \uc218\uc9d1\uc744 \uc704\ud55c \uad11\ubc94\uc704\ud55c \uc804\ucc98\ub9ac\uac00 \ud544\uc694\ud558\uba70, \uc0c8 \ud544\ub4dc\ub97c \ucd94\uac00\ud558\ub824\uba74 \ucd94\uac00 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc5b4\uc57c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e8\uc77c \ubabd\uace0DB \uceec\ub809\uc158\uc758 \ub370\uc774\ud130\ub97c \ubcc4\ub3c4\uc758 \ud14c\uc774\ube14\ub85c \ubd84\ud560\ud574\uc57c \ud558\ubbc0\ub85c \ucffc\ub9ac\ub97c \uc704\ud574 \uc870\uc778\uc774 \ud544\uc694\ud558\uba70, \uc774\ub294 \ub9ac\uc18c\uc2a4 \uc9d1\uc57d\uc801\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c \uc911\ucca9\ub41c \uc0c8 \ud544\ub4dc\ub97c \uc2e4\uc2dc\uac04\uc73c\ub85c \ucd94\uac00\ud558\ub824\uba74 \ubcc4\ub3c4\uc758 \ud14c\uc774\ube14\uc744 \ub2e4\uc2dc \ub9cc\ub4e4\uace0 \uc2a4\ud0a4\ub9c8\ub97c \uc5c5\ub370\uc774\ud2b8\ud574\uc57c \ud558\ubbc0\ub85c \ud30c\uc774\ud504\ub77c\uc778\uc774 \uc911\ub2e8\ub420 \uac00\ub2a5\uc131\uc774 \uc788\uace0 \uc218\ub3d9 \uac1c\uc785\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. \ubc18\uba74, Capella Columnar\ub294 \uc911\ucca9\ub41c \ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc804\ucc98\ub9ac\uac00 \ud544\uc694\ud558\uc9c0 \uc54a\uc544 \ud504\ub85c\uc138\uc2a4\ub97c \uac04\uc18c\ud654\ud569\ub2c8\ub2e4. \ubcc4\ub3c4\uc758 \ud14c\uc774\ube14\uc774\ub098 \uc870\uc778 \uc5c6\uc774\ub3c4 MongoDB \uceec\ub809\uc158\uc5d0\uc11c \uc9c1\uc811 \uc218\uc9d1\ud560 \uc218 \uc788\uc73c\uba70, \ucd94\uac00 \ucc98\ub9ac \uc5c6\uc774 \uc911\ucca9\ub41c \uc0c8 \ud544\ub4dc \ucd94\uac00\uc640 \uac19\uc740 \uc2e4\uc2dc\uac04 \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc790\ub3d9\uc73c\ub85c \ubc18\uc601\ud569\ub2c8\ub2e4.<\/span><\/p>\n<hr \/>\n<h2>\uce74\ud3a0\ub77c \uceec\ub7fc\uc774\ub780 \ubb34\uc5c7\uc778\uac00\uc694?<\/h2>\n<p>\uc774 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ub370\ubaa8\ub97c \uc0b4\ud3b4\ubcf4\uae30 \uc804\uc5d0 Capella Columnar\uc5d0 \ub300\ud55c \uc2ec\uce35\uc801\uc778 \uac1c\uc694 \ub3d9\uc601\uc0c1\uc744 \uc2dc\uccad\ud558\uac70\ub098 \ub2e4\uc74c \ub0b4\uc6a9\uc744 \uc77d\uc5b4\ubcf4\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/free-tier-capella-columnar-mobile-vector-search-and-more\/\">\ucd5c\uadfc \ubc1c\ud45c<\/a> \uc6b4\uc601 \ubc0f \uc2e4\uc2dc\uac04 \ubd84\uc11d \uc6cc\ud06c\ub85c\ub4dc\ub97c \ud1b5\ud569\ud558\ub294 \uc774 \uc0c8\ub85c\uc6b4 \uae30\uc220\uc744 \uc18c\uac1c\ud569\ub2c8\ub2e4:<\/p>\n<p><iframe loading=\"lazy\" title=\"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uce74\ud3a0\ub77c \uceec\ub7fc\ud615: \uc2ec\uce35\uc801\uc778 \uae30\uc220 \uac1c\uc694\" width=\"900\" height=\"506\" src=\"https:\/\/www.youtube.com\/embed\/pXoenAEhz9Q?feature=oembed&#038;enablejsapi=1&#038;origin=https:\/\/www.couchbase.com\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h2><span style=\"font-weight: 400;\">\uc0d8\ud50c \ubabd\uace0DB \ub370\uc774\ud130<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">\uc774 \ub370\ubaa8\uc758 \ubc94\uc704\uc5d0\uc11c\ub294 \uc0d8\ud50c MongoDB \uceec\ub809\uc158\uc744 \uc0ac\uc6a9\ud588\uc2b5\ub2c8\ub2e4. <\/span><span style=\"font-weight: 400;\">\uadf9\uc7a5<\/span><span style=\"font-weight: 400;\"> \uc758 <\/span><em><span style=\"font-weight: 400;\">sample_mflix <\/span><\/em><span style=\"font-weight: 400;\">\ub370\uc774\ud130\ubca0\uc774\uc2a4.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\ub2e4\uc74c\uc740 \uadf9\uc7a5 \uceec\ub809\uc158\uc758 \uc0d8\ud50c \ubb38\uc11c\uc785\ub2c8\ub2e4:<\/span><\/p>\n<pre class=\"nums:false lang:default decode:true\">{\r\n  \"_id\": {\r\n    \"$oid\": \"59a47286cfa9a3a73e51e72c\"\r\n  },\r\n  \"theaterId\": 1000,\r\n  \"location\": {\r\n    \"address\": {\r\n      \"street1\": \"x1\",\r\n      \"city\": \"\ube14\ub8e8\ubc0d\ud134\",\r\n      \"state\": \"MN\",\r\n      \"\uc6b0\ud3b8\ubc88\ud638\": \"55425\"\r\n    },\r\n    \"geo\": {\r\n      \"type\": \"\ud3ec\uc778\ud2b8\",\r\n      \"\uc88c\ud45c\": [\r\n        -93.24565,\r\n        44.85466\r\n      ]\r\n    }\r\n  }\r\n}<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16371\" style=\"border: 1px solid black;\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image1-5-1024x535.png\" alt=\"\" width=\"900\" height=\"470\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image1-5-1024x535.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image1-5-300x157.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image1-5-768x401.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image1-5-1536x803.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image1-5-1320x690.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image1-5.png 1999w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<h2><span style=\"font-weight: 400;\">\ubabd\uace0DB\uc5d0\uc11c \uce74\ud3a0\ub77c \uceec\ub7fc\uc73c\ub85c \ub370\uc774\ud130 \uc218\uc9d1<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">\uce74\ud3a0\ub77c \uceec\ub7fc\ub7ec\uc758 \uce74\ud504\uce74 \ub9c1\ud06c\ub97c \ud65c\uc6a9\ud558\uc5ec \ubabd\uace0DB \uceec\ub809\uc158\uc758 \ub370\uc774\ud130\uac00 \uc774\ubbf8 \uac8c\uc2dc\ub418\uc5b4 \uc788\ub294 \uce74\ud504\uce74 \uc8fc\uc81c\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc218\uc9d1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><span style=\"font-weight: 400;\"> \uc774\ub97c \uc704\ud574\uc11c\ub294 \uc0ac\uc6a9\uc790\uac00 Kafka \ud30c\uc774\ud504\ub77c\uc778\uc744 \uc124\uc815\ud574\uc57c \ud558\uba70, \uc5ec\uae30\uc11c MongoDB \ub370\uc774\ud130\ub97c Kafka \ud1a0\ud53d\uc73c\ub85c \ud37c\ub110\ub9c1\ud574\uc57c \ud569\ub2c8\ub2e4.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">1\ub2e8\uacc4 - \ubabd\uace0DB\ub97c Kafka\uc5d0 \uc5f0\uacb0\ud558\uae30<\/span><\/h3>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\ub2e4\uc6b4\ub85c\ub4dc <\/span><a href=\"https:\/\/debezium.io\/documentation\/reference\/stable\/connectors\/mongodb.html\"><span style=\"font-weight: 400;\">\ub370\ubca0\uc9c0\uc6c0 \ubabd\uace0DB \uc18c\uc2a4 \ucee4\ub125\ud130<\/span><\/a><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\ub3c5\ub9bd\ud615 \ub610\ub294 \ubd84\uc0b0 \ubaa8\ub4dc\uc5d0\uc11c Kafka Connect \uc2e4\ud589\ud558\uae30<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\uc5f0\uacb0\uc5d0 \ud544\uc694\ud55c \uc5f0\uacb0 \uc18d\uc131\uacfc \ud568\uaed8 POST \uc694\uccad\uc744 \ubcf4\ub0b4\uc138\uc694. <\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span> <span style=\"font-weight: 400;\">MongoDB<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<pre class=\"nums:false lang:default decode:true\">curl -X POST -H \"Content-Type: application\/json\" https:\/\/localhost:8083\/connectors -d '{\"name\": \"\",\"config\": {\r\n        \"connector.class\": \"io.debezium.connector.mongodb.MongoDbConnector\",\r\n        \"capture.mode\": \"change_streams_update_full\",\r\n        \"mongodb.ssl.enabled\": \"true\",\r\n        \"topic.\uc811\ub450\uc0ac\": \"\",\r\n        \"value.converter\": \"org.apache.kafka.connect.json.JsonConverter\",\r\n        \"value.converter.schemas.enable\": \"false\",\r\n        \"key.converter.schemas.enable\": \"false\",\r\n        \"key.converter\": \"org.apache.kafka.connect.json.JsonConverter\",\r\n        \"collection.include.list\": \"sample_mflix.theaters\",\r\n        \"mongodb.connection.string\":}}'\u00af<\/pre>\n<p><i><span style=\"font-weight: 400;\">\uceec \uc694\uccad\uc758 \uc790\ub9ac \ud45c\uc2dc\uc790\ub97c \ub300\uad04\ud638(\uc608: \ub300\uad04\ud638\ub85c \ud45c\uc2dc\ub428)\ub85c \ubc14\uafb8\uc5b4 \uc8fc\uc138\uc694, <\/span><\/i><i><span style=\"font-weight: 400;\">&lt;value&gt;<\/span><\/i><i><span style=\"font-weight: 400;\">)\ub97c \ud2b9\uc815 \uc0ac\uc6a9 \uc0ac\ub840\uc5d0 \uc801\ud569\ud55c \uac12\uc73c\ub85c \uc124\uc815\ud558\uc138\uc694.<\/span><\/i><\/p>\n<p><span style=\"font-weight: 400;\">\uadf8 \ud6c4\uc5d0\ub294 \ub370\uc774\ud130\uac00 Kafka \ud1a0\ud53d\uc73c\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4. \ub370\uc774\ud130\ub294 Confluent Kafka \uc8fc\uc81c\uc5d0 \ud45c\uc2dc\ub429\ub2c8\ub2e4. <\/span><em>mongo_columnar_topic.sample_mflix.theaters<\/em>:<\/p>\n<p><span style=\"font-weight: 400;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16372\" style=\"border: 1px solid black;\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image9-1024x499.png\" alt=\"\" width=\"900\" height=\"439\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image9-1024x499.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image9-300x146.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image9-768x374.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image9-1536x748.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image9-1320x643.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image9.png 1999w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/span><\/p>\n<p><span style=\"font-weight: 400;\">\uc774\uc81c \uce74\ud504\uce74 \ud1a0\ud53d\uc758 \ub370\uc774\ud130\ub97c \uce74\ud3a0\ub77c \uceec\ub7fc\uc744 \uc0ac\uc6a9\ud558\uc5ec \uce74\ud504\uce74 \ud1a0\ud53d\uc758 \ub370\uc774\ud130\ub97c \uceec\ub809\uc158\uc73c\ub85c \uac00\uc838\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">2\ub2e8\uacc4 - \uce74\ud3a0\ub77c \uceec\ub7fc\uc5d0\uc11c \ub9c1\ud06c \ub9cc\ub4e4\uae30<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\uc774 \uc608\uc5d0\uc11c\ub294 Confluent Kafka\ub97c Kafka \ud50c\ub808\uc774\ubc84\ub85c \uc0ac\uc6a9\ud558\uace0 \uc788\uc73c\uba70, Capella Columnar\ub294 Amazon MSK\ub3c4 \uc9c0\uc6d0\ud569\ub2c8\ub2e4.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16373\" style=\"border: 1px solid black;\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image4-1-1024x500.png\" alt=\"\" width=\"900\" height=\"439\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image4-1-1024x500.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image4-1-300x147.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image4-1-768x375.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image4-1-1536x751.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image4-1-1320x645.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image4-1.png 1999w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16374\" style=\"border: 1px solid black;\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image3-3-1024x503.png\" alt=\"\" width=\"900\" height=\"442\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image3-3-1024x503.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image3-3-300x147.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image3-3-768x377.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image3-3-1536x755.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image3-3-1320x648.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image3-3.png 1999w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<h3><span style=\"font-weight: 400;\">3\ub2e8\uacc4 - \ub9c1\ud06c\ub41c \uceec\ub809\uc158 \ub9cc\ub4e4\uae30<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\ub9c1\ud06c\ub97c \ub9cc\ub4e0 \ud6c4\uc5d0\ub294 \ub370\uc774\ud130\uac00 \uc800\uc7a5\ub420 \ub9c1\ud06c\ub41c \uceec\ub809\uc158\uc744 \ub9cc\ub4e4\uc5b4\uc57c \ud569\ub2c8\ub2e4:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16375\" style=\"border: 1px solid black;\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image5-2-1024x503.png\" alt=\"\" width=\"900\" height=\"442\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image5-2-1024x503.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image5-2-300x147.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image5-2-768x377.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image5-2-1536x754.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image5-2-1320x648.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image5-2.png 1999w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">\ud544\ub4dc\ub294 \uc790\uccb4 \uc124\uba85\uc774 \ud544\uc694 \uc5c6\uc73c\uba70, \ud544\ub4dc \uae30\ubcf8 \ud0a4\ub294 Kafka \uc8fc\uc81c\uc5d0 \uc788\ub294 MongoDB \ubb38\uc11c\uc758 \uae30\ubcf8 \ud0a4 \uacbd\ub85c\uc785\ub2c8\ub2e4. \uc8fc\uc5b4\uc9c4 \uc608\uc81c\uc5d0\uc11c MongoDB \ubb38\uc11c\uc758 \uae30\ubcf8 \ud0a4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <em>objectId<\/em>:<\/span><\/p>\n<pre class=\"nums:false lang:default decode:true\">_id`$oid`: \ubb38\uc790\uc5f4<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16376\" style=\"border: 1px solid black;\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image17-1024x502.png\" alt=\"\" width=\"900\" height=\"441\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image17-1024x502.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image17-300x147.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image17-768x377.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image17-1536x753.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image17-1320x647.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image17.png 1999w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">CDC\ub97c \ud65c\uc131\ud654\ud558\uba74 Capella Columnar \uc5d4\uc9c4\uc774 \uc774\ud574\ud558\ub294 \ubb38\uc11c \ud615\uc2dd\uc5d0 \ub300\ud55c \ud569\uc758\uac00 \uc774\ub8e8\uc5b4\uc9d1\ub2c8\ub2e4. \ud604\uc7ac\ub294 \uc18c\uc2a4 \ucee4\ub125\ud130\ub85c Debezium\ub9cc \uc9c0\uc6d0\ud569\ub2c8\ub2e4.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">4\ub2e8\uacc4 - \ub9c1\ud06c \uc5f0\uacb0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\uceec\ub809\uc158\uc744 \ub9cc\ub4e0 \ud6c4\uc5d0\ub294 \ub2e4\uc74c\uc744 \uc218\ud589\ud574\uc57c \ud569\ub2c8\ub2e4. <\/span><b>\uc5f0\uacb0 <\/b><span style=\"font-weight: 400;\">\ub9c1\ud06c\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16377\" style=\"border: 1px solid black;\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image8-1-1024x500.png\" alt=\"\" width=\"900\" height=\"439\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image8-1-1024x500.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image8-1-300x147.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image8-1-768x375.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image8-1-1536x751.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image8-1-1320x645.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image8-1.png 1999w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">\ub9c1\ud06c\uac00 \uc5f0\uacb0\ub418\uba74 \uc544\ub798 \ucffc\ub9ac\uc5d0\uc11c \ubcfc \uc218 \uc788\ub4ef\uc774 \ub370\uc774\ud130\uac00 \uc720\uc785\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16378\" style=\"border: 1px solid black;\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image7-2-1024x501.png\" alt=\"\" width=\"900\" height=\"440\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image7-2-1024x501.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image7-2-300x147.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image7-2-768x376.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image7-2-1536x751.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image7-2-1320x646.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image7-2.png 1999w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">MongoDB\uc5d0\uc11c Capella Columnar\ub85c\uc758 \ub370\uc774\ud130 \uc218\uc9d1\uc740 \uc6d0\ud65c\ud558\uace0 \uc9c1\uad00\uc801\uc774\uc5c8\uc2b5\ub2c8\ub2e4. \uc774\uc81c ClickHouse\uc640 \uac19\uc740 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc9c1\uba74\ud558\ub294 \ubb38\uc81c\uc5d0 \uc8fc\ubaa9\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">MongoDB\uc5d0\uc11c ClickHouse\ub85c\uc758 \ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">ClickHouse\ub294 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c, \ubb38\uc11c \uae30\ubc18 \ubc0f \uc911\ucca9\ub41c \ub370\uc774\ud130 \uad6c\uc870\ub85c \uc778\ud574 MongoDB\uc5d0\uc11c \uc9c1\uc811 \ub370\uc774\ud130\ub97c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uc774\ub97c \uc704\ud574\uc11c\ub294 \ucd94\uac00\uc801\uc778 \ub370\uc774\ud130 \ubcc0\ud658 \ub2e8\uacc4\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. MongoDB \ub370\uc774\ud130\uac00 \uc911\ucca9\uc774 \uc2ec\ud558\uac70\ub098 \ucd94\uac00 \ud544\ub4dc\uac00 \ub3c4\uc785\ub41c \uacbd\uc6b0 \uc774\ub7ec\ud55c \ubcc0\ud658\uc758 \ubcf5\uc7a1\uc131\uc774 \uc99d\uac00\ud558\uba70, \uc774\ub7ec\ud55c \ubcc0\uacbd \uc0ac\ud56d\uc744 \uad00\ub9ac\ud558\uae30 \uc704\ud574 \ucd94\uac00 \ud14c\uc774\ube14\uc744 \ub9cc\ub4dc\ub294 \ub4f1\uc758 \uc870\uc815\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/span><\/p>\n<h3>ClickHouse\uc5d0\uc11c MongoDB \uceec\ub809\uc158\uc6a9 \ud14c\uc774\ube14 \ub9cc\ub4e4\uae30<\/h3>\n<p><span style=\"font-weight: 400;\">ClickHouse\uc5d0 \ub9e4\ud551\ub418\ub294 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\ub824\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \ud558\uc138\uc694. <\/span><a href=\"https:\/\/clickhouse.com\/docs\/en\/engines\/table-engines\/integrations\/mongodb\"><span style=\"font-weight: 400;\">MongoDB<\/span><\/a><span style=\"font-weight: 400;\"> \uceec\ub809\uc158\uc5d0\ub294 \ub2e4\uc74c \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4:<\/span><\/p>\n<pre class=\"nums:false lang:default decode:true\">\ud14c\uc774\ube14 \uc0dd\uc131 [\uc874\uc7ac\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0] [db.]table_name\r\n(\r\n   name1 [type1],\r\n   name2 [type2],\r\n   ...\r\n) \uc5d4\uc9c4 = \ubabd\uace0DB(\ud638\uc2a4\ud2b8:\ud3ec\ud2b8, \ub370\uc774\ud130\ubca0\uc774\uc2a4, \uceec\ub809\uc158, \uc0ac\uc6a9\uc790, \ube44\ubc00\ubc88\ud638 [, \uc635\uc158]);<\/pre>\n<p><span style=\"font-weight: 400;\">\uc5ec\uae30\uc11c \ucc38\uc870\ud558\ub294 \ubabd\uace0DB \uceec\ub809\uc158\uc740 \ub2e4\uc74c\uacfc \uac19\uc544\uc57c \ud569\ub2c8\ub2e4. <em>\uc911\ucca9\ub418\uc9c0 \uc54a\uc74c<\/em> \ub97c \uac00\ub9ac\ud0a4\uae30 \uc804\uc5d0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\uc6b0\ub9ac\ub294 <\/span><span style=\"font-weight: 400;\">\uadf9\uc7a5<\/span><span style=\"font-weight: 400;\"> \uceec\ub809\uc158\uc5d0 \uc800\uc7a5\ud558\uba70, \uc6b0\ub9ac\uc758 \ubaa9\ud45c\ub294 \uc774 \ub370\uc774\ud130\ub97c ClickHouse\uc5d0\uc11c \uad6c\uc870\ud654\ub41c \uad00\uacc4\ud615 \ud615\uc2dd\uc73c\ub85c \ud45c\ud604\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">ClickHouse\ub294 \uc911\ucca9\ub41c \ud544\ub4dc\ub97c \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uc73c\ubbc0\ub85c, \uc911\ucca9\ub41c \ud544\ub4dc\ub97c \ucc98\ub9ac\ud558\uae30 \uc704\ud574 \uc138 \uac1c\uc758 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc5b4\uc57c \ud569\ub2c8\ub2e4. <\/span><span style=\"font-weight: 400;\">\uadf9\uc7a5<\/span><span style=\"font-weight: 400;\"> \ub370\uc774\ud130\uc5d0 \uc774\ub7ec\ud55c \uc2a4\ud0a4\ub9c8\ub97c \uc801\uc6a9\ud569\ub2c8\ub2e4:<\/span><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>\uadf9\uc7a5<\/b><span style=\"font-weight: 400;\">: _id, theaterId<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>\uadf9\uc7a5_\uc704\uce58_\uc8fc\uc18c<\/b><span style=\"font-weight: 400;\">: \uac70\ub9ac1, \ub3c4\uc2dc, \uc8fc, \uc6b0\ud3b8\ubc88\ud638<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>\uadf9\uc7a5_\uc704\uce58_\uc9c0\uc5ed<\/b><span style=\"font-weight: 400;\">\uc720\ud615, \uc88c\ud45c<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3><span style=\"font-weight: 400;\">\uc804\ucc98\ub9ac<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\ub370\uc774\ud130\ub97c \uc900\ube44\ud558\uae30 \uc704\ud574 \uba3c\uc800 MongoDB \uce21\uc5d0\uc11c \uc804\ucc98\ub9ac\ub97c \uc218\ud589\ud558\uc5ec \ud544\uc694\ud55c \ud544\ub4dc\uc758 \uc911\ucca9\uc744 \ud574\uc81c\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc5d0\ub294 \uc911\ucca9\ub41c \ud544\ub4dc\ub97c \ucd94\ucd9c\ud558\uc5ec \ubcc4\ub3c4\uc758 \uceec\ub809\uc158\uc73c\ub85c \ud50c\ub7ab\ud654\ud558\uae30 \uc704\ud55c MongoDB \ud30c\uc774\ud504\ub77c\uc778\uc744 \uc0dd\uc131\ud558\ub294 \uc791\uc5c5\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4. <\/span><em><span style=\"font-weight: 400;\">\uc8fc\uc18c<\/span><\/em><span style=\"font-weight: 400;\"> \uadf8\ub9ac\uace0 <\/span><em><span style=\"font-weight: 400;\">\uc9c0\ub9ac\uc801<\/span><\/em><span style=\"font-weight: 400;\">\uc640 <\/span><em><span style=\"font-weight: 400;\">\uadf9\uc7a5<\/span><\/em><span style=\"font-weight: 400;\"> \ud14c\uc774\ube14\uc744 \uc9c1\uc811 \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p>MongoDB\uc6a9 \ud30c\uc774\ud504\ub77c\uc778 <em>\uc8fc\uc18c <\/em>\uceec\ub809\uc158:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16379\" style=\"border: 1px solid black;\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image14-1024x587.png\" alt=\"\" width=\"900\" height=\"516\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image14-1024x587.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image14-300x172.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image14-768x440.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image14-1536x881.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image14-1320x757.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image14.png 1999w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<p>\ub2e4\uc74c \ub300\uc0c1 \ud30c\uc774\ud504\ub77c\uc778 <i>\uc9c0\ub9ac\uc801<\/i><span style=\"font-weight: 400;\"> \uceec\ub809\uc158:<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16380\" style=\"border: 1px solid black;\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image6-2-1024x531.png\" alt=\"\" width=\"900\" height=\"467\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image6-2-1024x531.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image6-2-300x156.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image6-2-768x398.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image6-2-1536x797.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image6-2-1320x685.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image6-2.png 1999w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><br \/>\n<\/span><\/p>\n<h3>ClickHouse\uc5d0\uc11c \ud14c\uc774\ube14 \ub9cc\ub4e4\uae30<\/h3>\n<p><span style=\"font-weight: 400;\">\uc804\ucc98\ub9ac\uac00 \uc644\ub8cc\ub418\uba74 ClickHouse\uc5d0\uc11c \ud574\ub2f9 \ud14c\uc774\ube14 3\uac1c\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4:<\/span><\/p>\n<p>\uc0dd\uc131\ud560 \ucffc\ub9ac <em>\uadf9\uc7a5<\/em>:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16381\" style=\"border: 1px solid black;\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image15-1024x508.png\" alt=\"\" width=\"900\" height=\"446\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image15-1024x508.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image15-300x149.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image15-768x381.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image15-1536x762.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image15-1320x655.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image15.png 1999w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<p>\uc0dd\uc131\ud560 \ucffc\ub9ac <em>\uadf9\uc7a5\uc758_\uc704\uce58_\uc8fc\uc18c:<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16382\" style=\"border: 1px solid black;\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image2-5-1024x539.png\" alt=\"\" width=\"900\" height=\"474\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image2-5-1024x539.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image2-5-300x158.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image2-5-768x405.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image2-5-1536x809.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image2-5-1320x695.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image2-5.png 1999w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<p>\uc0dd\uc131\ud560 \ucffc\ub9ac <em>\uadf9\uc7a5_\uc704\uce58_\uc9c0\uc5ed<\/em>:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16383\" style=\"border: 1px solid black;\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image13-1024x514.png\" alt=\"\" width=\"900\" height=\"452\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image13-1024x514.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image13-300x151.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image13-768x386.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image13-1536x771.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image13-1320x663.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image13.png 1999w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">MongoDB\uc5d0\uc11c ClickHouse\ub85c \ub370\uc774\ud130 \uc218\uc9d1\uc744 \uc644\ub8cc\ud588\uc73c\ub2c8, \uc774\uc81c \ub450 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \ubcc0\uacbd\uc774 \uc5b4\ub5bb\uac8c \ucc98\ub9ac\ub418\ub294\uc9c0 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. ClickHouse\uc5d0\uc11c \uc9c1\uba74\ud55c \ubb38\uc81c\uc640 \ube44\uad50\ud558\uc5ec Capella Columnar\uc5d0\uc11c \uc774\ub7ec\ud55c \ubcc0\uacbd \uc0ac\ud56d\uc744 \uad00\ub9ac\ud558\ub294 \uac83\uc774 \uc5bc\ub9c8\ub098 \uc26c\uc6b4\uc9c0 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">\uc2e4\uc2dc\uac04 \ubcc0\uacbd \uc0ac\ud56d\uc740 \uc5b4\ub5bb\uac8c \ucc98\ub9ac\ub418\ub098\uc694?<\/span><\/h2>\n<h3>\ubabd\uace0DB \uce21\uc5d0\uc11c \uc218\uc815<\/h3>\n<p><span style=\"font-weight: 400;\">MongoDB\uc5d0\uc11c \ubb38\uc11c \ud558\ub098\ub97c \ubcc0\uacbd\ud558\uace0 \uc911\ucca9\ub41c \uc18c\uc720\uc790 \ud544\ub4dc\ub97c \ucd94\uac00\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<pre class=\"nums:false lang:default decode:true\">{\r\n  \"\uc18c\uc720\uc790\": {\r\n    \"name\": \"John\",\r\n    \"age\": 50\r\n  }\r\n}<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16384\" style=\"border: 1px solid black;\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image16-1024x503.png\" alt=\"\" width=\"900\" height=\"442\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image16-1024x503.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image16-300x147.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image16-768x377.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image16-1536x755.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image16-1320x648.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image16.png 1999w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<h3>\uce74\ud3a0\ub77c \uceec\ub7fc\uc758 \uc2e4\uc2dc\uac04 CDC \ubcc0\uacbd \uc0ac\ud56d<\/h3>\n<p><span style=\"font-weight: 400;\">\ucd94\uac00 \ub2e8\uacc4\uac00 \ud544\uc694\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ud2b9\uc815 \ubb38\uc11c\ub97c \ucffc\ub9ac\ud558\uba74 \ubcc0\uacbd \uc0ac\ud56d\uc774 \ubc18\uc601\ub418\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16385\" style=\"border: 1px solid black;\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image12-1024x504.png\" alt=\"\" width=\"900\" height=\"443\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image12-1024x504.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image12-300x148.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image12-768x378.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image12-1536x756.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image12-1320x650.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image12.png 1999w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<h3><span style=\"font-weight: 400;\">ClickHouse \uc124\uc815<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">ClickHouse\ub294 \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc9c1\uc811 \uac00\uc838\uc624\ub824\uace0 \ud560 \ub54c \ud30c\uc774\ud504\ub77c\uc778\uc774 \ub04a\uc5b4\uc9c0\uae30 \ub54c\ubb38\uc5d0 \uc2e4\uc2dc\uac04 \ubcc0\uacbd\uc5d0 \uc5b4\ub824\uc6c0\uc744 \uacaa\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\uc5c5\ub370\uc774\ud2b8\ub41c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub824\uba74 <\/span><em><span style=\"font-weight: 400;\">\uc18c\uc720\uc790<\/span><\/em><span style=\"font-weight: 400;\"> \ud544\ub4dc\ub97c \uc0ac\uc6a9\ud558\ub824\uba74 ClickHouse\uc5d0 \ub2e4\ub978 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uba3c\uc800, \uc0c8 \ubabd\uace0DB \uceec\ub809\uc158\uc744 \ub9cc\ub4e4\uace0 \uc5ec\uae30\uc5d0 <\/span><em><span style=\"font-weight: 400;\">\uc18c\uc720\uc790<\/span><\/em><span style=\"font-weight: 400;\"> \ud544\ub4dc\uac00 \uc911\ucca9\ub418\uc9c0 \uc54a\uc740 \uacbd\uc6b0 ClickHouse\uc5d0\uc11c \ud574\ub2f9 \ud14c\uc774\ube14\uc744 \uc815\uc758\ud569\ub2c8\ub2e4.<\/span><\/p>\n<p>\uc18c\uc720\uc790 \uceec\ub809\uc158\uc744 \uc0dd\uc131\ud558\uae30 \uc704\ud55c MongoDB\uc758 \ud30c\uc774\ud504\ub77c\uc778:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16386\" style=\"border: 1px solid black;\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image11-1024x505.png\" alt=\"\" width=\"900\" height=\"444\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image11-1024x505.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image11-300x148.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image11-768x378.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image11-1536x757.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image11-1320x650.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image11.png 1999w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><b><\/b><\/p>\n<p>\uc0dd\uc131\ud558\uae30 <em>\uc18c\uc720\uc790<\/em> \ud14c\uc774\ube14\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16387\" style=\"border: 1px solid black;\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image10-1024x509.png\" alt=\"\" width=\"900\" height=\"447\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image10-1024x509.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image10-300x149.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image10-768x382.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image10-1536x763.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image10-1320x656.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image10.png 1999w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">\uc774\uc81c \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud558\ub294 \ub2e8\uacc4\ub85c \ub118\uc5b4\uac00\uba74\uc11c, ClickHouse\uc5d0\uc11c\ub294 \uac04\ub2e8\ud55c \ucffc\ub9ac\ub77c\ub3c4 \uc2e4\ud589\ud558\ub824\uba74 \uc6d0\ubcf8 \ub370\uc774\ud130\uc758 \uc911\ucca9\uc744 \ud574\uc81c\ud558\uae30 \uc704\ud574 \uc11c\ub85c \ub2e4\ub978 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud588\uae30 \ub54c\ubb38\uc5d0 \ub370\uc774\ud130\ub97c \uc11c\ub85c \uc5f0\uacb0\ud574\uc57c \ud55c\ub2e4\ub294 \uc810\uc5d0 \uc720\uc758\ud574\uc57c \ud569\ub2c8\ub2e4. \ubc18\uba74, Capella Columnar\ub294 \uc774\ub7ec\ud55c \ucffc\ub9ac\ub97c \uc190\uc27d\uac8c \ucc98\ub9ac\ud558\ubbc0\ub85c \ucd94\uac00 \ub2e8\uacc4\uac00 \ud544\uc694\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">\uce74\ud3a0\ub77c \uceec\ub7fc\ud615\uacfc \ud074\ub9ad\ud558\uc6b0\uc2a4\uc5d0\uc11c \ub370\uc774\ud130 \ucffc\ub9ac\ud558\uae30<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">\ubaa8\ub4e0 <\/span><em><span style=\"font-weight: 400;\">theaterId<\/span><\/em><span style=\"font-weight: 400;\"> \uadf8\ub9ac\uace0 <\/span><span style=\"font-weight: 400;\"><em>street1<\/em><\/span><span style=\"font-weight: 400;\">\u00a0\uc5ec\uae30\uc11c <\/span><em><span style=\"font-weight: 400;\">geo<\/span><\/em> <span style=\"font-weight: 400;\">\uc720\ud615<\/span><span style=\"font-weight: 400;\"> \ub294 <\/span><em><span style=\"font-weight: 400;\">\ud3ec\uc778\ud2b8<\/span><\/em><span style=\"font-weight: 400;\"> \ud074\ub9ad\ud558\uc6b0\uc2a4\uc640 \uce74\ud3a0\ub77c \uceec\ub7fc\uc5d0\uc11c \ubaa8\ub450 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\uce74\ud3a0\ub77c \uceec\ub7fc\uc5d0 \ub300\ud55c \ucffc\ub9ac:<\/span><\/p>\n<pre class=\"nums:false lang:default decode:true\">columnar_th\uc5d0\uc11c theaterId, address.street1\uc744 \uc120\ud0dd\ud558\uace0 geo.type = 'Point'\ub97c \uc785\ub825\ud569\ub2c8\ub2e4;<\/pre>\n<p><span style=\"font-weight: 400;\">ClickHouse\uc5d0 \ub300\ud55c \ucffc\ub9ac:<\/span><\/p>\n<pre class=\"nums:false wrap:true lang:default decode:true\">theaters_location_geo\uc5d0\uc11c theaterId, street1 select `type` = 'Point'\uc778 theaters_location_geo.theaterId = theaters_location_address.theaterId\uc758 inner join theaters_location_address;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-16388\" style=\"border: 1px solid black;\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image18-1024x482.png\" alt=\"\" width=\"900\" height=\"424\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image18-1024x482.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image18-300x141.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image18-768x362.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image18-1536x723.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image18-1320x621.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/image18.png 1999w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/p>\n<h2><span style=\"font-weight: 400;\">ClickHouse\uc640 \uce74\ud3a0\ub77c \uceec\ub7fc \ube44\uad50<\/span><\/h2>\n<table>\n<tbody>\n<tr>\n<td><b>\ub9e4\uac1c\ubcc0\uc218<\/b><\/td>\n<td><b>ClickHouse<\/b><\/td>\n<td><b>\uce74\ud3a0\ub77c \uce7c\ub7fc<\/b><\/td>\n<\/tr>\n<tr>\n<td>\ub370\uc774\ud130 \uc218\uc9d1<\/td>\n<td>\uc911\ucca9\ub41c \ub370\uc774\ud130\uc758 \uc911\ucca9 \ud574\uc81c\ub85c \uc778\ud574 \uad11\ubc94\uc704\ud55c \uc0ac\uc804 \ucc98\ub9ac\uac00 \ud544\uc694\ud558\uba70, \ud544\ub4dc\ub97c \uc5f4\uc5d0 \ucd94\uac00\ud558\uba74 \ucd94\uac00 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc5b4\uc57c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/td>\n<td>\uc911\ucca9\ub41c \ub370\uc774\ud130\uc5d0\ub294 \uc804\ucc98\ub9ac\uac00 \ud544\uc694\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/td>\n<\/tr>\n<tr>\n<td>\uc2a4\ud0a4\ub9c8 \ubc0f \ub370\uc774\ud130 \ubcc0\ud658<\/td>\n<td>\ub2e8\uc77c \ubabd\uace0DB \uceec\ub809\uc158\uc758 \ub370\uc774\ud130\ub97c \ubcc4\ub3c4\uc758 \ud14c\uc774\ube14\ub85c \ubd84\ud560\ud574\uc57c \ud558\uba70, \ucffc\ub9ac\ub97c \uc704\ud574 \uc870\uc778\uc774 \ud544\uc694\ud558\ubbc0\ub85c \ube44\uc6a9\uc774 \ub9ce\uc774 \ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/td>\n<td>\ubcc4\ub3c4\uc758 \ud14c\uc774\ube14\uc774\ub098 \uc870\uc778 \uc5c6\uc774\ub3c4 MongoDB \uceec\ub809\uc158\uc5d0\uc11c \uc9c1\uc811 \ub370\uc774\ud130\ub97c \uc218\uc9d1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/td>\n<\/tr>\n<tr>\n<td>\uc2e4\uc2dc\uac04 \ub370\uc774\ud130 \ubcc0\uacbd \uc0ac\ud56d<\/td>\n<td>\uc911\ucca9\ub41c \uc0c8 \ud544\ub4dc\ub97c \ucd94\uac00\ud558\ub824\uba74 \ub370\uc774\ud130\uc758 \uc911\ucca9\uc744 \ud574\uc81c\ud558\uae30 \uc704\ud574 \ubcc4\ub3c4\uc758 \ud14c\uc774\ube14\uc744 \ub2e4\uc2dc \ub9cc\ub4e4\uc5b4\uc57c \ud558\ubbc0\ub85c \uc2a4\ud0a4\ub9c8 \uc5c5\ub370\uc774\ud2b8\uc640 \ubcf5\uc7a1\ud55c \ubcc0\ud658\uc774 \ud544\uc694\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774\ub85c \uc778\ud574 \ud30c\uc774\ud504\ub77c\uc778\uc774 \uc911\ub2e8\ub418\uace0 \uc218\ub3d9 \uac1c\uc785\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/td>\n<td>\uc911\ucca9\ub41c \uc0c8 \ud544\ub4dc \ucd94\uac00\uc640 \uac19\uc740 \uc2e4\uc2dc\uac04 \ubcc0\uacbd \uc0ac\ud56d\uc740 \ucd94\uac00 \ucc98\ub9ac \uc5c6\uc774 \uc790\ub3d9\uc73c\ub85c \ubc18\uc601\ub429\ub2c8\ub2e4.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span style=\"font-weight: 400;\">\uacb0\ub860<\/span><\/h2>\n<p>\uc694\uc57d\ud558\uba74, Couchbase Capella\ub294 \uc911\ucca9\ub41c MongoDB \ub370\uc774\ud130\ub97c \uc218\uc9d1\ud558\uace0 \ucffc\ub9ac\ud558\ub294 \ubcf4\ub2e4 \uac04\uc18c\ud654\ub41c \uc811\uadfc \ubc29\uc2dd\uc744 \uc81c\uacf5\ud558\uc5ec \uc804\ucc98\ub9ac\ub97c \ucd5c\uc18c\ud654\ud558\uace0 \uc2e4\uc2dc\uac04 \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc27d\uac8c \ucc98\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubc18\uba74, ClickHouse\ub294 \uad11\ubc94\uc704\ud55c \ub370\uc774\ud130 \ubcc0\ud658\uacfc \uc2a4\ud0a4\ub9c8 \uc870\uc815\uc774 \ud544\uc694\ud558\ubbc0\ub85c \ubcf5\uc7a1\ud55c \uc911\ucca9 \uad6c\uc870\ub97c \uad00\ub9ac\ud558\uae30\uc5d0\ub294 \ud6a8\uc728\uc131\uc774 \ub5a8\uc5b4\uc9d1\ub2c8\ub2e4. \uc2e4\uc2dc\uac04 \ub370\uc774\ud130\uc640 \uc911\ucca9\ub41c \ud615\uc2dd\uc744 \ub2e4\ub8e8\ub294 \ud658\uacbd\uc5d0\uc11c\ub294 Capella Columnar\uac00 \ub354 \uc720\uc5f0\ud558\uace0 \ud6a8\uc728\uc801\uc778 \uc120\ud0dd\uc784\uc744 \uc785\uc99d\ud569\ub2c8\ub2e4.<\/p>\n<h2><span style=\"font-weight: 400;\">\ucc38\uc870<\/span><\/h2>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Watch: <a href=\"https:\/\/www.youtube.com\/watch?v=pXoenAEhz9Q\"><span style=\"font-weight: 400;\">\uce74\ud3a0\ub77c \uceec\ub7fc: \uc2ec\uce35\uc801\uc778 \uae30\uc220 \uac1c\uc694<\/span><\/a><\/li>\n<li><a href=\"https:\/\/dzone.com\/articles\/keep-calm-and-column-wise\"><span style=\"font-weight: 400;\">\uce68\ucc29\ud558\uace0 \ud604\uba85\ud55c \uce7c\ub7fc \uc791\uc131<\/span><\/a><\/li>\n<li><a href=\"https:\/\/www.vldb.org\/pvldb\/vol15\/p2085-alkowaileet.pdf\"><span style=\"font-weight: 400;\">\uc2a4\ud0a4\ub9c8 \uc5c6\ub294 LSM \uae30\ubc18 \ubb38\uc11c \uc800\uc7a5\uc18c\ub97c \uc704\ud55c \uc5f4 \ud615\uc2dd<\/span><\/a><\/li>\n<li><a href=\"https:\/\/docs.couchbase.com\/columnar\/intro\/intro.html\"><span style=\"font-weight: 400;\">\uce74\ud3a0\ub77c \uceec\ub7fc \uc18c\uac1c<\/span><\/a><\/li>\n<li><a href=\"https:\/\/cloud.couchbase.com\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uce74\ud3a0\ub77c\ub97c \ubb34\ub8cc\ub85c \uc0ac\uc6a9\ud558\ub824\uba74 \uac00\uc785\ud558\uc138\uc694.<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Ensuring a seamless flow of data is crucial for effective analysis and decision-making. Today, with data often being unstructured and nested, the choice of database plays a significant role in optimizing processing efficiency and query performance. In this blog post, [&hellip;]<\/p>","protected":false},"author":85528,"featured_media":16389,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[10129,2242,2225],"tags":[10034,1766,1309],"ppma_author":[10035,10036,9918],"class_list":["post-16370","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-columnar","category-connectors","category-cloud","tag-clickhouse","tag-data-migration","tag-mongodb"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.8 (Yoast SEO v25.8) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Simplifying Real-Time Analytics on JSON: Capella Columnar vs. ClickHouse - The Couchbase Blog<\/title>\n<meta name=\"description\" content=\"Efficiently ingest and query nested data in Capella Columnar vs. ClickHouse, comparing preprocessing, schema transformation, and real-time updates.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/ko\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Simplifying Real-Time Analytics on JSON: Capella Columnar vs. ClickHouse\" \/>\n<meta property=\"og:description\" content=\"Efficiently ingest and query nested data in Capella Columnar vs. ClickHouse, comparing preprocessing, schema transformation, and real-time updates.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-09-26T00:13:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T04:54:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/blog-capella-columnar-clickhouse-1024x536.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"536\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Ayush Tripathi, Ritik Raj, Janhavi Tripurwar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ayush Tripathi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/\"},\"author\":{\"name\":\"Ayush Tripathi\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/e1fff268cf639be15f4f150d9fc05519\"},\"headline\":\"Simplifying Real-Time Analytics on JSON: Capella Columnar vs. ClickHouse\",\"datePublished\":\"2024-09-26T00:13:09+00:00\",\"dateModified\":\"2025-06-14T04:54:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/\"},\"wordCount\":1366,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/blog-capella-columnar-clickhouse.png\",\"keywords\":[\"clickhouse\",\"Data Migration\",\"mongodb\"],\"articleSection\":[\"Columnar\",\"Connectors\",\"Couchbase Capella\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/\",\"name\":\"Simplifying Real-Time Analytics on JSON: Capella Columnar vs. ClickHouse - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/blog-capella-columnar-clickhouse.png\",\"datePublished\":\"2024-09-26T00:13:09+00:00\",\"dateModified\":\"2025-06-14T04:54:21+00:00\",\"description\":\"Efficiently ingest and query nested data in Capella Columnar vs. ClickHouse, comparing preprocessing, schema transformation, and real-time updates.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/blog-capella-columnar-clickhouse.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/blog-capella-columnar-clickhouse.png\",\"width\":2400,\"height\":1256},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Simplifying Real-Time Analytics on JSON: Capella Columnar vs. ClickHouse\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/e1fff268cf639be15f4f150d9fc05519\",\"name\":\"Ayush Tripathi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/a1dd0a1398a0ca551eafe4c50a320b4d\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ab8d3244859342fa389fed32cf53f2d5dc94a4a30b0c570c7b336bcd9741fa64?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ab8d3244859342fa389fed32cf53f2d5dc94a4a30b0c570c7b336bcd9741fa64?s=96&d=mm&r=g\",\"caption\":\"Ayush Tripathi\"},\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/ayushkumartripathi\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Simplifying Real-Time Analytics on JSON: Capella Columnar vs. ClickHouse - The Couchbase Blog","description":"Efficiently ingest and query nested data in Capella Columnar vs. ClickHouse, comparing preprocessing, schema transformation, and real-time updates.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.couchbase.com\/blog\/ko\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/","og_locale":"ko_KR","og_type":"article","og_title":"Simplifying Real-Time Analytics on JSON: Capella Columnar vs. ClickHouse","og_description":"Efficiently ingest and query nested data in Capella Columnar vs. ClickHouse, comparing preprocessing, schema transformation, and real-time updates.","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/","og_site_name":"The Couchbase Blog","article_published_time":"2024-09-26T00:13:09+00:00","article_modified_time":"2025-06-14T04:54:21+00:00","og_image":[{"width":1024,"height":536,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/blog-capella-columnar-clickhouse-1024x536.png","type":"image\/png"}],"author":"Ayush Tripathi, Ritik Raj, Janhavi Tripurwar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ayush Tripathi","Est. reading time":"10\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/"},"author":{"name":"Ayush Tripathi","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/e1fff268cf639be15f4f150d9fc05519"},"headline":"Simplifying Real-Time Analytics on JSON: Capella Columnar vs. ClickHouse","datePublished":"2024-09-26T00:13:09+00:00","dateModified":"2025-06-14T04:54:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/"},"wordCount":1366,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/blog-capella-columnar-clickhouse.png","keywords":["clickhouse","Data Migration","mongodb"],"articleSection":["Columnar","Connectors","Couchbase Capella"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/","url":"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/","name":"Simplifying Real-Time Analytics on JSON: Capella Columnar vs. ClickHouse - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/blog-capella-columnar-clickhouse.png","datePublished":"2024-09-26T00:13:09+00:00","dateModified":"2025-06-14T04:54:21+00:00","description":"Efficiently ingest and query nested data in Capella Columnar vs. ClickHouse, comparing preprocessing, schema transformation, and real-time updates.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/blog-capella-columnar-clickhouse.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/blog-capella-columnar-clickhouse.png","width":2400,"height":1256},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/simplifying-real-time-analytics-on-json-capella-columnar-vs-clickhouse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Simplifying Real-Time Analytics on JSON: Capella Columnar vs. ClickHouse"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","description":"NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4, Couchbase","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/e1fff268cf639be15f4f150d9fc05519","name":"\uc544\uc720\uc2dc \ud2b8\ub9ac\ud30c\ud2f0","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/a1dd0a1398a0ca551eafe4c50a320b4d","url":"https:\/\/secure.gravatar.com\/avatar\/ab8d3244859342fa389fed32cf53f2d5dc94a4a30b0c570c7b336bcd9741fa64?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab8d3244859342fa389fed32cf53f2d5dc94a4a30b0c570c7b336bcd9741fa64?s=96&d=mm&r=g","caption":"Ayush Tripathi"},"url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/ayushkumartripathi\/"}]}},"authors":[{"term_id":10035,"user_id":85528,"is_guest":0,"slug":"ayushkumartripathi","display_name":"Ayush Tripathi","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/ab8d3244859342fa389fed32cf53f2d5dc94a4a30b0c570c7b336bcd9741fa64?s=96&d=mm&r=g","author_category":"","last_name":"Tripathi","first_name":"Ayush","job_title":"Software Engineer","user_url":"","description":""},{"term_id":10036,"user_id":85529,"is_guest":0,"slug":"ritikraj","display_name":"Ritik Raj","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/cfe4dbb21fb16ea9137ea6cc359220689e437885565d7bcfaa8796438ba6c163?s=96&d=mm&r=g","author_category":"","last_name":"Raj","first_name":"Ritik","job_title":"Software Engineer 2","user_url":"","description":""},{"term_id":9918,"user_id":85045,"is_guest":0,"slug":"janhavitripurwar","display_name":"Janhavi Tripurwar","avatar_url":{"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/janhavi-couchbase.jpg","url2x":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2024\/09\/janhavi-couchbase.jpg"},"author_category":"","last_name":"Tripurwar","first_name":"Janhavi","job_title":"Software Engineer 2","user_url":"","description":""}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/16370","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/users\/85528"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=16370"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/16370\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/16389"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=16370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=16370"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=16370"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=16370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}