Large database in today’s market have reached up to 200TB. Large databases are tripling every two years. Disk storage that exist today cannot cope with the data bandwidth. Storage subsystem can house the data but run into the data bandwidth problems. At about 1TB is where the problem raises it’s ugly head and the problem gets worse and worse.
Oracle is annoucing their first ever hardware product – The HP Oracle Exadata Programmable Storage Server with 2 Intel Processors with 4 cores each (8 cores) and allows oracle to build intelligence for the disk subsystem. In two months, it will be 2 processes with 6 cores each (12 cores). The Storage Server runs Parallel Query Server and reduces data going through the pipes. Instead of packets being served (all the disk blocks), the actual query results are passed to the database servers. Exadata Storage Servers are query processing servers. The Exadata Storage Servers can be a grid of storage servers.
Brawnier Hardware are two infiband pipes per storage server to allow transfer of 1 Gigabyte per second. Each Exabyte is 20 gigabits thus providing wider pipes and more of them.
The HP Oracle Exadata Storage Server Grid is available immediately for Linux Servers.
Larry also announced the HP Oracle Databas Machine !!!! It doesn’t make sense to just provide just the storage.
The world’s fastest database machine.
64 cores for DB
112 cores for exadata
168 TB of disk data
14GB/sec data bandwidth
Using the proliant technology
Customer testing program began on Oct 2007. This has been a three year development programme. 10-72 times speed up reported by an European telecommunication system (M-Tel). From 2 IBM p570’s on EMC CX3-40 storage reported 28 X average performance with just half of the exabyte.
LGR outsources DW. 30 minute query
HP Superdome on Hitachie XP24000
10-15 times CME Group
Giant Eagle Exadata speedup:13 IBM 570 CPU on EMC clarion and DMX Storage Array (16 times average performance increases)
NetApp Storage for Oracle Primary Financial DW – 10.7 queries/Hour to 337 queries/Hour on TPCH query set (30X speed up)
Problem: move disk blocks to the database servers. The arrays typically have low bandwidth.
Oracle DB Machine
1000GB/Hour
20GB/Sec with Infiniband
Open Standard
Fault tolerant
Disk Failure
100 X 1TB disks
368GB of RAM
System Price: 650k
Price per TB: 4K
Software license: 1,680,000
Designed to speed up OLTP as well as DW – 10-50 X faster