The database includes a statistics package, DBMS_STATS_FUNCS. Functions in the
statistics package support linear algebra, frequent itemsets, descriptive statistics,
hypothesis testing (T-test, F-test, Binomial test, Wilcoxon Signed Ranks Test, One-
Way ANOVA, Chi-square, Mann Whitney, Kolmogorov-Smirnov), crosstab statistics
(% statistics, chi squared, phi coefficient, Cramer??™s V, contingency coefficient, and
Cohen??™s kappa), and nonparametric correlation (Pearson??™s correlation coefficients,
and Spearman??™s and Kendall??™s).
MODEL Clause in SELECT
The SQL MODEL clause first appeared in Oracle Database 10g as an extension to
the SELECT statement. This clause enables relational data to be treated as multidimensional
arrays (much like spreadsheets) and is also used to define formulas for the
arrays, avoiding multiple joins and UNION clauses.
MODEL supports analytical queries that include prior-year comparisons and share
of ancestor, and it is particularly useful in budgeting, forecasting, and other statistical
applications.
Pages:
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516