Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is the differences between star and snowflake schemas?
What is Active Datawarehousing?
Explain what is the extension of file to save template?
What is the difference between power center and power mart?
What are the different problems that ?Data mining? can solve?
How can you import tables from a database?
Explain normalization?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
Explain the versions of reportnet?
Explain what are the advantages of query studio compared to report studio?
Explain can report net connect multiple datasource at a time in report creation time?
What are the advantages of cold fusion?
how much memory space occupied real time project (roughly)?
Explain what is a view as it relates to system modeling?
What are situations where snowflake schema is better than star schema when the opposite is true?
