Business Intelligence Features -
Analysis Oracle Database 11g continues
a tradition of innovation and leadership in database analytical
features. The SQL PIVOT operator introduced in Oracle Database
11g enhances performance and simplicity of a central
data manipulation task. The revolutionary SQL MODEL clause introduced
in Oracle Database 10g enables a whole new level of
advanced analysis. Oracle Database 10g also added Frequent
Item Sets analysis, useful for data mining, and Regular Expression
support for more powerful searching. Oracle's CONNECT BY clause,
enhanced in 10g, supports hierarchical queries. The
SQL analytic functions introduced in Oracle 8i Release
2 enable moving window calculations such as cumulative sums
and rolling averages. Oracle provides the richest analytic platform
of any database.
Technical
Information
The SQL Model Clause of Oracle Database 10g (PDF)
Oracle Database 10g's groundbreaking SQL MODEL
clause handles query results as virtual multidimensional
arrays and processes the data with sets of interdependent
formulas. The feature simplifies application development
and maintenance and improves performance. This white paper
gives a detailed description of the new clause.
Announcing the New MODEL (HTML - Oracle Mag.)
This concise article introduces the SQL MODEL clause through
a sales forecasting case study. It provides a quick introduction
to the power of SQL MODEL.
Frequent Itemsets in Oracle Database 10g (PDF)
Frequent Itemsets analysis is a widely useful technique
to find what events or characteristics tend to be grouped
together. It can add value in applications from sales
analysis to genetics studies. Oracle Database 10g
introduces optimized support for frequent itemsets processing
.
SQL Aggregation for Business Intelligence in Oracle Database
10g
An overview of Oracle's SQL aggregation features supporting enterprise-scale BI: extensions
to SQL's GROUP BY clause, SQL functions to distinguish
among aggregate groups, and integration with materialized
views.
Analytic
SQL Features in Oracle9i (PDF)
SQL enhancements in Oracle9i improve performance
and development productivity for complex analytic queries.
This paper covers analytic SQL functions such as moving
averages and cumulative sums, GROUP BY extensions and
query processing optimizations.
Bookmark
