{"id":9756,"date":"2021-08-16T00:00:46","date_gmt":"2021-08-16T07:00:46","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=9756"},"modified":"2025-06-13T18:43:32","modified_gmt":"2025-06-14T01:43:32","slug":"simplifying-query-index-with-collections","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/simplifying-query-index-with-collections\/","title":{"rendered":"N1QL \ucffc\ub9ac\ub97c \uac04\uc18c\ud654\ud558\uace0 \uceec\ub809\uc158\uc73c\ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud558\ub294 5\ub2e8\uacc4"},"content":{"rendered":"

\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c NoSQL\ub85c \ub370\uc774\ud130\ub97c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud558\ub824\ub294 \uacbd\uc6b0,<\/strong> \uadf8\ub807\ub2e4\uba74 \uc9c0\uae08\uc774 \uadf8 \uc5b4\ub290 \ub54c\ubcf4\ub2e4 \uc88b\uc740 \uc2dc\uae30\uc785\ub2c8\ub2e4.<\/p>\n

\ucd5c\uadfc \ucd9c\uc2dc\ub41c Couchbase 7.0\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/a> \ubc94\uc704 \ubc0f \uceec\ub809\uc158\uc744 \uc18c\uac1c\ud569\ub2c8\ub2e4. JSON \ub370\uc774\ud130<\/a>. \ubb34\uc5c7\ubcf4\ub2e4\ub3c4 \ubc94\uc704\uc640 \uceec\ub809\uc158\uc744 \uc0ac\uc6a9\ud558\uba74 \ud604\uc7ac\uc758 \uad00\uacc4\ud615 \ub370\uc774\ud130 \ubaa8\ub378\uc744 Couchbase \ubb38\uc11c \ub370\uc774\ud130 \ubaa8\ub378\ub85c \ub354 \uac04\ub2e8\ud558\uace0 \uc27d\uac8c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uacb0\uacfc\uc801\uc73c\ub85c \uae30\uc5c5\uc740 Couchbase\uc758 \ubd84\uc0b0\ud615 \uacf5\uc720 \uc544\ud0a4\ud14d\ucc98, \uace0\uac00\uc6a9\uc131 \ubc0f \uc218\ud3c9\uc801 \ud655\uc7a5\uc131\uc758 \uc774\uc810\uc744 \ub204\ub9b4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\uadf8\ub9ac\uace0 Couchbase\uc758 \uc624\ub79c \uace0\uac1d \ub610\ub294 \uc0ac\uc6a9\uc790\ub77c\uba74 - \ubc94\uc704 \ubc0f \uceec\ub809\uc158\uc740 \ub370\uc774\ud130 \uad00\ub9ac \ubc0f \uad6c\uc131 \uce21\uba74\uc5d0\uc11c \ub9ce\uc740 \uac83\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/a>.<\/p>\n

\ud558\uc9c0\ub9cc NoSQL\uc744 \ucc98\uc74c \uc0ac\uc6a9\ud558\ub4e0 Couchbase \ubca0\ud14c\ub791\uc774\ub4e0 \uc0c1\uad00\uc5c6\uc774 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucffc\ub9ac\ub294 -. N1QL \ucffc\ub9ac \uc5b8\uc5b4 \uc0ac\uc6a9<\/a> - \uc0c8\ub85c\uc6b4 \ubc94\uc704 \ubc0f \uceec\ub809\uc158 \ub370\uc774\ud130 \ubaa8\ub378\uc758 \uc774\uc810\uc744 \ud65c\uc6a9\ud558\uc138\uc694. N1QL \ucffc\ub9ac\ub97c \uac04\uc18c\ud654\ud558\ub824\uba74 \uc774\uc804 Bucket \ubaa8\ub378\uc5d0\uc11c \uc0c8\ub85c\uc6b4 Collections \ubaa8\ub378\ub85c Couchbase \ub370\uc774\ud130\ub97c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud574\uc57c \ud569\ub2c8\ub2e4. \ub2e4\ud589\ud788\ub3c4 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc740 5\ub2e8\uacc4\uc758 \uac04\ub2e8\ud55c \uacfc\uc815\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9d1\ub2c8\ub2e4.<\/p>\n

\ubc94\uc704 \ubc0f \uceec\ub809\uc158\uc5d0 \ub300\ud55c \uac80\ud1a0\ubd80\ud130 \uc2dc\uc791\ud558\uaca0\uc2b5\ub2c8\ub2e4. (\ub610\ub294 \uc900\ube44\uac00 \ub418\uc5c8\ub2e4\uba74 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uac00\uc774\ub4dc\ub85c \ubc14\ub85c \uac74\ub108\ub6f0\uc138\uc694.<\/a>.)<\/p>\n

\uc7a0\uae50\ub9cc\uc694, \ubc94\uc704 \ubc0f \uceec\ub809\uc158\uc774\ub780 \ubb34\uc5c7\uc778\uac00\uc694?<\/h2>\n

\ubc94\uc704\ub294 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4(RDBMS)\uc758 \uc2a4\ud0a4\ub9c8\uc5d0 \ud574\ub2f9\ud569\ub2c8\ub2e4. Couchbase \uceec\ub809\uc158\uc744 \uc704\ud55c \ub17c\ub9ac\uc801 \ucee8\ud14c\uc774\ub108\uc785\ub2c8\ub2e4. \ubaa8\ub4e0 Couchbase \ubc84\ud0b7\uc5d0\ub294 \uae30\ubcf8 Scope\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uae30\ubcf8 \ucee8\ud14c\uc774\ub108\ub97c \uc9c1\uc811 \uc0ac\uc6a9\ud558\uac70\ub098 \uc9c1\uc811 \uc815\uc758\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\uceec\ub809\uc158\uc740 RDBMS\uc758 \ud14c\uc774\ube14\uacfc \uc720\uc0ac\ud569\ub2c8\ub2e4. \ubaa8\ub4e0 \ubc94\uc704\uc5d0\ub294 \uae30\ubcf8 \uceec\ub809\uc158\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uceec\ub809\uc158 can<\/em> \ub97c \uc0ac\uc6a9\ud558\uc5ec \uc720\uc0ac\ud55c \uc720\ud615\uc758 \ub808\ucf54\ub4dc(\uc608: RDBMS \ud14c\uc774\ube14)\ub97c \uc800\uc7a5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4, \uceec\ub809\uc158\uc5d0 \uc800\uc7a5\ud560 \uc218 \uc788\ub294 \ud56d\ubaa9\uc5d0\ub294 \uc2a4\ud0a4\ub9c8 \uc81c\ud55c\uc774 \uc5c6\uc2b5\ub2c8\ub2e4.<\/strong>. \uc804\uc801\uc73c\ub85c \uadc0\ud558\uc5d0\uac8c \ub2ec\ub824 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\ub2e4\uc74c\uc740 \ub2e4\uc591\ud55c \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1c\ub150\uc774 \ub2e4\uc74c\uacfc \uac19\uc740 \uc0c8\ub85c\uc6b4 \uae30\ub2a5\uc5d0 \uc5b4\ub5bb\uac8c \ub9e4\ud551\ub418\ub294\uc9c0 \ubcf4\uc5ec\uc8fc\ub294 \uadf8\ub9bc\uc785\ub2c8\ub2e4. \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc11c\ubc84<\/a> 7.0:<\/p>\n

<\/div>\n

\"\"<\/p>\n

<\/div>\n

\ubcf4\uc2dc\ub2e4\uc2dc\ud53c, \uc774\uc81c \uad00\uacc4\ud615 \ub370\uc774\ud130\uc640 NoSQL \ub370\uc774\ud130 \ubaa8\ub378<\/a> \uc5d0\uc11c \ubc94\uc704 \ubc0f \uceec\ub809\uc158\uc744 \uc0ac\uc6a9\ud560 \ub54c \uce74\uc6b0\uce58\ubca0\uc774\uc2a4<\/a>.<\/p>\n

\ubc94\uc704 \ubc0f \uceec\ub809\uc158 \uc544\ub798\uc758 \uc2dc\uc2a4\ud15c \ud0a4 \uacf5\uac04<\/h3>\n\n\n\n\n\n\n\n
\ud0a4 \uc2a4\ud398\uc774\uc2a4<\/strong><\/td>\n\uc124\uba85<\/strong><\/td>\n<\/tr>\n
`system:all_scopes`<\/td>\n\uae30\ubcf8 \ubc94\uc704\uc640 \uac19\uc740 \uc2dc\uc2a4\ud15c \uac1d\uccb4\ub97c \ud3ec\ud568\ud55c \ubaa8\ub4e0 \ubc94\uc704\uc758 \ubaa9\ub85d\uc785\ub2c8\ub2e4.<\/td>\n<\/tr>\n
`system:scopes`<\/td>\n\uc2dc\uc2a4\ud15c \ubc94\uc704\ub97c \uc81c\uc678\ud55c \uc0ac\uc6a9 \uac00\ub2a5\ud55c \ubaa8\ub4e0 \ubc94\uc704<\/td>\n<\/tr>\n
`system:all_collections`<\/td>\n\uae30\ubcf8 \uceec\ub809\uc158\uacfc \uac19\uc740 \uc2dc\uc2a4\ud15c \uac1c\uccb4\ub97c \ud3ec\ud568\ud55c \ubaa8\ub4e0 \uceec\ub809\uc158\uc758 \ubaa9\ub85d\uc785\ub2c8\ub2e4.<\/td>\n<\/tr>\n
`system:collections`<\/td>\n\uc2dc\uc2a4\ud15c \uceec\ub809\uc158\uc744 \uc81c\uc678\ud55c \uc0ac\uc6a9 \uac00\ub2a5\ud55c \ubaa8\ub4e0 \uceec\ub809\uc158<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/div>\n

\ubc94\uc704 \ubc0f \uceec\ub809\uc158\uc73c\ub85c N1QL \ucffc\ub9ac\ub97c \uac04\uc18c\ud654\ud558\ub294 \ubc29\ubc95<\/h2>\n

One major consequence of Scopes and Collections is that the N1QL query language is now simpler. This is because a `type` field is no longer required on every document. As a result, both the Data Definition Language (DDL) and Data Manipulation Language (DML) of N1QL statements are easier to write and understand.<\/p>\n

\uc774\uc81c \ub354 \uac04\ub2e8\ud558\uace0 \uc9c1\uad00\uc801\uc778 N1QL \ucffc\ub9ac<\/h3>\n

\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uceec\ub809\uc158\uc740 \uad00\uacc4\ud615 \ud14c\uc774\ube14\uacfc \ub3d9\ub4f1\ud55c \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc720\uc0ac\uc131\uc758 \uac15\uc810\uc740 \uc57d\uc810 \uc5c6\uc774 \ub17c\ub9ac\uc801 \ud14c\uc774\ube14\uacfc \uad00\uacc4\ud615 \ud14c\uc774\ube14 \uc0ac\uc774\uc758 \uac04\uadf9\uc744 \uba54\uc6cc\uc90d\ub2c8\ub2e4. \ubb3c\ub9ac\uc801 \ub370\uc774\ud130 \ubaa8\ub378<\/a> \ub9ce\uc740 RDBMS\uac00 \uc775\uc219\ud574\uc838 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

Take a look at these side-by-side N1QL queries below using the `travel-sample` dataset.<\/p>\n\n\n\n\n
\ubc84\ud0b7 \ubaa8\ub378<\/strong><\/td>\n\uceec\ub809\uc158 \ubaa8\ub378<\/strong><\/td>\n<\/tr>\n
\n
SELECT a.name\r\n  FROM `travel-sample` a\r\nWHERE a.type='airport'\r\n   AND a.city='London'\r\n<\/pre>\n
 <\/td>\n
\n
SELECT a.name\r\n FROM \uacf5\ud56d a\r\nWHERE a.city='London'\r\n<\/pre>\n
 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/div>\n
The query on the left jumps illustrates how you had to specify the document `type` field under the old Bucket model. The query on the right is simpler because the document `type` is no longer required under the new Collection model introduced in Couchbase 7.0.<\/p>\n
N1QL \uc870\uc778 \uc870\uac74\ub3c4 \ub354 \uac04\ub2e8\ud574\uc84c\uc2b5\ub2c8\ub2e4.<\/h3>\n
N1QL\uc758 \uc870\uc778\ub3c4 \ub354 \uc26c\uc6cc\uc84c\uc2b5\ub2c8\ub2e4. \uc544\ub798\uc5d0\uc11c \uc774\uc804 \ucffc\ub9ac\uc640 \uc0c8 \ucffc\ub9ac\ub97c \ube44\uad50\ud574 \ubcf4\uc138\uc694.<\/p>\n\n\n\n\n
\ubc84\ud0b7 \ubaa8\ub378<\/strong><\/td>\n\uceec\ub809\uc158 \ubaa8\ub378<\/strong><\/td>\n<\/tr>\n
\n
SELECT h.name,\r\n       a.faa\r\n FROM `travel-sample` h\r\n   JOIN `travel-sample` a\r\n      ON h.city=a.city AND a.type='airport'\r\n WHERE h.type='hotel'\r\n   AND a.city='London'\r\n<\/pre>\n
 <\/td>\n
\n
SELECT h.name,\r\n       a.faa\r\n FROM \ud638\ud154 h\r\n   JOIN \uacf5\ud56d a\r\n     ON h.city=a.city\r\n WHERE a.city='London'\r\n<\/pre>\n
 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/div>\n
Under the new Collection model, the JOIN syntax doesn’t require you to use the `type` field to restrict your query to a specific table of documents within the Bucket.<\/p>\n
\ubc84\ud0b7 \ubaa8\ub378\uacfc\uc758 \ud558\uc704 \ud638\ud658\uc131\uc744 \uc720\uc9c0\ud558\ub294 N1QL \ucffc\ub9ac<\/h3>\n
\uc0c8\ub85c\uc6b4 \uceec\ub809\uc158 \ubaa8\ub378\uc758 \ub3c4\uc785\uc774 \ubc84\ud0b7\uc758 \uc885\ub9d0\uc744 \uc758\ubbf8\ud558\uc9c0\ub294 \uc54a\uc2b5\ub2c8\ub2e4. N1QL \ucffc\ub9ac \uc11c\ube44\uc2a4\ub294 \uc774\uc804\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c \uc5ec\uc804\ud788 \ubc84\ud0b7 \ubaa8\ub378\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4.<\/p>\n
\uc720\uc77c\ud55c \ubcc0\uacbd \uc0ac\ud56d\uc740 \uc774\uc81c \ubc84\ud0b7 \ub370\uc774\ud130\uac00 \uae30\ubcf8 \uceec\ub809\uc158\uc744 \ud3ec\ud568\ud558\ub294 \uae30\ubcf8 \ubc94\uc704\uc5d0 \uc800\uc7a5\ub41c\ub2e4\ub294 \uc810\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n\n
\ubc84\ud0b7 \ubaa8\ub378<\/strong><\/td>\n\uceec\ub809\uc158 \ubaa8\ub378<\/strong><\/td>\n<\/tr>\n
\n
SELECT a.faa\r\n FROM `travel-sample` a\r\nWHERE a.type='airport'\r\n<\/pre>\n
 <\/td>\n
\ub458 \uc911 \ud558\ub098\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n
SELECT a.faa\r\nFROM `travel-sample`\r\nWHERE a.type='airport'\r\n<\/pre>\n
 <\/p>\n
\ub610\ub294<\/em><\/p>\n
SELECT a.faa\r\nFROM \uae30\ubcf8\uac12:`\uc5ec\ud589 \uc0d8\ud50c`._\uae30\ubcf8\uac12._\uae30\ubcf8\uac12 a\r\nWHERE a.type='airport'\r\n<\/pre>\n
 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/div>\n
\ub2e4\uc74c \uc0ac\ud56d\uc5d0 \uc720\uc758\ud558\uc138\uc694. \ub124\uc784\uc2a4\ud398\uc774\uc2a4 \uc811\ub450\uc0ac\ub294 \ud544\uc218\uc785\ub2c8\ub2e4.<\/strong> and should have the value `default:` for all references to the default Scope or default Collection.<\/p>\n
\uceec\ub809\uc158\uc744 \uc0ac\uc6a9\ud55c N1QL \ucffc\ub9ac\uc758 \uc911\uc694\ud55c \ubcc0\uacbd \uc0ac\ud56d<\/h2>\n
\uceec\ub809\uc158 \ubaa8\ub378 \uc0ac\uc6a9, \ucffc\ub9ac \uc5d4\uc9c4\uc740 \uceec\ub809\uc158 \uc774\ub984\uc758 \uc804\uccb4 \uacbd\ub85c\ub97c \uc54c\uace0 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/strong>. \uc774\ub294 \uceec\ub809\uc158 \uc774\ub984\uc774 \ubc84\ud0b7 \ub0b4\uc5d0\uc11c \uace0\uc720\ud560 \ud544\uc694\ub294 \uc5c6\uace0 \ud574\ub2f9 \ubc94\uc704 \ub0b4\uc5d0\uc11c\ub9cc \uace0\uc720\ud560 \uc218 \uc788\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/p>\n
\uc815\uaddc\ud654\ub41c \uceec\ub809\uc158 \uc774\ub984\uc758 \ud615\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n
\ud615\uc2dd:<\/p>\n
\ub124\uc784\uc2a4\ud398\uc774\uc2a4:bucket.scope.collection<\/pre>\n
\uc608\uc2dc:<\/p>\n
\ub124\uc784\uc2a4\ud398\uc774\uc2a4:`\uc5ec\ud589 \uc0d8\ud50c`.booking.hotel<\/pre>\n
However, you can reference a Collection with its relative path by setting the `query_context`<\/p>\n
\uadf8\ub9ac\uace0 \ucffc\ub9ac \uc6cc\ud06c\ubca4\uce58 UI<\/strong> \ub97c \ud074\ub9ad\ud558\uba74 \uc544\ub798 \uc2a4\ud06c\ub9b0\uc0f7\uc758 \uc624\ub978\ucabd \uc0c1\ub2e8\uc5d0 \uc788\ub294 \ub4dc\ub86d\ub2e4\uc6b4 \uc0c1\uc790\uc5d0\uc11c \ubc84\ud0b7\uacfc \ubc94\uc704\ub97c \uc120\ud0dd\ud558\uc5ec \ucffc\ub9ac \ucee8\ud14d\uc2a4\ud2b8\ub97c \uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
<\/div>\n
\"\"<\/p>\n
<\/div>\n
\ucffc\ub9ac \ucee8\ud14d\uc2a4\ud2b8\ub294 \ub2e4\uc74c\uc5d0\uc11c\ub3c4 \uc9c0\uc6d0\ub429\ub2c8\ub2e4. \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 SDK<\/a>, REST API<\/a> \uadf8\ub9ac\uace0 cbq \uc258<\/a>.<\/p>\n
\uceec\ub809\uc158\uc73c\ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud574\uc57c \ud558\ub098\uc694?<\/h2>\n
\uc544\ub2c8\uc694, \uc6d0\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0 \uceec\ub809\uc158 \ubaa8\ub378\ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud560 \ud544\uc694\ub294 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n
\ub9c8\uc774\uadf8\ub808\uc774\uc158\ud558\uc9c0 \uc54a\uae30\ub85c \uc120\ud0dd\ud55c \uacbd\uc6b0 \uadf8\ub300\ub85c \uc720\uc9c0\ub418\ub294 \uc0ac\ud56d\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n