Can Snowflake schema be used in OLTP?

View previous topic View next topic Go down

Can Snowflake schema be used in OLTP?

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

View user profile

Back to top Go down

Re: Can Snowflake schema be used in OLTP?

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

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

View user profile

Back to top Go down

Re: Can Snowflake schema be used in OLTP?

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

View user profile

Back to top Go down

Re: Can Snowflake schema be used in OLTP?

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

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

View user profile http://www.mysoftforge.com

Back to top Go down

Re: Can Snowflake schema be used in OLTP?

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


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