Getting to Answers on Oracle's New Hardware - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Information Management
Commentary
10/22/2008
12:27 PM
Curt Monash
Curt Monash
Commentary
50%
50%

Getting to Answers on Oracle's New Hardware

I spent about six hours at Oracle last week - talking with Andy Mendelsohn, Ray Roccaforte, Juan Loaiza, Cetin Ozbutun, et al. I plan to write more, but for now, let me pass along a few quick comments. First, the key philosophical point that I had perhaps been missing is that Oracle thinks there is and should be a storage (server) tier...

I spent about six hours at Oracle last week - talking with Andy Mendelsohn, Ray Roccaforte, Juan Loaiza, Cetin Ozbutun, et al. - and plan to write more later. For now, let me pass along a few quick comments.

• The key philosophical point that I had perhaps been missing is that Oracle thinks there is and should be a storage (server) tier, just as there also are database (server), application (server), and web (server) tiers.

• Exadata cells are designed to never talk with each other. Instead, they talk to a set of Infiniband switches, which then talk to a grid of servers on the database tier. Oracle thinks this has solved its I/O bandwidth problem for once and for all. It's hard to see why that wouldn't be the case.

• What Exadata does on the storage tier in query execution is throw stuff away. Mainly, this is projection and restriction/SELECT. But if a join has been resolved on a small fact table, and Oracle is now filtering a fact table to match a value or set of values, the storage tier can do that too.• Backups are now done (or soon will be?) on the storage tier. I presume the same goes for restore, but I didn't ask.

• Oracle says that RAC (Real Application Clusters) no longer has much to do with locking (RAC's antecedents include Distributed Lock Manager, which is why the question arises). Generally, Oracle denies that RAC creates overhead or bottleneck problems.

• Generic UDFs (User-Defined Functions) aren't automatically parallel on Oracle, unless it's clear that they only affect single rows EDIT: or otherwise are assured to be free of side effects. However, Oracle has itself implemented and shipped long lists of parallel UDFs.

• Oracle insists that even without Exadata, it has lots of users in the 10+ terabyte range, and few over 100 terabytes. Oracle further insists that this is with the most conservative kind of counting - single database, true user data, etc. Oracle estimates that Teradata Petabyte Power Player Dell would only be at 300 terabytes by this kind of counting.

• I didn't focus on admittedly worthy questions like "Across how many cores do these parallel analytics really scale?" or "How easy is it to provision a new node in a RAC cluster if one goes down?"

• The SAS drive option has been increased from 300 to 450 gigabyte drives. Presumably, this will take our estimate of high-end Exadata list pricing down from $198K/TB of user data to $122K. Competitive vendors should show similar improvements, however, if they also use new generation drives.I spent about six hours at Oracle last week - talking with Andy Mendelsohn, Ray Roccaforte, Juan Loaiza, Cetin Ozbutun, et al. I plan to write more, but for now, let me pass along a few quick comments. First, the key philosophical point that I had perhaps been missing is that Oracle thinks there is and should be a storage (server) tier...

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Slideshows
What Digital Transformation Is (And Isn't)
Cynthia Harvey, Freelance Journalist, InformationWeek,  12/4/2019
Commentary
Watch Out for New Barriers to Faster Software Development
Lisa Morgan, Freelance Writer,  12/3/2019
Commentary
If DevOps Is So Awesome, Why Is Your Initiative Failing?
Guest Commentary, Guest Commentary,  12/2/2019
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
The Cloud Gets Ready for the 20's
This IT Trend Report explores how cloud computing is being shaped for the next phase in its maturation. It will help enterprise IT decision makers and business leaders understand some of the key trends reflected emerging cloud concepts and technologies, and in enterprise cloud usage patterns. Get it today!
Slideshows
Flash Poll