Making ML as easy as SQL — using a predictive database

{
"schema": {
"messages": {
"type": "table",
"columns": {
"content": { "type": "Text" }
}
}
}
}
curl -X PUT "https://$AITO_ENVIRONMENT.api.aito.ai/api/v1/schema" \
-H "x-api-key: $API_KEY" \
-H "content-type: application/json" \
-d@schema.json
curl -X POST \ https://$AITO_ENVIRONMENT.api.aito.ai/api/v1/_search \ -H "x-api-key: $API_KEY" \ -H "content-type: application/json" \ -d '{ "from": "messages" }'
curl -X POST \
https://$AITO_ENVIRONMENT.api.aito.ai/api/v1/data/messages/batch \
-H "x-api-key: $API_KEY" \
-H "content-type: application/json" \
-d '
[
{ "content": "Hello world" },
{ "content": "A second message" }
]'
curl -X POST \
https://$AITO_ENVIRONMENT.api.aito.ai/api/v1/_search \
-H "x-api-key: $API_KEY" \
-H "content-type: application/json" \
-d '{
"from": "messages"
}'
{
"offset": 0,
"total": 2,
"hits": [
{ "content": "Hello world" },
{ "content": "A second message" }
]
}

Using Statistical Reasoning

  • recommendations,
  • personalized search and
  • automatic tagging of products.
{
"from": "impressions",
"where": {
"session.user": "larry",
"product.id": {
"$and": [
{ "$not": "6409100046286" }
]
}
},
"recommend": "product",
"goal": {
"purchase": true
},
"limit": 5
}
{
"offset": 0,
"total": 41,
"hits": [
{
"$p": 0.38044899845646235,
"category": "104",
"id": "6408430000258",
"name": "Valio eila™ Lactose-free semi-skimmed milk drink 1l",
"price": 1.95,
"tags": "lactose-free drink"
},
{
"$p": 0.20982669270272708,
"category": "104",
"id": "6410405216120",
"name": "Pirkka lactose-free semi-skimmed milk drink 1l",
"price": 1.25,
"tags": "lactose-free drink pirkka"
},
{
"$p": 0.04097576026274742,
"category": "100",
"id": "6410405093677",
"name": "Pirkka iceberg salad Finland 100g 1st class",
"price": 1.29,
"tags": "fresh vegetable pirkka"
},
{
"$p": 0.04017592239308106,
"category": "108",
"id": "6415600501811",
"name": "Coca-Cola 1,5l soft drink",
"price": 2.49,
"tags": "drink"
},
{
"$p": 0.03593903693070478,
"category": "103",
"id": "6412000030026",
"name": "Saarioinen Maksalaatikko liver casserole 400g",
"price": 1.99,
"tags": "meat food"
}
]
}
  • Aito did create a recommendation model based on the query and the entire impression table,
  • And Aito used the query and the model to filter and score all product table contents.

The Applications

  • for process optimization
  • for internal tools and analytics
  • for prototypes and proof-of-concepts
  • and for MVPs and small productions settings

The Numbers

Aito benchmark for both the Splice and Spam dataset UCI repository
Aito estimated vs measured probabilities in the Spam dataset
Performance test with generated e-commerce data
15 minutes stress test impression count, query speed and througput

The Future

--

--

--

Aito.ai decision automation in the cloud. #ML for #nocode and #rpa operators.

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

Recommended from Medium

Deep Learning for Supply Chain Optimization | Using Automated Robots to Sort Packages

What Does a Machine Learning Engineer do? Roles, Responsibilities & Skills

Childhood Data Analysts

Blue Book for Bulldozers Competition Part 4 (Continued)— Thorough Analysis of Important Features II

Santander Customer Transaction Prediction — Case Study

A Hybrid Analytic Schema Using Snowflake DB and Looker — Chapter 1

The Data Driven Leader — Summary

Python Data Analysis | Early stage diabetes risk prediction

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
aito.ai

aito.ai

Aito.ai decision automation in the cloud. #ML for #nocode and #rpa operators.

More from Medium

Techniques for Data Collection

How to implement a visual search in no time

An old school car painted in pink

ML OPS with DB2: Manage and Score Python ML Models in IBM DB2

Data Overload Vol. 9