Oracle9i DBMS and Application Server Services

1
Oracle9i DBMS and Application Server Services

• Bernt Castman KTH
• nov 2001

2
(No Transcript)
3
Oracle 9i released june 2001

• Standard Edition
• Enterprise Edition
• Personal Edition
• http//www.oracle.com/ip/deploy/database/oracle9i/
  index.html?packagingandoptions.html

4
Availability

• Stand-by database, failover
• primary-to-secondary switch
• log apply delay
• Full online reorganization and redefinition
• changing table and column attributes
• Block oriented table recovery
• rest of table online
• LogMiner
• Query history and undo on an SQL level

5
Back Up

• Administrator correct USER ERRORS
• Use Log Miner
• Generate redo statements
• delete records
• drop table
• Automatic recovery from almost any non-media
  related database failure after a restart

6
Scalability and performance

• Increased transaction throughput
• Reduced footprint per user
• Automatic resource management
• Performance enhancements
• Prefetching
• self tuning direct I/O
• Virtual interface support

7
Security

• Strong three tier security
• X.509 certificates
• Integration with LDAP
• Standard-based Public Key Infrastructure
• Fine-grained auditing
• Improved user and security policy management
• Data encryption and Label security

8
Development Platform

• Enterprise Java Engine (JServer)
• XML type and XDK
• SQL enhancements
• CASE support
• ANSI compliant joins
• scrolling cursor
• PL/SQL support full SQL-syntax

9
Manageability

• DBMS manages the rollback segments in undo
  tabelspaces
• Dynamic memory management
• Oracle Managed files
• Resumeable statements
• Multiple block size in one database
• Recovery Manager support of automatic backups
• Web based admin. tools

10
More

• Integration with Windows 2000
• Active Directory, PKI, OLE DB provider
• Business Intelligence
• OLAP server, calculation engine, Data Mining
• eBusiness enhancements
• Globalization
• timezone aware datatypes
• Internet Content Management
• files, multimedia, e-mail

11
Integration Functionality

• Core database Engine
• OLAP Services
• Java OLAP API
• Calculation engine
• Analytic Workspace
• Multi Table Insert, SQL additions
• Warehouse Builder
• Workflow Builder
• XML Datatype

12
Oracles Strategy

• Deliver a full software landscape
• Offer customers a complete and tighty integrated
  package of software
• everything a company needs to manage its
  financials, manufacturing, sales force,
  logistics, e-commerce and suppliers
• Delivered by Oracle

13
Oracle9i Application Server

• provides the tools and infrastructure to start
  your e-business and support its growth.
• is part of the Oracle Internet Suite
• Oracle8i
  manage
• Oracle Internet Developer Suite build
• Oracle9i Application Server run
• Oracle HTTP Server powered by Apache

14
(No Transcript)
15
(No Transcript)
16
Oracle AS Three versions

• Standard Edition
• lightweight Web server with minimal application
  support
• Enterprise Edition
• medium-sized to large-sized Web site that handles
  a high volume of transactions.
• Wireless Edition
• Oracle Portal-to-Go if you need to deliver
  content to mobile devices

17
Oracle9i Application Server Documentation
Release 1 (v1.0.2.2.1) for Windows NT/2000

• Gateway for Microsoft SQL Server
• Gateway for Sybase DB
• Internet Directory
• Oracle9iAS Email
• InterConnect
• Workflow

18
Oracle AS and JAVA

• This release of OracleJSP supports the JSP 1.1
  specification, including the tag extension
  mechanism for custom tags. OracleJSP translates
  and executes JSP pages in the release 8.1.7
  database using the embedded Oracle Servlet Engine
  (OSE)
• environments JDK 1.1.8 and 1.2.2
• Servlet Engine in Oracle 8.1.7 database.
  Apache Web server with JServ servlet engine
  OracleJSP also works with the Tomcat server