数据库原理（双语）邓绪斌-1（P39）Chapter06.pptVIP

6.4 Views 1. Creating a View (CREATE VIEW) 2. Removing a View (DROP VIEW) 3. View Resolution 4. Restrictions on Views 5. View Updatability 6. WITH CHECK OPTION 7. Advantages and Disadvantages of Views (不讲) 8. View Materialization 6. WITH CHECK OPTION Rows exist in a view because they satisfy WHERE condition of defining query (行出现在视图中，是因为它满足视图定义中的WHERE条件) . If a row changes and no longer satisfies condition, it disappears from the view (修改视图中的行，使之不满足视图定义中的WHERE条件，该行将从视图中消失). New rows appear in the view when insert/update on table cause them to satisfy WHERE condition (修改视图外的行，使之满足视图定义中的WHERE条件，或者向定义视图的基础表插入满足视图定义中WHERE条件的行，该行将出现在视图中). Rows that enter or leave a view are called migrating rows(进入或离开视图的行称为：迁移行). WITH CHECK OPTION prohibits a row migrating out of the view(禁止通过视图使行迁移出视图：通过视图修改视图中的行，使之不再属于视图). CREATE VIEW … AS subselect [WITH CHECK OPTION] 6. WITH CHECK OPTION Example 6.6 - WITH CHECK OPTION CREATE VIEW Manager3Staff AS SELECT * FROM Staff WHERE branchNo =B003 WITH CHECK OPTION; Cannot update branchNo of row from B003 to B002, as this would cause row to migrate out of view. UPDATE Manager3Staff SET branchNo = B002 -- rejected Cannot insert a row into view with a branch number that does not equal B003. INSERT INTO Manager3Staff VALUES(S123, A, B , Assistant, F, 57-1-1, 9000, B001) -- rejected Staff staffNo fName lName position sex DOB salary branchNo 6.4 Views 1. Creating a View (CREATE VIEW) 2. Removing a View (DROP VIEW) 3. View Resolution 4. Restrictions on Views 5. View Updatability 6. WITH CHECK OPTION 7. Advantages and Disadvantages of Views (不讲) 8. View Materialization 6.4 Views 1. Creating a View (CREATE VIEW) 2. Removing a View (DROP VIEW) 3. View Resolution 4. Restrictions on Views 5. View Updatability 6. WITH CHECK OPTION 7. Advantages and Disadvantages of Views (不讲) 8. View Materialization 8. View Materialization(视图物化) View resolution may b