We interrupt your regularly scheduled blog --
Larry Ellison has just announced a new Database In-Memory Option which can make queries 100 times faster, but better than that is the faster transaction rates such as 3 to 4 times faster row insertion. How is this being done? Oracle 12c stores data in rows and columns simultaneously with this new option so the columns (introduction of "Columnar technology") are being kept "in-memory" and transactional integrity is kept due to the fact that there are no transactions being saved back on the columns, just the rows. Cores will be able to scan billions of rows a second per vector instruction, and report results will be returned sub-second because the current OLTP architecture is being slowed down by analytic indexes which the column views will actually take advantage of.
This option makes the database easier to tune, run faster, just as secure as today but once the switch is flipped you get better performance even though nothing structurally changes when you flip the switch. A live demo of a 3 billion row table (courtesy of Wikipedia data) showed how it was more than 1000 times faster when the In-Memory Option is turned on! This allows companies to Scale-Out and Scale-Up with different types of hardware. Speaking of hardware, Larry introduced several new components:
M6-32 Big Memory Machine - This has 32 Terabytes of DRAM memory, 32 SPARC M6 chips (twice as many cores as the M5), and as he casually mentioned is available right now. Today. Go buy one! Then he elaborated on the Interconnect it uses to process 3 TeraBYTES, not TeraBITS, per second and on top of everything else the machine costs $3M which is less than a third of the cost of IBMs biggest machine. He noted that their IBM partners in the room weren't clapping. Awesome.
M6-32 SuperCluster - Just like it's brother the Big Memory Machine, it is the fastest database machine out there but the plus for this is that it connects to Exadata as integrated storage to speed things up by a factor of 10 via the Infiniband I/O Interconnect.
Oracle Database Backup, Logging, Recovery Appliance - Quite a mouthful, but Larry says he named it so I guess that's that. This doesn't act like a file backup utility that loses data, slows down the business, and isn't scalable; instead this platform which is "like a Exadata machine" ships all of the logs so it results in the ability to restore as of any point in time. Going a step further, this can all be delivered as a Cloud Service!
He closed with a snippet of what is the "Datacenter of the Future", which I think is a sneak-peak of things to come, where he details out a data center that has specialized servers for the core, backup, analytic and database functions to increase what customers can get out of their data centers.
-- We now return you to your regularly scheduled blog.
No comments:
Post a Comment