Augment or Replace and what product to use?
By Jean-Pierre Dijcks on Feb 26, 2009
There is a lot said and discussed on the HP Oracle Database Machine offering from Oracle. But , at a high level, I think it is important to understand the two offerings Oracle introduced. These offerings allow various solutions for various scenarios, all delivering extreme performance to an Oracle data warehouse.
The following picture shows the products in the Oracle Exadata family and how they typically would be implemented.
This diagram shows on the one hand the HP Oracle Exadata Storage Servers which can be easily used to augment a current Oracle data warehouse. As the exadata technology is transparent to the system, a current database (provided it is 188.8.131.52) will get the benefits from the new storage architecture. No changes to the actual database application are needed, so this strategy poses an easy and virtually risk free move onto a new extreme performance storage architecture.
If you are looking for a completely new system or for a replacement of an existing data warehouse application (Oracle or non-Oracle), the HP Oracle database machine allows you to put a fully balanced, extreme performance solution in place almost immediately.
The HP Oracle Database Machine gives you the benefits of an appliance in that it all comes out of the box from a single vendor - Oracle. But rather than have a database system that is non-standard for your data center, you get the Oracle database. With that you have the entire Oracle package available. This means you have in-database ETL, in-database analytics such as data mining, advanced security and it is all pre-configured and pre-installed on the Exadata hardware architecture.
Now, if you want to see some more on the technical abilities of the solutions, you should review some demonstrations here. Look for the expanded Exadata Series node. These are short, recorded technical demonstrations.
If you are new to the solution, I would recommend to start reading some of these whitepapers:
- Technical whitepaper on HP Oracle Exadata Storage Servers
- A whitepaper on migrating from legacy storage to Exadata storage
- HP Oracle Database Machine overview (what is in the box)
This post is intended to be the first in a whole series on the HP Oracle Database Machine. A lot of good stuff on Exadata storage and dw in general is written by Kevin Closson. Have a read through his blog here.
So stay tuned for more on the HP Oracle Database Machine and of course on data warehousing in general.