{"id":2347,"date":"2016-07-22T22:29:17","date_gmt":"2016-07-22T22:29:16","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=2347"},"modified":"2024-09-12T02:27:09","modified_gmt":"2024-09-12T09:27:09","slug":"modelling-the-taxlot-process-with-n1ql","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/modelling-the-taxlot-process-with-n1ql\/","title":{"rendered":"N1QL\uc5d0\uc11c \uc138\ubd84\ud654\uad6c \ub9e4\uce6d \ud504\ub85c\uc138\uc2a4 \ubaa8\ub378\ub9c1\ud558\uae30"},"content":{"rendered":"<h2><strong>\uc774 \uc870\ud56d\uc758 \ubaa9\uc801<\/strong><\/h2>\n<p>\uc774 \ubb38\uc11c\uc5d0\uc11c\ub294 \uacfc\uc138 \uc9c0\ubc88 \ub9e4\uce6d \ud504\ub85c\uc138\uc2a4\ub97c \ubaa8\ub378\ub9c1\ud558\uace0 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc5d0\uc11c \uc2e4\ud589\ud558\ub294 \ubc29\ubc95\uc744 \uc5f4\uac70\ud569\ub2c8\ub2e4. \ub370\uc774\ud130 \ubaa8\ub378 \uc790\uccb4\ub294 \uc8fc\uad00\uc801\uc778 \uac83\uc774\uc9c0\ub9cc, \uc774 \ubb38\uc11c\uc5d0\uc11c\ub294 \ubaa8\ub378\uacfc \uad00\ub828\ub41c \uc8fc\uc694 \uc5d4\ud130\ud2f0\uc640 \uacfc\uc138 \uc9c0\ubc88 \uc77c\uce58 \ud504\ub85c\uc138\uc2a4\ub97c \uc2e4\ud589\ud558\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 N1QL \ucffc\ub9ac\ub9cc \ub098\uc5f4\ud560 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc194\ub8e8\uc158\uc744 \uc0b4\ud3b4\ubcf4\uae30 \uc804\uc5d0 \ub3c5\uc790\ub4e4\uc774 SQL\uacfc \ub9e4\uc6b0 \uc720\uc0ac\ud558\uc9c0\ub9cc \uba87 \uac00\uc9c0 \ucd94\uac00 JSON \uad00\ub828 \uae30\ub2a5\uc774 \uc788\ub294 N1QL\uc758 \uc77c\ubd80 \uad6c\uc870\uc5d0 \uc775\uc219\ud574\uc9c0\uac70\ub098 \uc5b8\uc820\uac00 \ud22c\uc790\ud560 \uc758\ud5a5\uc774 \uc788\ub2e4\uace0 \uac00\uc815\ud569\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\ubc30\uc5f4\uc5d0 \ub300\ud574 NEST \uc808\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud589\uc744 \uc5f4\ub85c \ubc14\uafc0 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li>UNNEST\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubc30\uc5f4\uc744 \ud589\uc73c\ub85c \ubd84\ud574\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p>JSON \ubb38\uc11c\uc640 N1QL\uc740 \uae30\ub2a5\uc774 \ub9e4\uc6b0 \ud48d\ubd80\ud558\ubbc0\ub85c \uad6c\ubb38\uc5d0 \ub300\ud55c \uac04\ub2e8\ud55c \uc785\ubb38\uc11c\ub97c \uc791\uc131\ud558\ub294 \uac83\uc774 \ub9e4\uc6b0 \uc720\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n<p><a href=\"https:\/\/learn.couchbase.com\/store\/\">https:\/\/learn.couchbase.com\/store\/<\/a><\/p>\n<p><a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/4.1\/n1ql\/n1ql-language-reference\/index.html\">https:\/\/developer.couchbase.com\/documentation\/server\/4.1\/n1ql\/n1ql-language-reference\/index.html<\/a><\/p>\n<h2><strong>\uacfc\uc138 \uad6c\uc5ed\uc774\ub780 \ubb34\uc5c7\uc778\uac00\uc694? <\/strong><\/h2>\n<p>A\u00a0<strong>\uc138\uae08 \ub85c\ud2b8<\/strong>\u00a0\ub294 \ud3ec\ud2b8\ud3f4\ub9ac\uc624\uc5d0\uc11c \uac1c\uc2dc\ub41c \uac70\ub798(\uc608: \ub9e4\uc218 \ub610\ub294 \uacf5\ub9e4\ub3c4)\uc758 \uae30\ub85d\uc785\ub2c8\ub2e4. \uc8fc\ubb38\uc774 \uc5ec\ub7ec \uc870\uac01\uc73c\ub85c \uccb4\uacb0\ub418\ub294 \uacbd\uc6b0 \uc774\ub97c \ubd80\ubd84 \uccb4\uacb0\uc774\ub77c\uace0 \ud558\uba70, \uac00\uaca9\uc740 \ud3c9\uade0\ud654\ub418\uc5b4 \ub2e8\uc77c \ud638\uac00\ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4.\u00a0<strong>\uc138\uae08 \ub85c\ud2b8<\/strong>\u00a0\ubc88\ud638\uc785\ub2c8\ub2e4. \uc5ec\ub7ec \uac1c\uc758\u00a0<strong>\uc138\uae08 \ub85c\ud2b8<\/strong>\u00a0\ubcf4\uc548 \ubc0f \uc804\ubc18\uc801\uc778 \uc704\uce58 \ub0b4\uc5d0\uc11c.<\/p>\n<p>\uc720\uac00\uc99d\uad8c\uc744 \uad6c\ub9e4\ud560 \ub54c\ub9c8\ub2e4 \uc0c8 \ud3ec\uc9c0\uc158\uc740 \ubcc4\uac1c\uc758 \ubcc4\uac1c\uc758 \ud3ec\uc9c0\uc158\uc785\ub2c8\ub2e4.\u00a0<em>\uc138\uae08 \ub85c\ud2b8<\/em>\u00a0- \ub3d9\uc77c\ud55c \uc99d\uad8c\uc758 \uc8fc\uc2dd\uc744 \uc774\ubbf8 \uc18c\uc720\ud558\uace0 \uc788\ub294 \uacbd\uc6b0\uc5d0\ub3c4 \ub9c8\ucc2c\uac00\uc9c0\uc785\ub2c8\ub2e4. (\uc138\uae08 \ub85c\ud2b8\ub294 \ub9e4\uc785 \ub0a0\uc9dc \ubc0f \uc8fc\uc2dd \uc218\ub97c \ud3ec\ud568\ud558\uc5ec \uac70\ub798\uc640 \uc138\uae08\uc5d0 \ubbf8\uce58\ub294 \uc601\ud5a5\uc744 \uae30\ub85d\ud55c \uae30\ub85d\uc785\ub2c8\ub2e4.)\u00a0<\/p>\n<p>A\u00a0<em>\uc138\uae08\uc6a9\uc9c0 \uc2dd\ubcc4 \ubc29\ubc95<\/em>\u00a0\ub294 \uc11c\ub85c \ub2e4\ub978 \ub0a0\uc9dc\uc5d0 \uc11c\ub85c \ub2e4\ub978 \uac00\uaca9\uc73c\ub85c \uc5ec\ub7ec \ubc88 \ub9e4\uc218\ud55c \ud3ec\uc9c0\uc158\uc774 \uc788\uace0 \ud3ec\uc9c0\uc158\uc758 \uc77c\ubd80\ub9cc \ub9e4\ub3c4\ud558\ub294 \uac70\ub798\ub97c \uccb4\uacb0\ud558\ub294 \uacbd\uc6b0 \ub9e4\ub3c4\ud560 \uc138\uae08 \ub78f\uc744 \uacb0\uc815\ud558\ub294 \ubc29\uc2dd\uc785\ub2c8\ub2e4. \ub2f9\uc0ac\ub294 \ubc95\uc5d0 \ub530\ub77c \uc774 \uc815\ubcf4\ub97c \ucd94\uc801 \ubc0f \uad00\ub9ac\ud558\uace0 \uc6d0\uac00 \uae30\uc900\uacfc \uc218\uc775\uae08\uc744 \uadc0\ud558\uc640 \uad6d\uc138\uccad\uc5d0 \ubcf4\uace0\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<p>\uc120\ud0dd\ud55c \uc138\uae08\uc6a9\uc9c0 ID \ubc29\ubc95\uc740 \uc790\uc0b0\uc744 \ud310\ub9e4\ud560 \ub54c \ub0a9\ubd80\ud560 \uc138\uae08 \uae08\uc561\uc5d0 \uc0c1\ub2f9\ud55c \uc601\ud5a5\uc744 \ubbf8\uce60 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h2><strong>\uacfc\uc138 \uc9c0\ubc88 \ub9e4\uce6d \ubc29\ubc95\ub860<\/strong><\/h2>\n<p>\uc774 \ubb38\uc11c\uc5d0 \ud45c\uc2dc\ub418\ub294 \ucffc\ub9ac\uc5d0\ub294 \uac00\uc7a5 \ub9ce\uc774 \uc0ac\uc6a9\ub418\ub294 \ubc29\ubc95\ub860\uc778 FIFO \ubc29\ubc95\ub9cc \ud45c\uc2dc\ub418\uc9c0\ub9cc \ubc29\ubc95\ub860\uc740 \ubaa8\ub450 \ub3d9\uc77c\ud558\uac8c \ub098\uc5f4\ud569\ub2c8\ub2e4.<\/p>\n<p>\u00a0<\/p>\n<p><strong>FIFO(\uc120\uc785\uc120\ucd9c)<\/strong><\/p>\n<ol>\n<li>\uc138\uae08 \ub78f\uc744 \uc77c\uce58\uc2dc\ud0a4\ub294 \uae30\ubcf8 \ubc29\ubc95\uc785\ub2c8\ub2e4. \ud310\ub9e4\ub294 \uac00\uc7a5 \ube60\ub978 \uad6c\ub9e4\uc640 \uc21c\ucc28\uc801\uc73c\ub85c \uc9dd\uc744 \uc774\ub8f9\ub2c8\ub2e4. FIFO\ub294 \uc7ac\uace0\uc5d0 \ub0a8\uc544\uc788\ub294 \uc790\uc0b0\uc774 \uac00\uc7a5 \ucd5c\uadfc\uc5d0 \uad6c\ub9e4\ud558\uac70\ub098 \uc0dd\uc0b0\ud55c \uc790\uc0b0\uacfc \uc77c\uce58\ud55c\ub2e4\uace0 \uac00\uc815\ud569\ub2c8\ub2e4. \uc120\ubb3c \ubc0f \uc120\ubb3c \uc635\uc158\uc5d0\ub294 \ud56d\uc0c1 FIFO\uac00 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p>\u00a0<\/p>\n<p><strong>LIFO(\ub77c\uc2a4\ud2b8 \uc778, \ud37c\uc2a4\ud2b8 \uc544\uc6c3)<\/strong><\/p>\n<ol>\n<li>\uac01 \ud310\ub9e4\ub294 \uac00\ub2a5\ud55c \uac00\uc7a5 \ucd5c\uadfc\uc758 \uad6c\ub9e4\uc640 \uc9dd\uc744 \uc774\ub8f9\ub2c8\ub2e4. LIFO\ub294 \ubc95\uc778\uc774 \ucd5c\uc2e0 \uc7ac\uace0\ub97c \uba3c\uc800 \ud310\ub9e4, \uc0ac\uc6a9 \ub610\ub294 \ucc98\ubd84\ud55c\ub2e4\uace0 \uac00\uc815\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p style=\"margin-left:.75in\">\u00a0<\/p>\n<p><strong>\uc7a5\uae30\uc801\uc778 \uc218\uc775 \uadf9\ub300\ud654<\/strong> - \ud310\ub9e4\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc6b0\uc120 \uc21c\uc704\uc5d0 \ub530\ub77c \uc30d\uc744 \uc774\ub8f9\ub2c8\ub2e4:<\/p>\n<p style=\"margin-left:.5in\">1. \uc7a5\uae30\uc801\uc778 \uc8fc\ub2f9 \uc218\uc775 \uadf9\ub300\ud654<\/p>\n<p style=\"margin-left:.5in\">2. \uc8fc\ub2f9 \ub2e8\uae30 \uc218\uc775 \uadf9\ub300\ud654<\/p>\n<p style=\"margin-left:.5in\">3. \ub2e8\uae30 \uc8fc\ub2f9 \uc190\uc2e4 \ucd5c\uc18c\ud654<\/p>\n<p style=\"margin-left:.5in\">4. \uc7a5\uae30\uc801\uc778 \uc8fc\ub2f9 \uc190\uc2e4 \ucd5c\uc18c\ud654<\/p>\n<p style=\"margin-left:.5in\">\u00a0<\/p>\n<p><strong>\uc7a5\uae30\uc801 \uc190\uc2e4 \uadf9\ub300\ud654<\/strong> - \ud310\ub9e4\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc6b0\uc120 \uc21c\uc704\uc5d0 \ub530\ub77c \uc30d\uc744 \uc774\ub8f9\ub2c8\ub2e4:<\/p>\n<p style=\"margin-left:.5in\">1. \uc7a5\uae30 \uc8fc\ub2f9 \uc190\uc2e4 \uadf9\ub300\ud654<\/p>\n<p style=\"margin-left:.5in\">2. \ub2e8\uae30 \uc8fc\ub2f9 \uc190\uc2e4 \uadf9\ub300\ud654<\/p>\n<p style=\"margin-left:.5in\">3. \uc8fc\ub2f9 \ub2e8\uae30 \uc774\uc775 \ucd5c\uc18c\ud654<\/p>\n<p style=\"margin-left:.5in\">4. \uc7a5\uae30\uc801\uc778 \uc8fc\ub2f9 \uc774\uc775 \ucd5c\uc18c\ud654<\/p>\n<p style=\"margin-left:.5in\">\u00a0<\/p>\n<p><strong>\ub2e8\uae30 \uc218\uc775 \uadf9\ub300\ud654<\/strong> - \ud310\ub9e4\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc6b0\uc120 \uc21c\uc704\uc5d0 \ub530\ub77c \uc30d\uc744 \uc774\ub8f9\ub2c8\ub2e4:<\/p>\n<p style=\"margin-left:.5in\">1. \uc8fc\ub2f9 \ub2e8\uae30 \uc218\uc775 \uadf9\ub300\ud654<\/p>\n<p style=\"margin-left:.5in\">2. \uc7a5\uae30\uc801\uc778 \uc8fc\ub2f9 \uc218\uc775 \uadf9\ub300\ud654<\/p>\n<p style=\"margin-left:.5in\">3. \uc7a5\uae30\uc801\uc778 \uc8fc\ub2f9 \uc190\uc2e4 \ucd5c\uc18c\ud654<\/p>\n<p style=\"margin-left:.5in\">4. \ub2e8\uae30 \uc8fc\ub2f9 \uc190\uc2e4 \ucd5c\uc18c\ud654<\/p>\n<p style=\"margin-left:.5in\">\u00a0<\/p>\n<p><strong>\ub2e8\uae30 \uc190\uc2e4 \uadf9\ub300\ud654<\/strong> - \ud310\ub9e4\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc6b0\uc120 \uc21c\uc704\uc5d0 \ub530\ub77c \uc30d\uc744 \uc774\ub8f9\ub2c8\ub2e4:<\/p>\n<p style=\"margin-left:.5in\">1. \ub2e8\uae30 \uc8fc\ub2f9 \uc190\uc2e4 \ucd5c\ub300\ud654<\/p>\n<p style=\"margin-left:.5in\">2. \uc7a5\uae30 \uc8fc\ub2f9 \uc190\uc2e4 \uadf9\ub300\ud654<\/p>\n<p style=\"margin-left:.5in\">3. \uc7a5\uae30\uc801\uc778 \uc8fc\ub2f9 \uc774\uc775 \ucd5c\uc18c\ud654<\/p>\n<p style=\"margin-left:.5in\">4. \uc8fc\ub2f9 \ub2e8\uae30 \uc774\uc775 \ucd5c\uc18c\ud654<\/p>\n<p style=\"margin-left:.5in\">\u00a0<\/p>\n<p><strong>\ucd5c\uace0 \ube44\uc6a9<\/strong> - \uc218\uc775\uc744 \ucd5c\uc18c\ud654\ud558\uba74\uc11c \uc190\uc2e4\uc744 \ucd5c\ub300\ud654\ud569\ub2c8\ub2e4. \ud310\ub9e4\ub294 \uc30d\uc744 \uae30\uc900\uc73c\ub85c \ud569\ub2c8\ub2e4.<\/p>\n<p>\ub97c \ud074\ub9ad\ud558\uc138\uc694:<\/p>\n<ul>\n<li>\uba3c\uc800, \uccad\uc0b0 \uac70\ub798\ub97c \ubbf8\uccb4\uacb0 \ub78f\uc5d0 \ub9e4\uce6d\ud558\ub294 \ub370 \uac00\ub2a5\ud55c \ubaa8\ub4e0 \uc635\uc158\uc744 \uc0b4\ud3b4\ubd05\ub2c8\ub2e4.<\/li>\n<li>\uac00\ub2a5\ud55c \ub9e4\uce58\uac00 \uc190\uc2e4\ub85c \uc774\uc5b4\uc9c8 \uacbd\uc6b0, \uba54\uc11c\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \ub9e4\uce58\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p>\ub97c \uc0ac\uc6a9\ud558\uba74 \uac00\uc7a5 \ud070 \uc190\uc2e4\uc774 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/p>\n<ul>\n<li>\uac00\ub2a5\ud55c \uc77c\uce58\ud558\ub294 \ud56d\ubaa9\uc774 \uc5c6\uc5b4 \uc190\uc2e4\uc774 \ubc1c\uc0dd\ud560 \uacbd\uc6b0, \uba54\uc11c\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uacb0\uacfc\ub97c \uac00\uc838\uc624\ub294 \uc77c\uce58 \ud56d\ubaa9\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p>\uac00\ub2a5\ud55c \ucd5c\uc18c\ud55c\uc758 \uc774\ub4dd\uc744 \uc5bb\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\u00a0<\/p>\n<p><strong>\ud2b9\uc815 \ub85c\ud2b8<\/strong> - \ubaa8\ub4e0 \uc138\uae08 \ub78f\uacfc \ub9c8\uac10 \uac70\ub798\ub97c \ud655\uc778\ud55c \ub2e4\uc74c \uc218\ub3d9\uc73c\ub85c \ub78f\uc744 \uc77c\uce58\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc744 \uc0ac\uc6a9\ud558\uc5ec \uac70\ub798\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud2b9\uc815 \ub78f\uc740 \uc624\ub298 \ub610\ub294 \ud3ec\uc9c0\uc158\uc5d0 \ub300\ud574 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc9c0\ub9cc<\/p>\n<p>\uacc4\uc815 \uae30\ubcf8 \uc77c\uce58 \ubc29\ubc95.<\/p>\n<p><strong style=\"font-size: 1.5em;line-height: 1.2em\">\ub77c\uc774\ube0c \uc608\uc81c \uc0ac\uc6a9<\/strong><\/p>\n<p>\uc785\ub825\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<div>\n<h2><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/july\/modelling-the-taxlot-process-with-n1ql\/tax1.png\" \/><\/h2>\n<\/div>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\ube44\uc988\ub2c8\uc2a4 \uaddc\uce59\uc5d0 \ub530\ub974\uba74 \uc138\uae08\uc744 \ucd5c\uc18c\ud654\ud558\ub824\uba74 \uac01 \uac70\ub798\ub294 \ud604\uc7ac \uac70\ub798 \uc774\ud6c4\uc5d0 \ubc1c\uc0dd\ud558\ub294 \uac70\ub798\uc640 \ubc18\ub300 \uac70\ub798 \uc720\ud615(\uc608: B\ub294 \ub9e4\uc218\ub97c \uc758\ubbf8\ud558\uba70, \uc774 \uacbd\uc6b0 \ubc18\ub300 \uac70\ub798 \uc720\ud615\uc778 S \ub610\ub294 SELL)\uc758 \uac70\ub798\ub85c \uccad\uc0b0\ub418\uc5b4\uc57c \ud558\uba70, \uc218\ub7c9\uc740 \uccad\uc0b0\ub418\ub294 \uac70\ub798\ubcf4\ub2e4 \uac19\uac70\ub098 \ucee4\uc57c \ud558\uace0 \uccad\uc0b0\ub418\ub294 \uac70\ub798\uc758 \uac70\ub798 \ub0a0\uc9dc\ubcf4\ub2e4 \ud070 \uac70\ub798 \ub0a0\uc9dc\ub97c \uac00\uc838\uc57c \ud55c\ub2e4\uace0 \uba85\uc2dc\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h2><strong>\ud2b9\uc815 \uacfc\uc138 \uc9c0\ubc88 \ub9e4\uce6d\uc758 \uc5d4\ud2f0\ud2f0<\/strong><\/h2>\n<p>\uc5ec\ub7ec \uace0\uac1d, \uace0\uac1d\uc5d0\uac8c \uc11c\ube44\uc2a4\ub97c \uc81c\uacf5\ud558\ub294 \ud5e4\uc9c0\ud380\ub4dc, \uae08\uc735 \uc11c\ube44\uc2a4 \ud68c\uc0ac\uc5d0\uc11c \uc6b4\uc601\ud55c\ub2e4\uace0 \uac00\uc815\ud569\ub2c8\ub2e4. \ucea1\ucc98\ub41c #\uc758 \uc694\uc18c\ub294 \uc5ec\uae30\uc5d0 \ub098\uc5f4\ub41c \uac83\ubcf4\ub2e4 \ud6e8\uc52c \ub354 \ud3ec\uad04\uc801\uc774\uc9c0\ub9cc, \uc5ec\uae30\uc11c\ub294 \uc138\uae08 \ub85c\ud2b8 \ub9e4\uce6d \ud504\ub85c\uc138\uc2a4\uc5d0 \ucc38\uc5ec\ud558\ub294 \uac00\uc7a5 \uc911\uc694\ud55c \uc694\uc18c\ub9cc \ubcf4\uc5ec\ub4dc\ub9ac\ub824\uace0 \ud569\ub2c8\ub2e4. Couchbase\uc5d0\uc11c \uc774\ub97c \ubaa8\ub378\ub9c1\ud558\ub294 \ubc29\ubc95\uc740 \ub450 \uac00\uc9c0\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud558\ub294 \uacbd\uc6b0 \uc77c\ubd80 \ub370\uc774\ud130\ub97c \ube60\ub974\uac8c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud55c \ub2e4\uc74c \ube44\uc988\ub2c8\uc2a4 \ubaa8\ub378\ub9c1\uc744 \uc704\ud574 NoSQL\uc744 \uc801\uc6a9\ud558\ub824\ub294 \uacbd\uc6b0, \uac01 \uc5d4\ud130\ud2f0\uc5d0 \ub300\ud574 \ubb38\uc11c \uc720\ud615\uc744 \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4(\uc608: \ud2b8\ub808\uc774\ub354\uac00 \ud558\ub098\uc758 \uc5d4\ud130\ud2f0, \uc0c1\ud488\uc774 \ub2e4\ub978 \uc5d4\ud130\ud2f0\uac00 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4). \uadf8\ub9ac\uace0 \ubaa8\ub4e0 \ubb38\uc11c\uc5d0 \ubb38\uc11c \uc720\ud615\uc744 \ub098\ud0c0\ub0b4\ub294 \uc720\ud615 \uc694\uc18c\ub97c \ud3ec\ud568\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p>\u00a0<\/p>\n<p><strong>\uad00\uacc4\ud615 \ubaa8\ub378 \uc0d8\ud50c\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4,<\/strong><\/p>\n<p style=\"margin-left: 80px\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/july\/modelling-the-taxlot-process-with-n1ql\/taxlot-relational.png\" \/><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p><strong>\uc774\ub97c \uadf8\ub300\ub85c \ubc88\uc5ed\ud558\uc5ec \ubb38\uc11c \ubaa8\ub378\uc5d0 \uc801\uc6a9\ud558\uba74 \uc5d4\ud2f0\ud2f0\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/strong><\/p>\n<p>\u00a0<\/p>\n<p style=\"margin-left: 80px\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/july\/modelling-the-taxlot-process-with-n1ql\/taxlot-cb-relational.png\" \/><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p><strong>TaxLot \ub9e4\uce6d \ud504\ub85c\uc138\uc2a4\uac00 \uc2e4\uc81c\ub85c \ubc1c\uc0dd\ud558\ub294 TradeOrder \uc5d4\ud2f0\ud2f0\uc5d0 \ub300\ud55c \uc815\uaddc\ud654 \ud574\uc81c \ubaa8\ub378 \uc0d8\ud50c<\/strong><\/p>\n<p style=\"margin-left: 80px\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/july\/modelling-the-taxlot-process-with-n1ql\/tax2.png\" \/><\/p>\n<p>\n<strong>N1QL\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc138\uae08 \ub85c\ud2b8 \ud504\ub85c\uc138\uc2a4 \uc2e4\ud589<\/strong><\/p>\n<p>TaxLot \ub9e4\uce6d\uc5d0 FIFO \ubc29\uc2dd\uc744 \uc0ac\uc6a9\ud55c\ub2e4\uace0 \uac00\uc815\ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc774 \ud504\ub85c\uc138\uc2a4\ub294 \ubbf8\ub9ac \uc815\ud574\uc9c4 \uc21c\uc11c\uc5d0 \ub530\ub77c \ud589\uc744 \ubc18\ubcf5\ud558\uace0 \uacb0\uacfc \uc9d1\ud569\uc744 \uce90\uc2dc\ud574\uc57c \ud558\ubbc0\ub85c \ud568\uc218\ud615 \uc5b8\uc5b4\uc5d0 \ub9e4\uc6b0 \uc801\ud569\ud558\uc9c0\ub9cc, \uc5b8\uc5b4\uc758 \ud48d\ubd80\ud568\uacfc \ub2e4\uc591\uc131 \ub54c\ubb38\uc5d0 N1QL\uc5d0\uc11c \uc774\ub97c \uc2e4\ud589\ud558\ub294 \ubc29\ubc95\uc744 \uc5f4\uac70\ud558\uace0 \uc2f6\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub2e8\uacc4<\/p>\n<ol style=\"list-style-type:lower-alpha\">\n<li>\ub3c5\uc790\uac00 Couchbase\uc5d0 \uc775\uc219\ud558\uace0 \uad00\ub9ac\uc790 \ucf58\uc194\uc744 \ud0d0\uc0c9\ud560 \uc218 \uc788\ub2e4\uace0 \uac00\uc815\ud569\ub2c8\ub2e4.<\/li>\n<li>\ubc84\ud0b7\uc744 \uc0dd\uc131\ud558\uace0, Taxlot_Demo\ub77c\uace0 \ubd80\ub974\uaca0\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\ud544\uc694\ud55c \ubb38\uc11c\ub97c \uc791\uc131\ud558\uc5ec \uc88b\uc740 \ud14c\uc2a4\ud2b8\ubca0\ub4dc\ub97c \ud655\ubcf4\ud558\uc138\uc694.<\/li>\n<li>\uadf8\ub7f0 \ub2e4\uc74c \uc77c\uce58 \uc870\uac74 \uadf8\ub8f9\uc5d0 \ub300\ud55c \ubaa8\ub4e0 \uac70\ub798\uc758 \ubc30\uc5f4\uc744 \uc0dd\uc131\ud558\ub294 \uc784\uc2dc \ubc84\ud0b7\uc744 \ub9cc\ub4ed\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 \ud2b9\uc815 \ud380\ub4dc, \ud2b8\ub808\uc774\ub354, \ube0c\ub85c\ucee4, \uc804\ub7b5, \uc0c1\ud488, \ud2b8\ub808\uc774\ub529 \uc720\ud615\ub9cc \uc77c\uce58\uc2dc\ud0a4\uace0\uc790 \ud55c\ub2e4\uace0 \uac00\uc815\ud558\uba74 \uc774\uc804\uacfc \uc774\ud6c4\uc758 \uadf8\ub9bc\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p>\u00a0<\/p>\n<p style=\"margin-left: 80px\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/july\/modelling-the-taxlot-process-with-n1ql\/tax3.png\" \/><\/p>\n<p>\u00a0<\/p>\n<p style=\"margin-left: 80px\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/july\/modelling-the-taxlot-process-with-n1ql\/tax4.png\" \/><\/p>\n<p><span style=\"line-height: 1.6em\">5. \uadf8\ub7f0 \ub2e4\uc74c \ub2e8\uc77c \ucffc\ub9ac\uc5d0\uc11c \uc138\uae08 \ubc88\ud638 \uc77c\uce58 \ud56d\ubaa9\uc744 \uac00\uc838\uc635\ub2c8\ub2e4. \ucffc\ub9ac\uac00 \ub9ce\uc740 \uac83\uc744 \ub2ec\uc131\ud558\ubbc0\ub85c \uc774\ud574\ud558\uae30 \uc27d\ub3c4\ub85d \ub2e8\uacc4\ubcc4\ub85c \ub098\ub204\uace0 \ub9c8\uc9c0\ub9c9\uc5d0 \uc804\uccb4 \ucffc\ub9ac\ub97c \ub098\uc5f4\ud569\ub2c8\ub2e4. <\/span><strong style=\"line-height: 1.6em\"><em><u>\ub2e8\uacc4 e\ub294 Couchbase\uc5d0\uc11c Taxlot \ud504\ub85c\uc138\uc2a4\ub97c \uc2e4\ud589\ud558\ub294 \ub370 \ud544\uc694\ud55c \uc720\uc77c\ud55c \ucffc\ub9ac\uc774\uba70, \uc911\uac04 \uae00\uba38\ub9ac \uae30\ud638 a, b, c, d\ub294 \ub2e8\uacc4 e\uc758 \ub354 \ud070 \ucffc\ub9ac\ub97c \uc5f4\uac70\ud560 \ubfd0\uc785\ub2c8\ub2e4.<\/u><\/em><\/strong><\/p>\n<p>a.  f\ub2e8\uacc4\uc758 \uac00\uc7a5 \uc548\ucabd \ucffc\ub9ac\ub294 4\ub2e8\uacc4\uc758 \ud0a4\uc640 \uc77c\uce58\ud560 \uc218 \uc788\ub294 \uc5f0\uacb0\ub41c \uc5f4\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4. \u00a0<\/p>\n<p style=\"margin-left: 80px\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/july\/modelling-the-taxlot-process-with-n1ql\/tax5.png\" \/><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0b.  \ub2e4\uc74c\uc73c\ub85c 4\ub2e8\uacc4\uc5d0\uc11c \uc0dd\uc131\ud55c \uad6c\uccb4\ud654\ub41c \ud14c\uc774\ube14\uc5d0 \uc870\uc778\ud558\uba74 \uc774 \ucffc\ub9ac\uc758 \uacb0\uacfc\ub294 \uadf8\ub8f9\ud654 \uae30\uc900 \ub0b4\uc758 \uac01 \uac70\ub798\uc640 \uac00\ub2a5\ud55c \uc77c\uce58 \ud56d\ubaa9 \ubc30\uc5f4\uc774 \ub429\ub2c8\ub2e4.<\/p>\n<p>\u00a0<\/p>\n<p style=\"margin-left: 80px\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/july\/modelling-the-taxlot-process-with-n1ql\/tax6.png\" \/><\/p>\n<p>c. \uadf8\ub7f0 \ub2e4\uc74c \ubc30\uc5f4\uc758 \uc911\ucca9\uc744 \ud574\uc81c\ud558\uc5ec \uadf8\ub8f9 \ub0b4\uc758 \ubaa8\ub4e0 \ud589 \uac04\uc5d0 \ub2e4\ub300\ub2e4 \uad00\uacc4\ub97c \ub9cc\ub4ed\ub2c8\ub2e4. <strong><u>\ud380\ub4dc\uc544\uc774\ub514, \ud2b8\ub808\uc774\ub354\uc544\uc774\ub514, \ube0c\ub85c\ucee4\uc544\uc774\ub514, \uc804\ub7b5, \uc0c1\ud488\uc544\uc774\ub514, \ub871\uc20f\u00a0 <\/u><\/strong><\/p>\n<p style=\"margin-left: 80px\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/july\/modelling-the-taxlot-process-with-n1ql\/tax7.png\" \/><\/p>\n<p>\u00a0<\/p>\n<p>d. \uadf8\ub7f0 \ub2e4\uc74c \ube44\uc988\ub2c8\uc2a4 \uaddc\uce59\uc744 \uc801\uc6a9\ud558\uc5ec \ubc18\ub300\ucabd \uc11c\uba85 \uac70\ub798\ub97c \uac00\uc838\uc640 \uc138\uae08 \ub85c\ud2b8\uc640 \uc77c\uce58\ud558\ub294 \uac70\ub798\ub97c \ucc3e\uc2b5\ub2c8\ub2e4.<\/p>\n<p style=\"margin-left:1.0in\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/july\/modelling-the-taxlot-process-with-n1ql\/tax7.png\" \/><\/p>\n<p>\n<span style=\"line-height: 1.6em\">e.\u00a0<\/span><span style=\"line-height: 1.6em\">\uadf8\ub7f0 \ub2e4\uc74c \ub9c8\uc9c0\ub9c9\uc73c\ub85c \ud3d0\uc1c4\ud574\uc57c \ud558\ub294 \ub808\ucf54\ub4dc\ub9cc \ub2e4\uc2dc \uc804\ub2ec\ud569\ub2c8\ub2e4.<\/span><\/p>\n<p style=\"margin-left: 80px\">\u00a0<\/p>\n<p style=\"margin-left:1.0in\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/july\/modelling-the-taxlot-process-with-n1ql\/tax8.png\" \/><\/p>\n<h2><strong>\uacb0\uacfc<\/strong><\/h2>\n<p>\ub530\ub77c\uc11c \ub370\uc774\ud130 \uc138\ud2b8\uac00 \ub2e4\uc74c\uacfc \uac19\ub2e4\uba74, \uac70\ub798 1\uc740 \ub9e4\uc218 \uac70\ub798\uc774\uace0 \ub9e4\ub3c4 \uac70\ub798\uc778 \uac70\ub798 2\uc640 \uc77c\uce58\ud558\ubbc0\ub85c \uac70\ub798 1\uc740 \uac70\ub798 2\ub85c \uccad\uc0b0\ub429\ub2c8\ub2e4. \uac70\ub798 3\uc740 \uc77c\uce58\ud558\ub294 \ud56d\ubaa9\uc774 \uc5c6\uc73c\ubbc0\ub85c \uccad\uc0b0\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub9c8\ucc2c\uac00\uc9c0\ub85c \uac70\ub798 4\ub3c4 \uac70\ub798 5\ub85c \ub9c8\uac10\ub429\ub2c8\ub2e4.<\/p>\n<p>\uac70\ub798 7~9\ub294 \ubaa8\ub450 \ub9e4\uc218 \uac70\ub798\uc774\uba70 \uc77c\uce58\ud558\ub294 \ub9e4\ub3c4 \uac70\ub798\uac00 \uc5c6\uc73c\ubbc0\ub85c \uccad\uc0b0\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\u00a0<img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/july\/modelling-the-taxlot-process-with-n1ql\/tax10.png\" \/><\/p>\n<p><span style=\"font-size: 2em;font-weight: bold;line-height: 1.2em\">\uacb0\ub860<\/span><\/p>\n<p>\u00a0<\/p>\n<p>\uc774 \uae00\uc758 \ubaa9\uc801\uc740 \ub9e4\uc6b0 \ubcf5\uc7a1\ud55c \ub370\uc774\ud130 \uc561\uc138\uc2a4 \ucffc\ub9ac\ub97c \ud574\uacb0\ud558\ub294 \ub370 N1QL\uc744 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc5f4\uac70\ud558\ub294 \uac83\uc774\uc5c8\uc2b5\ub2c8\ub2e4. SQL\ub85c \ubcf5\uc7a1\ud55c \uae30\ub2a5\uc744 \uc791\uc131\ud558\ub294 \ub370 \uc775\uc219\ud558\ub2e4\uba74 \uc774\uc81c \ub2e4\uc74c\uc5d0\uc11c \ub9e4\uc6b0 \uc27d\uac8c \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <strong>N1QL<\/strong>. \uc774 \ubb38\uc11c\uc5d0 \uc0ac\uc6a9\ub41c \uc608\uc81c\ub294 \ub530\ub77c \ud558\uae30 \uc27d\ub3c4\ub85d \uc758\ub3c4\uc801\uc73c\ub85c \ub2e8\uc21c\ud654\ub418\uc5c8\uc73c\uba70, \uc870\uc9c1\uc5d0\uc11c \uc6d0\ud558\ub294 \uacb0\uacfc\ub97c \uc5bb\uae30 \uc704\ud574 \uba87 \uac00\uc9c0 \uc870\uc815 \ub610\ub294 \ucd94\uac00 \uc870\uc778 \ub610\ub294 \ucffc\ub9ac\ub97c \ucd94\uac00\ud574\uc57c \ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\u00a0<\/p>\n<p><strong>\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc544\ud0a4\ud14d\ucc98\ub97c \ub354 \uc798 \uc774\ud574\ud558\ub824\uba74 \ub2e4\uc74c \ub9c1\ud06c\ub97c \ucc38\uc870\ud558\uc138\uc694. <\/strong><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/downloads\/?family=couchbase-server\"><strong>https:\/\/www.couchbase.com\/downloads\/?family=couchbase-server\/<\/strong><\/a><\/p>\n<p>\u00a0<\/p>\n<p><strong>N1Ql\uacfc \uc774 \uc194\ub8e8\uc158\uc774 \uc81c\uacf5\ud558\ub294 \uad6c\uc870\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\ub824\uba74 \ub2e4\uc74c \ub9c1\ud06c\ub97c \ud655\uc778\ud558\uc138\uc694.<\/strong><\/p>\n<p><a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/4.1\/n1ql\/index.html\"><strong>https:\/\/developer.couchbase.com\/documentation\/server\/4.1\/n1ql\/index.html<\/strong><\/a><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p><u>____________________________________________________________________________<\/u><\/p>\n<p>\uc774 \uae00\uc740 \uc0b0\ub514\uc544 \ud06c\ub9ac\uc288\ub098\ubb34\ub974\ud2f0(Sandhya Krishnamurthy) \uc218\uc11d \uc194\ub8e8\uc158 \uc5d4\uc9c0\ub2c8\uc5b4\uac00 \uc791\uc131\ud588\uc2b5\ub2c8\ub2e4. <strong>\uce74\uc6b0\uce58\ubca0\uc774\uc2a4<\/strong>\ub294 NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc120\ub3c4\uc801\uc778 \uacf5\uae09\uc5c5\uccb4\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc791\uc131\uc790\uc5d0\uac8c \ubb38\uc758 <a href=\"mailto:sandhya.krishnamurthy@couchbase.com\">sandhya.krishnamurthy@couchbase.com<\/a><\/p>\n<ul>\n<li>\ud3ec\ub7fc\uc5d0\uc11c \ubb38\uc758\ud558\uae30<\/li>\n<li>\ud314\ub85c\uc6b0\ud558\uae30 <a href=\"https:\/\/twitter.com\/couchbasedev\">@couchbasedev<\/a> \uadf8\ub9ac\uace0 <a href=\"https:\/\/twitter.com\/couchbase\">@couchbase<\/a><\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p>\ubb34\ub8cc \uc81c\ud488 \ub2e4\uc6b4\ub85c\ub4dc \ubc0f \ubb34\ub8cc \uad50\uc721\uc744 \ubc1b\uc73c\ub824\uba74 \uc544\ub798 \uc0ac\uc774\ud2b8\ub97c \ubc29\ubb38\ud558\uc5ec Couchbase \uc81c\ud488\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uc138\uc694.<\/p>\n<p><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/\"><strong>www.couchbase.com<\/strong><\/a><\/p>\n<p><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/downloads\/\"><strong>https:\/\/www.couchbase.com\/downloads\/<\/strong><\/a><\/p>\n<p><a href=\"https:\/\/learn.couchbase.com\/store\/\"><strong>https:\/\/learn.couchbase.com\/store\/<\/strong><\/a><\/p>\n<p>\u00a0<\/p>","protected":false},"excerpt":{"rendered":"<p>Purpose of this Article This article enumerates how the tax lot matching process can be modelled and the run in Couchbase. While the data model itself is a subjective thing, this article is going to only list the major entities [&hellip;]<\/p>","protected":false},"author":66,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1812],"tags":[],"ppma_author":[9038],"class_list":["post-2347","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-n1ql-query"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.1 (Yoast SEO v26.1.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Modelling the Taxlot Matching Process in 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\/modelling-the-taxlot-process-with-n1ql\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Modelling the Taxlot Matching Process in N1QL\" \/>\n<meta property=\"og:description\" content=\"Purpose of this Article This article enumerates how the tax lot matching process can be modelled and the run in Couchbase. While the data model itself is a subjective thing, this article is going to only list the major entities [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/modelling-the-taxlot-process-with-n1ql\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-22T22:29:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-12T09:27:09+00:00\" \/>\n<meta name=\"author\" content=\"Sandhya Krishnamurthy, Senior Solutions Engineer, 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=\"Sandhya Krishnamurthy, Senior Solutions Engineer, Couchbase\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/\"},\"author\":{\"name\":\"Sandhya Krishnamurthy, Senior Solutions Engineer, Couchbase\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/2d421ebd7ebf63e5491a9371909ab723\"},\"headline\":\"Modelling the Taxlot Matching Process in N1QL\",\"datePublished\":\"2016-07-22T22:29:16+00:00\",\"dateModified\":\"2024-09-12T09:27:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/\"},\"wordCount\":1605,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"articleSection\":[\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/\",\"name\":\"Modelling the Taxlot Matching Process in N1QL - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2016-07-22T22:29:16+00:00\",\"dateModified\":\"2024-09-12T09:27:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-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\/modelling-the-taxlot-process-with-n1ql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Modelling the Taxlot Matching Process in 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\/2d421ebd7ebf63e5491a9371909ab723\",\"name\":\"Sandhya Krishnamurthy, Senior Solutions Engineer, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/f4d7b0d0e3660d30cbd035db5621088e\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b2f1ee16accb4f849269e443ba5b34bc512dd5d425b4399779ebbaf3d1154557?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b2f1ee16accb4f849269e443ba5b34bc512dd5d425b4399779ebbaf3d1154557?s=96&d=mm&r=g\",\"caption\":\"Sandhya Krishnamurthy, Senior Solutions Engineer, Couchbase\"},\"description\":\"Sandhya Krishnamurthy is a technologist with a strong database development background and pre-sales experience. She is a part-time artist, part-time singer and full-time mom.\",\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/sandhya-krishnamurthy\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Modelling the Taxlot Matching Process in 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\/modelling-the-taxlot-process-with-n1ql\/","og_locale":"ko_KR","og_type":"article","og_title":"Modelling the Taxlot Matching Process in N1QL","og_description":"Purpose of this Article This article enumerates how the tax lot matching process can be modelled and the run in Couchbase. While the data model itself is a subjective thing, this article is going to only list the major entities [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/modelling-the-taxlot-process-with-n1ql\/","og_site_name":"The Couchbase Blog","article_published_time":"2016-07-22T22:29:16+00:00","article_modified_time":"2024-09-12T09:27:09+00:00","author":"Sandhya Krishnamurthy, Senior Solutions Engineer, Couchbase","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sandhya Krishnamurthy, Senior Solutions Engineer, Couchbase","Est. reading time":"10\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/"},"author":{"name":"Sandhya Krishnamurthy, Senior Solutions Engineer, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/2d421ebd7ebf63e5491a9371909ab723"},"headline":"Modelling the Taxlot Matching Process in N1QL","datePublished":"2016-07-22T22:29:16+00:00","dateModified":"2024-09-12T09:27:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/"},"wordCount":1605,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","articleSection":["SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/","url":"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/","name":"Modelling the Taxlot Matching Process in N1QL - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2016-07-22T22:29:16+00:00","dateModified":"2024-09-12T09:27:09+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-n1ql\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/modelling-the-taxlot-process-with-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\/modelling-the-taxlot-process-with-n1ql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Modelling the Taxlot Matching Process in 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\/2d421ebd7ebf63e5491a9371909ab723","name":"Sandhya Krishnamurthy, \uc120\uc784 \uc194\ub8e8\uc158 \uc5d4\uc9c0\ub2c8\uc5b4, Couchbase","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/f4d7b0d0e3660d30cbd035db5621088e","url":"https:\/\/secure.gravatar.com\/avatar\/b2f1ee16accb4f849269e443ba5b34bc512dd5d425b4399779ebbaf3d1154557?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b2f1ee16accb4f849269e443ba5b34bc512dd5d425b4399779ebbaf3d1154557?s=96&d=mm&r=g","caption":"Sandhya Krishnamurthy, Senior Solutions Engineer, Couchbase"},"description":"\uc0b0\ub514\uc544 \ud06c\ub9ac\uc288\ub098\ubb34\ub974\ud2f0\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1c\ubc1c \ubc30\uacbd\uacfc \uc0ac\uc804 \uc601\uc5c5 \uacbd\ud5d8\uc774 \ud48d\ubd80\ud55c \uae30\uc220 \uc804\ubb38\uac00\uc785\ub2c8\ub2e4. \uadf8\ub140\ub294 \ud30c\ud2b8\ud0c0\uc784 \uc544\ud2f0\uc2a4\ud2b8, \ud30c\ud2b8\ud0c0\uc784 \uac00\uc218, \ud480\ud0c0\uc784 \uc5c4\ub9c8\uc774\uae30\ub3c4 \ud569\ub2c8\ub2e4.","url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/sandhya-krishnamurthy\/"}]}},"authors":[{"term_id":9038,"user_id":66,"is_guest":0,"slug":"sandhya-krishnamurthy","display_name":"Sandhya Krishnamurthy, Senior Solutions Engineer, Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/b155c5b9bb4bc33f88ee8b7a387044ccc4e23146d3058e66ea7c3a82dd1f51c0?s=96&d=mm&r=g","author_category":"","last_name":"Krishnamurthy","first_name":"Sandhya","job_title":"","user_url":"","description":"\uc0b0\ub514\uc544 \ud06c\ub9ac\uc288\ub098\ubb34\ub974\ud2f0\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac1c\ubc1c \ubc30\uacbd\uacfc \uc0ac\uc804 \uc601\uc5c5 \uacbd\ud5d8\uc774 \ud48d\ubd80\ud55c \uae30\uc220 \uc804\ubb38\uac00\uc785\ub2c8\ub2e4. \uadf8\ub140\ub294 \ud30c\ud2b8\ud0c0\uc784 \uc544\ud2f0\uc2a4\ud2b8, \ud30c\ud2b8\ud0c0\uc784 \uac00\uc218, \ud480\ud0c0\uc784 \uc5c4\ub9c8\uc774\uae30\ub3c4 \ud569\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/2347","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\/66"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=2347"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/2347\/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=2347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=2347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=2347"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=2347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}