MySQL HeatWave
tags :
One Database for OLTP, OLAP, ML & Lakehouse #
ref MySQL HeatWave is the only Fully Managed database service that combines
transactions,
analytics, and
machine learning services into one MySQL Database, without the complexity, latency, and cost of ETL duplication.
“query engine”
MySQL HeatWave includes MySQL HeatWave Data Lakehouse, letting users query half a petabyte of data in
Object Storage—in a variety of file formats, such as CSV, Parquet, and export files from other databases.
- Customers can leverage the benefits of HeatWave even when their data is stored outside a MySQL database.
youtube only database that combines OLTP and OLAP: online transactions and high speed analytics.
youtube Vector Store can be created in heatwave.
Cloud Hosting #
Deploy MySQL HeatWave on Oracle Cloud Infrastructure (OCI), Amazon Web Services (AWS), and Microsoft Azure. You can also use MySQL HeatWave in your data center with Oracle Dedicated Region Cloud@Customer.
Features #
https://www.oracle.com/sa/mysql/#features
ML Services #
https://www.oracle.com/sa/mysql/#automl
No need for a separate machine learning service #
- In-database machine learning in MySQL HeatWave eliminates the need for a separate ML service.
- ML training, inference, and explanation can be applied to data stored in MySQL and HeatWave Lakehouse.
- Accelerates ML initiatives, enhances security, and reduces costs.
Save time and effort with machine learning lifecycle automation #
- HeatWave AutoML automates the ML lifecycle, including algorithm selection, data sampling, feature selection, and hyperparameter optimization.
- Customizable ML pipeline for algorithm selection, feature selection, and hyperparameter optimization.
- Supports anomaly detection, forecasting, classification, regression, and recommender systems.
Recommender system for personalized recommendations #
- HeatWave AutoML’s recommender system considers implicit and explicit feedback to generate personalized recommendations.
- Predicts user-item preferences, item ratings, and provides lists of similar users and items.
Interactive MySQL HeatWave AutoML console #
- Business analysts can build, train, run, and explain ML models using a visual interface.
- No SQL commands or coding required.
- Allows exploring what-if scenarios to evaluate business assumptions.
Faster, less expensive, and more accurate than Redshift ML #
- HeatWave AutoML outperforms Amazon Redshift ML in terms of accuracy, speed, and cost-efficiency.
- Trains models up to 25X faster at 1% of the cost.
- Scales seamlessly as more nodes are added.
Explainable ML models #
- All models trained by HeatWave AutoML are explainable.
- Provides explanations of predictions, ensuring regulatory compliance, fairness, and trust.
Use current skills #
- Developers and data analysts can use familiar SQL commands to build ML models.
- Integration with popular notebooks like Jupyter and Apache Zeppelin.
Generative AI and vector store #
- Private preview feature: vector store empowers customers to utilize large language models (LLMs) with proprietary data for more accurate answers.
- Generative AI and vector store capabilities enable natural language interactions and efficient document search in various file formats in HeatWave Lakehouse.
Meeting with Oracle MySQL @Faisaliya hotel #
Participants #
Nipun.agarwal@oracle.com Amin Ibrahim: https://www.linkedin.com/in/amin-ibrahim-a8014990/ Mughees A Minhas: https://www.linkedin.com/in/mughees-minhas-a3ba30/
- mother from Hyderabad Deccan, he is from Karachi
Przemek Dominiak: https://www.linkedin.com/in/przemekdominiak/
Notes #
- RAG application is on the roadmap