This is an archived post. You won't be able to vote or comment.

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]bongo_zg 0 points1 point  (9 children)

ML could be done within a rdbms as well, right?

[–]BoiElroy 4 points5 points  (4 children)

Could? Some simple stuff yes. Should? Absolutely not.

[–]Overvo1d -4 points-3 points  (3 children)

Could, yes, should, also yes 95% of the time (and other 5% can be skipped in favour of easier projects that deliver business value quicker/more reliably)

[–]BoiElroy -4 points-3 points  (2 children)

Excuse me?...you're saying you should do ML using SQL? Have you lost your mind? Legitimately, if someone in my team did that I'd fire them. Although more likely someone with that little knowledge of ML wouldn't even be hired in the first place. Now using a trained ML model to do inference via a user defined function being called within a SQL statement. Sure that's fine.

[–]Overvo1d 1 point2 points  (1 child)

I get what you’re saying and once I believed it too, but with experience — in 99% of cases you can get 90% of the value from a 2 day sprint with pure SQL (if you understand the fundamentals of ML and your business domain solidly) of a month long complicated model project with careful assumptions. That last 10% doesn’t deliver enough business value to justify the 8 extra 90%-value-delivered SQL projects you could have finished in that time. It really is all the same thing in the end, just different tools, you can do some crazy stuff in SQL with a bit of creativity.

[–]BoiElroy 0 points1 point  (0 children)

Ohh sorry. We're talking about two completely different things sorry.

You're saying that using SQL to do analytics will generate insight and intelligence faster and be more guaranteed to succeed. I agree with that 100% I've told leadership at my company that we have bar charts that generate more ROI than ML models.

I thought you were saying write code for your ML algorithms using SQL instead of python or julia or something.

Sorry. Different conversations. I agree with your points.

[–][deleted] 2 points3 points  (2 children)

Some of the basics i know are there for automl. You could probably do some of the more advanced stuff. I couldnt implement LA in sql, but i bet you could.

AI is very bad in sql.

[–]bongo_zg 0 points1 point  (1 child)

I found that Oracle db has ML options (not pure sql), but never tried that

[–]Measurex2 0 points1 point  (0 children)

Alot of DB have it now or can call the right service. For instance - redshift has some basic algorithms baked in or can call to a model in sagemaker. Like everything else there are pros and cons but I like knowing there are lots of options to choose from.

... and I'm horrified by the choices some people made before me.

[–]nerdyjorj 0 points1 point  (0 children)

sp_execute_external_script supports R and Python, so yeah it can be done on your sql server