MySQL, the open source relational database that came to Oracle through the Sun Microsystems acquisition, originated as a relatively simple relational database that was known for one task: transaction processing. In an announcement today, Oracle is unveiling an extended version of MySQL that takes it into data warehousing territory. It is releasing a new managed MySQL database service on Oracle Cloud Infrastructure (OCI) that will support both transaction and analytic processing workloads.
That creates a key change for MySQL users. With few if any analytic options open, MySQL users typically resorted to ETL to move data to a separate database if they needed a data warehouse. In the new Oracle cloud service, it’s part of the same offering, and thanks to liberal use of in-memory technology, eliminates the need to run ETL.
Until now, MySQL has been primarily restricted to transaction processing as it lacks features, such as support for