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

Event Sourcing with Kafka in Go

Part 1 | In which we ponder why UI development gets…so…slow…so…quickly.

Integrate Prometheus and Grafana and also make their storage persistent …

Starting with a Solid Foundation (Coding Habits)

The biggest non-technical lesson that I have learned in my journey as a developer

Jupyter Notebook Shortcuts

Why Organizations are embracing OpenShift ?

Will we stop (re)writing code?

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

The great Python dataframe showdown, part 2: out-of-core processing with Vaex

IBM Data Virtualization Installation

DSC Croatia 2022

Logical Operations in Python?