{"id":791,"date":"2018-12-10T18:52:52","date_gmt":"2018-12-10T09:52:52","guid":{"rendered":"https:\/\/itport.cloud\/?p=791"},"modified":"2018-12-10T21:54:06","modified_gmt":"2018-12-10T12:54:06","slug":"post-791","status":"publish","type":"post","link":"https:\/\/itport.cloud\/?p=791","title":{"rendered":"\uff08\u7b2c2\u56de\uff09\u30aa\u30f3\u30d7\u30ec\u30df\u30b9RDB\u3067\u306e\u30d3\u30c3\u30b0\u30c7\u30fc\u30bf\u306e\u84c4\u7a4d\u3010\u30c7\u30fc\u30bf\u91cf\u898b\u7a4d\u308a \u7de8\u3011"},"content":{"rendered":"<div>\n<h1 id=\"e79baee6aca1-1\">\u76ee\u6b21<\/h1>\n<div><a href=\"#RDB_1\">\u524d\u56de\u306e\u304a\u3055\u3089\u3044(\u524d\u63d0\u6761\u4ef6)<\/a><\/div>\n<div><a href=\"#RDB_2\">\u691c\u8a3c\u74b0\u5883\u306b\u3064\u3044\u3066<\/a><\/div>\n<div><a href=\"#RDB_3\">\u30c6\u30fc\u30d6\u30eb\u69cb\u6210\u306b\u3064\u3044\u3066<\/a><\/div>\n<div><a href=\"#RDB_4\">\u30d2\u30fc\u30d7\u30c7\u30fc\u30bf\u91cf\u306e\u63a8\u5b9a<\/a><\/div>\n<div><a href=\"#RDB_5\">\u4ed6RDBS\u3067\u306e\u30c7\u30fc\u30bf\u91cf\u63a8\u5b9a<\/a><\/div>\n<div><a href=\"#RDB_6\">\u304a\u308f\u308a\u306b<\/a><\/div>\n<h1 id=\"e5898de59b9ee381aee3818ae38195e38289e38184e5898de68f90e69da1e4bbb6-2\"><a id=\"RDB_1\"><\/a>\u524d\u56de\u306e\u304a\u3055\u3089\u3044(\u524d\u63d0\u6761\u4ef6)<\/h1>\n<div>\n<p>\u524d\u56de\u3001\u691c\u8a3c\u3092\u9032\u3081\u308b\u306b\u3042\u305f\u308a\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u6761\u4ef6\u3092\u60f3\u5b9a\u3057\u307e\u3057\u305f\u3002<\/p>\n<\/div>\n<ul>\n<li>\u88fd\u9020\u696d\u306e\u4f01\u696d<\/li>\n<li>\u5168\u56fd\u306b10\u7b87\u6240\u306e\u751f\u7523\u30e9\u30a4\u30f3\u5de5\u5834\u3092\u6301\u3064<\/li>\n<li>\u5de5\u5834\u306f24\u6642\u9593\u7a3c\u50cd<\/li>\n<li>\u5de5\u5834\u3067\u7a3c\u50cd\u3059\u308b\u30bb\u30f3\u30b5\u306e\u30c7\u30fc\u30bf\u3092\u53ce\u96c6\u3057\u3001\u9577\u671f\u7684(10\uff5e20\u5e74)\u306b\u30c7\u30fc\u30bf\u3092\u84c4\u7a4d\u3057\u3001\u52b9\u7387\u7684\u306a\u7a3c\u52d5\u3092\u5206\u6790\u3059\u308b\u305f\u3081\u306b\u30c7\u30fc\u30bf\u3092\u5229\u7528\u3057\u305f\u3044<\/li>\n<li>\u53ce\u96c6\u3059\u308b\u30bb\u30f3\u30b5\u30c7\u30fc\u30bf\u306e\u751f\u6210\u983b\u5ea6\u306f\uff11\u5206\u3068\u3057\u3001\u30bb\u30f3\u30b5\u306e\u6570\u306f3000\u500b\/1\u5de5\u5834<\/li>\n<li>\u30c7\u30fc\u30bf\u306f\u975e\u69cb\u9020\u5316\u30c7\u30fc\u30bf<\/li>\n<li>\u5de5\u5834\u306e\u30b7\u30b9\u30c6\u30e0\u3068\u63a5\u7d9a\u3059\u308b\u305f\u3081\u3001\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u9762\u304b\u3089\u30aa\u30d5\u30e9\u30a4\u30f3\u74b0\u5883\uff08\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u63a5\u7d9a\u306f\u3057\u306a\u3044\uff09\u3068\u3059\u308b<\/li>\n<\/ul>\n<div>\u4eca\u56de\u306f\u3001\u3053\u308c\u3089\u306e\u6761\u4ef6\u304b\u3089\u3069\u308c\u304f\u3089\u3044\u306e\u30c7\u30fc\u30bf\u91cf\u3068\u306a\u308b\u304b\u30c7\u30fc\u30bf\u91cf\u306e\u898b\u7a4d\u308a\u3092\u3057\u3066\u307f\u307e\u3059\u3002<\/div>\n<h1 id=\"e6a49ce8a8bce792b0e5a283e381abe381a4e38184e381a6-3\"><a id=\"RDB_2\"><\/a>\u691c\u8a3c\u74b0\u5883\u306b\u3064\u3044\u3066<\/h1>\n<div>\n<p>\u672c\u30c6\u30fc\u30de\u3067\u306f\u691c\u8a3c\u3059\u308b\u306b\u3042\u305f\u3063\u3066\u3001RDBS\u3092SQLServer2016 Developer Edition(Enterprise Edition\u3068\u540c\u7b49)\u3092\u4f7f\u7528\u3057\u3066\u3044\u304d\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>\u30aa\u30f3\u30d7\u30ec\u30df\u30b9RDBS\u306fOracle\u3001MySQL\u3001PostgreSQL\u7b49\u30fb\u30fb\u30fb\u69d8\u3005\u3042\u308b\u304c\u3001\u79c1\u81ea\u8eab\u304cSQLServer\u3092\u4f7f\u3046\u6a5f\u4f1a\u304c\u591a\u304b\u3063\u305f\u3053\u3068\u304c\u3042\u308a\u3001\u4eca\u56de\u306fSQLServer\u3092\u4e3b\u8ef8\u3068\u3057\u3066\u691c\u8a3c\u3059\u308b\u304c\u3001\u4ed6DBMS\u3067\u3082\u540c\u7b49\u306e\u6a5f\u80fd\u306a\u3069\u304c\u3042\u308c\u3070\u30d4\u30c3\u30af\u30a2\u30c3\u30d7\u3057\u3066\u7d39\u4ecb\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n<\/div>\n<div><\/div>\n<div style=\"text-align: center;\">\n<table style=\"border-collapse: collapse; width: 39.6722%; height: 66px;\" border=\"1\">\n<tbody>\n<tr>\n<td style=\"width: 17.5665%; text-align: center;\">OS<\/td>\n<td style=\"width: 82.4335%;text-align: center;\">Windows Server2016<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 17.5665%; text-align: center;\">DBMS<\/td>\n<td style=\"width: 82.4335%; text-align: center;\">SQLServer2016 Developer Edition<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div><\/div>\n<h1 id=\"e38386e383bce38396e383abe6a78be68890e381abe381a4e38184e381a6-4\"><a id=\"RDB_3\"><\/a>\u30c6\u30fc\u30d6\u30eb\u69cb\u6210\u306b\u3064\u3044\u3066<\/h1>\n<div>\u30bb\u30f3\u30b5\u30c7\u30fc\u30bf\u3092\u683c\u7d0d\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u69cb\u6210\u3068\u3057\u307e\u3059\u3002<\/div>\n<div>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nCREATE TABLE DataTable (\r\n    plant_id as varchar(2) NOT NULL,       --\u5de5\u5834ID\r\n    sampling_at as smalldatetime NOT NULL, --\u53d6\u5f97\u65e5\u6642\r\n    sensor_name as varchar(15) NOT NULL,   --\u30bb\u30f3\u30b5\u540d\r\n    valueasdecimal(15,3),                  --\u5024\r\n    CONSTRAINT &#x5B;DataTablePK] PRIMARYKEY CLUSTERED\r\n    (\r\n        plant_id,\r\n        sampling_at,\r\n        sensor_name\r\n    )\r\n);\r\n<\/pre>\n<\/div>\n<div>(\u30c6\u30fc\u30d6\u30eb\u30a4\u30e1\u30fc\u30b8)<\/div>\n<div>\n<table style=\"border-collapse: collapse; width: 66.8853%;\" border=\"1\">\n<tbody>\n<tr>\n<td style=\"width: 12.8689%; text-align: center;\"><strong>plant_id <\/strong><\/td>\n<td style=\"width: 21.3935%; text-align: center;\"><strong>sampling_at <\/strong><\/td>\n<td style=\"width: 18.2241%; text-align: center;\"><strong>sensor_name<\/strong><\/td>\n<td style=\"width: 14.3988%; text-align: center;\"><strong>value<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 12.8689%; text-align: center;\">01<\/td>\n<td style=\"width: 21.3935%; text-align: center;\">2018-12-01 00:00:00<\/td>\n<td style=\"width: 18.2241%; text-align: center;\">Sensor_0001<\/td>\n<td style=\"width: 14.3988%; text-align: center;\">12.345<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 12.8689%; text-align: center;\">01<\/td>\n<td style=\"width: 21.3935%; text-align: center;\">2018-12-01 00:01:00<\/td>\n<td style=\"width: 18.2241%; text-align: center;\">Sensor_0001<\/td>\n<td style=\"width: 14.3988%; text-align: center;\">13.456<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div><\/div>\n<div>\u5de5\u5834ID\u3068\u6642\u7cfb\u5217\u3068\u30bb\u30f3\u30b5\u540d\u3092\u30ad\u30fc\u306b\u30c7\u30fc\u30bf\u3092\u84c4\u7a4d\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/div>\n<h1 id=\"e38392e383bce38397e38387e383bce382bfe9878fe381aee68ea8e5ae9a-5\"><a id=\"RDB_4\"><\/a>\u30d2\u30fc\u30d7\u30c7\u30fc\u30bf\u91cf\u306e\u63a8\u5b9a<\/h1>\n<div>\n<p>\u4eca\u56de\u306f\u3001\u4e0a\u8a18\u306e\u30c6\u30fc\u30d6\u30eb\u69cb\u6210\u3067\u30c7\u30fc\u30bf\u3092\u84c4\u7a4d\u3059\u308b\u3068\u8003\u3048\u3001\u30c7\u30fc\u30bf\u91cf\u304c\u3069\u308c\u307b\u3069\u3068\u306a\u308b\u306e\u304b\u3092\u63a8\u5b9a\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>\u307e\u305a\u306f\u30d2\u30fc\u30d7\u306e\u30c7\u30fc\u30bf\u91cf\u3092\u63a8\u5b9a\u3057\u307e\u3059\u3002<br \/>\n<a href =\"https:\/\/docs.microsoft.com\/ja-jp\/sql\/relational-databases\/indexes\/heaps-tables-without-clustered-indexes?view=sql-server-2016\">\u30d2\u30fc\u30d7<\/a>\u3068\u306f\u3001\u30af\u30e9\u30b9\u30bf\u30fc\u5316\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4f7f\u7528\u3057\u306a\u3044\u30c6\u30fc\u30d6\u30eb\u306e\u3053\u3068\u3092\u6307\u3057\u307e\u3059\u3002<\/p>\n<\/div>\n<div>\u30af\u30e9\u30b9\u30bf\u30fc\u5316\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4f7f\u7528\u3057\u306a\u3044\u3068\u3044\u3046\u3053\u3068\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u306b\u9806\u4e0d\u540c\u3067\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<br \/>\n\u4e0a\u8a18\u306e\u30c6\u30fc\u30d6\u30eb\u69cb\u6210\u3067\u3042\u308c\u3070\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc\u3092\u4f7f\u7528\u3057\u3066\u3044\u306a\u3044\u72b6\u614b\u306b\u306a\u308a\u307e\u3059\u3002<br \/>\n\u3064\u307e\u308a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9(\u7d22\u5f15)\u3092\u542b\u307e\u306a\u3044\u5358\u7d14\u306a\u30c7\u30fc\u30bf\u91cf\u3092\u898b\u7a4d\u308a\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/div>\n<h5 id=\"1-e683b3e5ae9ae383ace382b3e383bce38389e695b0-6\">1. \u60f3\u5b9a\u30ec\u30b3\u30fc\u30c9\u6570<\/h5>\n<div>\n<p>\u30ec\u30b3\u30fc\u30c9\u6570\u306f\u3001<\/p>\n<\/div>\n<ul>\n<li>\u751f\u6210\u983b\u5ea6\u304c\uff11\u5206<\/li>\n<li>24\u6642\u9593\u7a3c\u50cd<\/li>\n<li>10\u7b87\u6240\u306e\u5de5\u5834<\/li>\n<li>\u30bb\u30f3\u30b5\u306e\u6570\u306f3000\u500b\/1\u5de5\u5834<\/li>\n<li>\u5c11\u306a\u304f\u3068\u308210\u5e74\u9593\u306e\u30c7\u30fc\u30bf\u3092\u84c4\u7a4d<\/li>\n<\/ul>\n<div>\u306e\u6761\u4ef6\u304b\u3089\u3001<br \/>\n<strong>Num_Rows(\u30ec\u30b3\u30fc\u30c9\u6570) = ((24 * 60) \u00d7 (365 \u00d7 10)) \u00d7 (3000 \u00d7 10) = 157,680,000,000\u30ec\u30b3\u30fc\u30c9 (\u7d041500\u5104\u30ec\u30b3\u30fc\u30c9)<\/strong><\/div>\n<h5 id=\"2-nulle58886e381aee7a2bae4bf9de9a098e59f9f-7\">2. NULL\u5206\u306e\u78ba\u4fdd\u9818\u57df<\/h5>\n<div>\n<p>\u5404\u5217\u306eNULL\u5206\u3092\u78ba\u4fdd\u3059\u308b\u9818\u57df\u304c\u4e88\u7d04\u3055\u308c\u308b\u305f\u3081\u3001\u4ee5\u4e0b\u306e\u5bb9\u91cf\u304c\u5fc5\u8981\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n<p><strong>NULL_Bitmap(NULL\u4e88\u7d04\u9818\u57df) = 2 + ((\u5217(\u56fa\u5b9a\u9577\u304a\u3088\u3073\u53ef\u5909\u9577)\u306e\u7dcf\u6570) + 7) \/ 8)<\/strong><br \/>\n<strong>= 2 + ((4 + 7) \/ 8) = 3.375<\/strong><\/p>\n<p>\u5c0f\u6570\u90e8\u306f\u7121\u8996\u3055\u308c\u308b\u306e\u3067\u3001NULL_Bitmap = 3\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n<\/div>\n<h5 id=\"3-e8a18ce38182e3819fe3828ae381aee38387e383bce382bfe9878f-8\">3. \u884c\u3042\u305f\u308a\u306e\u30c7\u30fc\u30bf\u91cf<\/h5>\n<div>\n<p>\u56fa\u5b9a\u9577\u5217\u306e\u5408\u8a08\u30d0\u30a4\u30c8\u30b5\u30a4\u30ba\u306f\u4ee5\u4e0b\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n<p><strong>plant_id : varchar(2) = 2 + 2 = 4 byte<\/strong><br \/>\n<strong>sampling_at : smalldatetime = 4 byte<\/strong><br \/>\n<strong>sensor_name : varchar(15) = 15 + 2 = 17 byte<\/strong><\/p>\n<p><strong>Fixed_Data_Size(\u56fa\u5b9a\u9577\u5217\u306e\u5408\u8a08\u30d0\u30a4\u30c8\u30b5\u30a4\u30ba) = 4 + 4 + 17 = 25 byte<\/strong><\/p>\n<p>decimal\u578b\u306f\u53ef\u5909\u9577\u578b\u306a\u306e\u3067\u3001\u6700\u5927\u30b5\u30a4\u30ba\u3092\u8003\u616e\u3057\u3066\u4ee5\u4e0b\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n<p><strong>value : decimal(15,3) = 2 + (1(\u53ef\u5909\u9577\u5217\u6570) \u00d7 2) + 18 = 22 byte<\/strong><\/p>\n<p><strong>Variable_Data_Size(\u53ef\u5909\u9577\u5217\u306e\u6700\u5927\u30d0\u30a4\u30c8\u30b5\u30a4\u30ba) = 22 byte<\/strong><\/p>\n<p><strong>Row_Size(1\u884c\u3042\u305f\u308a\u306e\u30c7\u30fc\u30bf\u91cf) = Fixed_Data_Size + Variable_Data_Size + NULL_Bitmap + \u884c\u30d8\u30c3\u30c0\u30aa\u30fc\u30d0\u30d8\u30c3\u30c9(4 byte)<\/strong><br \/>\n<strong>= 25 + 22 + 3 + 4 = 54 byte<\/strong><\/p>\n<\/div>\n<h5 id=\"4-1e3839ae383bce382b8e38182e3819fe3828ae381aee8a18ce695b0-9\">4. 1\u30da\u30fc\u30b8\u3042\u305f\u308a\u306e\u884c\u6570<\/h5>\n<div>\u30d2\u30fc\u30d7\u306e\u30c7\u30fc\u30bf\u306f\u30da\u30fc\u30b8\u5358\u4f4d\u3067\u8a08\u7b97\u3057\u307e\u3059\u3002<br \/>\n1\u30da\u30fc\u30b8\u3042\u305f\u308a\u306b\u683c\u7d0d\u3067\u304d\u308b\u30c7\u30fc\u30bf\u91cf\u306f8096 byte\u3067\u3059\u3002<br \/>\n\u307e\u305f\u3001\u884c\u306f\u8907\u6570\u306e\u30da\u30fc\u30b8\u306b\u307e\u305f\u304c\u308b\u3053\u3068\u306f\u3067\u304d\u306a\u3044\u306e\u3067\u3001\u5c0f\u6570\u4ee5\u4e0b\u306f\u5207\u308a\u6368\u3066\u307e\u3059\u3002<\/div>\n<div>\n<p><strong>Row_Per_Page(1\u30da\u30fc\u30b8\u3042\u305f\u308a\u306e\u884c\u6570) = 8096 \/ (Row_Size + 2)<br \/>\n<\/strong><strong>= 8096 \/ (54 + 2) = 144.57 = 144\u884c\/\u30da\u30fc\u30b8<\/strong><\/p>\n<\/div>\n<h5 id=\"5-e38199e381b9e381a6e381aee8a18ce38292e6a0bce7b48de38199e3828be3839ae383bce382b8e695b0-10\">5. \u3059\u3079\u3066\u306e\u884c\u3092\u683c\u7d0d\u3059\u308b\u30da\u30fc\u30b8\u6570<\/h5>\n<div>\n<p>\u5168\u30c7\u30fc\u30bf\u3092\u683c\u7d0d\u3059\u308b\u305f\u3081\u306e\u30da\u30fc\u30b8\u6570\u3092\u8a08\u7b97\u3057\u307e\u3059\u3002<\/p>\n<p><strong>Num_Pages(\u5168\u30da\u30fc\u30b8\u6570) = Num_Rows \/ Row_Per_Page<\/strong><br \/>\n<strong>= 157,680,000,000 \/ 144 = 1,095,000,000 \u30da\u30fc\u30b8 (\u7d0410\u5104\u30da\u30fc\u30b8)<\/strong><\/p>\n<\/div>\n<h5 id=\"6-e38392e383bce38397e381abe38387e383bce382bfe38292e6a0bce7b48de38199e3828be3819fe38281e381abe5bf85e8a681e381aae9a098e59f9f-11\">6. \u30d2\u30fc\u30d7\u306b\u30c7\u30fc\u30bf\u3092\u683c\u7d0d\u3059\u308b\u305f\u3081\u306b\u5fc5\u8981\u306a\u9818\u57df<\/h5>\n<div>\n<p>1\u30da\u30fc\u30b8\u5f53\u305f\u308a\u306e\u7dcf\u30d0\u30a4\u30c8\u6570\u306f8192 byte\u306a\u306e\u3067\u3001<\/p>\n<p><strong>\u30d2\u30fc\u30d7\u306e\u30b5\u30a4\u30ba (\u30d0\u30a4\u30c8) = 8192 \u00d7 Num_Pages<\/strong><br \/>\n<strong>= 8192 \u00d7 1,095,000,000 = 8,970,240,000,000 byte(\u7d049\u5146byte)<\/strong><br \/>\n<strong>= 8.97 Tbyte<\/strong><\/p>\n<p>\u4ee5\u4e0a\u3067\u3001\u30d2\u30fc\u30d7\u306e\u30c7\u30fc\u30bf\u91cf\u3060\u3051\u30679\u30c6\u30e9\u30d0\u30a4\u30c8\u7a0b\u5ea6\u306b\u306a\u308b\u3053\u3068\u304c\u308f\u304b\u308a\u307e\u3057\u305f\u3002<br \/>\n<a href =\"https:\/\/docs.microsoft.com\/ja-jp\/sql\/relational-databases\/databases\/estimate-the-size-of-a-heap?view=sql-server-2017\">\u30d2\u30fc\u30d7\u30b5\u30a4\u30ba\u306e\u898b\u7a4d\u3082\u308a\u306f\u3053\u3061\u3089<\/a><\/p>\n<\/div>\n<div>\n<p>\u30c7\u30fc\u30bf\u91cf\u3060\u3051\u30679\u30c6\u30e9\u30d0\u30a4\u30c8\u7a0b\u5ea6\u3068\u63a8\u5b9a\u3055\u308c\u305f\u306e\u3067\u3001\u30d3\u30c3\u30b0\u30c7\u30fc\u30bf\u3068\u547c\u3079\u308b\u304f\u3089\u3044\u306b\u306f\u591a\u91cf\u306a\u30c7\u30fc\u30bf\u3067\u3059\u306d\u3002<\/p>\n<p>\u3053\u306e\u30c7\u30fc\u30bf\u91cf\u306f\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u542b\u3093\u3067\u3044\u306a\u3044\u7d14\u7c8b\u306a\u30c7\u30fc\u30bf\u91cf\u306a\u306e\u3067\u3001\u30c6\u30fc\u30d6\u30eb\u5168\u4f53\u306e\u30c7\u30fc\u30bf\u91cf\u306f\u3055\u3089\u306b\u500d\u8fd1\u304f\u306b\u5927\u304d\u304f\u306a\u308a\u307e\u3059\u3002<br \/>\n\u307e\u305f\u3001\u30c1\u30e5\u30fc\u30cb\u30f3\u30b0\u7b49\u3067\u975e\u30af\u30e9\u30b9\u30bf\u30fc\u5316\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u8ffd\u52a0\u3059\u308b\u306a\u3069\u3059\u308b\u3068\u3055\u3089\u306b\u5897\u52a0\u3059\u308b\u3053\u3068\u304c\u8003\u3048\u3089\u308c\u307e\u3059\u3002<\/p>\n<\/div>\n<h1 id=\"e4bb96rdbse381a7e381aee38387e383bce382bfe9878fe68ea8e5ae9a-12\"><a id=\"RDB_5\"><\/a>\u4ed6RDBS\u3067\u306e\u30c7\u30fc\u30bf\u91cf\u63a8\u5b9a<\/h1>\n<div>\u4e0a\u8a18\u3067\u306f\u3001SQLServer\u3067\u306e\u30c7\u30fc\u30bf\u91cf\u3092\u63a8\u5b9a\u3057\u307e\u3057\u305f\u304c\u3001\u4ed6RDBS\u3067\u306f\u3069\u3046\u306a\u306e\u304b\u8abf\u3079\u3066\u307f\u307e\u3057\u305f\u3002<\/div>\n<h5 id=\"oracle-13\">Oracle<\/h5>\n<div>Oracle 8\u306eWhitePaper\u306b\u898b\u7a4d\u65b9\u6cd5\u304c\u8a18\u8f09\u3055\u308c\u3066\u3044\u307e\u3057\u305f\u304c\u3001\u73fe\u5728\u306eOracle\u306e\u60c5\u5831\u304c\u898b\u3064\u304b\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002<br \/>\n\u5185\u5bb9\u306f\u5909\u308f\u3063\u3066\u3044\u306a\u3044\u306e\u3067\u3057\u3087\u3046\u304b\u3002<\/div>\n<div><\/div>\n<div>\u3000(\u53c2\u8003\uff1aOracle WhitePaper \u9818\u57df\u30b5\u30a4\u30ba\u306e\u898b\u7a4d\u3082\u308a\u65b9\u6cd5:<a href=\"http:\/\/otndnld.oracle.co.jp\/deploy\/maintenance\/pdf\/size_est.pdf\">http:\/\/otndnld.oracle.co.jp\/deploy\/maintenance\/pdf\/size_est.pdf<\/a>)<\/div>\n<h5 id=\"mysql-14\">MySQL<\/h5>\n<div>MySQL\u3082\u30c6\u30fc\u30d6\u30eb\u5217\u306e\u30c7\u30fc\u30bf\u578b\u3067\u884c\u5f53\u305f\u308a\u306e\u30c7\u30fc\u30bf\u91cf\u3092\u8a08\u7b97\u3057\u3001InnoDB\u306e\u30da\u30fc\u30b8\u5358\u4f4d\u3067\u30c7\u30fc\u30bf\u91cf\u3092\u63a8\u5b9a\u3067\u304d\u308b\u3088\u3046\u3067\u3059\u3002<br \/>\nInnoDB\u306e\u30da\u30fc\u30b8\u30b5\u30a4\u30ba\u306f16kb\u3068SQLServer\u3088\u308a\u3082\u5927\u304d\u3044\u3067\u3059\u3002<\/div>\n<div><div class=\"linkcard\"><div class=\"lkc-external-wrap\"><a class=\"lkc-link no_icon\" href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/storage-requirements.html\" data-lkc-id=\"5\" target=\"_blank\" rel=\"external noopener\"><div class=\"lkc-card\"><div class=\"lkc-content\"><figure class=\"lkc-thumbnail\"><img decoding=\"async\" class=\"lkc-thumbnail-img\" src=\"https:\/\/s.wordpress.com\/mshots\/v1\/https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fen%2Fstorage-requirements.html?w=100\" width=\"100px\" height=\"108px\" alt=\"\" \/><\/figure><div class=\"lkc-title\">MySQL :: MySQL 8.0 Reference Manual :: 11.8 Data Type Storage Requirements<\/div><div class=\"lkc-url\" title=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/storage-requirements.html\">https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/storage-requirements.html<\/div><div class=\"lkc-excerpt\">InnoDB Table Storage Requirements, NDB Table Storage Requirements, Numeric Type Storage Requirements, Date and Time Type Storage Requirements, String Type Storage Requirements, Spatial Type Storage Requirements, JSON Storage Requirements...<\/div><div class=\"lkc-more\">more<\/div><\/div><div class=\"lkc-info\"><div class=\"lkc-favicon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.google.com\/s2\/favicons?domain=dev.mysql.com\" alt=\"\" width=\"16\" height=\"16\" \/><\/div><div class=\"lkc-domain\">dev.mysql.com<\/div><div class=\"lkc-share\"> <div class=\"lkc-sns-hb\">11 Users<\/div> <div class=\"lkc-sns-po\">3 Pockets<\/div><\/div><\/div><div class=\"clear\"><\/div><\/div><\/a><\/div><\/div><\/div>\n<h5 id=\"postgresql-15\">PostgreSQL<\/h5>\n<div>\u3044\u304f\u3064\u304b\u63a8\u5b9a\u3059\u308b\u65b9\u6cd5\u304c\u3042\u308b\u307f\u305f\u3044\u3067\u3059\u304c\u3001SQL\u95a2\u6570\u3092\u4f7f\u7528\u3057\u3066\u3001\u30c7\u30a3\u30b9\u30af\u306e\u4f7f\u7528\u91cf\u3092\u8abf\u67fb\u3057\u3066\u3001\u63a8\u5b9a\u3059\u308b\u65b9\u6cd5\u304c\u7c21\u5358\u307f\u305f\u3044\u3067\u3059\u306d\u3002<\/div>\n<div><div class=\"linkcard\"><div class=\"lkc-external-wrap\"><a class=\"lkc-link no_icon\" href=\"https:\/\/www.postgresql.jp\/document\/10\/html\/disk-usage.html\" data-lkc-id=\"6\" target=\"_blank\" rel=\"external noopener\"><div class=\"lkc-card\"><div class=\"lkc-content\"><figure class=\"lkc-thumbnail\"><img decoding=\"async\" class=\"lkc-thumbnail-img\" src=\"https:\/\/s.wordpress.com\/mshots\/v1\/https%3A%2F%2Fwww.postgresql.jp%2Fdocument%2F10%2Fhtml%2Fdisk-usage.html?w=100\" width=\"100px\" height=\"108px\" alt=\"\" \/><\/figure><div class=\"lkc-title\">29.1. \u30c7\u30a3\u30b9\u30af\u4f7f\u7528\u91cf\u306e\u6c7a\u5b9a<\/div><div class=\"lkc-url\" title=\"https:\/\/www.postgresql.jp\/document\/10\/html\/disk-usage.html\">https:\/\/www.postgresql.jp\/document\/10\/html\/disk-usage.html<\/div><div class=\"lkc-excerpt\">\u5404\u30c6\u30fc\u30d6\u30eb\u306b\u306f\u3001\u30c7\u30fc\u30bf\u306e\u5927\u90e8\u5206\u304c\u683c\u7d0d\u3055\u308c\u308b\u30d7\u30e9\u30a4\u30de\u30ea\u30d2\u30fc\u30d7\u30c7\u30a3\u30b9\u30af\u30d5\u30a1\u30a4\u30eb\u304c\u5099\u308f\u3063\u3066\u3044\u307e\u3059\u3002 \u3082\u3057\u30c6\u30fc\u30d6\u30eb\u304c\u3001\u9577\u304f\u306a\u308b\u53ef\u80fd\u6027\u306e\u3042\u308b\u5024\u3092\u6301\u3064\u5217\u3092\u6301\u3064\u6642\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u306b\u95a2\u9023\u4ed8\u3051\u3089\u308c\u305fTOAST\u30d5\u30a1\u30a4\u30eb\u3082\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002 \u3053\u306e\u30d5\u30a1\u30a4\u30eb\u306f\u3001\u30e1\u30a4\u30f3\u30c6\u30fc\u30d6\u30eb\u306b\u53ce\u7d0d\u3059\u308b\u306b\u306f\u5927\u304d\u904e\u304e\u308b\u5024\u3092\u30c6\u30fc\u30d6\u30eb\u306b\u683c\u7d0d\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3055\u308c\u307e\u3059\uff0866.2\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\uff09\u3002 TOAST\u30c6\u30fc\u30d6\u30eb\u304c\u5b58\u5728\u3059\u308b\u5834\u5408\u306f\u3001\u305d\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u6709\u52b9\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c1\u3064\u3042\u308a\u307e\u3059\u3002 \u57fa\u672c\u30c6\u30fc\u30d6\u30eb\u306b\u95a2\u9023\u4ed8\u3051\u3089\u308c\u305f\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u5b58\u5728\u3059\u308b\u3053\u3068\u3082\u3042\u308a\u307e\u3059\u3002 \u30c6\u30fc\u30d6\u30eb\u3068\u30a4\u30f3\u30c7...<\/div><div class=\"lkc-more\">more<\/div><\/div><div class=\"lkc-info\"><div class=\"lkc-favicon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.google.com\/s2\/favicons?domain=www.postgresql.jp\" alt=\"\" width=\"16\" height=\"16\" \/><\/div><div class=\"lkc-domain\">www.postgresql.jp<\/div><div class=\"lkc-share\"> <div class=\"lkc-sns-hb\">1 User<\/div><\/div><\/div><div class=\"clear\"><\/div><\/div><\/a><\/div><\/div><\/div>\n<h1 id=\"e3818ae3828fe3828ae381ab-16\"><a id=\"RDB_6\"><\/a>\u304a\u308f\u308a\u306b<\/h1>\n<div>\u4eca\u56de\u306f\u30c7\u30fc\u30bf\u91cf\u3092\u63a8\u5b9a\u3057\u3066\u3001\u672c\u30c6\u30fc\u30de\u3067\u53d6\u308a\u6271\u3046\u30d3\u30c3\u30b0\u30c7\u30fc\u30bf\u306e\u898f\u6a21\u3092\u898b\u3066\u307f\u307e\u3057\u305f\u3002<\/div>\n<div>\u30af\u30e9\u30a6\u30c9\u3092\u5229\u7528\u3059\u308b\u5834\u5408\u306b\u306f\u3001\u30b9\u30c8\u30ec\u30fc\u30b8\u5bb9\u91cf\u3092\u62e1\u5927\u3059\u308b\u3053\u3068\u306f\u5bb9\u6613\u306b\u884c\u3048\u307e\u3059\u304c\u3001\u30aa\u30f3\u30d7\u30ec\u30df\u30b9\u3067\u306f\u30b9\u30c8\u30ec\u30fc\u30b8\u9818\u57df\u306f\u7269\u7406\u7684\u306a\u30b9\u30c8\u30ec\u30fc\u30b8\u306e\u5897\u52a0\u3084\u3001\u30b7\u30b9\u30c6\u30e0\u306e\u505c\u6b62\u3092\u4f34\u3046\u3053\u3068\u304c\u3042\u308b\u305f\u3081\u5bb9\u6613\u3067\u306f\u306a\u3044\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002<\/div>\n<div>\u305d\u306e\u305f\u3081\u3001\u30c7\u30fc\u30bf\u91cf\u3092\u63a8\u5b9a\u3057\u3066\u9069\u5207\u306a\u30b9\u30c8\u30ec\u30fc\u30b8\u5bb9\u91cf\u3092\u78ba\u4fdd\u3057\u3066\u304a\u304f\u3053\u3068\u304c\u91cd\u8981\u3068\u306a\u308a\u307e\u3059\u3002<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"\u76ee\u6b21 \u524d\u56de\u306e\u304a\u3055\u3089\u3044(\u524d\u63d0\u6761\u4ef6) \u691c\u8a3c\u74b0\u5883\u306b\u3064\u3044\u3066 \u30c6\u30fc\u30d6\u30eb\u69cb\u6210\u306b\u3064\u3044\u3066 \u30d2\u30fc\u30d7\u30c7\u30fc\u30bf\u91cf\u306e\u63a8\u5b9a \u4ed6RDBS\u3067\u306e\u30c7\u30fc\u30bf\u91cf\u63a8\u5b9a \u304a\u308f\u308a\u306b \u524d\u56de\u306e\u304a\u3055\u3089\u3044(\u524d\u63d0\u6761\u4ef6) \u524d\u56de\u3001\u691c\u8a3c\u3092\u9032\u3081\u308b\u306b\u3042\u305f\u308a\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u6761\u4ef6\u3092\u60f3\u5b9a\u3057\u307e\u3057\u305f\u3002 \u88fd\u9020\u696d\u306e\u4f01\u696d \u5168\u56fd\u306b10\u7b87\u6240\u306e\u751f\u7523\u30e9\u30a4\u30f3\u5de5\u5834\u3092\u6301\u3064 \u5de5\u5834\u306f24\u6642\u9593\u7a3c\u50cd \u5de5\u5834\u3067\u7a3c\u50cd\u3059\u308b\u30bb\u30f3\u30b5\u306e\u30c7\u30fc\u30bf\u3092\u53ce\u96c6\u3057\u3001\u9577\u671f\u7684(10\uff5e20\u5e74)\u306b\u30c7\u30fc\u30bf\u3092\u84c4\u7a4d\u3057\u3001\u52b9\u7387\u7684\u306a\u7a3c\u52d5\u3092\u5206\u6790\u3059\u308b\u305f\u3081\u306b\u30c7\u30fc\u30bf\u3092\u5229\u7528\u3057\u305f\u3044 \u53ce\u96c6\u3059\u308b\u30bb\u30f3\u30b5\u30c7\u30fc\u30bf\u306e\u751f\u6210\u983b\u5ea6\u306f\uff11\u5206\u3068\u3057\u3001\u30bb\u30f3\u30b5\u306e\u6570\u306f3000\u500b\/1\u5de5\u5834 \u30c7\u30fc\u30bf\u306f\u975e\u69cb\u9020\u5316\u30c7\u30fc\u30bf \u5de5\u5834\u306e\u30b7\u30b9\u30c6\u30e0\u3068\u63a5\u7d9a\u3059\u308b\u305f\u3081\u3001\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u9762\u304b\u3089\u30aa\u30d5\u30e9\u30a4\u30f3\u74b0\u5883\uff08\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u63a5\u7d9a\u306f\u3057\u306a\u3044\uff09\u3068\u3059\u308b \u4eca\u56de\u306f\u3001\u3053\u308c\u3089\u306e\u6761\u4ef6&hellip;","protected":false},"author":6,"featured_media":856,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[19],"class_list":{"0":"post-791","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-bigdata","8":"tag-season4"},"_links":{"self":[{"href":"https:\/\/itport.cloud\/index.php?rest_route=\/wp\/v2\/posts\/791","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itport.cloud\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itport.cloud\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itport.cloud\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/itport.cloud\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=791"}],"version-history":[{"count":55,"href":"https:\/\/itport.cloud\/index.php?rest_route=\/wp\/v2\/posts\/791\/revisions"}],"predecessor-version":[{"id":853,"href":"https:\/\/itport.cloud\/index.php?rest_route=\/wp\/v2\/posts\/791\/revisions\/853"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/itport.cloud\/index.php?rest_route=\/wp\/v2\/media\/856"}],"wp:attachment":[{"href":"https:\/\/itport.cloud\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=791"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itport.cloud\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=791"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itport.cloud\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=791"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}