{"id":407,"date":"2013-09-27T16:31:57","date_gmt":"2013-09-28T01:31:57","guid":{"rendered":"\/blog\/?p=407"},"modified":"2023-09-21T09:38:52","modified_gmt":"2023-09-21T00:38:52","slug":"database-%ec%9a%a9%ec%96%b4-%ec%84%a4%eb%aa%85-oracle","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=407","title":{"rendered":"database \uc6a9\uc5b4 \uc124\uba85 (oracle)"},"content":{"rendered":"\n

<\/p>

\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
\n

DATABASE <\/span><\/b>\uc6a9\uc5b4 \uc124\uba85<\/span><\/b><\/p>\n <\/td>\n <\/tr>\n

\n

\uc6a9\uc5b4<\/span><\/b><\/p>\n <\/td>\n

\n

\ub0b4\uc6a9<\/span><\/b><\/p>\n <\/td>\n <\/tr>\n

\n

\ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4 <\/span><\/span><\/p>\n <\/td>\n

\n

\uc758\uc0ac\uacb0\uc815<\/span>\uc9c0\uc6d0 \uc2dc\uc2a4\ud15c\uc774 \ud6a8\uc728\uc801\uc73c\ub85c \uc6b4\uc601\ub418\uae30 \uc704\ud574\n \ub2e4\uc591\ud55c \uc18c\uc2a4\uc758 \ub370\uc774\ud130\ub97c \ubcc4\ub3c4\ub85c \ucd94\ucd9c\ud558\uc5ec \uad00\ub9ac\ud558\ub294 \uac83 <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ub370\uc774\ud130 \ub9c8\uc774\ub2dd <\/span><\/span><\/p>\n <\/td>\n

\n

\ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4\uc758\n \uaddc\ubaa8\uac00 \ud06c\uace0 \ubcf5\uc7a1\ud560 \ub54c <\/span>\uad00\ub828 \ub370\uc774\ud130\ub97c \ucc3e\uc544\ub0b4\uace0 \ud544\uc694\ud55c \uc815\ubcf4\ub098 \uc9c0\uc2dd\uc744 \uc0dd\uc131<\/span>\ud558\ub294 \uacfc\uc815 <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ub370\uc774\ud130 \ub9c8\ud2b8 <\/span><\/span><\/p>\n <\/td>\n

\n

\ud2b9\uc815 \uc0ac\uc6a9\uc790\uac00 \uad00\uc2ec\uc744 \uac16\ub294 \ub370\uc774\ud130\ub4e4\uc744 \ub2f4\uc740<\/span> \ube44\uad50\uc801 \uc791\uc740 \uaddc\ubaa8\uc758 \ub370\uc774\ud130 \uc6e8\uc5b4\ud558\uc6b0\uc2a4 <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\n \uc815\uc758<\/span><\/p>\n <\/td>\n

\n

1. <\/span>\ud1b5\ud569\ub41c \ub370\uc774\ud130 (integrated data)<\/span><\/span><\/p>\n

2. <\/span>\uc800\uc7a5\ub41c \ub370\uc774\ud130 (stored data)<\/span><\/span><\/p>\n

3. <\/span>\uc6b4\uc601 \ub370\uc774\ud130 (operational data)<\/span><\/span><\/p>\n

4. <\/span>\uacf5\uc6a9 \ub370\uc774\ud130 (shared data)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\n \ud2b9\uc131<\/span><\/p>\n <\/td>\n

\n

- <\/span>\uc2e4\uc2dc\uac04 \uc811\uadfc\uc131 (real time accessibility)<\/span><\/span><\/p>\n

- <\/span>\ub0b4\uc6a9\uc5d0 \uc758\ud55c \ucc38\uc870 (content reference)<\/span><\/span><\/p>\n

- <\/span>\ub3d9\uc2dc \uacf5\uc720 (concurrent sharing)<\/span><\/span><\/p>\n

- <\/span>\uacc4\uc18d\uc801 \ubcc0\ud654 (continuous evolution)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\n \uad6c\uc131\uc694\uc18c<\/span><\/p>\n <\/td>\n

\n

1. <\/span>\uac1c\uccb4 (entity)<\/span><\/span><\/p>\n

2. <\/span>\uc18d\uc131 (attribute)<\/span><\/span><\/p>\n

3. <\/span>\uad00\uacc4 (relationship)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

 <\/span><\/p>\n <\/td>\n <\/tr>\n

\n

DBMS<\/span>\uc758 \ud544\uc218\uae30\ub2a5<\/span><\/p>\n <\/td>\n

\n

1. <\/span>\uc815\uc758\uae30\ub2a5 <\/span><\/span><\/p>\n

2. <\/span>\uc870\uc791\uae30\ub2a5<\/span><\/p>\n

3. <\/span>\uc81c\uc5b4\uae30\ub2a5 - <\/span>\ubb34\uacb0\uc131 \uc720\uc9c0, <\/span>\ubcf4\uc548, <\/span>\ubcd1\ud589\uc81c\uc5b4<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

ODBC
\n (Open DataBase
\n  <\/span>Connectivity)<\/span><\/p>\n <\/td>\n

\n

\uc708\ub3c4\uc6b0\uc988\n \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c <\/span>\ub2e4\uc591\ud55c DBMS<\/span>\uc5d0 \uc811\uadfc\ud558\uc5ec \uc0ac\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d \uac1c\ubc1c\ud55c \ud45c\uc900 \uac1c\ubc29\ud615\n \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\uc778\ud130\ud398\uc774\uc2a4 \uaddc\uaca9<\/span>\uc774\ub2e4. <\/span>\uc27d\uac8c \ub9d0\ud574 \uacf5\ud1b5 \uc778\ud130\ud398\uc774\uc2a4\ub97c \ud1b5\ud574 \uc11c\ub85c \ub2e4\ub978 DBMS<\/span>\uc5d0 \uc811\uadfc\ud560 \uc218 \uc788\ub3c4\ub85d \ud55c \uac83\uc774\ub2e4.<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ubb34\uacb0\uc131(Integrity)<\/span><\/span><\/p>\n <\/td>\n

\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\n \ub0b4\uc5d0 \uc9c0\uc815\ub418\ub294 \ub370\uc774\ud130 \uac12\ub4e4\uc774 \ud56d\uc0c1 \uc77c\uad00\uc131\uc744 \uac16\uace0 \ub370\uc774\ud130\uc758 \uc720\ud6a8\uc131, <\/span><\/span>\uc815\ud655\uc131<\/span>, <\/span>\uc548\uc815\uc131\uc744 \uc720\uc9c0\ud560 \uc218 \uc788\ub3c4\ub85d \ud558\ub294 \uc81c\uc57d\uc870\uac74\uc744\n \ub450\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud2b9\uc131. <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

 <\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uc2a4\ud0a4\ub9c8(schema)<\/span><\/span><\/p>\n <\/td>\n

\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc804\uccb4\uc801\uc778 \uad6c\uc870\uc640 \uc81c\uc57d\uc870\uac74\uc5d0 \ub300\ud55c \uba85\uc138\ub97c \uae30\uc220<\/span>\ud55c \uac83. <\/span>\uc2a4\ud0a4\ub9c8\ub294 \ucef4\ud30c\uc77c \ub418\uc5b4\n \ub370\uc774\ud130 \uc0ac\uc804(Data Dictionary,=<\/span>\uc2dc\uc2a4\ud15c \uce74\ub2ec\ub85c\uadf8=<\/span>\uba54\ud0c0\ub370\uc774\ud130)<\/span>\uc5d0 \uc800\uc7a5\ub428.<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uc2a4\ud0a4\ub9c8\uc758 3<\/span>\uacc4\uce35<\/span><\/p>\n <\/td>\n

\n

1. <\/span>\uc678\ubd80\uc2a4\ud0a4\ub9c8 (=<\/span>\uc11c\ube0c\uc2a4\ud0a4\ub9c8=<\/span>\uc0ac\uc6a9\uc790\n \ubdf0(<\/span>\uac00\uc0c1\ud14c\uc774\ube14))<\/span><\/span><\/p>\n

2. <\/span>\uac1c\ub150\uc2a4\ud0a4\ub9c8 (=<\/span>\uc804\uccb4\uc801\uc778 \ubdf0)<\/span><\/span><\/p>\n

3. <\/span>\ub0b4\ubd80\uc2a4\ud0a4\ub9c8 <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\n \uc5b8\uc5b4<\/span><\/p>\n <\/td>\n

\n

1. DDL(Data Definition Language)-<\/span>\uc815\uc758\uc5b4\n : CREATE, ALTER, DROP<\/span><\/span><\/p>\n

2. DML(Data Manipulation Language)-<\/span>\uc870\uc791\uc5b4\n : SELECT, UPDATE, INSERT, DELETE<\/span><\/span><\/p>\n

3. DCL(Data Control Language)-<\/span>\uc81c\uc5b4\uc5b4 : COMMIT,\n ROLLBACK, GRANT, REVOKE<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\n \uc0ac\uc6a9\uc790<\/span><\/p>\n <\/td>\n

\n

1. <\/span>\uc77c\ubc18\uc0ac\uc6a9\uc790 - (<\/span>\uc9c8\uc758\uc5b4)  <\/span><\/span><\/span><\/p>\n

2. <\/span>\uc751\uc6a9\ud504\ub85c\uadf8\ub798\uba38 - (DML\/<\/span>\uc751\uc6a9\ud504\ub85c\uadf8\ub7a8)<\/span><\/span><\/p>\n

3. DBA - (DDL\/DCL)<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

 <\/span><\/p>\n <\/td>\n <\/tr>\n

\n

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

\uc124\uacc4\uc21c\uc11c<\/span><\/p>\n <\/td>\n

\n

1. <\/span>\uc694\uad6c\uc870\uac74\ubd84\uc11d                 <\/span>-> <\/span>\uba85\uc138\uc11c<\/span><\/p>\n

2. <\/span>\uac1c\ub150\uc801 \uc124\uacc4                  <\/span>-> <\/span>\uc2a4\ud0a4\ub9c8<\/span><\/p>\n

3. <\/span>\ub17c\ub9ac\uc801 \uc124\uacc4 - <\/span>\uc815\uaddc\ud654 \uacfc\uc815    <\/span>-> <\/span>\ub17c\ub9ac \uc2a4\ud0a4\ub9c8 <\/span><\/span><\/p>\n

4. <\/span>\ubb3c\ub9ac\uc801 \uc124\uacc4                  <\/span>-> <\/span>\ubb3c\ub9ac \uc2a4\ud0a4\ub9c8 <\/span><\/span><\/p>\n

5. <\/span>\uad6c\ud604                         <\/span>-> DB<\/span>\uad6c\ud604<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ub370\uc774\ud130 \ubaa8\ub378 <\/span><\/span><\/p>\n <\/td>\n

\n

\ud604\uc2e4\uc138\uacc4\ub97c\n \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ud45c\ud604\ud558\ub294 \uc911\uac04\uacfc\uc815, <\/span>\uc989 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4\uacfc\uc815\uc5d0\uc11c \ub370\uc774\ud130\uc758 \uad6c\uc870\ub97c \ud45c\ud604\ud558\uae30 <\/span><\/span><\/p>\n

(<\/span>\uad6c\uc131\uc694\uc18c : <\/span>\ub370\uc774\ud130 \uad6c\uc870, <\/span>\uc5f0\uc0b0, <\/span>\uc81c\uc57d\uc870\uac74)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uad50\ucc28\uad00\uacc4<\/span><\/p>\n <\/td>\n

\n

(=intersection relationship) n:m<\/span>\uad00\uacc4 \ub77c\uace0\ub3c4 \ud568. <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uc7ac\uadc0\uad00\uacc4<\/span><\/p>\n <\/td>\n

\n

(=intersection relationship) <\/span>\ub3d9\uc77c \uac1c\uccb4\uac04\uc5d0 \ucc38\uc870\ud558\ub294 \uad00\uacc4<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

 <\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uad00\uacc4\ub370\uc774\ud130\ubaa8\ub378<\/span><\/p>\n <\/td>\n

\n

(=RDB) <\/span>\uac1c\uccb4 \uc9d1\ud569\uc5d0 \ub300\ud55c \uc18d\uc131\uad00\uacc4\ub97c \ud45c\ud604\ud558\uae30 \uc704\ud574 \uac1c\uccb4\ub97c <\/span>\ub9b4\ub808\uc774\uc158<\/span> \uc989, <\/span>\ud14c\uc774\ube14\ub85c\n \uc0ac\uc6a9\ud558\uace0, <\/span>\uac1c\uccb4 \uc9d1\ud569\ub4e4 \uc0ac\uc774\uc758 \uad00\uacc4\ub97c \uacf5\ud1b5\uc18d\uc131\uc73c\ub85c \uc5f0\uacb0\ud558\ub294 \ub3c5\ub9bd\ub41c \ud615\ud0dc\uc758 \ub370\uc774\ud130 \ubaa8\ub378(<\/span>\uae30\ubcf8\ud0a4, <\/span>\uc678\ub798\ud0a4\ub85c \ud45c\ud604,n:m<\/span>\uad00\uacc4\n \ud45c\ud604\uac00\ub2a5)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uacc4\uce35\ub370\uc774\ud130\ubaa8\ub378<\/span><\/p>\n <\/td>\n

\n

(=Hierarchical Data Model)<\/span><\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758\n \ub17c\ub9ac\uc801 \uad6c\uc870 \ud45c\ud604\uc744 <\/span>\ud2b8\ub9ac(Tree)<\/span>\ud615\ud0dc\ub85c \ud45c\ud604<\/span>\ud55c \ub370\uc774\ud130 \ubaa8\ub378 (n:m<\/span>\uad00\uacc4 \ud45c\ud604 \ubd88\uac00\ub2a5, 1:n<\/span>\uad00\uacc4\ub85c \ud45c\ud604\uac00\ub2a5)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ub124\ud2b8\uc6cc\ud06c\n \ub370\uc774\ud130 \ubaa8\ub378<\/span><\/p>\n <\/td>\n

\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758\n \ub17c\ub9ac\uc801 \uad6c\uc870\ud45c\ud604\uc744 \uadf8<\/span>\ub798\ud504 \ud615\ud0dc\ub85c \ud45c\ud604<\/span>\ud55c \ub370\uc774\ud130 \ubaa8\ub378 (n:m<\/span>\uad00\uacc4 \ud45c\ud604 \ubd88\uac00\ub2a5, 1:n<\/span>\uad00\uacc4\ub85c \ud45c\ud604\uac00\ub2a5)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uac1d\uccb4\uc9c0\ud5a5\n \ub370\uc774\ud130\ubaa8\ub378<\/span><\/p>\n <\/td>\n

\n

\uc2e4\uc138\uacc4\uc5d0\n \uc874\uc7ac\ud558\ub294 \uac1c\ub150\uc801 \uc5d4\ud2f0\ud2f0\ub97c \uc911\uc2ec\uc73c\ub85c \ubaa8\ub378\ub9c1\ud558\ub294 \ubc29\uc2dd<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

 <\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ucea1\uc290\ud654 (Encapsulation)<\/span><\/span><\/p>\n <\/td>\n

\n

\uac1d\uccb4\uc9c0\ud5a5\n \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc5f0\uad00\ub41c \uc790\ub8cc\uad6c\uc870\uc640 \ud568\uc218\ub97c \ud55c \ud14c\ub450\ub9ac\ub85c \ubb36\ub294 \uac83\uc744 \ub9d0\ud568. <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

 <\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ub9b4\ub808\uc774\uc158<\/span><\/p>\n <\/td>\n

\n

\ud14c\uc774\ube14 <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ub9b4\ub808\uc774\uc158\n \uc2a4\ud0a4\ub9c8<\/span><\/p>\n <\/td>\n

\n

\uc131\uc9c8\uc774\ub984(<\/span>\uc815\uc801)                       <\/span><\/span>\uc608) <\/span>\uc774\ub984,  \n <\/span><\/span>\ud559\ubc88<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ub9b4\ub808\uc774\uc158\n \uc778\uc2a4\ud134\uc2a4<\/span><\/p>\n <\/td>\n

\n

\uc2e4\uc9c8\uc801\uc778\n \ub0b4\uc6a9(<\/span>\ub3d9\uc801)                  <\/span><\/span>\uc608) <\/span>\ub0a8\uae30\uc218, 52061762<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ud29c\ud50c(Tuple)<\/span><\/span><\/p>\n <\/td>\n

