{"id":478075,"date":"2023-08-09T09:27:06","date_gmt":"2023-08-09T09:27:06","guid":{"rendered":""},"modified":"2023-09-05T11:16:00","modified_gmt":"2023-09-05T11:16:00","slug":"multi-dimensional-olap-molap","status":"publish","type":"wiki","link":"https:\/\/oneproxy.pro\/jp\/wiki\/multi-dimensional-olap-molap\/","title":{"rendered":"\u591a\u6b21\u5143 OLAP (MOLAP)"},"content":{"rendered":"<h2>\u591a\u6b21\u5143 OLAP (MOLAP) \u306e\u8d77\u6e90\u306e\u6b74\u53f2<\/h2>\n<p>\u591a\u6b21\u5143 OLAP (\u4e00\u822c\u306b MOLAP \u3068\u3057\u3066\u77e5\u3089\u308c\u3066\u3044\u308b) \u306f\u3001\u30c7\u30fc\u30bf\u5206\u6790\u3068\u30d3\u30b8\u30cd\u30b9 \u30a4\u30f3\u30c6\u30ea\u30b8\u30a7\u30f3\u30b9\u306e\u5206\u91ce\u3067\u4f7f\u7528\u3055\u308c\u3066\u3044\u308b\u5f37\u529b\u3067\u6d17\u7df4\u3055\u308c\u305f\u30c6\u30af\u30ce\u30ed\u30b8\u3067\u3059\u3002MOLAP \u306e\u30eb\u30fc\u30c4\u306f\u3001EF Codd \u535a\u58eb\u304c\u300c\u5927\u898f\u6a21\u5171\u6709\u30c7\u30fc\u30bf \u30d0\u30f3\u30af\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb \u30c7\u30fc\u30bf \u30e2\u30c7\u30eb\u300d\u3068\u3044\u3046\u8ad6\u6587\u3067 OLAP (\u30aa\u30f3\u30e9\u30a4\u30f3\u5206\u6790\u51e6\u7406) \u306e\u6982\u5ff5\u3092\u521d\u3081\u3066\u7d39\u4ecb\u3057\u305f 1970 \u5e74\u4ee3\u306b\u307e\u3067\u9061\u308a\u307e\u3059\u3002\u3057\u304b\u3057\u3001MOLAP \u304c\u5e83\u304f\u6ce8\u76ee\u3055\u308c\u3001\u3055\u307e\u3056\u307e\u306a\u696d\u754c\u3067\u30c7\u30fc\u30bf\u306b\u57fa\u3065\u304f\u610f\u601d\u6c7a\u5b9a\u306b\u4e0d\u53ef\u6b20\u306a\u30c4\u30fc\u30eb\u306b\u306a\u3063\u305f\u306e\u306f 1990 \u5e74\u4ee3\u306b\u306a\u3063\u3066\u304b\u3089\u3067\u3057\u305f\u3002<\/p>\n<h2>\u591a\u6b21\u5143 OLAP (MOLAP) \u306e\u8a73\u7d30\u60c5\u5831<\/h2>\n<p>MOLAP \u306f\u3001\u30a2\u30ca\u30ea\u30b9\u30c8\u3084\u610f\u601d\u6c7a\u5b9a\u8005\u304c\u5927\u898f\u6a21\u306a\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306b\u5bfe\u3057\u3066\u8907\u96d1\u306a\u30af\u30a8\u30ea\u3084\u591a\u6b21\u5143\u5206\u6790\u3092\u5b9f\u884c\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b\u7279\u6b8a\u306a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7ba1\u7406\u30b7\u30b9\u30c6\u30e0\u3067\u3059\u3002\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u51e6\u7406\u7528\u306b\u6700\u9069\u5316\u3055\u308c\u305f\u5f93\u6765\u306e\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u306f\u7570\u306a\u308a\u3001MOLAP \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u3001\u5206\u6790\u30ef\u30fc\u30af\u30ed\u30fc\u30c9\u3092\u52b9\u7387\u7684\u306b\u51e6\u7406\u3059\u308b\u3088\u3046\u306b\u7279\u5225\u306b\u8a2d\u8a08\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>MOLAP \u3067\u306f\u3001\u30c7\u30fc\u30bf\u306f\u591a\u6b21\u5143\u69cb\u9020\u306b\u7de8\u6210\u3055\u308c\u3001\u901a\u5e38\u306f\u30ad\u30e5\u30fc\u30d6\u3068\u3057\u3066\u8868\u3055\u308c\u307e\u3059\u3002\u3053\u308c\u3089\u306e\u30ad\u30e5\u30fc\u30d6\u306b\u306f\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u3001\u30e1\u30b8\u30e3\u30fc\u3001\u968e\u5c64\u304c\u542b\u307e\u308c\u3066\u304a\u308a\u3001\u30c7\u30fc\u30bf\u306e\u5305\u62ec\u7684\u3067\u76f4\u611f\u7684\u306a\u30d3\u30e5\u30fc\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u306f\u6642\u9593\u3001\u5834\u6240\u3001\u88fd\u54c1\u30ab\u30c6\u30b4\u30ea\u306a\u3069\u306e\u30c7\u30fc\u30bf\u306e\u7279\u6027\u3092\u8868\u3057\u3001\u30e1\u30b8\u30e3\u30fc\u306f\u58f2\u4e0a\u53ce\u76ca\u3084\u5229\u76ca\u306a\u3069\u306e\u5206\u6790\u5bfe\u8c61\u306e\u6570\u5024\u3067\u3059\u3002<\/p>\n<h2>\u591a\u6b21\u5143 OLAP (MOLAP) \u306e\u5185\u90e8\u69cb\u9020<\/h2>\n<p>MOLAP \u306e\u5185\u90e8\u69cb\u9020\u306b\u306f\u3001\u3044\u304f\u3064\u304b\u306e\u91cd\u8981\u306a\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u304c\u542b\u307e\u308c\u307e\u3059\u3002<\/p>\n<ol>\n<li>\n<p><strong>\u30ad\u30e5\u30fc\u30d6\uff1a<\/strong> MOLAP \u306e\u4e2d\u5fc3\u8981\u7d20\u3067\u3042\u308b\u30ad\u30e5\u30fc\u30d6\u306f\u3001\u30c7\u30fc\u30bf\u3092\u591a\u6b21\u5143\u5f62\u5f0f\u3067\u4fdd\u5b58\u3057\u3001\u9ad8\u901f\u304b\u3064\u52b9\u7387\u7684\u306a\u30af\u30a8\u30ea\u3092\u53ef\u80fd\u306b\u3057\u307e\u3059\u3002\u30ad\u30e5\u30fc\u30d6\u5185\u306e\u5404\u30bb\u30eb\u306f\u3001\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u306e\u4e00\u610f\u306e\u4ea4\u5dee\u90e8\u5206\u3092\u8868\u3057\u3001\u5bfe\u5fdc\u3059\u308b\u30e1\u30b8\u30e3\u30fc\u5024\u304c\u542b\u307e\u308c\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u5bf8\u6cd5:<\/strong> \u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u306f\u3001\u30c7\u30fc\u30bf\u3092\u30b0\u30eb\u30fc\u30d7\u5316\u304a\u3088\u3073\u6574\u7406\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3055\u308c\u308b\u30ab\u30c6\u30b4\u30ea\u5c5e\u6027\u3067\u3059\u3002\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u306b\u3088\u308a\u3001\u30c7\u30fc\u30bf\u3092\u3055\u307e\u3056\u307e\u306a\u65b9\u6cd5\u3067\u7d30\u5206\u5316\u3057\u3066\u3001\u30e6\u30fc\u30b6\u30fc\u304c\u3055\u307e\u3056\u307e\u306a\u89b3\u70b9\u304b\u3089\u60c5\u5831\u3092\u8868\u793a\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u5bfe\u7b56\uff1a<\/strong> \u30e1\u30b8\u30e3\u30fc\u306f\u3001\u5206\u6790\u3055\u308c\u308b\u6570\u5024\u30c7\u30fc\u30bf \u30dd\u30a4\u30f3\u30c8\u3067\u3059\u3002\u3053\u308c\u3089\u306b\u306f\u3001\u58f2\u4e0a\u3001\u53ce\u76ca\u3001\u5229\u76ca\u3001\u6570\u91cf\u3001\u5206\u6790\u306b\u95a2\u9023\u3059\u308b\u305d\u306e\u4ed6\u306e\u6570\u5024\u306a\u3069\u306e\u6307\u6a19\u3092\u542b\u3081\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u968e\u5c64:<\/strong> \u968e\u5c64\u306f\u3001\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u306e\u7570\u306a\u308b\u30ec\u30d9\u30eb\u9593\u306e\u95a2\u4fc2\u3092\u5b9a\u7fa9\u3057\u307e\u3059\u3002\u305f\u3068\u3048\u3070\u3001\u6642\u9593\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u306b\u306f\u3001\u5e74 &gt; \u56db\u534a\u671f &gt; \u6708 &gt; \u65e5\u306e\u3088\u3046\u306a\u968e\u5c64\u304c\u3042\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<\/li>\n<\/ol>\n<h2>\u591a\u6b21\u5143 OLAP (MOLAP) \u306e\u4e3b\u306a\u6a5f\u80fd\u306e\u5206\u6790<\/h2>\n<p>MOLAP \u306f\u3001\u30c7\u30fc\u30bf\u5206\u6790\u306e\u5f37\u529b\u306a\u30c4\u30fc\u30eb\u3068\u306a\u308b\u3044\u304f\u3064\u304b\u306e\u91cd\u8981\u306a\u6a5f\u80fd\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002<\/p>\n<ol>\n<li>\n<p><strong>\u30cf\u30a4\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\uff1a<\/strong> MOLAP \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u3001\u30af\u30a8\u30ea\u3068\u5fdc\u7b54\u6642\u9593\u304c\u9ad8\u901f\u306b\u306a\u308b\u3088\u3046\u306b\u6700\u9069\u5316\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u591a\u6b21\u5143\u69cb\u9020\u306b\u3088\u308a\u3001\u5927\u898f\u6a21\u306a\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3067\u3042\u3063\u3066\u3082\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u3068\u96c6\u7d04\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u76f4\u611f\u7684\u306a\u30c7\u30fc\u30bf\u63a2\u7d22:<\/strong> \u30ad\u30e5\u30fc\u30d6\u5185\u306e\u30c7\u30fc\u30bf\u306e\u591a\u6b21\u5143\u8868\u73fe\u306b\u3088\u308a\u3001\u30e6\u30fc\u30b6\u30fc\u306f\u3055\u307e\u3056\u307e\u306a\u89d2\u5ea6\u304b\u3089\u30c7\u30fc\u30bf\u3092\u63a2\u7d22\u3057\u3001\u30a4\u30f3\u30bf\u30e9\u30af\u30c6\u30a3\u30d6\u306a\u8996\u899a\u5316\u3092\u901a\u3058\u3066\u6d1e\u5bdf\u3092\u5f97\u308b\u3053\u3068\u304c\u5bb9\u6613\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u5206\u6790:<\/strong> MOLAP \u30b7\u30b9\u30c6\u30e0\u306f\u3001\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u307e\u305f\u306f\u307b\u307c\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u306e\u30c7\u30fc\u30bf\u66f4\u65b0\u3092\u30b5\u30dd\u30fc\u30c8\u3067\u304d\u308b\u305f\u3081\u3001\u4f01\u696d\u306f\u5165\u624b\u53ef\u80fd\u306a\u6700\u65b0\u60c5\u5831\u306b\u57fa\u3065\u3044\u3066\u30c7\u30fc\u30bf\u306b\u57fa\u3065\u3044\u305f\u610f\u601d\u6c7a\u5b9a\u3092\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u9ad8\u5ea6\u306a\u8a08\u7b97:<\/strong> MOLAP \u306f\u3001\u96c6\u8a08\u3001\u6bd4\u7387\u3001\u30e9\u30f3\u30ad\u30f3\u30b0\u3001\u6642\u9593\u30d9\u30fc\u30b9\u306e\u8a08\u7b97\u306a\u3069\u3001\u3055\u307e\u3056\u307e\u306a\u9ad8\u5ea6\u306a\u8a08\u7b97\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u308b\u305f\u3081\u3001\u30e6\u30fc\u30b6\u30fc\u306f\u30ab\u30b9\u30bf\u30e0 \u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u3092\u5fc5\u8981\u3068\u305b\u305a\u306b\u8907\u96d1\u306a\u5206\u6790\u3092\u5b9f\u884c\u3067\u304d\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u30c7\u30fc\u30bf\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u3068\u30a2\u30af\u30bb\u30b9\u5236\u5fa1:<\/strong> MOLAP \u30b7\u30b9\u30c6\u30e0\u306f\u5805\u7262\u306a\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u6a5f\u80fd\u3092\u63d0\u4f9b\u3057\u3001\u8a31\u53ef\u3055\u308c\u305f\u30e6\u30fc\u30b6\u30fc\u306e\u307f\u304c\u6a5f\u5bc6\u30c7\u30fc\u30bf\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n<\/li>\n<\/ol>\n<h2>\u591a\u6b21\u5143 OLAP (MOLAP) \u306e\u7a2e\u985e<\/h2>\n<p>MOLAP \u306f\u3001\u30c7\u30fc\u30bf\u306e\u4fdd\u5b58\u65b9\u6cd5\u3068\u30a2\u30af\u30bb\u30b9\u65b9\u6cd5\u306b\u57fa\u3065\u3044\u3066\u3001\u4e3b\u306b 2 \u3064\u306e\u30bf\u30a4\u30d7\u306b\u5206\u985e\u3067\u304d\u307e\u3059\u3002<\/p>\n<ol>\n<li>\n<p><strong>ROLAP (\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb OLAP):<\/strong> ROLAP \u3067\u306f\u3001\u30c7\u30fc\u30bf\u306f\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u4fdd\u5b58\u3055\u308c\u3001OLAP \u64cd\u4f5c\u306f\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066\u76f4\u63a5\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002\u67d4\u8edf\u6027\u304c\u3042\u308a\u3001\u5927\u898f\u6a21\u306a\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u51e6\u7406\u3067\u304d\u307e\u3059\u304c\u3001MOLAP \u3068\u6bd4\u8f03\u3059\u308b\u3068\u4f4e\u901f\u306b\u306a\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>MOLAP (\u591a\u6b21\u5143OLAP):<\/strong> MOLAP \u3067\u306f\u3001\u30c7\u30fc\u30bf\u306f\u4e8b\u524d\u306b\u96c6\u7d04\u3055\u308c\u3001\u591a\u6b21\u5143\u30ad\u30e5\u30fc\u30d6\u5f62\u5f0f\u3067\u4fdd\u5b58\u3055\u308c\u307e\u3059\u3002\u3053\u308c\u306b\u3088\u308a\u3001\u30af\u30a8\u30ea\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304c\u5411\u4e0a\u3057\u3001\u52b9\u7387\u7684\u306a\u30c7\u30fc\u30bf\u5206\u6790\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<\/li>\n<\/ol>\n<p>ROLAP \u3068 MOLAP \u306e\u9055\u3044\u3092\u307e\u3068\u3081\u305f\u8868\u306f\u6b21\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n<table>\n<thead>\n<tr>\n<th><\/th>\n<th>\u30ed\u30e9\u30c3\u30d7<\/th>\n<th>\u30e2\u30e9\u30c3\u30d7<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u30c7\u30fc\u30bf\u30b9\u30c8\u30ec\u30fc\u30b8<\/td>\n<td>\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30c6\u30fc\u30d6\u30eb<\/td>\n<td>\u591a\u6b21\u5143\u7acb\u65b9\u4f53<\/td>\n<\/tr>\n<tr>\n<td>\u30af\u30a8\u30ea\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9<\/td>\n<td>\u8907\u96d1\u306a\u30af\u30a8\u30ea\u306e\u5834\u5408\u306f\u9045\u304f\u306a\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059<\/td>\n<td>\u30af\u30a8\u30ea\u306e\u5fdc\u7b54\u6642\u9593\u306e\u77ed\u7e2e<\/td>\n<\/tr>\n<tr>\n<td>\u96c6\u8a08<\/td>\n<td>\u30af\u30a8\u30ea\u4e2d\u306b\u30aa\u30f3\u30b6\u30d5\u30e9\u30a4\u3067\u5b9f\u884c\u3055\u308c\u308b\u96c6\u8a08<\/td>\n<td>\u4e8b\u524d\u306b\u96c6\u8a08\u3055\u308c\u305f\u30c7\u30fc\u30bf\u306b\u3088\u308a\u30af\u30a8\u30ea\u3092\u9ad8\u901f\u5316<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\u591a\u6b21\u5143 OLAP (MOLAP) \u306e\u4f7f\u7528\u65b9\u6cd5\u3001\u554f\u984c\u3001\u304a\u3088\u3073\u89e3\u6c7a\u7b56<\/h2>\n<p>MOLAP \u306f\u3001\u6b21\u306e\u3088\u3046\u306a\u3055\u307e\u3056\u307e\u306a\u696d\u754c\u3084\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u5e45\u5e83\u304f\u4f7f\u7528\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<ol>\n<li>\n<p><strong>\u30d3\u30b8\u30cd\u30b9\u30a4\u30f3\u30c6\u30ea\u30b8\u30a7\u30f3\u30b9\u3068\u30ec\u30dd\u30fc\u30c8:<\/strong> MOLAP \u306f\u8a73\u7d30\u306a\u5206\u6790\u3068\u30ec\u30dd\u30fc\u30c8\u3092\u5bb9\u6613\u306b\u3057\u3001\u4f01\u696d\u304c\u50be\u5411\u3001\u30d1\u30bf\u30fc\u30f3\u3001\u6a5f\u4f1a\u3092\u7279\u5b9a\u3057\u3066\u610f\u601d\u6c7a\u5b9a\u30d7\u30ed\u30bb\u30b9\u3092\u6539\u5584\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u8ca1\u52d9\u5206\u6790\uff1a<\/strong> \u8ca1\u52d9\u30a2\u30ca\u30ea\u30b9\u30c8\u306f MOLAP \u3092\u4f7f\u7528\u3057\u3066\u8ca1\u52d9\u8a08\u753b\u3001\u4e88\u7b97\u7de8\u6210\u3001\u4e88\u6e2c\u3092\u5b9f\u884c\u3057\u3001\u7d44\u7e54\u304c\u3088\u308a\u512a\u308c\u305f\u8ca1\u52d9\u7ba1\u7406\u3092\u5b9f\u73fe\u3067\u304d\u308b\u3088\u3046\u306b\u652f\u63f4\u3057\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u30bb\u30fc\u30eb\u30b9\u3068\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\uff1a<\/strong> MOLAP \u306f\u3001\u8ca9\u58f2\u30c7\u30fc\u30bf\u3001\u9867\u5ba2\u884c\u52d5\u3001\u5e02\u5834\u52d5\u5411\u306e\u5206\u6790\u3092\u652f\u63f4\u3057\u3001\u30bf\u30fc\u30b2\u30c3\u30c8\u3092\u7d5e\u3063\u305f\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u6226\u7565\u3068\u58f2\u4e0a\u306e\u5897\u52a0\u306b\u3064\u306a\u304c\u308a\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u30b5\u30d7\u30e9\u30a4\u30c1\u30a7\u30fc\u30f3\u30de\u30cd\u30b8\u30e1\u30f3\u30c8\uff1a<\/strong> MOLAP \u306f\u3001\u5728\u5eab\u3001\u6d41\u901a\u3001\u9700\u8981\u30d1\u30bf\u30fc\u30f3\u3092\u5206\u6790\u3059\u308b\u3053\u3068\u306b\u3088\u308a\u3001\u30b5\u30d7\u30e9\u30a4 \u30c1\u30a7\u30fc\u30f3\u306e\u904b\u7528\u3092\u6700\u9069\u5316\u3059\u308b\u306e\u306b\u5f79\u7acb\u3061\u307e\u3059\u3002<\/p>\n<\/li>\n<\/ol>\n<p>\u305f\u3060\u3057\u3001MOLAP \u306f\u6b21\u306e\u3088\u3046\u306a\u8ab2\u984c\u306b\u76f4\u9762\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<ul>\n<li>\n<p><strong>\u30c7\u30fc\u30bf\u91cf:<\/strong> \u30c7\u30fc\u30bf\u304c\u5897\u52a0\u3059\u308b\u3068\u3001\u30ad\u30e5\u30fc\u30d6\u306e\u30b5\u30a4\u30ba\u304c\u5897\u52a0\u3057\u3001\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u554f\u984c\u304c\u767a\u751f\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u30c7\u30fc\u30bf\u306e\u9bae\u5ea6:<\/strong> \u4e00\u90e8\u306e MOLAP \u30b7\u30b9\u30c6\u30e0\u3067\u306f\u3001\u30c7\u30fc\u30bf\u3092\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u6700\u65b0\u306e\u72b6\u614b\u306b\u4fdd\u3064\u3053\u3068\u304c\u56f0\u96e3\u306a\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u30c7\u30fc\u30bf\u306e\u8907\u96d1\u3055:<\/strong> \u8907\u96d1\u306a\u30c7\u30fc\u30bf\u95a2\u4fc2\u3068\u968e\u5c64\u3092\u51e6\u7406\u3059\u308b\u306b\u306f\u3001\u614e\u91cd\u306a\u30e2\u30c7\u30ea\u30f3\u30b0\u304c\u5fc5\u8981\u306a\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<\/li>\n<\/ul>\n<p>\u3053\u308c\u3089\u306e\u8ab2\u984c\u306b\u5bfe\u3059\u308b\u89e3\u6c7a\u7b56\u306b\u306f\u3001\u30c7\u30fc\u30bf\u306e\u5206\u5272\u3001\u5897\u5206\u66f4\u65b0\u3001\u52b9\u7387\u7684\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u4f5c\u6210\u6226\u7565\u304c\u542b\u307e\u308c\u307e\u3059\u3002<\/p>\n<h2>\u4e3b\u306a\u7279\u5fb4\u3068\u985e\u4f3c\u7528\u8a9e\u3068\u306e\u6bd4\u8f03<\/h2>\n<p>MOLAP \u3092\u4ed6\u306e\u95a2\u9023\u7528\u8a9e\u3084\u30c6\u30af\u30ce\u30ed\u30b8\u30fc\u3068\u6bd4\u8f03\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n<table>\n<thead>\n<tr>\n<th><\/th>\n<th>\u591a\u6b21\u5143 OLAP (MOLAP)<\/th>\n<th>\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb OLAP (ROLAP)<\/th>\n<th>OLTP (\u30aa\u30f3\u30e9\u30a4\u30f3 \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u51e6\u7406)<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u30c7\u30fc\u30bf\u30b9\u30c8\u30ec\u30fc\u30b8<\/td>\n<td>\u591a\u6b21\u5143\u7acb\u65b9\u4f53<\/td>\n<td>\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30c6\u30fc\u30d6\u30eb<\/td>\n<td>\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30c6\u30fc\u30d6\u30eb<\/td>\n<\/tr>\n<tr>\n<td>\u30af\u30a8\u30ea\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9<\/td>\n<td>\u3082\u3063\u3068\u65e9\u304f<\/td>\n<td>\u8907\u96d1\u306a\u30af\u30a8\u30ea\u306e\u5834\u5408\u306f\u9045\u304f\u306a\u308a\u307e\u3059<\/td>\n<td>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u51e6\u7406\u7528\u306b\u6700\u9069\u5316<\/td>\n<\/tr>\n<tr>\n<td>\u76ee\u7684<\/td>\n<td>\u5206\u6790\u51e6\u7406<\/td>\n<td>\u5206\u6790\u51e6\u7406<\/td>\n<td>\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u51e6\u7406<\/td>\n<\/tr>\n<tr>\n<td>\u4f7f\u7528\u4e8b\u4f8b<\/td>\n<td>\u8907\u96d1\u306a\u30c7\u30fc\u30bf\u5206\u6790<\/td>\n<td>\u5927\u898f\u6a21\u306a\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306e\u5206\u6790<\/td>\n<td>\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u51e6\u7406<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\u591a\u6b21\u5143 OLAP (MOLAP) \u306b\u95a2\u3059\u308b\u5c55\u671b\u3068\u5c06\u6765\u306e\u6280\u8853<\/h2>\n<p>\u30c6\u30af\u30ce\u30ed\u30b8\u30fc\u304c\u9032\u5316\u3057\u7d9a\u3051\u308b\u306b\u3064\u308c\u3066\u3001MOLAP \u306e\u5c06\u6765\u306b\u306f\u6709\u671b\u306a\u767a\u5c55\u304c\u671f\u5f85\u3055\u308c\u307e\u3059\u3002 MOLAP \u306b\u95a2\u9023\u3059\u308b\u6f5c\u5728\u7684\u306a\u5c06\u6765\u306e\u30c8\u30ec\u30f3\u30c9\u3068\u30c6\u30af\u30ce\u30ed\u30b8\u306b\u306f\u6b21\u306e\u3088\u3046\u306a\u3082\u306e\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<ol>\n<li>\n<p><strong>\u30a4\u30f3\u30e1\u30e2\u30ea\u30b3\u30f3\u30d4\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0:<\/strong> \u30a4\u30f3\u30e1\u30e2\u30ea \u30b3\u30f3\u30d4\u30e5\u30fc\u30c6\u30a3\u30f3\u30b0\u6280\u8853\u3092\u6d3b\u7528\u3059\u308b\u3068\u3001MOLAP \u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304c\u3055\u3089\u306b\u5411\u4e0a\u3057\u3001\u30af\u30a8\u30ea\u306e\u5fdc\u7b54\u6642\u9593\u3092\u5927\u5e45\u306b\u77ed\u7e2e\u3067\u304d\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u9ad8\u5ea6\u306a\u5206\u6790\u306e\u7d71\u5408:<\/strong> \u6a5f\u68b0\u5b66\u7fd2\u3084\u4eba\u5de5\u77e5\u80fd\u306a\u3069\u306e\u9ad8\u5ea6\u306a\u5206\u6790\u30c4\u30fc\u30eb\u3068\u306e\u7d71\u5408\u306b\u3088\u308a\u3001\u3088\u308a\u6d17\u7df4\u3055\u308c\u305f\u30c7\u30fc\u30bf\u5206\u6790\u3068\u4e88\u6e2c\u6a5f\u80fd\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u30af\u30e9\u30a6\u30c9\u30d9\u30fc\u30b9\u306eMOLAP:<\/strong> \u30af\u30e9\u30a6\u30c9\u306e MOLAP \u306f\u30b9\u30b1\u30fc\u30e9\u30d3\u30ea\u30c6\u30a3\u3001\u67d4\u8edf\u6027\u3001\u30b3\u30b9\u30c8\u52b9\u7387\u3092\u63d0\u4f9b\u3057\u3001\u3088\u308a\u5e45\u5e83\u3044\u30e6\u30fc\u30b6\u30fc\u304c\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u30c7\u30fc\u30bf\u306e\u30d7\u30e9\u30a4\u30d0\u30b7\u30fc\u3068\u30ac\u30d0\u30ca\u30f3\u30b9:<\/strong> \u5c06\u6765\u306e MOLAP \u30b7\u30b9\u30c6\u30e0\u306f\u3001\u30c7\u30fc\u30bf\u306e\u30d7\u30e9\u30a4\u30d0\u30b7\u30fc\u3068\u30ac\u30d0\u30ca\u30f3\u30b9\u3092\u512a\u5148\u3057\u3001\u30c7\u30fc\u30bf\u4fdd\u8b77\u898f\u5236\u3078\u306e\u30b3\u30f3\u30d7\u30e9\u30a4\u30a2\u30f3\u30b9\u3092\u78ba\u4fdd\u3057\u307e\u3059\u3002<\/p>\n<\/li>\n<\/ol>\n<h2>\u30d7\u30ed\u30ad\u30b7 \u30b5\u30fc\u30d0\u30fc\u306e\u4f7f\u7528\u65b9\u6cd5\u307e\u305f\u306f\u591a\u6b21\u5143 OLAP (MOLAP) \u3068\u306e\u95a2\u9023\u4ed8\u3051\u65b9\u6cd5<\/h2>\n<p>OneProxy \u306b\u3088\u3063\u3066\u63d0\u4f9b\u3055\u308c\u308b\u30d7\u30ed\u30ad\u30b7 \u30b5\u30fc\u30d0\u30fc\u306a\u3069\u306e\u30d7\u30ed\u30ad\u30b7 \u30b5\u30fc\u30d0\u30fc\u306f\u3001\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u901a\u4fe1\u306e\u4fdd\u8b77\u3068\u6700\u9069\u5316\u306b\u304a\u3044\u3066\u91cd\u8981\u306a\u5f79\u5272\u3092\u679c\u305f\u3057\u307e\u3059\u3002 MOLAP \u306e\u5185\u90e8\u69cb\u9020\u3084\u6a5f\u80fd\u306b\u306f\u76f4\u63a5\u95a2\u4fc2\u3057\u307e\u305b\u3093\u304c\u3001\u30d7\u30ed\u30ad\u30b7 \u30b5\u30fc\u30d0\u30fc\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u6b21\u306e\u65b9\u6cd5\u3067 MOLAP \u306e\u4f7f\u7528\u3092\u5f37\u5316\u3067\u304d\u307e\u3059\u3002<\/p>\n<ol>\n<li>\n<p><strong>\u30c7\u30fc\u30bf\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\uff1a<\/strong> \u30d7\u30ed\u30ad\u30b7 \u30b5\u30fc\u30d0\u30fc\u306f\u3001MOLAP \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3068\u30b5\u30fc\u30d0\u30fc\u306e\u9593\u306e\u4ef2\u4ecb\u8005\u3068\u3057\u3066\u6a5f\u80fd\u3057\u3001\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306e\u5b9f\u969b\u306e IP \u30a2\u30c9\u30ec\u30b9\u3092\u30de\u30b9\u30af\u3057\u3066\u4e0d\u6b63\u30a2\u30af\u30bb\u30b9\u304b\u3089\u4fdd\u8b77\u3059\u308b\u3053\u3068\u306b\u3088\u308a\u3001\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u5c64\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u30ad\u30e3\u30c3\u30b7\u30f3\u30b0\uff1a<\/strong> \u30d7\u30ed\u30ad\u30b7 \u30b5\u30fc\u30d0\u30fc\u306f\u3001\u983b\u7e41\u306b\u8981\u6c42\u3055\u308c\u308b\u30c7\u30fc\u30bf\u3092\u30ad\u30e3\u30c3\u30b7\u30e5\u3067\u304d\u308b\u305f\u3081\u3001MOLAP \u30b5\u30fc\u30d0\u30fc\u306e\u8ca0\u8377\u304c\u8efd\u6e1b\u3055\u308c\u3001\u30e6\u30fc\u30b6\u30fc\u306e\u30af\u30a8\u30ea \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304c\u5411\u4e0a\u3057\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u8ca0\u8377\u5206\u6563:<\/strong> \u30d7\u30ed\u30ad\u30b7 \u30b5\u30fc\u30d0\u30fc\u306f\u3001\u7740\u4fe1\u8981\u6c42\u3092\u8907\u6570\u306e MOLAP \u30b5\u30fc\u30d0\u30fc\u306b\u5206\u6563\u3057\u3001\u30ea\u30bd\u30fc\u30b9\u306e\u52b9\u7387\u7684\u306a\u5229\u7528\u3092\u4fdd\u8a3c\u3057\u3001\u30b5\u30fc\u30d0\u30fc\u306e\u904e\u8ca0\u8377\u3092\u9632\u3050\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<\/li>\n<li>\n<p><strong>\u30a2\u30af\u30bb\u30b9\u5236\u5fa1\uff1a<\/strong> \u30d7\u30ed\u30ad\u30b7 \u30b5\u30fc\u30d0\u30fc\u306f\u30a2\u30af\u30bb\u30b9 \u30b3\u30f3\u30c8\u30ed\u30fc\u30eb \u30dd\u30ea\u30b7\u30fc\u3092\u9069\u7528\u3057\u3001\u8a31\u53ef\u3055\u308c\u305f\u30e6\u30fc\u30b6\u30fc\u306e\u307f\u304c MOLAP \u30b7\u30b9\u30c6\u30e0\u306b\u63a5\u7d9a\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n<\/li>\n<\/ol>\n<h2>\u95a2\u9023\u30ea\u30f3\u30af<\/h2>\n<p>Multi-Dimensional OLAP (MOLAP) \u304a\u3088\u3073\u95a2\u9023\u30c6\u30af\u30ce\u30ed\u30b8\u306e\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u6b21\u306e\u30ea\u30bd\u30fc\u30b9\u3092\u53c2\u7167\u3059\u308b\u3053\u3068\u3092\u691c\u8a0e\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<ul>\n<li><a href=\"https:\/\/www.example.com\/molap-intro\" target=\"_new\" rel=\"noopener nofollow\">\u30ea\u30f3\u30af1<\/a><\/li>\n<li><a href=\"https:\/\/www.example.com\/molap-vs-rolap\" target=\"_new\" rel=\"noopener nofollow\">\u30ea\u30f3\u30af2<\/a><\/li>\n<li><a href=\"https:\/\/www.example.com\/molap-cloud-usage\" target=\"_new\" rel=\"noopener nofollow\">\u30ea\u30f3\u30af3<\/a><\/li>\n<li><a href=\"https:\/\/www.example.com\/proxy-security\" target=\"_new\" rel=\"noopener nofollow\">\u30ea\u30f3\u30af4<\/a><\/li>\n<\/ul>\n<p>Multi-Dimensional OLAP (MOLAP) \u306f\u9032\u5316\u3057\u7d9a\u3051\u3066\u304a\u308a\u3001\u3053\u306e\u5206\u91ce\u306e\u6700\u65b0\u306e\u9032\u6b69\u3092\u5e38\u306b\u6700\u65b0\u306e\u72b6\u614b\u306b\u4fdd\u3064\u3053\u3068\u3067\u3001\u3053\u306e\u5f37\u529b\u306a\u30c7\u30fc\u30bf\u5206\u6790\u30c6\u30af\u30ce\u30ed\u30b8\u3092\u6700\u5927\u9650\u306b\u6d3b\u7528\u3067\u304d\u308b\u3053\u3068\u3092\u5fd8\u308c\u306a\u3044\u3067\u304f\u3060\u3055\u3044\u3002<\/p>","protected":false},"featured_media":468949,"menu_order":0,"template":"","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"footnotes":""},"class_list":["post-478075","wiki","type-wiki","status-publish","has-post-thumbnail","hentry"],"acf":{"faq_title":"Frequently Asked Questions about <mark>Multi-Dimensional OLAP (MOLAP): An Overview<\/mark>","faq_items":[{"question":"What is Multi-Dimensional OLAP (MOLAP)?","answer":"<p><strong>Answer:<\/strong> Multi-Dimensional OLAP (MOLAP) is a specialized database management system used for data analysis and business intelligence. It organizes data in multidimensional cubes, allowing users to perform complex queries and gain insights from different perspectives. MOLAP is optimized for high performance and real-time analysis, making it a valuable tool for decision-making processes.<\/p>"},{"question":"How did Multi-Dimensional OLAP (MOLAP) originate?","answer":"<p><strong>Answer:<\/strong> The concept of OLAP was introduced by Dr. E.F. Codd in the 1970s. However, MOLAP gained widespread attention in the 1990s as a powerful technology for data analysis. Driven by the need to efficiently handle large datasets and facilitate multidimensional exploration, MOLAP became an essential tool in the world of business intelligence.<\/p>"},{"question":"How does Multi-Dimensional OLAP (MOLAP) work internally?","answer":"<p><strong>Answer:<\/strong> MOLAP works by organizing data in multidimensional cubes, each containing dimensions, measures, and hierarchies. Dimensions represent attributes like time, location, or product categories, while measures are the numerical data being analyzed. Hierarchies define relationships between different levels of dimensions, facilitating intuitive data exploration.<\/p>"},{"question":"What are the key features of Multi-Dimensional OLAP (MOLAP)?","answer":"<p><strong>Answer:<\/strong> MOLAP offers high performance, intuitive data exploration, real-time analysis capabilities, advanced calculations, and robust data security. These features enable users to quickly analyze large datasets, gain insights from various perspectives, and make data-driven decisions efficiently and securely.<\/p>"},{"question":"What types of Multi-Dimensional OLAP (MOLAP) exist?","answer":"<p><strong>Answer:<\/strong> There are two main types of MOLAP: ROLAP (Relational OLAP) and MOLAP (Multidimensional OLAP). ROLAP stores data in relational databases and performs OLAP operations directly on database tables, while MOLAP stores data in pre-aggregated multidimensional cubes for faster query performance.<\/p>"},{"question":"How can Multi-Dimensional OLAP (MOLAP) be used, and what challenges may arise?","answer":"<p><strong>Answer:<\/strong> MOLAP is used for business intelligence, financial analysis, sales and marketing, and supply chain management. Challenges can arise due to increasing data volume, data freshness, and data complexity. Solutions involve data partitioning, incremental updates, and efficient indexing strategies.<\/p>"},{"question":"How does the future of Multi-Dimensional OLAP (MOLAP) look like?","answer":"<p><strong>Answer:<\/strong> The future of MOLAP holds promising developments, such as in-memory computing, advanced analytics integration, cloud-based solutions, and increased focus on data privacy and governance. These advancements will further enhance MOLAP's capabilities and utility in the business intelligence landscape.<\/p>"},{"question":"How are proxy servers associated with Multi-Dimensional OLAP (MOLAP)?","answer":"<p><strong>Answer:<\/strong> Proxy servers, like those provided by OneProxy, enhance MOLAP usage by adding an extra layer of security, caching frequently requested data, load balancing, and enforcing access control policies. They contribute to a secure and optimized MOLAP experience.<\/p><hr><p>Note: The provided questions and answers are based on the content of the previous article on Multi-Dimensional OLAP (MOLAP) for the website of OneProxy. The FAQ format aims to address common inquiries users may have about the topic.<\/p>"}]},"_links":{"self":[{"href":"https:\/\/oneproxy.pro\/jp\/wp-json\/wp\/v2\/wiki\/478075","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneproxy.pro\/jp\/wp-json\/wp\/v2\/wiki"}],"about":[{"href":"https:\/\/oneproxy.pro\/jp\/wp-json\/wp\/v2\/types\/wiki"}],"version-history":[{"count":0,"href":"https:\/\/oneproxy.pro\/jp\/wp-json\/wp\/v2\/wiki\/478075\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oneproxy.pro\/jp\/wp-json\/wp\/v2\/media\/468949"}],"wp:attachment":[{"href":"https:\/\/oneproxy.pro\/jp\/wp-json\/wp\/v2\/media?parent=478075"}],"curies":[{"name":"\u3046\u30fc\u3093","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}