DATABASE CLASSES - August 7
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
- Why is Optimization Necessary?
- Setting Optimization Goals
- Phases in Optimization
- Necessary Information for Optimization
Session II - Estimating Disk Space Requirements
- What Logical Spaces Should Be Included
- A Simple Formula for Early Approximation
- More Advanced Formulas
Session III - Effectively Using Indexes
- Types of Indexes
- Ordering Attributes of an Index
- Indexes and NULL Values
- Effect of Indexes on Queries
- Effect of Indexes on Inserts, Deletes and Updates
- General Rules
Session IV - Effectively Using Primary and Foreign Keys and Other Attributes
- Using A Logical or Generated Primary Key
- Replicating Foreign Keys
- Replicating Non-key Attributes
Session V - Effectively Splitting or Combining Tables
- Combining Tables
- Splitting Tables
- Using Views
- Using Materialized Views
Session VI - A Practical Bag of Tricks
- Examples
Session VII - Verifying a Physical Design Via Access Modelling
- Selecting Transactions to Model
- Points to Check During Modelling
- Automating the Modelling
- 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