Find this at http://www.npac.syr.edu/users/gcf/arldatabase/arlparrdbms1fall97/

First Part (Motivation, Theory) of Parallel Relational Databases

This presentation contains the first two sections Parallel Database Technology in Commercial Applications and Industry Parallel Database Technology and Theory

Of the full ARL Parallel Database Module

The first section sets the scene by motivating the need for paraalel databases while

The second section reviews both Sequentional and Parallel Relational Databases looking at explicit examples nCUBE and SP2 with Oracle and DB2

We also discuss database system architectures and review

The SQL Query language

Table of Contents for First Part (Motivation, Theory) of Parallel Relational Databases

001 Parallel Relational Database Management Systems -- I
002 Abstract of Parallel Relational Database Management Systems -- I
003 Outline of Full Database Presentation
004 Section I: 
    Parallel Database Technology in Commercial Applications and 
    Industry
005 Motivations for Parallel Databases -- I:
    Overview of Parallel Database Appeal
006 Motivations for Parallel Databases -- II:
    Inadequacies with Current Mainframe Solutions
007 Motivations for Parallel Databases -- III:
    Commercial versus Scientific Applications
008 Motivations for Parallel Databases -- IV:
    Market Demand from Competitiveness
009 Application Areas for Parallel Database: commercial, 
    administration, scientific
010 General Classes of Commercial Applications
011 An Application Example ---
    Intelligent Business systems
    1)Objectives
012 Intelligent Business systems  ---
    2)Typical Questions
013 Intelligent Business systems ---
    3) Major Technology Challenges 
014 Intelligent Business systems ---
    4) Solutions
015 Major Software and Hardware vendors in Parallel Database 
    Technology
016 Some Current Major Commercial Users
017 Parallel Database Technology and Theory
018 Hardware architectures for parallel DBMS
    -- Generic System 
019 Hardware Architectures and forms of Parallelism
020 Three (Hardware) architectures for parallel DBMS 
021 Topological view of MP machines (with "Scalability" in 
    mind)
022 Notes on Shared Nothing Architecture
023 Dataflow perspective
024 Parallelisms in parallel database systems
025 Data Partitioning --- How to divide data among multiple disks ?
026 Basic Data Partitioning Schemes
027 Major Approaches in Data Partitioning
028 Danger of Data Skew arises on 
    Shared Nothing with Data Partitioning
029 Pitfalls in data partitioning
030 Performance Metrics In Parallel Database Systems
031 Performance barriers
032 Some basic terminology for relational database model 
033 Examples of Typical Relational Operations
034 Join Operation: a SELECT operation that combines rows from two or 
    more tables. Each returned row contains data from more than one 
    table
035 Overview of Structure Query Language (SQL)
036 Features of Structure Query Language (SQL)
037 Major RDBMS functionality
038 What is a 3GL or 4GL?
039 What is PL/SQL -- I ?
040 What is PL/SQL -- II?
041 What is PL/SQL -- III?
042 What is Data Integrity?
043 What are Schemes?
044 What are Roles?
045 What are Profiles and Auditing?
046 What are Two-phase Database Schema?
047 Example: Relational Joins
048 General Structure of Parallel and Sequential Relational Joins
049 Parallel Algorithm for Relational Joins
050 Parallel Database Software Architecture
    Distributed Lock Manager
051 Parallel Database Software Architecture