{"id":2171,"date":"2026-04-30T01:47:22","date_gmt":"2026-04-30T08:47:22","guid":{"rendered":"https:\/\/www.couchbase.com\/com-2026\/products-n1ql\/"},"modified":"2026-10-16T16:03:00","modified_gmt":"2026-10-16T23:03:00","slug":"products-n1ql","status":"publish","type":"page","link":"https:\/\/www.couchbase.com\/ja\/products\/n1ql\/","title":{"rendered":"\u30a8\u30b9\u30ad\u30e5\u30fc\u30a8\u30eb\u30d7\u30e9\u30b9\u30d7\u30e9\u30b9"},"content":{"rendered":"
\n
\n
\n

SQL++\uff1aJSON\u306e\u305f\u3081\u306eANSI SQL<\/h1>\n\n\n\n

SQL++\u306f\u3001\u69cb\u9020\u5316\u30af\u30a8\u30ea\u8a00\u8a9e\uff08SQL\uff09\u3068JavaScript Object Notation\uff08JSON\uff09\u306e\u67d4\u8edf\u6027\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u3001Couchbase\u306e\u5f37\u529b\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a00\u8a9e\u3067\u3059\u3002American National Standards Institute\uff08ANSI\uff09\u306e\u69cb\u6587\u30ac\u30a4\u30c9\u30e9\u30a4\u30f3\u306b\u6e96\u62e0\u3057\u3001\u958b\u767a\u8005\u5411\u3051\u306b\u8a2d\u8a08\u3055\u308c\u305fSQL++\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u65e2\u5b58\u306e\u30b9\u30ad\u30eb\u3092\u6d3b\u7528\u3057\u3066\u3001\u30b9\u30d4\u30fc\u30c9\u3001\u4e00\u8cab\u6027\u3001\u52b9\u7387\u6027\u3092\u5099\u3048\u305f\u6700\u65b0\u306e\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u69cb\u7bc9\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

\n
\u7121\u6599\u3067\u59cb\u3081\u308b<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\n

Couchbase\u3067\u5f37\u529b\u306aSQL\u3092\u4f7f\u7528\u3059\u308b<\/h2>\n\n\n\n

\u30a8\u30b9\u30ad\u30e5\u30fc\u30a8\u30eb\u30d7\u30e9\u30b9\u30d7\u30e9\u30b9<\/a> \u306f\u3001\u696d\u754c\u6a19\u6e96\u306eANSI\u69cb\u6587\u3092\u6301\u3064JSON\u7528\u306eSQL\u3067\u3059\u3002SQL++\u306f\u3001ACID\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u3001\u30b9\u30b3\u30fc\u30d7\u3068\u547c\u3070\u308c\u308b\u968e\u5c64\u30b9\u30ad\u30fc\u30de\u3001\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u9593\u306e\u7d50\u5408\u306a\u3069\u306e\u4e00\u822c\u7684\u306a\u6982\u5ff5\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u307e\u3059\u3002\u307e\u305f\u3001\u7279\u8a31\u53d6\u5f97\u6e08\u307f\u306e\u30b3\u30b9\u30c8\u30d9\u30fc\u30b9\u306e\u6700\u9069\u5316\u3082\u5229\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n<\/section>\n\n\n\n

\n
\n
<\/path><\/svg><\/div>\n\n\n

\u30b3\u30b9\u30c8\u52b9\u7387<\/h2>\n\n\n\n

\u65b0\u3057\u3044\u8a00\u8a9e\u3078\u306e\u30af\u30a8\u30ea\u306e\u5909\u66f4\u306f\u30b3\u30b9\u30c8\u304c\u304b\u304b\u308a\u307e\u3059\u3002SQL++\u306fANSI 92\u6a19\u6e96\u306b\u6e96\u62e0\u3057\u3066\u304a\u308a\u3001SQL\u306eCouchbase\u3078\u306e\u79fb\u884c\u304c\u3088\u308a\u901f\u304f\u7c21\u5358\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n

\n
\u79fb\u4f4f\u306e\u30d2\u30f3\u30c8<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
<\/svg><\/div>\n\n\n

\u901f\u3044<\/h2>\n\n\n\n

\u30af\u30a8\u30ea\u306e\u8a18\u8ff0\u306f\u8907\u96d1\u3067\u3001\u9593\u9055\u3063\u305f\u65b9\u6cd5\u3067\u5b9f\u884c\u3059\u308b\u3068\u4f4e\u901f\u306b\u306a\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\u5f53\u793e\u306e\u30b3\u30b9\u30c8\u30fb\u30d9\u30fc\u30b9\u30fb\u30aa\u30d7\u30c6\u30a3\u30de\u30a4\u30b6\u30fc\uff08CBO\uff09\u306f\u6700\u9ad8\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3092\u4fdd\u8a3c\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

\n
\u3082\u3063\u3068\u901f\u304f<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
<\/path><\/svg><\/div>\n\n\n

\u4e00\u8cab\u6027<\/h2>\n\n\n\n

\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u8907\u6570\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u30c7\u30fc\u30bf\u306e\u4e0d\u6574\u5408\u304c\u767a\u751f\u3057\u307e\u3059\u3002Couchbase\u306f\u3001\u5358\u4e00\u306e\u30de\u30eb\u30c1\u30e2\u30c7\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u3059\u3079\u3066\u306e\u30e6\u30fc\u30b9\u30b1\u30fc\u30b9\u3092\u30b5\u30dd\u30fc\u30c8\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

\n
\u3055\u3089\u306b\u8a73\u3057\u304f<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
<\/svg><\/div>\n\n\n

\u304a\u99b4\u67d3\u307f<\/h2>\n\n\n\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7528\u306e\u65b0\u3057\u3044\u72ec\u81ea\u306e\u30af\u30a8\u30ea\u8a00\u8a9e\u3092\u7fd2\u5f97\u3059\u308b\u3053\u3068\u306f\u56f0\u96e3\u3067\u3059\u3002SQL++\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u958b\u767a\u8005\u306fANSI SQL\u306e\u65e2\u5b58\u306e\u30b9\u30ad\u30eb\u3092JSON\u306b\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

\n
\u304a\u5ba2\u69d8\u306e\u58f0<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/section>\n\n\n\n
\n
\n
\"\"<\/figure>\n<\/div>\n\n\n\n
\n
\n
\n

\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8<\/p>\n\n\n\n

Learn the fundamentals of SQL queries for JSON<\/h2>\n<\/div>\n\n\n\n
\n
\n
Read documentation<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\n

SQL++\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a00\u8a9e\u306e\u4e3b\u306a\u6a5f\u80fd<\/h2>\n\n\n\n

SQL++\u306f\u3001\u91cd\u8981\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u30b5\u30dd\u30fc\u30c8\u3059\u308b\u305f\u3081\u306b\u3001\u30c7\u30fc\u30bf\u3092\u64cd\u4f5c\u3057\u3001\u3088\u308a\u9ad8\u901f\u306a\u30af\u30a8\u30ea\u3092\u958b\u767a\u3059\u308b\u305f\u3081\u306e\u5f37\u529b\u306a\u65b9\u6cd5\u3092\u30c1\u30fc\u30e0\u306b\u63d0\u4f9b\u3057\u307e\u3059\u3002<\/p>\n<\/section>\n\n\n\n

\n
\n
\n
<\/svg><\/div>\n\n\n

\u30b0\u30ed\u30fc\u30d0\u30eb\u30fb\u30bb\u30ab\u30f3\u30c0\u30ea\u30fc\u30fb\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\uff08GSI\uff09<\/h2>\n\n\n\n

GSI\u306f\u3001\u5bfe\u8a71\u578b\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u305f\u3081\u306e\u4f4e\u30ec\u30a4\u30c6\u30f3\u30b7\u306e\u30af\u30a8\u30ea\u30fc\u3092\u53ef\u80fd\u306b\u3059\u308b\u3002GSI\u306f\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u30ec\u30d9\u30eb\u306e\u51e6\u7406\u3092\u30b5\u30dd\u30fc\u30c8\u3059\u308b\u3002
<\/p>\n\n\n\n

\n
\u3055\u3089\u306b\u8a73\u3057\u304f<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
<\/svg><\/div>\n\n\n

\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u9769\u65b0<\/h2>\n\n\n\n

Couchbase includes composite and array indexes and a function that identifies the best index for SQL queries.
<\/p>\n\n\n\n

\n
\u3055\u3089\u306b\u8a73\u3057\u304f<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
\n
<\/svg><\/div>\n\n\n

\u591a\u6b21\u5143\u30b9\u30b1\u30fc\u30ea\u30f3\u30b0\uff08MDS\uff09<\/h2>\n\n\n\n

MDS\u306f\u69d8\u3005\u306a\u30de\u30a4\u30af\u30ed\u30b5\u30fc\u30d3\u30b9\u306e\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u5206\u96e2\u3092\u5b9f\u73fe\u3059\u308b\u306e\u3067\u3001\u5fc5\u8981\u306a\u6642\u306b\u5fc5\u8981\u306a\u30b5\u30fc\u30d3\u30b9\u3092\u30b9\u30b1\u30fc\u30eb\u30a2\u30a6\u30c8\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

\n
\u3055\u3089\u306b\u8a73\u3057\u304f<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
\n
<\/path>\n <\/path><\/svg><\/div>\n\n\n

\u30d5\u30eb\u30c6\u30ad\u30b9\u30c8\u691c\u7d22\uff08FTS\uff09<\/h2>\n\n\n\n

\u8a00\u8a9e\u3092\u610f\u8b58\u3057\u305f\u30c6\u30ad\u30b9\u30c8\u691c\u7d22\u3092\u5185\u8535\u3057\u3066\u3044\u308b\u305f\u3081\u3001\u30e6\u30fc\u30b6\u30fc\u306f\u30b9\u30b3\u30a2\u30ea\u30f3\u30b0\u306b\u57fa\u3065\u3044\u3066\u6700\u3082\u95a2\u9023\u6027\u306e\u9ad8\u3044\u6587\u66f8\u3092\u3059\u3070\u3084\u304f\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/section>\n\n\n\n

\n
\n

SQL++: JSON\u306e\u67d4\u8edf\u6027\u3092\u5099\u3048\u305fSQL\u30e9\u30a4\u30af\u306a\u30af\u30a8\u30ea<\/h2>\n\n\n\n

\u5305\u62ec\u7684\u3067\u5ba3\u8a00\u7684\u306aJSON\u30af\u30a8\u30ea\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a00\u8a9e\u3092\u4f7f\u7528\u3057\u3066\u3001\u9b45\u529b\u7684\u306a\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u7c21\u5358\u306b\u958b\u767a\u3067\u304d\u307e\u3059\u3002\u958b\u767a\u8005\u306f\u3001\u30b9\u30ad\u30fc\u30de\u30ec\u30b9JSON\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u30b9\u30c8\u30a2\u3092\u4f7f\u7528\u3057\u3066\u3001\u5909\u5316\u3059\u308b\u30d3\u30b8\u30cd\u30b9\u8981\u4ef6\u306b\u8fc5\u901f\u306b\u5bfe\u5fdc\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

\n
SQL++\u309210\u5206\u3067\u5b66\u3076<\/a><\/div>\n<\/div>\n<\/div>
\"\"<\/figure><\/div>\n<\/div>\n\n\n\n
\n
\"\"<\/figure>
\n

SQL\u30af\u30a8\u30ea\u306b\u671f\u5f85\u3055\u308c\u308b\u6a5f\u80fd\u3092\u5099\u3048\u305f\u59a5\u5354\u306e\u306a\u3044\u30af\u30a8\u30ea<\/h2>\n\n\n\n

SQL++\u306f\u3001\u30b5\u30d6\u30df\u30ea\u79d2\u306e\u30ec\u30a4\u30c6\u30f3\u30b7\u3067\u4f55\u767e\u4e07\u3082\u306e\u540c\u6642\u30a4\u30f3\u30bf\u30e9\u30af\u30b7\u30e7\u30f3\u3092\u30b5\u30dd\u30fc\u30c8\u3059\u308b\u305f\u3081\u306e\u7d44\u307f\u8fbc\u307f\u30aa\u30d7\u30c6\u30a3\u30de\u30a4\u30b6\u3068\u30a4\u30cd\u30fc\u30d6\u30e9\u3092\u5099\u3048\u305f\u9ad8\u6027\u80fdNoSQL\u30af\u30a8\u30ea\u8a00\u8a9e\u3067\u3059\u3002Couchbase\u306e\u591a\u6b21\u5143\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\u306f\u3001\u30af\u30a8\u30ea\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3001\u691c\u7d22\u3001\u304a\u3088\u3073\u5206\u6790\u30b5\u30fc\u30d3\u30b9\u5168\u4f53\u3067SQL++\u3092\u4f7f\u7528\u3057\u3001\u30c7\u30fc\u30bf\u5bb9\u91cf\u3092\u5f3e\u529b\u7684\u306b\u62e1\u5f35\u3057\u3001\u9ad8\u901f\u306a\u30af\u30a8\u30ea\u6027\u80fd\u3092\u5b9f\u73fe\u3059\u308b\u305f\u3081\u306b\u30d1\u30fc\u30c6\u30a3\u30b7\u30e7\u30cb\u30f3\u30b0\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n

\n
SQL++\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8<\/a><\/div>\n<\/div>\n<\/div><\/div>\n<\/div>\n\n\n\n
\n
\n

\u4f7f\u3044\u6163\u308c\u305f\u30c4\u30fc\u30eb\u306b\u3088\u308a\u3001\u30af\u30a8\u30ea\u306e\u958b\u767a\u3068\u6700\u9069\u5316\u304c\u7c21\u5358\u306b\u884c\u3048\u307e\u3059\u3002
<\/h2>\n\n\n\n

SQL++\u306fQuery Workbench\u3092\u901a\u3057\u3066\u30a2\u30af\u30bb\u30b9\u3055\u308c\u3001\u30af\u30a8\u30ea\u3092\u6700\u9069\u5316\u3059\u308b\u305f\u3081\u306b\u5fc5\u8981\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u958b\u767a\u8005\u306b\u6559\u3048\u3066\u304f\u308c\u308b\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u30a2\u30c9\u30d0\u30a4\u30b9\u6a5f\u80fd\u304c\u7d44\u307f\u8fbc\u307e\u308c\u3066\u3044\u307e\u3059\u3002Flex Index\u306f\u8907\u96d1\u306a\u30af\u30a8\u30ea\u8ff0\u8a9e\u306e\u305f\u3081\u306bFull-Text Search Service\u306e\u8ee2\u7f6e\u691c\u7d22\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4f7f\u7528\u3059\u308b\u3002Couchbase\u306f\u307e\u305f\u3001\u30b3\u30b9\u30c8\u30d9\u30fc\u30b9\u306e\u30aa\u30d7\u30c6\u30a3\u30de\u30a4\u30b6\u3068\u7d50\u679c\u306e\u30c7\u30fc\u30bf\u3092\u64cd\u4f5c\u3059\u308b\u305f\u3081\u306eJavaScript\u30d9\u30fc\u30b9\u306e\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u95a2\u6570\u3092\u542b\u3080\u3002<\/p>\n\n\n\n