Overlooking Problems with Oracle's Exadata - InformationWeek
IoT
IoT
Software // Information Management
Commentary
12/15/2009
09:26 AM
Neil Raden
Neil Raden
Commentary
50%
50%
RELATED EVENTS
Faster, More Effective Response With Threat Intelligence & Orchestration Playboo
Aug 31, 2017
Finding ways to increase speed, accuracy, and efficiency when responding to threats should be the ...Read More>>

Overlooking Problems with Oracle's Exadata

The premise that Oracle Exadata V2 is going to siphon off all of the existing implementations on older SMP platforms to the new Exadata platform fails for two reasons...

I can't quite figure out where IDC's review of Exadata V2 ends and Stephen Swoyer's opinion begins, but in the latter's article "Why Oracle's Exadata May Attract CXO's," some questionable suggestions are offered. At one point, Swoyer writes, "many of the largest data warehousing or OLTP systems in the world continue to run on Oracle," and adds further that, "many of the biggest combined DW and OLTP configurations also run on Oracle." While this may be true, the key word here is "run." I know of no "combined" OLTP and data warehouse instances that actually perform. There are a myriad of reasons for this, such as:

- Workload management is dramatically different. OLTP is small transactions, many of them write; data warehouse is bulk load and very large (comparatively) queries. Activity is much less predictable and rather clumpy compared to OLTP - The physical layout of the tables for performance reasons is different - There is usually a need for aggregation in data warehouses - There are different optimization strategies for OLTP and BI What is a combined OLTP and data warehouse, anyway? An OLTP system typically serves an operational purpose, but a data warehouse combines data from many systems. Does a combined system merely provide analytical access to the data of one OLTP system? That doesn't sound like a very good idea. I hope I live long enough to see the dream of combined databases actually realized -- data entered and stored at its logical location and used and reused for any valid purpose without replication. It would be fantastic, but it's sort of unrealistic. Data warehouses of yore served as big bags of data, with lots of downstream data marts, cubes and other structures that served to satisfy the need the data warehouse was meant to serve. In other words, many of these "large" Oracle data warehouses are simply holding pens. But no one sees data warehousing this way anymore. Whether you have 100 GB or 100 TB, that database has to provide deep analytics on its own. Large Oracle databases aren't doing that. Competitors are. Therefore the premise that Exadata V2 is going to siphon off all of the existing implementations on older SMP platforms to the new Exadata platform fails for two reasons. First, if your existing database vendor can't cut it, you are not likely to cast your fate with their newest promise. Second, Oracle has absolutely zero credibility in massively parallel platforms. Does anyone remember Oracle PQO for the SP2? That was the last time Oracle was going to win over the data warehousing market with a highly scalable platform. It didn't work. And RAC is a terrible choice for data warehousing. Exadata will have to prove its ability to handle BIG DATA warehouses, and the Oracle database will have to have the functionality for analytics that its competitors already exhibit.The premise that Oracle Exadata V2 is going to siphon off all of the existing implementations on older SMP platforms to the new Exadata platform fails for two reasons...

Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
IT Strategies to Conquer the Cloud
Chances are your organization is adopting cloud computing in one way or another -- or in multiple ways. Understanding the skills you need and how cloud affects IT operations and networking will help you adapt.
Video
Slideshows
Twitter Feed
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll