EBK DATABASE SYSTEM CONCEPTS
EBK DATABASE SYSTEM CONCEPTS
7th Edition
ISBN: 9781260049268
Author: SILBERSCHATZ
Publisher: MCG COURSE
Question
Book Icon
Chapter 7, Problem 43E
Program Plan Intro

 Materialized view:

  • Materialized view is a database object that contains the result of a query.
  • It is mainly used for increasing application performance.
  • It is used for replicating data and to cache expensive queries in a data warehouse environment.

</PROGRAM-PLAN-INNTRO>

 Constraints on materialized views enforcing functional dependency:

  • The constraints on materialized view helps for increasing execution speed.
  • Materialized view is refreshed by the type of materialized view.
  • The constraints under materialized view should be normalized.
  • That means each dimension should be contained in one table.
  • Also, the joins between tables must be normalized or partially normalized.
  • Hence, there is a guarantee that each child side row joins with exactly one parent side row.
  • Hence, constraints on materialized view can be used for enforcing functional dependency.

Blurred answer
Students have asked these similar questions
Write a C program using embedded assembler in which you use your own function to multiply by two without using the product. Tip: Just remember that multiplying by two in binary means shifting the number one place to the left. You can use the sample program from the previous exercise as a basis, which increments a variable. Just replace the INC instruction with SHL.
using r language
r language
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr