Foilset Search Full Index for Basic foilset

First Part (Motivation, Theory) of Parallel Relational Databases

Given by Gang Cheng Marek Podgorny Chao-Wei Ou at ARL Database Tutorial on February 98. Foils prepared 7 October 97

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

There are two types of foils -- html and image which are each available in basic and JavaScript enabled "focused" style
(basic:)(focus style:) Denote Foils where Image Critical
(basic:)(focus style:) Denote Foils where HTML is sufficient
1 Parallel Relational Database Management Systems -- I
2 Abstract of Parallel Relational Database Management Systems -- I
3 Outline of Full Database Presentation
4 Section I:
Parallel Database Technology in Commercial Applications and Industry
5 Motivations for Parallel Databases -- I:
Overview of Parallel Database Appeal
6 Motivations for Parallel Databases -- II:
Inadequacies with Current Mainframe Solutions
7 Motivations for Parallel Databases -- III:
Commercial versus Scientific Applications
8 Motivations for Parallel Databases -- IV:
Market Demand from Competitiveness
9 Application Areas for Parallel Database: commercial, administration, scientific
10 General Classes of Commercial Applications
11 An Application Example ---
Intelligent Business systems
1)Objectives
12 Intelligent Business systems ---
2)Typical Questions
13 Intelligent Business systems ---
3) Major Technology Challenges
14 Intelligent Business systems ---
4) Solutions
15 Major Software and Hardware vendors in Parallel Database Technology
16 Some Current Major Commercial Users
17 Parallel Database Technology and Theory
18 Hardware architectures for parallel DBMS
-- Generic System
19 Hardware Architectures and forms of Parallelism
20 Three (Hardware) architectures for parallel DBMS
21 Topological view of MP machines (with "Scalability" in mind)
22 Notes on Shared Nothing Architecture
23 Dataflow perspective
24 Parallelisms in parallel database systems
25 Data Partitioning --- How to divide data among multiple disks ?
26 Basic Data Partitioning Schemes
27 Major Approaches in Data Partitioning
28 Danger of Data Skew arises on
Shared Nothing with Data Partitioning
29 Pitfalls in data partitioning
30 Performance Metrics In Parallel Database Systems
31 Performance barriers
32 Some basic terminology for relational database model
33 Examples of Typical Relational Operations
34 Join Operation: a SELECT operation that combines rows from two or more tables. Each returned row contains data from more than one table
35 Overview of Structure Query Language (SQL)
36 Features of Structure Query Language (SQL)
37 Major RDBMS functionality
38 What is a 3GL or 4GL?
39 What is PL/SQL -- I ?
40 What is PL/SQL -- II?
41 What is PL/SQL -- III?
42 What is Data Integrity?
43 What are Schemes?
44 What are Roles?
45 What are Profiles and Auditing?
46 What are Two-phase Database Schema?
47 Example: Relational Joins
48 General Structure of Parallel and Sequential Relational Joins
49 Parallel Algorithm for Relational Joins
50 Parallel Database Software Architecture
Distributed Lock Manager
51 Parallel Database Software Architecture
Full WebWisdom URL and this Foilset Search
This contains all WebWisdom links preceded by those referenced in this foilset
© on Mon Oct 13 1997