InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Are Materialized Views? |
|
Answer» These are schema objects that are used to summarize, compute, replicate, and distribute data. They can be used in various environments for computation such as data WAREHOUSING, decision support, and distributed or mobile computing and it ALSO provides local access to data RATHER than ACCESSING from remote sites. In data WAREHOUSES, MVs are used to compute and store aggregated data. These are schema objects that are used to summarize, compute, replicate, and distribute data. They can be used in various environments for computation such as data warehousing, decision support, and distributed or mobile computing and it also provides local access to data rather than accessing from remote sites. In data warehouses, MVs are used to compute and store aggregated data. |
|