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