| Team Fly | |
Hardware 2001-02 306 587 Hardware 2001-03 442 1029 Hardware 2001-04 439 1468 Hardware 2001-05 413 1881 Hardware 2001-06 429 2310 Peripherals and Accessories 2001-01 5439 5439 Peripherals and Accessories 2001-02 5984 11423 Peripherals and Accessories 2001-03 5104 16527 Peripherals and Accessories 2001-04 5619 22146 Peripherals and Accessories 2001-05 4955 27101 Peripherals and Accessories 2001-06 5486 32587 Photo 2001-01 2802 2802 Photo 2001-02 2220 5022 Photo 2001-03 2982 8004 Photo 2001-04 2824 10828 Photo 2001-05 2359 13187 Photo 2001-06 3225 16412
As you can see in the results, the moving sum is contained within each product category and resets when a new product category starts. In the past, windowing analysis used to require third-party products such as spreadsheet applications. Having the capabilities to perform these functions right in the database can streamline analysis and report generation efforts.
There are many other functions included with Oracle Database 10g that can be used to analyze data in large databases. While we will not be going into any detail for these, they are listed here for completeness:
Statistical functions, including:
Linear regression functions
Descriptive statistics functions
Hypothetical testing and crosstab statistics functions
(contained a new PL/SQL package called dbms_statistics)
first/last functions
lag/lead functions
Reporting aggregate functions
Inverse percentile functions
Hypothetical rank and distribution functions
| Team Fly | |