Differentiation between view and materialized view

Write down the differentiation between view and materialized view?

View Complete Question

Comments & Conversion

Expert

Verified

View:

Tail raid data representation is offered through a view to access data from its table.
It has logical structure can’t take up space.
Alters get influenced in corresponding tables.

Materialized view:

Pre computed data perseveres in materialized view.
It has physical data space activity.
Alters will not get influenced in corresponding tables.

Related Questions in Database Management System

Q : Identify those statements are true

Identify those statements are true about a foreign key?

Q : Platform as a Service or PaaS-Cloud

Platform as a Service (PaaS): Here, a proper platform or an environment is provided for the development of applications as a service by the vendors to their customers. The development group can dev

Q : What is repository What is the

What is the repository?

Q : Sequence number in Data stage Explain

Explain how do you produce the Sequence number within the Data stage?

Q : Introduction of the term slowly

Provide a brief introduction of the term slowly changing dimensions (or SCD)?

Q : Illustrates each database must be in

Illustrates all databases should be in third normal form or not?

Q : ROLAP and MOLAP Explain the following

Explain the following term: a) ROLAP b) MOLAP

Q : Er diagram Consider a MOVIE database in

Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows: ¦ Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genre

Q : Report with several data providers Can

Can we have a report with several data providers?

Q : Extranet and an intranet Describe the

Describe the differences between an extranet and an intranet.

Discover Q & A

Leading Solution Library

Avail More Than 1458012 Solved problems, classrooms assignments, textbook's solutions, for quick Downloads

No hassle, Instant Access

Start Discovering

18,76,764

1952075
Asked

3,689

Active Tutors

1458012

Questions
Answered

Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!

Submit Assignment