C3印刷用.PDF

Size: px

Start display at page:

Download "C3印刷用.PDF"

ともあきながだき
4 years ago
Views:

1 [ C-3 ] Oracle8i On Windows

2 Agenda Windows Oracle8i Oracle8i for Windows NT/2000 R8.1.7 Oracle HTTP Server Oracle intermedia Oracle Workflow

3 Windows

4 Oracle8i for Windows Oracle8i Enterprise Edition Oracle8i Personal Edition Oracle8i Workgroup Server Oracle8i Lite Windows 95/98/NT/2000 Windows CE Palm Windows NT 4.0 Windows 2000 Windows 98 Windows NT4.0 Windows 2000 Windows NT 4.0 Windows 2000

5 Oracle8i Enterprise Edition R /4 Windows 2000 Oracle8i Enterprise Edition R /7 Oracle Fail Safe 1998/1 Oracle8 Enterprise Edition R /9 NT 4.0 EE Oracle Parallel Server Option 1997/7 (2000/2) (1997/11) Oracle7 Server R /12 NT 4.0 (1996/12) Oracle7 Server R /1 NT 3.51 (1996/1) Oracle7 Server R /5 NT 3.5 (1994/12) Oracle7 Server R /6 NT 3.1 (1993/ )

6 Oracle for NT NT NT AP ODBC OO4O COM Automation OLE DB Provider ( MMC)

7 COM MS Office Applications Visual Basic Applications COM/DCOM ADO C/C++ Applications COM Automation Feature Oracle Objects for OLE OCI C library Oracle (or 3rd Party) OLE DB OLE DB/ODBC Bridge Net8 Oracle

8 MTS Oracle Services for Microsoft Transaction Server MSDTC Oracle OLE Oracle MTS/COM+ OraMTS RM OraMTS OraMTS Job

9 Oracle Administration Assistant Windows NT NT Oracle Oracle Oracle_Home

10 Professional Server Advanced Server Datacenter Server CPU 4G G 8G 64G Oracle8i R8.1.6 Windows2000 Windows 2000 Enterprise Memory Architecture Active Directory Terminal Service Microsoft Cluster Service

11 VLM Intel PSE36 PAE36(AWE) Windows 64GB Windows 2000 Intel Xeon DB Buffer Advanced Server 8GB 4GB Datacenter Server 64GB SGA (R8.1.6 ) 1GB DB Buffer Oracle8i OS

12 300 Sec SUM

13 Active Directory Active Directory Windows 2000 LDAP Oracle8i Active Directory Net8 Enterprise User Security

14 OS OS 1 1 OS Oracle Administration Assistant for Windows NT

15 Oracle Administration Assistant OS Active Directory

16 Net8 Net8 Active Directory Database Configuration Assistant TNSNAMES.ORA Net8 Configuration Assistant Net8 AD Active Directory

17 Net8 Sales Sales?,,,, etc... Active Directory

18 Enterprise User Security SSL(Secure Socket Layer) X.509 (User Certificate and Digital Signature ) Active Directory Oracle Advanced Security

19 Enterprise User Security W / Active Directory / Oracle Enterprise Security Manager Net8/SSL W W W Oracle Wallet Manager

20 Terminal Service Windows 2000 Terminal Service Oracle8i Objects for OLE Oracle ODBC Pro*C/C++ Terminal Service OK Cancel OK Cancel OK Cancel OK Cancel AP TCO Citrix Metaframe Citrix Metaframe Terminal Service

21 Cluster

22 Oracle Fail Safe Microsoft Cluster Server 2 Windows 2000 Advanced Server 4 Windows 2000 Datacenter Server Cold Failover Enterprise Edition Workgroup Server Windows NT 4.0 Enterprise Edition

23 Oracle Fail Safe Active/Passive -1 LAN A DBMS-A B DB-A NTFS

24 Oracle Fail Safe Active/Passive -2 LAN A DBMS-A B DB-A NTFS

25 Oracle Fail Safe Active/Passive -3 LAN A DBMS-A B DB-A NTFS NTFS

26 Oracle Fail Safe Active/Active -1 LAN A DBMS-A DBMS-B B DB-A DB-B NTFS

27 Oracle Fail Safe Active/Active -2 LAN A DBMS-A DBMS-B B DB-A DB-B NTFS

28 Oracle Fail Safe Active/Active -3 LAN A DBMS-B B DBMS-A DB-A DB-B NTFS

29 Oracle Parallel Server Oracle 1 1 (Warm/Hot Failover) Oracle Parallel Server!!

