利用 HeatWave 对 MySQL 数据库之外的业务性数据进行分析和机器学习：速度提升百倍 .pdf

1、100 x Acceleration on Analytics and Machine Learning with HeatWave on Transactional Data Outside of MySQL databasesMandy PangSenior Principal Product ManagerMySQL HeatWaveMySQL and HeatWave Summit2024AgendaCopyright 2024,Oracle and/or its affiliates.All rights reserved.MySQL HeatWave overviewUse Cas

2、esMySQL HeatWave overviewTransactions,real-time analytics,machine learning and GenAI across data warehouse and data lake in one serviceMySQL HeatWaveAnalyticsOLTPSocial,eCommerce,IoT,gaming,fintech apps.Analytics and ML Social,eCommerce,IoT,gaming,fintech apps.Analytics and ML toolstoolsObject Store

3、Database Database exportsexportsIn-database MLDatabase exportsStreaming dataData SourcesEnterprise AppsWeb/SocialLog filesIoTMySQL MySQL storagestorageFor both non-MySQL and MySQL workloadsMySQL AutopilotQueriesQueriesResultsResultsVector store*Vector store*GenAIGenAI*Coming soon*Coming soonFASTER T

4、IME TO INSIGHTS=FASTER BUSINESS RESPONSE TO MARKET TREANDSBest performance in industry for data warehouse020406080100120Average Execution Time(Sec)*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 wi

5、th the TPC-H specifications.*Results from March 2023HeatWaveHeatWave(10 nodes)Redshift(10*ra3.4xlarge)Snowflake(X-Large)Google BigQuery(800 slots)Databricks(Large)4.2X4.2X3.3X3.3X5.6X5.6X7.4X7.4XTPCTPC-H 10TBH 10TBPRICE PERFORMANCE COMPARISON FOR 10TB TPC-HLowest cost in industry for data warehouse0

6、0.10.20.30.40.50.60.70.80.91Price-Performance($)*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*Results from Sept 2022HeatWaveOnly compute costs are considered abovePr