Re: Analytic SQL Book?
Date: Tue, 29 Sep 2009 15:45:33 -0500 (CDT)
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"
- (download link anchor is approximate location in the document)
- DB2 UDB Advanced Analytics for Business Intelligence, by Peter J. Hass
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. :)
http://www.freelists.org/webpage/oracle-l Received on Tue Sep 29 2009 - 15:45:33 CDT