Interested to Buy Any Domain ? << Click Here >> for more details...
what is Materialized Views?
- 2 Answers
- 7470 Views
- Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Name at least three brands of Database Management Systems
What are cluster analysis in data warehousing?
Explain about core dimension,
What needs to be done when the database is shutdown?
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
what is the difference between aggregate table and fact table ? how do you load these two tables ?
How to define a cube??
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Tell me one example for junk dimension?
What is the difference between Datawarehouse and OLAP?
Explain what is a three tier data warehouse?
What is data analysis?
Teradata 
