Session Number: 1115
Track: 1-Advanced Analytics
Session Type: Product Feature
Primary Presenter: Brendan Tierney [. - Oralytics]
Time: Jan 26, 2016 (11:20 AM - 12:10 PM)
Session level: Introductory
Keywords: OAA/Oracle R Enterprise, Oracle Database, YesSQL!
Abstract (250 words or less):
Did you know that Oracle comes with over 280+ statistical functions? and that these statistical functions are available in all version of the Database? Most people do not seem to know this. When we hear about people performing statistical analytics we can hear them talking about Excel and R. But what if we could do statistical analysis in the database, without having to extract any data onto client machines. That would be really good and just think of the possible data security issues with using Excel, R and other tools. This presentation will explore the various statistical areas available in SQL and I will give a number of demonstrations on some of the more commonly used statistical techniques. With the introduction of Big Data SQL we can now use these same 280+ Oracle statistical functions on all our data including Hadoop and NoSQL. We can also greatly expand our statistical capabilities by using Oracle R Enterprise using the capabilities embedded in SQL.