{"id":327,"date":"2024-07-08T05:16:14","date_gmt":"2024-07-08T05:16:14","guid":{"rendered":"https:\/\/the.2days.kr\/?p=327"},"modified":"2024-07-08T05:16:14","modified_gmt":"2024-07-08T05:16:14","slug":"%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4%eb%9e%80-%eb%ac%b4%ec%97%87%ec%9d%b8%ea%b0%80","status":"publish","type":"post","link":"https:\/\/the.2days.kr\/?p=327","title":{"rendered":"\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub780 \ubb34\uc5c7\uc778\uac00?"},"content":{"rendered":"
\n

\n
\n
\n<\/span>
\n \ub370\uc774\ud130\ubca0\uc774\uc2a4
\n <\/figcaption><\/figure>\n<\/p>\n

\n
\n \ub370\uc774\ud130\ubca0\uc774\uc2a4(Database)
\n <\/b>
\n
\n \ucef4\ud4e8\ud130\ub294 \uc5ec\ub7ec \uac00\uc9c0 \uc6a9\ub3c4\ub85c \ub9ce\uc740 \uc591\uc758 \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud569\ub2c8\ub2e4. \ud68c\uc0ac\uc5d0\uc11c\ub294 \ub9e4\ucd9c\uacfc \uc9c1\uc6d0\ub4e4\uc758 \uc815\ubcf4\ub97c \uae30\ub85d\ud558\uc5ec \uad00\ub9ac\ud558\uace0, \ubcd1\uc6d0\uc5d0\uc11c\ub294 \ud654\uc790\ub4e4\uc758 \uc9c4\ub8cc \ub0b4\uc5ed\uc744 \ucef4\ud4e8\ud130\uc5d0 \uae30\ub85d\ud558\uc5ec \uad00\ub9ac\ud569\ub2c8\ub2e4.\n <\/p>\n

\n \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub780 \ucef4\ud4e8\ud130\uc5d0 \uc800\uc7a5\ub41c \ub370\uc774\ud130\ub4e4\uc744 \ud1b5\ud569\ud558\uc5ec \uc800\uc7a5\ud558\uace0 \uad00\ub9ac\ud558\ub294 \ubaa8\uc784\uc774\uace0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c(DBMS : Database Management System)\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uad00\ub9ac\ud558\ub294 \ud504\ub85c\uadf8\ub7a8\uc758 \uc9d1\ud569\uc785\ub2c8\ub2e4. \uc800\uc7a5\ub41c \ub370\uc774\ud130\uc758 \uc591\uc774 \ubc29\ub300\ud558\uace0 \ub9ce\uc740 \uc0ac\ub78c\ub4e4\uc774 \uc0ac\uc6a9\ud560\uc218\ub85d \ud6a8\uc728\uc801\uc785\ub2c8\ub2e4. \ub2e4\uc2dc \ub9d0\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc758 \ubaa9\uc801\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uace0, \uc800\uc7a5\ub41c \ub370\uc774\ud130\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uac80\uc0c9 \ubc0f \uc218\uc815\ud560 \uc218 \uc788\ub294 \ud658\uacbd\uc744 \uc81c\uacf5\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.\n <\/p>\n

\n \uc804\ud615\uc801\uc778 \ud30c\uc77c \ucc98\ub9ac \uc2dc\uc2a4\ud15c\uc758 \ubb38\uc81c\uc810\uacfc \uadf8 \ub300\uc548\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uace0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc758 \uc5ed\ud560 \ubc0f \ub3c4\uc785 \uc2dc \uc7a5\uc810, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5b8\uc5b4\uc640 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790\uae4c\uc9c0 \uc0b4\ud3b4\ubcf4\ub3c4\ub85d \ud569\uc2dc\ub2e4.\n <\/p>\n

\n
\n
\n<\/span>
\n \ub9c8\uc774\ud06c\ub85c\uc18c\ud504\ud2b8\uc0ac\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc18c\ud504\ud2b8\uc6e8\uc5b4 \ubc0f \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8, Access
\n <\/figcaption><\/figure>\n<\/p>\n

\n
\n \ud30c\uc77c \ucc98\ub9ac \uc2dc\uc2a4\ud15c
\n <\/b>
\n
\n \ud30c\uc77c\uc744 \uad6c\uc131\ud558\ub294 \uae30\ubcf8\uc801 \uc694\uc18c\ub294 \ub808\ucf54\ub4dc(Record)\uc774\uace0 \ud558\ub098\uc758 \ub808\ucf54\ub4dc\ub294 \uc5f0\uad00\ub41c \ud544\ub4dc(Field)\uc758 \uc9d1\ud569\uc73c\ub85c \uad6c\uc131\ub429\ub2c8\ub2e4. \ub808\ucf54\ub4dc\ub294 \uc790\ub8cc\ub97c \uc800\uc7a5\ud558\uac70\ub098 \ud45c\ud604\ud558\ub294 \uae30\ubcf8 \ub2e8\uc704\uc774\uace0, \ud544\ub4dc\ub294 \uc18d\uc131\uc744 \ub098\ud0c0\ub0b4\ub294 \uc815\ubcf4\uc758 \ucd5c\uc18c \ub2e8\uc704\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \ud68c\uc0ac\uc6d0\uc758 \ub808\ucf54\ub4dc\ub294 \uc784\uc6a9\uc77c, \ubd80\uc11c, \uc131\uba85\ucc98\ub7fc \uc18d\uc131\uc744 \ub098\ud0c0\ub0b4\ub294 \ud544\ub4dc\ub4e4\ub85c \uad6c\uc131\ub429\ub2c8\ub2e4.\n <\/p>\n

\n \ud30c\uc77c \ucc98\ub9ac \uc2dc\uc2a4\ud15c\uc740 \uc544\ub798\uc758 \uc774\ubbf8\uc9c0\uc640 \uac19\uc774 \uac01 \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\ub9c8\ub2e4 \ubcc4\ub3c4\uc758 \ub370\uc774\ud130 \ud30c\uc77c\uc744 \uc720\uc9c0\ud558\uc9c0\ub9cc \ub370\uc774\ud130 \uc885\uc18d\uacfc \ub370\uc774\ud130 \uc911\ubcf5\uc774\ub77c\ub294 \ubb38\uc81c\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n

\n
\n
\n<\/span>
\n \ud30c\uc77c \ucc98\ub9ac \uc2dc\uc2a4\ud15c
\n <\/figcaption><\/figure>\n<\/p>\n

\n \ub370\uc774\ud130 \uc885\uc18d\uc740 \uac01 \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\uacfc \ub370\uc774\ud130 \ud30c\uc77c \uac04\uc758 \uc758\uc874\uc801\uc778 \uc0c1\ud669\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \uc989 \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\uc740 \ub370\uc774\ud130\uc758 \ub17c\ub9ac\uc801\uc778 \uad6c\uc870 \uc678\uc5d0\ub3c4 \ubb3c\ub9ac\uc801\uc778 \uad6c\uc870\uae4c\uc9c0 \uace0\ub824\ud558\uc5ec \uc791\uc131\ud569\ub2c8\ub2e4. \ub530\ub77c\uc11c \ub370\uc774\ud130 \ud30c\uc77c\uc758 \uad6c\uc131 \uc694\uc18c\uc640 \uad6c\uc131 \ubc29\ubc95, \uc811\uadfc \ubc29\ubc95 \ub4f1\uc774 \ubcc0\uacbd\ub418\uba74 \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\ub3c4 \ubcc0\uacbd\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4.\n <\/p>\n

\n \ub370\uc774\ud130 \uc911\ubcf5\uc740 \uc5ec\ub7ec \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ub3d9\uc77c\ud55c \ub370\uc774\ud130 \ud30c\uc77c\uc744 \ud544\uc694\ub85c \ud558\ub354\ub77c\ub3c4 \uac01 \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\ub9c8\ub2e4 \ubcc4\ub3c4\uc758 \ub370\uc774\ud130 \ud30c\uc77c\uc744 \uc720\uc9c0\ud558\ub294 \uac83\uc744 \ub9d0\ud558\uc9c0\ub9cc \uc774\ub85c \uc778\ud574 \uc800\uc7a5 \uacf5\uac04\uc774 \ub0ad\ube44\ub418\uace0 \ub370\uc774\ud130\uc758 \uc218\uc815 \uc81c\uc5b4\uac00 \uc5b4\ub824\uc6cc\uc9c0\uae30 \ub54c\ubb38\uc5d0, \ub370\uc774\ud130 \uc218\uc815 \uc2dc \ub2e4\uc218\uc758 \ub370\uc774\ud130 \ud30c\uc77c\uc5d0\uc11c \ub370\uc774\ud130 \ubd88\uc77c\uce58 \ud604\uc0c1\uc774 \ubc1c\uc0dd\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n

\n \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc774\ub7f0 \ubb38\uc81c\ub4e4\uc744 \ud574\uacb0\ud558\uae30 \uc704\ud574 \ub4f1\uc7a5\ud558\uc600\uc2b5\ub2c8\ub2e4.\n <\/p>\n<\/p>\n

\n
\n \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ud504\ub85c\uadf8\ub7a8
\n <\/b>
\n
\n \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ud55c \uc870\uc9c1\uc758 \uc5ec\ub7ec \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\ub4e4\uc774 \uc800\uc7a5\ub41c \ub370\uc774\ud130\ub97c \uacf5\uc720\ud560 \uc218 \uc788\ub3c4\ub85d \ub370\uc774\ud130\ub97c \ud1b5\ud569\u00b7\uad00\ub9ac\ud569\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ubcd1\uc6d0\uc758 \ud658\uc790 \uad00\ub9ac, \uae30\uc5c5\uc758 \uc815\ubcf4 \uc2dc\uc2a4\ud15c, \ube44\ud589\uae30\uc758 \uc608\uc57d \uc2dc\uc2a4\ud15c \uac19\uc740 \uae30\uc874 \uc751\uc6a9 \ubd84\uc57c \uc678\uc5d0\ub3c4 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4(Data Warehouse), \ub370\uc774\ud130 \ub9c8\uc774\ub2dd, \uba40\ud2f0\ubbf8\ub514\uc5b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4(Multimedia Database)\uc640 \uac19\uc740 \uc0c8\ub85c\uc6b4 \uc751\uc6a9 \ubd84\uc57c\uc5d0\uc11c\ub3c4 \ub110\ub9ac \uc0ac\uc6a9\ub429\ub2c8\ub2e4.
\n
\n * \ub370\uc774\ud130 \ub9c8\uc774\ub2dd – \uc0ac\uc6a9\uc790\uc758 \uc758\uc0ac \uacb0\uc815\uc5d0 \ub3c4\uc6c0\uc744 \uc8fc\uae30 \uc704\ud574 \ub2e4\uc591\ud55c \uc6b4\uc601 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ucd94\ucd9c\u00b7\ubcc0\ud658\u00b7\ud1b5\ud569\u00b7\uc694\uc57d\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub73b\ud569\ub2c8\ub2e4.
\n
\n * \uba40\ud2f0\ubbf8\ub514\uc5b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 – \ub9ce\uc740 \ub370\uc774\ud130 \uac00\uc6b4\ub370 \uc228\uaca8\uc838 \uc788\ub294 \uc720\uc6a9\ud55c \uc0c1\uad00\uad00\uacc4\ub97c \ubc1c\uacac\ud558\uc5ec, \ubbf8\ub798\uc5d0 \uc2e4\ud589 \uac00\ub2a5\ud55c \uc815\ubcf4\ub97c \ucd94\ucd9c\ud574\ub0b4\uace0 \uc758\uc0ac \uacb0\uc815\uc5d0 \uc774\uc6a9\ud558\ub294 \uacfc\uc815\uc744 \ub73b\ud569\ub2c8\ub2e4.
\n
\n * \uba40\ud2f0\ubbf8\ub514\uc5b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 – \uc74c\uc131, \uadf8\ub798\ud53d, \uc601\uc0c1 \ub4f1\uacfc \uac19\uc774 \ub2e4\uc591\ud55c \ub9e4\uccb4\ub97c \ud1b5\ud574 \ud45c\ud604\ub418\ub294 \ub300\ub7c9\uc758 \uc815\ubcf4\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ub418\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub73b\ud569\ub2c8\ub2e4.\n <\/p>\n

\n
\n \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc800\uc7a5\ub41c \ub370\uc774\ud130\uc758 \ud2b9\uc9d5
\n <\/b>
\n
\n – \ud1b5\ud569\ub41c \ub370\uc774\ud130(Integrated Data) : \uc720\uc6a9\ud55c \uc815\ubcf4\ub294 \ud558\ub098\uc758 \uc0ac\uc2e4\uc774 \uc5ec\ub7ec \uac00\uc9c0 \uc0ac\uc2e4\uacfc \uc5f0\uad00\ub418\uc5b4 \ub9cc\ub4e4\uc5b4\uc9c0\ubbc0\ub85c, \ub3c5\ub9bd\ub41c \ub370\uc774\ud130\ub294 \uc720\uc6a9\ud55c \uc815\ubcf4\ub97c \uc81c\uacf5\ud558\uc9c0 \ubabb\ud569\ub2c8\ub2e4. \ud1b5\ud569\ub41c \ub370\uc774\ud130\ub780 \uc5f0\uad00\ub41c \ub370\uc774\ud130\uc758 \ubaa8\uc784\uc785\ub2c8\ub2e4.
\n
\n – \uc800\uc7a5\ub41c \ub370\uc774\ud130(Stored Data) : \uc790\uae30 \ub514\uc2a4\ud06c\ub098 \uad11 \ub514\uc2a4\ud06c\uc640 \uac19\uc740 \ubcf4\uc870\uae30\uc5b5\uc7a5\uce58\uc5d0 \uc800\uc7a5\ub418\uc5b4 \uc788\ub294 \ub370\uc774\ud130\uc758 \ubaa8\uc784\uc785\ub2c8\ub2e4.
\n
\n – \uc6b4\uc601 \ub370\uc774\ud130(Operational Data) : \ubaa8\ub4e0 \uc870\uc9c1\uccb4\ub294 \uc6b4\uc601\uc5d0 \ud544\uc694\ud55c \ub370\uc774\ud130\ub97c \uc218\uc9d1\ud558\uc5ec \uc870\uc9c1\ud55c \ud6c4 \uc800\uc7a5\ud558\uace0 \uad00\ub9ac\ud569\ub2c8\ub2e4. \uc6b4\uc601 \ub370\uc774\ud130\ub780 \ud2b9\uc815 \uc870\uc9c1\uccb4\uc758 \uc874\uc7ac \ubaa9\uc801\uc774\ub098 \uc5ed\ud560 \uce21\uba74\uc5d0\uc11c \ud544\uc694\ud55c \ub370\uc774\ud130\uac00 \uad6c\uc870\uc801\uc73c\ub85c \ud1b5\ud569\ub41c \ubaa8\uc784\uc785\ub2c8\ub2e4.
\n
\n – \uacf5\uc6a9 \ub370\uc774\ud130(Shared Data) : \ub2e4\uc218\uc758 \uc0ac\uc6a9\uc790\uc640 \uc751\uc6a9 \uc2dc\uc2a4\ud15c\ub4e4\uc774 \uacf5\uc720\ud558\ub294 \ub370\uc774\ud130\uc758 \ubaa8\uc784\uc785\ub2c8\ub2e4.\n <\/p>\n

\n
\n \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud2b9\uc9d5
\n <\/b>
\n
\n – \uc2e4\uc2dc\uac04 \uc811\uadfc\uc131 : \uc0ac\uc6a9\uc790\ub098 \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\uc758 \uc694\uad6c\ub97c \uc989\uc2dc \ucc98\ub9ac\ud558\uc5ec \uc751\ub2f5\ud560 \uc218 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.
\n
\n – \uacc4\uc18d\uc801\uc778 \ubcc0\ud654 : \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\uc758 \uc0bd\uc785, \uae30\uc874 \ub370\uc774\ud130\uc758 \uc0ad\uc81c\uc640 \uac31\uc2e0 \ub4f1\uc744 \ud1b5\ud558\uc5ec \uacc4\uc18d \ubcc0\ud654\ud558\uba74\uc11c \uc5b8\uc81c\ub098 \ucd5c\uc2e0 \ub370\uc774\ud130\ub97c \uc720\uc9c0\ud574\uc57c \ud569\ub2c8\ub2e4.
\n
\n – \ub3d9\uc2dc \uacf5\uc720 : \ub2e4\uc218\uc758 \uc0ac\uc6a9\uc790\uc640 \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\ub4e4\uc774 \ub3d9\uc2dc\uc5d0 \uc811\uadfc\ud558\uc5ec \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud558\uace0 \uac31\uc2e0\ud560 \uc218 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.
\n
\n – \ub0b4\uc6a9\uc5d0 \uc758\ud55c \ucc38\uc870 : \ub370\uc774\ud130\ub97c \uac80\uc0c9\ud560 \ub54c \ub370\uc774\ud130\uc758 \uc800\uc7a5 \uc704\uce58\ub098 \uc8fc\uc18c\ub97c \ubab0\ub77c\ub3c4 \uc0ac\uc6a9\uc790\uac00 \uc6d0\ud558\ub294 \uac12\uc744 \uc81c\uc2dc\ud558\uba74 \uad00\ub828 \ub370\uc774\ud130\ub97c \ucc3e\uc544\uc11c \uc81c\uacf5\ud560 \uc218 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4.\n <\/p>\n<\/p>\n

\n
\n \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c(DBMS : Database Management System)
\n <\/b>
\n
\n \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc740 \uc0ac\uc6a9\uc790\uc640 \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\uc5d0 \ud3b8\ub9ac\ud558\uace0 \ud6a8\uc728\uc801\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9 \ud658\uacbd\uc744 \uc81c\uacf5\ud558\ub294 \uc18c\ud504\ud2b8\uc6e8\uc5b4\uc785\ub2c8\ub2e4. \uc904\uc5ec\uc11c ‘DBMS’\ub77c\uace0\ub3c4 \ubd80\ub985\ub2c8\ub2e4. DBMS\uc758 \uc0ac\uc6a9\uc790\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc800\uc7a5\ub41c \ub370\uc774\ud130\uc758 \ubb3c\ub9ac\uc801 \uc800\uc7a5 \uad6c\uc870\ub97c \uc54c \ud544\uc694\uac00 \uc5c6\uc73c\uba70, \ub370\uc774\ud130\uc758 \uc800\uc7a5\uacfc \uac31\uc2e0, \uac80\uc0c9 \uc54c\uace0\ub9ac\uc998\uc744 \uae30\uc220\ud560 \ud544\uc694\ub3c4 \uc5c6\uc2b5\ub2c8\ub2e4.\n <\/p>\n

\n DBMS\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uad6c\uc870\ub97c \uba85\uc2dc\ud558\uace0, \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud558\uba70, \ub370\uc774\ud130\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uac80\uc0c9\ud558\uace0 \uc218\uc815\ud560 \uc218 \uc788\uac8c \ub9cc\ub4ed\ub2c8\ub2e4. \ub610\ud55c \uc2dc\uc2a4\ud15c\uc758 \uace0\uc7a5\uc774\ub098 \uad8c\ud55c\uc774 \uc5c6\ub294 \uc0ac\uc6a9\uc790\ub85c\ubd80\ud130 \ub370\uc774\ud130\ub97c \uc548\uc804\ud558\uac8c \ubcf4\ud638\ud558\uba70, \ub2e4\uc218\uc758 \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud560 \uc218 \uc788\ub3c4\ub85d \uc81c\uc5b4\ud569\ub2c8\ub2e4.\n <\/p>\n

\n \uc544\ub798\uc758 \uc774\ubbf8\uc9c0\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub300\ud55c \ubaa8\ub4e0 \uc811\uadfc\uc774 DBMS\ub97c \ud1b5\ud574 \uc774\ub8e8\uc5b4\uc9c0\ub294 \ubaa8\uc2b5\uc785\ub2c8\ub2e4. \uac01 \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\uc740 DBMS\ub97c \ud1b5\ud574\uc11c\ub9cc \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud558\ubbc0\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uad6c\uc870\uac00 \ubcc0\uacbd\ub418\ub354\ub77c\ub3c4 \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\uc5d0\ub294 \uc601\ud5a5\uc744 \uc8fc\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub9c8\ucc2c\uac00\uc9c0\ub85c \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\uc774 \ubcc0\uacbd\ub418\uc5b4\ub3c4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\ub294 \uc601\ud5a5\uc744 \uc8fc\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uad00\uacc4\ub97c \ud504\ub85c\uadf8\ub7a8-\ub370\uc774\ud130 \ub3c5\ub9bd\uc131(Program-Data Independence)\uc774\ub77c\uace0 \ud569\ub2c8\ub2e4.\n <\/p>\n

\n
\n
\n<\/span>
\n DBMS\ub97c \ud1b5\ud55c \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uad00\ub9ac, \ucd9c\ucc98 : Techtarger – Craig S. Mullins
\n <\/figcaption><\/figure>\n<\/p>\n

\n \ud30c\uc77c \ucc98\ub9ac \uc2dc\uc2a4\ud15c\uacfc \ube44\uad50\ud560 \ub54c DBMS \ub3c4\uc785\uc5d0 \ub530\ub978 \uc7a5\uc810\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.
\n
\n 1. \ub370\uc774\ud130\uc758 \uc911\ubcf5\uacfc \ubd88\uc77c\uce58\uac00 \uac10\uc18c\ud569\ub2c8\ub2e4.
\n
\n 2. \uc0ac\uc6a9\uc790\uc5d0\uac8c \ub354 \ub098\uc740 \uc11c\ube44\uc2a4\ub97c \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n
\n 3. \uc2dc\uc2a4\ud15c\uc758 \uc735\ud1b5\uc131\uc774 \ud5a5\uc0c1\ub429\ub2c8\ub2e4.
\n
\n 4. \uc2dc\uc2a4\ud15c \uac1c\ubc1c \ubc0f \uc720\uc9c0 \ube44\uc6a9\uc774 \uac10\uc18c\ud569\ub2c8\ub2e4.
\n
\n 5. \ud45c\uc900\ud654\ub97c \uc2dc\ud589\ud558\uae30 \uc6a9\uc774\ud569\ub2c8\ub2e4.
\n
\n 6. \ubcf4\uc548\uc774 \ud5a5\uc0c1\ub429\ub2c8\ub2e4.
\n
\n 7. \ub370\uc774\ud130 \ubb34\uacb0\uc131\uc774 \ud5a5\uc0c1\ub429\ub2c8\ub2e4.
\n
\n 8. \uc870\uc9c1\uccb4\uc758 \uc694\uad6c \uc0ac\ud56d\uc744 \ud30c\uc545\ud558\uc5ec \uc870\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n
\n 9. \uc2dc\uc2a4\ud15c\uc758 \uace0\uc7a5\uc73c\ub85c\ubd80\ud130 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ubcf5\uad6c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n
\n 10. \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uacf5\uc720\uc640 \ub3d9\uc2dc \uc811\uadfc\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.\n <\/p>\n

\n \ud604\uc7ac \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \ub300\ud45c\uc801\uc778 DBMS\ub85c\ub294 Oracle, MySQL, Microsoft SQL Server, PostgreSQL, MongoDB \ub4f1\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc791\uc5c5\uc5d0 \uc801\ud569\ud55c DBMS\ub97c \uc120\uc815\ud558\ub824\uba74 \uae30\uc220\uc801\uc778 \uc694\uc778\uacfc \uacbd\uc81c\uc801\uc778 \uc694\uc778\uc744 \ubaa8\ub450 \uace0\ub824\ud574\uc57c \ud569\ub2c8\ub2e4. \uae30\uc220\uc801 \uc694\uc778\uc73c\ub85c\ub294 DBMS\uc758 \ub370\uc774\ud130 \ubaa8\ub378, DBMS\uac00 \uc9c0\uc6d0\ud558\ub294 \uc0ac\uc6a9\uc790 \uc778\ud130\ud398\uc774\uc2a4, \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4, \uc751\uc6a9 \uac1c\ubc1c \ub3c4\uad6c, \uc800\uc7a5 \uad6c\uc870 \ubc0f \uc811\uadfc \ubc29\ubc95 \ub4f1\uc774 \uc788\uace0, \uacbd\uc81c\uc801 \uc694\uc778\uc73c\ub85c\ub294 \uc18c\ud504\ud2b8\uc6e8\uc5b4\uc640 \ud558\ub4dc\uc6e8\uc5b4 \uad6c\uc785 \ube44\uc6a9, \uc720\uc9c0 \ubcf4\uc218 \ube44\uc6a9, \uc9c1\uc6d0\ub4e4\uc758 \uad50\uc721 \uc9c0\uc6d0 \ub4f1\uc774 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n

\n
\n
\n<\/span>
\n 2021\ub144 5\uc6d4 \uae30\uc900 DBSM 1~30 \uc21c\uc704, \ucd9c\ucc98 : DB-ENGINES
\n <\/figcaption><\/figure>\n<\/p>\n

\n
\n \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5b8\uc5b4
\n <\/b>
\n
\n \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5b8\uc5b4\ub780 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc744 \uad6c\ucd95\ud558\uace0 \uad00\ub9ac\ud558\ub294 \ub370 \uc0ac\uc6a9\ud558\ub294 \uc5b8\uc5b4\ub85c \uc5ed\ud560\uc5d0 \ub530\ub77c \ubd84\ub958\ud558\uba74 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.
\n
\n
\n – \ub370\uc774\ud130 \uc815\uc758\uc5b4(DDL : Data Definition Language)
\n <\/b>
\n : \ub370\uc774\ud130 \uc800\uc7a5 \uad6c\uc870, \ub370\uc774\ud130 \uc811\uadfc \ubc29\ubc95, \ub370\uc774\ud130 \ud615\uc2dd \ub4f1 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uad6c\ucd95\ud558\uac70\ub098 \uc218\uc815\ud560 \ub54c \uc0ac\uc6a9\ud558\ub294 \uc5b8\uc5b4\uc785\ub2c8\ub2e4. \ub370\uc774\ud130 \uc815\uc758\uc5b4\ub85c \uae30\uc220\ub41c \ubb38\uc7a5\uc740 \ubc88\uc5ed\ub41c \ud6c4 \ub370\uc774\ud130 \uc0ac\uc804(Data Dictionary) \ub610\ub294 \uc2dc\uc2a4\ud15c \uce74\ud0c8\ub85c\uadf8(System Catalog)\ub77c\ub294 \ud2b9\ubcc4 \ud30c\uc77c\uc5d0 \uc800\uc7a5\ub429\ub2c8\ub2e4.
\n
\n
\n – \ub370\uc774\ud130 \uc870\uc791\uc5b4(DML : Data Manipulation Language)
\n <\/b>
\n : \ub370\uc774\ud130\uc5d0 \uc800\uc7a5\ub41c \ub370\uc774\ud130\ub97c \uac80\uc0c9, \uc218\uc815, \uc0bd\uc785, \uc0ad\uc81c\ud560 \ub54c \uc0ac\uc6a9\ud558\ub294 \uc5b8\uc5b4\ub85c, \uc0ac\uc6a9\uc790\uc640 DBMS \uac04\uc5d0 \uc778\ud130\ud398\uc774\uc2a4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \ub300\ud45c\uc801\uc778 \ub370\uc774\ud130 \uc870\uc791\uc5b4\ub85c\ub294 \uc9c8\uc758\uc5b4\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130 \uc870\uc791\uc5b4\ub294 \ud544\uc694\ud55c \ub370\uc774\ud130\uc640 \uac80\uc0c9 \ubc29\ubc95\uae4c\uc9c0 \uba85\uc2dc\ud558\ub294 \uc808\ucc28\uc801 \uc5b8\uc5b4(Procedural Language)\uc640 \ud544\uc694\ud55c \ub370\uc774\ud130\ub9cc \uba85\uc2dc\ud558\uace0 \uac80\uc0c9 \ubc29\ubc95\uc740 \uba85\uc2dc\ud558\uc9c0 \uc54a\ub294 \ube44\uc808\ucc28\uc801 \uc5b8\uc5b4(Non Procedural Language)\ub85c \uad6c\ubd84\ub429\ub2c8\ub2e4. SQL\uc740 \ub300\ud45c\uc801\uc778 \ube44\uc808\ucc28\uc801 \uc5b8\uc5b4\uc785\ub2c8\ub2e4.
\n
\n
\n – \ub370\uc774\ud130 \uc81c\uc5b4\uc5b4(DCL : Data Control Language)
\n <\/b>
\n : \ub370\uc774\ud130\ub97c \ubcf4\ud638\ud558\uace0 \uad00\ub9ac\ud558\ub294 \uc5b8\uc5b4\ub85c, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubb34\uacb0\uc131 \uc720\uc9c0, \ubcf4\uc548 \ubc0f \uc811\uadfc \uc81c\uc5b4(Access Control), \uc2dc\uc2a4\ud15c \uc7a5\uc560\ub85c\ubd80\ud130\uc758 \ubcf5\uad6c, \ubcd1\ud589 \uc218\ud589 \uc81c\uc5b4 \uae30\ub2a5 \ub4f1\uc744 \uc218\ud589\ud569\ub2c8\ub2e4.\n <\/p>\n<\/p>\n

\n
\n
\n<\/span>
\n \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790 \uc0c1\uc138 \uad6c\ubd84, \ucd9c\ucc98 : DUCAT
\n <\/figcaption><\/figure>\n<\/p>\n

\n
\n \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790 \uad6c\ubd84
\n <\/b>
\n
\n \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc758 \uc8fc\uc694 \ubaa9\ud45c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uace0, \ud6a8\uc728\uc801\uc778 \ub370\uc774\ud130 \uac80\uc0c9 \ud658\uacbd\uc744 \uc81c\uacf5\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc758 \ud65c\uc6a9 \ud615\ud0dc\uc5d0 \ub530\ub77c \ub2e4\uc74c\uacfc \uac19\uc774 \ud06c\uac8c \uc138 \uac00\uc9c0 \uc720\ud615\uc73c\ub85c \uad6c\ubd84\ub429\ub2c8\ub2e4.
\n
\n
\n – \uc751\uc6a9 \ud504\ub85c\uadf8\ub798\uba38(Application Programmer)
\n <\/b>
\n : \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4(C\uc640 C++ \ub4f1)\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud2b9\uc815 \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8(ex : \uc778\uc0ac \uad00\ub9ac, \uace0\uac1d \uad00\ub9ac \ub4f1)\uc774\ub098 \uc778\ud130\ud398\uc774\uc2a4\ub97c \uad6c\ud604\ud558\ub294 \uc0ac\ub78c\ub4e4\uc785\ub2c8\ub2e4. \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc811\uadfc \ubd80\ubd84\uc744 \ub0b4\ud3ec\ub41c \ub370\uc774\ud130 \uc870\uc791\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac1c\ubc1c\ud569\ub2c8\ub2e4.
\n
\n
\n – \ucd5c\uc885 \uc0ac\uc6a9\uc790(End User)
\n <\/b>
\n : \ub370\uc774\ud130\uc758 \uac80\uc0c9, \uc0bd\uc785, \uc0ad\uc81c, \uac31\uc2e0 \ub4f1\uc744 \uc704\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc744 \uc0ac\uc6a9\ud558\ub294 \uc0ac\ub78c\uc73c\ub85c, \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\uc744 \uc9c1\uc811 \uc791\uc131\ud558\uc9c0\ub294 \uc54a\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc9c8\uc758\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc815\ubcf4\ub97c \ucc3e\ub294 \uc77c\ubc18 \uc0ac\uc6a9\uc790\uc640, \uc791\uc131\ub41c \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\uc744 \ud65c\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc5d0 \uc811\uadfc\ud558\ub294 \ucd08\ubcf4 \uc0ac\uc6a9\uc790\ub85c \uad6c\ubd84\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n
\n
\n – \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc790(DBA : Database
\n <\/b>
\n
\n Administrator)
\n <\/b>
\n : \ub370\uc774\ud130 \uc815\uc758\uc5b4(DDL)\uc640 \ub370\uc774\ud130 \uc81c\uc5b4\uc5b4(DCL)\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud0a4\ub9c8(Schema)\ub97c \uc0dd\uc131\ud558\uace0 \uad00\ub9ac\ud558\ub294 \uc0ac\ub78c\ub4e4\uc785\ub2c8\ub2e4. DBMS\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc790\uac00 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \ub3c4\uad6c\ub4e4\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc790\uc758 \uc8fc\uc694 \uc5c5\ubb34\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2a4\ud0a4\ub9c8\uc758 \uc0dd\uc131\uacfc \ubcc0\uacbd, \ubb34\uacb0\uc131 \uc81c\uc57d \uc870\uac74 \uba85\uc2dc, \ubcf4\uc548 \uc815\ucc45 \uc218\ub9bd(\uc0ac\uc6a9\uc790\uc758 \uad8c\ud55c \uc124\uc815 \ubc0f \uc5ed\ud560 \uad00\ub9ac), \uc800\uc7a5 \uad6c\uc870 \ubc0f \uc811\uadfc \ubc29\ubc95 \uc815\uc758, \ubc31\uc5c5(Backup)\uacfc \ubcf5\uad6c(Recovery) \uc808\ucc28 \uc218\ub9bd, \ud45c\uc900\ud654 \uc2dc\ud589 \ub4f1\uc774 \uc788\uc2b5\ub2c8\ub2e4.
\n
\n
\n<\/b>\n<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub370\uc774\ud130\ubca0\uc774\uc2a4(Database) \ucef4\ud4e8\ud130\ub294 \uc5ec\ub7ec \uac00\uc9c0 \uc6a9\ub3c4\ub85c \ub9ce\uc740 \uc591\uc758 \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud569\ub2c8\ub2e4. \ud68c\uc0ac\uc5d0\uc11c\ub294 \ub9e4\ucd9c\uacfc \uc9c1\uc6d0\ub4e4\uc758 \uc815\ubcf4\ub97c \uae30\ub85d\ud558\uc5ec \uad00\ub9ac\ud558\uace0, \ubcd1\uc6d0\uc5d0\uc11c\ub294 \ud654\uc790\ub4e4\uc758 \uc9c4\ub8cc \ub0b4\uc5ed\uc744 \ucef4\ud4e8\ud130\uc5d0 \uae30\ub85d\ud558\uc5ec \uad00\ub9ac\ud569\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub780 \ucef4\ud4e8\ud130\uc5d0 \uc800\uc7a5\ub41c \ub370\uc774\ud130\ub4e4\uc744 \ud1b5\ud569\ud558\uc5ec \uc800\uc7a5\ud558\uace0 \uad00\ub9ac\ud558\ub294 \ubaa8\uc784\uc774\uace0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c(DBMS : Database Management System)\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uad00\ub9ac\ud558\ub294 \ud504\ub85c\uadf8\ub7a8\uc758 \uc9d1\ud569\uc785\ub2c8\ub2e4. \uc800\uc7a5\ub41c \ub370\uc774\ud130\uc758 \uc591\uc774 \ubc29\ub300\ud558\uace0 \ub9ce\uc740 \uc0ac\ub78c\ub4e4\uc774 \uc0ac\uc6a9\ud560\uc218\ub85d \ud6a8\uc728\uc801\uc785\ub2c8\ub2e4. \ub2e4\uc2dc \ub9d0\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc758…<\/p>\n","protected":false},"author":1,"featured_media":326,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[17],"tags":[],"_links":{"self":[{"href":"https:\/\/the.2days.kr\/index.php?rest_route=\/wp\/v2\/posts\/327"}],"collection":[{"href":"https:\/\/the.2days.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/the.2days.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/the.2days.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/the.2days.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=327"}],"version-history":[{"count":1,"href":"https:\/\/the.2days.kr\/index.php?rest_route=\/wp\/v2\/posts\/327\/revisions"}],"predecessor-version":[{"id":328,"href":"https:\/\/the.2days.kr\/index.php?rest_route=\/wp\/v2\/posts\/327\/revisions\/328"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/the.2days.kr\/index.php?rest_route=\/wp\/v2\/media\/326"}],"wp:attachment":[{"href":"https:\/\/the.2days.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/the.2days.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/the.2days.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}