Wednesday, 09 March 2016 00:02

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

By

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.

BUSINESS WORKS BETTER WITH WINDOWS 1O. MAKE THE SHIFT

You cannot afford to miss this Dell Webinar.

With Windows 7 support ending 14th January 2020, its time to start looking at your options.

This can have significant impacts on your organisation but also presents organisations with an opportunity to fundamentally rethink the way users work.

The Details

When: Thursday, September 26, 2019
Presenter: Dell Technologies
Location: Your Computer

Timezones

QLD, VIC, NSW, ACT & TAS: 11:00 am
SA, NT: 10:30 am
WA: 9:00 am NZ: 1:00 pm

Register and find out all the details you need to know below.

REGISTER!

ADVERTISE ON ITWIRE NEWS SITE & NEWSLETTER

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

Get more LEADS & MORE SALES

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]

OR CLICK HERE!

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.

VENDOR NEWS & EVENTS

REVIEWS

Recent Comments