Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Hybrid Architecture

3 posters

Go down

Hybrid Architecture Empty Hybrid Architecture

Post  niranjan Thu Jul 10, 2014 12:05 am

Hi,

When do we use a hybrid model? i.e. a 3NF in EDW and dimensional data marts together? What would be the business scenarios?

thanks,
Niranjan

niranjan

Posts : 4
Join date : 2014-07-10

Back to top Go down

Hybrid Architecture Empty Re: Hybrid Architecture

Post  ngalemmo Thu Jul 10, 2014 8:50 am

It is an Inmon Architecture approach. It is not a 'hybrid'. This approach has its proponents and can be successful.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Hybrid Architecture Empty hybrid architecture

Post  niranjan Thu Jul 17, 2014 1:14 am

in DW Tool Kit Third Edition, Chapter 1, Page 9 -
Hybrid architecture is defined as the marriage of Kimbal and Inmon CIF architecture.
Basically EDW will be in 3NF but the data marts will be in dimensional form.


niranjan

Posts : 4
Join date : 2014-07-10

Back to top Go down

Hybrid Architecture Empty Re: Hybrid Architecture

Post  ngalemmo Thu Jul 17, 2014 2:21 am

Whatever. It is basically the architecture Inmon proposed over 20 years ago. His belief is an EDW should be a comprehensive repository built as a 3NF database. Users would not access the database directly, but rather data would be published into data marts. These may be dimensional models, cubes, data extracts, ect. Using the term 'hybrid' is a political one for those who don't want to admit they are implementing an Inmon architecture.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Hybrid Architecture Empty Re: Hybrid Architecture

Post  niranjan Thu Jul 17, 2014 3:26 am

Thanks nick

niranjan

Posts : 4
Join date : 2014-07-10

Back to top Go down

Hybrid Architecture Empty Re: Hybrid Architecture

Post  BoxesAndLines Thu Jul 17, 2014 10:01 am

LOL. They're trying to avoid Inmon's incessant need for trademarking data warehousing terms.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Hybrid Architecture Empty Re: Hybrid Architecture

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum