# OLTP(On-line Transaction Processing)
\n– \ud130\ubbf8\ub0a0\uc758 \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 \uadf8 \uacb0\uacfc\ub97c \ud130\ubbf8\ub110\uc5d0 \ub418\ub3cc\ub824 \ubcf4\ub0b4\uc8fc\ub294 \ucc98\ub9ac\ud615\ud0dc
\n– \ub124\ud2b8\uc6cd\uc0c1\uc758 \uc5ec\ub7ec \uc774\uc6a9\uc790\uac00 \uc2e4\uc2dc\uac04\uc73c\ub85c \ub514\ube44\uc5d0 \ub370\uc774\ud130\ub97c \uac31\uc2e0\ud558\uac70\ub098 \uc870\ud68c\ud558\ub294 \ub4f1\uc758 \ub2e8\uc704 \uc791\uc5c5\uc744 \ucc98\ub9ac\ud558\ub294 \ubc29\uc2dd
\n– \uae08\uc735,\uc804\uc0b0\uad00\ub828 \ubd80\ubb38\uc5d0\uc11c \ub9ce\uc774 \ubc1c\uc0dd, \uc628\ub77c\uc778 \uac70\ub798\ucc98\ub9ac\ub77c\uace0\ub3c4 \ud568
\n– \ub2e4\uc218\uc758 \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \uc774\uc6a9\ud560\uc218 \uc788\ub3c4\ub85d \uc1a1\uc218\uc2e0 \uc790\ub8cc\ub97c \ud2b8\ub79c\uc7ad\uc158\ub2e8\uc704\ub85c \uc555\ucd95, \ube44\uc5b4\uc788\ub294 \uacf5\uac04\uc744 \ub2e4\ub978 \uc0ac\uc6a9\uc790\ub4e4\uc774 \ud568\uaed8 \uc4f8\uc218 \uc788\ub3c4\ub85d \ud568<\/p>\n
# OLAP(On-line analytical processing)
\n– \ub514\ube44\ub4f1\uc5d0 \uc800\uc7a5\ub41c \uc790\ub8cc\ub97c \ub2e4\uac01\ub3c4\uc5d0\uc11c \ubcfc\uc218 \uc788\ub3c4\ub85d \ud574\uc8fc\ub294 \uc11c\ube44\uc2a4
\n– \ubbf8\ub798\uc5d0 \ubc1c\uc0dd\ud560 \uc0ac\uac74\uc5d0 \ub300\ud574 \ucd5c\uace0 \uacbd\uc601\uc790\uc758 \uc758\uc0ac\uc9c0\uc6d0 \uacb0\uc815\uc744 \uac00\ub2a5\ud558\uac8c \ud574\uc8fc\ub294 \ub3c4\uad6c<\/p>\n
# ETT \ub3c4\uad6c
\n– \uc6b4\uc601\uacc4 \uc2dc\uc2a4\ud15c\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ucd94\ucd9c(Extraction), \ubcc0\ud658(Transformation) \ud574\uc11c DW\ub85c \uc801\uc7ac(Transportation)\ub97c \uc704\ud55c \ub3c4\uad6c\ub4e4<\/p>\n
# DW(data warehouse)
\n– \uacfc\uac70\uc758 \ubc1c\uc0dd\ud55c \uc77c\ub4e4\uc5d0 \ub300\ud574 ‘\ub204\uac00’, ‘\ubb34\uc5c7\uc744’\uc5d0 \ub300\ud55c \uc790\ub8cc\ub97c \ubaa8\uc544 \ub193\uc740 \uc9d1<\/p>\n
# MIS(management information system) – \uacbd\uc601\uc815\ubcf4\uc2dc\uc2a4\ud15c
\n– \uae30\uc5c5\uacbd\uc601\uc5d0\uc11c \uc758\uc0ac\uacb0\uc815\uc758 \uc720\ud6a8\uc131\uc744 \ub192\uc774\uae30 \uc704\ud558\uc5ec,
\n\uacbd\uc601 \ub0b4\uc678\uc758 \uad00\ub828 \uc815\ubcf4\ub97c \ud544\uc694\uc5d0 \ub530\ub77c \uc989\uac01\uc801\uc73c\ub85c \ub300\ub7c9 \uc218\uc9d1,\uc804\ub2ec,\ucc98\ub9ac,\uc800\uc7a5,\uc774\uc6a9\ud560\uc218 \uc788\ub3c4\ub85d \ud3b8\uc131\ud55c \uc778\uac04\uacfc \ucef4\ud4e8\ud130\uc758 \uacb0\ud569 \uc2dc\uc2a4\ud15c<\/p>\n
# ERP(enterprise resource plannig) – \uc804\uc0ac\uc801 \uc790\uc6d0\uad00\ub9ac
\n– \uae30\uc5c5\uc5d0\uc11c \uae30\uac04\uc744 \uc774\ub8e8\ub294 \uc5c5\ubb34\ub4e4(\uc0dd\uc0b0,\uc790\uc7ac,\uc601\uc5c5,\uc778\uc0ac,\ud68c\uacc4)\ub97c \ud1b5\ud569 \uad00\ub9ac\ud574\uc8fc\ub294 \ub300\ud615 \uacbd\uc601\uad00\ub9ac\ud615\ud328\ud0a4\uc9c0 \uc18c\ud504\ud2b8\uc6e8\uc5b4<\/p>\n","protected":false},"excerpt":{"rendered":"
# OLTP(On-line Transaction Processing) – \ud130\ubbf8\ub0a0\uc758 \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 \uadf8 \uacb0\uacfc\ub97c \ud130\ubbf8\ub110\uc5d0 \ub418\ub3cc\ub824 \ubcf4\ub0b4\uc8fc\ub294 \ucc98\ub9ac\ud615\ud0dc – \ub124\ud2b8\uc6cd\uc0c1\uc758 \uc5ec\ub7ec \uc774\uc6a9\uc790\uac00 \uc2e4\uc2dc\uac04\uc73c\ub85c \ub514\ube44\uc5d0 \ub370\uc774\ud130\ub97c \uac31\uc2e0\ud558\uac70\ub098 \uc870\ud68c\ud558\ub294 \ub4f1\uc758 \ub2e8\uc704 \uc791\uc5c5\uc744 \ucc98\ub9ac\ud558\ub294 \ubc29\uc2dd – \uae08\uc735,\uc804\uc0b0\uad00\ub828 \ubd80\ubb38\uc5d0\uc11c \ub9ce\uc774 \ubc1c\uc0dd, \uc628\ub77c\uc778 \uac70\ub798\ucc98\ub9ac\ub77c\uace0\ub3c4 \ud568 – \ub2e4\uc218\uc758 \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \uc774\uc6a9\ud560\uc218 \uc788\ub3c4\ub85d \uc1a1\uc218\uc2e0 \uc790\ub8cc\ub97c \ud2b8\ub79c\uc7ad\uc158\ub2e8\uc704\ub85c \uc555\ucd95, \ube44\uc5b4\uc788\ub294 \uacf5\uac04\uc744 \ub2e4\ub978 \uc0ac\uc6a9\uc790\ub4e4\uc774 … \uacc4\uc18d \uc77d\uae30 “OLTP, OLAP, ETT\ub3c4\uad6c, DW, MIS, ERP\ub294 \ubb34\uc5c7\uc778\uac00?”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1399","post","type-post","status-publish","format-standard","hentry","category-tip"],"_links":{"self":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1399","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1399"}],"version-history":[{"count":0,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1399\/revisions"}],"wp:attachment":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1399"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1399"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1399"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}