Oracle, in partnership with HP, has announced a new data warehouse appliance product line, cleverly branded "Exadata."... Numbers are being thrown around suggesting that, unlike prior Oracle offerings, the Exadata-based appliance at least has scalability and price/performance worth comparing to Teradata - hey, Exa is bigger than Tera! - Netezza, et al.
Oracle, in partnership with HP, has announced a new data warehouse appliance product line, cleverly branded "Exadata." The basic idea seems to be that database processing is split among two sets of servers:
• (The new stuff) A set of back-end servers - the Oracle Exadata Storage Servers - that gets data off of disk and does some preliminary query processing.
• (The old stuff) A conventional Oracle RAC cluster on the front-end.
Numbers are being thrown around suggesting that, unlike prior Oracle offerings, the Exadata-based appliance at least has scalability and price/performance worth comparing to Teradata - hey, Exa is bigger than Tera! - Netezza, et al.Kevin Closson, who evidently worked on the project, offers the most useful and detailed description of Exadata I've seen so far. In particular, he and Oracle seem to claim:
• I/O will no longer be a bottleneck, due to direct-attached storage (DAS), Infiniband, and so on. (That sounds plausible.)
• Files will be optimized simultaneously for sequential table scans and conventional block-based random I/O. (Huh?)
If for the sake of argument we grant the claims so far, it's still not clear to me whether Oracle's approach is fully competitive with Teradata, Netezza, et al. Whatever query processing isn't already done at the Exadata Storage end has to be done in Oracle RAC. But what exactly does RAC bring to query parallelization? Well, it should help with concurrency. Whatever performance Oracle can get with a small number of users shouldn't degrade too badly as the user load grows. The Exadata-based appliance will probably prove to have much better concurrency than startup vendors' Release 1s typically have.
That's the good-news side of my guessing. The other traditional Release 1 bottleneck is that too much data is shipped to the "fat head," and query processing isn't really parallelized in more than a simple-minded way. So far, I've seen nothing to suggest that Oracle isn't as subject to that problem as any other vendor.
As for Oracle's sophisticated query accelerations such as sophisticated materialized views and so on - I think users increasingly want all queries to run quickly, rather than just the ones that were previously planned for. So I'm not sure how much of an advantage those will prove to be.
And of course Oracle's management tools are robust and its prices high. Those are both givens.
The Agile ArchiveWhen it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
2014 Analytics, BI, and Information Management SurveyITís tried for years to simplify data analytics and business intelligence efforts. Have visual analysis tools and Hadoop and NoSQL databases helped? Respondents to our 2014 InformationWeek Analytics, Business Intelligence, and Information Management Survey have a mixed outlook.
Join us for a roundup of the top stories on InformationWeek.com for the week of December 14, 2014. Be here for the show and for the incredible Friday Afternoon Conversation that runs beside the program.