Is Oracle SQL the best language for Statistics

    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.



    Independent Oracle Users Group
    330 N. Wabash Ave., Suite 2000, Chicago, IL 60611
    phone: 312-245-1579 | email: ioug@ioug.org

    Copyright © 1993-2017 by the Independent Oracle Users Group
    Terms of Use | Privacy Policy