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

Limitations of ER modelling while modelling a dwh

3 posters

Go down

Limitations of ER modelling while modelling a dwh Empty Limitations of ER modelling while modelling a dwh

Post  bharadwaj.uma@gmail.com Sun Jan 30, 2011 1:33 pm

Could anyone help me out of Limitations of ER modelling when used for modelling data in a dwh

bharadwaj.uma@gmail.com

Posts : 1
Join date : 2011-01-30

Back to top Go down

Limitations of ER modelling while modelling a dwh Empty Re: Limitations of ER modelling while modelling a dwh

Post  BoxesAndLines Sun Jan 30, 2011 3:18 pm

There are none I can think of.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Limitations of ER modelling while modelling a dwh Empty Re: Limitations of ER modelling while modelling a dwh

Post  ngalemmo Mon Jan 31, 2011 4:48 pm

The downside is query performance. Those who subscribe to the Inmon approach to a data warehouse, that is, maintaing a somewhat 3NF data repository of all data, do not (or should not) allow end-user access to the repository for data analysis queries. There are two reasons for this: 1, the schema tends to be overly complex and difficult to use, and 2, massive queries run for a very long time. Inmon recommends that end-user accessible data be published in the form of data marts (usually dimensional, usually aggregate - star schema or cubes) or other data extracts for consumption.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Limitations of ER modelling while modelling a dwh Empty Re: Limitations of ER modelling while modelling a dwh

Post  BoxesAndLines Wed Feb 02, 2011 12:00 pm

Ahh, when someone says ER-modeling, that doesn't imply dimensional or normalized data models.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Limitations of ER modelling while modelling a dwh Empty Re: Limitations of ER modelling while modelling a dwh

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