{"id":105929,"date":"2025-04-14T02:58:31","date_gmt":"2025-04-13T22:28:31","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/mongodb-with-search-indexes-queried-as-kimballs-star-schema-with-facts-and-dimensions-k1\/"},"modified":"2025-04-14T02:58:31","modified_gmt":"2025-04-13T22:28:31","slug":"mongodb-with-search-indexes-queried-as-kimballs-star-schema-with-facts-and-dimensions-k1","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/mongodb-with-search-indexes-queried-as-kimballs-star-schema-with-facts-and-dimensions-k1\/","title":{"rendered":"MongoDB \u0628\u0627 \u0634\u0627\u062e\u0635 \u0647\u0627\u06cc \u062c\u0633\u062a\u062c\u0648 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0637\u0631\u062d \u0633\u062a\u0627\u0631\u0647 \u06a9\u06cc\u0645\u0628\u0627\u0644 \u0628\u0627 \u062d\u0642\u0627\u06cc\u0642 \u0648 \u0627\u0628\u0639\u0627\u062f \u067e\u0631\u0633\u06cc\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f"},"content":{"rendered":"<div data-article-id=\"2404029\" id=\"article-body\">\n<p>\u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0627\u0633\u0646\u0627\u062f \u0645\u0627\u0646\u0646\u062f MongoDB \u060c \u0645\u062f\u0644 \u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0647 \u0637\u0648\u0631 \u0645\u0639\u0645\u0648\u0644 \u0628\u0631\u0627\u06cc \u0627\u0644\u06af\u0648\u0647\u0627\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u0627\u0632 \u067e\u06cc\u0634 \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u0628\u0647\u06cc\u0646\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f \u060c \u062c\u0627\u06cc\u06cc \u06a9\u0647 \u0647\u0631 \u062f\u0627\u0645\u0646\u0647 \u06cc\u0627 \u0633\u0631\u0648\u06cc\u0633 \u0635\u0627\u062d\u0628 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062e\u0648\u062f \u0627\u0633\u062a. \u0627\u06cc\u0646 \u062f\u0631 \u062a\u0636\u0627\u062f \u0628\u0627 \u0645\u062f\u0644 \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u0627\u0633\u062a \u060c \u06a9\u0647 \u0627\u063a\u0644\u0628 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0645\u062a\u0645\u0631\u06a9\u0632 \u0648 \u06a9\u0627\u0645\u0644\u0627\u064b \u0639\u0627\u062f\u06cc \u06a9\u0647 \u0645\u0633\u062a\u0642\u0644 \u0627\u0632 \u0647\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 \u062e\u0627\u0635 \u0637\u0631\u0627\u062d\u06cc \u0634\u062f\u0647 \u0627\u0633\u062a \u060c \u0639\u0645\u0644 \u0645\u06cc \u06a9\u0646\u062f.<br \/>\u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644 \u060c \u0627\u06a9\u062b\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0628\u0647 \u062a\u0648\u0627\u0646\u0627\u06cc\u06cc \u0627\u0646\u062c\u0627\u0645 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u0648\u0642\u062a \u06cc\u0627 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u0646\u062f \u060c \u062c\u0627\u06cc\u06cc \u06a9\u0647 \u0627\u0644\u06af\u0648\u0647\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0627\u0632 \u067e\u06cc\u0634 \u062a\u0639\u06cc\u06cc\u0646 \u0646\u0634\u062f\u0647 \u0627\u0633\u062a. <br \/>\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u060c \u0628\u0631\u0639\u06a9\u0633 \u0627\u0633\u062a: SQL \u0628\u0647 \u06cc\u06a9 \u0637\u0631\u062d\u0648\u0627\u0631\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062f\u06cc\u06af\u0631\u06cc \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u062f \u060c \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 MongoDB \u0647\u0645\u0627\u0646 \u0631\u0648\u06cc\u06a9\u0631\u062f \u0645\u062f\u0644 \u0627\u0628\u0639\u0627\u062f\u06cc \u0631\u0627 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0639\u0645\u0644\u06cc\u0627\u062a\u06cc \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f.<\/p>\n<p><strong>\u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc<\/strong>\u060c \u06cc\u06a9 \u0631\u0648\u0634 \u0645\u0639\u0645\u0648\u0644 \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u0628\u0627\u0646\u06a9 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u060c \u0627\u063a\u0644\u0628 \u062f\u0631 \u06cc\u06a9 <strong>\u0645\u062f\u0644 \u0627\u0628\u0639\u0627\u062f\u06cc<\/strong> \u0645\u062b\u0644 <strong>\u0637\u0631\u062d<\/strong> \u0645\u062d\u0628\u0648\u0628 \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 \u0631\u0627\u0644\u0641 \u06a9\u06cc\u0645\u0628\u0627\u0644. \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u060c \u0639\u0627\u062f\u06cc \u0634\u062f\u0647 <strong>\u0645\u06cc\u0632\u0647\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc\u062a<\/strong> \u0627\u062d\u0627\u0637\u0647 \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 denormalized <strong>\u0645\u06cc\u0632\u0647\u0627\u06cc \u0627\u0628\u0639\u0627\u062f\u06cc<\/strong>\u0628\u0634\u0631 \u0627\u06cc\u0646 \u062a\u0646\u0638\u06cc\u0645\u0627\u062a \u0627\u0633\u062a <strong>\u062c\u062f\u0627 \u0627\u0632 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0639\u0645\u0644\u06cc\u0627\u062a\u06cc<\/strong> \u0648 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0628\u0627 \u0628\u0627\u0631\u0647\u0627\u06cc \u06a9\u0627\u0631\u06cc \u0645\u0639\u0627\u0645\u0644\u0647 \u0627\u06cc \u0628\u0647 \u0631\u0648\u0632 \u0646\u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p><strong>mongoDB \u060c \u06cc\u06a9 \u0627\u0633\u062a\u0631\u0627\u062a\u0698\u06cc \u0645\u062a\u0641\u0627\u0648\u062a \u0631\u0627 \u0627\u0645\u06a9\u0627\u0646 \u067e\u0630\u06cc\u0631 \u0645\u06cc \u06a9\u0646\u062f<\/strong>\u0628\u0634\u0631 \u0628\u0627 \u062a\u0634\u06a9\u0631 \u0627\u0632 \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc\u06cc \u0645\u0627\u0646\u0646\u062f \u0634\u0627\u062e\u0635 \u0647\u0627\u06cc \u062c\u0633\u062a\u062c\u0648\u06cc Atlas MongoDB \u060c <strong>\u062a\u062d\u0644\u06cc\u0644\u06cc \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc<\/strong> \u0628\u062f\u0648\u0646 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062a\u06a9\u062b\u06cc\u0631 \u0628\u0647 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062a\u062d\u0644\u06cc\u0644\u06cc \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0639\u0645\u0644\u06cc\u0627\u062a\u06cc \u0627\u0646\u062c\u0627\u0645 \u0634\u0648\u062f. \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u06cc\u06a9 \u0645\u062b\u0627\u0644 \u0633\u0627\u062f\u0647 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0637\u0631\u062d \u0646\u0645\u0648\u0646\u0647 \u062a\u0627\u0631\u06cc\u062e \u0641\u0631\u0648\u0634 Oracle \u06a9\u0647 \u0645\u0646 \u062f\u0631 \u06af\u0630\u0634\u062a\u0647 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0646\u0645\u0648\u0646\u0647 \u0627\u06cc \u0627\u0632 \u06cc\u06a9 \u0637\u0631\u062d \u0633\u062a\u0627\u0631\u0647 \u0627\u06cc \u06a9\u0647 \u0628\u0647 \u062f\u0631\u0633\u062a\u06cc \u0628\u0627 \u0634\u0627\u062e\u0635 \u0647\u0627\u06cc Bitmap \u062f\u0631 \u06a9\u0644\u06cc\u062f\u0647\u0627\u06cc \u062e\u0627\u0631\u062c\u06cc \u0637\u0631\u0627\u062d\u06cc \u0634\u062f\u0647 \u0627\u0633\u062a \u060c \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u0645 \u062a\u0627 \u062a\u062d\u0648\u0644 \u0633\u062a\u0627\u0631\u0647 \u0631\u0627 \u0641\u0631\u0627\u0647\u0645 \u06a9\u0646\u062f.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/mongodb-with-search-indexes-queried-as-kimballs-star-schema-with-facts-and-dimensions-k1\/#%D8%B5%D8%A7%D8%AF%D8%B1%D8%A7%D8%AA_%D8%A7%D8%B2_SQL_%D8%A8%D9%87_CSV\" >\u0635\u0627\u062f\u0631\u0627\u062a \u0627\u0632 SQL \u0628\u0647 CSV<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/mongodb-with-search-indexes-queried-as-kimballs-star-schema-with-facts-and-dimensions-k1\/#%D9%88%D8%A7%D8%B1%D8%AF_%DA%A9%D8%B1%D8%AF%D9%86_%D8%A8%D9%87_MongoDB\" >\u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u0628\u0647 MongoDB<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/mongodb-with-search-indexes-queried-as-kimballs-star-schema-with-facts-and-dimensions-k1\/#%D9%86%D9%85%D8%A7%DB%8C%D9%87_%D8%B3%D8%A7%D8%B2%DB%8C_%D8%B7%D8%B1%D8%AD%D9%88%D8%A7%D8%B1%D9%87_%D8%B3%D8%AA%D8%A7%D8%B1%D9%87\" >\u0646\u0645\u0627\u06cc\u0647 \u0633\u0627\u0632\u06cc \u0637\u0631\u062d\u0648\u0627\u0631\u0647 \u0633\u062a\u0627\u0631\u0647<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/mongodb-with-search-indexes-queried-as-kimballs-star-schema-with-facts-and-dimensions-k1\/#%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88_%D8%A7%D8%B2_%D8%B7%D8%B1%D8%AD_%D8%B3%D8%AA%D8%A7%D8%B1%D9%87_%E2%80%93_%D8%AA%D8%AD%D9%88%D9%84_%D8%B3%D8%AA%D8%A7%D8%B1%D9%87\" >\u067e\u0631\u0633 \u0648 \u062c\u0648 \u0627\u0632 \u0637\u0631\u062d \u0633\u062a\u0627\u0631\u0647 &#8211; \u062a\u062d\u0648\u0644 \u0633\u062a\u0627\u0631\u0647<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/nabfollower.com\/blog\/mongodb-with-search-indexes-queried-as-kimballs-star-schema-with-facts-and-dimensions-k1\/#%D8%B3%D8%A4%D8%A7%D9%84%D8%A7%D8%AA_MongoDB_%D8%AF%D8%B1_%DB%8C%DA%A9_%D8%B7%D8%B1%D8%AD_%D8%B3%D8%AA%D8%A7%D8%B1%D9%87\" >\u0633\u0624\u0627\u0644\u0627\u062a MongoDB \u062f\u0631 \u06cc\u06a9 \u0637\u0631\u062d \u0633\u062a\u0627\u0631\u0647<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nabfollower.com\/blog\/mongodb-with-search-indexes-queried-as-kimballs-star-schema-with-facts-and-dimensions-k1\/#%D9%BE%D8%A7%DB%8C%D8%A7%D9%86\" >\u067e\u0627\u06cc\u0627\u0646<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D8%B5%D8%A7%D8%AF%D8%B1%D8%A7%D8%AA_%D8%A7%D8%B2_SQL_%D8%A8%D9%87_CSV\"><\/span>\n<p>  \u0635\u0627\u062f\u0631\u0627\u062a \u0627\u0632 SQL \u0628\u0647 CSV<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0633\u0627\u062f\u0647 \u062a\u0631\u06cc\u0646 \u0645\u0648\u0631\u062f \u0628\u0631\u0627\u06cc \u0628\u0647 \u062f\u0633\u062a \u0622\u0648\u0631\u062f\u0646 \u0637\u0631\u062d \u0646\u0645\u0648\u0646\u0647 \u062a\u0627\u0631\u06cc\u062e \u0641\u0631\u0648\u0634 (SH) \u0628\u0627 \u062f\u0627\u062f\u0647 \u0647\u0627 \u060c \u062f\u0627\u0634\u062a\u0646 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062e\u0648\u062f\u0645\u062e\u062a\u0627\u0631 \u062f\u0631 \u0631\u062f\u06cc\u0641 \u0622\u0632\u0627\u062f Oracle Cloud \u060c \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0628\u0647 \u0637\u0648\u0631 \u067e\u06cc\u0634 \u0641\u0631\u0636 \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u0627\u0633\u062a. <\/p>\n<p>\u0645\u0646 \u0628\u0631\u0627\u06cc \u062f\u0631\u06cc\u0627\u0641\u062a \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0647 \u067e\u0631\u0648\u0646\u062f\u0647 \u0647\u0627\u06cc CSV \u0627\u0632 Olload SQLCL \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight shell\"><code><span class=\"k\">for <\/span>i <span class=\"k\">in <\/span>CHANNELS COSTS COUNTRIES CUSTOMERS PRODUCTS PROMOTIONS SALES SUPPLEMENTARY_DEMOGRAPHICS TIMES \n<span class=\"k\">do \n <\/span><span class=\"nb\">echo<\/span> <span class=\"s2\">\"set loadformat csv\"<\/span>\n <span class=\"nb\">echo<\/span> <span class=\"s2\">\"alter session set nls_date_format=\"YYYY-MM-DD\";\"<\/span>\n <span class=\"nb\">echo<\/span> <span class=\"s2\">\"unload SH.<\/span><span class=\"nv\">$i<\/span><span class=\"s2\">\"<\/span>\n<span class=\"k\">done<\/span> <span class=\"o\">&gt;<\/span> unload.sql\n\nsqlcl @ unload.sql\n\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u067e\u0631\u0648\u0646\u062f\u0647 \u0647\u0627\u06cc CSV \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0631 \u0641\u0647\u0631\u0633\u062a \u0641\u0639\u0644\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight q\"><code>\n<span class=\"o\">$<\/span><span class=\"w\"> <\/span><span class=\"n\">wc<\/span><span class=\"w\"> <\/span><span class=\"o\">-<\/span><span class=\"n\">l<\/span><span class=\"w\"> <\/span><span class=\"o\">*<\/span><span class=\"n\">.csv<\/span><span class=\"w\"> <\/span><span class=\"o\">|<\/span><span class=\"w\"> <\/span><span class=\"n\">sort<\/span><span class=\"w\"> <\/span><span class=\"o\">-<\/span><span class=\"n\">n<\/span><span class=\"w\">                                                                                                                                                              <\/span>\n<span class=\"w\">       <\/span><span class=\"mi\">6<\/span><span class=\"w\"> <\/span><span class=\"n\">CHANNELS_DATA_TABLE.csv<\/span>\n<span class=\"w\">      <\/span><span class=\"mi\">24<\/span><span class=\"w\"> <\/span><span class=\"n\">COUNTRIES_DATA_TABLE.csv<\/span>\n<span class=\"w\">      <\/span><span class=\"mi\">73<\/span><span class=\"w\"> <\/span><span class=\"n\">PRODUCTS_DATA_TABLE.csv<\/span>\n<span class=\"w\">     <\/span><span class=\"mi\">504<\/span><span class=\"w\"> <\/span><span class=\"n\">PROMOTIONS_DATA_TABLE.csv<\/span>\n<span class=\"w\">    <\/span><span class=\"mi\">1827<\/span><span class=\"w\"> <\/span><span class=\"n\">TIMES_DATA_TABLE.csv<\/span>\n<span class=\"w\">    <\/span><span class=\"mi\">4501<\/span><span class=\"w\"> <\/span><span class=\"n\">SUPPLEMENTARY_DEMOGRAPHICS_DATA_TABLE.csv<\/span>\n<span class=\"w\">   <\/span><span class=\"mi\">55501<\/span><span class=\"w\"> <\/span><span class=\"n\">CUSTOMERS_DATA_TABLE.csv<\/span>\n<span class=\"w\">   <\/span><span class=\"mi\">82113<\/span><span class=\"w\"> <\/span><span class=\"n\">COSTS_DATA_TABLE.csv<\/span>\n<span class=\"w\">  <\/span><span class=\"mi\">918844<\/span><span class=\"w\"> <\/span><span class=\"n\">SALES_DATA_TABLE.csv<\/span>\n\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u067e\u0631\u0648\u0646\u062f\u0647 \u0647\u0627\u06cc CSV \u062d\u0627\u0648\u06cc \u06cc\u06a9 \u0647\u062f\u0631 \u0628\u0627 \u0646\u0627\u0645 \u0633\u062a\u0648\u0646 \u0645\u0648\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062f\u0631 \u0637\u0631\u062d \u0633\u062a\u0627\u0631\u0647 \u0627\u0633\u062a:<br \/><br \/><em>\u062a\u0635\u0648\u06cc\u0631 \u0627\u0632: https:\/\/docs.oracle.com\/cd\/b19306_01\/server.102\/b14198\/graphics\/comsc007.gif<\/em><\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D9%88%D8%A7%D8%B1%D8%AF_%DA%A9%D8%B1%D8%AF%D9%86_%D8%A8%D9%87_MongoDB\"><\/span>\n<p>  \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u0628\u0647 MongoDB<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0645\u0646 \u06cc\u06a9 \u0627\u0637\u0644\u0633 \u0645\u062d\u0644\u06cc \u0645\u0648\u0646\u06af\u0648\u062f \u0631\u0627 \u0634\u0631\u0648\u0639 \u06a9\u0631\u062f\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight shell\"><code>atlas deployments setup  atlas <span class=\"nt\">--type<\/span> <span class=\"nb\">local<\/span> <span class=\"nt\">--port<\/span> 27017 <span class=\"nt\">--force<\/span>\n\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0645\u0646 \u067e\u0631\u0648\u0646\u062f\u0647 \u0647\u0627\u06cc CSV \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight shell\"><code>mongoimport <span class=\"nt\">-j<\/span> 8 <span class=\"nt\">--type<\/span><span class=\"o\">=<\/span>csv <span class=\"nt\">--headerline<\/span> <span class=\"nt\">--drop<\/span> <span class=\"nt\">--file<\/span><span class=\"o\">=<\/span>CHANNELS_DATA_TABLE.csv <span class=\"nt\">--db<\/span><span class=\"o\">=<\/span>sh <span class=\"nt\">--collection<\/span><span class=\"o\">=<\/span>channels <span class=\"nv\">$@<\/span> <span class=\"o\">&amp;&amp;<\/span>                                                               \nmongoimport <span class=\"nt\">-j<\/span> 8 <span class=\"nt\">--type<\/span><span class=\"o\">=<\/span>csv <span class=\"nt\">--headerline<\/span> <span class=\"nt\">--drop<\/span> <span class=\"nt\">--file<\/span><span class=\"o\">=<\/span>COSTS_DATA_TABLE.csv <span class=\"nt\">--db<\/span><span class=\"o\">=<\/span>sh <span class=\"nt\">--collection<\/span><span class=\"o\">=<\/span>costs <span class=\"o\">&amp;&amp;<\/span>                                                                     \nmongoimport <span class=\"nt\">-j<\/span> 8 <span class=\"nt\">--type<\/span><span class=\"o\">=<\/span>csv <span class=\"nt\">--headerline<\/span> <span class=\"nt\">--drop<\/span> <span class=\"nt\">--file<\/span><span class=\"o\">=<\/span>COUNTRIES_DATA_TABLE.csv <span class=\"nt\">--db<\/span><span class=\"o\">=<\/span>sh <span class=\"nt\">--collection<\/span><span class=\"o\">=<\/span>countries <span class=\"o\">&amp;&amp;<\/span>                                                             \nmongoimport <span class=\"nt\">-j<\/span> 8 <span class=\"nt\">--type<\/span><span class=\"o\">=<\/span>csv <span class=\"nt\">--headerline<\/span> <span class=\"nt\">--drop<\/span> <span class=\"nt\">--file<\/span><span class=\"o\">=<\/span>CUSTOMERS_DATA_TABLE.csv <span class=\"nt\">--db<\/span><span class=\"o\">=<\/span>sh <span class=\"nt\">--collection<\/span><span class=\"o\">=<\/span>customers <span class=\"o\">&amp;&amp;<\/span>                                                             \nmongoimport <span class=\"nt\">-j<\/span> 8 <span class=\"nt\">--type<\/span><span class=\"o\">=<\/span>csv <span class=\"nt\">--headerline<\/span> <span class=\"nt\">--drop<\/span> <span class=\"nt\">--file<\/span><span class=\"o\">=<\/span>PRODUCTS_DATA_TABLE.csv <span class=\"nt\">--db<\/span><span class=\"o\">=<\/span>sh <span class=\"nt\">--collection<\/span><span class=\"o\">=<\/span>products <span class=\"o\">&amp;&amp;<\/span>                                                               \nmongoimport <span class=\"nt\">-j<\/span> 8 <span class=\"nt\">--type<\/span><span class=\"o\">=<\/span>csv <span class=\"nt\">--headerline<\/span> <span class=\"nt\">--drop<\/span> <span class=\"nt\">--file<\/span><span class=\"o\">=<\/span>PROMOTIONS_DATA_TABLE.csv <span class=\"nt\">--db<\/span><span class=\"o\">=<\/span>sh <span class=\"nt\">--collection<\/span><span class=\"o\">=<\/span>promotions <span class=\"o\">&amp;&amp;<\/span>                                                           \nmongoimport <span class=\"nt\">-j<\/span> 8 <span class=\"nt\">--type<\/span><span class=\"o\">=<\/span>csv <span class=\"nt\">--headerline<\/span> <span class=\"nt\">--drop<\/span> <span class=\"nt\">--file<\/span><span class=\"o\">=<\/span>SALES_DATA_TABLE.csv <span class=\"nt\">--db<\/span><span class=\"o\">=<\/span>sh <span class=\"nt\">--collection<\/span><span class=\"o\">=<\/span>sales <span class=\"o\">&amp;&amp;<\/span>\nmongosh sh <span class=\"nt\">--eval<\/span> <span class=\"s2\">\"show collections\"<\/span>                         \n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0646\u0647\u0635\u062f \u0647\u0632\u0627\u0631 \u0648\u0627\u0642\u0639\u06cc\u062a \u0648 \u0627\u0628\u0639\u0627\u062f \u0645\u0631\u0628\u0648\u0637\u0647 \u0631\u0627 \u062f\u0631 \u062f\u0647 \u062b\u0627\u0646\u06cc\u0647 \u0648\u0627\u0631\u062f \u0645\u06cc \u06a9\u0646\u062f:<br \/><img decoding=\"async\" src=\"https:\/\/media2.dev.to\/dynamic\/image\/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fn3n8kemjkf3ytqvcn1uf.png\" alt=\"\u0634\u0631\u062d \u062a\u0635\u0648\u06cc\u0631\" loading=\"lazy\" width=\"800\" height=\"460\" title=\"\"><\/p>\n<p>\u0645\u0646 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 &#8220;SH&#8221; \u0645\u062a\u0635\u0644 \u0645\u06cc \u0634\u0648\u0645 \u0648 \u0646\u0645\u0648\u0646\u0647 \u0627\u06cc \u0627\u0632 \u0627\u0633\u0646\u0627\u062f &#8220;\u0641\u0631\u0648\u0634&#8221; \u0631\u0627 \u0630\u06a9\u0631 \u0645\u06cc \u06a9\u0646\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight javascript\"><code><span class=\"nx\">mongosh<\/span>\n<span class=\"nx\">use<\/span> <span class=\"nx\">sh<\/span><span class=\"p\">;<\/span>\n<span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">sales<\/span><span class=\"p\">.<\/span><span class=\"nf\">find<\/span><span class=\"p\">().<\/span><span class=\"nf\">limit<\/span><span class=\"p\">(<\/span><span class=\"mi\">2<\/span><span class=\"p\">)<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><img decoding=\"async\" src=\"https:\/\/media2.dev.to\/dynamic\/image\/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fu10wsqdnbo8sqyue09qy.png\" alt=\"\u0634\u0631\u062d \u062a\u0635\u0648\u06cc\u0631\" loading=\"lazy\" width=\"800\" height=\"513\" title=\"\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D9%86%D9%85%D8%A7%DB%8C%D9%87_%D8%B3%D8%A7%D8%B2%DB%8C_%D8%B7%D8%B1%D8%AD%D9%88%D8%A7%D8%B1%D9%87_%D8%B3%D8%AA%D8%A7%D8%B1%D9%87\"><\/span>\n<p>  \u0646\u0645\u0627\u06cc\u0647 \u0633\u0627\u0632\u06cc \u0637\u0631\u062d\u0648\u0627\u0631\u0647 \u0633\u062a\u0627\u0631\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062f\u0631 \u0628\u0627\u0646\u06a9\u0647\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc SQL \u060c \u06cc\u06a9 \u0634\u0627\u062e\u0635 \u0628\u0647\u06cc\u0646\u0647 \u0648\u0627\u062d\u062f \u0628\u0631\u0627\u06cc \u06cc\u06a9 \u062f\u0627\u062f\u0647 \u0645\u0627\u0631\u062a\u06cc \u06a9\u0647 \u062f\u0631 \u062a\u0631\u06a9\u06cc\u0628 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0627\u0628\u0639\u0627\u062f \u067e\u0631\u0633\u06cc\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f \u060c \u0627\u06cc\u062c\u0627\u062f \u0646\u0645\u06cc \u0634\u0648\u062f. \u0637\u0631\u062d SH \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 Oracle \u0627\u0632 \u06cc\u06a9 \u0634\u0627\u062e\u0635 Bitmap \u0628\u0631\u0627\u06cc \u0647\u0631 \u06a9\u0644\u06cc\u062f \u062e\u0627\u0631\u062c\u06cc \u062f\u0631 \u062c\u062f\u0648\u0644 \u0648\u0627\u0642\u0639\u06cc\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f.<br \/>\u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627 \u062a\u0645\u0627\u0645 \u0634\u0627\u062e\u0635 \u0647\u0627\u06cc \u0644\u0627\u0632\u0645 \u0631\u0627 \u0645\u06cc \u062e\u0648\u0627\u0646\u0646\u062f \u0648 \u0646\u062a\u0627\u06cc\u062c \u0631\u0627 \u0628\u0627 \u0639\u0645\u0644\u06cc\u0627\u062a bitmap \u062a\u0631\u06a9\u06cc\u0628 \u0645\u06cc \u06a9\u0646\u0646\u062f \u060c \u06a9\u0647 \u0648\u0642\u062a\u06cc \u067e\u06cc\u0634 \u0628\u06cc\u0646\u06cc \u0647\u0627\u06cc \u0641\u0631\u062f\u06cc \u0641\u0627\u0642\u062f \u0627\u0646\u062a\u062e\u0627\u0628\u06cc \u0647\u0633\u062a\u0646\u062f \u060c \u0627\u06cc\u062f\u0647 \u0622\u0644 \u0627\u0633\u062a \u060c \u0627\u0645\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u0622\u0646\u0647\u0627 \u0622\u0646 \u0631\u0627 \u0628\u0647 \u0645\u062c\u0645\u0648\u0639\u0647 \u06a9\u0648\u0686\u06a9\u06cc \u0627\u0632 \u0631\u062f\u06cc\u0641 \u0647\u0627 \u06a9\u0627\u0647\u0634 \u0645\u06cc \u062f\u0647\u062f \u062a\u0627 \u0627\u0632 \u062c\u062f\u0648\u0644 \u0648\u0627\u0642\u0639\u06cc\u062a \u0628\u062e\u0648\u0627\u0646\u062f. <br \/>\u0634\u0627\u062e\u0635 \u0647\u0627\u06cc BITMAP \u0628\u0631\u0627\u06cc \u0627\u0646\u0628\u0627\u0631\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0627\u0645\u0627 \u0628\u0631\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0639\u0645\u0644\u06cc\u0627\u062a\u06cc \u0645\u0624\u062b\u0631 \u0647\u0633\u062a\u0646\u062f \u060c \u0632\u06cc\u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u0645\u0646\u062c\u0631 \u0628\u0647 \u062a\u06a9\u0647 \u062a\u06a9\u0647 \u0634\u062f\u0646 \u0634\u0627\u062e\u0635 \u0648 \u0645\u0648\u0627\u0631\u062f \u0642\u0641\u0644 \u0634\u062f\u0646 \u062f\u0631 \u0633\u06cc\u0633\u062a\u0645 \u0647\u0627\u06cc OLTP \u0634\u0648\u0646\u062f. \u0628\u0631\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u060c \u0627\u0648\u0631\u0627\u06a9\u0644 \u06cc\u06a9 \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u0633\u062a\u0648\u0646 \u062f\u0631 \u062d\u0627\u0641\u0638\u0647 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f \u060c \u06a9\u0647 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u062d\u0627\u0641\u0638\u0647 \u067e\u0646\u0647\u0627\u0646 \u0628\u0647\u06cc\u0646\u0647 \u0634\u062f\u0647 \u062a\u062d\u0644\u06cc\u0644\u06cc \u0628\u0631\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u0639\u0627\u0645\u0644\u0647 \u0627\u06cc \u0639\u0645\u0644 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p>MongoDB \u06cc\u06a9 \u0631\u0627\u0647 \u062d\u0644 \u0645\u062a\u0641\u0627\u0648\u062a \u062f\u0627\u0631\u062f: \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u062f\u0631 \u0647\u0631 \u062c\u062f\u0648\u0644 FACT \u0627\u0632 \u06cc\u06a9 \u0634\u0627\u062e\u0635 \u062c\u0633\u062a\u062c\u0648\u06cc \u0648\u0627\u062d\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u062f. \u0634\u0627\u062e\u0635 \u0647\u0627\u06cc \u062c\u0633\u062a\u062c\u0648\u06cc ATLAS \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0639\u0645\u0644\u06cc\u0627\u062a\u06cc \u0627\u062c\u0631\u0627 \u0645\u06cc \u0634\u0648\u0646\u062f \u0648 \u0628\u0647 \u0637\u0648\u0631 \u0647\u0645\u0632\u0645\u0627\u0646 \u0627\u0632 \u062c\u0631\u06cc\u0627\u0646 \u062a\u063a\u06cc\u06cc\u0631 \u0628\u0647 \u0631\u0648\u0632 \u0645\u06cc \u0634\u0648\u0646\u062f \u0648 \u0627\u0645\u06a9\u0627\u0646 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0646\u0632\u062f\u06cc\u06a9 \u0628\u0647 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0639\u0645\u0644\u06cc\u0627\u062a\u06cc \u0631\u0627 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc \u06a9\u0646\u0646\u062f.<\/p>\n<p>\u0645\u0646 \u0634\u0627\u062e\u0635 \u062c\u0633\u062a\u062c\u0648\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0631 \u0642\u0633\u0645\u062a \u0647\u0627\u06cc \u06a9\u0644\u06cc\u062f \u0627\u0628\u0639\u0627\u062f \u062f\u0631 \u062c\u062f\u0648\u0644 \u0648\u0627\u0642\u0639\u06cc\u062a \u0627\u0639\u0644\u0627\u0645 \u06a9\u0631\u062f\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight javascript\"><code><span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">sales<\/span><span class=\"p\">.<\/span><span class=\"nf\">createSearchIndex<\/span><span class=\"p\">(<\/span>\n   <span class=\"dl\">\"<\/span><span class=\"s2\">SalesDimension<\/span><span class=\"dl\">\"<\/span><span class=\"p\">,<\/span>\n   <span class=\"p\">{<\/span>\n     <span class=\"dl\">\"<\/span><span class=\"s2\">mappings<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\n       <span class=\"dl\">\"<\/span><span class=\"s2\">fields<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\n         <span class=\"dl\">\"<\/span><span class=\"s2\">PROD_ID<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span>    <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">type<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">number<\/span><span class=\"dl\">\"<\/span> <span class=\"p\">},<\/span>\n         <span class=\"dl\">\"<\/span><span class=\"s2\">CUST_ID<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span>    <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">type<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">number<\/span><span class=\"dl\">\"<\/span> <span class=\"p\">},<\/span>\n         <span class=\"dl\">\"<\/span><span class=\"s2\">TIME_ID<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span>    <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">type<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">token<\/span><span class=\"dl\">\"<\/span> <span class=\"p\">},<\/span>\n         <span class=\"dl\">\"<\/span><span class=\"s2\">CHANNEL_ID<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">type<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">number<\/span><span class=\"dl\">\"<\/span> <span class=\"p\">},<\/span>\n         <span class=\"dl\">\"<\/span><span class=\"s2\">PROMO_ID<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span>   <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">type<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">number<\/span><span class=\"dl\">\"<\/span> <span class=\"p\">},<\/span>\n       <span class=\"p\">}<\/span>\n     <span class=\"p\">}<\/span>\n   <span class=\"p\">}<\/span>\n<span class=\"p\">)<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0645\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u0627\u0632 CSV \u0628\u062f\u0648\u0646 \u062a\u0639\u0631\u06cc\u0641 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0645. Time_ID \u06cc\u06a9 \u0631\u0634\u062a\u0647 \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631 \u062f\u0631 \u0642\u0627\u0644\u0628 YYYY-MM-DD \u0627\u0633\u062a \u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0645\u0646 \u0622\u0646 \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0646\u0634\u0627\u0646\u0647 \u0627\u0639\u0644\u0627\u0645 \u06a9\u0631\u062f\u0645. \u0632\u0645\u06cc\u0646\u0647 \u0647\u0627\u06cc \u062f\u06cc\u06af\u0631 \u0627\u0639\u062f\u0627\u062f \u0647\u0633\u062a\u0646\u062f. \u0647\u0645\u0647 \u0632\u0645\u06cc\u0646\u0647 \u0647\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06a9\u0644\u06cc\u062f\u0647\u0627\u06cc \u062e\u0627\u0631\u062c\u06cc \u06a9\u0647 \u0628\u0647 \u0645\u062c\u0645\u0648\u0639\u0647 \u0647\u0627\u06cc \u0627\u0628\u0639\u0627\u062f \u0627\u0634\u0627\u0631\u0647 \u0645\u06cc \u06a9\u0646\u0646\u062f \u060c \u062e\u062f\u0645\u062a \u0645\u06cc \u06a9\u0646\u0646\u062f. \u0645\u0642\u0627\u062f\u06cc\u0631 \u0622\u0646\u0647\u0627 \u0627\u0632 \u062f\u0627\u0634\u062a\u0646 \u0646\u0638\u0645 \u0637\u0628\u06cc\u0639\u06cc \u0627\u0647\u0645\u06cc\u062a \u06a9\u0645\u062a\u0631\u06cc \u062f\u0627\u0631\u0646\u062f \u060c \u06a9\u0647 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062f\u0627\u0645\u0646\u0647 \u0631\u0627 \u062a\u0633\u0647\u06cc\u0644 \u06a9\u0646\u062f.<\/p>\n<p>\u0627\u06cc\u0646 \u0645\u062b\u0627\u0644 \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u062f\u0631 Atlas MongoDB Free Tier (M0) \u0627\u062c\u0631\u0627 \u06a9\u0631\u062f \u06a9\u0647 \u0627\u0645\u06a9\u0627\u0646 \u0633\u0647 \u0641\u0647\u0631\u0633\u062a \u062c\u0633\u062a\u062c\u0648 \u0631\u0627 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc \u06a9\u0646\u062f:<br \/><img decoding=\"async\" src=\"https:\/\/media2.dev.to\/dynamic\/image\/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Frh5zw5cfzdv0i4hnu9ge.png\" alt=\"\u0634\u0631\u062d \u062a\u0635\u0648\u06cc\u0631\" loading=\"lazy\" width=\"800\" height=\"312\" title=\"\"><\/p>\n<p>\u0627\u0646\u062f\u0627\u0632\u0647 \u06a9\u0644 \u0637\u0631\u062d SH \u060c \u0628\u062f\u0648\u0646 \u0634\u0627\u062e\u0635 \u062c\u0633\u062a\u062c\u0648 \u060c 60 \u0645\u06af\u0627\u0628\u0627\u06cc\u062a \u0627\u0633\u062a:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight r\"><code><span class=\"n\">Logical<\/span><span class=\"w\"> <\/span><span class=\"n\">Data<\/span><span class=\"w\"> <\/span><span class=\"n\">Size<\/span><span class=\"o\">:<\/span><span class=\"w\"> <\/span><span class=\"m\">172.12<\/span><span class=\"w\"> <\/span><span class=\"n\">MB<\/span><span class=\"w\">\n<\/span><span class=\"n\">Storage<\/span><span class=\"w\"> <\/span><span class=\"n\">Size<\/span><span class=\"o\">:<\/span><span class=\"w\"> <\/span><span class=\"m\">31.49<\/span><span class=\"w\"> <\/span><span class=\"n\">MB<\/span><span class=\"w\">\n<\/span><span class=\"n\">Index<\/span><span class=\"w\"> <\/span><span class=\"n\">Size<\/span><span class=\"o\">:<\/span><span class=\"w\"> <\/span><span class=\"m\">30.32<\/span><span class=\"w\"> <\/span><span class=\"n\">MB<\/span><span class=\"w\">\n<\/span><span class=\"n\">Total<\/span><span class=\"w\"> <\/span><span class=\"n\">Collections<\/span><span class=\"o\">:<\/span><span class=\"w\"> <\/span><span class=\"m\">9<\/span><span class=\"w\">\n<\/span><\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u06a9\u0647 \u0628\u06cc\u0634\u062a\u0631 \u0645\u062c\u0645\u0648\u0639\u0647 \u0641\u0631\u0648\u0634 \u0627\u0633\u062a:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight r\"><code><span class=\"n\">Storage<\/span><span class=\"w\"> <\/span><span class=\"n\">Size<\/span><span class=\"o\">:<\/span><span class=\"w\"> <\/span><span class=\"m\">20.83<\/span><span class=\"n\">MB<\/span><span class=\"w\">\n<\/span><span class=\"n\">Logical<\/span><span class=\"w\"> <\/span><span class=\"n\">Data<\/span><span class=\"w\"> <\/span><span class=\"n\">Size<\/span><span class=\"o\">:<\/span><span class=\"w\"> <\/span><span class=\"m\">124.4<\/span><span class=\"n\">MB<\/span><span class=\"w\">\n<\/span><span class=\"n\">Total<\/span><span class=\"w\"> <\/span><span class=\"n\">Documents<\/span><span class=\"o\">:<\/span><span class=\"w\"> <\/span><span class=\"m\">918843<\/span><span class=\"w\">\n<\/span><span class=\"n\">Indexes<\/span><span class=\"w\"> <\/span><span class=\"n\">Total<\/span><span class=\"w\"> <\/span><span class=\"n\">Size<\/span><span class=\"o\">:<\/span><span class=\"w\"> <\/span><span class=\"m\">26.01<\/span><span class=\"n\">MB<\/span><span class=\"w\">\n<\/span><\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0634\u0627\u062e\u0635 \u062c\u0633\u062a\u062c\u0648 \u062a\u0642\u0631\u06cc\u0628\u0627\u064b \u0628\u0647 \u0647\u0645\u0627\u0646 \u0627\u0646\u062f\u0627\u0632\u0647 \u0637\u0648\u0644 \u0645\u06cc \u06a9\u0634\u062f:<br \/><img decoding=\"async\" src=\"https:\/\/media2.dev.to\/dynamic\/image\/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F2ae0d7185dw43puxob12.png\" alt=\"\u0634\u0631\u062d \u062a\u0635\u0648\u06cc\u0631\" loading=\"lazy\" width=\"800\" height=\"406\" title=\"\"><\/p>\n<p>\u0627\u06cc\u0646 \u0646\u0633\u062e\u0647 \u06cc \u0646\u0645\u0627\u06cc\u0634\u06cc \u06cc\u06a9 \u0628\u0627\u0646\u06a9 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u06a9\u0648\u0686\u06a9 \u0631\u0627 \u0628\u0647 \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc \u06af\u0630\u0627\u0631\u062f \u0648 \u0645\u0642\u062f\u0627\u0631 \u0627\u06cc\u0646 \u0631\u0648\u06cc\u06a9\u0631\u062f \u0631\u0627 \u0647\u0646\u06af\u0627\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0628\u0632\u0631\u06af\u062a\u0631 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f. \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc \u0634\u0648\u062f \u0627\u0646\u062f\u0627\u0632\u0647 \u0634\u0627\u062e\u0635 \u062c\u0633\u062a\u062c\u0648 \u0631\u0627 \u0628\u0627 \u062d\u0627\u0641\u0638\u0647 \u0646\u0645\u0648\u0646\u0647 \u0645\u0642\u0627\u06cc\u0633\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88_%D8%A7%D8%B2_%D8%B7%D8%B1%D8%AD_%D8%B3%D8%AA%D8%A7%D8%B1%D9%87_%E2%80%93_%D8%AA%D8%AD%D9%88%D9%84_%D8%B3%D8%AA%D8%A7%D8%B1%D9%87\"><\/span>\n<p>  \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0627\u0632 \u0637\u0631\u062d \u0633\u062a\u0627\u0631\u0647 &#8211; \u062a\u062d\u0648\u0644 \u0633\u062a\u0627\u0631\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0645\u0632\u06cc\u062a \u0627\u0635\u0644\u06cc \u0627\u06cc\u0646 \u0637\u0631\u062d \u0633\u062a\u0627\u0631\u0647 \u062f\u0631 \u062c\u062f\u0648\u0644 \u0648\u0627\u0642\u0639\u06cc\u062a \u0622\u0646 \u0646\u0647\u0641\u062a\u0647 \u0627\u0633\u062a \u060c \u06a9\u0647 \u062d\u0627\u0648\u06cc \u0631\u062f\u06cc\u0641 \u0647\u0627\u06cc \u0628\u06cc \u0634\u0645\u0627\u0631\u06cc \u0628\u0627 \u0627\u0646\u062f\u0627\u0632\u0647 \u0645\u062d\u062f\u0648\u062f \u0627\u0633\u062a \u0648 \u0641\u0642\u0637 \u06a9\u0644\u06cc\u062f\u0647\u0627 \u0648 \u0627\u0642\u062f\u0627\u0645\u0627\u062a \u062e\u0627\u0631\u062c\u06cc \u0631\u0627 \u062f\u0631 \u0627\u062e\u062a\u06cc\u0627\u0631 \u062f\u0627\u0631\u062f. \u0627\u06cc\u0646 \u062a\u0639\u062f\u0627\u062f \u0631\u062f\u06cc\u0641 \u0628\u0632\u0631\u06af \u0628\u0627 \u0627\u0646\u062f\u0627\u0632\u0647 \u0631\u062f\u06cc\u0641 \u06a9\u0648\u0686\u06a9\u062a\u0631 \u062c\u0628\u0631\u0627\u0646 \u0645\u06cc \u0634\u0648\u062f. \u062f\u0631 \u062d\u0627\u0644\u062a \u0627\u06cc\u062f\u0647 \u0622\u0644 \u060c \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0648\u0627\u0642\u0639\u06cc\u062a \u0628\u0631\u0627\u06cc \u0628\u0647 \u062d\u062f\u0627\u0642\u0644 \u0631\u0633\u0627\u0646\u062f\u0646 \u067e\u06cc\u0648\u0633\u062a\u0646 \u0628\u0647 \u0628\u0633\u06cc\u0627\u0631\u06cc \u0627\u0632 \u0631\u062f\u06cc\u0641 \u0647\u0627 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f.<br \/>\u062c\u062f\u0627\u0648\u0644 \u0627\u0628\u0639\u0627\u062f \u06a9\u0648\u0686\u06a9\u062a\u0631 \u0647\u0633\u062a\u0646\u062f \u0627\u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u0631\u062f\u06cc\u0641 \u0647\u0627\u06cc \u0628\u0632\u0631\u06af\u062a\u0631 \u0631\u0627 \u0628\u0627 \u0686\u0646\u062f\u06cc\u0646 \u0648\u06cc\u0698\u06af\u06cc \u0628\u0631\u0627\u06cc \u0641\u06cc\u0644\u062a\u0631 \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 \u06a9\u0627\u0631\u0628\u0631 \u0648 \u0646\u0645\u0627\u06cc\u0634 \u062a\u0648\u0636\u06cc\u062d\u0627\u062a \u0637\u0648\u0644\u0627\u0646\u06cc \u062f\u0631 \u062e\u0648\u062f \u062c\u0627\u06cc \u062f\u0647\u0646\u062f. \u062f\u0631 SQL \u060c \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0647 \u062c\u062f\u0648\u0644 \u0648\u0627\u0642\u0639\u06cc\u062a \u0645\u06cc \u067e\u06cc\u0648\u0646\u062f\u0646\u062f \u062a\u0627 \u0627\u0628\u0639\u0627\u062f \u062f\u0631 \u0628\u0646\u062f FROM \u060c \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 \u067e\u06cc\u0634 \u0628\u06cc\u0646\u06cc \u0647\u0627 \u062f\u0631 \u0628\u0646\u062f WHOLE \u0645\u0634\u062e\u0635 \u0634\u062f\u0647 \u0627\u0633\u062a. \u0628\u0647\u06cc\u0646\u0647 \u0633\u0627\u0632 RDBMS \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0628\u0647\u0631\u0647 \u06af\u06cc\u0631\u06cc \u0627\u0632 \u0637\u0631\u062d\u0648\u0627\u0631\u0647 \u0633\u062a\u0627\u0631\u0647 \u0628\u0647 \u0637\u0648\u0631 \u0645\u0624\u062b\u0631 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u062f \u060c \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0645\u0646 \u062f\u0631 \u0645\u0642\u0627\u0644\u0647 \u0627\u06cc \u0642\u062f\u06cc\u0645\u06cc \u0628\u0631\u0627\u06cc \u062e\u0628\u0631\u0646\u0627\u0645\u0647 Soug \u0634\u0631\u062d \u062f\u0627\u062f\u0645:<\/p>\n<div class=\"crayons-card c-embed text-styles text-styles--secondary\">\n<div class=\"c-embed__cover\">\n<p>          <img decoding=\"async\" alt=\"\" src=\"https:\/\/media2.dev.to\/dynamic\/image\/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto\/https%3A%2F%2Fcdn.slidesharecdn.com%2Fss_thumbnails%2Fnl20144adaptivebitmappruning-141119120820-conversion-gate02-thumbnail.jpg%3Fwidth%3D640%26height%3D640%26fit%3Dbounds\" height=\"640\" loading=\"lazy\" class=\"m-0\" width=\"452\" title=\"\"><\/p><\/div>\n<div class=\"c-embed__body\">\n<p class=\"truncate-at-3\">\n<p>          \u062a\u062d\u0648\u0644 \u0633\u062a\u0627\u0631\u0647 \u060c 12C Adaptive Bitmap Adaptive Bitmap \u0648 \u06af\u0632\u06cc\u0646\u0647 \u062f\u0631 \u062d\u0627\u0641\u0638\u0647 &#8211; \u0628\u0627\u0631\u06af\u06cc\u0631\u06cc \u0628\u0647 \u0635\u0648\u0631\u062a PDF \u06cc\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u0622\u0646\u0644\u0627\u06cc\u0646 \u0628\u0647 \u0635\u0648\u0631\u062a \u0631\u0627\u06cc\u06af\u0627\u0646\n        <\/p>\n<div class=\"color-secondary fs-s flex items-center\">\n          <img decoding=\"async\" alt=\"\u0641\u0627\u0648\u06cc\u06a9\u0648\u0646\" class=\"c-embed__favicon m-0 mr-2 radius-0\" src=\"https:\/\/media2.dev.to\/dynamic\/image\/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto\/https%3A%2F%2Fpublic.slidesharecdn.com%2F_next%2Fstatic%2Fmedia%2Ffavicon.7bc3d920.ico\" loading=\"lazy\" width=\"32\" height=\"32\" title=\"\"><br \/>\n        slideshare.net\n      <\/div>\n<\/p><\/div>\n<\/div>\n<p>\u067e\u06cc\u0634 \u0628\u06cc\u0646\u06cc \u0647\u0627\u06cc \u0628\u0646\u062f \u062c\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc \u0628\u0647 \u062f\u0633\u062a \u0622\u0648\u0631\u062f\u0646 \u0644\u06cc\u0633\u062a \u06a9\u0644\u06cc\u062f\u0647\u0627\u06cc \u0627\u0628\u0639\u0627\u062f \u062f\u0631 \u0627\u0628\u0639\u0627\u062f \u06a9\u0648\u0686\u06a9 \u0627\u0639\u0645\u0627\u0644 \u0645\u06cc \u0634\u0648\u062f. \u0633\u067e\u0633 \u0627\u06cc\u0646 \u0644\u06cc\u0633\u062a \u0628\u0631\u0627\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 \u062c\u062f\u0648\u0644 \u0648\u0627\u0642\u0639\u06cc\u062a \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0634\u0627\u062e\u0635 \u0647\u0627\u06cc bitmap \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f \u0648 \u0641\u0642\u0637 \u0631\u062f\u06cc\u0641 \u0647\u0627\u06cc \u0644\u0627\u0632\u0645 \u0631\u0627 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0645\u06cc \u06a9\u0646\u062f. \u0633\u0631\u0627\u0646\u062c\u0627\u0645 \u060c \u0627\u06cc\u0646 \u0646\u062a\u06cc\u062c\u0647 \u0628\u0631\u0627\u06cc \u067e\u06cc\u0634 \u0628\u06cc\u0646\u06cc \u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u0628\u0627 \u062c\u062f\u0627\u0648\u0644 \u0627\u0628\u0639\u0627\u062f\u06cc \u0628\u0647 \u0647\u0645 \u067e\u06cc\u0648\u0633\u062a\u0647 \u0627\u0633\u062a. \u0627\u06cc\u0646 \u062a\u062d\u0648\u0644 \u060c \u0645\u0648\u062c\u0648\u062f \u062f\u0631 RDBM \u0647\u0627\u06cc \u062a\u062c\u0627\u0631\u06cc \u0645\u0627\u0646\u0646\u062f Oracle Database Enterprise Edition \u060c \u0641\u06cc\u0644\u062a\u0631 \u0631\u0627 \u0628\u0647\u06cc\u0646\u0647 \u0645\u06cc \u06a9\u0646\u062f \u062a\u0627 \u067e\u06cc\u0648\u0646\u062f\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0636\u0631\u0648\u0631\u06cc \u0631\u0627 \u0628\u0647 \u062d\u062f\u0627\u0642\u0644 \u0628\u0631\u0633\u0627\u0646\u062f. \u062f\u0631 Oracle Standard Edition \u06cc\u0627 PostgreSQL \u062f\u0631 \u062f\u0633\u062a\u0631\u0633 \u0646\u06cc\u0633\u062a. <\/p>\n<p>\u0627\u06cc\u0646 \u06a9\u0647 \u0622\u06cc\u0627 \u0627\u06cc\u0646 \u062a\u062d\u0648\u0644 \u0627\u062c\u0631\u0627 \u0634\u062f\u0647 \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631 \u060c \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 SQL \u0627\u0632 \u062c\u062f\u0648\u0644 \u0628\u06cc\u0646 \u062c\u062f\u0648\u0644 \u0648 \u0627\u0628\u0639\u0627\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 \u060c \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0632\u06cc\u0631 \u0645\u0639\u0627\u0645\u0644\u0627\u062a \u0641\u0631\u0648\u0634 \u0641\u0631\u0648\u0634 \u0627\u0632 \u0633\u0627\u0644 2001 \u0631\u0627 \u06a9\u0647 \u0628\u0627 \u062a\u0628\u0644\u06cc\u063a\u0627\u062a \u067e\u0631 \u0647\u0632\u06cc\u0646\u0647 \u0647\u0645\u0631\u0627\u0647 \u0627\u0633\u062a \u060c \u0628\u0627\u0632\u0646\u0634\u0633\u062a\u0647 \u0645\u06cc \u06a9\u0646\u062f \u060c \u0645\u0634\u062a\u0631\u06cc \u0647\u0627\u06cc \u06a9\u0627\u0644\u06cc\u0641\u0631\u0646\u06cc\u0627 \u0631\u0627 \u062f\u0631\u06af\u06cc\u0631 \u0645\u06cc \u06a9\u0646\u062f \u0648 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u06a9\u0627\u0646\u0627\u0644 \u0641\u0631\u0648\u0634 \u0645\u0633\u062a\u0642\u06cc\u0645 \u0631\u062e \u0645\u06cc \u062f\u0647\u062f \u060c \u0628\u0647 \u0637\u0648\u0631 \u062e\u0627\u0635 \u0628\u0627 \u062a\u0645\u0631\u06a9\u0632 \u0628\u0631 \u0634\u0646\u0628\u0647 \u0647\u0627:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>\n  <span class=\"n\">s<\/span><span class=\"p\">.<\/span><span class=\"n\">PROMO_ID<\/span><span class=\"p\">,<\/span> <span class=\"n\">s<\/span><span class=\"p\">.<\/span><span class=\"n\">CUST_ID<\/span><span class=\"p\">,<\/span> <span class=\"n\">s<\/span><span class=\"p\">.<\/span><span class=\"n\">CHANNEL_ID<\/span><span class=\"p\">,<\/span> <span class=\"n\">s<\/span><span class=\"p\">.<\/span><span class=\"n\">TIME_ID<\/span><span class=\"p\">,<\/span> <span class=\"n\">s<\/span><span class=\"p\">.<\/span><span class=\"n\">PROD_ID<\/span><span class=\"p\">,<\/span>\n  <span class=\"n\">p<\/span><span class=\"p\">.<\/span><span class=\"n\">PROD_NAME<\/span><span class=\"p\">,<\/span> <span class=\"n\">p<\/span><span class=\"p\">.<\/span><span class=\"n\">PROD_LIST_PRICE<\/span><span class=\"p\">,<\/span>\n  <span class=\"n\">s<\/span><span class=\"p\">.<\/span><span class=\"n\">quantity_sold<\/span><span class=\"p\">,<\/span> <span class=\"n\">s<\/span><span class=\"p\">.<\/span><span class=\"n\">amount_sold<\/span><span class=\"p\">,<\/span>\n<span class=\"k\">FROM<\/span>  <span class=\"n\">sales<\/span> <span class=\"n\">s<\/span>\n <span class=\"k\">JOIN<\/span> <span class=\"n\">products<\/span> <span class=\"n\">p<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">s<\/span><span class=\"p\">.<\/span><span class=\"n\">PROD_ID<\/span> <span class=\"o\">=<\/span> <span class=\"n\">p<\/span><span class=\"p\">.<\/span><span class=\"n\">PROD_ID<\/span>\n <span class=\"k\">JOIN<\/span> <span class=\"n\">promotions<\/span> <span class=\"n\">pr<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">s<\/span><span class=\"p\">.<\/span><span class=\"n\">PROMO_ID<\/span> <span class=\"o\">=<\/span> <span class=\"n\">pr<\/span><span class=\"p\">.<\/span><span class=\"n\">PROMO_ID<\/span>\n <span class=\"k\">JOIN<\/span> <span class=\"n\">customers<\/span> <span class=\"k\">c<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">s<\/span><span class=\"p\">.<\/span><span class=\"n\">CUST_ID<\/span> <span class=\"o\">=<\/span> <span class=\"k\">c<\/span><span class=\"p\">.<\/span><span class=\"n\">CUST_ID<\/span>\n <span class=\"k\">JOIN<\/span> <span class=\"n\">channels<\/span> <span class=\"n\">ch<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">s<\/span><span class=\"p\">.<\/span><span class=\"n\">CHANNEL_ID<\/span> <span class=\"o\">=<\/span> <span class=\"n\">ch<\/span><span class=\"p\">.<\/span><span class=\"n\">CHANNEL_ID<\/span>\n <span class=\"k\">JOIN<\/span> <span class=\"n\">times<\/span> <span class=\"n\">t<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">s<\/span><span class=\"p\">.<\/span><span class=\"n\">TIME_ID<\/span> <span class=\"o\">=<\/span> <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"n\">TIME_ID<\/span>\n<span class=\"k\">WHERE<\/span> <span class=\"n\">pr<\/span><span class=\"p\">.<\/span><span class=\"n\">PROMO_COST<\/span> <span class=\"o\">&gt;<\/span> <span class=\"mi\">10000<\/span>\n  <span class=\"k\">AND<\/span> <span class=\"k\">c<\/span><span class=\"p\">.<\/span><span class=\"n\">CUST_STATE_PROVINCE<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'CA'<\/span>\n  <span class=\"k\">AND<\/span> <span class=\"n\">ch<\/span><span class=\"p\">.<\/span><span class=\"n\">CHANNEL_DESC<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'Direct Sales'<\/span>\n  <span class=\"k\">AND<\/span> <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"n\">FISCAL_YEAR<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">2001<\/span>\n  <span class=\"k\">AND<\/span> <span class=\"n\">t<\/span><span class=\"p\">.<\/span><span class=\"n\">DAY_NAME<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'Saturday'<\/span>\n  <span class=\"k\">AND<\/span> <span class=\"n\">s<\/span><span class=\"p\">.<\/span><span class=\"n\">TIME_ID<\/span> <span class=\"o\">&gt;<\/span> <span class=\"nb\">date<\/span> <span class=\"s1\">'2001-01-01'<\/span>\n<span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>SQL \u0645\u0633\u062a\u0642\u0644 \u0627\u0632 \u0645\u062f\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0641\u06cc\u0632\u06cc\u06a9\u06cc \u0639\u0645\u0644 \u0645\u06cc \u06a9\u0646\u062f. \u0628\u0631\u0646\u0627\u0645\u0647 \u0631\u06cc\u0632 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0628\u0627\u06cc\u062f \u062a\u0631\u062a\u06cc\u0628 \u0628\u0647\u06cc\u0646\u0647 \u0628\u0631\u0627\u06cc \u067e\u06cc\u0648\u0633\u062a\u0646 \u0628\u0647 \u062c\u062f\u0627\u0648\u0644 \u0648 \u0627\u0646\u062a\u062e\u0627\u0628 \u0634\u0627\u062e\u0635 \u0647\u0627 \u060c \u0628\u0627 \u062a\u06a9\u06cc\u0647 \u0628\u0631 \u062a\u0631\u06a9\u06cc\u0628\u0627\u062a \u067e\u06cc\u0686\u06cc\u062f\u0647 \u067e\u06cc\u0634 \u0628\u06cc\u0646\u06cc \u0647\u0627 \u0628\u0631\u0627\u06cc \u0627\u0631\u0632\u06cc\u0627\u0628\u06cc \u06a9\u0627\u0631\u062f\u06cc\u0646\u0627\u0644 \u0647\u0627 \u062a\u062e\u0645\u06cc\u0646 \u0628\u0632\u0646\u062f.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D8%B3%D8%A4%D8%A7%D9%84%D8%A7%D8%AA_MongoDB_%D8%AF%D8%B1_%DB%8C%DA%A9_%D8%B7%D8%B1%D8%AD_%D8%B3%D8%AA%D8%A7%D8%B1%D9%87\"><\/span>\n<p>  \u0633\u0624\u0627\u0644\u0627\u062a MongoDB \u062f\u0631 \u06cc\u06a9 \u0637\u0631\u062d \u0633\u062a\u0627\u0631\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>MongoDB \u06a9\u0646\u062a\u0631\u0644 \u0628\u06cc\u0634\u062a\u0631\u06cc \u0631\u0627 \u0628\u0647 \u062a\u0648\u0633\u0639\u0647 \u062f\u0647\u0646\u062f\u0647 \u062f\u0631 \u0645\u0648\u0631\u062f \u0646\u062d\u0648\u0647 \u062f\u0633\u062a\u0631\u0633\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0645\u06cc \u062f\u0647\u062f \u0648 \u0627\u0632 \u0647\u0645\u0627\u0646 \u0631\u0648\u06cc\u06a9\u0631\u062f \u0628\u0647\u06cc\u0646\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f:<\/p>\n<ol>\n<li>\u0627\u0632 \u0647\u0631 \u0628\u0639\u062f \u06a9\u0647 \u0641\u06cc\u0644\u062a\u0631\u0647\u0627 \u062f\u0631 \u0622\u0646 \u0627\u0639\u0645\u0627\u0644 \u0645\u06cc \u0634\u0648\u062f \u060c \u0627\u0632 \u0645\u0646\u0627\u0628\u0639 \u0645\u0631\u0627\u062c\u0639\u0647 \u06a9\u0646\u06cc\u062f<\/li>\n<li>\u062c\u062f\u0648\u0644 \u0648\u0627\u0642\u0639\u06cc\u062a \u0631\u0627 \u0628\u0627 \u06cc\u06a9 \u062e\u0637 \u0644\u0648\u0644\u0647 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0634\u0627\u062e\u0635 \u062c\u0633\u062a\u062c\u0648 \u0628\u0631\u0627\u06cc \u06cc\u0627\u0641\u062a\u0646 \u0627\u06cc\u0646 \u0645\u0646\u0627\u0628\u0639 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0646\u06cc\u062f<\/li>\n<li>\u0628\u0647 \u0627\u0628\u0639\u0627\u062f\u06cc \u06a9\u0647 \u0627\u0632 \u0622\u0646\u0647\u0627 \u0628\u0647 \u0632\u0645\u06cc\u0646\u0647 \u0647\u0627\u06cc \u0628\u06cc\u0634\u062a\u0631\u06cc \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u06cc\u062f \u062c\u0633\u062a\u062c\u0648 \u06a9\u0646\u06cc\u062f<\/li>\n<\/ol>\n<p>\u0645\u0631\u062d\u0644\u0647 bitmap \u063a\u06cc\u0631 \u0636\u0631\u0648\u0631\u06cc \u0627\u0633\u062a \u0632\u06cc\u0631\u0627 \u0634\u0627\u062e\u0635 \u0647\u0627\u06cc \u062c\u0633\u062a\u062c\u0648 \u060c \u06a9\u0647 \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0622\u067e\u0627\u0686\u06cc \u0644\u0648\u0686\u0646 \u0647\u0633\u062a\u0646\u062f \u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u0686\u0646\u062f\u06cc\u0646 \u0641\u06cc\u0644\u062a\u0631 \u0631\u0627 \u0628\u0627 \u0627\u067e\u0631\u0627\u062a\u0648\u0631 \u062a\u0631\u06a9\u06cc\u0628 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u0646\u062f. \u06a9\u0644\u06cc\u062f\u0647\u0627\u06cc \u0627\u0628\u0639\u0627\u062f \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0634\u062f\u0647 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647 \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0633\u0627\u062f\u0647 \u0628\u0627 \u0627\u067e\u0631\u0627\u062a\u0648\u0631 \u062f\u0631 \u0622\u0646 \u0633\u0627\u062f\u0647 \u0627\u0633\u062a.<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0645\u062b\u0627\u0644\u06cc \u0628\u0631\u0627\u06cc \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0645\u0639\u0627\u0645\u0644\u0627\u062a \u0641\u0631\u0648\u0634 \u0627\u0632 \u0633\u0627\u0644 2001 \u0622\u0648\u0631\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a (<code>TIME_ID: { $gt: \"2001-01-01\" }<\/code>) \u06a9\u0647 \u0628\u0627 \u062a\u0628\u0644\u06cc\u063a\u0627\u062a \u067e\u0631 \u0647\u0632\u06cc\u0646\u0647 \u0647\u0645\u0631\u0627\u0647 \u0627\u0633\u062a (<code>PROMO_COST: { $gt: 10000 }<\/code>) \u060c \u0645\u0634\u062a\u0631\u06cc \u0647\u0627\u06cc \u06a9\u0627\u0644\u06cc\u0641\u0631\u0646\u06cc\u0627 \u0631\u0627 \u062f\u0631\u06af\u06cc\u0631 \u06a9\u0646\u06cc\u062f (<code>{ CUST_STATE_PROVINCE: 'CA'      }<\/code>) \u060c \u0648 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u06a9\u0627\u0646\u0627\u0644 \u0641\u0631\u0648\u0634 \u0645\u0633\u062a\u0642\u06cc\u0645 \u0631\u062e \u0645\u06cc \u062f\u0647\u062f (<code>{ CHANNEL_DESC: 'Direct Sales' }<\/code>) \u060c \u0628\u0647 \u0637\u0648\u0631 \u062e\u0627\u0635 \u0628\u0627 \u062a\u0645\u0631\u06a9\u0632 \u0628\u0631 \u0634\u0646\u0628\u0647 \u0647\u0627 (<code>{ FISCAL_YEAR: 2001 , DAY_NAME: 'Saturday' }<\/code>). <\/p>\n<p>\u0628\u0631\u0627\u06cc \u0645\u062d\u062f\u0648\u062f\u0647 \u0632\u0645\u0627\u0646\u06cc \u060c \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u06a9\u0644\u06cc\u062f \u0627\u0628\u0639\u0627\u062f \u062a\u0645\u0627\u0645 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0631\u0627 \u0628\u0627 \u0641\u0631\u0645\u062a YYYY-MM-DD \u062e\u0648\u062f \u062f\u0631 \u0627\u062e\u062a\u06cc\u0627\u0631 \u062f\u0627\u0631\u062f \u060c \u0646\u06cc\u0627\u0632\u06cc \u0628\u0647 \u062e\u0648\u0627\u0646\u062f\u0646 \u0627\u0632 \u0628\u0639\u062f \u0646\u062f\u0627\u0631\u0645. \u0628\u0631\u0627\u06cc \u062f\u06cc\u06af\u0631\u0627\u0646 \u060c \u0645\u0646 \u0627\u0632 \u0645\u062c\u0645\u0648\u0639\u0647 \u0647\u0627\u06cc \u0627\u0628\u0639\u0627\u062f \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u06cc \u06a9\u0646\u0645 \u062a\u0627 \u0645\u062c\u0645\u0648\u0639\u0647 \u0627\u06cc \u0627\u0632 \u06a9\u0644\u06cc\u062f\u0647\u0627 \u0631\u0627 \u06a9\u0647 \u0648\u0636\u0639\u06cc\u062a \u0645\u0646 \u0631\u0627 \u062a\u0623\u06cc\u06cc\u062f \u0645\u06cc \u06a9\u0646\u062f \u060c \u0628\u062f\u0633\u062a \u0622\u0648\u0631\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight javascript\"><code><span class=\"kd\">const<\/span> <span class=\"nx\">promoIds<\/span> <span class=\"o\">=<\/span> <span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">promotions<\/span><span class=\"p\">.<\/span><span class=\"nf\">find<\/span><span class=\"p\">(<\/span> \n <span class=\"p\">{<\/span><span class=\"na\">PROMO_COST<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"na\">$gt<\/span><span class=\"p\">:<\/span> <span class=\"mi\">10000<\/span> <span class=\"p\">}}<\/span> \n<span class=\"p\">).<\/span><span class=\"nf\">toArray<\/span><span class=\"p\">().<\/span><span class=\"nf\">map<\/span><span class=\"p\">(<\/span><span class=\"nx\">doc<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"nx\">doc<\/span><span class=\"p\">.<\/span><span class=\"nx\">PROMO_ID<\/span><span class=\"p\">);<\/span>\n\n<span class=\"kd\">const<\/span> <span class=\"nx\">custIds<\/span>  <span class=\"o\">=<\/span> <span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">customers<\/span><span class=\"p\">.<\/span><span class=\"nf\">find<\/span><span class=\"p\">(<\/span> \n  <span class=\"p\">{<\/span> <span class=\"na\">CUST_STATE_PROVINCE<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">CA<\/span><span class=\"dl\">'<\/span> <span class=\"p\">}<\/span>      \n<span class=\"p\">).<\/span><span class=\"nf\">toArray<\/span><span class=\"p\">().<\/span><span class=\"nf\">map<\/span><span class=\"p\">(<\/span><span class=\"nx\">doc<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"nx\">doc<\/span><span class=\"p\">.<\/span><span class=\"nx\">CUST_ID<\/span><span class=\"p\">);<\/span>\n\n<span class=\"kd\">const<\/span> <span class=\"nx\">channelIds<\/span>  <span class=\"o\">=<\/span> <span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">channels<\/span><span class=\"p\">.<\/span><span class=\"nf\">find<\/span><span class=\"p\">(<\/span> \n  <span class=\"p\">{<\/span> <span class=\"na\">CHANNEL_DESC<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">Direct Sales<\/span><span class=\"dl\">'<\/span> <span class=\"p\">}<\/span> \n<span class=\"p\">).<\/span><span class=\"nf\">toArray<\/span><span class=\"p\">().<\/span><span class=\"nf\">map<\/span><span class=\"p\">(<\/span><span class=\"nx\">doc<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"nx\">doc<\/span><span class=\"p\">.<\/span><span class=\"nx\">CHANNEL_ID<\/span><span class=\"p\">);<\/span>\n\n<span class=\"kd\">const<\/span> <span class=\"nx\">timeIds<\/span>  <span class=\"o\">=<\/span> <span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">times<\/span><span class=\"p\">.<\/span><span class=\"nf\">find<\/span><span class=\"p\">(<\/span> \n <span class=\"p\">{<\/span> <span class=\"na\">FISCAL_YEAR<\/span><span class=\"p\">:<\/span> <span class=\"mi\">2001<\/span> <span class=\"p\">,<\/span> <span class=\"na\">DAY_NAME<\/span><span class=\"p\">:<\/span> <span class=\"dl\">'<\/span><span class=\"s1\">Saturday<\/span><span class=\"dl\">'<\/span> <span class=\"p\">}<\/span> \n<span class=\"p\">).<\/span><span class=\"nf\">toArray<\/span><span class=\"p\">().<\/span><span class=\"nf\">map<\/span><span class=\"p\">(<\/span><span class=\"nx\">doc<\/span> <span class=\"o\">=&gt;<\/span> <span class=\"nx\">doc<\/span><span class=\"p\">.<\/span><span class=\"nx\">TIME_ID<\/span><span class=\"p\">);<\/span>\n\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u062f\u0631 \u0645\u0648\u0631\u062f \u0644\u06cc\u0633\u062a \u0647\u0627\u06cc \u0637\u0648\u0644\u0627\u0646\u06cc \u0646\u06af\u0631\u0627\u0646 \u0646\u0628\u0627\u0634\u06cc\u062f \u060c \u0634\u0627\u062e\u0635 \u0647\u0627\u06cc \u062c\u0633\u062a\u062c\u0648 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u0627\u0632 \u067e\u0633 \u0622\u0646 \u0628\u0631\u0622\u06cc\u0646\u062f:<br \/><img decoding=\"async\" src=\"https:\/\/media2.dev.to\/dynamic\/image\/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F39zx4evksffcblb1z5ig.png\" alt=\"\u0634\u0631\u062d \u062a\u0635\u0648\u06cc\u0631\" loading=\"lazy\" width=\"800\" height=\"1267\" title=\"\"><\/p>\n<p>\u0645\u0631\u062d\u0644\u0647 \u0628\u0639\u062f\u06cc \u06cc\u06a9 \u062e\u0637 \u0644\u0648\u0644\u0647 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0627\u0632 \u0622\u0646 \u0644\u06cc\u0633\u062a \u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f \u0648 \u0645\u062d\u062f\u0648\u062f\u0647 \u0632\u0645\u0627\u0646\u06cc \u0631\u0627 \u062f\u0631 \u06cc\u06a9 \u0641\u06cc\u0644\u062a\u0631 \u0645\u0631\u06a9\u0628 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u06a9\u0646\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight javascript\"><code><span class=\"nx\">db<\/span><span class=\"p\">.<\/span><span class=\"nx\">sales<\/span><span class=\"p\">.<\/span><span class=\"nf\">aggregate<\/span><span class=\"p\">([<\/span>\n  <span class=\"p\">{<\/span>\n    <span class=\"dl\">\"<\/span><span class=\"s2\">$search<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\n      <span class=\"dl\">\"<\/span><span class=\"s2\">index<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">SalesDimension<\/span><span class=\"dl\">\"<\/span><span class=\"p\">,<\/span>\n      <span class=\"dl\">\"<\/span><span class=\"s2\">compound<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\n        <span class=\"dl\">\"<\/span><span class=\"s2\">must<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">[<\/span>\n          <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">in<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">path<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">PROMO_ID<\/span><span class=\"dl\">\"<\/span><span class=\"p\">.<\/span> <span class=\"p\">,<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">value<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"nx\">promoIds<\/span>   <span class=\"p\">}<\/span> <span class=\"p\">},<\/span>\n          <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">in<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">path<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">CUST_ID<\/span><span class=\"dl\">\"<\/span><span class=\"p\">.<\/span>  <span class=\"p\">,<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">value<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"nx\">custIds<\/span>    <span class=\"p\">}<\/span> <span class=\"p\">},<\/span>\n          <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">in<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">path<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">CHANNEL_ID<\/span><span class=\"dl\">\"<\/span><span class=\"p\">,<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">value<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"nx\">channelIds<\/span> <span class=\"p\">}<\/span> <span class=\"p\">},<\/span>\n          <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">in<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">path<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">TIME_ID<\/span><span class=\"dl\">\"<\/span><span class=\"p\">.<\/span>  <span class=\"p\">,<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">value<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"nx\">timeIds<\/span>    <span class=\"p\">}<\/span> <span class=\"p\">},<\/span>\n          <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">range<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">path<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">TIME_ID<\/span><span class=\"dl\">\"<\/span><span class=\"p\">,<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">gt<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">2001-01-01<\/span><span class=\"dl\">\"<\/span>  <span class=\"p\">}<\/span> <span class=\"p\">}<\/span>\n        <span class=\"p\">]<\/span>\n      <span class=\"p\">}<\/span>\n    <span class=\"p\">}<\/span>\n  <span class=\"p\">},<\/span>\n  <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">$sort<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">TIME_ID<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"o\">-<\/span><span class=\"mi\">1<\/span> <span class=\"p\">}<\/span> <span class=\"p\">},<\/span>\n  <span class=\"p\">{<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">$limit<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"mi\">3<\/span> <span class=\"p\">},<\/span>\n  <span class=\"p\">{<\/span>\n    <span class=\"dl\">\"<\/span><span class=\"s2\">$lookup<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\n      <span class=\"dl\">\"<\/span><span class=\"s2\">from<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span>         <span class=\"dl\">\"<\/span><span class=\"s2\">products<\/span><span class=\"dl\">\"<\/span><span class=\"p\">,<\/span>\n      <span class=\"dl\">\"<\/span><span class=\"s2\">localField<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span>   <span class=\"dl\">\"<\/span><span class=\"s2\">PROD_ID<\/span><span class=\"dl\">\"<\/span><span class=\"p\">,<\/span>\n      <span class=\"dl\">\"<\/span><span class=\"s2\">foreignField<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">PROD_ID<\/span><span class=\"dl\">\"<\/span><span class=\"p\">,<\/span>\n      <span class=\"dl\">\"<\/span><span class=\"s2\">as<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span>           <span class=\"dl\">\"<\/span><span class=\"s2\">product_info<\/span><span class=\"dl\">\"<\/span>\n    <span class=\"p\">}<\/span>\n  <span class=\"p\">},<\/span>\n  <span class=\"p\">{<\/span>\n    <span class=\"dl\">\"<\/span><span class=\"s2\">$unwind<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"dl\">\"<\/span><span class=\"s2\">$product_info<\/span><span class=\"dl\">\"<\/span>\n  <span class=\"p\">},<\/span>\n  <span class=\"p\">{<\/span>\n    <span class=\"dl\">\"<\/span><span class=\"s2\">$project<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"p\">{<\/span>\n      <span class=\"dl\">\"<\/span><span class=\"s2\">PROMO_ID<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span><span class=\"p\">,<\/span>\n      <span class=\"dl\">\"<\/span><span class=\"s2\">CUST_ID<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span><span class=\"p\">,<\/span>\n      <span class=\"dl\">\"<\/span><span class=\"s2\">CHANNEL_ID<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span><span class=\"p\">,<\/span>\n      <span class=\"dl\">\"<\/span><span class=\"s2\">TIME_ID<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span><span class=\"p\">,<\/span>\n      <span class=\"dl\">\"<\/span><span class=\"s2\">PROD_ID<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span><span class=\"p\">,<\/span>\n      <span class=\"dl\">\"<\/span><span class=\"s2\">quantity_sold<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span><span class=\"p\">,<\/span>\n      <span class=\"dl\">\"<\/span><span class=\"s2\">amount_sold<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span><span class=\"p\">,<\/span>\n      <span class=\"dl\">\"<\/span><span class=\"s2\">product_info.PROD_NAME<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span><span class=\"p\">,<\/span>\n      <span class=\"dl\">\"<\/span><span class=\"s2\">product_info.PROD_LIST_PRICE<\/span><span class=\"dl\">\"<\/span><span class=\"p\">:<\/span> <span class=\"mi\">1<\/span>\n    <span class=\"p\">}<\/span>\n  <span class=\"p\">}<\/span>\n<span class=\"p\">]);<\/span>\n\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0639\u0645\u0644\u06cc\u0627\u062a \u062c\u0633\u062a\u062c\u0648 \u0627\u0648\u0644\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647 \u0627\u0632 \u062e\u0637 \u0644\u0648\u0644\u0647 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u060c \u0628\u0631\u0627\u06cc \u0628\u0647 \u062f\u0633\u062a \u0622\u0648\u0631\u062f\u0646 \u06a9\u0627\u0631\u0622\u06cc\u06cc \u062d\u062f\u0627\u0642\u0644 \u0645\u0648\u0627\u0631\u062f\u06cc \u0627\u0633\u062a \u06a9\u0647 \u062a\u0648\u0633\u0637 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u0648\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0642\u0631\u0627\u0631 \u0645\u06cc \u06af\u06cc\u0631\u062f \u0648 \u0645\u06cc \u062a\u0648\u0627\u0646 \u067e\u0631\u062f\u0627\u0632\u0634 \u0628\u06cc\u0634\u062a\u0631\u06cc \u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f.<br \/>\u0645\u0646 \u06cc\u06a9 \u0646\u0648\u0639 \u06a9\u0627\u0631 \u0645\u0631\u062a\u0628 \u0633\u0627\u0632\u06cc \u0648 \u0645\u062d\u062f\u0648\u062f\u06cc\u062a \u0631\u0627 \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0647 \u0627\u0645 \u062a\u0627 \u0641\u0642\u0637 \u0633\u0647 \u0641\u0631\u0648\u0634 \u0622\u062e\u0631 \u0631\u0627 \u0628\u0647 \u0646\u0645\u0627\u06cc\u0634 \u0628\u06af\u0630\u0627\u0631\u0645. \u0645\u0646 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u06cc\u0634\u062a\u0631\u06cc \u0631\u0627 \u0628\u0627 \u062c\u0633\u062a\u062c\u0648\u06cc \u0628\u0639\u062f \u0627\u0632 \u0645\u062d\u0635\u0648\u0644 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0647 \u0627\u0645 \u0648 \u0641\u0642\u0637 \u0646\u0627\u0645 \u0648 \u0642\u06cc\u0645\u062a \u0631\u0627 \u0628\u0647 \u067e\u0631\u0648\u0698\u0647 \u062e\u0648\u062f \u0628\u0627\u0632 \u0645\u06cc \u06a9\u0646\u0645.<\/p>\n<p>\u0646\u062a\u06cc\u062c\u0647 \u060c \u0645\u062c\u0645\u0648\u0639\u0647 \u0627\u06cc \u0627\u0632 \u0627\u0633\u0646\u0627\u062f \u0622\u0645\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u0628\u0627\u0632\u06af\u0634\u062a \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631 \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 8 \u0645\u06cc\u0644\u06cc \u062b\u0627\u0646\u06cc\u0647 \u0628\u0627\u0632\u06af\u0631\u062f\u0627\u0646\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/media2.dev.to\/dynamic\/image\/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fgsy3qlyo7qcs43yn6qls.png\" alt=\"\u0634\u0631\u062d \u062a\u0635\u0648\u06cc\u0631\" loading=\"lazy\" width=\"800\" height=\"557\" title=\"\"><\/p>\n<p>\u0627\u06cc\u0646 \u067e\u0633\u062a \u0628\u0627 \u0647\u062f\u0641 \u0646\u0634\u0627\u0646 \u062f\u0627\u062f\u0646 \u0645\u0624\u0644\u0641\u0647 \u062c\u0633\u062a\u062c\u0648 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u062a\u062d\u0644\u06cc\u0644\u06cc \u0628\u0627 \u062e\u0648\u0627\u0646\u062f\u0646 \u0641\u0642\u0637 \u0627\u0633\u0646\u0627\u062f \u0644\u0627\u0632\u0645 \u0627\u0632 \u0645\u062c\u0645\u0648\u0639\u0647 \u0648\u0627\u0642\u0639\u06cc\u062a. \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0628\u06cc\u0634\u062a\u0631 \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0647 \u062e\u0637 \u0644\u0648\u0644\u0647 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f. Datamodel \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0647\u0628\u0648\u062f \u0628\u062e\u0634\u06cc\u062f (\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0628\u0647\u062a\u0631 \u060c \u06a9\u0644\u06cc\u062f\u0647\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 _id \u0648 \u062e\u0648\u0634\u0647 \u0628\u0646\u062f\u06cc \u0634\u0627\u062e\u0635) \u0627\u0645\u0627 \u0647\u062f\u0641 \u0627\u06cc\u0646 \u0628\u0648\u062f \u06a9\u0647 \u0646\u0634\u0627\u0646 \u062f\u0647\u06cc\u0645 \u0686\u06af\u0648\u0646\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u062f\u0648\u0646 \u062a\u063a\u06cc\u06cc\u0631 \u0637\u0631\u062d \u060c \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062a\u062d\u0644\u06cc\u0644\u06cc \u0645\u0624\u062b\u0631 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u0645.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D9%BE%D8%A7%DB%8C%D8%A7%D9%86\"><\/span>\n<p>  \u067e\u0627\u06cc\u0627\u0646<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0628\u0631 \u062e\u0644\u0627\u0641 \u0637\u0631\u062d \u0647\u0627\u06cc SQL STAR \u060c \u06a9\u0647 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0641\u0631\u0622\u06cc\u0646\u062f\u0647\u0627\u06cc \u0628\u0627\u0631\u06af\u0630\u0627\u0631\u06cc-\u0627\u0646\u062a\u0642\u0627\u0644 (ELT) \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062f\u06cc\u06af\u0631 \u062f\u0627\u0631\u062f \u060c \u0645\u062f\u0644 \u0633\u0646\u062f MongoDB \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc \u062f\u0647\u062f \u062a\u0627 \u0645\u0639\u0627\u0645\u0644\u0627\u062a \u0627\u0632 \u062c\u0645\u0644\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062a\u0639\u0628\u06cc\u0647 \u0634\u062f\u0647 \u06cc\u0627 \u0627\u0631\u062c\u0627\u0639 \u0634\u062f\u0647 \u062f\u0631 \u06cc\u06a9 \u0645\u062c\u0645\u0648\u0639\u0647 \u0648\u0627\u062d\u062f \u0630\u062e\u06cc\u0631\u0647 \u0634\u0648\u062f \u060c \u0628\u0647 \u0637\u0648\u0631 \u0645\u0624\u062b\u0631 \u0628\u0647 \u062d\u0642\u0627\u06cc\u0642 \u0686\u0646\u062f \u063a\u063a\u0637\u06cc \u0648 \u0628\u062f\u0648\u0646 \u067e\u06cc\u0648\u0646\u062f\u0647\u0627\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0628\u067e\u0631\u062f\u0627\u0632\u062f.<\/p>\n<p>\u0627\u0632 \u0631\u0648\u06cc\u06a9\u0631\u062f \u062a\u062d\u0648\u0644 \u0633\u062a\u0627\u0631\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0631\u0627\u06cc \u062a\u0648\u0644\u06cc\u062f \u0644\u06cc\u0633\u062a\u06cc \u0627\u0632 \u06a9\u0644\u06cc\u062f\u0647\u0627\u06cc \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0645\u062c\u0645\u0648\u0639\u0647 \u0647\u0627\u06cc \u062c\u0633\u062a\u062c\u0648 \u0628\u0627 \u0641\u06cc\u0644\u062a\u0631\u0647\u0627\u06cc \u0642\u0627\u0628\u0644 \u0627\u062c\u0631\u0627 \u060c \u0645\u0634\u0627\u0628\u0647 \u062c\u062f\u0627\u0648\u0644 \u0627\u0628\u0639\u0627\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f. \u0634\u0627\u062e\u0635 \u0647\u0627\u06cc \u062c\u0633\u062a\u062c\u0648\u06cc \u0627\u0637\u0644\u0633 \u0627\u06cc\u0646 \u06a9\u0644\u06cc\u062f\u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0627\u0633\u0646\u0627\u062f \u0644\u0627\u0632\u0645 \u0627\u0632 \u0645\u062c\u0645\u0648\u0639\u0647 \u062d\u0642\u0627\u06cc\u0642 \u0628\u0631\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0628\u06cc\u0634\u062a\u0631 \u062f\u0631 \u062e\u0637 \u0644\u0648\u0644\u0647 \u062c\u0645\u0639 \u062a\u0631\u06a9\u06cc\u0628 \u0645\u06cc \u06a9\u0646\u0646\u062f.<\/p>\n<p>\u0628\u0627 MongoDB \u060c \u0627\u06af\u0631 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062e\u0648\u062f \u0631\u0627 \u0628\u0647 \u062f\u0631\u0633\u062a\u06cc \u0628\u0631\u0627\u06cc \u0645\u0648\u0627\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0627\u0645\u0646\u0647 \u0627\u0644\u06af\u0648\u0628\u0631\u062f\u0627\u0631\u06cc \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f \u0648 \u0628\u0639\u062f\u0627\u064b \u0628\u0627 \u0646\u06cc\u0627\u0632\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0647 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062a\u062c\u0645\u0639 \u0627\u0633\u0646\u0627\u062f \u067e\u0631\u0627\u06a9\u0646\u062f\u0647 \u062f\u0627\u0631\u062f \u060c \u0645\u0648\u0627\u062c\u0647 \u0634\u0648\u06cc\u062f \u060c \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u06cc\u06a9 \u0641\u0647\u0631\u0633\u062a \u062c\u0633\u062a\u062c\u0648 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0642\u0628\u0644 \u0627\u0632 \u062a\u063a\u06cc\u06cc\u0631 \u0645\u062f\u0644 \u06cc\u0627 \u067e\u062e\u0634 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062f\u06cc\u06af\u0631\u06cc \u060c \u0627\u06cc\u0646 \u0646\u06cc\u0627\u0632\u0647\u0627 \u0631\u0627 \u0628\u0631\u0637\u0631\u0641 \u06a9\u0646\u062f.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0627\u0633\u0646\u0627\u062f \u0645\u0627\u0646\u0646\u062f MongoDB \u060c \u0645\u062f\u0644 \u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0647 \u0637\u0648\u0631 \u0645\u0639\u0645\u0648\u0644 \u0628\u0631\u0627\u06cc \u0627\u0644\u06af\u0648\u0647\u0627\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u0627\u0632 \u067e\u06cc\u0634 \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u0628\u0647\u06cc\u0646\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f \u060c \u062c\u0627\u06cc\u06cc \u06a9\u0647 \u0647\u0631 \u062f\u0627\u0645\u0646\u0647 \u06cc\u0627 \u0633\u0631\u0648\u06cc\u0633 \u0635\u0627\u062d\u0628 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062e\u0648\u062f \u0627\u0633\u062a. \u0627\u06cc\u0646 \u062f\u0631 \u062a\u0636\u0627\u062f \u0628\u0627 \u0645\u062f\u0644 \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u0627\u0633\u062a \u060c \u06a9\u0647 \u0627\u063a\u0644\u0628 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0645\u062a\u0645\u0631\u06a9\u0632 \u0648 &hellip;<\/p>\n","protected":false},"author":2,"featured_media":105930,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-105929","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/105929","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=105929"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/105929\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/105930"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=105929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=105929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=105929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}