Oracle OpenWorld 2000 Moscone Center, San Francisco, October 26 - PowerPoint PPT Presentation

Loading...

PPT – Oracle OpenWorld 2000 Moscone Center, San Francisco, October 26 PowerPoint presentation | free to download - id: 1433a5-MGIxN



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Oracle OpenWorld 2000 Moscone Center, San Francisco, October 26

Description:

Conclusions wrt OpenWorld. CERN-IT-DB. Motivation ... OpenWorld clearly the main Oracle event. Direct access to developers in Campground ... – PowerPoint PPT presentation

Number of Views:74
Avg rating:3.0/5.0
Slides: 22
Provided by: anal127
Learn more at: http://edms-service.web.cern.ch
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Oracle OpenWorld 2000 Moscone Center, San Francisco, October 26


1
Oracle OpenWorld 2000Moscone Center, San
Francisco, October 2-6
  • Trip Report
  • Jamie Shiers, IT-DB
  • http//cern.ch/db/

2
Introduction
  • Motivation for attending
  • Highlights
  • Plenary Sessions
  • Parallel Sessions
  • Campground
  • Oracle VLDB discussions
  • Conclusions wrt OpenWorld

3
Motivation
  • Main purpose was to learn about enhanced support
    for Objects and VLDB environments
  • On-going discussions with Oracle experts on
    potential use of Oracle for handling LHC physics
    data
  • No Java, XML, e-business,

4
Highlights
  • Oracle 9i announcement
  • Larrys keynote
  • VLDB discussions

5
Plenary Sessions
  • Gary Bloom, Oracle Welcome Address 
  • Duane Zitzner, HP Beyond Infrastructure 
  • Chuck Rozwat, Oracle The Secret of the Software
    Grid 
  • Mark Jarvis, Oracle The Power of Anywhere 
  • Craig Barrett, Intel The Solution Revolution 
  • Lawrence J. Ellison, Oracle Software Powers the
    Internet 
  • Jeremy Burton, Oracle B2B - 2 - B 
  • Mark Jarvis, Oracle Survivor Meets Millionaire 
  • Mike Ruettgers, EMC The New ROI for the New
    Economy 
  • Sohaib Abbasi, Oracle Portals The New E-Business
    Desktop 
  • Ken Jacobs, Oracle The Six Million Dollar DBA 
  • Scott McNealy, Sun The Next Generation Net
    Always On. Always With You. 
  • Ron Wohl, Mark Barrenechea, Oracle The Oracle
    E-Business Suite 
  • Jeremiah Wilton Amazon A Successful
    Implementation of e-Commerce Technology 

6
Oracle 9i announcement
  • Real Application Clusters (Oracle Parallel
    Server)
  • DejaView historical query
  • Performance improvements for Web sites
  • 3 times or 1M
  • Changes to product bundling
  • Reduce from 80 products to Database
    Application Server
  • Virtual Private Databases
  • See
  • http//technet.oracle.com/products/oracle9i/
  • http//technet.oracle.com/

7
6M DBA
  • Ken Jacobs, a DBA barely alive. Beaten into
    submission by tedious backups and arcane
    tablespace extensions. Gentleman, we can rebuild
    him. We have the technology to build the world's
    first internet-DBA. Better than he was before,
    better, stronger, faster. Ken Jacobs will be that
    DBA, Ken Jacobs will be the Six Million Dollar
    DBA.

8
Parallel Sessions
  • Many sessions on partitions, Oracle Enterprise
    Manager, DBA studio, Oracle Internet Directory,
    Oracle Parallel Server
  • Latest advances in Object-Relational features
  • OCCI C interface to Oracle
  • Internals of data storage
  • Replication
  • Oracle 9i Beta programme
  • Up to 4 concurrent interesting sessions

9
Partitions
  • Technique for splitting very large tables /
    indexes into more manageable units
  • Partition by range, list, hash, composite
  • Unnecessary partitions pruned from query by
    optimiser
  • 64K partitions per table
  • Each partition can be stored in separate
    tablespace
  • In turn mapped to multiple files / filesystems
  • Tablespaces can be put offline and exported
  • Tablespaces of 10 x 10GB files gives 100PB
    total
  • Investigating partitions / (transportable)
    tablespaces for
  • Scalability
  • Export to regional centres
  • Mass Storage Interface

