Materialized views can be managed through Oracle Enterprise Manager (see also
Chapter 5). The SQL Advisor accessible in Enterprise Manager includes a SQL
Access Advisor that can recommend when to create materialized views.
Analytics, OLAP, and Data Mining in the Database
Analysis of large data sets is faster when it takes place in the database where the data
is stored. This section describes the database functions and other features available
for analytics and statistics, online analytical processing (OLAP) multidimensional
deployment choices, and data mining.
It is worth noting here that the growing use of Oracle for statistical computations led
to support for floating-point number types providing the precision outlined in the
IEEE 754-1985 standard (with minor differences). These are provided in the
datatypes BINARY_FLOAT and BINARY_DOUBLE in Oracle Database 10g and
more recent database releases.
Analytic and Statistical Functions
Oracle releases dating back to Oracle8i have continued to add new analytic and
statistical functions as SQL extensions to the core Oracle Enterprise Edition and
Standard Edition databases.
Pages:
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514