\n

\ud14c\uc774\ube14\uc758\n \ud589(Row)                   \n <\/span>=<\/span>\ub808\ucf54\ub4dc<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uce74\ub514\ub110\ub9ac\ud2f0(Cardinality)<\/span><\/span><\/p>\n <\/td>\n

\n

\ud29c\ud50c\uc758 \uc218                          <\/span><\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uc18d\uc131<\/span><\/p>\n <\/td>\n

\n

\uac1c\uccb4\uac00 \uac00\uc9c0\ub294\n \ud2b9\uc131\uc774\ub098 \uc0c1\ud0dc         <\/span>=<\/span>\ud14c\uc774\ube14\uc758\n \uc5f4(Column)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ucc28\uc218<\/span><\/p>\n <\/td>\n

\n

\uc18d\uc131\uc758 \uc218 <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ub3c4\uba54\uc778 <\/span><\/span><\/p>\n <\/td>\n

\n

\ud558\ub098\uc758 \uc18d\uc131\uc774\n \ucde8\ud560 \uc218 \uc788\ub294 \uac19\uc740 \ud0c0\uc785\uc758 \uc6d0\uc790 \uac12\ub4e4\uc758 \uc9d1\ud569<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uad50\ucc28\uc5d4\ud2f0\ud2f0<\/span><\/p>\n

