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 : Distance between any two specified nodes

Is the shortest distance between any 2 specified nodes is given by minimum spanning tree?

Q : Report with several data providers Can

Can we have a report with several data providers?

Q : Data query and knowledge query Write

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

Q : Introduction of the term analysis

Give a brief introduction of the term analysis service?

Q : Main data structures Name the main data

Name the main data structures used in these areas: Hierarchical data model, RDBMS and Network data model?

Q : System R and its major subsystems

Illustrates the System R and its major subsystems?

Q : Steps for transforming an entity into a

Write down the steps for transforming an entity into a table?

Q : Keep informatica reject data Elucidate

Elucidate Where to keep informatica rejected data? How to remove the informatica rejected data?

Q : Tuple-oriented and domain-oriented

Differentiates Tuple-oriented relational calculus and domain-oriented relational calculus?

Q : Introduction of the term universe in SQL

Give a brief introduction of the term universe in SQL? Brief explain the kinds of universes in business objects?

Discover Q & A

Leading Solution Library

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

No hassle, Instant Access

Start Discovering

18,76,764

1922688
Asked

3,689

Active Tutors

1419835

Questions
Answered

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

Submit Assignment