{"id":1153,"date":"2016-01-03T10:00:39","date_gmt":"2016-01-03T10:00:39","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1153"},"modified":"2016-01-03T10:00:39","modified_gmt":"2016-01-03T10:00:39","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-%ec%8a%a4%ed%82%a4%eb%a7%88-%ec%98%a4%eb%b8%8c%ec%a0%9d%ed%8a%b8","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1153","title":{"rendered":"\uc624\ub77c\ud074 \uc2a4\ud0a4\ub9c8 \uc624\ube0c\uc81d\ud2b8"},"content":{"rendered":"<p><P style=\"MARGIN-LEFT: 21pt\"><SPAN style=\"FONT-SIZE: 14pt; FONT-FAMILY: HY\ud5e4\ub4dc\ub77c\uc778M; COLOR: black\">\ud14c\uc774\ube14(Table) <\/SPAN><\/P><br \/>\n<UL><br \/>\n<LI><SPAN style=\"COLOR: black\">\ub370\uc774\ud130 \uc2a4\ud1a0\ub9ac\uc9c0\uc758 \uae30\ubcf8 \ub2e8\uc704\ub85c, \ud589(row)\uacfc \uc5f4(column)\ub85c \uc800\uc7a5\ub429\ub2c8\ub2e4. <SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"><\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">\uc2e4\uc81c \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc9c0\ub9cc \uc0ac\uc6a9\uc790\uac00 \uc9c0\uc815\ud55c \ud45c\ud604\uc2dd\uc774\ub098 \ud568\uc218\uc5d0 \uc758\ud574 \uacc4\uc0b0\ub420 \uc218 \uc788\ub294 \uac00\uc0c1 \uceec\ub7fc(virtual column)\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">\ud14c\uc774\ube14\uc5d0 \ub300\ud55c \uc555\ucd95 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">\ud30c\ud2f0\uc154\ub2dd \uc635\uc158\uc744 \ud1b5\ud574, \ub2e4\uc591\ud55c \ud30c\ud2f0\uc154\ub2dd \uae30\ubc95\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">\ud14c\uc774\ube14\uc758 \uc5f4\ub85c \ub610 \ub2e4\ub978 \ud14c\uc774\ube14\uc744 \uc815\uc758\ud560 \uc218 \uc788\ub294 Nested Table \uae30\ub2a5\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">\ud2b9\uc815 \ud2b8\ub79c\uc7ad\uc158\uc774\ub098 \uc138\uc158\uc5d0 \ud55c\ud574 \uc784\uc2dc \ud14c\uc774\ube14(temporary table)\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud574\ub2f9 \ud2b8\ub79c\uc7ad\uc158\uc774\ub098 \uc138\uc158\uc774 \uc885\ub8cc\ub418\uba74 \ud574\ub2f9 \ub370\uc774\ud130\ub294 \uc790\ub3d9\uc73c\ub85c \uc0ac\ub77c\uc9d1\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"COLOR: black\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc678\ubd80\uc5d0 \uc874\uc7ac\ud558\ub294 \uc77c\ubc18 \ub370\uc774\ud130\uc5d0 \ub300\ud574 \uc774\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub0b4\uc758 \uc77c\ubc18 \ud14c\uc774\ube14\ucc98\ub7fc \uc77d\uae30 \uc791\uc5c5\uc744 \ud560 \uc218 \uc788\ub294 \uc678\ubd80 \ud14c\uc774\ube14(external table)\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"><\/SPAN><\/SPAN><\/DIV><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 14pt; FONT-FAMILY: HY\ud5e4\ub4dc\ub77c\uc778M; COLOR: black\">\ubdf0(View) <\/SPAN><\/P><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">\ubdf0\ub294 \ud558\ub098 \ud639\uc740 \uadf8 \uc774\uc0c1\uc758 \ud14c\uc774\ube14\uc774\ub098 \ub2e4\ub978 \ubdf0\uc5d0 \uc800\uc7a5\ub41c \ub370\uc774\ud130\uc5d0 \ub300\ud55c \ub9de\ucda4\ud615 \ud45c\ud604 \ubc29\ubc95\uc785\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">\ubdf0\ub294 \ud14c\uc774\ube14\ucc98\ub7fc \uc0ac\uc6a9\ud560 \uc218 \uc788\uc9c0\ub9cc, \ud14c\uc774\ube14\uacfc\ub294 \ub2ec\ub9ac \ubcc4\ub3c4\uc758 \uc800\uc7a5 \uacf5\uac04\uc774 \ud544\uc694\uce58 \uc54a\uc2b5\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">\uc870\uc778 \ubdf0(Join View)\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc73c\uba70, DML \ubb38\uc7a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uacbd\uc6b0\ub97c Updatable Join View\ub77c\uace0 \ud569\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"COLOR: black\">\ubcc4\ub3c4\uc758 \uc2a4\ud0a4\ub9c8 \uc624\ube0c\uc81d\ud2b8\ub294 \uc544\ub2c8\uc9c0\ub9cc, SQL \ubb38\uc7a5 \uc548\uc5d0 \ubdf0\ucc98\ub7fc \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 subquery\ub97c Inline View\ub77c\uace0 \ud569\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/DIV><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 14pt; FONT-FAMILY: HY\ud5e4\ub4dc\ub77c\uc778M; COLOR: black\">\ud074\ub7ec\uc2a4\ud130(Cluster) <\/SPAN><\/P><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">\uc8fc\ub85c \ud568\uaed8 \uc0ac\uc6a9\ub418\ub294 \uacf5\uc6a9 \uceec\ub7fc \uac12\ub4e4\uc744 \uae30\uc900\uc73c\ub85c \ub3d9\uc77c\ud55c \ub370\uc774\ud130 \ube14\ub85d\uc5d0 \ud14c\uc774\ube14 \ub370\uc774\ud130 \ub4e4\uc774 \uc800\uc7a5\ub418\ub3c4\ub85d \ud558\ub294\ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"COLOR: black\">Index cluster \ud615\ud0dc\ub97c \uc4f8 \uc218\ub3c4 \uc788\uace0, cluster key \uac12\uc5d0 \ub300\ud55c hash function\uc758 \uacb0\uacfc \uac12\uc5d0 \ub530\ub77c \uc800\uc7a5\ud558\ub294 \ud615\ud0dc\ub97c \uc0ac\uc6a9\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/DIV><br \/>\n<P><SPAN style=\"FONT-SIZE: 14pt; FONT-FAMILY: HY\ud5e4\ub4dc\ub77c\uc778M; COLOR: black\">Materialized View <\/SPAN><\/P><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">\ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc694\uc57d, \uacc4\uc0b0, \ubcf5\uc81c, \ubd84\uc0b0 \ub4f1\uc5d0 \uc0ac\uc6a9\ub418\ub294 \uc2a4\ud0a4\ub9c8 \uc624\ube0c\uc81d\ud2b8\uc785\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"COLOR: black\">\ubcc4\ub3c4\uc758 \uc800\uc7a5 \uacf5\uac04 \uc0ac\uc6a9, \ub9c8\uc2a4\ud130 \ud14c\uc774\ube14\uc774 \ubcc0\uacbd\ub418\uba74 \ubc18\uc601\ub418\ub294 \uc810, SQL \uc2e4\ud589 \uc18d\ub3c4\uc758 \ud5a5\uc0c1, Query Rewrite\uc5d0 \uc758\ud55c SQL\uc758 \ud22c\uba85\uc131 \ub4f1\uc758 \uc758\ubbf8\uc5d0\uc11c \uc778\ub371\uc2a4\uc640 \uc720\uc0ac\ud55c \uac1c\ub150\uc785\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/DIV><br \/>\n<P><SPAN style=\"FONT-SIZE: 14pt; FONT-FAMILY: HY\ud5e4\ub4dc\ub77c\uc778M; COLOR: black\">Materialized View Log <\/SPAN><\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"COLOR: black\">Materialized View\uac00 \uc815\uc758\ub41c \ub9c8\uc2a4\ud130 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\uac00 \ubcc0\uacbd\ub41c \uacbd\uc6b0, \uc774\ub97c \uc810\uc9c4\uc801\uc73c\ub85c \ube60\ub974\uac8c \ubc18\uc601\ud560 \uc218 \uc788\ub3c4\ub85d \ub9c8\uc2a4\ud130 \ud14c\uc774\ube14\uc758 \ubcc0\uacbd \ub0b4\uc5ed\uc744 \uc800\uc7a5\ud558\ub294 \uc624\ube0c\uc81d\ud2b8\uc785\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/DIV><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 14pt; FONT-FAMILY: HY\ud5e4\ub4dc\ub77c\uc778M; COLOR: black\">\ucc28\uc6d0(Dimension) <\/SPAN><\/P><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">DW \ud658\uacbd\uc5d0\uc11c \ub9ce\uc774 \uc0ac\uc6a9\ub418\ub294 \uc77c\/\uc6d4\/\ub144 \ub4f1\uacfc \uac19\uc774, \uceec\ub7fc\ub4e4 \ud639\uc740 \uceec\ub7fc \uc9d1\ud569\ub4e4 \uac04\uc758 \uacc4\uce35\uc801 \uad00\uacc4\ub97c \uc815\uc758\ud558\ub294 \uc624\ube0c\uc81d\ud2b8\uc785\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"COLOR: black\">\ubcc4\ub3c4\uc758 \uc800\uc7a5 \uacf5\uac04\uc774 \ud544\uc694\uce58 \uc54a\uc2b5\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/DIV><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 14pt; FONT-FAMILY: HY\ud5e4\ub4dc\ub77c\uc778M; COLOR: black\">\uc2dc\ud000\uc2a4(Sequence) <\/SPAN><\/P><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">\uc720\uc77c\ud55c \uc77c\ub828 \ubc88\ud638\ub97c \uc27d\uace0 \ube60\ub974\uac8c \uc5bb\uc744 \uc218 \uc788\ub294 \uc624\ube0c\uc81d\ud2b8\uc785\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"COLOR: black\">\uc624\ub984\ucc28\uc21c\/\ub0b4\ub9bc\ucc28\uc21c\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\uace0, \ubc88\ud638\ub4e4 \uac04\uc758 \uc778\ud130\ubc8c\uc744 \ub458 \uc218 \uc788\uace0, \uba54\ubaa8\ub9ac\uc5d0 \uce90\uc26c \uc2dc\ud0ac \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/DIV><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 14pt; FONT-FAMILY: HY\ud5e4\ub4dc\ub77c\uc778M; COLOR: black\">Synonym <\/SPAN><\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"COLOR: black\">\ud14c\uc774\ube14, \ubdf0, materialized view, \uc2dc\ud000\uc2a4, procedure, function, package, type, \ub610 \ub2e4\ub978 synonym\uc5d0 \ub300\ud55c alias\ub85c data dictionary\uc5d0 \uc815\uc758\ub9cc \uc800\uc7a5\ub420 \ubfd0\uc774\uc9c0, \ubcc4\ub3c4\uc758 \uc800\uc7a5 \uacf5\uac04\uc774 \ud544\uc694\uce58 \uc54a\uc2b5\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/DIV><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 14pt; FONT-FAMILY: HY\ud5e4\ub4dc\ub77c\uc778M; COLOR: black\">\uc778\ub371\uc2a4(Index) <\/SPAN><\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"COLOR: black\">\ub2e4\uc74c\uacfc \uac19\uc774 \ub2e4\uc591\ud55c \uc778\ub371\uc2a4 \uae30\ubc95\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/DIV><br \/>\n<UL style=\"MARGIN-LEFT: 54pt\"><br \/>\n<LI><SPAN style=\"COLOR: black\">B-tree index<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">B-tree cluster index<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">Hash cluster index<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">Reverse key index<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">Bitmap index<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">Bitmap join index<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">Function-based index<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">Domain index<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><\/UL><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">Unique index\uc640 Nonunique index\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">\uc5ec\ub7ec \uceec\ub7fc\uc744 \uc870\ud569\ud574\uc11c \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"COLOR: black\">\uc778\ub371\uc2a4\ub97c invisible \uc0c1\ud0dc\ub85c \ubcc0\uacbd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 DML \uc624\ud37c\ub808\uc774\uc158\uc758 \uacb0\uacfc\ub294 \uc774 \uc778\ub371\uc2a4\uc5d0 \uc720\uc9c0\ub418\uc9c0\ub9cc, \uc635\ud2f0\ub9c8\uc774\uc800\uc5d0 \uc758\ud574\uc11c\ub294 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc778\ub371\uc2a4 \uc0dd\uc131 \uacb0\uacfc\ub97c \uac80\uc99d\ud55c \ud6c4 visible \uc0c1\ud0dc\ub85c \ubcc0\uacbd\ud558\uba74, \uc774 \ub54c\ubd80\ud130 \uc635\ud2f0\ub9c8\uc774\uc800\uac00 \uc774 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uac8c \ub429\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/DIV><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 14pt; FONT-FAMILY: HY\ud5e4\ub4dc\ub77c\uc778M; COLOR: black\">Index-Organized Table(IOT) <\/SPAN><\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"COLOR: black\">\uc774\ub294 \uc778\ub371\uc2a4\uc640 \ud14c\uc774\ube14\uc744 \ud558\ub098\ub85c \ud569\uce5c \uac83\uacfc \uac19\uc740 \uac1c\ub150\uc73c\ub85c, \uc77c\ubc18 \ud14c\uc774\ube14\uc758 \uacbd\uc6b0\uc5d4 \ub370\uc774\ud130\uac00 \uc21c\uc11c\uc5c6\uc774 \uc800\uc7a5\ub418\ub294 \ubc18\uba74, \uc774 IOT\uc5d0\uc11c\ub294 primary key \uc21c\uc73c\ub85c B-tree \uc778\ub371\uc2a4 \uad6c\uc870\uc5d0 \uc800\uc7a5\ub429\ub2c8\ub2e4. \ub610\ud55c primary key \uceec\ub7fc \uac12 \ubfd0 \uc544\ub2c8\ub77c, \ub2e4\ub978 \uceec\ub7fc\ub4e4\uc758 \uac12\ub4e4\ub3c4 \ubaa8\ub450 \uc774 \ud55c \uc624\ube0c\uc81d\ud2b8\uc5d0 \uc800\uc7a5\ub429\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/DIV><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"COLOR: black\">&nbsp; <\/SPAN>&nbsp;<\/P><\/LI><\/UL><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ud14c\uc774\ube14(Table) \ub370\uc774\ud130 \uc2a4\ud1a0\ub9ac\uc9c0\uc758 \uae30\ubcf8 \ub2e8\uc704\ub85c, \ud589(row)\uacfc \uc5f4(column)\ub85c \uc800\uc7a5\ub429\ub2c8\ub2e4. \uc2e4\uc81c \ub514\uc2a4\ud06c \uacf5\uac04\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc9c0\ub9cc \uc0ac\uc6a9\uc790\uac00 \uc9c0\uc815\ud55c \ud45c\ud604\uc2dd\uc774\ub098 \ud568\uc218\uc5d0 \uc758\ud574 \uacc4\uc0b0\ub420 \uc218 \uc788\ub294 \uac00\uc0c1 \uceec\ub7fc(virtual column)\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \uc555\ucd95 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud30c\ud2f0\uc154\ub2dd \uc635\uc158\uc744 \ud1b5\ud574, \ub2e4\uc591\ud55c \ud30c\ud2f0\uc154\ub2dd \uae30\ubc95\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud14c\uc774\ube14\uc758 \uc5f4\ub85c \ub610 \ub2e4\ub978 \ud14c\uc774\ube14\uc744 \uc815\uc758\ud560 \uc218 \uc788\ub294 Nested Table \uae30\ub2a5\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. [&hellip;]<\/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":[9],"tags":[649,650],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1153"}],"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=1153"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1153\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1153"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}