8 ms·
The big thing in Aito is still, that it is 'modelless'. You don't need a prepared model to do a prediction, because the model is done ad hoc / lazily for the qu
by arauhala 6y ago
The big thing in Aito is still, that it is 'modelless'. You don't need a prepared model to do a prediction, because the model is done ad hoc / lazily for the query. It is a much easier workflow, because you don't need to care about the models and you can have very free format / templated queries like this:
predictCaseFieldForCustomer(customer, department, case, predictedField) {
return aito.query({
from: f'customer-$customer',
where: {
$on : [
{ case : case },
{ department : department }
]
},
predict : predictedField
})
}
- dvasdekis 6y agoYep, that's dependent and independent variables in a simple linear regression (SLR). Postgres has SLR built in. Madlib is an extension to Postgres that does much more.
- arauhala 6y agoPlease correct me if I'm mistake, but doesn't that require a separately prepared model in both Postgres and madlib? You cannot simply request for an arbitrary prediction in a single & simple query.