Re: Snapshot too old

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 17 Oct 2006 13:58:14 -0700
Message-ID: <bf46380610171358t73b2a0ccoa2c98ff0e7abd254@mail.gmail.com>

On 10/15/06, Mladen Gogala <mgogala_at_verizon.net> wrote:
>
>
>
> OK, let me ignite a flame war between the Inmon fans and the Kimball fans:
> what is the difference between data mart and a data warehouse? How to
> decide between the two? How to define granularity for data mart and how to
> define granularity for data warehouse?

I'm caught between the two.

I prefer Inmon's architecture, but Kimball's books.

Kimball provides good tools, examples, etc in his books.

Inmon is hard to read. I do prefer his architecture however. That is, a DW is a repository of time series data. This is rarely queried by users, and is used to create DM that are used by users.

Different approches, Kimball's is easier to start small with however.

Inmon's requires more commitment up front, but is ultimately more flexible and powerful.

Sorry, no flames from me. :)

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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

Received on Tue Oct 17 2006 - 15:58:14 CDT