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

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

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

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


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


© on Mon Oct 13 1997