what is Materialized Views?

Answers were Sorted based on User's Feedback



what is Materialized Views?..

Answer / rameshbabu.katikireddy

In literature on data warehousing are created in Oracle using a schema object called a materialized view. Materialized views can be used to perform a number of roles, such as improving query performance or providing replicated data, as described below.

In data warehouses, materialized views can be used to recompute and store aggregated data such as sum of sales. Materialized views in these environments are typically referred to as summaries since they store summarized data. They can also be used to recompute joins with or without aggregations. So a materialized view is used to eliminate overhead associated with expensive joins or aggregations for a large or important class of queries.
Posted by
Rameshbabu.katikireddy
Time:jan.11.2012,6:20pm
Contact09767696346
Karimnagar

Is This Answer Correct ?    3 Yes 1 No

what is Materialized Views?..

Answer / vr

A materialized view is a database object that contains the results of a query. For example, it may be a local copy of data located remotely, or may be a subset of the rows and/or columns of a table or join result, or may be a summary based on aggregations of a table's data.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

Explain a linked cube?

0 Answers  


What are universe requirements?

0 Answers  


What is a Data Warehouse?

9 Answers  


I have two universes created by two difference database can we join them in designer & report level? How

0 Answers  


explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I

3 Answers   IBM, Ness Technologies,






What is factless fact tables?

0 Answers  


What is called dimensional modelling?

0 Answers  


What is Snow Flake Schema design in database?

3 Answers  


Can you brief about the Data warehouse project you worked on?

0 Answers   Deloitte, TCS,


Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

0 Answers  


What is metadata in context of a datawarehouse?

0 Answers  


What is metadata in context of a datawarehouse and how it is important?

0 Answers  


Categories