The innovative highly scalable, cloud-based service, that includes a data analysis engine, enables data integration and data analysis applications to run on the same database without any of the cost or difficulty of using multiple systems.Oracle has revealed the wide availability of a cloud-based MySQL database service that includes a new analytics platform capable of performing transaction processing and business analysis tasks within the same database system.
Moreover to have the complete knowledge about the cloud services definitely one must take the Oracle Cloud Service Bus Training.This training will help you to build all the key skills required for performing dynamic operations when required for the business expansion.
MySQL as a Cloud Service
The software powerhouse is positioning the fully managed MySQL Database Service as a high-performance, lower-cost alternative to competing systems such as Amazon Web Services’ RDS database and Redshift cloud data warehouse, Google Cloud SQL, and Microsoft Azure SQL Database.
Oracle’s partners have been requesting that the company expand its database services portfolio. And that is exactly what Oracle is doing with MySQL Database Service,” said Edwin DeSouza, Oracle’s vice president of product marketing for MySQL, in an interview with CRN.
As part of its acquisition of Sun Microsystems in 2010, Oracle acquired the open-source MySQL database. MySQL was previously acquired by Sun in 2008.
MySQL is a popular database for online transaction processing (OLTP) applications, which manage data generated by retail, financial, and other operational applications that support many business processes. However, the database has historically been lacking in data analysis and online analytical processing (OLAP) capabilities.
As a result, when running analytical applications – such as analyzing sales data to identify customer trends – businesses and organizations frequently use a database separate from the OLTP system. As a result, system complexity increases, as does data movement and transformation, as well as costs.
MySQL users have been forced to use a different database for OLAP,” DeSouza explained. According to him, this “adds friction” to database operations and necessitates data extract, transform, and load (ETL) technology and processes. “Data is not real time, and decision making is not real time,” he continued.
Oracle has revealed the global launch of the Oracle MySQL Database Service with the MySQL Analytics Engine, a MySQL offering that offers database administrators and application developers a unified platform for both OLTP and OLAP workloads.
According to Nipun Agarwal, vice president of research and advanced development – the Oracle organization that developed the new capabilities within the MySQL Database Service and the analytics engine – the new MySQL service, which has been in beta testing for about a year, is optimized for – and available only through – the Oracle Cloud Infrastructure (OCI), Oracle’s Infrastructure-as-a-Service cloud platform.
The MySQL Analytics Engine is an in-memory analytics accelerator that enables users to run sophisticated analytical queries against their live MySQL databases. When a customer launches the MySQL service, data from the MySQL database is loaded into the analytics engine’s memory. Oracle claims that this eliminates the need for complex and costly data integration and ETL.
It is considerably quicker and substantially less expensive. There is no longer any need for two separate databases or ETL. All existing MySQL tools and applications continue to function normally, according to Agarwal.
According to Oracle, the analytical engine scales to thousands of cores and supports real-time analytics, and the technology performs 2.7 times faster than AWS Redshift at one-third the cost. The engine employs in-memory, hybrid columnar processing with massive inter- and intra-node parallelism optimized for the Oracle Cloud Infrastructure, as well as distributed algorithms optimized for the Oracle Cloud Infrastructure.
Aside from the new engine, the query optimizer within the MySQL Database Service has been improved to support both analytical and OLTP queries.
Oracle MySQL, which introduces a small cloud database service and analytics engine, is in a large space. MySQL database services are provided by a number of vendors, including cloud platform vendors AWS, Google, and Microsoft Azure.
Mainstream databases such as Oracle’s flagship relational database and Microsoft SQL Server are also potential competitors. The MariaDB database, as well as its recently launched SkySQL managed cloud database service, which was created by some of MySQL’s original developers, poses a competitive threat.
There is also a new generation of database systems, such as Splice Machine and MemSQL, that support both transaction processing and data analytics in a single system.
Oracle Database is supported by hundreds of resellers and systems integrator partners. However, DeSouza stated that partners as well as many cloud customers who come to Oracle through partners have been requesting a MySQL cloud service.
Although some may see MySQL and the latest cloud service as a competitive option to Oracle’s cash cow database, DeSouza stated that Oracle understands the importance of providing partners and customers with a database product at “open source price points.”
Author Bio
I am VarshaDutta Dusa, Working as a Senior Digital Marketing professional & Content writer in HKR Trainings. Having good experience in handling technical content writing and aspires to learn new things to grow professionally. I am expertise in delivering content on the market demanding technologies like Service Now Training, Oracle Service Bus Course, SQL Server DBA Course, Elasticsearch Course, Jmeter Course, Kibana, ServiceNow HR Service Management etc.