Re: Analytic SQL Book?
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_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
> -- (download link anchor is approximate location in the
> -- DB2 UDB Advanced Analytics for Business Intelligence, by Peter J.
> -- 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:
> Different version, same advice. :)