(=<\/span>\uad50\ucc28\ub9b4\ub808\uc774\uc158)<\/span><\/span><\/p>\n <\/td>\n

\n

n:m<\/span>\uad00\uacc4\uc758 \ub9b4\ub808\uc774\uc158 \uc0ac\uc774\uc5d0\uc11c \uc0dd\uae34 \ubcc4\ub3c4\uc758 \ub9b4\ub808\uc774\uc158<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uc815\uaddc\ud654 \ub9b4\ub808\uc774\uc158<\/span><\/p>\n <\/td>\n

\n

\ubaa8\ub4e0 \uc18d\uc131\uc774\n '\uc6d0\uc790\uac12'\uc73c\ub85c\ub9cc \uad6c\uc131\ub41c \ub9b4\ub808\uc774\uc158 <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

 <\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ud0a4<\/span><\/p>\n <\/td>\n

\n

\ub9b4\ub808\uc774\uc158\uc5d0\n \uc874\uc7ac\ud558\ub294 \ud29c\ud50c\uc744 \uc2dd\ubcc4\ud558\uae30 \uc704\ud55c <\/span>\uc2dd\ubcc4\uc790<\/span>\ub97c\uc758\ubbf8<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uc288\ud37c\ud0a4<\/span><\/p>\n <\/td>\n

\n

\ud29c\ud50c\uc744 \uad6c\ubcc4\ud558\uae30\n \uc704\ud574 \ud55c \uac1c \uc774\uc0c1\uc758 \uc18d\uc131\uc758 \uc9d1\ud569\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9c4 \ud0a4 <\/span><\/span><\/p>\n

\uc720\uc77c\uc131\uc740\n \ub9cc\uc871, <\/span>\ucd5c\uc18c\uc131\uc740 \ub9cc\uc871\ud558\uc9c0 \uc54a\ub294 \ud0a4 <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ud6c4\ubcf4\ud0a4 (Candidate Key)<\/span><\/span><\/p>\n <\/td>\n

\n

\uc720\uc77c\uc131, <\/span>\ucd5c\uc18c\uc131\uc744 \ubaa8\ub450 \ub9cc\uc871\ud558\ub294 \ud0a4<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uae30\ubcf8\ud0a4 (Primary Key)<\/span><\/span><\/p>\n <\/td>\n

\n

\ud6c4\ubcf4\ud0a4 \uc911\uc5d0\uc11c\n \ub300\ud45c\ub85c \uc9c0\uc815\ub41c \ud0a4 (<\/span>\uc911\ubcf5\uac12, null <\/span>\ubd88\uac00)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ub300\uccb4\ud0a4 (Alternative Key)<\/span><\/span><\/p>\n <\/td>\n

\n

\uae30\ubcf8\ud0a4\ub97c\n \uc81c\uc678\ud55c \ud6c4\ubcf4\ud0a4<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uc678\ub798\ud0a4 (Foreign Key)<\/span><\/span><\/p>\n <\/td>\n

\n

\ucc38\uc870\ud558\ub294\n \ub9b4\ub808\uc774\uc158\uc758 \uae30\ubcf8\ud0a4<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

 <\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ubb34\uacb0\uc131 \uc885\ub958<\/span><\/p>\n <\/td>\n

\n

-<\/span>\ud0a4 \ubb34\uacb0\uc131 : <\/span>\ud558\ub098\uc758 \ub9b4\ub808\uc774\uc158\uc5d0\ub294 \uc801\uc5b4\ub3c4 \ud558\ub098\uc758 \ud0a4\uac00 \uc874\uc7ac\ud574\uc57c <\/span><\/span><\/p>\n

-<\/span>\ub110 \ubb34\uacb0\uc131 : <\/span>\uc18d\uc131\uc774 NULL<\/span>\uac12\uc744 \uac00\uc9c8 \uc218 \uc5c6\uc74c. <\/span><\/span><\/p>\n

-<\/span>\uace0\uc720 \ubb34\uacb0\uc131 : <\/span>\ud2b9\uc815 \uc18d\uc131\uc5d0 \ub300\ud574 \uac01 \ud29c\ud50c\uc774 \uac16\ub294 \uac12\uc774 \ub2ec\ub77c\uc57c\ud568.<\/span><\/span><\/p>\n

-<\/span>\uac1c\uccb4\ubb34\uacb0\uc131(Entity Integrity) : <\/span><\/span>\ud55c \ub9b4\ub808\uc774\uc158\uc758 \uae30\ubcf8\ud0a4\ub97c \uad6c\uc131\ud558\ub294 \uc5b4\ub5a0\ud55c\n \uc18d\uc131 \uac12\ub3c4 \ub110\uac12\uc774\ub098 \uc911\ubcf5\uac12\uc744 \uac00\uc9c8 \uc218 \uc5c6\uc74c. <\/span><\/span><\/p>\n

-<\/span>\ucc38\uc870\ubb34\uacb0\uc131(Reference Integrity) : <\/span><\/span>\ucc38\uc870\ud560 \uc218 \uc5c6\ub294 \uc678\ub798\ud0a4 \uac12\uc744 \uac00\uc9c8 \uc218 \uc5c6\uc74c. <\/span><\/span><\/p>\n

-<\/span>\uc601\uc5ed\ubb34\uacb0\uc131(Domain Integrity) : <\/span><\/span>\uc18d\uc131 \uac12\ub4e4\uc740 \uc815\ud574\uc9c4 \ubc94\uc704 \ub0b4\uc5d0 \uc788\uc5b4\uc57c \ud568. <\/span><\/span><\/p>\n

\uc608) <\/span>\uc131\ubcc4\uc740 \ub0a8,<\/span>\uc5ec \ub9cc \uc785\ub825\uac00\ub2a5<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

 <\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uc774\uc0c1(Anomaly)<\/span><\/span><\/p>\n <\/td>\n

\n

\ub370\uc774\ud130\uc758\n \uc911\ubcf5\uc73c\ub85c \uc778\ud558\uc5ec \uc0ac\uc6a9\uc790\uc758 \uc758\ub3c4\uc640 \ub2e4\ub974\uac8c \ub370\uc774\ud130\uac00 <\/span><\/span><\/p>\n

\uc0bd\uc785(<\/span>\uc0bd\uc785\uc774\uc0c1), <\/span>\uc0ad\uc81c(<\/span>\uc0ad\uc81c\uc774\uc0c1), <\/span>\uac31\uc2e0(<\/span>\uac31\uc2e0\uc774\uc0c1)<\/span>\ub418\ub294\n \ud604\uc0c1<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ud568\uc218\uc885\uc18d
\n (Functi-onal Dependency) <\/span>\uc758 \uc885\ub958<\/span><\/p>\n <\/td>\n

\n

-<\/span>\uc644\uc804\ud568\uc218\uc885\uc18d(Full Funtional Dependancy)<\/span><\/span><\/p>\n

-<\/span>\ubd80\ubd84\ud568\uc218\uc885\uc18d(Partial Funtional Dependancy)<\/span><\/span><\/p>\n

-<\/span>\uc774\ud589\uc801\ud568\uc218\uc885\uc18d(Transitive Funtional Dependancy)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uc815\uaddc\ud654 (Normalization)<\/span><\/span><\/p>\n <\/td>\n

\n

\uac1c\uccb4\ub4e4\uc5d0\n \uc874\uc7ac\ud558\ub294 \ub370\uc774\ud130 \uc18d\uc131\uc758 \uc911\ubcf5\uc744 \ucd5c\uc18c\ud654\ud558\uc5ec \uc77c\uce58\uc131\uc744 \ubcf4\uc7a5\ud558\uba70 \ub370\uc774\ud130 \ubaa8\ub378\uc744 \ub2e8\uc21c\ud558\uac8c \uad6c\uc131\ud558\ub294 \uacfc\uc815<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uc815\uaddc\ud654 \uacfc\uc815<\/span><\/p>\n <\/td>\n

\n

1NF : <\/span>\ub3c4\uba54\uc778\uc774 \uc6d0\uc790\uac12<\/span><\/p>\n

2NF : <\/span>\ubd80\ubd84\ud568\uc218\uc885\uc18d \uc81c\uac70, <\/span>\uc644\uc804\ud568\uc218\uc885\uc18d\uc73c\ub85c \ub9cc\ub4ec<\/span><\/p>\n

3NF : <\/span>\uc774\ud589\uc815 \ud568\uc218 \uc885\uc18d \uc81c\uac70<\/span><\/p>\n

BCNF   <\/span>: <\/span>\uacb0\uc815\uc790\uc774\uba74\uc11c \ud6c4\ubcf4\ud0a4\uac00 \uc544\ub2cc \uac83 \uc81c\uac70<\/span><\/p>\n

4NF : <\/span>\ub2e4\uce58\uc885\uc18d(multi value) <\/span>\uc81c\uac70<\/span><\/p>\n

5NF : <\/span>\uc870\uc778\uc885\uc18d\uc131 \uc774\uc6a9<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

 <\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uad00\uacc4\ub300\uc218
