使用 MySQL HeatWave 制作終極戶外探險預報.pdf

1、MySQL and HeatWave SummitCraig ShallahamerOracle ACE DirectorApplied AI Scientist|OraPub FounderW orapubW Crafting the Ultimate Outdoor Adventure ForecastUsing MySQL HeatWaveMySQL and HeatWave Summit 2024|May 1,2024Oracle Conference Center,Redwood City,California USAMySQL and HeatWave SummitCraig Sh

2、allahamerOracle ACE DirectorApplied AI Scientist|OraPub FounderW orapubW Having worked with Oracle technology since 1989,Craig Shallahamer is a leader in the fields of machine learning,artificial intelligence and Oracle database performance tuning.Craig has extensive experience in constructing and t

3、eaching predictive modeling methods,notably developing a Reinforcement Machine Learning bot in 1990.He has launched several specialized generative AI conversational assistants,each with distinct personalities and capabilities.As an Applied AI Scientist at Viscosity and the founder of OraPub,Craig is

4、 also the author of two acclaimed books:Oracle Performance Firefighting and Forecasting Oracle Performance.He has received recognition as an Oracle ACE Director for his valuable contributions to the Oracle community through his technical expertise and leadership.Craig is an active participant in Ora

5、cle user groups,frequently presenting at conferences and serving as a board member and volunteer.MySQL and HeatWave Summit1990I created a program where I could play the game tic-tac-toe with a computer,but also enabled the computer to play itself and learning through that process.MySQL and HeatWave

6、SummitMySQL and HeatWave SummitMySQL and HeatWave SummitFrom a more business perspective Internet marketing,focusing on identifying hot leads for very specific promotions.IT Operations when many Oracle systems must be monitored and Operations possibly alerted;both anomaly detection and performance p

7、rediction.Domain specific generative Q&A Bots and Conversational Assistants With Personality in multiple business domains.For example,Oracle Performance Tuning,Biblical Texts,Real estate investing platform.MySQL and HeatWave SummitLeveraging Oracle Cloud Infrastructure,AI Shane is a conversational A

8、I assistant with a vast curated knowledge base of all things Oracle performance.Shane also has a very distinct stereotypic surfer persona.His objective is to help anyone improve their Oracle system performance optimization skills.AI Shane leverages the Oracle Generative AI Oracle Generative AI servi

9、ces within Oracle Cloud Infrastructure Oracle Cloud Infrastructure(OCI).This includes LLMs,vector LLMs,vector and traditional capabilities within Oracle Databases.Specifically,AI Shane can use the Oracle Vector Store,Oracle GenAI Services,Oracle Autonomous DB,Oracle MySQL,Oracle MySQL Heatwave and O

10、CI Compute.Shane AI:The Oracle Tuning AI AssistantMySQL and HeatWave SummitMySQL and HeatWave SummitViscosity Pillars and Delivery ModelsOracle&SQL Server PostgresPerformance TuningData ReplicationData Warehousing AnalyticsData IntegrationERP Blue PrintsDatabase UpgradesAPEXEBSWeb/Mobile Apps.Net an

11、d C#E-Business SuiteSAAS/PAASAzure Gold PartnerCloud MigrationsEngineered SystemsOracle Cloud PartnerGoogle PartnerAWS Partner Hybrid CloudWorkshopsAssessmentsProof ofConceptsTrainingTurnkeyProjectsManaged ServicesMySQL and HeatWave SummitViscositys Oracle ACEsThe Oracle ACE ProgramThe Oracle ACE Pr

12、ogram recognizes and rewards individuals for their contributions to the Oracle community.Charles KimCEO|Co-FounderW racdbaW ACE DirectorCraig ShallahamerApplied AI ScientistW orapubW ACE DirectorRich NiemiecChief Innovation OfficerW richniemiecW ACE DirectorSean ScottPrincipal ConsultantW oraclesean

13、W ACE DirectorGary GordhamerPrincipal ConsultantW ggordhamW ACE ProMySQL and HeatWave SummitWeve written over 25 technical books!MySQL and HeatWave SummitR E A D Y?MySQL and HeatWave SummitT H E P L A NSituation the painFlowArchitectureMySQL&HeatWave callsSurprisesMySQL and HeatWave Summithttp:/rain

14、-app.py?station=KORMySQL and HeatWave Summithttp:/rain-app.py?station=KORMySQL and HeatWave SummitThe SituationIts helpful if I know its going to rain.Most of my hikes are less than six hours.What I need is a six hour rain forecast.Ever hear of a 6hr rain forecast?No.And,local forecast arent really

15、so local.Perhaps AI can help?MySQL and HeatWave SummitBuild an AI,to forecast the likelihood of rain,from now out to six hours into the future.Needs to run from a URL on my phone.Objective Summaryhttp:/rain-app.py?station=KORMySQL and HeatWave SummitT H E F L O WThe WU station ID and API key have be

16、en validated to ensure weather data can be retrieved.MySQL and HeatWave SummitTHE ARCHITECTUREMySQL and HeatWave SummitTrain using MySQL HeatWave AutoMLIt is really this simple.Create a table with your preprocessed data,set the sys.ML_TRAIN parameters and run sys.ML_TRAIN just like any other MySQL p

17、rocedure.MySQL and HeatWave SummitPredictions using MySQL HeatWaveFirst,I need to check if the ML model has already been created.So,I make a simple MySQL query to my rain_ml_models table.MySQL and HeatWave SummitTo make a prediction using an existing ML model,the most recent data is given to the ML

18、model to make the prediction.I have lots of preprocessed columns(most_recent_data)so I need to ensure I give the model only the columns(column_names)it wants.Predictions using MySQL HeatWaveMySQL and HeatWave SummitThe most recent weather data is placed into the row_input session variable.row_input

19、will be given to the trained ML model to help make the prediction.Predictions using MySQL HeatWaveMySQL and HeatWave SummitBefore I can request a prediction,the trained ML model must be loaded into HeatWave cluster.Once loaded,the model_handle and the row_input is given to make the prediction using

20、a simple SELECT statement!Predictions using MySQL HeatWaveMySQL and HeatWave SummitAfter the quick prediction occurs,the trained ML model is unloaded from the HeatWave cluster.Then the results are sent to the users mobile device!http:/rain-app.py?station=KORPredictions using MySQL HeatWaveMySQL and

21、HeatWave SummitSURPRISES IT JUST WORKS AutoML quality,simplicity,HeatWave speed,usability and especially stability.Documentation is created to help me use the product.Integration(MySQL,HeatWave)with Python means APIs anywhere,community everywhere and very straightforward.MySQL and HeatWave SummitA s

22、pecial shout-out to bothKirk Bohn&Preside FosterThank you both for helping make this presentation possible!MySQL and HeatWave SummitNow its your turn! for presentation and code.http:/rain-app.py?station=KORMySQL and HeatWave SummitThankYou!MySQL and HeatWave SummitMySQL and HeatWave SummitCraig ShallahamerOracle ACE DirectorApplied AI Scientist|OraPub FounderW orapubW Crafting the Ultimate Outdoor Adventure ForecastUsing MySQL HeatWaveMySQL and HeatWave Summit 2024|May 1,2024Oracle Conference Center,Redwood City,California USAShane AI