Oracle adds data warehousing to MySQL

Oracle
(Image credit: Oracle)

Oracle is releasing an extended version of its open-source MySQL service that will include data warehousing functionality. The update should mean that users of cloud computing database solutions no longer need to rely on a separate data analytics database if they need a data warehouse.

From today, Oracle is making its MySQL Database Service with integrated MySQL Analytics Engine available, delivering a unified platform for both online transaction processing and online analytics processing workloads. 

The new analytics engine will go head to head with Amazon Redshift, promising to be at least twice as fast and 66% less expensive than Amazon’s service.

A new database service

Although MySQL remains one of the most popular database solutions in the world, it has largely been limited to transaction processing as it lacks some of the functionality required for analytics. 

As a result, many users of MySQL databases had to run a separate analytics database, extracting, transforming, and loading their data as part of a costly and time-consuming process.

The new update means that the Oracle MySQL Database Service is the only solution that allows customers to run both transaction and analytics workloads directly from their MySQL database. It not only means that more businesses may consider MySQL for their data warehousing needs, they may also see Oracle as a viable MySQL service provider.

“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 Edward Screven, chief corporate architect at Oracle. 

“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.”

Via ZDNet

TOPICS
Barclay Ballard

Barclay has been writing about technology for a decade, starting out as a freelancer with ITProPortal covering everything from London’s start-up scene to comparisons of the best cloud storage services.  After that, he spent some time as the managing editor of an online outlet focusing on cloud computing, furthering his interest in virtualization, Big Data, and the Internet of Things. 

Latest in Pro
An American flag flying outside the US Capitol building against a blue sky
Sean Plankey selected as CISA director by President Trump
A young man working on laptop in office writing notes
Ending the fix/break cycle of End User Computing support
OpenAI
OpenAI wants to help your business build its next generation of AI agents
Ai tech, businessman show virtual graphic Global Internet connect Chatgpt Chat with AI, Artificial Intelligence.
Nation-state threats are targeting UK AI research
A hand reaching out to touch a futuristic rendering of an AI processor.
Business investors are positive about AI’s impact on the economy
Scam alert
Fake jobs and phone calls: How Americans lost $12.5 bn to fraud in 2024
Latest in News
Vision Pro Metallica
Apple Vision Pro goes off to never never land with Metallica concert footage
Mufasa is joined by another lion, a monkey and a bird in this promotional image
Mufasa: The Lion King prowls onto Disney+ as it finally gets a streaming release date
An American flag flying outside the US Capitol building against a blue sky
Sean Plankey selected as CISA director by President Trump
An Nvidia GeForce RTX 4060 on a table with its retail packaging
Nvidia RTX 5060 GPU spotted in Acer gaming PC, suggesting rumors of imminent launch are correct – and that it’ll run with only 8GB of video RAM
Indiana Jones talking to a friend in a university setting with a jaunty smile on his face
New leak claims Indiana Jones and the Great Circle PS5 release will come in April
A close up of the limited edition vinyl turntable wrist watch from AndoAndoAndo
This limited-edition timepiece turns the iconic Technics SL-1200 turntable into a watch, and I want one