Recap Materialized View
Virtual View
M.V. vs. V.V.
View Creation Example
Week 8: Worksheet
CSC 343 Winter 2021 University of Toronto Mississauga
March 18/19th, 2021
1
ISAM
B Trees
B+ Trees
2
Class Exercise!
Given the following B+ Trees, complete the following action:
a. Insert 40 into the B+ Tree below. 19 24 33
14
1*
4*
5*
8*
14*
16*
19*
20*
22*
24*
27*
29*
33*
34*
38*
39*
3
b. Delete 30 from the B+ Tree below. 30
21
59
7
42
4*
6*
7*
9*
15*
21*
23*
30*
33*
42*
46*
59*
62*
4