Re: analytics reference

From: Karl Arao <karlarao_at_gmail.com>
Date: Tue, 12 Aug 2014 23:50:43 -0500
Message-ID: <CACNsJndvfVKbfm5=6hAbGkKviCBSe7zxgvkQ_U8sz_aaB0tdtQ_at_mail.gmail.com>

I find this informative
http://infolab.stanford.edu/infoseminar/archive/SpringY2000/speakers/agupta/paper.pdf or you can just google "Analytic Functions Srikanth Bellamkonda" you can find related materials/patents

here's 12c - Analytic SQL in 12c
http://www.oracle.com/technetwork/database/bi-datawarehousing/wp-in-database-analytics-12c-2132656.pdf

Connor's presentation http://www.slideshare.net/hamcdc/sep13-analytics

the window functions chapter on the SQL pocket guide is good too http://www.amazon.com/SQL-Pocket-Guide-Reference-OReilly-ebook/dp/B0043D2E40 , and Jonathan referenced another book on this thread as well

There's also an Oracle module - Analytic SQL for Data Warehousing D52496GC10

On Tue, Aug 12, 2014 at 10:09 AM, Adric Norris <landstander668_at_gmail.com> wrote:

> Can anyone recommend a good reference (preferably with lots of examples)
> on the use of Oracle analytic functions? It tends to be something of a
> struggle whenever I use the beasties, and I'd like to get my head wrapped
> around them a bit better.
>
> Thanx!
>
> --
> "In the beginning the Universe was created. This made a lot of people very
> angry and has been widely regarded as a bad move." -Douglas Adams
>

-- 
Karl Arao
Blog: karlarao.wordpress.com
Wiki: karlarao.tiddlyspot.com
Twitter: _at_karlarao <http://twitter.com/karlarao>

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

Received on Wed Aug 13 2014 - 06:50:43 CEST