Re: Analytic SQL Book?

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 30 Sep 2009 09:47:57 -0700
Message-ID: <bf46380909300947o6ad3e284lb24e4f44d2754508_at_mail.gmail.com>

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_at_society.servebeer.com
> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 30 2009 - 11:47:57 CDT