Create applications with AI features easily using JavaScript and MySQL

at Roga DX in Brazil - Sept/25

Transcript

1. Crie aplicações com recursos de IA de forma simples usando JavaScript e MySQL MySQL HeatWave Data & AI Platform Narciso Oliveira Junior narciso.junior@oracle.com MySQL HeatWave Setembro, 2025
2. Narciso Júnior - narciso.junior@oracle.com Oracle Data & AI specialist | Driving Business Growth with Cloud | MySQL HeatWave GTM & Evangelist
3. 3 Copyright © 2024, Oracle and/or its affiliates Crie aplicações com recursos de IA de forma simples usando JavaScript e MySQL Out Target for TODAY!
4. 4 Copyright © 2024, Oracle and/or its affiliates
5. MySQL is the #1 Open Source Database And the most popular database for developers Copyright © 2025, Oracle and/or its affiliates Which databases have you used in the last 12 months? Source: DB Engines Ranking Jetbrains developer survey 2024 #1 in the cloud
6. Innovative organizations across many industries run MySQL Copyright © 2025, Oracle and/or its affiliates Social E-Commerce Tech Finance Manufacturing
7. 8 Oracle CloudWorld Tour Copyright © 2025, Oracle and/or its affiliates The world’s most popular open source database 1995 MySQL is Founded 2000 MySQL Adopts GPL Officially open- source project 2003 4 million active MySQL Installations 2005 MySQL 5.0 Advanced DB Features 2008 Acquisition by Sun 2010 Oracle Acquires Sun
8. 9 Oracle CloudWorld Tour Copyright © 2025, Oracle and/or its affiliates 2015 MySQL 5.7 Perf & Security 2018 MySQL 8.0 Giant leap for SQL 2019 DBMS of the year (DB-Engine) 2020 2024 8.4 LTS and 9.0 Innov. releases 2025 The world’s most popular open source database MySQL AI
9. Copyright © 2025, Oracle and/or its affiliates 10 Enter the new age of Data & AI AI ML & GenAI Data-Driven Actions & Insights Cloud OnPrem All Data Structured Semi-Structed Unstructured
10. Addressing the complexity with HeatWave One solution for Data & AI 11 Copyright © 2025, Oracle and/or its affiliates Single Service / No ETL Multi-Cloud Value ML & IA Data Science Analytics in Real-time All Data Social Media IoT Digital assets ERP / CRM Big Data
11. 12 Copyright © 2024, Oracle and/or its affiliates
12. Copyright © 2024, Oracle and/or its affiliates 13 • Advanced security features for encryption, data masking, authentication, and a database firewall • Automated patching, upgrades, backup, and high-availability management. Access to the latest MySQL features. • Technical support provided by the MySQL experts • Integrated data processing engine performing in-memory query acceleration for MySQL • Transparently improves MySQL query performance by orders of magnitude • The HeatWave cluster can scale out to handle peak loads and scale back in when no longer needed to reduce costs +
13. HeatWave MySQL: Faster insights One cloud service for transactions + real-time analytics Copyright © 2025, Oracle and/or its affiliates Eliminate the cost, complexity, latency, and risks of ETL duplication to a separate analytics database Use existing skills to get real-time analytics Cost model is determined by the resources allocated (CPU, RAM, Storage) rather than by request HeatWave MySQL Analytics tools and applications Transactional applications InnoDB storage engine OLTP HeatWave analytics cluster Data Warehouse
14. 15 Copyright © 2024, Oracle and/or its affiliates
15. JavaScript for HeatWave MySQL JavaScript for HeatWave MySQL Technical Brief 16 Copyright © 2024, Oracle and/or its affiliates MySQL Shell Support 2 1 3
16. 17 Copyright © 2024, Oracle and/or its affiliates OCI Region Availability Domain 1 Fault Domain 1 Fault Domain 2 Fault Domain 3 VCN Public Subnet 00.0.00.0/00 Private Subnet 00.0.00.0/00 VM Demo MySQL OLTP HeatWave OLAP HeatWave MySQL HeatWave Extreme Performance Demo - Architecture User MySQL Shell https://dev.mysql.com/doc/heatwave/en/mys-hw-airportdb-quickstart.html QuickStart AirportDB Analytics
17. HeatWave Extreme Performance Demo – In Action! Copyright © 2024, Oracle and/or its affiliates 18
18. Copyright © 2025, Oracle and/or its affiliates Lightning-Fast MySQL Performance with HeatWave Customer Feedbacks #1 Customer Feedbacks #2 • AWS RDS: 5 mins • HeatWave: 1 seg Customer Feedbacks #3 • AWS Aurora: 3 mins • HeatWave: 12 segs Benchmarks
19. Copyright © 2025, Oracle and/or its affiliates Unbeatable price & superior performance https://blogs.oracle.com/mysql/post/mysql-cloud-services-cost-comparison-who-provides-the-best-value-2025 • HeatWave MySQL is based on MySQL Enterprise • AWS RDS, Aurora, GCP CloudSQL for MySQL and Azure Database for MySQL are based on MySQL Community that is free
20. TPC-H 10TB 21 Best performance and price-performance for data warehouse Copyright © 2025, Oracle and/or its affiliates According to 10 TB TPC-H benchmarks as of May 23, 2023. Redshift, Snowflake, Databricks and BigQuery numbers for 10TB TPC-H numbers are provided by a third party. Benchmark queries are derived from the TPC-H benchmarks, but results are not comparable to published TPC-H benchmark results since these do not comply with the TPC-H specifications. 4X faster than Redshift 10X better price-performance 4X faster than Snowflake 15X better price-performance 10X ra3.4xlarge X-Large Cluster 800 slots Large Cluster Faster time to insights = faster business response to market trends 21 9X faster than BigQuery 20X better price-performance 11X faster than Databricks 37X better price-performance
21. Copyright © 2024, Oracle and/or its affiliates HeatWave customer momentum
22. 23 Copyright © 2024, Oracle and/or its affiliates
23. HeatWave GenAI – Easy and Integrated Copyright © 2025, Oracle and/or its affiliates 24 Applications HeatWave Object store Pretrained models In-database LLM Natural language question Natural language response Augmented prompt Vector Store HeatWave Chat Embedding Generation HeatWave AutoML 1 3 Automated Integrated Secure 2
24. Copyright © 2025, Oracle and/or its affiliates Building GenAI applications with non-Oracle databases is complex Discover user documents Parse data from documents Extract metadata Split data into segments Choose embedding model Create vector embeddings Design vector store Insert metadata + segments + embeddings into vector store Ensure consistency of ML model when querying Part 1 - Create a vector store Part 2 – Use the vector store with LLMs Ask a Question Choose embedding model Create query embedding Select Vector store to search Select search algorithm Select search results Create prompt with search results and guard rails Select LLM Get Results SQL> call sys.VECTOR_STORE_LOAD(uri, @options) SQL> sys.ML_RAG("What is HeatWave?", @NL_response, @optional_search_params) ➢ Simpler and faster ➢ No additional cost
25. 26 Copyright © 2024, Oracle and/or its affiliates OCI Region Availability Domain 1 Fault Domain 1 FD 2 FD 3 VCN Public Subnet 00.0.00.0/00 Private Subnet 00.0.00.0/00 VM Demo MySQL OLTP HeatWave GenAI HeatWave GenAI HeatWave GenAI Demo - Architecture User MySQL Shell https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-quickstart.html#mys-hw-gen-qs-vector-load QuickStart Set Up a GenAI- Powered Help Chat Object Storage Oracle Services Network
26. HeatWave GenAI Demo – In Action! Copyright © 2024, Oracle and/or its affiliates 27
27. Apps created using HeatWave GenAI - Visit our demo station and talk to our team Copyright © 2024, Oracle and/or its affiliates 28 Light-Fasting Dashboard 49x more performance with HeatWave MySQL AskME - Gen AI Chat Bot Ask natural language questions to your data! n8n & HeatWave GenAI Run AI agents integrated with HeatWave GenAI using n8n AI automation workflow GenA for eCommerce Leverage GenAI for content translation, reviews summarization, sentimental analysis etc
28. HeatWave Use Case: Semantic search and anomaly detection on documents Copyright © 2025, Oracle and/or its affiliates E-Commerce Natural language summary of anomaly across detected logs Vector Store Product descriptions . . . In-Database GenAI Fintech Vector Store Financial performance . . . In-Database GenAI Telecommunications AutoML Anomaly Detection Detect anomalous logs Alert operator Logs In-Database GenAI Ask questions about proprietary data in natural language
29. Copyright © 2025, Oracle and/or its affiliates 34 Always FREE HeatWave instance available in Oracle Cloud • Always free service • Run small-scale applications on HeatWave at no cost • Available features • OLTP, Autopilot, JavaScript • Vector store, Vector processing • Machine Learning (AutoML) • Lakehouse (object store processing) • Available now in all OCI accounts • 1 ECPU, 16GB memory with HeatWave node • MySQL storage: 50 GB, Lakehouse storage: 10 GB One Always Free DB system free-of-charge in the home region of each commercial tenancy Start for free here: • Oracle Cloud: https://cloud.oracle.com/mysqlaas/db-systems • Databases → HeatWave MySQL DB Systems
30. Learn more and stay in touch! Copyright © 2024, Oracle and/or its affiliates
31. Copyright © 2025, Oracle and/or its affiliates | Confidential: Internal/Restricted/Highly Restricted 36 https://education.oracle.com/race-to -certification-2025
32. 37 Copyright © 2024, Oracle and/or its affiliates Labs and free courses Live Labs Link => Live Labs
33. 38 Copyright © 2024, Oracle and/or its affiliates Labs and free courses Free MySQL Courses MySQL Explorer Link => MySQL Explorer
34. 39 Copyright © 2024, Oracle and/or its affiliates Labs and free courses Free MySQL Courses HeatWave Explorer Link => HeatWaveExplorer
35. 40 Copyright © 2024, Oracle and/or its affiliates
36. Q & A
37. Thank YOU! Narciso Oliveira Junior HeatWave Cloud Evangelist narciso.junior@oracle.com 42 Copyright © 2024, Oracle and/or its affiliates