{"id":1993,"date":"2016-01-04T18:31:14","date_gmt":"2016-01-04T18:31:13","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=1993"},"modified":"2025-06-13T17:24:49","modified_gmt":"2025-06-14T00:24:49","slug":"data-modelling-for-n1ql","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/data-modelling-for-n1ql\/","title":{"rendered":"N1QL\uc6a9 \ub370\uc774\ud130 \ubaa8\ub378\ub9c1"},"content":{"rendered":"<p>Couchbase\ub97c \uc0ac\uc6a9\ud55c \ud0a4-\uac12 \ub370\uc774\ud130 \ubaa8\ub378\ub9c1\uc5d0 \uad00\ud55c \uac8c\uc2dc\ubb3c\uc5d0\uc11c \uc8fc\uc694 \uad00\uc2ec\uc0ac\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n<ul>\n<li>*\u00a0<a href=\"https:\/\/www.couchbase.com\/blog\/ko\/data-modelling-when-embed-or-refer\/\">\ub370\uc774\ud130 \uc0bd\uc785 \uc2dc\uae30 \ubc0f \ucc38\uc870 \uc2dc\uae30<\/a><\/li>\n<li>*\u00a0<a href=\"https:\/\/www.couchbase.com\/blog\/ko\/manual-secondary-indexes\/\">\ubcf4\uc870 \uc778\ub371\uc2a4 \uad6c\ucd95<\/a><\/li>\n<li>*\u00a0<a href=\"https:\/\/www.couchbase.com\/blog\/ko\/data-modelling-key-design\/\">\ud0a4 \ub514\uc790\uc778<\/a>.<\/li>\n<\/ul>\n<p>N1QL\uc758 \uc138\uacc4\uc5d0\uc11c \uc6b0\ub9ac\ub294 \uc5ec\uc804\ud788 \ube44\uc2b7\ud55c \uac83\uc5d0 \ub300\ud574 \uc0dd\uac01\ud558\uace0 \uc788\uc73c\uba70, \uc774 \uae00\uc5d0\uc11c\ub294 \uadf8 \uc911 \ub450 \uac00\uc9c0\ub97c \uc0b4\ud3b4\ubcfc \uac83\uc785\ub2c8\ub2e4:<\/p>\n<ul>\n<li>* \ubb38\uc11c \uc720\ud615\uc744 \ud45c\ud604\ud558\ub294 \ubc29\ubc95<\/li>\n<li>* \ubb38\uc11c \uac04\uc758 \uad00\uacc4\ub97c \ubaa8\ub378\ub9c1\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p>\uadfc\ubcf8\uc801\uc73c\ub85c\ub294 \uc5ec\uc804\ud788 \uc62c\ubc14\ub978 \uc808\ucda9\uc548\uc744 \ub9cc\ub4e4\uc5b4\uc11c <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/conceptual-physical-logical-data-models\/\">\ubb3c\ub9ac\uc801 \ub370\uc774\ud130 \ubaa8\ub378<\/a> \ub17c\ub9ac \ubaa8\ub378\uc744 \uac00\uc7a5 \ud6a8\uc728\uc801\uc73c\ub85c \ud45c\ud604\ud569\ub2c8\ub2e4. \ubcc0\uacbd\ub41c \uac83\uc740 \uba87 \uac00\uc9c0 \uad6c\ud604 \uc138\ubd80 \uc0ac\ud56d\ubfd0\uc785\ub2c8\ub2e4.<\/p>\n<h2>\uc544\ubb34\uac83\ub3c4 \ud558\uc9c0 \uc54a\uc74c<\/h2>\n<p>\uba3c\uc800, \ubcc0\uacbd\ud560 \ud544\uc694 \uc5c6\uc774 \uae30\uc874 JSON \ub370\uc774\ud130\ub97c \ucffc\ub9ac\ud560 \uc218 \uc788\ub2e4\ub294 \uc810\uc744 \ub9d0\uc500\ub4dc\ub9ac\uace0 \uc2f6\uc2b5\ub2c8\ub2e4. N1QL\uc740 \uae30\uc874 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\uccb4\ub97c \uac1c\uc870\ud560 \uac83\uc744 \uc694\uad6c\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ud558\uc9c0\ub9cc \ubaa8\ub378\uc744 \ubcc0\uacbd\ud558\uc5ec N1QL\uc758 \ud6a8\uc728\uc744 \ub192\uc774\uace0 \ucffc\ub9ac\ub97c \ub354 \uc27d\uac8c \uc791\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ucc98\uc74c\ubd80\ud130 \ub2e4\uc2dc \uc2dc\uc791\ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 \ucc98\uc74c\ubd80\ud130 N1QL \ucffc\ub9ac \uac00\ub2a5\uc131\uc744 \uace0\ub824\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n<h2>\ubb38\uc11c \uc720\ud615<\/h2>\n<p>\ud0a4-\uac12 \ub370\uc774\ud130 \ubaa8\ub378\ub9c1\uc5d0\uc11c \uac00\uc7a5 \uc911\uc694\ud55c \ubd80\ubd84 \uc911 \ud558\ub098\ub294 \ud0a4 \uc124\uacc4\uc785\ub2c8\ub2e4. \ud0a4-\uac12 \uc138\uacc4\uc5d0\uc11c \ud0a4\ub294 \ubb34\uc5c7\uc744 \uc800\uc7a5\ud558\uace0 \uc788\ub294\uc9c0 \uc54c\ub824\uc8fc\uace0 \ub2e4\uc2dc \uc27d\uac8c \ucc3e\uc744 \uc218 \uc788\uc5b4\uc57c \ud55c\ub2e4\ub294 \ub9c9\uc911\ud55c \ucc45\uc784\uc744 \uc9c0\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc608\ub97c \ub4e4\uc5b4 \uace0\uac1d \uae30\ub85d\uc758 \ud0a4\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \ud615\uc2dd\uc744 \ucde8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n<ul>\n<li><code>* cust::name<\/code> \uc8fc\uc694 \uace0\uac1d \uae30\ub85d<\/li>\n<li><code>* cust::name::payment<\/code> \uace0\uac1d\uc758 \uacb0\uc81c \uc138\ubd80 \uc815\ubcf4<\/li>\n<\/ul>\n<p>\ub9ac\uce58 \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uba74 \ud0a4 \uc774\ub984\uc758 \uc5ed\ud560\uc774 \ubcc0\uacbd\ub429\ub2c8\ub2e4. \ud0a4\ub97c \uc9c1\uc811 \uc694\uccad\ud558\ub294 \ub300\uc2e0 \uc6d0\ud558\ub294 \ub370\uc774\ud130\ub97c \uc694\uccad\ud558\uac8c \ub429\ub2c8\ub2e4. \uc800\uc7a5\ud558\ub294 \ub0b4\uc6a9\uc744 \uc124\uba85\ud558\uace0 \ub370\uc774\ud130\ub97c \uc27d\uac8c \ucc3e\uc744 \uc218 \uc788\ub3c4\ub85d \ud558\ub294 \ub450 \uac00\uc9c0 \ucc45\uc784\uc774 \ubb38\uc11c \uc790\uccb4\uc758 \ubb38\uc11c \uc720\ud615\uc73c\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc5ec\uae30\uc11c N1QL\uacfc SQL\uc758 \ud070 \uc2e4\uc9c8\uc801\uc778 \ucc28\uc774\uc810 \uc911 \ud558\ub098\ub97c \ubc1c\uacac\ud588\uc2b5\ub2c8\ub2e4: \uc624\ub298\ub0a0 N1QL\uc5d0\uc11c FROM\uc740 \ub354 \uc801\uc740 \uc791\uc5c5\uc744 \uc218\ud589\ud569\ub2c8\ub2e4. Couchbase \ubc84\ud0b7\uc758 \ubc94\uc704\ub294 \uc77c\ubc18\uc801\uc778 \uad00\uacc4\ud615 \ud14c\uc774\ube14\uc758 \ubc94\uc704\uc640 \ud06c\uac8c \ub2e4\ub985\ub2c8\ub2e4.<\/p>\n<p>SQL FROM\uc740 \uad00\uc2ec \uc788\ub294 \ub370\uc774\ud130\ub85c \ucffc\ub9ac \ubc94\uc704\ub97c \uc881\ud799\ub2c8\ub2e4. N1QL FROM\uc740 \ucffc\ub9ac \uc5d4\uc9c4\uc5d0 \uc5b4\ub5a4 \ubc84\ud0b7\uc744 \uc0b4\ud3b4\ubcfc\uc9c0 \uc54c\ub824\uc90d\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc778 \ubc84\ud0b7\uc5d0\ub294 \ud558\ub098\uc758 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0 \ub300\ud55c \ubaa8\ub4e0 \ub370\uc774\ud130\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc73c\ubbc0\ub85c \ubb38\uc11c \uc720\ud615\uc744 \uad6c\ubd84\ud558\ub294 \ub2e4\ub978 \ubc29\ubc95\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n<h3>\uace0\uac1d<\/h3>\n<p>\ud55c \uace0\uac1d\uc744 \uc790\uc138\ud788 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \uac04\ub2e8\ud55c \uae30\ub85d\uc785\ub2c8\ub2e4:<\/p>\n<p><code>{ <\/code><\/p>\n<p><code>\u00a0 \"\uc774\ub984\": \"\uc568\ub7f0 \ud30c\ud2b8\ub9ac\uc9c0\", <\/code><\/p>\n<p><code>\u00a0 \"\uc774\uba54\uc77c\": \"alan@example.com\", <\/code><\/p>\n<p><code>\u00a0 \"\uc704\uce58\": \"\ub178\ub9ac\uce58\", <\/code><\/p>\n<p><code>\u00a0 \"\uc804\ud654\": \"+44-1603-619-331\", <\/code><\/p>\n<p><code>\u00a0 \"docInfo\": <\/code><\/p>\n<p><code>\u00a0 { <\/code><\/p>\n<p><code>\u00a0 \u00a0 \"type\": \"\uace0\uac1d\", <\/code><\/p>\n<p><code>\u00a0 \u00a0 \"created\": \"2015-10-22T10:17:24.731Z\", <\/code><\/p>\n<p><code>\u00a0 \u00a0 \"schemaVersion\": \"1.2.3\" <\/code><\/p>\n<p><code>\u00a0 } <\/code><\/p>\n<p><code>} <\/code><\/p>\n<p>\uadf8\ub9ac\uace0 <i>\uc720\ud615<\/i> \uac12\uc744 \uc785\ub825\ud558\uc5ec N1QL \ucffc\ub9ac\uc758 \ubc94\uc704\ub97c \uc881\ud799\ub2c8\ub2e4:<\/p>\n<p><code>SELECT * FROM `default` WHERE type = customer;<\/code><\/p>\n<p>\uc0ac\uc6a9 <code>\uc720\ud615<\/code> \ub97c \uc0ac\uc6a9\ud558\uba74 \ud2b9\uc815 \uc720\ud615\uc758 \ubb38\uc11c\ub9cc \ud3ec\ud568\ud558\ub294 \uc778\ub371\uc2a4\ub97c \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4<\/p>\n<p><code>CREATE INDEX customers ON `default` WHERE type=customer; <\/code><\/p>\n<p>\ubb38\uc11c \uc2a4\ud0a4\ub9c8\uc5d0 \uc774\ubbf8 \uc720\ud615\uc774 \uc9c0\uc815\ub418\uc5b4 \uc788\uc744 \uac00\ub2a5\uc131\uc774 \ub192\uc73c\uba70, \ud2b9\ud788 Couchbase \ubcf4\uae30\ub97c \uc0ac\uc6a9\ud558\uace0 \uc788\ub294 \uacbd\uc6b0\uc5d0\ub294 \ub354\uc6b1 \uadf8\ub807\uc2b5\ub2c8\ub2e4. \uc5b4\ub290 \ucabd\uc774\ub4e0 \ubb38\uc11c\ub97c \ub9cc\ub4e4 \ub54c\ub294 \ubb38\uc11c \ubcf8\ubb38 \ub0b4\uc5d0 \uc720\ud615\uc744 \uc9c0\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p>\ud5a5\ud6c4 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc640 N1QL\uc758 \ubc18\ubcf5 \uc791\uc5c5\uc5d0\uc11c\ub294 \ubc84\ud0b7 \uc218\uc900 \uc774\ud558\uc758 \ub124\uc784\uc2a4\ud398\uc774\uc2a4\ub97c \ubcfc \uc218 \uc788\uc9c0\ub9cc, \uc720\ud615\uc740 \ud56d\uc0c1 \uc800\ub834\ud55c \ube44\uc6a9\uc73c\ub85c \ubb38\uc11c\ub97c \uad6c\ubd84\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc744 \uc81c\uacf5\ud560 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<h2>\ubb38\uc11c \uac04\uc758 \uad00\uacc4<\/h2>\n<p>\uc5d0 \ub300\ud55c \uc9c8\ubb38 <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/data-modelling-when-embed-or-refer\/\">\uc784\ubca0\ub4dc \uc2dc\uae30 \ubc0f \ucc38\uc870 \uc2dc\uae30<\/a> \uc740 N1QL\uc744 \ubaa8\ub378\ub9c1\ud560 \ub54c \uc5ec\uc804\ud788 \uc911\uc694\ud55c \uc694\uc18c\uc785\ub2c8\ub2e4. \ucc28\uc774\uc810\uc740 N1QL\uc740 JOIN\uc744 \ud1b5\ud574 \uc774\ub7ec\ud55c \uad00\uacc4\ub97c \ucc98\ub9ac\ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<p>N1QL \uc870\uc778\uc740 \uadf8 \uc0ac\uc774\uc5d0 \uc774\ub8e8\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n<ul>\n<li>* \ub2e4\ub978 \ubc84\ud0b7\uc5d0 \uc788\ub294 \ubb38\uc11c<\/li>\n<li>* \uac19\uc740 \ubc84\ud0b7\uc5d0 \uc788\ub294 \ubb38\uc11c<\/li>\n<\/ul>\n<p>\ub450 \uacbd\uc6b0 \ubaa8\ub450 \uc870\uc778\uc740 \uc67c\ucabd\uc5d0 \uc788\ub294 \ubb38\uc11c\uc758 \uac12\uc744 \uc624\ub978\ucabd\uc5d0 \uc788\ub294 \ubb38\uc11c\uc758 \ud0a4 \uc774\ub984\uacfc \uc77c\uce58\uc2dc\ud0b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \ud55c \ubb38\uc11c\uc5d0 \ub2e4\ub978 \ubb38\uc11c\uc758 \ud0a4 \uc774\ub984\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\ub294 \uacbd\uc6b0 \ub450 \ubb38\uc11c\ub97c \uc870\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uac00\uc0c1\uc758 \uace0\uac1d\uc758 \uac00\uc7a5 \ucd5c\uadfc \uad6c\ub9e4\ub97c \ud504\ub85c\ud544\uc5d0 \ucd94\uac00\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4:<\/p>\n<p><code>{ lastPurchase: \"prod::drivinggloves\" } <\/code><\/p>\n<p>\uc5ec\uae30\uc758 \uac12\uc740 \ubc84\ud0b7\uc758 \ub2e4\ub978 \uacf3\uc5d0 \uc788\ub294 \uc81c\ud488 \ubb38\uc11c\uc758 \ud0a4 \uc774\ub984\uc774\uae30\ub3c4 \ud569\ub2c8\ub2e4.<\/p>\n<p>\ub530\ub77c\uc11c Norwuch\uc5d0 \uac70\uc8fc\ud558\ub294 \ubaa8\ub4e0 \uace0\uac1d\uc5d0 \ub300\ud574 \uace0\uac1d\uc758 \uc774\ub984\uacfc \ub9c8\uc9c0\ub9c9 \uad6c\ub9e4 \uac00\uaca9\uc744 \ubc18\ud658\ud558\ub824\uba74 \ub2e4\uc74c N1QL\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4:<\/p>\n<p><code>SELECT r.name, a.price FROM `default` r JOIN `default` a ON KEYS r.lastPurchase WHERE r.location = \"Norwich\"; <\/code><\/p>\n<p>\uacb0\uacfc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n<p><code>{ <\/code><\/p>\n<p><code>\u00a0 \"\uc694\uccadID\": \"a2284985-541f-491d-b921-4c248f154293\", <\/code><\/p>\n<p><code>\u00a0 \"\uc11c\uba85\": <\/code><\/p>\n<p><code>\u00a0 { <\/code><\/p>\n<p><code>\u00a0 \u00a0 \"name\": \"json\", <\/code><\/p>\n<p><code>\u00a0 \u00a0 \"price\": \"json\" }, <\/code><\/p>\n<p><code>\u00a0 \u00a0\"\uacb0\uacfc\": <\/code><\/p>\n<p><code>\u00a0 \u00a0 [ <\/code><\/p>\n<p><code>\u00a0 \u00a0 \u00a0 { \"name\": \"\uc568\ub7f0 \ud30c\ud2b8\ub9ac\uc9c0\", <\/code><\/p>\n<p><code>\u00a0 \u00a0 \u00a0 \"price\": \"9.99\" <\/code><\/p>\n<p><code>\u00a0 \u00a0 \u00a0 } <\/code><\/p>\n<p><code>\u00a0 \u00a0 ], <\/code><\/p>\n<p><code>\u00a0 \u00a0 \"\uc0c1\ud0dc\": \"\uc131\uacf5\", <\/code><\/p>\n<p><code>\u00a0 \u00a0 \"\uba54\ud2b8\ub9ad\": <\/code><\/p>\n<p><code>\u00a0 \u00a0 { <\/code><\/p>\n<p><code>\u00a0 \u00a0 \u00a0 \"elapsedTime\": \"5.223111ms\", <\/code><\/p>\n<p><code>\u00a0 \u00a0 \u00a0 \"\uc2e4\ud589 \uc2dc\uac04\": \"5.124029ms\", <\/code><\/p>\n<p><code>\u00a0 \u00a0 \u00a0 \"resultCount\": 1, <\/code><\/p>\n<p><code>\u00a0 \u00a0 \u00a0 \"\uacb0\uacfc \ud06c\uae30\": 77 <\/code><\/p>\n<p><code>\u00a0 \u00a0 } <\/code><\/p>\n<p><code>} <\/code><\/p>\n<p>N1QL\uc744 \uc0ac\uc6a9\ud558\uba74 \ubb38\uc11c \uac04\uc5d0 \uc77c\ub300\uc77c, \uc77c\ub300\ub2e4, \ub2e4\ub300\ub2e4 \uad00\uacc4\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc774\uc804\uc5d0\ub294 \uc784\ubca0\ub514\ub4dc \ubb38\uc11c\uac00 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ubaa8\ub378\ub9c1\ud558\ub294 \ub370 \ud070 \ubd80\ubd84\uc744 \ucc28\uc9c0\ud588\uc9c0\ub9cc, N1QL\uc744 \uc0ac\uc6a9\ud558\uba74 \uac1c\ubc1c\uc790\uac00 \uc27d\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h2>\uc694\uc57d<\/h2>\n<p>\uc774 \uac8c\uc2dc\ubb3c\uc5d0\uc11c \uc8fc\ubaa9\ud574\uc57c \ud560 \ub450 \uac00\uc9c0 \uc8fc\uc694 \uc0ac\ud56d\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n<ul>\n<li>\ubb38\uc11c\uc5d0\ub294 \ucffc\ub9ac\uc5d0\uc11c \ubc94\uc704\ub97c \uc881\ud788\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc720\ud615\uc774 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<li>\uc870\uc778\uc740 \uc67c\ucabd \ubb38\uc11c\uc758 \ubcf8\ubb38\uc5d0 \ub098\ud0c0\ub098\ub294 \uc624\ub978\ucabd \ubb38\uc11c\uc758 \uae30\ubcf8 \ud0a4\uc5d0 \uc758\uc874\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p>\uad81\uadf9\uc801\uc73c\ub85c N1QL\uc744 \uc0ac\uc6a9\ud558\uae30 \uc704\ud574 JSON \ub370\uc774\ud130\uc5d0 \ub300\ud574 \ud06c\uac8c \ubcc0\uacbd\ud560 \ud544\uc694\ub294 \uc5c6\uc2b5\ub2c8\ub2e4. N1QL\uc5d0 \ub300\ud574 \ub354 \uc790\uc138\ud788 \uc54c\uc544\uac00\ub2e4 \ubcf4\uba74 \ub2e4\ub978 \uac83\ubcf4\ub2e4 \ub354 \uc798 \uc791\ub3d9\ud558\ub294 \ubb38\uc11c \ud615\ud0dc\ub97c \ubc1c\uacac\ud558\uac8c \ub420 \uac83\uc785\ub2c8\ub2e4. \uadf8\ub807\ub2e4\uba74 \uadf8 \ubaa8\uc591\uc744 <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/forums\/\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ud3ec\ub7fc<\/a>!<\/p>","protected":false},"excerpt":{"rendered":"<p>In my posts on key-value data modelling with Couchbase, the main concerns were: *\u00a0when to embed data and when to refer *\u00a0building secondary indexes *\u00a0key design. In a N1QL world, we&#8217;re still thinking about similar things and in this post [&hellip;]<\/p>","protected":false},"author":18,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1819,1812],"tags":[1883],"ppma_author":[8982],"class_list":["post-1993","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-modeling","category-n1ql-query","tag-data-modelling"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.0 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data modelling for N1QL - The Couchbase Blog<\/title>\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\/data-modelling-for-n1ql\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data modelling for N1QL\" \/>\n<meta property=\"og:description\" content=\"In my posts on key-value data modelling with Couchbase, the main concerns were: *\u00a0when to embed data and when to refer *\u00a0building secondary indexes *\u00a0key design. In a N1QL world, we&#8217;re still thinking about similar things and in this post [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/data-modelling-for-n1ql\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-01-04T18:31:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T00:24:49+00:00\" \/>\n<meta name=\"author\" content=\"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/\"},\"author\":{\"name\":\"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/6c3060a94353df62a71d4672b3454555\"},\"headline\":\"Data modelling for N1QL\",\"datePublished\":\"2016-01-04T18:31:13+00:00\",\"dateModified\":\"2025-06-14T00:24:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/\"},\"wordCount\":773,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"keywords\":[\"data modelling\"],\"articleSection\":[\"Data Modeling\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/\",\"name\":\"Data modelling for N1QL - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2016-01-04T18:31:13+00:00\",\"dateModified\":\"2025-06-14T00:24:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"width\":1800,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data modelling for N1QL\"}]},{\"@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\/6c3060a94353df62a71d4672b3454555\",\"name\":\"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/b1bc555cd9166b46d6063003c3b92317\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3b38ea45b78371f0008a765ea828bfed91aa97c25981ebf214226402a510b39b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3b38ea45b78371f0008a765ea828bfed91aa97c25981ebf214226402a510b39b?s=96&d=mm&r=g\",\"caption\":\"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase\"},\"description\":\"Matthew Revell is a Lead Dev Advocate, EMEA Couchbase. He developed a global strategy for putting Couchbase front in the minds of the product's developers.\",\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/matthew-revell\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data modelling for N1QL - The Couchbase Blog","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\/data-modelling-for-n1ql\/","og_locale":"ko_KR","og_type":"article","og_title":"Data modelling for N1QL","og_description":"In my posts on key-value data modelling with Couchbase, the main concerns were: *\u00a0when to embed data and when to refer *\u00a0building secondary indexes *\u00a0key design. In a N1QL world, we&#8217;re still thinking about similar things and in this post [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/data-modelling-for-n1ql\/","og_site_name":"The Couchbase Blog","article_published_time":"2016-01-04T18:31:13+00:00","article_modified_time":"2025-06-14T00:24:49+00:00","author":"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase","Est. reading time":"4\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/"},"author":{"name":"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/6c3060a94353df62a71d4672b3454555"},"headline":"Data modelling for N1QL","datePublished":"2016-01-04T18:31:13+00:00","dateModified":"2025-06-14T00:24:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/"},"wordCount":773,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","keywords":["data modelling"],"articleSection":["Data Modeling","SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/","url":"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/","name":"Data modelling for N1QL - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2016-01-04T18:31:13+00:00","dateModified":"2025-06-14T00:24:49+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","width":1800,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/data-modelling-for-n1ql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Data modelling for N1QL"}]},{"@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\/6c3060a94353df62a71d4672b3454555","name":"Matthew Revell, \uc218\uc11d \uac1c\ubc1c\uc790 \uc639\ud638\uc790, EMEA \uc9c0\uc5ed, Couchbase","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/b1bc555cd9166b46d6063003c3b92317","url":"https:\/\/secure.gravatar.com\/avatar\/3b38ea45b78371f0008a765ea828bfed91aa97c25981ebf214226402a510b39b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3b38ea45b78371f0008a765ea828bfed91aa97c25981ebf214226402a510b39b?s=96&d=mm&r=g","caption":"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase"},"description":"\ub9e4\ud29c \ub808\ubca8\uc740 EMEA \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc758 \uc218\uc11d \uac1c\ubc1c\uc790 \uc639\ud638\uc790\uc785\ub2c8\ub2e4. \uadf8\ub294 \uc81c\ud488 \uac1c\ubc1c\uc790\ub4e4\uc758 \ub9c8\uc74c\uc18d\uc5d0 Couchbase\ub97c \uac01\uc778\uc2dc\ud0a4\uae30 \uc704\ud55c \uae00\ub85c\ubc8c \uc804\ub7b5\uc744 \uac1c\ubc1c\ud588\uc2b5\ub2c8\ub2e4.","url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/matthew-revell\/"}]}},"authors":[{"term_id":8982,"user_id":18,"is_guest":0,"slug":"matthew-revell","display_name":"Matthew Revell, Lead Developer Advocate, EMEA, Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/3b38ea45b78371f0008a765ea828bfed91aa97c25981ebf214226402a510b39b?s=96&d=mm&r=g","author_category":"","last_name":"Revell","first_name":"Matthew","job_title":"","user_url":"","description":"\ub9e4\ud29c \ub808\ubca8\uc740 EMEA \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc758 \uc218\uc11d \uac1c\ubc1c\uc790 \uc639\ud638\uc790\uc785\ub2c8\ub2e4. \uadf8\ub294 \uc81c\ud488 \uac1c\ubc1c\uc790\ub4e4\uc758 \ub9c8\uc74c\uc18d\uc5d0 Couchbase\ub97c \uac01\uc778\uc2dc\ud0a4\uae30 \uc704\ud55c \uae00\ub85c\ubc8c \uc804\ub7b5\uc744 \uac1c\ubc1c\ud588\uc2b5\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/1993","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\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=1993"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/1993\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=1993"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=1993"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=1993"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=1993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}