Wednesday, 09 March 2016 00:02

Oracle opens up M7's DAX 'SQL in Silicon' capability


Third-party developers can now exploit the performance of the SQL coprocessors built into Oracle's Sparc M7 chip.

When Oracle announced its first Sparc M7 servers at Oracle Open World 2015, it mentioned that third-party developers would be granted access to the 'SQL in Silicon' features.

DAX (the new term for this feature, short for 'data analytics accelerator') provides each of the M7's 32 cores with a coprocessor to perform scan, extract, select and translate SQL functions. These coprocessors operate at memory bus speed (up to 160GBps), and are used by Oracle Database 12c.

This speed is achieved in part by the combination of DAX and hardware support for memory decompression.

Oracle has now released an API and development kit for Solaris 11 that allows other developers to take advantage of DAX. Not only does it accelerate SQL functions, it also frees up the main processors for other work.

Vice president of product management for systems Marshall Choy told iTWire that Oracle's engineers had developed code allowing Apache Spark to take advantage of DAX, and that it would be submitted to Apache.

The performance improvement turns what have previously been batch operations into practically interactive activities, he said. DAX allows a database of one billion rows to be analysed interactively.

"In reality, not that much work" is required to DAX-enable a program, said Choy. Adding DAX support to Spark took a week and "the legal agreements took longer," he added

Furthermore, Brown University has been carrying out research into the performance and scalability of DAX in conjunction with Oracle. Computer science department chairman Ugur Centimenel said "We are currently working on characterising the performance of DAX across a suite of modern in-memory data layout schemes.

"After completing this study, we will work on the optimal use of DAX in accelerating interactive data exploration and visualisation with the Tupleware main-memory database system and S-Store real-time stream processing system.

"Through these studies, we will quantify the performance and scalability of M7 and DAX on real workloads involving sophisticated search and machine learning over large data sets."

Choy predicted that "a year from now we'll be looking at use cases that we didn't imagine."

M7 systems "have done exceedingly well" in the market and the open API for DAX will help continue this growth, in part by extending SPARC systems into non-traditional markets, he said.

Interested parties can join Oracle's software in silicon developer program here.


Australia is a cyber espionage hot spot.

As we automate, script and move to the cloud, more and more businesses are reliant on infrastructure that has high potential to be exposed to risk.

It only takes one awry email to expose an accounts payable process, and for cyber attackers to cost a business thousands of dollars.

In the free white paper ‘6 steps to improve your Business Cyber Security’ you will learn some simple steps you should be taking to prevent devastating malicious cyber attacks from destroying your business.

Cyber security can no longer be ignored, in this white paper you will learn:

· How does business security get breached?
· What can it cost to get it wrong?
· 6 actionable tips



iTWire can help you promote your company, services, and products.


Advertise on the iTWire News Site / Website

Advertise in the iTWire UPDATE / Newsletter

Promote your message via iTWire Sponsored Content/News

Guest Opinion for Home Page exposure

Contact Andrew on 0412 390 000 or email [email protected]


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 and a PhD in Industrial and Business Studies.



Recent Comments