\n (Relational Algebra)<\/span><\/span><\/p>\n <\/td>\n

\n

\ud29c\ud50c\uc758 \uc9d1\ud569\uc778\n \ub9b4\ub808\uc774\uc158\uc744 \ucc98\ub9ac\ud558\uae30 \uc704\ud55c \uc5f0\uc0b0\uc758 \uc9d1\ud569<\/span><\/p>\n

(<\/span>\uc808\ucc28\uc801\uc778 \ubc29\ubc95,\n HOW?)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uad00\uacc4\ub300\uc218\uc758\n \uc885\ub958<\/span><\/p>\n <\/td>\n

\n

1) <\/span>\uc77c\ubc18\uc9d1\ud569\uc5f0\uc0b0\uc790 <\/span><\/span><\/p>\n

-<\/span>\ud569\uc9d1\ud569<\/span><\/p>\n

-<\/span>\uad50\uc9d1\ud569<\/span><\/p>\n

-<\/span>\ucc28\uc9d1\ud569<\/span><\/p>\n

-<\/span>\uad50\ucc28\uacf1(Catesian Product)(x)<\/span><\/span><\/p>\n

2) <\/span>\uc21c\uc218(<\/span>\ud2b9\ubcc4)<\/span>\uad00\uacc4\uc5f0\uc0b0\uc790<\/span><\/p>\n

-<\/span>\uc140\ub809\ud2b8(Select)(<\/span>\u03c3)<\/span><\/span><\/p>\n

-<\/span>\ud504\ub85c\uc81d\ud2b8(Project)(<\/span>\u03c0)<\/span><\/span><\/p>\n

-<\/span>\uc870\uc778(Join)(<\/span>\u25b6\u25c0) : <\/span>\uad50\ucc28\uacf1(Catesian Product)<\/span>\uc5f0\uc0b0 \uc218\ud589 \ud6c4 Select<\/span>\uc5f0\uc0b0\uc744\n \uc801\uc6a9\ud55c \uac83\uacfc \uac19\uc74c. (Inner Join, Outer Join, Natural Join)<\/span><\/span><\/p>\n

-<\/span>\ub514\ube44\uc804(Division)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uad00\uacc4\ud574\uc11d
\n (Relational Calaulus)<\/span><\/span><\/p>\n <\/td>\n

\n

\uc6d0\ud558\ub294 \uc815\ubcf4\ub9cc\uc744\n \uae30\uc220\ud558\ub294 <\/span>\ube44\uc808\ucc28\uc801\uc778 \ubc29\ubc95(What?)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

 <\/span><\/p>\n <\/td>\n <\/tr>\n

\n

SQL<\/span><\/p>\n

(Structured Quary Language, <\/span>\uc9c8\uc758\uc5b4)<\/span><\/span><\/p>\n

\uc758 \uc885\ub958<\/span><\/p>\n <\/td>\n

\n

1. DDL : CREATE, ALTER, DROP<\/span><\/p>\n

2. DML : SELECT, UPDATE, INSERT, DELETE<\/span><\/p>\n

3. DCL : COMMIT(<\/span>\uc5f0\uc0b0\uc791\uc5c5 \uc2e4\ud589\uacb0\uacfc \uc800\uc7a5), ROLLBACK(<\/span>\uc5f0\uc0b0\uc791\uc5c5\n \uc2e4\ud589 \uc774\uc804\uc73c\ub85c \ubcf5\uad6c), GRANT(<\/span>\uc0ac\uc6a9\uc790\uc5d0\uac8c \ud574\ub2f9 \uac1d\uccb4\uc5d0 \ub300\ud55c \ud2b9\uc815 \uc0ac\uc6a9\uad8c\ud55c\uc744 \ubd80\uc5ec), REVOKE(<\/span>\ud2b9\uc815\uad8c\ud55c \ud574\uc81c)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

WITH CHECK OPTION<\/span><\/p>\n <\/td>\n

\n

 <\/span>WHERE<\/span>\uc808\uc5d0 \ub9cc\uc871\ud558\ub294 \uac83\uc5d0 \ud55c\ud574\uc11c\ub294 \uc0bd\uc785, <\/span>\uc0ad\uc81c, <\/span>\uc218\uc815\uac00 \uac00\ub2a5\ud558\ub2e4\ub294 \ub73b(CREATE<\/span>\ud560\n \ub54c \uc0ac\uc6a9)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ubdf0(View)<\/span><\/span><\/p>\n <\/td>\n

\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\n \ub0b4\uc5d0 \uc874\uc7ac\ud558\ub294 \ud558\ub098 \uc774\uc0c1\uc758 \ud14c\uc774\ube14\ub85c\ubd80\ud130 \uc720\ub3c4\ub41c <\/span>\uac00\uc0c1\uc758 \ud14c\uc774\ube14.<\/span><\/span> <\/span>\ub370\uc774\ud130\uc758 <\/span>\ub17c\ub9ac\uc801 \ub3c5\ub9bd\uc131<\/span>\uc744 \uc81c\uacf5\ud558\uace0 \ub370\uc774\ud130 \uc811\uadfc\uc81c\uc5b4\ub85c <\/span>\ubcf4\uc548\uc131\uc744 \ud5a5\uc0c1<\/span>\ud558\uba70, <\/span>\uc5ec\ub7ec\n <\/span>\uc0ac\uc6a9\uc790\uc758 \uc694\uad6c\ub97c \uc9c0\uc6d0<\/span>\ud568. <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

CASCADE<\/span><\/p>\n <\/td>\n

\n

\uad00\uacc4\ub41c \uac83\uc744\n \ub530\ub77c\uac00\uc11c \uc5f0\uc18d\uc801\uc73c\ub85c \uc0ad\uc81c\ud560 \ub54c<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

RESTRICT<\/span><\/p>\n <\/td>\n

\n

\uc5b4\ub5a4 \ud14c\uc774\ube14\uc744\n \uc9c0\uc6b8 \ub54c \ucc38\uc870\ud558\ub294 \uc5b4\ub5a4 \uac83\uc740 \uc81c\uc678\ud560 \ub54c<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

REFERENCE<\/span><\/p>\n <\/td>\n

\n

FORREIGN KEY<\/span>\uc640 \ud55c \uc14b\ud2b8<\/span><\/p>\n

FORREIGN KEY <\/span>\uc18d\uc131\uba85 REFERENCE <\/span>\ucc38\uc870\ud14c\uc774\ube14\uba85(<\/span>\uc18d\uc131\uba85)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

DISTINCT<\/span><\/p>\n <\/td>\n

\n

\uc911\ubcf5\ub41c \uc18d\uc131\uc744\n \uc81c\uac70\ud558\uace0 \uac80\uc0c9<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

COUNT<\/span><\/p>\n <\/td>\n

\n

\uc18d\uc131 \uc218\ub97c\n \ucd9c\ub825<\/span><\/p>\n

\uc608) SELECT COUNT(*) AS <\/span>\ud559\uc0dd\uc218 FROM <\/span>\ud559\uc0dd;<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

GROUP BY <\/span><\/p>\n

(HAVING<\/span>\uc808\uc740 \uc870\uac74)<\/span><\/span><\/p>\n <\/td>\n

\n

\uc608) SELECT <\/span>\uacfc\ubaa9\ubc88\ud638, COUNT(*) AS <\/span>\ud559\uc0dd\uc218 FROM <\/span>\uc131\uc801 GROUP BY <\/span>\uacfc\ubaa9\ubc88\ud638 HAVING COUNT(*) >=2;<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

ORDER BY <\/span><\/p>\n <\/td>\n

\n

\uc815\ub82c <\/span><\/span><\/p>\n

\uc608)ORDER BY <\/span>\uc18d\uc131\uba85 DESC <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

LIKE<\/span><\/p>\n <\/td>\n

\n

\uc608) SELECT * FROM <\/span>\ud559\uc0dd WHERE <\/span>\uc774\ub984 LIKE '<\/span>\uae40%<\/span>';<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

INSERT<\/span><\/p>\n <\/td>\n

\n

\uc608) INSERT INTO <\/span>\ud14c\uc774\ube14\uba85(<\/span>\uc18d\uc131\uba851, <\/span>\uc18d\uc131\uba852,..) VALUES(<\/span>\ub370\uc774\ud1301, <\/span>\ub370\uc774\ud1302,...)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

UPDATE<\/span><\/p>\n <\/td>\n

\n

\uc608) UPDATE <\/span>\ud14c\uc774\ube14\uba85 SET <\/span>\uc18d\uc131\uba85=<\/span>\ub370\uc774\ud130,.. WHERE <\/span>\uc870\uac74;<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

GRANT<\/span><\/p>\n <\/td>\n

\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\n \uc0ac\uc6a9\uc790\uc5d0\uac8c \ud574\ub2f9 \uac1d\uccb4\uc5d0 \ub300\ud55c \ud2b9\uc815 \uc0ac\uc6a9\uad8c\ud55c\uc744 \ubd80\uc5ec\ud560 \ub54c \uc0ac\uc6a9\ud558\ub294 \uba85\ub839\ubb38 <\/span><\/span><\/p>\n

