Re: Analytic SQL Book?
- From: Jared Still <jkstill@xxxxxxxxx>
- To: rjoralist@xxxxxxxxxxxxxxxxxxxxx
- Date: Wed, 30 Sep 2009 09:47:57 -0700
Thanks Rich, that DB2 paper is very cool!
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
On Tue, Sep 29, 2009 at 1:45 PM, Rich Jesse <rjoralist@xxxxxxxxxxxxxxxxxxxxx
> wrote:
> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
