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

Can Snowflake schema be used in OLTP?

4 posters

Go down

Can Snowflake schema be used in OLTP? Empty Can Snowflake schema be used in OLTP?

Post  debdw Sun May 20, 2012 4:25 am

As in Star schema dimensional data is denormalized whereas in snow flake dimensional tables are normalized basing on business requirements.
In OLTP data is stored in normalised form.

Therefore is it possible to implement snowflake schema in OLTP environment? Yes or No? Justify.

debdw

Posts : 1
Join date : 2012-05-20

Back to top Go down

Can Snowflake schema be used in OLTP? Empty Re: Can Snowflake schema be used in OLTP?

Post  BoxesAndLines Mon May 21, 2012 9:18 am

This question makes no sense. You either are building an OLTP data model or a dimensional model. Snowflaking a dimensional model doesn't make it an OLTP model.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Can Snowflake schema be used in OLTP? Empty Re: Can Snowflake schema be used in OLTP?

Post  TheNJDevil Mon May 21, 2012 9:48 am

Why stop at a snowflaked model? Why not implement a star schema as a OLTP model? But, in the end, like BnL says, just because a DM is snowflaked, doesn't make it a OLTP. It's how you use it that will determine if it's OLTP.

TheNJDevil

Posts : 68
Join date : 2011-03-01

Back to top Go down

Can Snowflake schema be used in OLTP? Empty Re: Can Snowflake schema be used in OLTP?

Post  craigbert Mon May 21, 2012 10:25 am

Like the other posters have said it depends on what you are using it for.

Consider a budget application. You need all this financial information rolled up along a variety of levels. A normalized model for that would not perform very well, but a star schema that can be updated handles this sort of need nicely.

The same would be true for a forecasting system for products.
craigbert
craigbert

Posts : 1
Join date : 2012-05-21
Location : Texas

http://www.mysoftforge.com

Back to top Go down

Can Snowflake schema be used in OLTP? Empty Re: Can Snowflake schema be used in OLTP?

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