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

Second Part (Benchmarking,Explicit Systems, Textwise) of Parallel Relational Databases

This discusses the last three parts of presentation

What is situation at NPAC including hardware, InfoMall activities and the DR-LINK product of Textwise (Liz Liddy)

Detailed Discussion of Parallel Oracle on SP2 and nCUBE

Results of NPAC's Benchmarking Activities Especially TPCD work

Table of Contents for Second Part (Benchmarking,Explicit Systems, Textwise) of Parallel Relational Databases

001 Parallel Relational Database Management Systems II
002 Abstract of Second Part of Parallel Relational Database Systems 
    Presentation
003 Parallel Database efforts at NPAC and in InfoMall
004 NPAC's Experience in Parallel Database Technology
005 nCUBE Database Hardware and Software Infrastructure in NPAC
006 IBM Database Hardware and Software Infrastructure in NPAC
007 InfoMall(NPAC) Parallel Database Evaluation and Benchmarking 
    Service
008 Integrated Decision Support Systems
009 Overview of DR-LINK High Level Natural Language Database Interface
010 Features of DR-LINK High Level Natural Language Database Interface
011 Structure of DR-LINK High Level Database Interface
012 Parallel Oracle7 RDBMS -- A Case Study
013 What is the Oracle Parallel Server -- Introduction ?
014 Oracle Parallel RDBMS Architecture
    Overall Structure
015 Oracle Parallel RDBMS Architecture
    Parallel Data Query option:
016 Oracle Parallel RDBMS Architecture
    Parallel Server option
017 What are the versions of the Oracle Parallel Server ?
018 What is the Oracle Parallel Server File Structure and 
    Architecture?
019 Oracle7 Server Architecture
020 The Oracle Server Instance
021 Oracle7 Parallel Server Characteristics 
022 The Oracle7 Parallel Server
023 Application Example of Parallel Server (functional parallelism)
024 Parallel Server Option
025 Oracle7 on IBM SPX Architecture
026 Parallel Cache Management (PCM) and Distributed Lock Manager(DLM)
027 Oracle Parallel Server On-Line Recovery
028 Example of failure due to lack of concurrency control
029 Discussion of PCM Lock Example
030 Contention for Shared Resources
031 Using Oracle 7 Server's PCM locks:
032 Consider the following PCM Example
033 Parallel Query Option
034 Parallel Query Processing: Overview
035 Query Processing
036 Three Processing Phases in Parallel Query
037 Example of parallel execution of a full scan 
038 Parallel Query Execution
039 The query coordinator dynamically partitions the work among the 
    query servers
040 Data Partitioning in Oracle 7.1.3
041 File Striping in Oracle
042 Benchmarking Parallel RDBMS
043 Industry Benchmarking Tests-I
044 Industry Benchmarking Tests-II
045 Characteristics of DSS Workloads
046 TPC-D - a Decision Support Benchmark?
    Overall Structure
047 TPC-D - a Decision Support Benchmark?
    Nature of Benchmark Examples
048 TPC-D - a Decision Support Benchmark? Nature of Queries
049 TPC-D - a Decision Support Benchmark?
    Problems with  TPC-D design
050 TPC-D - a Decision Support Benchmark?
    Scalability Issues
051 TPC-D - a Decision Support Benchmark?
    Relevance to Real Applications
052 TPC-D - a Decision Support Benchmark?
    Overall Evaluation
053 Some Lessons Learned in NPAC's Benchmarking

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