Jenny Tsai Principal Product Manager Server Technologies Oracle

Jenny Tsai Principal Product Manager Server Technologies Oracle Corporation

Oracle 9 i The e. Business Platform

Key Development Focus Areas for Oracle 9 i Database Availability Scalability & Performance Security Development Platform Internet Content Management B 2 C and B 2 B e. Business Packaged Applications Manageability Windows 2000 Integration Business Intelligence

Availability • Protection from Catastrophic Failures • Online Data Evolution • Precision Database Repair • Self-Service Error Correction Achieving Continuous Data Availability

Protection from Catastrophic Failures - Oracle Data Guard Logical Continuously Standby Open SQL Apply Graceful Switchover and Switchback (Both) Additional Indexes & Materialized Views Production Physical Standby Delayed and Zero Loss Modes (Both) Management Framework (Both)

Online Data Evolution Ÿ Online Table Re-definition Ÿ Online creation of secondary indexes on Index-Organized Tables Ÿ Rapid Quiesce

Scalability and Performance • Increased transaction throughput on Real Application Clusters • Fine grained, automatic resource management • Optimize features critical for e. Business Support millions of Internet Users

Scalability, Real Application Clusters Ÿ Fast Growth Clusters – Rapidly Add Nodes And Disk Ÿ Vendor Independent Architecture – Linux, NT, AIX, Solaris, HP-UX, Compaq 1 -20

Real Application Clusters Oracle Applications Scalability 3648 4000 # of users 3500 3000 2500 1900 2000 1500 1026 1000 500 0 Single Node Two Nodes Four Nodes 1 -21

Security • Strong, three-tier security • Security for hosting environments • Standards-based Public Key Infrastructure (PKI) • Improved user and security policy management • Data encryption and label security Support End-to-End Security Infrastructure for Millions of Users

Strong, three-tier security Oracle Internet Directory (LDAP) Database retrieves authorizations for user, connects user to application schema User authenticates to middle tier (SSL) Middle tier proxies user identity (DN, Certificate) to database User A User B User C User D User E Application Server Oracle 9 i Server

Deep Data Protection: Virtual Private Database Partitioned Application Context User A Policy A User B Context Pooling Default Policy User C Policy Manager Tool Tax Records

Deep Data Protection: Fine-grained Auditing Audit Policy Not Audited . . . WHERE SALARY >500000 RELEVANT COLUMN = SALARY SELECT NAME, ADDRESS FROM EMP Audit Records SELECT NAME, SALARY FROM EMP WHERE NAME=ELLISON ES YE PLO EM Confidential SELECT NAME, SALARY FROM EMP WHERE NAME = ELLISON, , , etc.

Development Platform • Enterprise Java Engine • XML Type and XDK • SQL and PL/SQL improvements Create the most complete platform for developing e. Business applications

Built-in XML Developer Kits (XDK) and XML Type XML Schema Processor Class Generator Relational Tables Native XML Storage (XMLType) XML/XSLT Parser XSQL Servlet XML Transviewer Bean Character LOB’s

Manageability • Make the database self managing • Streamline and improve the operational management • Provide tools and techniques that simplify and reduce the task time required • Provide an end-to-end system management solution Keep the number of DBA’s constant as we scale to Internet Use

Make the database self managing Buffer Cache/Shared Pool Dynamically resizable Transparent Private Working Memory Buffer Cache Shared Pool Advisories Provided System Managed Undo Rollback Segments

Microsoft Integration • Close integration with Windows 2000 • Facilitated development and deployment on MS Windows platforms Lead platform of choice for organizations deploying on Windows 2000

Close integration with Windows 2000 Microsoft MTS Microsoft Active Directory and Certificate Store Microsoft COM+ Microsoft MSMQ Microsoft IIS

Content Management • Storing and managing all types of • • content Content Syndication for Internet applications Searching and indexing all types of content efficiently Organization of content for collaborative projects Location-enabled, mobile-ready content Consolidate all Internet Content in Oracle Databases

Storing, managing, aggregating, and searching all types of Content File Manager (SMB) Web (HTML) e. Mail (IMAP, POP) FTP NFS Native Java Native PL/SQL Web. DAV internet File System Metadata Extraction Ultra Search Catalogue optimized indexing

B 2 C and B 2 B e. Business • Providing a standard infrastructure to create storefronts, exchanges and portals • Supporting millions of messages/hour in industry standard business messaging formats • Distributed environment improvements Support storefronts and exchanges with thousands of suppliers and millions of transactions/hour

Millions of messages/hour in industry standard formats Global Topics and Agents Internet Consumers Oracle Internet Directory i. DAP Message Requests XML Messages over HTTP PL/SQL and XSLT Transformations Message Gateway for MQSeries, Tibco and MSMQ

Packaged Applications • Globalization - Expanding e. Business to the World Market • Providing tactical development features required by ISVs Provide the best platform to develop, deploy and host Packaged Applications

Globalization - Expanding e. Business to the World Market Multi language via Unicode 3. 0 UTF 8 and UTF 16 Locale Builder Multilingual, Linguistic and User Definable Collation Unicode datatype Character Set Scanner Timezone and DST Support

Business Intelligence • Scalability, performance, and manageability • Complete business intelligence platform: ETL, Integrated analysis and Personalization capabilities Scalable, internet-ready business intelligence platform

ETL, Integrated analysis and Personalization capabilities Clickstream Data Operational Data Reporting External Tables OLAP Server Change Data Capture Table Functions External Data Mining Multi table Inserts MERGE (Upsert) Querying Analysis Recommendations Warehouse Metadata Personalization XML Data Unload

Key Development Focus Areas for Oracle 9 i Database Availability Scalability & Performance Security Development Platform Internet Content Management B 2 C and B 2 B e. Business Packaged Applications Manageability Windows 2000 Integration Business Intelligence

Thank You Jenny Tsai Jenny. Tsai@oracle. com Oracle Corporation Confidential