satyaneerumalla

 Profile Answers by satyaneerumalla Questions by satyaneerumalla

• Aug 28th, 2006

 

Hi friend,

please elaborate what do you mean by materialized view.

Then i think i can help you to clear your doubt.

mail me at satya.neerumalla@tcs.com

satyaneerumalla

 Profile Answers by satyaneerumalla Questions by satyaneerumalla

• Sep 5th, 2006

 

A materialized view provides indirect access to table data by storing the results of a query in a separate schema object unlike an ordinary view, which does not take up any storage space or contain data.
Materialized views are schema objects that can be used to summarize, precompute, replicate, and distribute data. E.g. to construct a data warehouse.

The definition of materialized view is very near to the concept of  Cubes where we keep summarized data. But cubes occupy space.

Coming to datamart that is completely different concept. Datawarehouse contains overall view of the organization. But datamart is specific to a subjectarea like Finance etc...

we can combine different data marts of a compnay to form datawarehouse or we can split a datawarehouse into different data marts.

calltomadhu

 Profile Answers by calltomadhu 

• Sep 23rd, 2006

 

hi

view direct connect to table

it wont contain data and what we ask it will fire on table and give the data.

ex: sum(sal).

materilized view are indirect connect to data and stored in separte scheema. it is just like cube in dw. it will have data. what ever we ask summerised information it will give and stores it. when ever we ask next time it will directly from here itself.

performance wise this view are faster than normal view.