With Exadata v2 there is another offer in the portfolio of Oracle compression technology: Hybrid Columnar Compression. You have two types of compression (online and archive) and each one has a low and high compression algorithm.

So when you create a table on Exadata v2 Storage you can use one of the four combinations

To read the entire article at its source, please refer to Exadata Hybrid Columnar Compression (EHCC)

The Exadata Database Machine Version 2 was released at OpenWorld 2009 to great fanfare.  Since its unveiling, I've been getting a steady stream of questions from E-Business Suite customers who are intrigued by Exadata V2's potential.

All 11gR2 Database Applications are Compatible

The E-Business Suite and other OLTP applications will run on the Exadata V2 system if they're certified with the 11gR2 Database on Linux.

IDC's Jean Bozman and Matthew Eastwood recently published a report on Oracle Exadata V2. In it they comment on the expected performance improvements in Exadata V2:

I’ve been getting quite a few emails from folks asking why I haven’t been posting content about Sun Oracle Database Machine. One such reader asked:

"You guys must not actually have any real proof of this stuff or else you would be blogging for sure"

Last Tuesday we announced the second generation of Database Machine. This second generation of Oracle Exadata is now running on Sun hardware. The premise for Database Machine is still the same: deliver extreme performance systems on commodity hardware with ease of deployment.

BOSTON, Sept 15 (Reuters) - Oracle Corp (ORCL.O) has ended a high-profile computer-building partnership with Hewlett-Packard Co (HPQ.N) as Oracle prepares to acquire Sun Microsystems Inc (JAVA.O), a rival of HP.

BLOG UPDATE (07-SEP-2009): This blog entry is about a world-record 1TB TPC-H result publicly disclosed back in early June 2009. My blog entry was posted the day after that result went public, but for reasons I didn’t understand then, nor understand now, I was directed by Oracle Corporation to censor all mention of the published result. So I did. At the heart of the matter was the fact that the result was achieved with Oracle Database 11g Release 2 features.

Oracle Database 11g Release 2 is out, and as usual I wasn’t briefed — perhaps because Oracle is more scared than its competitors are of hard questions, perhaps for some other reason entirely.*  Anyhow, Oracle Database 11 Release 2 contains an Exadata-only feature called hybrid columnar compression.

Got a little busy there with all the comments on the Netezza posting, but now we're back into some of the outstanding topics. This post is the next one on discussing some of the ODTUG session questions (see this post).

One of the questions was about the use of partitioning and whether it is made obsolete by Exadata off-loading...

Netezza recently announced a new generation of data warehouse appliance called TwinFin. TwinFin’s clearest stated list price is “a little under $20,000 per terabyte of user data,” which in my opinion immediately became the new industry reference point for discussing prices in the data warehouse appliance category. Vigorous discussion ensued, especially in the comment thread to the first of the two posts linked above. Here’s some followup.

A colleague of mine in Oracle’s Real-World Performance Group just pointed out to me that the link (on my Papers, Webcasts, etc page) to the archived webcast of Part IV in my Oracle Exadata Storage Server Technical Deep Dive Series was stale. Actually, the problem turns out that I mistakenly set the file to expire after a fixed number of downloads. I didn’t think it would get downloaded 500 times but it seems I was wrong.

Mark Rittman is principal of the UK-based firm Rittman Mead, and a key speaker on business intelligence and data warehousing at the 2009 ODTUG conference. Oracle Senior Editor, Jeff Erickson, caught up to him at the conference and asked him to comment on Oracle Exadata.

More customers have begun to look at Exadata since the announcement last autumn and I have been teaching the Oracle Exadata Seminar this year to both an EMEA Audience and audiences in North America.

Exadata permits intelligent offloading of certain types of IO to the Cells where it is processed locally reducing the amount of traffic on the storage network and thereby reducing contention, latency and improving performance. Exadata can offload the following:

Yesterday I attended Kevin Closson's Exadata technical deep dive webcast series part 4. It is now available to download here. In there he talks about DBFS which is a filesystem on top of the Oracle database which can store normal files like text files. DBFS is provided with Exadata and is used to store staging files for the ETL/ELT process.

It is time to tune in to Kevin Closson's next deep dive into the Exadata secret sauce. He will be doing part III of his deep dive series via IOUG. Here are the details:

IOUG EXADATA SIG Webinar on May 19, 12:00PM - 1:00 PM CDT

Title: Oracle Exadata Storage Server Technical Deep Dive: Part III
Topic: The "Division of Work" - Quantifying the "Heavy Lifting" Done By the Storage Grid CPUs

Presuming you have to migrate your data to Exadata and you already did your capacity planning.

Then, probably, your next step is plan how to actually move your existing database to Exadata / HP Oracle DB-Machine (from now on called Exadata in this blog).

To read the entire article at its source, please refer to Migrating to Exadata / HP Oracle DB Machine

Several folks who read the Winter Corporation Exadata Performance Assessment have asked me what method I used to produce the throughput timeline graphs. I apologize to them for taking so long to follow this up.

The HP Oracle Exadata Storage Server is a storage product highly optimized for use with the Oracle database. Exadata is a combination of software and hardware used to store and access the Oracle database. It provides database aware storage services, such as the ability to offload database processing from the database server to storage, and provides this while being transparent to SQL processing and your database applications.

The benefits of fast, predictable data warehousing performance are clear: informed decisions can be made faster and you can respond quicker to changing market and competitive conditions. Join this webcast to hear first-hand how M-Tel, one of the largest Telcom Service Providers in Europe, plans to turn the extreme performance of the HP Oracle Exadata Storage Server into a competitive business advantage.

Oracle University is now offering a class on Oracle Exadata Storage. The class is a Live Virtual Class (LVC) allowing your resources and our resources to come together in class without traveling. After all, greener is better!

The class outline, the schedule and more details can be found here.

The HP Oracle Exadata Storage Server is a storage product highly optimized for use with the Oracle database. Exadata is a combination of software and hardware used to store and access the Oracle database. It provides database aware storage services, such as the ability to offload database processing from the database server to storage, and provides this while being transparent to SQL processing and your database applications.

Just in case you were like me and did not tune in for Oracle’s quarterly earnings concall, there were some interesting highlights. As many of you (well, there aren’t that many of you that read this, but…) know, I’ve been very interested in Exadata since its announcement at Oracle OpenWorld 2008 in October.

I’ve received a good deal of email following my recent blog entry entitled Winter Corporation Assessment of Exadata Performance: Lopsided!

Citing customer demand, Oracle has unveiled a half-size version of the HP Oracle Database Machine, its competitor to high-end data warehousing products such as that sold by Teradata.

Oracle's answer for large-scale data warehousing looks promising. But as this in-depth review reveals, production deployments and clearer insight on cost and administrative overhead are still wanting.

Intel stopped by a Tech Days event at Oracle headquarters last week to film Oracle and HP product managers discussing the HP Oracle Database Machine.