Differentiation between view and materialized view

+44 141 628 6080
[email protected]

--%>

Differentiation between view and materialized view

Write down the differentiation between view and materialized view?

View Complete Question

Comments & Conversion

E

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 : 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 : Dashboard in the business intelligence

Briefly explain the Dashboard in the business intelligence?

Q : Data query and knowledge query Write

Write down some of the differences between the data query and the knowledge query.

Q : Define the market structures and price

Define the market structures and price output determination in words of Clark and Clark.

Q : How a scenario is employed for business

Describe how a scenario is employed for business rule?

Q : Disadvantages of using Alias Write out

Write out the disadvantages of using the Alias?

Q : Target Types on the Server Write down

Write down the Target Types on the Server?

Q : Sequence number in Data stage Explain

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

Q : Utilization of data warehousing and

State some of the sectors where the data warehousing and data mining are utilized.

Q : Aggregate transformation Describe

Describe briefly Aggregate transformation?

Discover Q & A

Leading Solution Library

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

No hassle, Instant Access

Start Discovering

18,76,764

1946579
Asked

3,689

Active Tutors

1420848

Questions
Answered

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

Submit Assignment