Oracle OpenWorld 2000 Trip Report Jamie Shiers, IT-DB
Download
Report
Transcript Oracle OpenWorld 2000 Trip Report Jamie Shiers, IT-DB
Oracle OpenWorld 2000
Moscone Center, San Francisco, October 2-6
Trip Report
Jamie Shiers, IT-DB
http://cern.ch/db/
CERN-IT-DB
Introduction
Motivation for attending
Highlights
Plenary Sessions
Parallel Sessions
Campground
Oracle VLDB discussions
Conclusions wrt OpenWorld
CERN-IT-DB
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, …
CERN-IT-DB
Highlights
Oracle 9i announcement
Larry’s keynote
VLDB discussions
CERN-IT-DB
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
CERN-IT-DB
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/
CERN-IT-DB
$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.
CERN-IT-DB
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
CERN-IT-DB
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
CERN-IT-DB
Managing Enterprise-wide
Databases using Enterprise
Manager 2.1
Create and display status of jobs and events
Debu
Panda
Create and manage administrators
Sr. Systems Engg. Specialist
Create and manage groups
Oracle Support Services
Create and display status of jobs and events
Oracle Corporation
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.
CERN-IT-DB
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
CERN-IT-DB
Real Application Cluster (OPS)
CERN-IT-DB
CERN-IT-DB
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++
CERN-IT-DB
OCCI (C++ binding)
C++ version of Oracle Call Interface
Offers both “SQL” access to data…
– stmt->executeUpdate(“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
CERN-IT-DB
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
CERN-IT-DB
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/july2000/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
CERN-IT-DB
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
CERN-IT-DB
Conclusions
ORACLE
OPEN
WORLD
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
CERN-IT-DB