10
  • Create and display status of jobs and events
  • Create and manage administrators
  • Create and manage groups
  • Create and display status of jobs and events

11
OEM components DBA Studio
  • Central tool for routine DB Admin
  • DBA Studio combines multiple database tools in
    one app for managing
  • Instances, including startup,shutdown, and
    changing initialization parameters
  • Schemas, including tables, indexes, and oracle8
    objects.
  • Security, including user accounts, roles, and
    privileges.
  • Storage, including tablespaces, datafiles, and
    rollback segments.

12
OEM Features
  • DB Grouping
  • Job scheduling
  • Notification of events
  • Routine tasks
  • Schema manager - create, manage schema objects
    e.g. tables, views, indexes, etc.
  • Security Manager - create, edit users, roles and
    manage system and object privileges
  • Instance Manager - startup, shutdown database and
    manage initialization parameters
  • Storage Manager - manage database storage i.e.
    tablespaces, rollback segments, redo logs, etc.
  • http//technet.oracle.com/products/oem

13
Real Application Cluster (OPS)
14
(No Transcript)
15
ORDBMS Advances
  • Support Object Types and Object References
  • Support single inheritance (SQL-99)
  • Can store subtypes in supertype container
  • Subtypes can override methods of supertype
  • Type evolution (schema evolution)
  • (Nested) collections
  • Extensible indexing, user defined aggregates
  • Object Types Translator to map to C

16
OCCI (C binding)
  • C version of Oracle Call Interface
  • Offers both SQL access to data
  • stmt-gtexecuteUpdate(CREATE TABLE basket (fruit
    VARCHAR2(30), quantity NUMBER))
  • As well as ODMG-like navigational access
    (modelled after JDBC)
  • Have access to pre-release of Functional
    Specification
  • Access to code as part of Oracle 9i beta

17
Campground
  • Fairground might be a better name
  • Your chance to get free squidgy gismos
  • bags provided
  • Or discuss with key Oracle developers
  • Proximity to Oracle HQ meant that many more
    developers present than otherwise
  • Essentially entire OCCI / Object teams
  • Dramatically different to other conferences
  • Similar value to conference sessions

18
VLDB Discussions
  • 2nd in a series of meetings with Oracle experts
    on potential use for handling LHC physics data
  • Led by Ken Jacobs, VP product strategy
  • Also performance, data storage, availability
    recovery, access methods, replication
    distributed DB, objects extensibility, OCI
    C development, parallel server groups
  • Have developed a model for using Oracle
  • See http//wwwinfo.cern.ch/asd/rd45/workshops/july
    2000/agenda.htm
  • Have identified key Oracle technologies
  • partitions, parallel server, enterprise manager,
    OID, DBA studio, OCCI etc
  • Testing started for RAW and TAG data
  • Other data types (ESD, AOD) require Oracle 9i
    beta (OCCI)
  • Presentation devoted to this issue will be
    prepared

19
VLDB Status
  • Information from conference confirms choice of
    technologies
  • Results from RAW TAG data storage and
    performance promising
  • Query performance significantly enhanced using
    indexes
  • Potential problems
  • Storage overhead for floating point numbers
  • Floats and Ints currently stored as Oracle
    number
  • Discussing native support for floats in
    particular
  • Mass storage interface
  • Solution using offline partitions being tested
  • (lack of) machine independent transportable
    tablespaces
  • Work-around using Export/Import
  • Possibility of a tool to convert tablespaces

20
Conclusions
  • OpenWorld clearly the main Oracle event
  • Direct access to developers in Campground
  • Excellent technical presentations on new features
  • Comprehensive training programme
  • Few user papers
  • Too many people
  • Will be held in San Francisco for next 10 years
  • 2001 Dec 2 6
  • 2002 Nov 17 21
  • 2003 Sep 7 11
  • Mark these dates in your Palm Pilot or
    Blackberry now

21
(No Transcript)
About PowerShow.com