Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

A materialized view is said to be refreshed when we make it consistent with changes to its underlying tables. The process of refreshing a view

A materialized view is said to be refreshed when we make it consistent with changes to its underlying tables. The process of refreshing a view to keep it consisten with changes to the underlying table is often referred to as view maintenance. Two questions to consider are
1. How do we refresh a view when an underlying table is modified? Tow issues of particular interest are how to maintain views incrementally, that is, without recomputing from scratch when there is a change to an underlying table' and how to mantian views in a distributed envrionments such as a data warehouse.
2. When should we refresh a view in response to a change to an underlying table.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Donald A. Carpenter Fred R. McFadden

1st Edition

8178088045, 978-8178088044

More Books

Students explore these related Databases questions