Oracle Promises 100x Faster DB Queries With New In-Memory Option

Hugh Pickens DOT Com writes "ZDNet reports that Oracle's Larry Elison kicked off Oracle OpenWorld 2013 promising a 100x speed-up querying OTLP database or data warehouse batches by means of a 'dual format' for both row and column in-memory formats for the same data and table. Using Oracle's 'dual-format in-memory database' option, every transaction is recorded in row format simultaneously with writing the same data into a columnar database. 'This is pure in-memory columnar technology,' said Ellison, explaining that means no logging and very little overhead on data changes while the CPU core scans local in-memory columns. Ellison followed up with the introduction of Oracle's new M6-32 'Big Memory Machine,' touted to be the fastest in-memory machine in the world, hosting 32 terabytes of DRAM memory and up to 384 processor cores with 8-threads per core."

Oracle gains speed

[rossdee]

Especially upwind, but not 100x

still Emirates Team NZ only need to win one more race..to take back the Americas cup

Great news for NSA

[Anonymous Coward]

With increasing surveillance on American citizens such database will provide security forces with instant profile of each person. Let's combine that with license plate scanning, cell phone tracking, sexual preferences and health records.

Now we can sleep well at night, our children are safe.

One Big Memory Machination

[VortexCortex]

"Big Memory Machine"... So, they finally built Deepthought?

In-memory IO is grand, when that's your're bottleneck. Mine tends to be in the network level, so I use a local daemon for query result caching at the application level as "in-memory" speedup. The speedups are nice, but pricey. Color me unimpressed -- that's pink, BTW; I'm a Caucasoid your colors may vary, but only up to VARCHAR(20);

Uhg. Is "in memory" now just another buz-word? I guess we've come full circle back to Mainframe? Big memory banks are faster and better for a while, but then the bandwidth goes up and the price, reliability and scalability will favor distributed systems (as currently). I wonder which phase of the cycle quantum computing will favor: distributed / localized? You have to take into consideration your user distribution too...

So, eventually you'll want a hybrid system where the memory is distributed and cloned at each query-able interface, but still maintaining the entire dataset "in memory"...
SELECT * FROM earth WHERE answer LIKE "everything";
...
42 rows returned

Re:One Big Memory Machination

[Anonymous Coward]

If you used ECC memory, the answer wouldn't have been 42.

Re:Beowulf

[Anonymous Coward]

But does it run on Solaris?

Sadly, no. In fact it won't even function as a Minecraft server without some patches and a Java update. I hear that Oracle is still waiting on the vendor for Java update.

Re:Oracle gains speed

[ae1294]

At first glance, one would think "Oracle" is a company devoted to catering high end golf outings and boat racing.

They make software, right?

Only as a means of raising the money for high end golf outings and boat racing.

With blackjack and hookers....

Re:Oracle gains speed

[ooshna]

In fact forget the boat racing and the blackjack.

Re:One Big Memory Machination

[doomsayerxero]

That should be Varchar2(20).