Example MODEL usages include calculating sales differences in two
geographies, calculating percentage change, and calculating net present value. The
SQL MODEL clause can also use simultaneous equations and regression in
calculations.
OLAP and Data Mining Capabilities
For stored cubes (objects with predefined multidimensional joins), facts, and dimensions
in the relational database, Oracle introduced the OLAP Option to the Oracle9i
database. OLAP database capabilities are most commonly accessed althrough SQL,
though there is also a Java API. Oracle Database 11g added support for OLAP SQL
query rewrite.
As an OLAP alternative, Oracle now offers a technology that is relational databaseagnostic:
Essbase, from Hyperion (acquired by Oracle in 2007) is an OLAP engine
that can extract data from Oracle and other databases. This OLAP solution is especially
popular for Hyperion??™s financial applications and in cases where business
Analytics, OLAP, and Data Mining in the Database | 235
analysts want to generate their own cubes. Essbase cubes can also be accessed using
Oracle Business Intelligence Enterprise Edition (OBI EE) tools.
Pages:
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517