Client/Server Databases

Client/Server is a data-centric concept, and the Client/Server Databases seminar is your answer to those issues surrounding the architecture, design and management of data in this distributed environment. Unlike monolithic architectures, the data supporting applications developed in the client/server model will originate from many diverse locations throughout the organization, and is stored in a variety of formats. The implications of this are profound and immediate for any decision support system (DSS), on-line analytical processing (OLAP) or on-line transaction processing (OLTP) system.

Client/Server Databases will provide analysis of the data issues surrounding client/server and how to implement a realistic strategy. Additionally, attendees will gain a keen understanding of the technology behind data servers and the many different platforms and support levels required to manage them. Finally, the tools available to the development and support organization are reviewed and evaluated for ease of comparison.

WHO SHOULD ATTEND

This course is for staff with database management and development responsibility in organizations implementing a client/server architecture. Managers, analysts, DBAs, DAs and programmers will all benefit from a thorough overview of client/server database design, architecture, management, services and technology discussions.

PREREQUISITES

Although this seminar has no prerequisites, it would be beneficial for the attendee to have an understanding of basic client/server concepts. For more information, refer to the Introduction to Client/Server Computing seminar outline.

SEMINAR LENGTH

2 days

SEMINAR OUTLINE

1. Introduction

A. Client/Server Redefined
B. Distribution of Process, Data & Transaction
C. The State of the Technology
D. Data Management & Services
E. Database Design
F. Analysis & Design Methodologies
G. Tool Reviews

2. Client/Server Database Technology

A. Procedural Objects: Stored Procedures and Triggers
B. Database Trends
C. File Serving vs. Intelligent Data Serving
D. Data Server Essentials
E. Data Integrity: Centralized Management
F. Logical Unit of Work
G. Database Logging
H. Role of the Mainframe
I. Distribution Architectures
J. Major Database Software Vendors
K. The Future: RDBMS vs. OODBMS

3. Database Servers and Services

A. The Relational Model
B. Structured Query Language
C. Stored Procedures
D. Triggers
E. Default Rules
F. Client/Server Data Distribution Alternatives
G. Data Distribution Strategies & Replication Technology
H. Client/Server Data Storage Alternatives
I. Transaction Control
J. Server Configuration Options
K. Concurrency and Consistency
L. Deadlock Resolution
M. Indexing
N. Major Vendors: Strengths and Weaknesses

4. Database Design

A. Getting a Sound Data Model
B. Translating the Logical Model to a Physical Model
C. Maintaining Both Models
D. Client/Server Database Schema
E. Implementing the Database with Performance in Mind
- Tuning for Performance
- Disk Configuration
- Memory Sizing and Management
- Disk Subsystem Requirements
- Table/Log Placement
- Denormalization
- Integrity Enables
F. Installing the Database and Support Infrastructure
- Backup/Recovery
- Disaster Recovery
G. Review of Tools
H. Logical Data Modeling
I. Physical Data Modeling
J. Procedural Object Repositories
K. Data Server Administration