Re: Analytic SQL Book?

From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Tue, 29 Sep 2009 15:45:33 -0500 (CDT)
Message-ID: <ba3c7aba8a47f3a25f31ef57031a4158.squirrel_at_society.servebeer.com>

A few years ago, I wanted to plot out linear regression for forecasting table growth, so I used the fun MODEL analytic. And since there's no way I'd ever remember how I did that, I documented my research in the query:

• Oracle Database Data Warehousing Guide
• 10g Release 1 (10.1)
• Part Number B10736-01
• Chapter 22: SQL for Modeling, "Example 5 Calculating Using Regression"
• http://download-east.oracle.com/docs/cd/B14117_01/server.101/b10736/sqlmodel.htm#sthref1830
• (download link anchor is approximate location in the document)
  --
  
• DB2 UDB Advanced Analytics for Business Intelligence, by Peter J. Hass
• http://www.almaden.ibm.com/cs/people/peterh/b15.pdf

The DB2 guide has several excellent 1-page template-type example queries that translated easily (if needed) to Oracle.

> The best in terms of documentation is the Data Warehouse Guide: > http://download.oracle.com/docs/cd/B28359_01/server.111/b28313/analysis.htm#i1007779

Different version, same advice. :)

Rich

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 29 2009 - 15:45:33 CDT