HP Oracle Database Machine

[RolandBeck]

And there is a new one ...

The HP Oracle Database Machine
Runs Oracle Data Warehouses 10x Faster

The HP Oracle Database Machine was anounced by Larry Ellison in his Keynote speech at Oracle OpenWorld 2008.

The HP Oracle Database Machine is a complete system, including software, servers, and storage, designed to run large, multi-terabyte data warehouses 10x faster than conventional data warehouse systems. At the heart of the Database Machine, is the HP Oracle Exadata Storage Server, which has smart storage software that offloads data-intensive query processing from Oracle Database 11g Servers and does the query processing closer to the data. The Database Machine runs Oracle Database 11g and Real Application Clusters, Oracle Enterprise Linux, and includes all the required Infiniband infrastructure and related hardware. Simple and fast to implement, the HP Oracle Database Machine has the power to tackle large-scale business intelligence problems immediately and can scale linearly as your data warehouse grows.

more details here

[JohnG]

Hi Roland,

Thanks for the info on the HP Oracle Database Machine. I hadn't seen this. I just jumped online and you can even see it on youtube. I guess that it must be a real product if it's on youtube!

I did read about a company in the US (LGR Telecommunications) that has been working with a Database Machine for "more than a year, while the kinks were still being ironed out". Here's a snippet from the article:

"Chief architect Hannes van Rooyen says it's an ideal design for taking on massive data loads with rapid cycle times.

Van Rooyen concedes LGR, a supplier of custom telecom data warehouses, hasn't pushed an HP Oracle Database Machine out to one of its telecommunications customers yet. But its simulated production loads on the machine and found it handles them."

So it's not quite as 'real' as everyone thinks?

[zamir]

Thanks for the link to the article on this.

... but I think that whole article is very interesting. Also about telco warehouses.

Here's the whole article:

LGR Test Drives HP Oracle Database Machine

Posted by Charles Babcoc k, Sep 25, 2008 04:43 PM

Oracle (NSDQ: ORCL) CEO Larry Ellison announced a high-end, high-performance HP (NYSE: HPQ) Oracle Database Machine in San Francisco yesterday. LGR Telecommunications has been working with such a Database Machine for more than a year, while the kinks were still being ironed out. Chief architect Hannes van Rooyen says it's an ideal design for taking on massive data loads with rapid cycle times.

Van Rooyen concedes LGR, a supplier of custom telecom data warehouses, hasn't pushed an HP Oracle Database Machine out to one of its telecommunications customers yet. But its simulated production loads on the machine and found it handles them. To LGR, a production data warehouse should be built on the scale of the one it supplied to the largest U.S. telecommunications company -- you should be able to figure out who that is, but LGR isn't allowed to name it. It uses two 310-TB data warehouses, and needs to cycle lots of data back and forth between them. That's what the Database Machine is designed to do.

LGR won't be spending more time on beta tests. Now that the machines have become available, it plans to install one at two customer sites in the next few months, including that large customer in the U.S. Deploying a Database Machine, said van Rooyen, 28, is a lot faster than deploying additional servers and SAN arrays as your data warehouse grows. LGR ought to know. It's built a lot of standard data warehouses on high-end hardware, such as the HP Superdome, throwing disk arrays at the arrangement. "You have to run the host bus adapters (on the database servers) to the SAN array, reconfigure and rebalance the load," he says. It's a lot of skilled labor.

In one case, "we cycle 260 terabytes of data through the data warehouse every 90 days. There's a lot of velocity to our data," van Rooyen said in an interview at the Moscone Center as Oracle OpenWorld wound down. Telecom companies are trying to capture who's using what services where, what combinations of services, how frequently, and where the profit lies in combining services. To do so they need to deal with billions of small records after capturing and loading them into the data warehouse.

Van Rooyen said LGR is planning systems that can handle up to two petabytes of data. Parallel processing is a key to query performance against such large amounts of data, and the Oracle system does a good job of breaking queries down into parallel parts. "We push the core functionality of Oracle" to make use of its query optimization and use of Real Application Clusters, or a clustered version of one database on multiple servers.

Beyond that, LGR brings its expertise to bear to exploit the capacities of multicore chips. Big databases and complex queries are a problem for which multicore processors are the answer. Because both SQL queries and databases can be broken down into discrete parts, they lend themselves to parallel processing techniques better than many business applications, with their serial logic.

IBM (NYSE: IBM), Netezza (NYSE Arca: NZ), Teradata (NYSE: TDC), and others all have their uses of parallelism in their high-end data warehouse designs. But as van Rooyen points out, using it on standard hardware -- the database machine, in effect, is a small grid of HP Proliant servers, means LGR can produce telecom data warehouses, with their voracious appetite for CPU resources, at a much lower cost than in the past. The Oracle machine retails for $4,000 a terabyte, he noted.

Van Rooyen says HP may sell fewer Superdomes now that the database machine is available, but it may sell more database machines.

"Now when we need more storage, we plug in more Exadata Storage Servers. If we need CPU, who knows, Intel (NSDQ: INTC) is going to six-core processors. Maybe we'll slide one blade out and another blade in," he said.

In one of LGR's installations, the data warehouse routinely consumes 99% of the CPU power available, and six-core CPUs will be welcome when they reach the site on new HP blades.

The "$4,000 a terabyte" statement is pretty interesting.

Plus I hope everyone notices how fast I responded to this thread. Do I get a prize??

Hello

has smart storage software that offloads data-intensive query processing from Oracle Database 11g Servers and does the query processing closer to the data. The Database Machine runs Oracle Database 11g and Real Application Clusters, Oracle Enterprise Linux, and includes all the required Infiniband infrastructure and related hardware. wish it all Possible in vintage phones

Thanks