Home Business IT Technology Ellison's Open World triple play
Ellison's Open World triple play Featured
Get all your tech news delivered to your mail box five days a week
iTWire UPDATE - it's FREE!

Oracle CEO Larry Ellison used his keynote address at Oracle Open World 2013 to make three major announcements, most notably a new option for Oracle Database 12c that provides massive performance improvements for analytics and reporting,

The new in-memory option for Oracle Database 12c allows queries to be processed 100 times faster - or even more - while also delivering a useful doubling of transaction processing speed.

This is achieved through a combination of keeping data in memory and maintaining two separate structures: one organised by rows for speedy transaction processing, the other arranged by columns for fast query processing.

Both are simultaneously active and transactionally consistent.

Since the columnar data is only used for queries, there is no need for logging and so "there's very little overhead," Ellison said.

Each CPU core scans the columns in its local memory using vector instructions and so billions of rows can be processed per second.. "It's at least times faster," he said, and even complex queries are accelerated as tables can be joined around ten times faster.

The new option means "you're getting results at the speed of thought," he said.

The reason transaction processing operations are accelerated is that there is no longer any need to maintain indexes that exist only to improve query performance. Where perhaps ten or 20 analytical indexes would have to be updated every time a new row was inserted, now it is just the few actually required to make the database work.



Avoid War Room Scenarios and improve handling of critical application problems:

• Track all transactions, end-to-end, all the time and know what your users experience 24/7

• View code level details with context and repair problems quickly

• Fix problems in minutes before they wreak havoc

• Optimize your most important applications, Java, .NET, PHP, C/C++ and many more

Start your free trial today!



Where are your clients backing up to right now?

Is your DR strategy as advanced as the rest of your service portfolio?

What areas of your business could be improved if you outsourced your backups to a trusted source?

Read the industry whitepaper and discover where to turn to for managed backup


Stephen Withers

joomla visitors

Stephen Withers is one of Australia¹s most experienced IT journalists, having begun his career in the days of 8-bit 'microcomputers'. He covers the gamut from gadgets to enterprise systems. In previous lives he has been an academic, a systems programmer, an IT support manager, and an online services manager. Stephen holds an honours degree in Management Sciences, a PhD in Industrial and Business Studies, and is a senior member of the Australian Computer Society.