New Oracle Statistical Functions Page

OTN has a new page (link) describing the statistical functions in the Oracle 10g Database. These functions are available in all versions of the database at no extra cost. Features include:

  • Descriptive statistics
  • Hypothesis testing
  • Correlations analysis (parametric and nonparametric)
  • Ranking functions
  • Cross Tabulations with Chi-square statistics
  • Linear regression
  • ANOVA
  • Test Distribution fit
  • Window Aggregate functions
  • Statistical Aggregates
  • Pareto analysis
  • LAG/LEAD functions
  • Reporting aggregate functions

These statistical functions are also very scalable. In fact, I have heard that some companies are using these functions to compute statistics on massive amounts of data that cannot be handled by traditional statistical tools. Check it out!

Posted on February 12, 2007 .