Analytical SQL Promises Portability
Oracle Analytical SQL continues to develop beyond the built-in statistical routines it has had embedded in the Database Product since 8i with many new advances in the 12c release series including several algorithms supporting Predictive Analytics and Data/Text Mining.
Built-in SQL Analytics, that is using extensions of the SQL language to handle descriptive statistics, hypothesis testing and predictive analytical algorithms and more provides an avenue in which there is less need for expensive separate analytical servers, special language coding and multiple BI source code management.
Oracle SQL Analytics that are developed are submitted continually for ANSI SQL Standards inclusion. Since most SQL Database vendors strive to support ANSI Standard SQL portability of code becomes more possible. Most Business Intelligence (BI) Apps and servers support proprietary coding structures and interfaces.
ANSI Analytical SQL when more available across DBMS vendors will help to make Analytical Processes and Procedures more highly portable, code efficient and cost effective.
For more information on the ANSI SQL 99 Standard that supports Analytical SQL visit references below -
IBM
https://www-01.ibm.com/support/knowledgecenter/SSULQD_7.1.0/com.ibm.nz.dbu.doc/c_dbuser_ntz_sql_analytic_funcs.html
HP
http://my.vertica.com/docs/6.0.x/HTML/index.htm#11092.htm
Book -Joe Celko's Analytics and OLAP in SQL
https://books.google.com/books?id=fvE2We_ehL8C&dq=celko+oracle+ansi+sql+99+standard+analytics&source=gbs_navlinks_s
Oracle
http://ss64.com/ora/syntax-analytic.html
<< Home