{"id":7634,"date":"2019-09-07T23:57:32","date_gmt":"2019-09-08T06:57:32","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=7634"},"modified":"2025-06-13T20:19:34","modified_gmt":"2025-06-14T03:19:34","slug":"why-cost-based-optimizer-for-nosql-n1ql-couchbase","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/","title":{"rendered":"\uc801\uc744\uc218\ub85d \uc88b\uc2b5\ub2c8\ub2e4: \ube44\uc6a9 \uae30\ubc18 \ucd5c\uc801\ud654 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\ub294 \uc774\uc720\ub294 \ubb34\uc5c7\uc778\uac00\uc694?"},"content":{"rendered":"<blockquote><p><span style=\"font-weight: 400\">\uc801\uc744\uc218\ub85d \uc88b\uc2b5\ub2c8\ub2e4.  - <a href=\"https:\/\/en.wikipedia.org\/wiki\/Minimalism#Less_is_more_(architecture)\">\ub8e8\ub4dc\ube44\ud788 \ubbf8\uc2a4 \ubc18 \ub370\uc5b4 \ub85c\uc5d0<\/a><\/span><\/p><\/blockquote>\n<p>\ucffc\ub9ac \ucd5c\uc801\ud654 \ub3c4\uad6c\uc758 \ubaa9\ud45c\uc5d0 \ub300\ud574 \uc774\ubcf4\ub2e4 \ub354 \uc815\ud655\ud55c \ud45c\ud604\uc740 \uc5c6\uc2b5\ub2c8\ub2e4. \ub354 \uc801\uc740 \uc791\uc5c5\uc744 \uc218\ud589\ud558\uc138\uc694: \uc801\uc740 \uba54\ubaa8\ub9ac, \uc801\uc740 CPU, \uc801\uc740 \ub514\uc2a4\ud06c, \uc801\uc740 IO, \uc801\uc740 \uba85\ub839\uc5b4, \uc801\uc740 \ud30c\ud2f0\uc158, \uc801\uc740 \uc624\ubc84\ud50c\ub85c. \uc0dd\uc131\ud558\ub294 \ucffc\ub9ac \uacc4\ud68d\uc5d0 \ud544\uc694\ud55c \ubaa8\ub4e0 \uac83\uc744 \uc904\uc774\uc138\uc694. \uc774\uac83\uc774 \ubc14\ub85c SQL\uacfc <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/query-optimization-in-nosql-couchbase-mongodb\/\">NoSQL \ucd5c\uc801\ud654 \ub3c4\uad6c<\/a>.<\/p>\n<p>Couchbase 6.5\uc5d0\uc11c\ub294 \ucffc\ub9ac \uc11c\ube44\uc2a4\uc5d0\uc11c N1QL\uc744 \uc704\ud55c \ube44\uc6a9 \uae30\ubc18 \ucd5c\uc801\ud654 \ub3c4\uad6c(CBO-\ud504\ub9ac\ubdf0)\ub97c \ubc1c\ud45c\ud588\uc2b5\ub2c8\ub2e4.  \uc5ec\uae30\uc5d0\uc11c\ub294 CBO\uc758 \uc774\uc810\uc5d0 \uc775\uc219\ud558\uc9c0 \uc54a\uc740 NoSQL \uc0ac\uc6a9\uc790\ub4e4\uc758 \uc9c8\ubb38\uc5d0 \ub2f5\ud574 \ubcf4\ub824\uace0 \ud569\ub2c8\ub2e4.<\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">CBO\uac00 \uaf2d \ud544\uc694\ud55c \uc774\uc720\ub294 \ubb34\uc5c7\uc778\uac00\uc694?<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">CBO\uac00 \uc5c6\ub294 \uacbd\uc6b0 \uc131\uacfc\uc5d0 \ubbf8\uce58\ub294 \uc601\ud5a5\uc740 \ubb34\uc5c7\uc778\uac00\uc694?<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">\uc8fc\uc81c\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/scholar.google.com\/scholar?hl=en&amp;as_sdt=0%2C5&amp;q=SQL+optimizer&amp;btnG=\">vast<\/a>.  \uc5ec\uae30\uc5d0 \uc788\ub294 \ub2f5\ubcc0\uc740 \uac04\ub2e8\ud558\uace0 \ud3ec\uad04\uc801\uc774\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">2019\ub144, \uc790\ub140\uc758 \ubc1c\ud45c\ud68c\ub098 \uc57c\uad6c \uacbd\uae30\uc5d0 \uc81c\uc2dc\uac04\uc5d0 \ub3c4\ucc29\ud574\uc57c \ud558\ub294 \uc911\uc694\ud55c \uc21c\uac04\uc5d0 \uad50\ud1b5 \uc0c1\ud669\uc744 \uace0\ub824\ud558\uc9c0 \uc54a\ub294 \uc815\uc801 \uae38\uc548\ub0b4 \uc9c0\ub3c4\ub97c \uc0ac\uc6a9\ud558\uc2dc\uaca0\uc2b5\ub2c8\uae4c?  Google \uc9c0\ub3c4\uc758 \uacbd\ub85c \ucd5c\uc801\ud654 \ub3c4\uad6c\ub294 \uc2dc\uac04\uc5d0 \ub9de\ucdb0 \ucd5c\uc801\ud654\ud569\ub2c8\ub2e4. \ucd5c\uc801\ud654 \ub3c4\uad6c\ub294 \ucd5c\uc18c\ud55c\uc758 \ub9ac\uc18c\uc2a4\ub85c \ucffc\ub9ac\ub97c \uc2e4\ud589\ud560 \uc218 \uc788\ub294 \ubc29\uc548\uc744 \ucc3e\uc73c\ub824\uace0 \ub178\ub825\ud569\ub2c8\ub2e4: CPU, \uba54\ubaa8\ub9ac. \uc774\ub97c \uc54c\uba74\uc11c \uc65c \uc815\uc801 \uaddc\uce59(\ub610\ub294 <\/span><a href=\"https:\/\/docs.mongodb.com\/manual\/core\/query-plans\/\"><span style=\"font-weight: 400\">\ucffc\ub9ac \ubaa8\uc591<\/span><\/a><span style=\"font-weight: 400\">) \uae30\ubc18 \ucd5c\uc801\ud654\ub97c \ube44\uc988\ub2c8\uc2a4 \ud06c\ub9ac\ud2f0\uceec \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc6cc\ud06c\ub85c\ub4dc\uc5d0 \uc801\uc6a9\ud558\uace0 \uacc4\uc2e0\uac00\uc694?<\/span><\/p>\n<p><a href=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/09\/Screen-Shot-2019-09-07-at-5.49.23-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7636\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/09\/Screen-Shot-2019-09-07-at-5.49.23-PM-300x241.png\" alt=\"\" width=\"620\" height=\"498\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/09\/Screen-Shot-2019-09-07-at-5.49.23-PM-300x241.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/09\/Screen-Shot-2019-09-07-at-5.49.23-PM-768x618.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/09\/Screen-Shot-2019-09-07-at-5.49.23-PM-20x16.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/09\/Screen-Shot-2019-09-07-at-5.49.23-PM.png 922w\" sizes=\"auto, (max-width: 620px) 100vw, 620px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucd5c\uc801\ud654 \ub3c4\uad6c\uac00 \uacb0\uc815\uc744 \ub0b4\ub9bd\ub2c8\ub2e4.  \uc774\ub7ec\ud55c \uacb0\uc815\uc740 \ucffc\ub9ac \uc131\ub2a5, \uc2dc\uc2a4\ud15c \ucc98\ub9ac\ub7c9 \ubc0f SLA \ucda9\uc871 \ub2a5\ub825\uc5d0 \ud070 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4. \ub354 \ub098\uc740 \ucd5c\uc801\ud654 \ub3c4\uad6c\uac00 \uc788\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\uba74 \uac1c\ubc1c, \uad00\ub9ac \ubc0f SLA\ub97c \ub354 \uc27d\uac8c \ucda9\uc871\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400\">SQL\uc740 \uac00\uc7a5 \uc131\uacf5\uc801\uc778 4\uc138\ub300 \uc5b8\uc5b4\uc785\ub2c8\ub2e4.  \uc5b8\uc5b4\ub85c\uc11c, \uae30\ubcf8 \uc2a4\ud0a4\ub9c8\uac00 \uadf8\ub807\uc9c0 \uc54a\uc740 \uacbd\uc6b0\uc5d0\ub3c4 \ub9e4\uc6b0 \uc720\uc5f0\ud569\ub2c8\ub2e4.  \ubaa8\ub4e0 \uc870\ud569\uc744 \ubbf8\ub9ac \uacc4\ud68d\ud558\uc9c0 \uc54a\uace0\ub3c4 \ubaa8\ub4e0 \uad00\uacc4(\ud14c\uc774\ube14 \ub610\ub294 \uc911\uac04 \uad00\uacc4)\ub97c \uc120\ud0dd, \uc870\uc778, \ud22c\uc601\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.  \uc774\ub294 \uc571 \uac1c\ubc1c\uacfc \ub370\uc774\ud130 \ubd84\uc11d\uc5d0 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4. \uc774 <\/span><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/the-unreasonable-effectiveness-of-sql-in-nosql-databases\/\"><span style=\"font-weight: 400\">\uae30\uc0ac\uc5d0\uc11c\ub294 \uc8fc\uc694 NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc5b4\ub5bb\uac8c<\/span><\/a><span style=\"font-weight: 400\"> \ub294 SQL\uc758 \ub2e4\uc591\ud55c \uc694\uc18c\ub97c \uad6c\ud604\ud588\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub3c4 \ucd5c\uc801\ud654\uc5d0 \uc2e0\uacbd\uc744 \uc368\uc57c \ud569\ub2c8\ub2e4.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">\ucffc\ub9ac \uc5b8\uc5b4\uc758 \ub6f0\uc5b4\ub09c \uc720\uc5f0\uc131\uc5d0\ub294 \ucffc\ub9ac\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \ucd5c\uc801\ud654\ud558\uace0 \uc2e4\ud589\ud574\uc57c \ud558\ub294 \ub9c9\uc911\ud55c \ucc45\uc784\uc774 \ub530\ub985\ub2c8\ub2e4. SQL\uc758 \ucd08\uae30 \uad6c\ud604\uc740 \uaddc\uce59 \uae30\ubc18 \ucd5c\uc801\ud654 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud588\uc2b5\ub2c8\ub2e4.  \uc774\ub85c \uc778\ud574 \uaddc\uce59\uc758 \ubcf5\uc7a1\uc131, \uc0ac\uc6a9\uc790 \uc815\uc758 \ucd5c\uc801\ud654 \ub3c4\uad6c \ud78c\ud2b8, \ubcf5\uc7a1\ud55c \ucffc\ub9ac\uc5d0 \ub300\ud55c \ucffc\ub9ac \uacc4\ud68d \ud6a8\uc728\uc131 \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud588\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc<\/span><a href=\"https:\/\/people.eecs.berkeley.edu\/~brewer\/cs262\/3-selinger79.pdf\"><span style=\"font-weight: 400\"> \ube44\uc6a9 \uae30\ubc18 \ucd5c\uc801\ud654 \ub3c4\uad6c<\/span><\/a> (CBO)<span style=\"font-weight: 400\"> \ub294 \ub2e4\uc591\ud55c \ub370\uc774\ud130, \ub370\uc774\ud130 \uc65c\uace1 \ubc0f \uc6cc\ud06c\ub85c\ub4dc\uc5d0 \ub9de\uac8c \ucffc\ub9ac\ub97c \uc62c\ubc14\ub974\uac8c \ucd5c\uc801\ud654\ud558\uc5ec \ubaa8\ub4e0 \uac83\uc744 \ubcc0\ud654\uc2dc\ucf30\uc2b5\ub2c8\ub2e4.  CBO\uac00 \uc5c6\uc5c8\ub2e4\uba74 RDBMS\uac00 \uc800\ube44\uc6a9\uc73c\ub85c \uc774\ub807\uac8c \ub2e4\uc591\ud55c \uc0ac\uc6a9 \uc0ac\ub840\ub97c \ucc98\ub9ac\ud558\ub294 \ub370 \uc131\uacf5\ud558\uc9c0 \ubabb\ud588\uc744 \uac83\uc774\ub77c\uace0 \ud574\ub3c4 \uacfc\uc5b8\uc774 \uc544\ub2d9\ub2c8\ub2e4. \ucd5c\uc801\ud654 \ub3c4\uad6c\uac00 \uc788\ub294 NoSQL \uc2dc\uc2a4\ud15c\ub3c4 \ub9c8\ucc2c\uac00\uc9c0\uc785\ub2c8\ub2e4.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucd5c\uc801\ud654 \ub3c4\uad6c\uac00 \uacb0\uc815\uc744 \ub0b4\ub9bd\ub2c8\ub2e4.  \uc798\ubabb\ub41c \uacb0\uc815\uc740 \uc131\ub2a5\uc5d0 \ud070 \ubd80\uc815\uc801\uc778 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4. \uc2e4\uc81c \uc6cc\ud06c\ub85c\ub4dc\uc758 \uacbd\uc6b0, \ud1b5\uacc4\ub97c \uae30\ubc18\uc73c\ub85c \ud55c \uc758\uc0ac \uacb0\uc815\uc774 \uaddc\uce59 \uae30\ubc18 \uc758\uc0ac \uacb0\uc815\ubcf4\ub2e4 \ud6e8\uc52c \ub0ab\uc2b5\ub2c8\ub2e4. \ud1b5\uacc4\uac00 \uc774\ub97c \uc99d\uba85\ud569\ub2c8\ub2e4!<\/span><\/p>\n<p><span style=\"font-weight: 400\">\ucd5c\uc801\ud654 \ub3c4\uad6c\ub294 \ud06c\uac8c \ub2e4\uc74c\uacfc \uac19\uc740 \uc791\uc5c5\uc744 \uc218\ud589\ud569\ub2c8\ub2e4:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><b>\ub2e4\uc2dc \uc4f0\uae30: <\/b><span style=\"font-weight: 400\">\ucffc\ub9ac\ub97c \ucd5c\uc801\uc758 \ub3d9\ub4f1\ud55c \ud615\uc2dd\uc73c\ub85c \ub2e4\uc2dc \uc791\uc131\ud558\uba74 \ucd5c\uc801\ud654\uac00 \ub354 \uc26c\uc6cc\uc9d1\ub2c8\ub2e4.  \uc5ec\uae30\uc5d0\ub294 \uc0c1\uc218 \ud544\ud130 \ud3c9\uac00, \uc870\uc778 \ubcc0\ud658, \ud558\uc704 \ucffc\ub9ac \ud3c9\ud0c4\ud654, \ud558\uc704 \ucffc\ub9ac \uc811\uae30 \ub4f1\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4.  \uc7ac\uc791\uc131 \uc720\ud615\uc740 \ud6c4\uc18d \ub2e8\uacc4\uc5d0\uc11c \ucd5c\uc801\ud654 \ub3c4\uad6c\uc758 \ud2b9\uc815 \uae30\ub2a5\uacfc \ub258\uc559\uc2a4\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9d1\ub2c8\ub2e4.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><b>\uc561\uc138\uc2a4 \uacbd\ub85c: <\/b><span style=\"font-weight: 400\">\uac01 \ud0a4 \uc2a4\ud398\uc774\uc2a4(\ud14c\uc774\ube14\uc5d0 \ud574\ub2f9)\uc5d0 \ub300\ud574 \uc0ac\uc6a9 \uac00\ub2a5\ud55c \uc778\ub371\uc2a4 \ub610\ub294 \uc804\uccb4 \uc2a4\uce94(Couchbase\uc758 \uacbd\uc6b0 \uae30\ubcf8 \uc778\ub371\uc2a4 \uc2a4\uce94) \uc911\uc5d0\uc11c \uc120\ud0dd\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc11c \uac01 \ud0a4\uc2a4\ud398\uc774\uc2a4\uc5d0 \ub300\ud574 \ud558\ub098 \uc774\uc0c1\uc758 \uc778\ub371\uc2a4\ub97c \uc120\ud0dd\ud558\uace0, \uac01 \uc2a4\uce94 \uc694\uccad\uc5d0 \ub300\ud55c \uc220\uc5b4(\ubc94\uc704)\ub97c \uacb0\uc815\ud558\uace0, \ud3ec\ud568 \uc5ec\ubd80\ub97c \uacb0\uc815\ud569\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400\"><b>\uc8fc\ubb38\ud558\uae30: <\/b><span style=\"font-weight: 400\">\uadf8 \ubaa9\uc801\uc740 \uc911\uac04 \uacb0\uacfc \uc9d1\ud569\uc758 \ud06c\uae30\ub97c \uc81c\ud55c\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc870\uc778\uc740 \ud55c \ubc88\uc5d0 \ub450 \uac1c\uc758 \ud0a4 \uc2a4\ud398\uc774\uc2a4(\ud14c\uc774\ube14)\uc5d0\uc11c \uc218\ud589\ub429\ub2c8\ub2e4. \uc870\uc778 \uc720\ud615\uc5d0 \ub530\ub77c \ucffc\ub9ac\uc758 \uc758\ubbf8\uc640 \uacb0\uacfc\ub97c \ubcc0\uacbd\ud558\uc9c0 \uc54a\uace0 \uc21c\uc11c\ub97c \ubcc0\uacbd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, ((t1 INNER JOIN t2) INNER JOIN t3)\uc740 ((t3 INNER JOIN t2) INNER JOIN t1)\uacfc \ub3d9\uc77c\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc11c\ub294 \uc870\uc778\uc774 \uc218\ud589\ub418\ub294 \uc21c\uc11c\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4.  N1QL \uc635\ud2f0\ub9c8\uc774\uc800\ub294 \uc544\uc9c1 \uc870\uc778\uc758 \uc21c\uc11c\ub97c \ub2e4\uc2dc \uc9c0\uc815\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400\"><b>\uac00\uc785 \uc720\ud615: <\/b><span style=\"font-weight: 400\">\uac01 \ucffc\ub9ac \uc5d4\uc9c4\uc740 \ud2b9\uc815 \uc720\ud615\uc758 \uc870\uc778\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. Couchbase \ucffc\ub9ac \uc11c\ube44\uc2a4 \ubc0f \ubd84\uc11d \uc11c\ube44\uc2a4\ub294 \ubaa8\ub450 \uc911\ucca9 \ub8e8\ud504(NLJ) \ubc0f \ud574\uc2dc \uc870\uc778(HJ)\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4.  \ucffc\ub9ac \uc11c\ube44\uc2a4\uc758 \uacbd\uc6b0 \uc911\ucca9 \ub8e8\ud504\uac00 \uae30\ubcf8\uac12\uc774\uba70, \ubd84\uc11d \uc11c\ube44\uc2a4\uc758 \uacbd\uc6b0 \ud574\uc2dc \uc870\uc778\uc774 \uae30\ubcf8\uac12\uc785\ub2c8\ub2e4. \uc870\uc778 \uc720\ud615\uc744 \uc120\ud0dd\ud55c \ud6c4\uc5d0\ub294 \uc870\uc778 \ub0b4\uc5d0\uc11c \uc21c\uc11c\uc5d0 \ub300\ud55c \ucd94\uac00 \uacb0\uc815\uc744 \ub0b4\ub824\uc57c \ud569\ub2c8\ub2e4.  NLJ\uc758 \uacbd\uc6b0, \uc5b4\ub5a4 \ud14c\uc774\ube14\uc774 \uc678\ubd80 \ud14c\uc774\ube14\uc774\uace0 \uc5b4\ub5a4 \ud14c\uc774\ube14\uc774 \ub0b4\ubd80 \ud14c\uc774\ube14\uc778\uc9c0 \uacb0\uc815\ud574\uc57c \ud569\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c \uacb0\uacfc \uc9d1\ud569\uc774 \ub354 \uc791\uc740 \ud14c\uc774\ube14(\ud0a4 \uc2a4\ud398\uc774\uc2a4)\uc744 \uc678\ubd80 \ud14c\uc774\ube14\ub85c \uc120\ud0dd\ud569\ub2c8\ub2e4. HJ\uc758 \uacbd\uc6b0, \uc5b4\ub290 \ud14c\uc774\ube14\uc774 (\ud574\uc2dc \ud14c\uc774\ube14) \ube4c\ub4dc \ucabd\uc774\uace0 \ub2e4\ub978 \ud14c\uc774\ube14\uc774 \uacc4\ud68d\uc758 \ud504\ub85c\ube0c \ucabd\uc774 \ub420\uc9c0 \uacb0\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.\u00a0<\/span><\/li>\n<li>\ucd5c\uc801\ud654\ub97c \uc704\ud55c \ucd94\uac00 \uace0\ub824 \uc0ac\ud56d\uc774 \uc788\uc2b5\ub2c8\ub2e4(\uc608: LIMIT \uc808\uc744 \uc9c0\uc815\ud55c \uacbd\uc6b0 \uccab \ubc88\uc9f8 \ud589 \ucd5c\uc801\ud654).<\/li>\n<li style=\"font-weight: 400\"><b>\uc2e4\ud589 \ud2b8\ub9ac \ub9cc\ub4e4\uae30<\/b><span style=\"font-weight: 400\">:  \ub9c8\uc9c0\ub9c9\uc73c\ub85c, \uc774\uc804 \ub2e8\uacc4\uc758 \uacb0\uc815\uc744 \ub098\ud0c0\ub0b4\ub294 \uc5f0\uc0b0\uc790\uc640 \ub9e4\uac1c\ubcc0\uc218 \uac12\uc744 \uc0ac\uc6a9\ud558\uc5ec \ucffc\ub9ac \uc2e4\ud589 \ud2b8\ub9ac(\uacc4\ud68d)\ub97c \ub9cc\ub4ed\ub2c8\ub2e4.\u00a0<\/span><\/li>\n<\/ol>\n<p><b>\uc608\uc2dc:\u00a0<\/b><\/p>\n<p><span class=\"theme:neon font-size:17 line-height:20 lang:mysql decode:true crayon-inline\">SELECT id, address FROM customer WHERE postalcode = 57020;<\/span><\/p>\n<p><span style=\"font-weight: 400\">\ub3d9\uc77c\ud55c \ucffc\ub9ac\uac00 \ub2e8\uc77c \ud589, \uc218\ubc31\ub9cc \ud589 \ub610\ub294 \uc218\uc2ed\uc5b5 \ud589\uc5d0 \ub300\ud574 \uc791\ub3d9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\uac83\uc740 \ucffc\ub9ac\ub9cc\ud07c\uc774\ub098 \uac04\ub2e8\ud560 \uc218 \uc788\uc9c0\ub9cc, \uadf8 \uc774\uba74\uc5d0\ub294 \ubcf5\uc7a1\uc131\uc774 \uc228\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.  \uc635\ud2f0\ub9c8\uc774\uc800\ub294 \ub370\uc774\ud130\uc5d0 \uc811\uadfc\ud558\uae30 \uc704\ud574 \uc5ec\ub7ec \uac00\uc9c0 \uc635\uc158\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\uc804\uccb4 \ud14c\uc774\ube14 \uc2a4\uce94\uc740 \ud56d\uc0c1 \uc635\uc158\uc785\ub2c8\ub2e4.  \uace0\uac1d \ud14c\uc774\ube14\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud398\uc774\uc9c0\uc5d0 \ub9de\ub294 \ud589\uc774 \ud55c\ub450 \uac1c\ub9cc \uc788\ub294 \uacbd\uc6b0 \uc804\uccb4 \ud14c\uc774\ube14 \uc2a4\uce94\uc744 \uc218\ud589\ud569\ub2c8\ub2e4. <\/span><b>\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4 <\/b><span style=\"font-weight: 400\">\ub370\uc774\ud130\uc5d0 \ub3c4\ub2ec\ud560 \uc218 \uc788\ub294 \uac00\uc7a5 \ud6a8\uc728\uc801\uc778 \uacbd\ub85c\uc785\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\ud14c\uc774\ube14\uc5d0 \uc778\ub371\uc2a4\uac00 \uc788\ub2e4\uace0 \uc0c1\uc0c1\ud574 \ubcf4\uc138\uc694.<\/span>\n<ol>\n<li style=\"font-weight: 400\"><span class=\"theme:neon font-size:17 line-height:20 lang:mysql decode:true crayon-inline\">CREATE INDEX i1 ON customer(postalcode)<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">\uba3c\uc800 \uc778\ub371\uc2a4\ub97c \uc2a4\uce94\ud558\uc5ec \uc220\uc5b4\uc640 \uc77c\uce58\ud558\ub294 \ud589\uc758 \ud589ID\ub97c \ucc3e\uc740 \ub2e4\uc74c \ucd94\uac00 \uc5f4(ID, \uc8fc\uc18c)\uc744 \ud22c\uc601\ud560 \ud589\uc744 \uac00\uc838\uc624\ub294 \uc778\ub371\uc2a4 \uacbd\ub85c\uac00 \uac00\uc7a5 \uc88b\uc744 \uac83\uc774\ub77c\uace0 \uc0dd\uac01\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.  \uadf8\ub807\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ud14c\uc774\ube14\uc5d0 \ubc31\ub9cc \uac1c\uc758 \ud589\uc774 \uc788\uace0 \ubaa8\ub4e0 \ud589\uc758 \uc6b0\ud3b8\ubc88\ud638\uac00 57020\uc73c\ub85c \uc815\ud655\ud788 \uac19\ub2e4\uba74 \uc5b4\ub5a8\uae4c\uc694? \uadf8\ub7ec\uba74 \uc778\ub371\uc2a4 \uc561\uc138\uc2a4 \uacbd\ub85c\uac00 \uc2e4\uc81c\ub85c \ud14c\uc774\ube14 \uc2a4\uce94\ubcf4\ub2e4 \ube44\uc6a9\uc774 \ub354 \ub9ce\uc774 \ub4ed\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc774\uc81c \ucffc\ub9ac\ub97c \uc57d\uac04 \uc218\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p><span class=\"theme:neon font-size:17 line-height:20 lang:mysql decode:true crayon-inline\">SELECT id, address FROM customer WHERE postalcode = 57020 and yob &lt; 1980;<\/span><\/p>\n<p><span style=\"font-weight: 400\">\ub2e4\uc74c\uacfc \uac19\uc740 \uc778\ub371\uc2a4\uac00 \uc788\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4:<\/span><\/p>\n<pre class=\"theme:neon font-size:17 line-height:20 whitespace-before:1 whitespace-after:1 lang:mysql decode:true\">CREATE INDEX i1 ON customer(postalcode);\r\nCREATE INDEX i2 ON customer(yob);\r\nCREATE INDEX i3 ON customer(postalcode, yob);\r\nCREATE INDEX i4 ON customer(yob, postalcode);\r\nCREATE INDEX i5 ON customer(postalcode, id, address);\r\nCREATE INDEX i6 ON customer(yob, id, address);\r\nCREATE INDEX i7 ON customer(postalcode, yob, id, address);\r\nCREATE INDEX i8 ON customer(yob, postalcode, id, address);<\/pre>\n<p><span style=\"font-weight: 400\">\ucd5c\uc801\ud654 \ud504\ub85c\uadf8\ub7a8\uc5d0 \ub300\ud55c \uc720\ud6a8\ud55c \uc561\uc138\uc2a4 \uacbd\ub85c\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\uac01 \uc778\ub371\uc2a4 i1~i8\uc740 \uc720\ud6a8\ud55c \uc561\uc138\uc2a4 \uacbd\ub85c\uc785\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\ud14c\uc774\ube14 \uc2a4\uce94\uc740 \ud56d\uc0c1 \uc635\uc158\uc785\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\uc5ec\ub7ec \uc778\ub371\uc2a4 \uacb0\ud569<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">\uc774\ub807\uac8c \uac04\ub2e8\ud55c \ucffc\ub9ac\uc5d0\uc11c\ub3c4 \ucffc\ub9ac\uc5d0 \uac00\uc7a5 \uc801\ud569\ud55c \uc778\ub371\uc2a4\ub97c \uc120\ud0dd\ud558\uae30\uac00 \uc27d\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.  \ub530\ub77c\uc11c \uaddc\uce59 \uae30\ubc18 \ucd5c\uc801\ud654 \ub3c4\uad6c\ub294 \uc77c\ub828\uc758 \uaddc\uce59\uc744 \uc720\uc9c0\ud558\uace0 \uc774\ub7ec\ud55c \uaddc\uce59\uc744 \uc77c\uad00\ub418\uac8c \ub530\ub77c \ucd5c\uc0c1\uc758 \ubc29\uc548\uc744 \uc81c\uc2dc\ud569\ub2c8\ub2e4. \uc77c\ub828\uc758 \uaddc\uce59\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <\/span><a href=\"https:\/\/dzone.com\/articles\/a-deep-dive-into-couchbase-n1ql-query-optimization\"><span style=\"font-weight: 400\">N1QL \uaddc\uce59 \uae30\ubc18 \ucd5c\uc801\ud654 \ub3c4\uad6c<\/span><\/a><span style=\"font-weight: 400\"> \ub294 \uc798 \ubb38\uc11c\ud654\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc774\ub7ec\ud55c \uaddc\uce59\uc740 \ucc98\uc74c\ubd80\ud130 \uc815\ud574\uc9c4 \uac83\uc774 \uc544\ub2d9\ub2c8\ub2e4. \uc778\ub371\uc2a4 \uacbd\ub85c, \uac00\uc7a5 \ub9ce\uc740 \ud0a4\ub97c \uac00\uc9c4 \uc778\ub371\uc2a4 \ub4f1\uc744 \uc120\ud638\ud558\uae30 \uc2dc\uc791\ud569\ub2c8\ub2e4.  \uadf8\ub7ec\ub2e4 \ubcf4\uba74 \ucda9\ub3cc\uc774 \uc0dd\uae30\uac8c \ub429\ub2c8\ub2e4.\u00a0<\/span><\/p>\n<p><b>\uc608<\/b><span style=\"font-weight: 400\">:<\/span><\/p>\n<p><span style=\"font-weight: 400\">\ucffc\ub9ac: <span class=\"theme:neon font-size:17 line-height:20 lang:mysql decode:true crayon-inline\">SELECT id, address FROM customer WHERE postalcode = 57020 and yob &lt; 1980;<\/span>\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc0c9\uc778:\u00a0<\/span><\/p>\n<p><span class=\"theme:neon font-size:17 line-height:20 lang:mysql decode:true crayon-inline\">CREATE INDEX i7 ON customer(postalcode, yob, id, address); CREATE INDEX i8 ON customer(yob, postalcode, id, address);<\/span><\/p>\n<p><span style=\"font-weight: 400\">\uaddc\uce59 \uae30\ubc18 \ucd5c\uc801\ud654 \ub3c4\uad6c\ub294 \uc774\ub7ec\ud55c \uc778\ub371\uc2a4 \uc911 \uc5b4\ub5a4 \uac83\uc774 \uac00\uc7a5 \ud6a8\uc728\uc801\uc778\uc9c0 \ud30c\uc545\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.  \ubaa8\ub4e0 \uac83\uc740 \ub370\uc774\ud130 \uc65c\uace1\uc73c\ub85c \uadc0\uacb0\ub429\ub2c8\ub2e4: \ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc120\ud0dd\ud55c \uc778\ub371\uc2a4\uac00 \ub2e4\ub978 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c\ub294 \ucd5c\uc801\uc774 \uc544\ub2d0 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p><b>\uc608\uc2dc:<\/b><\/p>\n<p><span style=\"font-weight: 400\">\ucffc\ub9ac:<\/span><\/p>\n<pre class=\"theme:neon font-size:17 line-height:20 lang:mysql decode:true\">SELECT c.state, d.status, SUM(o.sale_amt) \r\nFROM order o \r\n       INNER JOIN customer c ON (o.cid = c.id) \r\n           INNER JOIN demo d ON (c.did = d.did) \r\nWHERE d.edu = \u201ccollege\u201d AND d.mstatus = \u201cmarried\u201d \r\nGROUP BY c.state, d.status<\/pre>\n<p><span style=\"font-weight: 400\">\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc8fc\uc5b4\uc9c4 FROM \uc808\uc5d0\uc11c \ub2e4\uc74c \uc8fc\ubb38\uc740 \ubaa8\ub450 \uc720\ud6a8\ud55c \uc8fc\ubb38\uc785\ub2c8\ub2e4.  \ucd5c\uc801\ud654 \ub3c4\uad6c\ub294 \uc774 \uc911 \uc5b4\ub290 \uac83\uc744 \uc120\ud0dd\ud574\uc57c \ud560\uae4c\uc694?<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">((\ub0b4\ubd80 \uc870\uc778 \uace0\uac1d \uc8fc\ubb38) \ub0b4\ubd80 \uc870\uc778 \ub370\ubaa8)<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">((\uace0\uac1d \ub0b4\ubd80 \uc870\uc778 \uc8fc\ubb38) \ub0b4\ubd80 \uc870\uc778 \ub370\ubaa8)<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">((\ub0b4\ubd80 \uc870\uc778 \ub370\ubaa8 \uc8fc\ubb38) \ub0b4\ubd80 \uc870\uc778 \uace0\uac1d)<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">((\uace0\uac1d \ub0b4\ubd80 \uc870\uc778 \ub370\ubaa8) \ub0b4\ubd80 \uc870\uc778 \uc8fc\ubb38)<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">((\ub0b4\ubd80 \uc870\uc778 \uc8fc\ubb38 \ub370\ubaa8) \ub0b4\ubd80 \uc870\uc778 \uace0\uac1d)<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">((\ub0b4\ubd80 \uc870\uc778 \uace0\uac1d \ub370\ubaa8) \ub0b4\ubd80 \uc870\uc778 \uc8fc\ubb38)<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">FROM \uc808\uc758 \ud0a4 \uc2a4\ud398\uc774\uc2a4(\ub610\ub294 \ud14c\uc774\ube14) \uc218\uac00 \uc99d\uac00\ud568\uc5d0 \ub530\ub77c \uc120\ud0dd \ud56d\ubaa9\uc774 \ub298\uc5b4\ub098\uace0 \uc120\ud0dd\uc774 \ub354 \ubcf5\uc7a1\ud574\uc9d1\ub2c8\ub2e4.   \uc21c\uc11c\uac00 \uc798\ubabb\ub418\uba74 \uc911\uac04 \uacb0\uacfc\uac00 \ubc29\ub300\ud574\uc838 \ub098\uc911\uc5d0 \ub300\ubd80\ubd84\uc744 \ubc84\ub9b4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc704\uc758 \ucffc\ub9ac\uc5d0\uc11c '\ub300\ud559' \ud559\ub825\uc758 \uae30\ud63c \uace0\uac1d\ub9cc \ub300\uc0c1\uc73c\ub85c \ud558\uae30 \ub54c\ubb38\uc5d0 \uace0\uac1d\uc5d0 \ub300\ud55c \uc870\uc778 \uc21c\uc11c\ub97c \uba3c\uc800 \uc9c0\uc815\ud558\uba74 \uc911\uac04 \uacb0\uacfc \uc9d1\ud569\uc774 \uc5c4\uccad\ub098\uac8c \ucee4\uc9d1\ub2c8\ub2e4.  \uc798\ubabb\ub41c \uc870\uc778 \uc21c\uc11c\ub294 \ucffc\ub9ac \uc9c0\uc5f0 \uc2dc\uac04\uacfc \uc2dc\uc2a4\ud15c \ucc98\ub9ac\ub7c9 \ubaa8\ub450\uc5d0 \ubd80\uc815\uc801\uc778 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4.<\/span><\/p>\n<p><b>\uc608\uc2dc:<\/b><\/p>\n<p><span style=\"font-weight: 400\">\ucffc\ub9ac:<\/span><\/p>\n<pre class=\"theme:neon font-size:17 line-height:20 lang:mysql decode:true\">SELECT c.state, c.zip, SUM(sale_amt) \r\nFROM order o INNER JOIN customer c ON (o.cid = c.id) \r\nWHERE o.year = \u201c2018\u201d \r\nGROUP BY state, zip;<\/pre>\n<p><span style=\"font-weight: 400\">\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc5ec\uae30\uc11c \ub450 \uac00\uc9c0 \uacb0\uc815\uc744 \ub0b4\ub824\uc57c \ud569\ub2c8\ub2e4.  \ud14c\uc774\ube14\uc758 \uc870\uc778 \uc720\ud615\uacfc \uc21c\uc11c\uc785\ub2c8\ub2e4.  \uac01\uac01\uc5d0 \ub300\ud55c \ud1b5\uacc4\ub97c \uc54c\uc9c0 \ubabb\ud558\uba74 \uc9c0\ub2a5\uc801\uc73c\ub85c \uacb0\uc815\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.  \ub530\ub77c\uc11c \uaddc\uce59 \uae30\ubc18 \ucd5c\uc801\ud654 \ub3c4\uad6c\ub294 \ub2e8\uc21c\ud788 \ud558\ub098\uc758 \ubc29\ubc95\uc744 \uae30\ubcf8\uac12\uc73c\ub85c \uc124\uc815\ud558\uace0 \uc0ac\uc6a9\uc790\uac00 \uae30\ubcf8\uac12\uc5d0\uc11c \ubcc0\uacbd\ud560 \uc218 \uc788\ub3c4\ub85d \uc758\uc874\ud569\ub2c8\ub2e4.  \uc774\ub294 \ube44\ud6a8\uc728\uc801\uc774\uba70 \ub300\uaddc\ubaa8 \ucffc\ub9ac\uc5d0\uc11c\ub294 \uc2e4\ud589 \ubd88\uac00\ub2a5\ud569\ub2c8\ub2e4. \uc774\ub85c \uc778\ud574 \uc131\ub2a5\uc5d0 \ubbf8\uce58\ub294 \uc601\ud5a5\uc740 \uba87 \ucd08\uc5d0\uc11c \uba87 \ubd84 \ub610\ub294 \uba87 \ubd84\uc5d0\uc11c \uba87 \uc2dc\uac04\uae4c\uc9c0 \uc5c4\uccad\ub0a9\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\ub2e4\uc2dc \ud55c \ubc88 \ud1b5\uacc4\uc801 \ucd94\uc815\uce58\uac00 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.   \uc5d4\ud130\ud504\ub77c\uc774\uc988 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c\ub294 \ud0a4 \uacf5\uac04(\ud14c\uc774\ube14)\uacfc \ubcf5\uc7a1\ud55c \uc220\uc5b4\uac00 \ub9ce\uc740 \ucffc\ub9ac\uac00 \uc77c\ubc18\uc801\uc785\ub2c8\ub2e4.\u00a0\u00a0<\/span><\/p>\n<p><strong>\uacb0\ub860<\/strong><\/p>\n<p><span style=\"font-weight: 400\">\uc2e4\uc81c \uc6cc\ud06c\ub85c\ub4dc\uc758 \uacbd\uc6b0 \ud1b5\uacc4\ub97c \uae30\ubc18\uc73c\ub85c \ud55c \uc758\uc0ac \uacb0\uc815\uc774 \uaddc\uce59 \uae30\ubc18 \uc758\uc0ac \uacb0\uc815\ubcf4\ub2e4 \ud6e8\uc52c \ub0ab\uc2b5\ub2c8\ub2e4. \ub2f9\uc5f0\ud558\uc8e0.  \uadf8 \uc774\uc720\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <\/span><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/cost-based-optimizer-for-couchbase-n1ql-sql-for-json\/\"><span style=\"font-weight: 400\">N1QL\uc740 CBO\ub97c \uad6c\ud604\ud588\uc2b5\ub2c8\ub2e4.<\/span><\/a><span style=\"font-weight: 400\">. \ub2e4\uc6b4\ub85c\ub4dc <\/span><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/downloads\/?family=server&amp;product=couchbase-server-developer\"><span style=\"font-weight: 400\">Couchbase 6.5<\/span><\/a><span style=\"font-weight: 400\"> \ub97c \ud074\ub9ad\ud558\uace0 \uc9c1\uc811 \ud655\uc778\ud558\uc138\uc694.\u00a0 <\/span><\/p>\n<p><span style=\"font-weight: 400\">NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uacb0\uc815\ud558\uae30 \uc804\uc5d0 \uacf5\uae09\uc5c5\uccb4\uc5d0 \ubb38\uc758\ud558\uc138\uc694:\u00a0 <em><strong><span style=\"color: #0000ff\">\ube44\uc6a9 \uae30\ubc18 \ucd5c\uc801\ud654 \ub3c4\uad6c\uac00 \uc788\ub098\uc694?<\/span><\/strong><\/em><\/span><\/p>\n<p><strong>\ucc38\uc870<\/strong><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c SQL\uc758 \ubd88\ud569\ub9ac\ud55c \ud6a8\uc728\uc131: \ube44\uad50 \uc5f0\uad6c. <\/span><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/the-unreasonable-effectiveness-of-sql-in-nosql-databases\/\"><span style=\"font-weight: 400\">https:\/\/www.couchbase.com\/blog\/the-unreasonable-effectiveness-of-sql-in-nosql-databases\/<\/span><\/a><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">SQL\uc758 \ubd88\ud569\ub9ac\ud55c \ud6a8\uc728\uc131 <\/span><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/unreasonable-effectiveness-of-sql\/\"><span style=\"font-weight: 400\">https:\/\/www.couchbase.com\/blog\/unreasonable-effectiveness-of-sql\/<\/span><\/a><span style=\"font-weight: 400\">\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Couchbase 6.5\ub97c \ub2e4\uc6b4\ub85c\ub4dc\ud569\ub2c8\ub2e4: <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/downloads\/?family=server&amp;product=couchbase-server-developer\">https:\/\/couchbase.com\/downloads?family=server&amp;product=couchbase-server-developer<\/a><\/span><\/li>\n<li>\uad00\uacc4\ud615 \uc2dc\uc2a4\ud15c\uc758 \ucffc\ub9ac \ucd5c\uc801\ud654\uc5d0 \ub300\ud55c \uac1c\uc694. <a href=\"https:\/\/cs.stanford.edu\/people\/chrismre\/cs345\/rl\/chaudhuri98.pdf\">https:\/\/cs.stanford.edu\/people\/chrismre\/cs345\/rl\/chaudhuri98.pdf<\/a><\/li>\n<\/ol>","protected":false},"excerpt":{"rendered":"<p>Less is more.\u00a0 &#8212; Ludwig Mies van der Rohe There is no truer statement on the goals of a query optimizer. Do less: Less memory, less CPU, less disk, less IO, less instructions, less partitions, less overflow. Less everything for [&hellip;]<\/p>","protected":false},"author":55,"featured_media":10799,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[9417,1812],"tags":[2401,1725,1906],"ppma_author":[8929],"class_list":["post-7634","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-performance","category-n1ql-query","tag-cbo","tag-nosql-database","tag-optimizer"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Less Is More: Why Use a Cost-Based Optimizer? - The Couchbase Blog<\/title>\n<meta name=\"description\" content=\"Couchbase includes a cost-based optimizer (CBO). Learn how having a CBO improves query performance and how to implement it.\" \/>\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\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Less Is More: Why Use a Cost-Based Optimizer?\" \/>\n<meta property=\"og:description\" content=\"Couchbase includes a cost-based optimizer (CBO). Learn how having a CBO improves query performance and how to implement it.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-08T06:57:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T03:19:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/09\/london-tube-2.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"800\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Keshav Murthy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rkeshavmurthy\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Keshav Murthy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/\"},\"author\":{\"name\":\"Keshav Murthy\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636\"},\"headline\":\"Less Is More: Why Use a Cost-Based Optimizer?\",\"datePublished\":\"2019-09-08T06:57:32+00:00\",\"dateModified\":\"2025-06-14T03:19:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/\"},\"wordCount\":1507,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/09\/london-tube-2.jpeg\",\"keywords\":[\"cbo\",\"NoSQL Database\",\"Optimizer\"],\"articleSection\":[\"High Performance\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/\",\"name\":\"Less Is More: Why Use a Cost-Based Optimizer? - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/09\/london-tube-2.jpeg\",\"datePublished\":\"2019-09-08T06:57:32+00:00\",\"dateModified\":\"2025-06-14T03:19:34+00:00\",\"description\":\"Couchbase includes a cost-based optimizer (CBO). Learn how having a CBO improves query performance and how to implement it.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/09\/london-tube-2.jpeg\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/09\/london-tube-2.jpeg\",\"width\":1200,\"height\":800,\"caption\":\"A schematic walking map of the London Tube\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Less Is More: Why Use a Cost-Based Optimizer?\"}]},{\"@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\/c261644262bf98e146372fe647682636\",\"name\":\"Keshav Murthy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/4e51d72fc07c662aa791316deafffac4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g\",\"caption\":\"Keshav Murthy\"},\"description\":\"Keshav Murthy is a Vice President at Couchbase R&amp;D. Previously, he was at MapR, IBM, Informix, Sybase, with more than 20 years of experience in database design &amp; development. He lead the SQL and NoSQL R&amp;D team at IBM Informix. He has received two President's Club awards at Couchbase, two Outstanding Technical Achievement Awards at IBM. Keshav has a bachelor's degree in Computer Science and Engineering from the University of Mysore, India, holds eleven US patents and has four US patents pending.\",\"sameAs\":[\"https:\/\/blog.planetnosql.com\/\",\"https:\/\/x.com\/rkeshavmurthy\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/keshav-murthy\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\uc801\uc740 \uac83\uc774 \ub354 \ub9ce\uc2b5\ub2c8\ub2e4: \ube44\uc6a9 \uae30\ubc18 \uc635\ud2f0\ub9c8\uc774\uc800\ub97c \uc0ac\uc6a9\ud574\uc57c \ud558\ub294 \uc774\uc720 - Couchbase \ube14\ub85c\uadf8","description":"Couchbase\uc5d0\ub294 \ube44\uc6a9 \uae30\ubc18 \ucd5c\uc801\ud654 \ub3c4\uad6c(CBO)\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. CBO\ub97c \uc0ac\uc6a9\ud558\uba74 \ucffc\ub9ac \uc131\ub2a5\uc774 \uc5b4\ub5bb\uac8c \ud5a5\uc0c1\ub418\ub294\uc9c0, \uadf8\ub9ac\uace0 \uc5b4\ub5bb\uac8c \uad6c\ud604\ud558\ub294\uc9c0 \uc54c\uc544\ubcf4\uc138\uc694.","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\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/","og_locale":"ko_KR","og_type":"article","og_title":"Less Is More: Why Use a Cost-Based Optimizer?","og_description":"Couchbase includes a cost-based optimizer (CBO). Learn how having a CBO improves query performance and how to implement it.","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/","og_site_name":"The Couchbase Blog","article_published_time":"2019-09-08T06:57:32+00:00","article_modified_time":"2025-06-14T03:19:34+00:00","og_image":[{"width":1200,"height":800,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/09\/london-tube-2.jpeg","type":"image\/jpeg"}],"author":"Keshav Murthy","twitter_card":"summary_large_image","twitter_creator":"@rkeshavmurthy","twitter_misc":{"Written by":"Keshav Murthy","Est. reading time":"8\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/"},"author":{"name":"Keshav Murthy","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636"},"headline":"Less Is More: Why Use a Cost-Based Optimizer?","datePublished":"2019-09-08T06:57:32+00:00","dateModified":"2025-06-14T03:19:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/"},"wordCount":1507,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/09\/london-tube-2.jpeg","keywords":["cbo","NoSQL Database","Optimizer"],"articleSection":["High Performance","SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/","url":"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/","name":"\uc801\uc740 \uac83\uc774 \ub354 \ub9ce\uc2b5\ub2c8\ub2e4: \ube44\uc6a9 \uae30\ubc18 \uc635\ud2f0\ub9c8\uc774\uc800\ub97c \uc0ac\uc6a9\ud574\uc57c \ud558\ub294 \uc774\uc720 - Couchbase \ube14\ub85c\uadf8","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/09\/london-tube-2.jpeg","datePublished":"2019-09-08T06:57:32+00:00","dateModified":"2025-06-14T03:19:34+00:00","description":"Couchbase\uc5d0\ub294 \ube44\uc6a9 \uae30\ubc18 \ucd5c\uc801\ud654 \ub3c4\uad6c(CBO)\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. CBO\ub97c \uc0ac\uc6a9\ud558\uba74 \ucffc\ub9ac \uc131\ub2a5\uc774 \uc5b4\ub5bb\uac8c \ud5a5\uc0c1\ub418\ub294\uc9c0, \uadf8\ub9ac\uace0 \uc5b4\ub5bb\uac8c \uad6c\ud604\ud558\ub294\uc9c0 \uc54c\uc544\ubcf4\uc138\uc694.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/09\/london-tube-2.jpeg","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/09\/london-tube-2.jpeg","width":1200,"height":800,"caption":"A schematic walking map of the London Tube"},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/why-cost-based-optimizer-for-nosql-n1ql-couchbase\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Less Is More: Why Use a Cost-Based Optimizer?"}]},{"@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\/c261644262bf98e146372fe647682636","name":"\ucf00\uc0e4\ube0c \uba38\uc2dc","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/4e51d72fc07c662aa791316deafffac4","url":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","caption":"Keshav Murthy"},"description":"\ucf00\uc0e4\ube0c \uba38\uc2dc\ub294 Couchbase R&amp;D\uc758 \ubd80\uc0ac\uc7a5\uc785\ub2c8\ub2e4. \uc774\uc804\uc5d0\ub294 MapR, IBM, Informix, Sybase\uc5d0\uc11c \uadfc\ubb34\ud588\uc73c\uba70 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \uac1c\ubc1c \ubd84\uc57c\uc5d0\uc11c 20\ub144 \uc774\uc0c1\uc758 \uacbd\ub825\uc744 \uc313\uc558\uc2b5\ub2c8\ub2e4. IBM Informix\uc5d0\uc11c SQL \ubc0f NoSQL R&amp;D \ud300\uc744 \uc774\ub04c\uc5c8\uc2b5\ub2c8\ub2e4. Couchbase\uc5d0\uc11c \ub450 \ucc28\ub840\uc758 President's Club \uc0c1\uc744, IBM\uc5d0\uc11c \ub450 \ucc28\ub840\uc758 Outstanding Technical Achievement Award\ub97c \uc218\uc0c1\ud588\uc2b5\ub2c8\ub2e4. \uc778\ub3c4 \ub9c8\uc774\uc18c\ub974 \ub300\ud559\uad50\uc5d0\uc11c \ucef4\ud4e8\ud130 \uacfc\ud559 \ubc0f \uacf5\ud559 \ud559\uc0ac \ud559\uc704\ub97c \ubc1b\uc558\uc73c\uba70, 11\uac1c\uc758 \ubbf8\uad6d \ud2b9\ud5c8\ub97c \ubcf4\uc720\ud558\uace0 \uc788\uace0 4\uac1c\uc758 \ubbf8\uad6d \ud2b9\ud5c8\ub97c \ucd9c\uc6d0 \uc911\uc785\ub2c8\ub2e4.","sameAs":["https:\/\/blog.planetnosql.com\/","https:\/\/x.com\/rkeshavmurthy"],"url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/keshav-murthy\/"}]}},"authors":[{"term_id":8929,"user_id":55,"is_guest":0,"slug":"keshav-murthy","display_name":"Keshav Murthy","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","author_category":"","last_name":"Murthy","first_name":"Keshav","job_title":"","user_url":"https:\/\/blog.planetnosql.com\/","description":"\ucf00\uc0e4\ube0c \uba38\uc2dc\ub294 Couchbase R&amp;D\uc758 \ubd80\uc0ac\uc7a5\uc785\ub2c8\ub2e4. \uc774\uc804\uc5d0\ub294 MapR, IBM, Informix, Sybase\uc5d0\uc11c \uadfc\ubb34\ud588\uc73c\uba70 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \uac1c\ubc1c \ubd84\uc57c\uc5d0\uc11c 20\ub144 \uc774\uc0c1\uc758 \uacbd\ub825\uc744 \uc313\uc558\uc2b5\ub2c8\ub2e4. IBM Informix\uc5d0\uc11c SQL \ubc0f NoSQL R&amp;D \ud300\uc744 \uc774\ub04c\uc5c8\uc2b5\ub2c8\ub2e4. Couchbase\uc5d0\uc11c \ub450 \ubc88\uc758 President's Club \uc0c1\uc744, IBM\uc5d0\uc11c \ub450 \ubc88\uc758 \uc6b0\uc218 \uae30\uc220 \uc5c5\uc801\uc0c1\uc744 \uc218\uc0c1\ud588\uc2b5\ub2c8\ub2e4. \uc778\ub3c4 \ub9c8\uc774\uc18c\ub974 \ub300\ud559\uad50\uc5d0\uc11c \ucef4\ud4e8\ud130 \uacfc\ud559 \ubc0f \uacf5\ud559 \ud559\uc0ac \ud559\uc704\ub97c \ubc1b\uc558\uc73c\uba70, 10\uac1c\uc758 \ubbf8\uad6d \ud2b9\ud5c8\ub97c \ubcf4\uc720\ud558\uace0 \uc788\uace0 3\uac1c\uc758 \ubbf8\uad6d \ud2b9\ud5c8\ub97c \ucd9c\uc6d0 \uc911\uc785\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/7634","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\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=7634"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/7634\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/10799"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=7634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=7634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=7634"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=7634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}