1 / 16

Oracle Database Scalability Program Briefing Summary

This document provides a summary of the Oracle Database Scalability Program briefing for the August 20 – 24, 2001 visit. It covers topics such as the Oracle Strawman Model, issues, concerns, current status, future directions, and more.

suea
Download Presentation

Oracle Database Scalability Program Briefing Summary

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DB US Visit Oracle Visit August 20 – 24 2001 [ plus related news ]

  2. Introduction • Oracle Strawman Model • Issues & Concerns • Current Status & Future Directions • AOB

  3. RAW: 1PB/yr ESD: ~100TB/yr AOD: ~10TB/yr TAG: ~100GB-1TB/yr ~1 ‘DB’ / month ~1 ‘DB’ / year ~1 ‘DB’ ~1 ‘DB’ combined with AOD LHC Datatypes & Oracle • Maybe possible to soften these to ~1 ‘DB’ for all ESD • Would there be a strong advantage? • Different ‘DB’s have different access patterns, accesscontrol, schema, … etc.

  4. Oracle Deployment DAQ cluster: current data – no history reconstruct ‘shift’ analysis export tablespaces to RAW cluster AOD/TAG 1 total? ESD cluster: 1/year? 1? to/from MSS to RCs to/from RCs

  5. Data R A W E S D A O D TAG 1TB/yr 10TB/yr 100TB/yr Tier1 1PB/yr Tier0 random seq. Users

  6. Building Blocks • ~100TB “databases” – clusters? • OCCI / OTT • Transportable tablespaces & other techniques for data import / export / exchange

  7. BT Visit – July 2001 • Oracle VLDB site: Enormous Proof of Concept test in 1999 • 80TB disk, 40TB mirrored, 37TB usable • Performed using Oracle 8i, EMC storage • “Single instance” – i.e. not cluster • Based on same techniques as identified on paper by IT-DB • Demonstrated > 2 years ago! • No concerns for building 100TB today!

  8. Size of the Largest RDBMS in Commercial Use for DSSSource: Database Scalability Program 2000 Terabytes Projected By Respondents 100 50 3 1996 2000 2005

  9. Issues & Concerns • VLDB support • Cluster issues (RAC on Linux etc.) • C++ binding / object model definition • Storage issues

  10. VLDB Support • RAW DB model revised to active partitions as part of DB (catalog) + offline partitions (not part of DB) + “historical data” (maybe in separate DB?) • Such a strategy is used by many Data Warehouse sites in production today • Does not require any special features • But Oracle like suggestion of extending “resumable statements” to provide “automatic but controlled” access to offline data

  11. VLDB support cont. • Oracle addressing limits of current architecture • Already permits 2EB databases • Limits on e.g. # files, partitions etc are expected to be significantly increased beyond Oracle 9i • An area of work, but not concern…

  12. Cluster Issues • Real Application Clusters = RAC = significant advance over previous OPS • Should be good fit for HEP read-mostly data • Supported on Linux by COMPAQ, FastTango • Not critical to overall model, but could simplify deployment significantly • e.g. small number of clusters: 1 / data type • COMPAQ Oracle competency centre in Valbonne…

  13. OCCI / OTT • On-going work with Oracle developers to fix bugs / provide enhancements to meet HEP requirements • Fixes prior to start of ß, during ß & post ß … • Currently using HEP data models • More examples welcome… • Enhancements via pre-releases, dot releases and 9i R2

  14. Storage Issues • Oracle number format provides greater precision than IEEE double • Solutions being investigated to allow efficient storage of floats / doubles / ints without user specifying precision / range • Target: next major Oracle release?

  15. Side Visits • FNAL • Objectivity • IBM • COMPAQ • FastTango / NetAppliance

  16. Summary • Oracle demonstrably interested in continuing to work with HEP on VLDB / LHC issues, both regarding 9i and also future Oracle versions • Strong support from Oracle server group • Strong interest from Oracle Grid team

More Related