\uc608) GRANT <\/span>\uad8c\ud55c ON <\/span>\ub370\uc774\ud130 \uac1d\uccb4 TO <\/span>\uc0ac\uc6a9\uc790\uba85 [WITH GRANT OPTION];<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

WITH GRANT OPTION<\/span><\/p>\n <\/td>\n

\n

\uc0ac\uc6a9\uc790\uac00\n \ubd80\uc5ec\ubc1b\uc740 \uad8c\ud55c\uc744 \ub2e4\ub978 \uc0ac\uc6a9\uc790\uc5d0 \ub2e4\uc2dc \ubd80\uc5ec\ud560 \uc218 \uc788\ub294 \uad8c\ud55c\uc744 \ubd80\uc5ec\ud568. <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

REVOKE<\/span><\/p>\n <\/td>\n

\n

\uc608) REVOKE [GRANT OPTION FOR] <\/span>\uad8c\ud55c ON <\/span>\ub370\uc774\ud130\n \uac1d\uccb4 FROM <\/span>\uc0ac\uc6a9\uc790\uba85 [CASCADE];<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

 <\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ub0b4\uc7a5(Embedded) SQL<\/span><\/span><\/p>\n <\/td>\n

\n

PASCAL, FORTRAN, C, C++, JAVA<\/span>\uc640 \uac19\uc740 \ud638\uc2a4\ud2b8 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\uc5d0 \uc0bd\uc785\uc2dc\ucf1c \uc0ac\uc6a9\ud560 \uc218\ub3c4 \uc788\ub294\ub370, <\/span>\uc774\uac83\uc744 \ub0b4\uc7a5(<\/span>\uc0bd\uc785)SQL<\/span>\uc774\ub77c\uace0\n \ud568. <\/span><\/span><\/p>\n

