OLAP Option
The OLAP Option physically stores dimensionally aware cubes in the Oracle relational
database. These cubes are most frequently accessed using SQL, although a
22 | Chapter 1: Introducing Oracle
Java API is also supported. As of Oracle Database 11g, Oracle??™s optimizer recognizes
the levels within these cubes. As a result, any business intelligence tool that submits
SQL to an Oracle database can transparently take advantage of the improved performance
offered by deployment of this option. Refreshes of the values in these cubes
are now maintained similar to refreshing materialized views.
Data Mining Option
Since Oracle9i, popular data-mining algorithms have been embedded in the database
through the Data Mining Option and are exposed through a PL/SQL or Java
data-mining API. Data-mining applications that use these algorithms are typically
built using Oracle??™s DataMiner or using data-mining tools from Oracle partners such
as InforSense and SPSS. Algorithms available in the Data Mining Option for Oracle
Database 11g include Na??ve Bayes, Associations, Adaptive Bayes Networks, Clustering,
Support Vector Machines (SVM), Nonnegative Matrix Factorization (NMF),
Decision Trees, and Generalized Linear Models.
Pages:
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80