Oracle MySQL HeatWave provides a single, unified platform for transactional and analytics workloads. Without any changes to existing applications. Oracle MySQL HeatWave increases MySQL performance by orders of magnitude for analytics and mixed workloads, MySQL is optimized for OLTP, many MySQL implementations use a separate OLAP database for For database admins and application developers, it’s the only service thatĮnables them to run OLTP and OLAP workloads directly from their MySQL database. Oracle MySQL HeatWave is the only MySQL cloud service with a built-in, high performance, in-memory queryĪccelerator. In this data lakehouse architecture on OCI, Oracle MySQL HeatWave is used for data warehousing. The following diagram illustrates this reference architecture.ĭescription of the illustration open-source-data-lakehouse.png The data which is present in theĭata lake can either be processed and loaded to the data warehouse, or it can be readĭirectly from the data lake for advanced analytics. DataĬan be sent to the data lake or to the data warehouse. Recommended best practices, and Terraform automation to deploy an open-source data lakehouseĪ data lakehouse can store and aggregate enterprise application data. This architecture introduces a platform topology, component overview,

Data lakehouse access control