tailieunhanh - Lecture Database design, application development and administration - Chapter 10: Application development with views

Chapter 10 - Application development with views. This chapter shows you how to apply your query formulation skills to building applications with views. This chapter also emphasizes views as the foundation for building database applications. Before discussing the link between views and database applications, essential background is provided. You will learn the motivation for views, the CREATE VIEW statement, and usage of views in SELECT and data manipulation (INSERT, UPDATE, and DELETE) statements. | Chapter 10 Application Development with Views Welcome to Chapter 10 on application development with views Views are fundamental to application development: - Purpose of writing queries is to specify data for applications (forms, reports, batch processing) - View: a stored query with intelligent processing - Data requirements are important part of applications: user interface design and workflow important also but not covered in this course Objectives: - Understand motivation for using views - Write CREATE VIEW statements and stored queries (Access) - Apply rules to write updatable views especially multi table updatable views - Analyze data requirements of hierarchical forms and reports - Skills important for application development work and course assignments Outline Background Creating views and using views Processing queries that reference views Updatable views Data requirements for hierarchical forms Data requirements for reports Background: - What is a view? - Why use views? Creating and using views: - CREATE VIEW statement and stored queries in Access - Using views in queries Processing views: brief presentation of materialization and modification Updatable views: - What is it? - Single table - Multiple table: Access rules Hierarchical forms: - What are they? - Specification of data requirements for hierarchical forms - Conceptual background for Access lab chapter 5 Hierarchical reports - What are they? - Specification of data requirements for hierarchical reports What is a View? Derived table Behaves like a base table (virtual) with some restrictions for view usage in modification statements Stored query What is a view? - Derived table - Not just a subset of base tables: specify with a query - Query can be complex and even contain row summaries, not individual rows View behavior: - Use a view like a base table - Use a view in a query - Use a view in modification statements - Some restrictions especially on usage in modification statements Virtual - Seems to . | Chapter 10 Application Development with Views Welcome to Chapter 10 on application development with views Views are fundamental to application development: - Purpose of writing queries is to specify data for applications (forms, reports, batch processing) - View: a stored query with intelligent processing - Data requirements are important part of applications: user interface design and workflow important also but not covered in this course Objectives: - Understand motivation for using views - Write CREATE VIEW statements and stored queries (Access) - Apply rules to write updatable views especially multi table updatable views - Analyze data requirements of hierarchical forms and reports - Skills important for application development work and course assignments Outline Background Creating views and using views Processing queries that reference views Updatable views Data requirements for hierarchical forms Data requirements for reports Background: - What is a view? - Why use views? .