Predictive AI Layers for Databases

AI Tables

SELECT <predicted_variable> FROM <ML_model> WHERE <conditions>

Automated Machine Learning and AI Tables

How predictive AI layers work

  1. The Machine Learning models are exposed as database tables (AI-Tables) that can be queried with the SELECT statements.
  2. The ML model generation and training are done through a simple INSERT statement.

The Example of Predictive AI Layers

INSERT INTO
mindsdb.predictors(name, predict, select_data_query)
VALUES
('used_cars_model', 'price', 'SELECT * FROM used_cars_data);
SELECT price,
confidence
FROM mindsdb.used_cars_model
WHERE model = "a6"
AND mileage = 36203
AND transmission = "automatic"
AND fueltype = "diesel"
AND mpg = "64.2"
AND enginesize = 2
AND year = 2016
AND tax = 20;

--

--

--

Our passion is bringing thousands of the best and brightest data scientists together under one roof for an incredible learning and networking experience.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Cyclistic: Google Data Analyst Certificate Capstone Project

What’s New on Ai+ Training November 2020

Time Series Analysis: The Components That Define It

Principles of Predictive Analytics and the Path to Time-Series Predictions

Is Babel’s Data Tower Compatible With Centralized ML Solutions?

Outstanding Returns Using Sentiment Analysis to Predict Alphabet (Google) Stock Price

An interview with Kristian Ovaska — Valuemotive’s super data scientist

Hierarchical Bayesian Models in R

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
ODSC - Open Data Science

ODSC - Open Data Science

Our passion is bringing thousands of the best and brightest data scientists together under one roof for an incredible learning and networking experience.

More from Medium

CDS Assistant Professor Brian McFee Receives Steinhardt Teaching Excellence Award

Defining trustworthy AI

How to Create a Recommendation System with AI Blueprints

Newsletter #66 — Nvidia upgrades its Omniverse