Share
Embed
Predicting Good Wine in the Database with Oracle Machine Learning
How To use Oracle Machine Learning in the Oracle Database to predict Good and Bad Wine.
Contains also:
- Oracle Analytics Cloud Analysis
- Oracle APEX
- Oracle REST APIs
FTisiot
September 11, 2020
Transcript
51 slides
-
Francesco Tisiot Brendan Tierney Predicting good wine in the database
with oracle machine learning @Ftisiot @BrendanTierney Rittman Mead Oralytics -
Can I have a glass of Wine? Yes Sir, what
kind of wine? tell me what you have there! @Ftisiot @BrendanTierney -
Can I have a glass of Wine? Yes Sir, what
kind of wine? Red Wine! @Ftisiot @BrendanTierney -
Can I have a glass of Wine? Yes, Do you
like this Nice English pinot noir?? hell no! @Ftisiot @BrendanTierney -
Can I have a glass of Wine? Yes, Do you
like this Nice croatian cabernet?? Let me check…. 95% Yes! @Ftisiot @BrendanTierney -
CLASSIFICATION Naïve Bayes Logistic Regression (GLM) Decision Tree Random Forest
Neural Network Support Vector Machine Explicit Semantic Analysis CLUSTERING Hierarchical K-Means Hierarchical O-Cluster Expectation Maximization (EM) ANOMALY DETECTION One-Class SVM TIME SERIES Forecasting - Exponential Smoothing Includes popular models e.g. Holt-Winters with trends, seasonality, irregularity, missing data REGRESSION Linear Model Generalized Linear Model Support Vector Machine (SVM) Stepwise Linear regression Neural Network LASSO ATTRIBUTE IMPORTANCE Minimum Description Length Principal Comp Analysis (PCA) Unsupervised Pair-wise KL Div CUR decomposition for row & AI ASSOCIATION RULES A priori/ market basket PREDICTIVE QUERIES Predict, cluster, detect, features SQL ANALYTICS SQL Windows SQL Patterns SQL Aggregates •Includes support for Partitioned Models, Transactional, Unstructured, Geo-spatial, Graph data. etc, Oracle Machine Learning Algorithms FEATURE EXTRACTION Principal Comp Analysis (PCA) Non-negative Matrix Factorization Singular Value Decomposition (SVD) Explicit Semantic Analysis (ESA) TEXT MINING SUPPORT Algorithms support text Tokenization and theme extraction Explicit Semantic Analysis (ESA) for document similarity STATISTICAL FUNCTIONS Basic statistics: min, max, median, stdev, t-test, F-test, Pearson’s, Chi-Sq, ANOVA, etc. R PACKAGES Third-party R Packages through Embedded Execution Spark MLlib algorithm integration MODEL DEPLOYMENT SQL—1st Class Objects Oracle RESTful API (ORDS) OML Microservices (for Apps) X1 X2 A1 A2 A3 A4 A5 A6 A7 Copyright © 2019 Oracle and/or its affiliates. -
STATISTICAL FUNCTIONS Descriptive statistics (e.g. median, stdev, mode, sum, etc.)
Hypothesis testing (t-test, F-test, Kolmogorov-Smirnov test, Mann Whitney test, Wilcoxon Signed Ranks test Correlations analysis (parametric and nonparametric e.g. Pearson’s test for correlation, Spearman's rho coefficient, Kendall's tau-b correlation coefficient) Ranking functions Cross Tabulations with Chi-square statistics Linear regression ANOVA (Analysis of variance) Test Distribution fit (e.g., Normal distribution test, Binomial test, Weibull test, Uniform test, Exponential test, Poisson test) Statistical Aggregates (min, max, mean, median, stdev, mode, quantiles, plus x sigma, minus x sigma, top n outliers, bottom n outliers) Statistical Functions and Analytical SQL ANALYTICAL SQL SQL Windows SQL Aggregate functions LAG/LEAD functions SQL for Pattern Matching Additional approximate query processing: APPROX_COUNT, APPROX_SUM, APPROX_RANK Regular Expressions Copyright © 2019 Oracle and/or its affiliates. -
Oracle Machine Learning Multiple Languages UIs Supported for End Users
& Apps Development Application Developers DBAs R & Python Data Scientists “Citizen” Data Scientists Notebook Users & DS Teams Coming soon -
BEGIN DBMS_DATA_MINING.CREATE_MODEL( model_name => 'Wine_CLASS_MODEL', mining_function => dbms_data_mining.classification, data_table_name =>
''Wine_TRAIN_DATA', case_id_column_name => 'ID', target_column_name => 'POINTS_BIN', settings_table_name => 'Wine_build_settings'); END; / CREATE ML MODEL BEGIN DBMS_DATA_MINING.CREATE_MODEL( model_name => 'Wine_CLASS_MODEL', mining_function => dbms_data_mining.classification, data_table_name => ''Wine_TRAIN_DATA', case_id_column_name => 'ID', target_column_name => 'POINTS_BIN', settings_table_name => 'Wine_build_settings'); END; / BEGIN DBMS_DATA_MINING.CREATE_MODEL( model_name => 'Wine_CLASS_MODEL', mining_function => dbms_data_mining.classification, data_table_name => ''Wine_TRAIN_DATA', case_id_column_name => 'ID', target_column_name => 'POINTS_BIN', settings_table_name => 'Wine_build_settings'); END; / BEGIN DBMS_DATA_MINING.CREATE_MODEL( model_name => 'Wine_CLASS_MODEL', mining_function => dbms_data_mining.classification, data_table_name => ''Wine_TRAIN_DATA', case_id_column_name => 'ID', target_column_name => 'POINTS_BIN', settings_table_name => 'Wine_build_settings'); END; / BEGIN DBMS_DATA_MINING.CREATE_MODEL( model_name => 'Wine_CLASS_MODEL', mining_function => dbms_data_mining.classification, data_table_name => ''Wine_TRAIN_DATA', case_id_column_name => 'ID', target_column_name => 'POINTS_BIN', settings_table_name => 'Wine_build_settings'); END; / BEGIN DBMS_DATA_MINING.CREATE_MODEL( model_name => 'Wine_CLASS_MODEL', mining_function => dbms_data_mining.classification, data_table_name => ''Wine_TRAIN_DATA', case_id_column_name => 'ID', target_column_name => 'POINTS_BIN', settings_table_name => 'Wine_build_settings'); END; / BEGIN DBMS_DATA_MINING.CREATE_MODEL( model_name => 'Wine_CLASS_MODEL', mining_function => dbms_data_mining.classification, data_table_name => ''Wine_TRAIN_DATA', case_id_column_name => 'ID', target_column_name => 'POINTS_BIN', settings_table_name => 'Wine_build_settings'); END; / @Ftisiot @BrendanTierney -
apply ML MODEL SELECT PREDICTION_PROBABILITY( Wine_CLASS_MODEL, 'GT_90_POINTS' USING 25 as
PRICE, ‘MALBEC' as VARIETY, ‘SPAIN' as COUNTRY ) FROM dual; SELECT PREDICTION_PROBABILITY( Wine_CLASS_MODEL, 'GT_90_POINTS' USING 25 as PRICE, ‘MALBEC' as VARIETY, ‘SPAIN' as COUNTRY ) FROM dual; SELECT PREDICTION_PROBABILITY( Wine_CLASS_MODEL, 'GT_90_POINTS' USING 25 as PRICE, ‘MALBEC' as VARIETY, ‘SPAIN' as COUNTRY ) FROM dual; SELECT PREDICTION_PROBABILITY( Wine_CLASS_MODEL, 'GT_90_POINTS' USING 25 as PRICE, ‘MALBEC' as VARIETY, ‘SPAIN' as COUNTRY ) FROM dual; @Ftisiot @BrendanTierney -
Copyright © 2018, Oracle and/or its affiliates. All rights reserved.
| Confidential – Oracle Internal/Restricted/Highly Restricted 22 -
Copyright © 2018, Oracle and/or its affiliates. All rights reserved.
| Confidential – Oracle Internal/Restricted/Highly Restricted 24 -
Copyright © 2018, Oracle and/or its affiliates. All rights reserved.
| Confidential – Oracle Internal/Restricted/Highly Restricted 25 -
Copyright © 2018, Oracle and/or its affiliates. All rights reserved.
| Confidential – Oracle Internal/Restricted/Highly Restricted 26 -
Copyright © 2018, Oracle and/or its affiliates. All rights reserved.
| Confidential – Oracle Internal/Restricted/Highly Restricted 27 -
ML Model Deployment via ORDS REST API Launch Developmentà APEX
@Ftisiot @BrendanTierney -
ML Model Deployment via ORDS REST API Launch RESTful Services
@Ftisiot @BrendanTierney -
ML Model Deployment via ORDS REST API Schema enables for
ORDS RESTful Services @Ftisiot @BrendanTierney -
ML Model Deployment via ORDS REST API Helpful example templates
provided @Ftisiot @BrendanTierney -
ML Model Deployment via ORDS REST API Helpful example templates
provided Build your own custom API For What-IF ML predictions / Scoring – micro-services @Ftisiot @BrendanTierney -
ML Model Deployment via ORDS REST API RESTful API for
calling OML model to make predictions @Ftisiot @BrendanTierney -
Real-time Wine Recommendation App + OpenDiningTable App Copyright © 2019
Oracle and/or its affiliates. @Ftisiot @BrendanTierney -
ML in database Summary analytics security governance prod deployment knowledge
sharing data exploration visualisations storytelling easy reuse @Ftisiot @BrendanTierney -
Francesco Tisiot Brendan Tierney Predicting good wine in the database
with oracle machine learning @Ftisiot @BrendanTierney Rittman Mead Oralytics