Hybrid Architecture

View previous topic View next topic Go down

Hybrid Architecture

Post  niranjan on 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

View user profile

Back to top Go down

Re: Hybrid Architecture

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

hybrid architecture

Post  niranjan on 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

View user profile

Back to top Go down

Re: Hybrid Architecture

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Hybrid Architecture

Post  niranjan on Thu Jul 17, 2014 3:26 am

Thanks nick

niranjan

Posts : 4
Join date : 2014-07-10

View user profile

Back to top Go down

Re: Hybrid Architecture

Post  BoxesAndLines on Thu Jul 17, 2014 10:01 am

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

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

View user profile

Back to top Go down

Re: Hybrid Architecture

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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