MFRDB07

DATES:

1. Introduction
   • Examine the concepts and terminology of Db2 relational database design.
   • Examine and expand upon the concepts specific to the environment of the client organizations represented by the students in the class.
   • The concepts and terminology of the three models of database systems.
2. Relational Model
   • Create a relational model.
   • Given a simple business application, design the entities that would solve the business problem using the relational model.
3. Db2 Architecture
   • Acquire familiarity with the architecture around the address space.
   • Appreciate the flow of control among Database Services Address Space, System Services Address Space, Intersystem Resource Lock Manager, Distributed Data Facility, and Stored Procedure Address Space.
4. Database Design: Synthetic Approach
   • Create a design using the synthetic approach.
   • Given a simple business application, design the keys using the synthetic approach.
5. Database Design: Analytic Approach
   • Create a design using the analytic approach.
   • Given a simple business application, design the keys using the analytic approach.
6. Other Design Topics
   • Implement optimum performance for Db2 databases in their environment.
   • Acquire proficiency with commits and batch programs.
   • Implement performance for SQL and applications with Data Access and EXPLAIN and the Db2 Optimizer and Program BIND Options.
7. Table and View Design
   • Create a design for all the entities and associations.
   • Case study which incorporates topics from previous exercises.
8. General Efficiency Techniques
   • Apply the efficiency techniques to redesign the entities and associations.
   • The results from the previous exercises are used.
9. Factors Affecting Performance
   • Column types and their impact on performance.
   • Design tables for performance.
10. EXPLAIN Statement
    • Examine the effect of various SELECT statements on the access path.
    • Instructor will provide the table and queries.
    • Queries will be processed through the EXPLAIN statement.
11. Tuning Strategy
    • Become familiar with a system wide perspective of Db2 and applications.
    • Create a strategy for tuning a set of SQL application design and table statistics.
12. Recovery and Security
    • Examine how security has evolved from protecting the network perimeter to protecting data at the source.
    • Learn how perimeter security is no longer effective in an age when data access models designed only for employees now extends to partners, vendors, and customers.
    • Instructor to provide examples and the case study.