[ C-3 ] Oracle8i On Windows
Agenda Windows Oracle8i Oracle8i for Windows NT/2000 R8.1.7 Oracle HTTP Server Oracle intermedia Oracle Workflow
Windows
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
Oracle8i Enterprise Edition R8.1.6 2000/4 Windows 2000 Oracle8i Enterprise Edition R8.1.5 1999/7 Oracle Fail Safe 1998/1 Oracle8 Enterprise Edition R8.0 1997/9 NT 4.0 EE Oracle Parallel Server Option 1997/7 (2000/2) (1997/11) Oracle7 Server R7.3 1996/12 NT 4.0 (1996/12) Oracle7 Server R7.2 1996/1 NT 3.51 (1996/1) Oracle7 Server R7.1 1995/5 NT 3.5 (1994/12) Oracle7 Server R7.0 1994/6 NT 3.1 (1993/ )
Oracle for NT NT NT AP ODBC OO4O COM Automation OLE DB Provider ( MMC)
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
MTS Oracle Services for Microsoft Transaction Server MSDTC Oracle OLE Oracle MTS/COM+ OraMTS RM OraMTS OraMTS Job
Oracle Administration Assistant Windows NT NT Oracle Oracle Oracle_Home
Professional Server Advanced Server Datacenter Server CPU 4G 2 2 4 8 4G 8G 64G -- -- 2 4 Oracle8i R8.1.6 Windows2000 Windows 2000 Enterprise Memory Architecture Active Directory Terminal Service Microsoft Cluster Service
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
300 Sec 1. 2. 3.SUM 4.1000 5.
Active Directory Active Directory Windows 2000 LDAP Oracle8i Active Directory Net8 Enterprise User Security
OS OS 1 1 OS Oracle Administration Assistant for Windows NT
Oracle Administration Assistant OS Active Directory
Net8 Net8 Active Directory Database Configuration Assistant TNSNAMES.ORA Net8 Configuration Assistant Net8 AD Active Directory
Net8 Sales Sales?,,,, etc... Active Directory
Enterprise User Security SSL(Secure Socket Layer) X.509 (User Certificate and Digital Signature ) Active Directory Oracle Advanced Security
Enterprise User Security W / Active Directory / Oracle Enterprise Security Manager Net8/SSL W W W Oracle Wallet Manager
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
Cluster
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
Oracle Fail Safe Active/Passive -1 LAN A DBMS-A B DB-A NTFS
Oracle Fail Safe Active/Passive -2 LAN A DBMS-A B DB-A NTFS
Oracle Fail Safe Active/Passive -3 LAN A DBMS-A B DB-A NTFS NTFS
Oracle Fail Safe Active/Active -1 LAN A DBMS-A DBMS-B B DB-A DB-B NTFS
Oracle Fail Safe Active/Active -2 LAN A DBMS-A DBMS-B B DB-A DB-B NTFS
Oracle Fail Safe Active/Active -3 LAN A DBMS-B B DBMS-A DB-A DB-B NTFS
Oracle Parallel Server Oracle 1 1 (Warm/Hot Failover) Oracle Parallel Server!!
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
Partitioning
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
RDBMS Select Q1_ORDERS JAN_ORDERS FEB_ORDERS MAR_ORDERS Update / Delete / Insert
Oracle RDBMS Select / Update / Delete / Insert Q1_ORDERS JAN_ORDERS FEB_ORDERS MAR_ORDERS
Oracle8i (ORDER) H1 Q1 Q2 Q3 Q4 Q4 H4 (PRODUCTS) Q1 Q2 (ORDER ITEM) Q3 H8 H1 H4 H8
ORDER 1 2 3 4
4 8 8...
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
Bitmap Index
CREATE BITMAP INDEX prod_color ON prod(color); Color <Blue, 1000100100010010100> <Green, 0001010000100100000> <Red, 0100000011000001001> <Yellow, 0010001000001000010> (AND OR ) I/O SQL
Fact Dimension Dimension High Ad-hoc Low Oracle8i Star Index Specialty Vendors Star Aware Oracle7 SQL Server Nothing 7.0 SQL Server 6.5 0 Parallel Bitmap Star Join 1 2 3 ( )
Key Oracle8i Now on Sale!! Key Key
Oracle8i for Windows NT/2000 R8.1.7
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)
Java Servlets Engine Java Oracle8i JVM Java Stored Procedures CORBA Objects Enterprise JavaBeans Java Servlets ORB CORBA Web Pages Web
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
Oracle intermedia Oracle8i intermedia
intermedia - Modules Oracle intermedia : Oracle intermedia Text Oracle intermedia Image. Oracle intermedia Audio Oracle intermedia Video Oracle intermedia Locator
intermedia Text SQL API DB Security programming interface SQL or PL/SQL
intermedia Text INSO 100 (Word,Excel,Powerpoint, etc.) Index HTML Web Web DB BLOB OS File URL
intermedia Image, Audio, Video, Metadata : BLOB, Bfile, URL, Server :, URL, TWAIN Device Java Client
intermedia Audio, Video Real Server Oracle Video Server BLOB
intermedia Locator (MapInfo s MapXtreme ) (QMSoft Centrus MapInfo MapMarker ) 10Km
Oracle Workflow (EE ) Oracle8i Enterprise Edition R8.1.7 R8.1.6 Web 100%
Workflow / HTML
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
E-MAIL Web Oracle Workflow Option
Workflow
Workflow PL/SQL APIs Workflow API Ad Hoc & JAVA APIs PL/SQL APIs
Advanced Queues C/C++ JAVA PL/SQL Advanced Queues
Oracle Fail Safe R3.1 Windows 2000 Datacenter Server 4 Database Server App Server HTTP Server Standby
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
Windows - Oracle for Windows