Friday, 04 December 2020 10:13

Oracle brings in-memory analytics to MySQL

By

The Oracle MySQL Database Service with integrated MySQL Analytics Engine, exclusively available in Oracle Cloud Infrastructure provides a single, unified platform for online transaction processing and online analytics processing workloads. the company said.

MySQL is widely used for transaction processing databases, but it has usually been necessary to extract data into a separate database for analytics work.

"The Oracle MySQL Database Service with the MySQL Analytics Engine provides a fully managed scale-out service for analytics and OLTP and is the only service that enables customers to run OLTP and OLAP workloads directly from their MySQL database," said Oracle officials.

The service automatically populates the memory of the analytics engine with data from the MySQL database, and works with MySQL-compatible tools and applications.

Queries are automatically routed to the MySQL Analytics Engine, simplifying application development, saving time, and enabling real-time queries, as well as decreasing costs and improving security.

"MySQL is the most popular database among developers and is widely used by companies across industries. But, until today, MySQL users have been forced to move their data into separate incompatible data warehouses for analytics leading to higher costs and delayed answers," said Oracle chief corporate architect Edward Screven.

"With the MySQL engineering team's latest innovations, Oracle is the only provider that offers developers and database administrators a single, unified platform that can easily run high performance real-time analytics against their MySQL database without requiring any change to their MySQL applications – making Oracle Cloud Infrastructure the best place to run MySQL applications."

According to Oracle, the service is at least twice as fast as Amazon Redshift and up to 66% less expensive. As Oracle chairman and CTO Larry Ellison is fond of saying, "you have to be willing to pay less".

"At Siemens Healthineers we use several MySQL databases. During our tests of the new MySQL Database Service Analytics Engine we discovered astonishing performance improvements, reducing query times from hours to literally seconds in cases of non-index based queries," said Siemens Healthineers senior key expert Jens Uecker.

"This enables us to expand service to new levels and opens the door to many more analytics-based capabilities, all while maintaining a single, seamless database platform."

MySQL Database for Analytics costs $0.5500248 per node per hour. The service is available in all Oracle Cloud commercial regions and will be available in Oracle Dedicated Region Cloud@Customer.


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