Jenny TsaiPrincipal Product ManagerServer TechnologiesOracle Corporation

Oracle9i The eBusiness Platform

Key Development Focus Areas for Oracle9i Database

AvailabilityAvailability

Scalability &Scalability &PerformancePerformance

SecuritySecurity

DevelopmentDevelopmentPlatformPlatform

ManageabilityManageability

Windows 2000Windows 2000IntegrationIntegration

Internet ContentInternet ContentManagementManagement

B2C and B2BB2C and B2BeBusinesseBusiness

PackagedPackagedApplicationsApplications

BusinessBusinessIntelligenceIntelligence

Availability

• Protection from Catastrophic Failures

• Online Data Evolution

• Precision Database Repair

• Self-Service Error Correction

• Protection from Catastrophic Failures

• Online Data Evolution

• Precision Database Repair

• Self-Service Error Correction

Achieving Continuous Data AvailabilityAchieving Continuous Data Availability

Protection from Catastrophic Failures - Oracle Data Guard

PhysicalStandby

Production

LogicalStandby

Graceful Switchover Graceful Switchover and Switchbackand Switchback

(Both)(Both)

ManagementManagementFrameworkFramework

(Both)(Both)

Delayed andDelayed andZero Loss ModesZero Loss Modes

(Both)(Both)

ContinuouslyContinuouslyOpenOpen SQLSQL

ApplyApply

AdditionalAdditionalIndexes & Indexes &

Materialized ViewsMaterialized Views

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 eBusiness

• Increased transaction throughput on Real Application Clusters

• Fine grained, automatic resource management

• Optimize features critical for eBusiness

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

1026

1900

3648

0

500

1000

1500

2000

2500

3000

3500

4000

SingleNode

TwoNodes

FourNodes

# o

f u

sers

Real Application ClustersOracle Applications Scalability

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

• 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 securityOracle Internet Directory

(LDAP)

User A

User B

User C

User DUser E

ApplicationServer

User authenticatesUser authenticatesto middle tier (SSL)to middle tier (SSL)

Middle tier proxiesMiddle tier proxiesuser identity (DN, Certificate)user identity (DN, Certificate)

to databaseto database

Database retrieves Database retrieves authorizations for user, authorizations for user,

connects user to connects user to application schemaapplication schema

Oracle9i Server

Deep Data Protection:Virtual Private Database

User C

User A

User B

Policy A

Policy C

Default Policy

Tax Records

ContextContextPoolingPooling

Partitioned Partitioned Application Application

ContextContext

PolicyManagerTool

Confidential

Deep Data Protection:Fine-grained Auditing

EMPLOYEES

Audit Policy

...WHERE SALARY >500000RELEVANT COLUMN = SALARY

SELECT NAME, ADDRESS FROM EMP

Not Audited

SELECT NAME, SALARY FROM EMP WHERE NAME=ELLISON

SELECT NAME, SALARY FROM EMP WHERE NAME = ELLISON, <timestamp>, <username>, etc.

Audit Records

Development Platform

• Enterprise Java Engine

• XML Type and XDK

• SQL and PL/SQL improvements

• Enterprise Java Engine

• XML Type and XDK

• SQL and PL/SQL improvements

Create the most complete platform for developing eBusiness applications

Built-in XML Developer Kits (XDK) and XML Type

Relational TablesRelational Tables

Character LOB’sCharacter LOB’s

Native XML StorageNative XML Storage(XMLType)(XMLType)

XMLXMLTransviewerTransviewer

BeanBean

ClassClassGeneratorGenerator

XML Schema ProcessorXML Schema Processor

XSQL ServletXSQL Servlet

XML/XSLT ParserXML/XSLT Parser

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

• 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

BufferCache

RollbackSegments

SharedPool

PrivateMemory

Buffer Cache/Shared PoolBuffer Cache/Shared PoolDynamically resizableDynamically resizable

AdvisoriesAdvisoriesProvidedProvided

TransparentTransparentWorking MemoryWorking Memory

System Managed UndoSystem Managed Undo

Microsoft Integration

• Close integration with Windows 2000

• Facilitated development and deployment on MS Windows platforms

• 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

MicrosoftIIS

MicrosoftMTS

MicrosoftMSMQ

Microsoft COM+

MicrosoftActive Directory

and Certificate Store

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

• 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

Ultra SearchUltra SearchCatalogueCatalogueoptimized optimized indexingindexing

MetadataMetadataExtractionExtraction

File Manager (SMB)File Manager (SMB)Web (HTML)Web (HTML)

eMail (IMAP, POP)eMail (IMAP, POP)FTPFTPNFSNFS

Native JavaNative JavaNative PL/SQLNative PL/SQL

WebDAVWebDAV

iinternet File Systemnternet File System

B2C and B2B eBusiness

• Providing a standard infrastructure to create storefronts, exchanges and portals

• Supporting millions of messages/hour in industry standard business messaging formats

• Distributed environment improvements

• 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

OracleInternet

Directory

XML MessagesXML Messagesover HTTPover HTTP

Global TopicsGlobal Topicsand Agentsand Agents

iDAPiDAPMessageMessageRequestsRequests

Internet Internet ConsumersConsumers

PL/SQL and XSLTPL/SQL and XSLTTransformationsTransformations

MessageMessageGatewayGateway

forforMQSeries,MQSeries,Tibco andTibco and

MSMQMSMQ

Packaged Applications

• Globalization - Expanding eBusiness to the World Market

• Providing tactical development features required by ISVs

• Globalization - Expanding eBusiness to the World Market

• Providing tactical development features required by ISVs

Provide the best platform to develop, deploy and host Packaged Applications

Globalization - Expanding eBusiness to the World Market

TimezoneTimezoneand DSTand DSTSupportSupport

Multi languageMulti languagevia Unicode 3.0via Unicode 3.0

UTF8 and UTF16UTF8 and UTF16

CharacterCharacterSetSet

ScannerScanner

LocaleLocaleBuilderBuilder

UnicodeUnicodedatatypedatatype

Multilingual,Multilingual,Linguistic andLinguistic andUser DefinableUser Definable

CollationCollation

Business Intelligence

• Scalability, performance, and manageability

• Complete business intelligence platform: ETL, Integrated analysis and Personalization capabilities

• 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

Metadata

Querying

Reporting

Analysis

OperationalData

ExternalData

ClickstreamData

WarehousePersonalization

ExternalExternalTablesTables

ChangeChangeData CaptureData Capture

Multi tableMulti tableInsertsInserts

MERGE (Upsert)MERGE (Upsert)

DataDataMiningMining

OLAPOLAPServerServer

XML Data UnloadXML Data Unload

RecommendationsRecommendations

TableTableFunctionsFunctions

Key Development Focus Areas for Oracle9i Database

AvailabilityAvailability

Scalability &Scalability &PerformancePerformance

SecuritySecurity

DevelopmentDevelopmentPlatformPlatform

ManageabilityManageability

Windows 2000Windows 2000IntegrationIntegration

Internet ContentInternet ContentManagementManagement

B2C and B2BB2C and B2BeBusinesseBusiness

PackagedPackagedApplicationsApplications

BusinessBusinessIntelligenceIntelligence

Jenny TsaiJenny.Tsai@oracle.com

Thank You