Basic Foilset Search HELP! * GREY=local Full Index for

LOCAL foilset First Part (Motivation, Theory) of Parallel Relational Databases

Given by Gang Cheng Marek Podgorny (Geoffrey Fox) at CPS600 Spring Semester on April 1995. Foils prepared July 6,1995
More Detail! * Foil Index from this file * See also color IMAGE

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

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

List of WebWisdom URL's Used in this Foilset

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

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Tue Feb 18 1997