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.


Subscribe to ITWIRE UPDATE Newsletter here

GRAND OPENING OF THE ITWIRE SHOP

The much awaited iTWire Shop is now open to our readers.

Visit the iTWire Shop, a leading destination for stylish accessories, gear & gadgets, lifestyle products and everyday portable office essentials, drones, zoom lenses for smartphones, software and online training.

PLUS Big Brands include: Apple, Lenovo, LG, Samsung, Sennheiser and many more.

Products available for any country.

We hope you enjoy and find value in the much anticipated iTWire Shop.

ENTER THE SHOP NOW!

INTRODUCING ITWIRE TV

iTWire TV offers a unique value to the Tech Sector by providing a range of video interviews, news, views and reviews, and also provides the opportunity for vendors to promote your company and your marketing messages.

We work with you to develop the message and conduct the interview or product review in a safe and collaborative way. Unlike other Tech YouTube channels, we create a story around your message and post that on the homepage of ITWire, linking to your message.

In addition, your interview post message can be displayed in up to 7 different post displays on our the iTWire.com site to drive traffic and readers to your video content and downloads. This can be a significant Lead Generation opportunity for your business.

We also provide 3 videos in one recording/sitting if you require so that you have a series of videos to promote to your customers. Your sales team can add your emails to sales collateral and to the footer of their sales and marketing emails.

See the latest in Tech News, Views, Interviews, Reviews, Product Promos and Events. Plus funny videos from our readers and customers.

SEE WHAT'S ON ITWIRE TV NOW!

BACK TO HOME PAGE
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.

Share News tips for the iTWire Journalists? Your tip will be anonymous

WEBINARS ONLINE & ON-DEMAND

GUEST ARTICLES

VENDOR NEWS

Guest Opinion

Guest Interviews

Guest Reviews

Guest Research

Guest Research & Case Studies

Channel News

Comments