{"id":2671,"date":"2018-02-02T21:25:22","date_gmt":"2018-02-02T12:25:22","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2671"},"modified":"2018-02-02T21:25:22","modified_gmt":"2018-02-02T12:25:22","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-%eb%b9%84%ed%8a%b8%eb%a7%b5-%ec%9d%b8%eb%8d%b1%ec%8a%a4-bitmapped-index","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2671","title":{"rendered":"\uc624\ub77c\ud074 \ube44\ud2b8\ub9f5 \uc778\ub371\uc2a4 BITMAPPED INDEX"},"content":{"rendered":"

Datawarehousing\ud658\uacbd \uacfcEnd-User-Computing\ud658\uacbd\ub4f1\uc5d0\uc11c \ud544\uc694\ud55cRDBMS\uc758 \ucca8\ub2e8Indexing Access\uae30\ubc95\uc73c\ub85c \uacbd\uc7c1\uc0ac\uc5d0\uc11c\ub294Bitwised Index\ub97c \ubc1c\ud45c\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uae30\ubc95\uc740Oracle Server V7.3\uc5d0\uc11c\ub3c4Bitmapped Index\ub77c\ub294 \uc774\ub984\uc73c\ub85c \ubc1c\ud45c\ub420 \uc608\uc815\uc774\ubbc0\ub85c \uc774\uc5d0 \ub300\ud55c \uc815\ud655\ud55c \uc774\ud574\ub97c \uc704\ud574 \ub2e4\uc74c\uc0ac\ud56d\uc744 \uae30\uc220\ud574 \ubcf4\uc558\uc2b5\ub2c8\ub2e4.<\/p>\n

 <\/p>\n

    \n
  1. Bitmapped Index<\/strong>\ub780<\/strong> ?<\/strong><\/li>\n<\/ol>\n

    RDBMS\uc758Table\ub85c\ubd80\ud130 \ud2b9\uc815 \uc790\ub8cc\uc758 \uac80\uc0c9\uc744 \uc704\ud574 \uae30\uc874\uc758 \uc77c\ubc18RDBMS\uc5d0\uc11c\ub294\uac80\uc0c9\ud6a8\uc728\uc758 \ud5a5\uc0c1\uc744 \uc704\ud574B-Tree Index\ub97c \uad6c\ud604\ud558\uc5ec \uc0ac\uc6a9\ud558\uc5ec \uc654\uc2b5\ub2c8\ub2e4. \uadf8\uc678\uc5d0\ub3c4B-tree Cluster Index, Hash Cluster Index\ub4f1\uc744 \uc774\uc6a9\ud558\uc5ec \u00a0 \ub300\ubd80\ubd84\uc758 \uac80\uc0c9\ud6a8\uc728\uc744 \ubcf4\uc7a5\ud558\uc5ec \uc654\uc9c0\ub9ccB-Tree Access\ub97c \uc704\ud55c \ud2b9\uc131\ub85c \uc778\ud574 \uba87\uac00\uc9c0 \uc5b4\ub824\uc6c0\uc744 \uc548\uace0 \uc788\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n

     <\/p>\n

    1) B-tree Index Access \ubc29\uc2dd\uc744 \uc704\ud574\uc120 \uc2e4\uc9c0 \uc870\uac74\ube44\uad50\ub418\ub294Column\uac12\uc5d0 \ub300\ud55cTable\uc758 \uc6d0\uc2dc\uac12\uc744Index\uc5d0\ub3c4 \ubcf4\uad00\ud558\uace0 \uc788\uc5b4\uc57c \ud568\uc73c\ub85c \uc778\ud574Index\ub97c \uc704\ud55c \uc2e4\uc9c0data\uc758 \uc911\ubcf5 \uc800\uc7a5\uc73c\ub85c \uc800\uc7a5\uacf5\uac04\uc758 \ub0ad\ube44\ub97c \uac10\uc218\ud558\uc5ec\uc57c\u00a0\u00a0 \uc73c\uba70, \ud2b9\ud788 \ud604\uc2e4 \uc0c1\ud669\uc5d0\uc11c \uc790\uc8fc \uc0ac\uc6a9\ucf00 \ub418\ub294 \uc5ec\ub7ec \uceec\ub7fc\uc758Concatenated Index (\uacb0\ud569<\/p>\n

    \uc778\ub371\uc2a4) \uc5d0\uc11c \uc790\ub8cc\ub7c9\uc774 \ub9ce\uc740Table\uc5d0 \ub300\ud574\uc11c\ub294 \ud06c\ub098\ud070 \ubd80\ub2f4\uc774\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n

     <\/p>\n

    2) Index\uc124\uc815Column\uac12\uc758 \ubd84\ud3ec\ub3c4(Unique\uc131)\uac00 \ub113\uc740Column\uc5d0 \ub300\ud55c(\uc608:\uc131\ubcc4)\uc870\uac74\uac80\uc0c9\uc2dc\uc5d0\ub294Index access\ub97c \ud588\uc744\ub54c \ubcf4\ub2e4 \uc624\ud788\ub824Full Table Scan\ubc29\uc2dd\uc774 \uc624\ud788\ub824 \ube60\ub978 \uc131\ub2a5\uc744 \ubcf4\uc7a5\ud558\uae30 \ub54c\ubb38\uc5d0RDBMS\uc758Cost Based Optimizer\ub294Random access\ube44\uc6a9\uc774 \ub9ce\uc774\ub4dc\ub294Index access\ub97c \ud3ec\uae30\ud558\uace0 \ube60\ub978\uc18d\ub3c4\uc758 \uc21c\ucc28<\/p>\n

    Table Scan\uc744 \ud558\uc5ec \ub192\uc740Hit Ratio\ub97c \ubcf4\uc7a5\ud558\ub824 \ud558\ub294 \uacbd\uc6b0\ub97c \uc6b0\ub9ac\ub294 \ud754\ud788 \ubcf4\uac8c\ub429\ub2c8\ub2e4.<\/p>\n

     <\/p>\n

    3) End-User-Computing \ud658\uacbd\uc5d0\uc11c \ud754\ud788 \uc608\uc0c1\ub418\ub294 \ubcf5\uc7a1\ud55c \uc9c8\uc758\uc870\uac74\uc73c\ub85c \uc778\ud574Optimizer\uac00 \ucd5c\uc801 \uc2e4\ud589\uacc4\ud68d\uc5d0\uc11cIndex\ub97c \ud3ec\uae30\ud558\uac8c\ub418\ub294 \uacbd\uc6b0\ub97c \ucd08\ub798\ud569\ub2c8\ub2e4.\u00a0\u00a0\u00a0\u00a0 (\uc608: \ubcf5\uc7a1\ud55cOR \uc5f0\uc0b0\uc790\ub4f1)<\/p>\n

     <\/p>\n

    \uc774\ub7ec\ud55c \uc0c1\ud669\uc744 \ud574\uacb0\ud558\uae30 \uc704\ud55c \uc0c8\ub85c\uc6b4Index Access \ubc29\ubc95 \u00a0 \ub85cBitmapped Index\uac00 \uc0c8\ub86d\uac8c \ub4f1\uc7a5\ud558\uac8c \ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n

     <\/p>\n

    \ub2e4\uc74c \uc0c1\ud669\uc744 \ud1b5\ud558\uc5ec \uad6c\uccb4\uc801 \uc124\uba85\uc744 \uc81c\uc2dc\ud569\ub2c8\ub2e4.<\/p>\n

    \uc608) \ud55c\uad6d\uc624\ub77c\ud074(\uc8fc) \uc5d0\uc11c \uad00\ub9ac\ud558\uace0 \uc788\ub294 \uace0\uac1d\uc815\ubcf4Table\uc774 \ub2e4\uc74c\uacfc \uac19\uc774 \uc815\uc758 \ub418\uc5b4\uc788\ub2e4\uace0 \uac00\uc815\ud569\uc2dc\ub2e4.<\/p>\n

    ————————————————<\/p>\n

    \uace0\uac1d\ubc88\ud638\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 \ud63c\uc778\uc5ec\ubd80\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 \uc131\ubcc4\u00a0\u00a0 \uc911\uc694\ub4f1\uae09<\/p>\n

    ————————————————<\/p>\n

    1001\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \uacb0\ud63c\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \uc5ec\u00a0\u00a0\u00a0\u00a0 \u00a0 \ud558<\/p>\n

    1002\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 \ubbf8\ud63c\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \ub0a8\u00a0\u00a0\u00a0\u00a0 \u00a0 \uc0c1<\/p>\n

    1003\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 \uc7ac\ud63c\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \ub0a8\u00a0\u00a0\u00a0\u00a0 \u00a0 \uc911<\/p>\n

    ————————————————<\/p>\n

     <\/p>\n

    \uc0c1\uae30Column\ub4e4\uc758 \uc18d\uc131\uc744 \ubcf4\uba74 \uace0\uac1d\ubc88\ud638\ub294 \uc720\uc77c\ud55c \uac12\ub4e4\uc774\uba70B-Tree Index\ub85c \ud0c1\uc6d4\ud55c \uc870\ud68c\uc131\ub2a5 \ubcf4\uc7a5.<\/p>\n

    \ud63c\uc778\uc5ec\ubd80(3\uc885\ub958),\uc131\ubcc4(2\uc885\ub958),\uc911\uc694\ub4f1\uae09(3\uc885\ub958) \uc74030 – 50%\uc758 \ub113\uc740 \ubd84\ud3ec\ub3c4\ub97c \uac16\ub294 \uac12\ub4e4\ub85c\uc11cB-Tree Index\uc0ac\uc6a9\uc2dc \ud6a8\uc728\uc131\uc774 \uac70\uc758 \uc5c6\uc2b4.<\/p>\n

    \uc989, B-Tree Index\uc5d0\uc11c\ub294 \uc790\ub8cc\uc758 \uac12\uc5d0 \ub530\ub77cSort\ud558\uc5ec \uc774\ubd84\uc2dd(Binary) \uac00\uc9c0\uce58\uae30(Leaf& Node) \uad6c\uc870\ub97c \uc720\uc9c0\ud558\uc5ec, \uc870\uac74\uc5d0 \ub4e4\uc5b4\uc624\ub294 \uac12\uc5d0\ub530\ub77c \uac80\uc0c9\uc790\ub8cc \ubc94\uc704(Access Range)\ub97c \ucabc\uac1c\uc5b4 \ub098\uac00\ub294\ub370 \ubc18\ud574, \uc800\uc7a5\ub418\uc5b4 \uc788\ub294 \uc790\ub8cc\uac00 \ub3d9\uc885(\uac19\uc740\uac12)\uc774 \ub9ce\ub2e4\uba74 \ud574\uc57c\ud560\uc77c(Access Range)\uc774 \uc904\uc9c0 \uc54a\uace0 \ube44\uc6a9\uc774 \ub9ce\uc774\ub4dc\ub294Random Access(Index\uc5d0\uc11cRowid\ub97c \uac00\uc9c0\uace0 \uc2e4Table Data\ub97c \ucc3e\uc744\ub54c)\ub9cc \ub9ce\uc544\uc9c0\uace0, Scan\ud574\uc57c\ud560 \uc790\ub8cc\uac00\uc9c0(Leaf) \uc218\ub294 \uc27d\uac8c \uc904\uc9c0\uc54a\uac8c\ub418\uc5b4B-Tree Index\ubc29\uc2dd\uc73c\ub85c\ub294 \ube60\ub978 \uc131\ub2a5\uc744 \ubcf4\uc7a5\ud558\uae30\uac00 \uc5b4\ub835\uc2b5\ub2c8\ub2e4.<\/p>\n

     <\/p>\n

    \uadf8\ub807\ub2e4\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \ubd84\ud3ec\ub3c4\uac00 \uc88b\uc9c0\uc54a\uc740 \uc911\uc694\ub4f1\uae09Column\uc744 \uba87 \uac1c\uc758Bit\ub4e4\ub9cc \uac00\uc9c0\uace0 \uc815\ubcf4\ub97c \uc800\uc7a5\ud0a4\ub85c \ud558\uc5ec\ubd05\ub2c8\ub2e4.<\/p>\n

     <\/p>\n

    ———————————————————-<\/p>\n

    \uc911\uc694\ub4f1\uae09= ‘\uc0c1’ \u00a0 1\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0 \u00a0 0<\/p>\n

    \uc911\uc694\ub4f1\uae09= ‘\uc911’ \u00a0 0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a01\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<\/p>\n

    \uc911\uc694\ub4f1\uae09= ‘\ud558’ \u00a0 0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0 \u00a0 0<\/p>\n

    ———————————————————-<\/p>\n

    *\ud63c\uc778\uc5ec\ubd80(3\uc885\ub958),\uc131\ubcc4(2\uc885\ub958)\ub3c4 \uac19\uc774 \uc801\uc6a9\ud558\uc600\ub2e4\uace0 \uac00\uc815.<\/p>\n

     <\/p>\n

    \uc774\ub7f0 \uc0c1\ud669\uc5d0\uc11c \uc544\ub798\uc758SQL\uc744 \uc2e4\ud589\ud55c\ub2e4\uace0 \uac00\uc815\ud558\uc5ec \ubd05\ub2c8\ub2e4.<\/p>\n

     <\/p>\n

    Select count(*) from \uace0\uac1d\uc815\ubcf4<\/p>\n

    where \uacb0\ud63c\uc5ec\ubd80= ‘\ubbf8\ud63c’\u00a0\u00a0 and \uc911\uc694\ub3c4in (‘\uc0c1’,’\uc911’);<\/p>\n

    (“\ubbf8\ud63c\uc790 \uc778 \uace0\uac1d\uc911\uc5d0 \uc911\uc694\ub3c4\uac00’\uc0c1’ \uc774\uac70\ub098’\uc911’\uc778 \uace0\uac1d\uc740 \uba87 ?”)<\/p>\n

     <\/p>\n

    \uc774SQL\uc744 \uc2e4\ud589\ud558\uae30 \uc704\ud55cOptimizer\uac00 \uc774\ub7ec\ud55cOperation\uc744 \ub2e4\uc74c\uacfc \uac19\uc774 \uacb0\uc815\ud55c\ub2e4\uba74 \ud6e8\uc52c \ube60\ub978\uc18d\ub3c4\uc758 \uc131\ub2a5\uc744 \ub0bc \uc218 \uc788\uc744 \uac83 \uc785\ub2c8\ub2e4.<\/p>\n

     <\/p>\n

    \ud63c\uc778\uc5ec\ubd80= ‘\ubbf8\ud63c’ AND (\uc911\uc694\ub3c4= ‘\uc0c1’ OR \uc911\uc694 \u00a0 = ‘\uc911’)<\/p>\n

    \uc989,\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘011001’ AND (\u00a0\u00a0\u00a0\u00a0 ‘100000’ OR\u00a0\u00a0\u00a0\u00a0 \u00a0 ‘010011’)<\/p>\n

    \ub2e4\uc2dc \ud480\uc5b4\ubcf4\uba74’011001′ AND ‘110011’ \uc774\uace0 \u00a0 \uacb0\uacfc\ub294’010001’\uc774\ub2e4.<\/p>\n

    Optimizer\ub294 \ub450\uac1c \uceec\ub7fc\uc758 \ub17c\ub9ac\uc5f0\uc0b0\uacb0\uacfc\uac00’010001’\uc778Row\ub4e4\uc744 \ucc3e\uc544 \uac74\uc218\ub97c \uc138\uba74 \ub420 \uac83 \uc785\ub2c8\ub2e4.<\/p>\n

     <\/p>\n

    \uc0c1\uae30\uc640 \uac19\uc774 \ub17c\ub9ac\uc5f0\uc0b0\uacfcBit\ucc98\ub9ac \ubc29\uc2dd\uc740Computer\uc5d0\uac8c \ud6e8\uc52c \uc27d\uac8c \ucc98\ub9ac\ud560 \uc218 \uc788\ub294 \uae38\uc744 \ub9cc\ub4e4\uc5b4\uc8fc\uac8c \ub418\uba74\uc11c, \uba87\uc885\ub958 \uc548\ub418\ub294 \uac12\ub4e4\uacfc\uc758 \ubcc4\ub3c4\uc758 \uc870\uadf8\ub9cc \uc5f0\uacb0\ud45c(Bitmap)\uc640 \uba87Bit\ub9cc\uc758 \uc800\uc7a5\uacf5\uac04\ub9cc\uc744 \uac00\uc9c0\uace0<\/p>\n

    Index \uad6c\uc131\uc744 \uac00\ub2a5\ucf00 \ud568\uc73c\ub85c\uc368 \uacf5\uac04\uc758 \uc808\uc57d\ud6a8\uacfc\ub3c4 \uc0c1\ub2f9\ud560 \uac83\uc774\ub2e4.\ud2b9\ud788, Data warehousing, Decision Support System \uc5d0\uc11c\uc640 \uac19\uc740 \ubc29\ub300\ud55c \uc815\ubcf4\ub7c9\uc5d0\uc11c \uc720\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

     <\/p>\n

      \n
    1. Bitmapped Index<\/strong>\uc758<\/strong> \uc7a5\ub2e8\uc810<\/strong> ?<\/strong><\/li>\n<\/ol>\n

       <\/p>\n

      Index\ub97c \uc0ac\uc6a9\ud558\ub294\ub370 \uc788\uc5b4\uc11c \uc6b0\ub9ac\ub294 \uba87\uac00\uc9c0\uc758 \uace0\ub824\uc0ac\ud56d\uc744 \uac80\ud1a0\ud574\uc57c \ud569\ub2c8\ub2e4. \uc870\ud68c\uc131\ub2a5\uce21\uba74, \uc800\uc7a5\uacf5\uac04\uce21\uba74, \uc720\uc9c0\uad00\ub9ac\uce21\uba74 \uc815\ub3c4\ub97c \uace0\ub824\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc55e\uc73c\ub85c, \uc774\ub7ec\ud55c \uce21\uba74\uc5d0\uc11c\uc758Bitmapped Index\ud2b9\uc131\uc744 \uc124\uba85\ud558\uae30\ub85c\ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc6b0\uc120, Bitmapped Index\uc758 \uc7a5,\ub2e8\uc810\uc744 \uac04\ucd94\ub824\ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \uc7a5\uc810\uc73c\ub85c\ub294 \uc544\uc8fc\uc801\uc740Index\uc800\uc7a5\uacf5\uac04\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc88b \u00a0 \uc54a\uc740 \ubd84\ud3ec\ub3c4\uc758 \uac12\uc744 \uac16\ub294 \ub2e4\ub7c9\uc758 \uc790\ub8cc\ub97c \ube60\ub978\uc18d\ub3c4\ub85cAccess\ud560 \uc218 \uc788\ub2e4\ub294 \uac83\uacfc \ubcf5\uc7a1\ub2e4\uc591\ud55c \uc870\uac74\uc5d0 \ub300\ud574Index Access Path\ub97c \uc801\uc6a9\ud560 \uc218 \uc788\ub2e4\ub294 \uc810\uc774 \uc788\ub294<\/p>\n

      \ubc18\uba74, \uc870\uac74 \uc720\ud615\uc774Pattern Match\ud615\ud0dc\uac00 \uc790\uc8fc \uc0ac\uc6a9\ub420\uc2dc \ud6a8\uc6a9\uc131\uc774 \uadf9\uc18c\ud654\ub418\uba70, B-Tree Index\uc640 \uac19\uc774 \ubaa8\ub4e0Query\uc5d0 \ub300\ud574Index Path\ub85c \uc0ac\uc6a9\ub420 \uc218 \uc5c6\ub2e4\ub294 \ub2e8\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ud55c\uc608\ub85cInsert, Update, Delete\uc640 \uac19\uc740Query\uc5d0\uc11c\ub294 \ubb34\uc758\ubbf8 \ud569\ub2c8\ub2e4.<\/p>\n

      Bitmapped Index\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uce21\uba74\uc5d0\uc11c \uac01\uac01 \uc720\uc6a9\ud55c \uc774\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

       <\/p>\n

      \uc870\ud68c\uc131 \u00a0 \uce21\uba74<\/strong><\/p>\n

      – \uac01\uac01\uc758 \ub3c5\ub9bd\uc801\uc778Column\ub4e4\uc5d0 \ub300\ud558\uc5ec \uc5ec\ub7ec\uc720\ud615(AND,OR…)\uc758 \uc870\uac74\uc808\uc5d0 \u00a0 \ub300\ud574Index\uac00 \uc0ac\uc6a9 \ub418\uc5b4\uc9c0\uac8c \ud558\ub294 \uaddc\uce59\uc774 \ubd88\ud544\uc694\ud558\ub2e4.(ad hoc query)<\/p>\n

      – \ubd84\ud3ec\ub3c4\uac00 \ub098\uc05c \uac12\uc5d0 \ub300\ud55cIndex Access\uac00 \ube60\ub984.<\/p>\n

      – Index Column\uc73c\ub85c \ucd94\uac00 \ud544\uc694\uc2dc \ub3c5\ub9bd\uc801\uc73c\ub85c \ucd94\uac00 \ubc0f \uc801\uc6a9 \uac00\ub2a5.<\/p>\n

      – \ubcf5\uc7a1\ud558\uac8c \uae38\uc5b4\uc9c0\ub294 \uc870\uac74\uc808\uc5d0\uc11c\ub3c4 \ubaa8\ub450 \uc720\ud6a8\ud558\uac8c \uc791\ub3d9\ub41c\ub2e4.(\ubcf5\uc7a1\ud55c \uc9c8\uc758 \ubc0fad hoc query\uc5d0\uc11c \uc720\uc6a9)<\/p>\n

      – \ud2b9\ud788 \ub2e4\ub7c9\uc758 \uc790\ub8cc\uc5d0 \ub300\ud55c \uacc4 \uc9c8\uc758(aggregate query)\uc5d0\uc11c \ud0c1\uc6d4. (\uc608:COUNT operator)<\/p>\n

      – \ubd84\ud3ec\ub3c4\uac00 \uc88b\uc740(Unique\uc131:\uac12\uc758\uc885\ub958\uac00 \ub9ce\ub2e4) \uac12\uc5d0\ub300\ud55cIndex\ub294 \ubd88\ub9ac.<\/p>\n

       <\/p>\n

      \uc800\uc7a5\uacf5\uac04\uce21\uba74<\/strong><\/p>\n

      – Index\uc5d0 \uac00\uc9c0\uace0 \uc788\uc5b4\uc57c \ub420 \uc790\ub8cc\uac12 \uc5d0\ub300\ud55c \uacf5\uac04 \uc808\uc57d.<\/p>\n

      . \ud558\uc9c0\ub9cc, Bitmapped Index\ub85c \uc801\uc6a9\ud558\uac8c\ub420Column\uc758 \ud2b9\uc131\uc0c1 \uc2e4\uc81c \uac12\uc758 \u00a0 Size\ub3c4 \ud06c\uc9c0\uc54a\ub2e4 \uc608\ub97c\ub4e4\uc5b4’\ub0a8’ \uacfc’\uc5ec’\uac12\uc758 \uaca8\uc6b02Byte \uc774\ud558\uc77c \uac83\uc774\ub2e4. \uc989, Bitmapped Index\uc801\uc6a9Column\uc758 \ud6c4\ubcf4\ub294 \ub300\uac1c5\uac00\uc9c0 \uc815\ub3c4 \uc774\ub0b4\uc758 \uac12\uc744 \uac16\ub294 \uacbd\uc6b0\uac00 \ub418\ubbc0\ub85c \uc2e4\uc9c0 \uac12\uc758Size\ub3c4 \uc791\uac8c\ub428.\uace0\ub85c, \uc774\ub7ec\ud55c \uce21\uba74\uc5d0\uc11c\uc758 \uc800\uc7a5\uacf5\uac04 \uc808\uc57d \uce21\uba74 \ubcf4\ub2e4\ub294 \uc2e4\uc81c \ud604\uc5c5\uc0c1 \uc694\uad6c\ub418\ub294Index\uad6c\uc131\uc5d0\uc11c \uc608\ub97c \ub4e4\uba74 \ub354\ub098\uc740 \uc774\ud574\uac00 \ub420 \uac83 \uc785\ub2c8\ub2e4.<\/p>\n

      \uc608) \uae30\uc874\uc5d0 \uace0\uac1d\uc815\ubcf4 \uac80\uc0c9\uc18d\ub3c4\ub97c \uc704\ud574Index1\uc744 \ub2e4\uc74c\uacfc \uac19\uc774 \uad6c\uc131 \ud558\uc600\ub2e4\uace0 \uac00\uc815 \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n

      B-Tree Index1 = (\ud63c\uc778\uc5ec\ubd80,\uc131\ubcc4,\uc911\uc694\ub3c4)<\/p>\n

      \uc774\uacbd\uc6b0\ub294Where\uc808\uc5d0\uc11c \ud63c\uc778\uc5ec\ubd80\uac00 \uc870\uac74\uc5d0 \uc624\uc9c0\uc54a\ub294 \uacbd\uc6b0\ub098 \uc870\uac74\uc808\uc5d0 \uc131\ubcc4\ub9cc \ud639\uc740 \uc911\uc694\ub3c4\ub9cc\uc744 \uac00\uc9c0\uace0 \uac80\uc0c9\ud560 \uacbd\uc6b0\uc5d0\ub294Index1\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uae30\uc5d0Index2(\uc131\ubcc4,\uc911\uc694\ub3c4,\ud63c\uc778\uc5ec\ubd80),Index3(\uc911\uc694\ub3c4,\uc131\ubcc4,\ud63c\uc778\uc5ec\ubd80)\ub4f1\uc758 \ucd94\uac00Index\uac00 \uc788\uc5b4\uc57c \ub9cc\uc871\ud55c \uc131\ub2a5\uc744 \ub0bc \uc218 \uc788\uc5c8\ub2e4\uba74 \uac70\uc75810 – 100\ubc30\uc758 \uacf5\uac04\uc808\uc57d\uc744\ud558\uba70Bitmapped Index1(\ud63c\uc778\uc5ec\ubd80),Index2(\uc131\ubcc4),Index3 (\uc911\uc694\ub3c4)\ub4f1\uc758 \ub3c5\ub9bd\uc801\uc7783\uac1c\uc758 \uc801\uc740\uacf5\uac04\uc73c\ub85c \ub9cc\uc871\ud55c \uc131\ub2a5\uc744 \ubcf4\uc7a5\ud560 \uc218 \uc788\ub2e4. \uc774\ub7ec\ud55c \uce21\uba74\uc5d0\uc11c\uc758 \uc774\uc810\uc774 \ud074 \uac83 \uc785\ub2c8\ub2e4.<\/p>\n

       <\/p>\n

      \uc720\uc9c0\uad00\ub9ac\uce21\uba74<\/strong><\/p>\n

      – Bitmapped Index\ub294Decision Support System\uacfc \uac19\uc740 \uc870\ud68c\uc804\uc6a9 \uc5c5\ubb34\ub098OLTP\uc5c5\ubb34 \ube44\uc911\uc774 \uc791\uc740 \uc5c5\ubb34\uc5d0\uc11c \uc801\ud569.<\/p>\n

      – \uc544\uc9c1Single Bit\uc5d0 \ub300\ud55cLock\ubc29\uc548\uc774 \uc5c6\uace0, Bitmapped Index\uc5d0\uc11cRow-Level Locking\ub300\uc2e0\uc5d0Block-Level Locking\uc774 \uc801\uc6a9\ub418\uae30 \ub54c\ubb38\uc5d0OLTP\uc804\uc6a9 \uc5c5\ubb34\uc5d0\uc11c\ub294Lock Contention \ubc0fDeadlock \uac00\ub2a5\uc131 \ub9ce\uc74c.<\/p>\n

      – Bitmapped Index\uc5d0\uc11cUpdate\ub4f1\uc758Transaction\uc740Block level Lock\uc744 \uc0ac\uc6a9\ud558\uc5ec\uc57c \ud558\ubbc0\ub85cOracle\uc758 \uae30\ubcf8Locking \uc778Row level Lock \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uac8c \ub418\uba70 \uacb0\uad6dOracle block (\uc608:2KB)\ub0b4\uc758 \ud55cRow\uc5d0 \ub300\ud55c \ubcc0\uacbd\uc774 \ud544\uc694\uc2dc(Update\ub4f1)\uc5d0\ub294 \ud574\ub2f9Block\uc804\uccb4\uac00Locking\ub418\ubbc0\ub85c \uc7a6\uc740 \ubcc0\uacbd\uc774 \uc608\uc0c1\ub418\ub294OLTP\uc5c5\ubb34\uc5d0\uc11c\ub294 \ud070\ubd80\ub2f4\uc774 \ub418\ubbc0\ub85cBatch\uc131Bulk Operation \uc774 \uac00\ubbf8\ub418\uc5b4 \uc6b4\uc6a9\ud560 \uc218 \uc788\ub294 \ubc29\uc548\uc774 \ud544\uc694.<\/p>\n

      \uc608) Data warehousing\uc5d0\uc11c\ub294 \uc8fc\uc5c5\ubb34\uac00 \uc870\ud68c\uc774\uba70, \uc790\ub8cc\ubcc0\uacbd \ucd94\uac00\uc2dc\ub294 \ub300\ubd80\ubd84Batch\uc131\uc73c\ub85c \ucc98\ub9ac\ud558\ub294 \uc0ac\ub840\uc5d0\uc11cBatch\uc791\uc5c5\uc2dcBitmapped Index\ub4e4\uc744Disable\uc2dc\ud0a4\uace0 \ucc98\ub9ac\ud6c4Enable\ud558\u00a0\u00a0 \uac83\uc774 \ubc14\ub78c\uc9c1.<\/p>\n

       <\/p>\n

      3.Oracle’s Bitmapped Index<\/strong>\uc758<\/strong> \ud2b9\uc131<\/strong> ?<\/strong><\/p>\n

      Oracle\uc5d0\uc11c\uc758Bitmapped Index\ub294 \ub2e4\uc74c\uc758 \uc774\uc810\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n

       <\/p>\n

      \uac80\uc99d\ub41c \uae30\uc220<\/strong><\/p>\n

      – \uc774\ubbf8Oracle7\uc758Text Server\uc5d0\uc11cBitmapped Technology\ub97c \uc801\uc6a9\ud558\uc5ec \uc0ac\uc6a9\ud558\uc5ec \uc654\uc73c\uba70 \uc774\ub7ec\ud55c \uae30\uc220\uc744Oracle7 Release7.3\uc5d0\uc11cProduction \uc73c\ub85c \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n

       <\/p>\n

      \ud1b5\ud569\uae30\ub2a5\uc73c\ub85c \uc81c\uacf5<\/strong><\/p>\n

      – \ubcc4\ub3c4\uc758 \uae30\ub2a5\uc635\uc158 \ucd94\uac00\uc5c6\uc774Oracle Server\uc5d0 \ud1b5\ud569\ub418\uc5b4 \uc81c\uacf5\ub429\ub2c8\ub2e4.<\/p>\n

      – \uae30\uc874 \uc0ac\uc6a9 \ubaa8\ub4e0 \ud658\uacbd\uacfc \uc218\uc815\uc5c6\uc774 \ud1b5\ud569 \uc801\uc6a9\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/p>\n

      (\uc608: DB Trigger, Distributed, Parallel, Integrity constraints…)<\/p>\n

      – \uac01\uc885SQL, Tool \ubc0fUtility, Application\ub4f1\uc5d0\uc11c \uc218\uc815\uc774 \ud544\uc694\uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n

       <\/p>\n

      \ubcd1\ub82cIndex \uc0dd\uc131 \uc9c0\uc6d0<\/strong><\/p>\n

      – \ubc29\ub300\ud55c \uc790\ub8cc\uc5d0 \ub300\ud55cIndex\uc0dd\uc131\uc2dc \ubcd1\ub82c\uc218\ud589\uc73c\ub85cBitmapped Index\uc0dd\uc131<\/p>\n

      \uc555\ucd95\uae30\ub2a5<\/strong><\/p>\n

      – \uc800\uc7a5\uacf5\uac04\uc744 \ud604\uc800\ud788 \uc904\uc77c \uc218 \uc788\uac8c \uad6c\ud604\ub41c \uc555\ucd95\uae30\ubc95\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n

       <\/p>\n

      \uc785\ub825\/\uc218\uc815\/\uc0ad\uc81c \uc9c0\uc6d0<\/strong><\/p>\n

      – Oracle\uc758Bitmapped Index\ub294Insert,Update,Delete \ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4.<\/p>\n

      (\uc740\ud589 \uacc4\uc815\uc5c5\ubb34 \uc640 \uac19\uc740 \ubb34\ub9ac\ud55cOLTP transaction\uc774 \uc544\ub2cc \ud558\ub8e8\uc5c5\ubb34 \uc911\uc5d0 \uc57d10% \uc774\ub0b4\uc758 \uc790\ub8cc\ubcc0\uacbd \uc5c5\ubb34\ub294 \uadf8\ub300\ub85c \uc0ac\uc6a9 \uac00\ub2a5)<\/p>\n

      – \uc0ac\uc6a9\uc790\ub85c \ud558\uc5ec\uae08 \uac00\ub054 \uc720\ubc1c\ub418\ub294 \ubcc0\uacbd\uc5d0 \ub300\ud574\uc11cBitmapped Index\ub97c \uc7ac\uc0dd\uc131\uc774 \ubd88\ud544\uc694\ud558\uac8c \ud22c\uba85\ud558\uac8c \uc0ac\uc6a9\uac00\ub2a5.<\/p>\n

       <\/p>\n

      \ubcd1\ub82cIndex \uac80\uc0c9 \uc9c0\uc6d0<\/strong><\/p>\n

      – \ub300\ub7c9\uc758Table\uc5d0 \ub300\ud55c \uac80\uc0c9\uc2dc \ubcd1\ub82c\ub85cBitmapped Index \uac80\uc0c9 \uac00\ub2a5.<\/p>\n

      \uc5ec\ub7ec\uceec\ub7fc\uc5d0 \ub300\ud55cBitmapped Index \uc9c0\uc6d0<\/p>\n

      – \ubd84\ud3ec\ub3c4\uac00 \ub098\uc05c \uba87\uac1c\uc758 \uceec\ub7fc\uc774 \ud56d\uc2dc \uac19\uc774 \uc870\uac74\uc5d0 \uc624\ub294 \uacbd\uc6b0B-Tree Index\uc5d0\uc11c\uc758Concatenated Index\uac19\uc774Multicolumn Bitmapped Index \uc0ac\uc6a9\uac00\ub2a5.<\/p>\n

       <\/p>\n

      \uc720\uc5f0\uc131 \ubcf4\uc7a5<\/strong><\/p>\n

      – \ud558\ub098\uc758Table\uc5d0B-tree Index\uc640Bitmapped Index\ub97c \ub3d9\uc2dc \ud63c\uc6a9\uac00\ub2a5.<\/p>\n

      (Clustered Index\ub3c4 \ud63c\uc6a9 \uc0dd\uc131 \uac00\ub2a5)<\/p>\n

       <\/p>\n

      Oracle\uc5d0\uc11c\uc758 \ud14c\uc2a4\ud2b8 \uc608\uc81c<\/p>\n

       <\/p>\n

      Oracle\uc5d0\uc11c\uc758Bitmapped Index\uc758 \ud2b9\uc131\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub294 \uc608\uc2dc \uc785\ub2c8\ub2e4.<\/p>\n

       <\/p>\n

      \uace0\uac1d\uc815\ubcf4\uc790\ub8cc\ub294 \uc57d100\ub9cc\uac74\uc758 \uc790\ub8cc\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\uc73c\uba70 \ud604\uc7ac \uace0\uac1d\ubc88\ud638\ub294 \uc720\uc77c\ud55c \uac12\uc73c\ub85c \uad6c\uc131\ub418\uba70Primary Key\ub85c \uc120\uc5b8\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098, \uc131\ubcc4 \uacfc \uc911\uc694\ub3c4, \ud63c\uc778\uc5ec\ubd80 \uceec\ub7fc\uc758 \uac12\uc7402\uac00\uc9c0 \ub0b4\uc9c0\ub2943\uac00\uc9c0 \uc885\ub958\uc774\uc5b4\uc11cB-Tree Index\ub85c\ub294 \uac80\uc0c9\uc218\ud589 \uc18d\ub3c4\ub97c \ubcf4\uc7a5\ud560 \uc218 \uc5c6\ub294 \uc0c1\ud669\uc784.<\/p>\n

       <\/p>\n

      1) Select * from \uace0\uac1d\uc815\ubcf4where \uc131\ubcc4= ‘\ub0a8’;<\/p>\n

      \ubcf8SQL\uc744Optimizer\ub294 \ucd5c\uc801\uc758Execution Plan\uc73c\ub85c Parallel Full<\/p>\n

      Table Scan\uc744 \uc120\ud0dd\ud558\uac8c \ub429\ub2c8\ub2e4. (\uc804\uccb4\uc75850%\uc774\ubbc0\ub85c)<\/p>\n

       <\/p>\n

      2) Select * from \uace0\uac1d\uc815\ubcf4where \uace0\uac1d\ubc88\ud638 = 1001;<\/p>\n

      \ubcf8SQL\uc744Optimizer\ub294 \ucd5c\uc801\uc758Execution Plan\uc73c\ub85c Unique B-tree<\/p>\n

      Index\ub97cAccess \ud558\uc5ecRowid\ub97c \uac00\uc9c0\uace0Table \uc7441\ubc88 Scan.<\/p>\n

       <\/p>\n

      3) Select * from \uace0\uac1d\uc815\ubcf4<\/p>\n

      where \uc131\ubcc4= ‘\ub0a8’ and \uc911\uc694\ub3c4in (‘\uc0c1’,’\uc911’);<\/p>\n

      \ubcf8SQL\uc744Optimizer\ub294 \ucd5c\uc801\uc758Execution Plan\uc73c\ub85c Bitmapped Index<\/p>\n

      \ub97c \uc120\ud0dd\ud558\uac8c \ub429\ub2c8\ub2e4.<\/p>\n

       <\/p>\n

      4) Select * from \uace0\uac1d\uc815\ubcf4<\/p>\n

      where \uc131\ubcc4= ‘\ub0a8’ and \uace0\uac1d\ubc88\ud638 = 1001;<\/p>\n

      \ubcf8SQL\uc744Optimizer\ub294 \ucd5c\uc801\uc758Execution Plan\uc73c\ub85cB-tree Index\ub97c<\/p>\n

      Range Scan\ud558\ub294 \ubc29 \uc744 \uc120\ud0dd\ud558\uac8c \ub429\ub2c8\ub2e4.<\/p>\n

      (\uc131\ubcc4Bitmapped Index \ubcf4\ub2e4\ub294Unique\ud55c \uace0\uac1d\ubc88\ud638Index\uac00 \ud6a8\uc728\uc801)<\/p>\n

       <\/p>\n

      \uc0c1\uae30\uc640\uac19\uc774Oracle \uc5d0\uc11c\uc758Bitmapped Index\ub294Cost Based Optimizer\uc5d0 \uc758\ud574 \ud22c\uba85\ud558\uace0 \uc720\uc5f0\uc131\uc788\uac8c \uc218\ud589\uc18d\ub3c4\ub97c \ubcf4\uc7a5\ud558\uac8c \ub418\uba70, \ud544\uc694\uc2dcOracle\uc758 \ud2b9\uc9d5\uc778Optimizer \ucde8\uc0ac \uc120\ud0dd\uae30\ub2a5\uc73c\ub85c \uc0ac\uc6a9\uc758\ub3c4\uc5d0 \ub9de\ucd94\uc5b4<\/p>\n

      \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/p>\n

       <\/p>\n

      \uacb0<\/strong> \ub860<\/strong><\/p>\n

       <\/p>\n

      Data Warehousing \ub610\ub294Decision Support System\uc5d0\uc11c\uc758 \ud544\uc694\ud55c \uc694\uc18c\uc778Oracle\uc758Bitmapped Index\ub294Release7.3 Server\uc5d0 \ud0d1\uc7ac\ub418\uac8c \ub418\uc5c8\uc73c\uba70 \uae30\uc874RDBMS\uc5d0\uc11c\uc758 \uc870\ud68c \uc218\ud589\uc18d\ub3c4\uc758 \uba87\uac00\uc9c0 \uac78\ub9bc\ub3cc\uc744 \ud574\uacb0\ucf00 \ud558\uc600\uace0, \ub610\ud55c \ubc29\ub300\ud55c \uc790\ub8cc\ub7c9\uc5d0 \ub300\ud55cIndex\uc758 \uc800\uc7a5\uacf5\uac04 \uc808\uc57d \ubc0fEnd-User-computing\uc5d0 \uaf2d \ud544\uc694\ud55cIndexing \uad6c\ud604\uae30\ubc95\uc785\ub2c8\ub2e4.<\/p>\n

      \ub2e8, Bitmapped Index\ub9cc\uc774 \uc9c0\uc0c1 \ucd5c\ub300\uc758 \ud574\ubc95\uc774 \uc544\ub2c8\ub780 \uac83\ub3c4 \uc6b0\ub9ac\ub294 \uc54c\uc544\uc57c \ud558\uba70 \uc0ac\uc804\uc5d0OLTP\uc5d0\uc11c\uc758 \ubd80\ub2f4\uac10\uc5d0 \ub300\ud55c \ubd84\uc11d\uc774 \ud544\uc694 \u00a0 \uba70, \uacfc\uc5f0 \ub098\uc05c\ubd84\ud3ec\ub3c4\uc5d0\uc11c \uc800\uc7a5\uacf5\uac04\uc5d0 \ub300\ud55c \ub0ad\ube44\uc5d0\ub294 \ub9ce\uc740 \uad00\uc2ec\uc774 \uc5c6\uace0 \ub2e8\uc9c0 \uc88b\uc740 \uc870\ud68c\uc18d\ub3c4\ub97c \ubcf4\uc7a5\ud0a4 \uc704\ud55c\ub2e4\uba74 \uc774\ubbf8 \uae30\uc874Oracle7\uc5d0\uc11c\ubd80\ud130 \uc0ac\uc6a9\ud574\uc628Clustered Index\ub97c \uac80\ud1a0\ud574 \ubcf4\ub294 \uac83\uc774 \ud0c0\ub2f9\ud558\ub9ac\ub77c\uace0 \uc0ac\ub8cc\ub429\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"

      Datawarehousing\ud658\uacbd \uacfcEnd-User-Computing\ud658\uacbd\ub4f1\uc5d0\uc11c \ud544\uc694\ud55cRDBMS\uc758 \ucca8\ub2e8Indexing Access\uae30\ubc95\uc73c\ub85c \uacbd\uc7c1\uc0ac\uc5d0\uc11c\ub294Bitwised Index\ub97c \ubc1c\ud45c\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uae30\ubc95\uc740Oracle Server V7.3\uc5d0\uc11c\ub3c4Bitmapped Index\ub77c\ub294 \uc774\ub984\uc73c\ub85c \ubc1c\ud45c\ub420 \uc608\uc815\uc774\ubbc0\ub85c \uc774\uc5d0 \ub300\ud55c \uc815\ud655\ud55c \uc774\ud574\ub97c \uc704\ud574 \ub2e4\uc74c\uc0ac\ud56d\uc744 \uae30\uc220\ud574 \ubcf4\uc558\uc2b5\ub2c8\ub2e4.   Bitmapped Index\ub780 ? RDBMS\uc758Table\ub85c\ubd80\ud130 \ud2b9\uc815 \uc790\ub8cc\uc758 \uac80\uc0c9\uc744 \uc704\ud574 \uae30\uc874\uc758 \uc77c\ubc18RDBMS\uc5d0\uc11c\ub294\uac80\uc0c9\ud6a8\uc728\uc758 \ud5a5\uc0c1\uc744 \uc704\ud574B-Tree Index\ub97c \uad6c\ud604\ud558\uc5ec \uc0ac\uc6a9\ud558\uc5ec \uc654\uc2b5\ub2c8\ub2e4. \uadf8\uc678\uc5d0\ub3c4B-tree Cluster Index, Hash Cluster Index\ub4f1\uc744 \uc774\uc6a9\ud558\uc5ec \u00a0 \ub300\ubd80\ubd84\uc758 \uac80\uc0c9\ud6a8\uc728\uc744 \ubcf4\uc7a5\ud558\uc5ec \uc654\uc9c0\ub9ccB-Tree Access\ub97c […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[219],"tags":[872,869,871,870],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2671"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2671"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2671\/revisions"}],"predecessor-version":[{"id":2672,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2671\/revisions\/2672"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2671"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2671"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2671"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}