(<\/span>\uaf2d BEGIN DECLARE SECTION, END DECLARE SECTION\n <\/span>\uc0ac\uc774\uc5d0\uc11c \ubcc0\uc218\uc120\uc5b8\uc744 \ud574\uc57c\ud568.<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ucee4\uc11c(Cursor)<\/span><\/span><\/p>\n <\/td>\n

\n

DECLARE : <\/span>\ucee4\uc11c\uc758 \uc774\ub984\uc744 \uc815\uc758\ud558\ub294 \uc120\uc5b8\uc744 \ud558\ub294 \uba85\ub839\uc5b4<\/span><\/p>\n

            <\/span>(DECLARE <\/span>\uc774\ub984\n CURSOR FOR<\/span>\uac00 \ud55c \uc138\ud2b8)<\/span><\/span><\/p>\n

OPEN : <\/span>\ucee4\uc11c\uac00 \uccab \ubc88\uc9f8 \ub808\ucf54\ub4dc\ub97c \uac00\ub9ac\ud0a4\ub3c4\ub85d \uc124\uc815\ud558\ub294 \uba85\ub839\uc5b4<\/span><\/p>\n

FETCH : <\/span>\ub2e4\uc74c \ub808\ucf54\ub4dc\ub85c \ucee4\uc11c\ub97c \uc774\ub3d9\uc2dc\ud0a4\ub294 \uba85\ub839\uc5b4<\/span><\/p>\n

CLOSE : <\/span>\uc9c8\uc758 \uc2e4\ud589 \uacb0\uacfc\uc5d0 \ub300\ud55c \ucc98\ub9ac \uc885\ub8cc\uc2dc \ucee4\uc11c\ub97c \ub2eb\uae30 \uc704\ud574 \uc0ac\uc6a9\ud558\ub294 \uba85\ub839\uc5b4 <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ud2b8\ub9ac\uac70(Trigger)<\/span><\/span><\/p>\n <\/td>\n

\n

\ud2b9\uc815 \ud14c\uc774\ube14\uc5d0\n \uc788\ub294 \ub370\uc774\ud130\uac00 \uc218\uc815\ub420 \ub54c \uc5f0\uacb0\ub41c \ub370\uc774\ud130\uae4c\uc9c0\ub3c4 \uc790\ub3d9\uc2e4\ud589\ub418\ub294 \"Stored Procedure\"<\/span>\uc784<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

CLUD <\/span>\ub9e4\ud2b8\ub9ad\uc2a4<\/span><\/p>\n <\/td>\n

\n

\uc5c5\ubb34\uc758 \ub2e8\uc704\n \ud504\ub85c\uc138\uc2a4\uc640 \ub370\uc774\ud130 \uac04\uc758 \uc0c1\uad00\uad00\uacc4 \ubd84\uc11d\uc744 \uc704\ud55c \ub3c4\uad6c <\/span><\/span><\/p>\n

(<\/span>\uc0c1\uad00 \ubaa8\ub378\ub9c1\uc5d0\uc11c \uc0ac\uc6a9) 2<\/span>\ucc28\uc6d0 \ubc30\uc5f4\uc744 \uc0ac\uc6a9\ud568.<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ud2b8\ub79c\uc7ad\uc158(Transaction)<\/span><\/span><\/p>\n <\/td>\n

\n

\uc5ec\ub7ec\uac1c\uc758\n \uc5f0\uc0b0\uc774 \ud558\ub098\uc758 \ub17c\ub9ac\uc801 \uae30\ub2a5\uc744 \uc218\ud589\ud558\uae30 \uc704\ud55c \uc791\uc5c5\ub2e8\uc704\ub85c \uad6c\uc131\ub428. <\/span>\ucabc\uac24 \uc218 \uc5c6\ub294 \uc5c5\ubb34\ucc98\ub9ac\uc758 \ub2e8\uc704<\/b>.<\/span><\/span><\/p>\n

(<\/span>\uc6d0\uc790\uc131 Atomicity, <\/span>\uc77c\uad00\uc131\n Consistency, <\/span>\uaca9\ub9ac\uc131 Isolation, <\/span>\uc601\uc18d\uc131 Durbility), <\/span>\ud569\uccd0\uc11c ACID <\/span>\ud2b8\ub79c\uc7ad\uc158<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ud2b8\ub79c\uc7ad\uc158\n \uc5f0\uc0b0<\/span><\/p>\n <\/td>\n

\n

Commit(<\/span>\uc644\ub8cc)<\/span><\/span><\/p>\n

Rollback(<\/span>\ubcf5\uadc0)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uc911\ubcf5\uc800\uc7a5\uae30\ubc95\n \uc885\ub958<\/span><\/p>\n <\/td>\n

\n

-<\/span>\ub85c\uadf8(Log) : <\/span>\uc774\uc804\uac12\uacfc \uc774\ud6c4 \uac12\uc744 \ubcc4\ub3c4\ub85c \uae30\ub85d\ud558\ub294 \ud30c\uc77c<\/span><\/p>\n

-<\/span>\ub364\ud504(Dump) : <\/span>\uc8fc\uae30\uc801\uc73c\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\uccb4\ub97c \uc800\uc7a5\uc7a5\uce58\uc5d0 \ubcf5\uc81c\ud558\ub294\n \uae30\ubc95<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uc7a5\uc560\ubc1c\uc0dd\uc2dc <\/span><\/span><\/p>\n

\ud68c\ubcf5\uae30\ubc95<\/span><\/p>\n <\/td>\n

\n

Redo : <\/span>\ud2b8\ub79c\uc7ad\uc158 \uc2e4\ud589\uc774 \uc131\uacf5\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc5c8\uc73c\ub098 Commit <\/span>\uc5f0\uc0b0\uc744 \uc2e4\ud589\ud558\uc9c0\n \uc54a\uc544 \ub514\uc2a4\ud06c\uc5d0 \ubc18\uc601\ub418\uc9c0 \uc54a\uc558\uc744 \uacbd\uc6b0 <\/span><\/span><\/p>\n

Undo : <\/span>\ud2b8\ub79c\uc7ad\uc158 \uc2e4\ud589\uc774 \uc131\uacf5\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc9c0 \uc54a\uc558\uc744 \ub54c \ub85c\uadf8\ub97c \uc774\uc6a9\ud558\uc5ec \uc774\uc804\uac12\uc73c\ub85c \ub418\ub3cc\ub9bc.\n (<\/span>\ubaa8\ub4e0 \ubcc0\uacbd\uc744 \ucde8\uc18c\uc2dc\ud0b4)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uac80\uc0ac\uc2dc\uc810(Check Point)
\n <\/span>\ud68c\ubcf5 <\/span><\/span><\/p>\n <\/td>\n

\n

\ub85c\uadf8 \uc804\uccb4\ub97c\n \uc870\uc0ac\ud574\uc57c \ud558\ub294 \uacbd\uc6b0\ub97c \ud68c\ud53c\ud558\uae30 \uc704\ud55c \ubc29\ubc95.<\/span><\/span><\/p>\n

\uac00\uc7a5 \ucd5c\uadfc\uc758\n \uac80\uc0ac\uc2dc\uc810\uc73c\ub85c\ubd80\ud130 \ud68c\ubcf5\uc791\uc5c5\uc744 \uc218\ud589 <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ub85c\ud0b9(Locking)<\/span><\/span><\/p>\n <\/td>\n

\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\n \uad00\ub9ac\uc5d0\uc11c \ud558\ub098\uc758 \ud2b8\ub79c\uc7ad\uc120\uc774\ub098 \uc138\uc158\uc5d0 \uc0ac\uc6a9\ub418\ub294 \ub370\uc774\ud130\ub97c \ub2e4\ub978 \ud2b8\ub79c\uc7ad\uc158\uc774\ub098 \uc138\uc158\uc740 \uc811\uadfc\ud558\uc9c0 \ubabb\ud558\uac8c \ud558\ub294 \uac83\uc774\ub2e4.\n <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uc778\ub371\uc2a4(Index)<\/span><\/span><\/p>\n <\/td>\n

\n

\uac80\uc0c9\uc744 \ube60\ub974\uac8c\n \ud558\uae30\uc704\ud574 \ub9cc\ub4e0 \ubcf4\uc870\uc801\uc778 \uc790\ub8cc\uad6c\uc870<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uc778\ub371\uc2a4 \uc885\ub958<\/span><\/p>\n <\/td>\n

\n

\uc9d1\uc911\uc778\ub371\uc2a4(Clustered Indes) : <\/span>\uc774\ubbf8 \uc815\ub82c\uc774 \ub418\uc5b4\uc788\uc5b4\uc11c \uc778\ub371\uc2f1 \uc5c6\uc774 \ubc14\ub85c \ucc3e\uc744 \uc218 \uc788\uc74c<\/span><\/p>\n

\ube44\uc9d1\uc911\uc778\ub371\uc2a4(Nonclustered Indes) : <\/span>\uc815\ub82c\uc774 \uc548\ub418\uc5b4\uc788\uc74c.   <\/span><\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uc778\ub371\uc2a4\uc758\n \uc811\uadfc\ubc29\uc2dd<\/span><\/p>\n <\/td>\n

\n

-<\/span>\uc0c9\uc778\uc21c\ucc28\uc815\ub82c\ubc29\uc2dd(ISAM) :<\/span><\/span><\/p>\n

-<\/span>\uac00\uc0c1\uae30\uc5b5\uc811\uadfc\ubc29\uc2dd(VSAM, Virtual Storage Access\n Method)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ud29c\ub2dd<\/span><\/p>\n <\/td>\n

\n

\uc870\uc815\uc744 \ud1b5\ud558\uc5ec\n \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac <\/span>\uc2dc\uc2a4\ud15c\uc758 \uc131\ub2a5\uc744 \ud5a5\uc0c1<\/span> \uc2dc\ud0a4\ub294 \uc791\uc5c5<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uac1d\uccb4\uc9c0\ud5a5\ub370\uc774\ud130\ubca0\uc774\uc2a4
\n (ODB)<\/span><\/span><\/p>\n <\/td>\n

\n

\uac1d\uccb4\uc9c0\ud5a5\uae30\uc220\uacfc\n \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uae30\uc220\uc774 \uacb0\ud569\ub41c \uac83<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uc624\ubc84\ub85c\ub529<\/span><\/p>\n <\/td>\n

\n

\ud558\ub098\uc758 \uba54\uc18c\ub4dc\uc774\ub984\uc744\n \ub458 \uc774\uc0c1\uc758 \ud504\ub85c\uadf8\ub7a8\uc774 \uc0ac\uc6a9\ud558\ub294 \uac83 <\/span><\/span><\/p>\n

(*<\/span>\ub2e4\ud615\uc131 Polymorphism <\/span>\uc774\ub77c\uace0\ub3c4 \ud568.)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\uc624\ubc84\ub77c\uc774\ub529<\/span><\/p>\n <\/td>\n

\n

\uc288\ud37c\ud074\ub798\uc2a4\uc5d0\n \uc788\ub294 \uba54\uc18c\ub4dc\ub97c \uc11c\ube0c\ud074\ub798\uc2a4\uc5d0\uc11c \uc0c1\uc18d\ubc1b\uc544 \ub2e4\ub978 \uae30\ub2a5\uc744 \uc218\ud589\ud558\ub294 \uba54\uc18c\ub4dc\ub97c \uc7ac\uc815\uc758 \ud558\ub294 \uac83 <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

OLAP(<\/span>\uc628\ub77c\uc778 \ubd84\uc11d\ucc98\ub9ac)
\n (Online Analytical
\n Processing)<\/span><\/span><\/p>\n <\/td>\n

\n

\ub300\uaddc\ubaa8\uc758\n \ubcf5\uc7a1\ud55c \ub370\uc774\ud130\ub97c \ub3d9\uc801\uc73c\ub85c \uc628\ub77c\uc778\uc5d0\uc11c\uc758 \ubd84\uc11d\uc744 \uc9c0\uc6d0\ud558\ub294 \ub3c4\uad6c \ub610\ub294 \uc791\uc5c5(<\/span>\uc885\ub958 : ROLAP, MOLAP, HOLAP)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

ROLAP(Relational OLAP)<\/span><\/p>\n <\/td>\n

\n

\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/span>\ub098 \ud655\uc7a5\ub41c \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud574 \ub2e4\ucc28\uc6d0 \ubaa8\ub378\ub9c1\ub418\ub294 \ub370\uc774\ud130 \ud050\ube0c\ub97c \ud14c\uc774\ube14\ud615\ud0dc\ub85c \uc800\uc7a5\uc6b4\uc6a9\ud558\ub294 \ubc29\uc2dd<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

MOLAP(Multidimensinal OLAP)<\/span><\/p>\n <\/td>\n

\n

\ub370\uc774\ud130 \ud050\ube0c\ub97c\n \uc2e4\uc81c\ub85c \ubc30\uc5f4\uc744 \uae30\ubc18\ud55c \ub2e4\ucc28\uc6d0 \uc800\uc7a5\uc5d4\uc9c4\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc800\uc7a5 \uc6b4\uc6a9\ud558\ub294 \ubc29\uc2dd<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

HOLAP(Hybrid OLAP)<\/span><\/p>\n <\/td>\n

\n

ROLAP<\/span>\uc640 MOLAP<\/span>\ub97c \ud63c\uc6a9\ud558\ub294 \ubc29\uc2dd<\/span><\/p>\n <\/td>\n <\/tr>\n

\n

OLTP(<\/span>\uc628\ub77c\uc778 \ud2b8\ub79c\uc7ad\uc158 \ucc98\ub9ac)<\/span><\/span><\/p>\n <\/td>\n

\n

\ud130\ubbf8\ub110\uc758\n \uba54\uc2dc\uc9c0\uc5d0 \ub530\ub77c \ud638\uc2a4\ud2b8\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac80\uc0c9 \ub4f1\uc758 \ucc98\ub9ac\ub97c \uc218\ud589\ud558\uace0, <\/span>\uadf8 \uacb0\uacfc\ub97c \ud130\ubbf8\ub110\uc5d0 \ub418\ub3cc\ub824 \ubcf4\ub0b4\uc8fc\ub294\n \ucc98\ub9ac\ud615\ud0dc <\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

Oracle RAC
\n (Real Application Cluster)<\/span><\/p>\n <\/td>\n

\n

-OPS(Oracle Parallel Server)<\/span>\uc758 \ud6c4\uc18d \uc81c\ud488\uc73c\ub85c Oracle 9i <\/span>\ubd80\ud130\n \uc801\uc6a9.
\n -<\/span>\uc624\ub77c\ud074\uc758 \ud074\ub7ec\uc2a4\ud130\ub9c1(<\/span>\ubd80\ud558\ubd84\uc0b0) <\/span>\uc194\ub8e8\uc158
\n -<\/span>\ub3d9\uc77c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc5ec\ub7ec \uc778\uc2a4\ud134\uc2a4\uac00 \uc811\uadfc \uac00\ub2a5
\n -<\/span>\ubaa8\ub4e0 \ub178\ub4dc\uac00 \ub3d9\uc77c\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uc18d \uac00\ub2a5.<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n<\/tbody><\/table>\n\n<\/p>

 <\/span><\/p>\n\n
\n<\/span>\n\n

\u25a0 \ubaa9\uc801 \ubcc4 \uc6a9\uc5b4 \ucc28\uc774<\/span><\/p>\n\n\n \n \n \n \n \n
\n

\uc804\uc0b0 \uc6a9\uc5b4<\/span><\/b><\/p>\n <\/td>\n

\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub378\ub9c1 \uc6a9\uc5b4<\/span><\/b><\/p>\n <\/td>\n

\n

\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc6a9\uc5b4<\/span><\/b><\/p>\n <\/td>\n <\/tr>\n

\n

\ud30c\uc77c(File)<\/span><\/span><\/p>\n <\/td>\n

\n

\uc5d4\ud2f0\ud2f0(Entity)<\/span><\/span><\/p>\n <\/td>\n

\n

\ud14c\uc774\ube14(Table)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ub808\ucf54\ub4dc(Record)<\/span><\/span><\/p>\n <\/td>\n

\n

\ud29c\ud50c(Tuple)<\/span><\/span><\/p>\n <\/td>\n

\n

\ud589(Row)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ud0a4(Key)<\/span><\/span><\/p>\n <\/td>\n

\n

\uc720\uc77c\uac12(Identifier)<\/span><\/span><\/p>\n <\/td>\n

\n

\uae30\ubcf8\ud0a4(Primary key), Unique<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n

\n

\ud544\ub4dc(Field)<\/span><\/span><\/p>\n <\/td>\n

\n

\uc5b4\ud2b8\ub9ac\ubdf0\ud2b8(Attribute)<\/span><\/span><\/p>\n <\/td>\n

\n

\uceec\ub7fc(Column)<\/span><\/span><\/p>\n <\/td>\n <\/tr>\n<\/tbody><\/table>\n\n

 <\/span><\/p>\n\n

\u25a0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\n\uc2a4\ud0a4\ub9c8(Schema)<\/span>\uc758 \uc815\uc758<\/span><\/p>\n\n

 <\/span><\/p>\n\n

- <\/span>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758\n\uad6c\uc870\uc640 \uc81c\uc57d \uc870\uac74\uc5d0 \uad00\ud55c \uc804\ubc18\uc801\uc778 \uba85\uc138(Specification)<\/span>\ub97c \uae30\uc220(Description).
\n  <\/span>(<\/span>\uc989, <\/span>\ub370\uc774\ud130\ubca0\uc774\uc2a4\n\ud558\ub098\ub97c \uae30\uc220\ud55c \uac83\uc774\ub2e4.)<\/span><\/span><\/p>\n\n

- <\/span>\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c\n\uad6c\uc131\ud558\ub294 \uac1c\uccb4(Entity), <\/span>\uc18d\uc131(Attribute), <\/span>\uad00\uacc4(Relationship) <\/span>\ubc0f \ub370\uc774\ud130 \uc870\uc791 \uc2dc
\n  <\/span><\/span>\ub370\uc774\ud130 \uac12\ub4e4\uc774 \uac16\ub294 \uc81c\uc57d \uc870\uac74 \ub4f1\uc5d0 \uad00\ud574 \uc804\ubc18\uc801\uc73c\ub85c \uc815\uc758.<\/span><\/span><\/p>\n\n

- <\/span>\ub808\ucf54\ub4dc \ud615\ud0dc\uc640\n\ub9b4\ub808\uc774\uc158 \uac19\uc740 \ubaa8\ub4e0 \ub370\uc774\ud130\uc758 \ub17c\ub9ac\uc801 \ub2e8\uc704\uc5d0 \uba85\uce6d\uc744 \ubd80\uc5ec\ud558\uace0 \uc758\ubbf8\ub97c \uae30\uc220<\/span><\/p>\n\n

- <\/span>\ub370\uc774\ud130 \ubca0\uc774\uc2a4\n\ub0b4\uc5d0 \uc788\ub294 \ub370\uc774\ud130\uc758 \ub17c\ub9ac\uc801 \ub2e8\uc704 \uc0ac\uc774\uc758 \uad00\uacc4\uc131 \ud45c\ud604<\/span><\/p>\n\n

- <\/span>\uc0ac\uc6a9\uc790\uc758 \uad00\uc810\uc5d0 \ub530\ub77c \uc678\ubd80 \uc2a4\ud0a4\ub9c8, <\/span>\uac1c\ub150\n\uc2a4\ud0a4\ub9c8, <\/span>\ub0b4\ubd80 \uc2a4\ud0a4\ub9c8\ub85c \uad6c\ubd84.<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25ce \uc2a4\ud0a4\ub9c8\uc758 3<\/span>\uacc4\uce35<\/span><\/p>\n\n

\u203b DBMS(DataBase Manaement System, <\/span>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c)<\/span>\uc740<\/span><\/p>\n\n

\uc678\ubd80\uc801 \uc2a4\ud0a4\ub9c8\uc5d0\n\ub530\ub77c \uba85\uc2dc\ub41c \uc0ac\uc6a9\uc790\uc758 \uc694\uad6c\ub97c<\/span><\/p>\n\n

\uac1c\ub150\uc801 \uc2a4\ud0a4\ub9c8\uc5d0\n\uc801\ud569\ud55c \ud615\ud0dc\ub85c \ubcc0\uacbd\ud558\uace0,<\/span><\/span><\/p>\n\n

\uc774\ub97c \ub2e4\uc2dc \ub0b4\ubd80\uc801\n\uc2a4\ud0a4\ub9c8\uc5d0 \uc801\ud569\ud55c \ud615\ud0dc\ub85c \ubcc0\ud658\ud55c\ub2e4.<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25cf \uc678\ubd80 \uc2a4\ud0a4\ub9c8 (External Schema) = <\/span>\uc11c\ube0c \uc2a4\ud0a4\ub9c8 = <\/span>\uc0ac\uc6a9\uc790 \ubdf0(View)<\/span><\/span><\/p>\n\n

- <\/span>\uc0ac\uc6a9\uc790\ub098\n\uc751\uc6a9 \ud504\ub85c\uadf8\ub798\uba38\uac00 \uac01 \uac1c\uc778\uc758 \uc785\uc7a5\uc5d0\uc11c \ud544\uc694\ub85c \ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub17c\ub9ac\uc801 \uad6c\uc870\ub97c \uc815\uc758<\/span><\/p>\n\n

- <\/span>\uc2e4\uc138\uacc4\uc5d0\n\uc874\uc7ac\ud558\ub294 \ub370\uc774\ud130\ub4e4\uc744 \uc5b4\ub5a4 \ud615\uc2dd, <\/span>\uad6c\uc870, <\/span>\ubc30\uce58\ub85c \ud654\uba74\uc744 \ud1b5\ud574\n\uc0ac\uc6a9\uc790\uc5d0\uac8c \ubcf4\uc5ec\uc904 \uac83\uc778\uac00?<\/span><\/span><\/p>\n\n

- <\/span>\uc804\uccb4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758\n\ud55c \ub17c\ub9ac\uc801 \ubd80\ubd84 \u2192 \"<\/span>\uc11c\ube0c\uc2a4\ud0a4\ub9c8\"<\/span><\/span><\/p>\n\n

- <\/span>\ud558\ub098\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\ub294\n\uc5ec\ub7ec \uac1c\uc758 \uc678\ubd80 \uc2a4\ud0a4\ub9c8\uac00 \uc874\uc7ac \uac00\ub2a5<\/span><\/p>\n\n

  <\/span>& <\/span>\ud558\ub098\uc758 \uc678\ubd80 \uc2a4\ud0a4\ub9c8\ub97c \uc5ec\ub7ec \uac1c\uc758 \uc751\uc6a9\ud504\ub85c\uadf8\ub7a8\uc774\ub098\n\uc0ac\uc6a9\uc790\uac00 \uacf5\uc6a9 \uac00\ub2a5<\/span><\/p>\n\n

- <\/span>\uac19\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\n\ub300\ud574\uc11c\ub3c4 \uc11c\ub85c \ub2e4\ub978 \uad00\uc810\uc744 \uc815\uc758\ud560 \uc218 \uc788\ub3c4\ub85d \ud5c8\uc6a9<\/span><\/p>\n\n

- <\/span>\uc77c\ubc18 \uc0ac\uc6a9\uc790\ub294\n\uc9c8\uc758\uc5b4(SQL)<\/span>\ub97c \uc774\uc6a9, DB<\/span>\ub97c \uc27d\uac8c \uc0ac\uc6a9<\/span><\/p>\n\n

- <\/span>\uc751\uc6a9\ud504\ub85c\uadf8\ub798\uba38\ub294 COBOL, C <\/span>\ub4f1\uc758 \uc5b8\uc5b4\ub97c \uc0ac\uc6a9, DB<\/span>\uc5d0 \uc811\uadfc<\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25cf \uac1c\ub150 \uc2a4\ud0a4\ub9c8(Conceptual Schema) = <\/span>\uc804\uccb4\uc801\uc778 \ubdf0(View)<\/span><\/span><\/p>\n\n

- <\/span>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758\n\uc804\uccb4\uc801\uc778 \ub17c\ub9ac\uc801 \uad6c\uc870<\/span><\/p>\n\n

- <\/span>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\n\uc2e4\uc81c\ub85c '<\/span>\uc5b4\ub5a4' <\/span>\ub370\uc774\ud130\uac00 \uc800\uc7a5\ub418\uc5c8\uc73c\uba70 \ub370\uc774\ud130 \uac04\uc758 \uad00\uacc4\ub294\n\uc5b4\ub5bb\uac8c \ub418\ub294\uac00?<\/span><\/span><\/p>\n\n

- <\/span>\ubaa8\ub4e0 \uc751\uc6a9\n\ud504\ub85c\uadf8\ub7a8\uc774\ub098 \uc0ac\uc6a9\uc790\ub4e4\uc774 \ud544\uc694\ub85c \ud558\ub294 \ub370\uc774\ud130\ub97c \uc885\ud569\ud55c \uc870\uc9c1 \uc804\uccb4\uc758 \ub370\uc774\ud130 \ubca0\uc774\uc2a4 <\/span><\/span><\/p>\n\n

  <\/span>(<\/span>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub2f9 \ud558\ub098\ub9cc \uc874\uc7ac)<\/span><\/span><\/p>\n\n

- <\/span>\uac1c\uccb4 \uac04\uc758\n\uad00\uacc4\uc640 \uc81c\uc57d \uc870\uac74 \uba85\uc2dc<\/span><\/p>\n\n

- <\/span>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758\n\uc811\uadfc \uad8c\ud55c, <\/span>\ubcf4\uc548 \ubc0f \ubb34\uacb0\uc131 \uaddc\uce59\uc5d0 \uad00\ud55c \uba85\uc138\ub97c \uc815\uc758<\/span><\/p>\n\n

- <\/span>\ub2e8\uc21c\ud55c \uc2a4\ud0a4\ub9c8(Schema)<\/span>\ub77c\uace0 \ud558\uba74 \uac1c\ub150\uc2a4\ud0a4\ub9c8\ub97c \uc758\ubbf8<\/span><\/p>\n\n

- <\/span>\uae30\uad00\uc774\ub098\n\uc870\uc9c1\uccb4\uc758 \uad00\uc810\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc815\uc758<\/span><\/p>\n\n

- <\/span>\ub370\uc774\ud130\ubca0\uc774\uc2a4\n\uad00\ub9ac\uc790(DBA, DataBase Administrator)<\/span>\uc5d0 \uc758\ud574 \uad6c\uc131<\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25cf \ub0b4\ubd80 \uc2a4\ud0a4\ub9c8(Internal Schema)<\/span><\/span><\/p>\n\n

- <\/span>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758\n\ubb3c\ub9ac\uc801 \uc800\uc7a5 \uad6c\uc870\ub97c \uc815\uc758<\/span><\/p>\n\n

- <\/span>\ub514\uc2a4\ud06c\uc5d0\ub294\n\uc5b4\ub5a4 \uad6c\uc870\ub85c \uc800\uc7a5\ud560 \uac83\uc778\uac00?<\/span><\/span><\/p>\n\n

- <\/span>\ub370\uc774\ud130\uc758\n\uc2e4\uc81c \uc800\uc7a5 \ubc29\ubc95\uc744 \uae30\uc220<\/span><\/p>\n\n

- <\/span>\ubb3c\ub9ac\uc801\uc778\n\uc800\uc7a5\uc7a5\uce58\uc640 \ubc00\uc811\ud55c \uacc4\uce35<\/span><\/p>\n\n

- <\/span>\uc2dc\uc2a4\ud15c \ud504\ub85c\uadf8\ub798\uba38\ub098 \uc2dc\uc2a4\ud15c \uc124\uacc4\uc790\uac00 \ubcf4\ub294 \uad00\uc810\uc758 \uc2a4\ud0a4\ub9c8<\/span><\/p>\n\n

 <\/span><\/p>\n\n

<\/p>\u25a0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 View <\/span>\ub780<\/span>\n\n

 <\/span><\/p>\n\n

http:\/\/radiocom.kunsan.ac.kr\/lecture\/oracle\/what_is\/view.html<\/span><\/span><\/a><\/span><\/p>\n\n

 <\/span><\/b><\/p>\n\n

\u25a0 \uc624\ub77c\ud074 \ub0b4\ubd80 \ubc0f \uc5f0\uacb0 \uad6c\uc870 Oracle<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

\uc624\ub77c\ud074\uc740 \ud06c\uac8c Instance<\/span>\uc640 Database<\/span>\ub85c \uad6c\uc131<\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25ce Instance<\/span><\/b> : SGA(System Global Area) <\/span>\uc601\uc5ed\uacfc Background Process <\/span>\ub85c \uad6c\uc131<\/span><\/p>\n\n

Database<\/span>\ub294\nInstance<\/span>\uc5d0 \uc758\ud574\uc11c Mount<\/span><\/span><\/p>\n\n

\ud56d\uc0c1 \ud558\ub098\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub9cc\uc744 OPEN<\/span><\/span><\/p>\n\n

\ud558\ub098\uc758 DB<\/span>\uc5d0 \uc5ec\ub7ec\uac1c\uc758 Instance<\/span>\ub97c \uc0dd\uc131\ud558\ub294\uac83\uc740 \uac00\ub2a5(RAC)<\/span><\/span><\/p>\n\n

\ud558\ub098\uc758 Instnace<\/span>\uc5d0 \uc5ec\ub7ec\uac1c\uc758 DB<\/span>\ub97c \uc0dd\uc131\ud558\ub294\uac74 \ubd88\uac00\ub2a5<\/span><\/p>\n\n

 <\/span><\/p>\n\n

- SGA(System Global\nArea) : Instance<\/span>\uac00 Startup<\/span>\ud560 \ub54c \uba54\ubaa8\ub9ac\uc5d0 \ud560\ub2f9\ub418\ub294 \uc791\uc5c5 \uc601\uc5ed<\/span><\/p>\n\n

\uc774 \uc601\uc5ed\uc740 \uc624\ub77c\ud074\uc774 \uae30\ub3d9\uc911\uc5d0 \uc0ac\uc6a9\ub418\ub294 \ub370\uc774\ud130\ub098 \uac01\uc885 \uc815\ubcf4\ub4e4 \uadf8\ub9ac\uace0 \uc77c\ubc18 \uc720\uc800\ub4e4\uc758 \ubaa8\ub4e0 SQL <\/span>\ubb38\uc7a5\ub4e4\uc774 \uc774\uacf3\uc5d0\uc11c \uc2e4\ud589<\/span><\/p>\n\n

SGA <\/span>\uc601\uc5ed\uc740 \ud074\uc218\ub85d \uc131\ub2a5\uc0c1 \uc774\uc810\uc774 \uc788\uc9c0\ub9cc Real Memory <\/span>\uc601\uc5ed\uc5d0 \uc704\uce58\ud560 \uc218 \uc788\ub3c4\ub85d \uc801\uc808\ud788 \uc870\uc808\ud574\uc57c\ud568<\/span><\/p>\n\n

- Background Process : <\/span>\uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc2dc\uc791\ub418\uae30 \uc704\ud574\uc11c\ub294 \uaf2d\n\ud544\uc694 \ud558\uba70,<\/span><\/span><\/p>\n\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc885\ub8cc\ub418\uba74 \uc704\uc758 \ud504\ub85c\uc138\uc2a4\ub4e4\ub3c4 \ubaa8\ub450 \uc885\ub8cc<\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25ce Database<\/span><\/b> : Data files, Control files,\nRedo log files<\/span>\ub85c \uad6c\uc131<\/span><\/p>\n\n

- Data files : <\/span>\uc2e4\uc81c \ub370\uc774\ud130\uac00 \uc800\uc7a5\ub418\ub294 \ubb3c\ub9ac\uc801 \ud30c\uc77c<\/span><\/p>\n\n

- Control files : <\/span>\uc81c\uc5b4 \uc815\ubcf4\ub97c \uac00\uc9c0\uace0 \uc788\ub294 \ud30c\uc77c, Mount\/Open<\/span>\ud558\uc5ec DB<\/span>\ub97c \uc0ac\uc6a9\ud558\ub294\ub370 \uaf2d \ud544\uc694\ud55c \ud30c\uc77c
\n <\/span> <\/span>-> <\/span>\ubc31\uc5c5 \ud544\uc218<\/span><\/p>\n\n

- Redo Log Files : <\/span>\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc0dd\uae34 \ubaa8\ub4e0 \ubcc0\ud654\ub97c \uae30\ub85d\ud558\ub294\n\ud30c\uc77c, DB <\/span>\uc7a5\uc560\uc2dc \ubcf5\uad6c\ub97c \uc704\ud574 \uc0ac\uc6a9<\/span><\/p>\n\n

\ub2e4\uc218\uc758 \uadf8\ub8f9\uc744 \uac00\uc9c0\uba70, <\/span>\uadf8\ub8f9 \ub0b4\uc758 \uba64\ubc84\ub4e4\uc740\n\ubaa8\ub450 \ub3d9\uc77c\ud55c \ub370\uc774\ud130\ub97c \uac00\uc9d0(<\/span>\ubc31\uc5c5\uc6a9)<\/span><\/span><\/p>\n\n

 <\/span><\/p>[<\/span><\/b>\uc624\ub77c\ud074 Background Process\n-  <\/span>http:\/\/www.oracleclub.com\/lecture\/1892<\/span><\/span><\/a>]<\/span><\/span><\/b>\n\n
\n<\/span>

<\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-407","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/407","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=407"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/407\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=407"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=407"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=407"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}