/ ( ) OO i
1....1 2. /...3 2.1 /...3 2.1.1 / IT...4 2.1.2 /...4 2.1.3 /...4 2.2...5 2.2.1...5 2.2.2...6 2.3...9 2.3.1...9 2.3.2...9 2.3.3...9 2.3.4...9 3....10 3.1...10 3.1.1...10 3.1.2...10 3.1.3...14 3.2...16 3.2.1...16 3.2.2...16 3.2.3...17 3.3...17 3.3.1 ERP...17 3.3.2...17 3.4...18 3.4.1...18 3.4.2...19 3.4.3...20 3.4.4...20 3.4.5...20 3.4.6...20 3.4.7...20 3.4.8...21 3.5 ORACLE BIS...21 ii
3.5.1 Oracle BIS...21 3.5.2...21 3.6 EDI...22 3.7...22 4. /...25 4.1...25 4.1.1...25 4.1.2 /...26 4.1.3 Oracle...26 4.1.4 Oracle...27 4.1.6 Oracle...27 4.1.7 Oracle...27 4.1.8 Oracle...27 4.1.9 Oracle...27 4.1.10 Oracle...28 4.1.11 Oracle...28 4.1.13 Oracle ()...28 4.1.14 Oracle ()...28 4.1.15 Oracle...28 4.2 ORACLE OLAP...29 4.2.1 Oracle...29 4.2.2 Oracle Express ()...29 4.2.3 Oracle OLAP ()...29 4.2.4 ()...29 4.3...29 4.3.1 ()...29 4.3.2 Oracle...29 4.3.3...29 4.3.4...29 4.3.5 PC ()...29 4.3.7 ()...29 5....30 5.1 ()...30 5.2 ()...30 5.3 ()...30 5.4 ()...30 5.5 ()...30 5.6 ()...30 6. ORACLE...31 6.1 ORACLE...31 iii
6.2...32 6.2.1...32 6.2.2...33 6.2.3...34 7. /...37 7.1...37 7.2...37 7.2.1...38 7.2.2...38 7.2.3...38 7.2.4...40 7.2.5...40 7.2.6...40 7.3...41 7.3.1...41 7.3.2...42 7.3.3...42 7.3.4...45 7.3.5...45 7.3.6...46 7.3.7 (Deliverable)...47 7.4...48 7.5...48 7.5.1...49 7.5.2...50 7.5.3...51 7.5.4...53 7.6...56 7.7...56 8....57 8.1 ()...57 8.2...57 8.2.1 ()...57 8.2.2 ()...57 8.2.3 ()...57 8.2.4 ()...57 8.2.5 ()...57 8.2.6 ()...57 8.2.7 DBA ()...57 8.2.8 DBA ()...57 iv
8.2.9 ()...57 8.3 7X24 ()...57 9....58 9.1...58 9.2...58 9.3...61 v
1. / / (MIS) / ORACLE Application 100 Oracle AIM PJM 1
Quick-Hand, 24 ORACLE OAR ORACLE ORACLE / 2
2. / 2.1 / / 18 13 MIS /// BOSS OA CMHK 3
2.1.1 / IT () 2.1.2 / (1) (2) (3) (4) (1) (2) (3) (4) (5) 2.1.3 / / 4
/ 2.2 2.2.1 SEM / DSS / CRM 5
2.2.2 90 WTO / EAI ERP BOSS OA SCM KPI MIS / 6
/ / Oracle / / / / / / 7
/ / WTO / Web 8
2.3 2.3.1 Oracle SQL / / Internet/Intranet 2.3.2 Oracle 2.3.3 Oracle Oracle 24 20 2.3.4 Oracle Oracle 9
3. 3.1 3.1.1 3.1.2 Oracle 5000 Oracle 3.1.2.1 Oracle Balancing Entity Balancing Entity Balancing Entity 3.1.2.2 Oracle 10
Oracle Oracle Oracle Oracle, Oracle Oracle -- 11
3.1.2.3 Oracle (GCS) Oracle GCS 3.1.2.4 OLAP (CENTRA) 3.1.2.5 CENTRA CENTRA CENTRA,Oracle 60 12
3.1.2.6 (ADI) Oracle Excel Oracle Oracle Oracle ADI ADI GLDI ADI WEB 3.1.2.7 database link database link database link 13
database link Oracle ERP OFAADI OLAP 3.1.3 Oracle Oracle Oracle Oracle (OLAP) Oracle Oracle Oracle Oracle FADI Oracle 3.1.3.1 Oracle Oracle Oracle 14
Oracle 3.1.3.2 3.1.3.3,Oracle Oracle Oracle Receivables Oracle 3.1.3.4 3.1.3.5 Oracle Assets Oracle Oracle () Oracle Cash Management Oracle Receivables ( )Oracle Payables( )Oracle General Ledger ( ) Oracle 15
3.2 3.2.1 3.2.1.1 Oracle Oracle EDI 3.2.1.2 Oracle 3.2.2 3.2.2.1 16
3.2.3 3.2.3.1 Oracle Oracle 3.3 3.3.1 ERP 3.3.2 Oracle 17
3.4.Oracle Oracle,,,, 3.4.1 ( ) 18
3.4.2 : 3.4.2.2 : 19
3.4.3 3.4.4 3.4.5 : : : 3.4.6 3.4.7 : 20
3.4.8 3.5 Oracle BIS 3.5.1 Oracle BIS Oracle Business Intelligence BIS Oracle Oracle OFA ABM WebDB 3.5.2 Oracle Oracle Oracle Oracle Oracle Oracle : 1. 2. 3. 4. (KPI),: 21
/ / 3.6 EDI Oracle Oracle (workflow) Oracle Workflow Oracle Oracle Web Employees Oracle Workflow Oracle Oracle EDI Oracle ( ) (Excel ) EDI. 3.7 OFA/OLAP/DW Oracle Oracle 22
OFA(Oracle Financial Analyer )OLAP DW OA Oracle Oralce BOSS BOSS BOSS Oralce BOSS Oracle BOSS Oracle /, OA Oracle OA Lotus Notes mail Oracle Mail OA Mail Oracle Mail Oracle mail Oracle URL link link mail Internet mail 23
Mail 24
4. / 4.1 Oracle Internet / Intranet MIS, Oracle ica ( Oracle internet Computer Architecture ) ica / Oracle ica Internet/Intranet Oracle, ; JAVA Applet IT ( ) LAN WAN D B MS L A N T e r m i n a l Serve r t e l e p ho ne line NC D B MS LAN WAN T elephone line PC WorkStation N C PC WorkStation 4.1.1 25
Oracle Application ica / Application Server Oracle Data Warehouse Import/Export Oracle Application (open interface) Oracle (GCS) Oracle Application ica Oracle Data Warehouse Import/Export Oracle Application open interface MIS Oracle (GCS) ( ) 4.1.2 / 4.1.3 Oracle / Oracle ica Internet/Intranet 26
4.1.4 Oracle / Oracle IBMHPSunNECHitachiFujitsuSGIDECUnisys NovelDOSWindows/NT Oracle Oracle SMP Cluster MPP Oracle SQL PL/SQL 4.1.6 Oracle MIS Oracle 4.1.7 Oracle / Oracle OracleC2 ( UNIX,VMS ) NCSC C2, NCSC C2 B1 NCSC NCSC B1 4.1.8 Oracle / Oracle Oracle Oracle Oracle / 4.1.9 Oracle / 27
4.1.10 Oracle / Oracle 4.1.11 Oracle Oracle Enterprise Manager Oracle Oracle Transparent Gateway ( ) Oracle Procedural Gateway ( ) 4.1.13 Oracle () 4.1.14 Oracle () 4.1.15 Oracle Oracle Applications Oracle Applications Oracle SQL*Loader ( ) SQL Load / Script Oracle Oracle Cooperative Applications 28
4.2 Oracle OLAP 4.2.1 Oracle Oracle ( ) BOSS POS SIM Oracle Applications / OLTP Oracle8 sophisticated query optimization parallel hardware configuration Rich Query Processing Techniques SQL Sophisticated SQL Optimizer 4.2.2 Oracle Express () 4.2.3 Oracle OLAP () 4.2.4 () 4.3 4.3.1 () 4.3.2 Oracle 4.3.3 Oracle 4.3.4 4.3.5 PC () 4.3.7 () Oracle 29
5. 5.1 () 5.2 () 5.3 () 5.4 () 5.5 () 5.6 () 30
6. Oracle 6.1 Oracle Oracle 100, Binariang Clear Communications Hong Kong Telecom Vodafone PLDT Philippines SKS-Korea Singapore Telephone Aria West Telstra Dacom Hutchison Korea Telecom Korea Mobile Telecom New T&T NTT Japan Optus PT Telekom Indonesia Shinawatra Thailand T&T Telecom New Zealand Telekom Malaysia Mobikom Oracle, : Airtouch AT&T Wireless System British Columbia Telephone BR Telecommunications Bell Atlantic Bell Canada Bellcore Bell Labs Bell South NYNEX McCaw Cellular Sprint Telefonos de Mexico Time Warner Cable US Cellular US West British Telephone Cable & Wireless Ericsson Finnish Telecom France Telecom Mercury Norwegian Telecom Swiss Telecom Telecom Eireann Telecom Italia Tele2 31
Cellular One PacBell Deutsche Telecom Dutch Telecom Energis Telia Tele Denmark Telefonica ( ) 6.2 6.2.1 WTO MIS ( ) MIS GMCC MIS ORACLESAP ORACLE ( ) ORACLE ERP MIS MIS 1999719 GMCC GMCCJMCCZMCC KPMG BPR ORACLE MIS 2-4 MIS 2000630 ORACLE ORACLE (ADI) 32
2001630 ORACLE 2001131 ORACLE OFA( ) ORACLE OLAP 1. GMCC 23 85 2. JMCC 13 55 3. ZMCC 7 67 6.2.2 ORACLE GLAPFAINVADIOFA 20023 ORACLE APPLICATION 130 118 5 150 1115OU3500 740 33
6.2.3 1. ORACLE ERP 2. ( ) ERP 1. 2. ORACLE ERP ERP 3. ORACLE ERP ORACLE 4. 34
5. 6. ( ) 7. 40 ORACLE ERP 8. 9. 35
10. 11. ORACLE ERP Oracle 36
7. / 7.1 / 7.2 ORACLE ERP 37
7.2.1 / () () () 7.2.2 18 2 3 56 7.2.3 1. 38
2. 3. ERP 1. ORACLE 2. 3. 1. 2. 3. 4. () 39
7.2.4 ORACLE OLAP OFA 7.2.5 25-30% 7.2.6 Oracle 40
Oracle Oracle Oracle Oracle Oracle Oracle Oracle 7.3 7.3.1 18 1. / 2. 41
3. / () () 18 () 5 8 () () 7.3.2 4. / () (() (PJM/AIM ) A () B C () 7.3.3 / 42
1. 2. 3. () 4. 5. 1. 2. 3. 4. 5. 6. 1. 2. 3. 1. 43
2. 1. 2. 3., 44
7.3.4 7.3.5 45
/ / / 7.3.6 1. 1) 2) 3) 4) 5) 6) 7) 8) 2. (Form) (Log) 3. (Form) (Log) 4. 5. 46
7.3.7 (Deliverable) 6. PM PM PM Definition Analysis Design IT W Build Test Transition W W W W W W I W W W I I I I I I I I PM PM/ PM PM PM 47
Production I W W I PM : : I=, W= : C= PM= / 7.4 Oracle Method QuickHand / Oracle AIM CDM DWM PJM QuickHand ERP ERP ERP Oracle 7.5 ( ),, 48
7.5.1 A B A B A B 49
7.5.2 Frank Dean QA 50
7.5.3 1. 2. 3. 4. 5. 1. 2. 3. 4. 5. 6. () 7. 1. 2. () () 3. () 4. 5. 1. () 51
2. () 3. () 4. () 5. 1. () 2. () 3. Oracle 4. Oracle, () 1. () 2. () 3. 4. Oracle, () 1. () 2. () 3. 4. Oracle, () ( ) 1. Oracle 52
2. Oracle 1. 2. 1. 2. 1. 2. 3. ( ) 7.5.4 1. 2. 3., 4. 5. 1. 2. 3. 4. 53
5. 6. 1. 2. () () 3. () 4. 5. 1. 2. () 3. () 4. 5. 1. () 2. 3. () 1. Oracle 2. 54
3. 1. 2. Oracle 3. 1. 2. 3. 1. Oracle Oracle 2. 3. ( ) 1. Oracle 2., 3. 1. 2. 1. 2. 3. ( ) 55
1. 2. 7.6 7.7 100 ( ) 56
8. 8.1 () / IT 8.2 8.2.1 () 8.2.2 () ORACLE DBA 7x24 8.2.3 () 8.2.4 () 8.2.5 () 8.2.6 () 8.2.7 DBA () 8.2.8 DBA () 8.2.9 () 8.3 7x24 () 57
9. 9.1 9.2 (1) K (2) (3) 18. K K+30 K+31 K+50 MIS K+51 K+90 CMHK / 58
(GLAPARPO&INV / ) K+91 K+130 K+131 K+180 K+181 K+250 K+91 K+250 (PAFACE&BIS ) K+251 K+300 59
K+301 K+360 K+361 - K+480 K+251 K+480 K+181 K+ 560 K+181 K+ 560 K+251 K+300 60
9.3 () 1 1 1 1 18 1 8 2 2 118 1 5 6 2 () () () () 20 110 3 1 1 61
1 9 2 1 2 3, 1 4 62