Oracle Machine Learning for SQL is part of the Oracle Machine Learning family of technologies, and is the fastest way to access the heart of the Machine Learning inside every Oracle Database.
Following Oracle's philosophy of moving the algorithms and not the data, the execution of these 30+ parallel, scalable in-Database implementations of machine learning algorithms minimizes or eliminates data movement, achieving scalability, security, and accelerated time-to-model deployment.
Oracle also provides easy mechanism for running R-extensible scripts directly inside the Oracle Database.
The following are a list of demos containing SQL code for learning about (OML4SQL)
Files on the current folder:
- dmsh.sql - Setup - Creates Demo Views and Tables
- dmshgrants.sql - Setup - Grants Privileges to Users
- oml4sql-anomaly-detection-1class-svm.sql - Anomaly Detection - One Class SVM Algorithm
- oml4sql-association-rules.sql - Association Rules - Apriori Algorithm
- oml4sql-attribute-importance.sql - Attribute Importance - "EXPLAIN" MDL function
- oml4sql-classification-decision-tree.sql - Classification - Decision Tree Algorithm
- oml4sql-classification-glm.sql - Classification - Generalized Linear Model Algorithm
- oml4sql-classification-naive-bayes.sql - Classification - Naïve Bayes Algorithm
- oml4sql-classification-neural-networks.sql - Classification - Neural Networks Algorithm
- oml4sql-classification-random-forest.sql - Classification - Random Forest Algorithm
- oml4sql-classification-regression-xgboost.sql - Classification and Regression - XGBoost Algorithm
- oml4sql-classification-svm.sql - Classification - SVM Algorithm
- oml4sql-classification-text-mining-svm.sql - Classification - SVM Algorithm with Text Mining
- oml4sql-clustering-expectation-maximization.sql - Clustering - Expectation-Maximization Algorithm
- oml4sql-clustering-kmeans-star-schema.sql - Clustering - K-Means Algorithm
- oml4sql-clustering-kmeans.sql - Clustering - K-Means Algorithm
- oml4sql-clustering-ocluster.sql - Clustering - O-Cluster Algorithm
- oml4sql-cross-validation-decision-tree.sql - Cross-Validation - Decision Tree Algorithm
- oml4sql-feature-extraction-cur.sql - Feature and Row Extraction - CUR Decomposition Algorithm
- oml4sql-feature-extraction-nmf.sql - Feature Extraction - Non-Negative Matrix Factorization Algorithm
- oml4sql-feature-extraction-svd.sql - Feature Extraction - Singular Value Decomposition
- oml4sql-feature-extraction-text-mining-esa.sql - Feature Extraction - ESA Algorithm for Text Mining
- oml4sql-feature-extraction-text-mining-nmf.sql - Feature Extraction - NMF Algorithm with Text Mining
- oml4sql-feature-extraction-text-term-extraction.sql - Feature Extraction - Text Term Extraction
- oml4sql-partitioned-models-svm.sql - Partitioned Models - Support Vector Machine Algorithm
- oml4sql-r-extensible-algorithm-registration.sql - OML R Extensible - Algorithm Registration
- oml4sql-r-extensible-association-rules.sql - OML R Extensible - Association Rules Algorithm
- oml4sql-r-extensible-attribute-importance-via-rf.sql - OML R Extensible - Attribute Importance via RF Algorithm
- oml4sql-r-extensible-glm.sql - OML R Extensible - Generalized Linear Model Algorithm
- oml4sql-r-extensible-kmeans.sql - OML R Extensible - K-Means Algorithm
- oml4sql-r-extensible-principal-components.sql - OML R Extensible - Principal Components Algorithm
- oml4sql-r-extensible-regression-neural-networks.sql - OML R Extensible - Regression - Neural Networks Algorithm
- oml4sql-r-extensible-regression-tree.sql - OML R Extensible - Regression Tree Algorithm
- oml4sql-regression-glm.sql - Regression - Generalized Linear Model Algorithm
- oml4sql-regression-neural-networks.sql - Regression - Neural Networks Algorithm
- oml4sql-regression-random-forest.sql - Regression - Random Forest Algorithm
- oml4sql-regression-svm.sql - Regression - SVM Algorithm
- oml4sql-singular-value-decomposition.sql - SVD Algorithm
- oml4sql-survival-analysis-xgboost.sql - Survival Analysis with AFT (Accelerated Failure Time) via XGBoost Algorithm
- oml4sql-time-series-esm-auto-model-search.sql - Time Series - Exponential Smoothing with Auto Model Search
- oml4sql-time-series-exponential-smoothing.sql - Time Series - Exponential Smoothing Algorithm
- oml4sql-time-series-mset.sql - Time Series - MSET Multivariate State Estimation Technique Algorithm
- oml4sql-time-series-regression-dataset.sql - Time Series Regression - Dataset
- oml4sql-time-series-regression.sql - Time Series Regression - Using a combination of ESM and GLM algorithms