30 Oracle Parallel Server LAN DBMS-A DBMS-B DBMS-A DBMS-B DBMS-A DBMS-B DBMS-A DBMS-B DB-A DB-B DB

31 Partitioning

32 Q1_ORDERS JAN_ORDERS 01-JAN-99 to 31-JAN-99 FEB_ORDERS 01-FEB-99 to 28-FEB-99 MAR_ORDERS 01-MAR-99 to 31-MAR-99

33 RDBMS Select Q1_ORDERS JAN_ORDERS FEB_ORDERS MAR_ORDERS Update / Delete / Insert

34 Oracle RDBMS Select / Update / Delete / Insert Q1_ORDERS JAN_ORDERS FEB_ORDERS MAR_ORDERS

35 Oracle8i (ORDER) H1 Q1 Q2 Q3 Q4 Q4 H4 (PRODUCTS) Q1 Q2 (ORDER ITEM) Q3 H8 H1 H4 H8

36 ORDER

38 DML C P U C P U C P U SMP SQL C P U C P U C P U C P U C P U INSERT..SELECT UPDATE DELETE CREATE..SELECT CPU

39 Bitmap Index

40 CREATE BITMAP INDEX prod_color ON prod(color); Color <Blue, > <Green, > <Red, > <Yellow, > (AND OR ) I/O SQL

41 Fact Dimension Dimension High Ad-hoc Low Oracle8i Star Index Specialty Vendors Star Aware Oracle7 SQL Server Nothing 7.0 SQL Server Parallel Bitmap Star Join ( )

42 Key Oracle8i Now on Sale!! Key Key

43 Oracle8i for Windows NT/2000 R8.1.7

44 Oracle8i for Windows NT/2000 R8.1.7 Oracle8i (R8.1) Java Servlets Engine Oracle HTTP Server Oracle intermedia Oracle Workflow (Enterprise Edition) 4Node-Cluster (Oracle Fail Safe R3.1)

45 Java Servlets Engine Java Oracle8i JVM Java Stored Procedures CORBA Objects Enterprise JavaBeans Java Servlets ORB CORBA Web Pages Web

46 Web Oracle HTTP Server powered by Apache DB HTML Web URL HTML URL HTML URL HTML Oracle HTTP Server mod_ose mod_plsql HTML Servlets PL/SQL

47 Oracle intermedia Oracle8i intermedia

48 intermedia - Modules Oracle intermedia : Oracle intermedia Text Oracle intermedia Image. Oracle intermedia Audio Oracle intermedia Video Oracle intermedia Locator

49 intermedia Text SQL API DB Security programming interface SQL or PL/SQL

50 intermedia Text INSO 100 (Word,Excel,Powerpoint, etc.) Index HTML Web Web DB BLOB OS File URL

51 intermedia Image, Audio, Video, Metadata : BLOB, Bfile, URL, Server :, URL, TWAIN Device Java Client

52 intermedia Audio, Video Real Server Oracle Video Server BLOB

53 intermedia Locator (MapInfo s MapXtreme ) (QMSoft Centrus MapInfo MapMarker ) 10Km

54 Oracle Workflow (EE ) Oracle8i Enterprise Edition R8.1.7 R8.1.6 Web 100%

55 Workflow / HTML

56 Workflow Advanced Queues Workflow WF Engine API WF Engine API WF Tables WF Tables WF Tables WF Tables WF Engine API WF Engine API WF

57 Web Oracle Workflow Option

58 Workflow

59 Workflow PL/SQL APIs Workflow API Ad Hoc & JAVA APIs PL/SQL APIs

60 Advanced Queues C/C++ JAVA PL/SQL Advanced Queues

61 Oracle Fail Safe R3.1 Windows 2000 Datacenter Server 4 Database Server App Server HTTP Server Standby

62 Oracle for Windows Phase 3 Oracle8i R8.1.7 Oracle8i JVM Accelerator Phase 2 Java Server Pages Servlet Oracle8i R8.1.6 XML Oracle JVM Oracle Integration Server Java2 Phase 1 Oracle8i R8.1.5 PL/SQL Server Pages Oracle Parallel Fail Safe 2001/02

63 Windows - Oracle for Windows

Windows Oracle -Web - Copyright Oracle Corporation Japan, All rights reserved.

Windows Oracle -Web - Copyright Oracle Corporation Japan, 2004. All rights reserved. Agenda Oracle Windows Windows Oracle 1 / Active Directory/Enterprise User Security 1-1 Windows 1-2 Kerberos 1-3 Enterprise