DATABASE CLASSES - August 7

From: judith copler <copler_at_iuvax.cs.indiana.edu>
Date: Wed, 1 Jul 1992 17:20:27 EST
Message-ID: <1992Jul1.222040.1647_at_news.cs.indiana.edu>




|CENTER FOR DATABASE SYSTEMS -- INDIANA UNIVERSITY and PURDUE |
|UNIVERSITY |

                DATABASE WORKSHOPS FRIDAY - AUGUST 7, 1992 - INDIANAPOLIS, INDIANA 8:30AM - 4:30PM

The Physical Design and Optimization of Relational Databases

Objective: All participants should gain an understanding of when and why optimization is necessary, how to estimate disk space requirements, how to create effective indexes, how to effectively use denormalization and replication, how to effectively use primary keys and views, and how to verify physical design. Examples will focus on comparing and contrasting the usage of optimization techniques for commercial products such as DB2, Ingres, Oracle and Sybase.

Who should attend: Database applications programmers, database designers and administrators

Session I - Introduction: An Overview of Optimization

  1. Why is Optimization Necessary?
  2. Setting Optimization Goals
  3. Phases in Optimization
  4. Necessary Information for Optimization

Session II - Estimating Disk Space Requirements

  1. What Logical Spaces Should Be Included
  2. A Simple Formula for Early Approximation
  3. More Advanced Formulas

Session III - Effectively Using Indexes

  1. Types of Indexes
  2. Ordering Attributes of an Index
  3. Indexes and NULL Values
  4. Effect of Indexes on Queries
  5. Effect of Indexes on Inserts, Deletes and Updates
  6. General Rules

Session IV - Effectively Using Primary and Foreign Keys and Other Attributes

  1. Using A Logical or Generated Primary Key
  2. Replicating Foreign Keys
  3. Replicating Non-key Attributes

Session V - Effectively Splitting or Combining Tables

  1. Combining Tables
  2. Splitting Tables
  3. Using Views
  4. Using Materialized Views

Session VI - A Practical Bag of Tricks

  1. Examples

Session VII - Verifying a Physical Design Via Access Modelling

  1. Selecting Transactions to Model
  2. Points to Check During Modelling
  3. Automating the Modelling
  4. Vendor Tools

For more information contact:

Judith Copler
Director
Center for Database Systems
Indiana University
401 Lindley Hall
Bloomington, IN 47405

812-855-4890 Received on Thu Jul 02 1992 - 00:20:27 CEST

Original text of this message