3 ms·
Google Clouds big query has an option for defining ml models in sql. R can deploy several models as sql queries. MSSQL also has options for this.
by wodenokoto 6y ago
Google Clouds big query has an option for defining ml models in sql.
R can deploy several models as sql queries.
MSSQL also has options for this.
- arauhala 6y agoThe 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.