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

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 CPS616 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 Notes on Shared Nothing Architecture
022 Shared-data Architecture
023 Shared Data Architecture
024 Note on Oracle nCUBE2 Hybrid Architecture
025 Topological view of MP machines (with ÒScalabilityÓ in mind)
026 Dataflow perspective
027 Parallelisms in parallel database systems
028 Data Partitioning --- How to divide data among multiple disks ?
029 Basic Data Partitioning Schemes
030 Major Approaches in Data Partitioning
031 Danger of Data Skew arises on 
    Shared Nothing with Data Partitioning
032 Pitfalls in data partitioning
033 Performance Metrics In Parallel Database Systems
034 Performance barriers
035 Some basic terminology for relational database model 
036 Examples of Typical Relational Operations
037 Join Operation: a SELECT operation that combines rows from two or 
    more tables. Each returned row contains data from more than one 
    table
038 Overview of Structure Query Language (SQL)
039 Features of Structure Query Language (SQL)
040 Major RDBMS functionality
041 What is a 3GL or 4GL?
042 What is PL/SQL -- I ?
043 What is PL/SQL -- II?
044 What is PL/SQL -- III?
045 What is Data Integrity?
046 What are Schemes?
047 What are Roles?
048 What are Profiles and Auditing?
049 What are Two-phase Database Schema?
050 Example: Relational Joins
051 General Structure of Parallel and Sequential Relational Joins
052 Parallel Algorithm for Relational Joins
053 Parallel Database Software Architecture
    Distributed Lock Manager
054 Parallel Database Software Architecture

Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu