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

Full Relational Database Presentation prepared for HPDC-4 Tutorial (Used in CPS616-1995)

Commercial Applications and Motivation for large Parallel Databases

Overview of base Technology including parallel architecture and review of sequential SQL

NPAC's Parallel Database Installation

Parallel Oracle on SP2 and nCUBE

DR-LINK high level frontend from Textwise

Some experiences with benchmarking --TPC-D

Linking of relational databases to the Web Example of use with large UNIX mail system Contrast of pluses and minuses of relational databases with distributed Web databnases

RDBMS HPDC95 MasterMasters for Full Relational Database Presentation 
                    prepared for HPDC-4 Tutorial
CPS616RDBMS1       First Part (Motivation, Theory) of Parallel 
                    Relational Databases
NPACAddons         Collection of GIF Images for General NPAC Projects 
                    1995-March96
CPS616RDBMS2       Second Part (Benchmarking,Explicit Systems, 
                    Textwise) of Parallel Relational Databases
CPS616webDBMS      CPS600 Presentation on Linkage of Web to 
                    Relational(Oracle) Databases

Table of Contents for Full Relational Database Presentation prepared for HPDC-4 Tutorial (Used in CPS616-1995)

• Including Parallelism and Benchmarking
• Good Online references include:
  • Parallel Database Project at NPAC
  • NPAC Parallel RDBMS WWW page
  • NPAC's Parallel RDBMS Hardware Infrastructure
• Industrial Activities:
  • Dun & Bradstreet
  • IBM Corp.
  • IBM SP2
  • DB2 Parallel Edition on SP2
  • Parallel Oracle 7 on SP2
  • nCUBE
  • Oracle Corp.
  • Oracle General FAQ
  • SQL Standards Home Page

RDBMS HPDC95 Master 001 001 Tutorial on Parallel Relational Databases 
                            including Oracle, DB2PE on nCUBE2 and IBM 
                            SP2
RDBMS HPDC95 Master 002 002 Abstract of Parallel Relational Database 
                            Tutorial

• Commercial Applications and Motivation of Parallel Relational Databases
• Theory and Architecture of Parallel Relational Databases
• Including a SQL review

       CPS616RDBMS1 001 003 Parallel Relational Database Management 
                            Systems -- I
       CPS616RDBMS1 002 004 Abstract of Parallel Relational Database 
                            Management Systems -- I
       CPS616RDBMS1 003 005 Outline of Full Database Presentation
       CPS616RDBMS1 004 006 Section I: 
                            Parallel Database Technology in Commercial
                             Applications and Industry
       CPS616RDBMS1 005 007 Motivations for Parallel Databases -- I:
                            Overview of Parallel Database Appeal
       CPS616RDBMS1 006 008 Motivations for Parallel Databases -- II:
                            Inadequacies with Current Mainframe 
                            Solutions
       CPS616RDBMS1 007 009 Motivations for Parallel Databases -- III:
                            Commercial versus Scientific Applications
       CPS616RDBMS1 008 010 Motivations for Parallel Databases -- IV:
                            Market Demand from Competitiveness
       CPS616RDBMS1 009 011 Application Areas for Parallel Database: 
                            commercial, administration, scientific
       CPS616RDBMS1 010 012 General Classes of Commercial Applications
       CPS616RDBMS1 011 013 An Application Example ---
                            Intelligent Business systems
                            1)Objectives
       CPS616RDBMS1 012 014 Intelligent Business systems  ---
                            2)Typical Questions
       CPS616RDBMS1 013 015 Intelligent Business systems ---
                            3) Major Technology Challenges 
       CPS616RDBMS1 014 016 Intelligent Business systems ---
                            4) Solutions
       CPS616RDBMS1 015 017 Major Software and Hardware vendors in 
                            Parallel Database Technology
       CPS616RDBMS1 016 018 Some Current Major Commercial Users
       CPS616RDBMS1 017 019 Parallel Database Technology and Theory
       CPS616RDBMS1 018 020 Hardware architectures for parallel DBMS
                            -- Generic System 
       CPS616RDBMS1 019 021 Hardware Architectures and forms of 
                            Parallelism
       CPS616RDBMS1 020 022 Three (Hardware) architectures for 
                            parallel DBMS 
       CPS616RDBMS1 021 023 Notes on Shared Nothing Architecture
       CPS616RDBMS1 022 024 Shared-data Architecture
       CPS616RDBMS1 023 025 Shared Data Architecture
       CPS616RDBMS1 024 026 Note on Oracle nCUBE2 Hybrid Architecture
       CPS616RDBMS1 025 027 Topological view of MP machines (with 
                            ÒScalabilityÓ in mind)
       CPS616RDBMS1 026 028 Dataflow perspective
       CPS616RDBMS1 027 029 Parallelisms in parallel database systems
       CPS616RDBMS1 028 030 Data Partitioning --- How to divide data 
                            among multiple disks ?
       CPS616RDBMS1 029 031 Basic Data Partitioning Schemes
       CPS616RDBMS1 030 032 Major Approaches in Data Partitioning
       CPS616RDBMS1 031 033 Danger of Data Skew arises on 
                            Shared Nothing with Data Partitioning
       CPS616RDBMS1 032 034 Pitfalls in data partitioning
       CPS616RDBMS1 033 035 Performance Metrics In Parallel Database 
                            Systems
       CPS616RDBMS1 034 036 Performance barriers
       CPS616RDBMS1 035 037 Some basic terminology for relational 
                            database model 
       CPS616RDBMS1 036 038 Examples of Typical Relational Operations
       CPS616RDBMS1 037 039 Join Operation: a SELECT operation that 
                            combines rows from two or more tables. 
                            Each returned row contains data from more 
                            than one table
       CPS616RDBMS1 038 040 Overview of Structure Query Language (SQL)
       CPS616RDBMS1 039 041 Features of Structure Query Language (SQL)
       CPS616RDBMS1 040 042 Major RDBMS functionality
       CPS616RDBMS1 041 043 What is a 3GL or 4GL?
       CPS616RDBMS1 042 044 What is PL/SQL -- I ?
       CPS616RDBMS1 043 045 What is PL/SQL -- II?
       CPS616RDBMS1 044 046 What is PL/SQL -- III?
       CPS616RDBMS1 045 047 What is Data Integrity?
       CPS616RDBMS1 046 048 What are Schemes?
       CPS616RDBMS1 047 049 What are Roles?
       CPS616RDBMS1 048 050 What are Profiles and Auditing?
       CPS616RDBMS1 049 051 What are Two-phase Database Schema?
       CPS616RDBMS1 050 052 Example: Relational Joins
       CPS616RDBMS1 051 053 General Structure of Parallel and 
                            Sequential Relational Joins
       CPS616RDBMS1 052 054 Parallel Algorithm for Relational Joins
       CPS616RDBMS1 053 055 Parallel Database Software Architecture
                            Distributed Lock Manager
         NPACAddons 023 056 Oracle Parallel Relational Database -- 
                            Screen1: Oracle Parallel Server
         NPACAddons 024 057 Oracle Parallel Relational Database -- 
                            Screen2: Parallel Cache Management
       CPS616RDBMS1 054 058 Parallel Database Software Architecture
         NPACAddons 025 059 Oracle Parallel Relational Database -- 
                            Screen3: Oracle's Parallel Query

• Benchmarking, Explicit Issues with Oracle on SP2 and nCUBE
• Textwise High Level Front End

       CPS616RDBMS2 001 060 Parallel Relational Database Management 
                            Systems II
       CPS616RDBMS2 002 061 Abstract of Second Part of Parallel 
                            Relational Database Systems Presentation
       CPS616RDBMS2 003 062 Parallel Database efforts at NPAC and in 
                            InfoMall
       CPS616RDBMS2 004 063 NPAC's Experience in Parallel Database 
                            Technology
       CPS616RDBMS2 005 064 nCUBE Database Hardware and Software 
                            Infrastructure in NPAC
       CPS616RDBMS2 006 065 IBM Database Hardware and Software 
                            Infrastructure in NPAC
       CPS616RDBMS2 007 066 InfoMall(NPAC) Parallel Database 
                            Evaluation and Benchmarking Service
       CPS616RDBMS2 008 067 Integrated Decision Support Systems
       CPS616RDBMS2 009 068 Overview of DR-LINK High Level Natural 
                            Language Database Interface
       CPS616RDBMS2 010 069 Features of DR-LINK High Level Natural 
                            Language Database Interface
       CPS616RDBMS2 011 070 Structure of DR-LINK High Level Database 
                            Interface
       CPS616RDBMS2 012 071 Parallel Oracle7 RDBMS -- A Case Study
       CPS616RDBMS2 013 072 What is the Oracle Parallel Server -- 
                            Introduction ?
       CPS616RDBMS2 014 073 Oracle Parallel RDBMS Architecture
                            Overall Structure
       CPS616RDBMS2 015 074 Oracle Parallel RDBMS Architecture
                            Parallel Data Query option:
       CPS616RDBMS2 016 075 Oracle Parallel RDBMS Architecture
                            Parallel Server option
       CPS616RDBMS2 017 076 What are the versions of the Oracle 
                            Parallel Server ?
       CPS616RDBMS2 018 077 What is the Oracle Parallel Server File 
                            Structure and Architecture?
       CPS616RDBMS2 019 078 Oracle7 Server Architecture
         NPACAddons 026 079 Oracle Parallel Relational Database  
                            Server on nCUBE2 -- Screen 1 on Oracle's 
                            Parallel Server for nCUBE2
         NPACAddons 027 080 Oracle Parallel Relational Database  
                            Server on nCUBE2 -- Screen 2  on Oracle's 
                            Parallel Server for nCUBE2
         NPACAddons 028 081 Oracle Parallel Relational Database  
                            Server on nCUBE2 -- Screen 3  on Oracle's 
                            Parallel Server for nCUBE2
         NPACAddons 029 082 Oracle Parallel Relational Database  
                            Server on nCUBE2 -- Screen 4  on Oracle's 
                            Parallel Server for nCUBE2
       CPS616RDBMS2 020 083 The Oracle Server Instance
       CPS616RDBMS2 021 084 Oracle7 Parallel Server Characteristics 
       CPS616RDBMS2 022 085 The Oracle7 Parallel Server
       CPS616RDBMS2 023 086 Application Example of Parallel Server 
                            (functional parallelism)
       CPS616RDBMS2 024 087 Parallel Server Option
       CPS616RDBMS2 025 088 Oracle7 on IBM SPX Architecture
       CPS616RDBMS2 026 089 Parallel Cache Management (PCM) and 
                            Distributed Lock Manager(DLM)
       CPS616RDBMS2 027 090 Oracle Parallel Server On-Line Recovery
       CPS616RDBMS2 028 091 Example of failure due to lack of 
                            concurrency control
       CPS616RDBMS2 029 092 Discussion of PCM Lock Example
       CPS616RDBMS2 030 093 Contention for Shared Resources
       CPS616RDBMS2 031 094 Using Oracle 7 Server's PCM locks:
       CPS616RDBMS2 032 095 Consider the following PCM Example
       CPS616RDBMS2 033 096 Parallel Query Option
       CPS616RDBMS2 034 097 Parallel Query Processing: Overview
       CPS616RDBMS2 035 098 Query Processing
       CPS616RDBMS2 036 099 Three Processing Phases in Parallel Query
       CPS616RDBMS2 037 100 Example of parallel execution of a full 
                            scan 
       CPS616RDBMS2 038 101 Parallel Query Execution
       CPS616RDBMS2 039 102 The query coordinator dynamically 
                            partitions the work among the query 
                            servers
       CPS616RDBMS2 040 103 Data Partitioning in Oracle 7.1.3
       CPS616RDBMS2 041 104 File Striping in Oracle
       CPS616RDBMS2 042 105 Benchmarking Parallel RDBMS
       CPS616RDBMS2 043 106 Industry Benchmarking Tests-I
       CPS616RDBMS2 044 107 Industry Benchmarking Tests-II
       CPS616RDBMS2 045 108 Characteristics of DSS Workloads
       CPS616RDBMS2 046 109 TPC-D - a Decision Support Benchmark?
                            Overall Structure
       CPS616RDBMS2 047 110 TPC-D - a Decision Support Benchmark?
                            Nature of Benchmark Examples
       CPS616RDBMS2 048 111 TPC-D - a Decision Support Benchmark? 
                            Nature of Queries
       CPS616RDBMS2 049 112 TPC-D - a Decision Support Benchmark?
                            Problems with  TPC-D design
       CPS616RDBMS2 050 113 TPC-D - a Decision Support Benchmark?
                            Scalability Issues
       CPS616RDBMS2 051 114 TPC-D - a Decision Support Benchmark?
                            Relevance to Real Applications
       CPS616RDBMS2 052 115 TPC-D - a Decision Support Benchmark?
                            Overall Evaluation
       CPS616RDBMS2 053 116 Some Lessons Learned in NPAC's 
                            Benchmarking

• Good Online NPAC references are:
  • NPAC Oracle 7 Database Server
  • Integration of Web and RDBMS
  • CPS600 Demo Mailbox Database
  • TravelVenture Demo
• Good Commercial References are:
  • Oracle Corp.
  • Oracle General FAQ
  • Oracle World Wide Web Interface Kit
  • SQL Standards Home Page

      CPS616webDBMS 001 117 Integration of Database Server and Web 
                            Technology
      CPS616webDBMS 002 118 Abstract of Web Oracle Integration 
                            Presentation
      CPS616webDBMS 003 119 Key points in Web Technology
      CPS616webDBMS 004 120 Key points in database technology
      CPS616webDBMS 005 121 The Synergy of Web Networking and Database
                             Technologies    
      CPS616webDBMS 006 122 Weak Points in Web Technology
      CPS616webDBMS 007 123 Weak Points in Database Technology
      CPS616webDBMS 008 124 By integrating a database server into Web 
                            technology, a Web server can be enhanced 
                            with:
      CPS616webDBMS 009 125 By integrating Web into database 
                            technology, a Database server can be 
                            enhanced with:
      CPS616webDBMS 010 126 Interfacing Web server and a database 
                            server
                            -- Basic Features of WWW Client Server 
                            System
      CPS616webDBMS 011 127 WWW Client Server Relationship
      CPS616webDBMS 012 128 Basic features in database access -- a 
                            SQL-based query interface   
      CPS616webDBMS 013 129 Basic Client-Server model
      CPS616webDBMS 014 130 Major approaches for interfacing web into 
                            DB server environment
      CPS616webDBMS 015 131 Basic WWW DB Integration Model
      CPS616webDBMS 016 132 Oracle approach to Web-RDBMS Integration
      CPS616webDBMS 017 133 Procedural and Programmable mechanisms
      CPS616webDBMS 018 134 Web-Oracle-Web (WOW) --- a Web-Oracle 
                            interface tool for developing gateways
      CPS616webDBMS 019 135 Basic components in WOW
      CPS616webDBMS 020 136 Client-Server Architecture for WOW
      CPS616webDBMS 021 137 Web-oracle Mail Database: a case study of 
                            integrating Oracle7 database server into 
                            Web
      CPS616webDBMS 022 138 The Entity-Relation Model
      CPS616webDBMS 023 139 Functionality of the mail database
         NPACAddons 008 140 Web to Oracle Interface Screen 1: Home 
                            Page for the Web-Mail Database
         NPACAddons 009 141 Web to Oracle Interface Screen 2: Query 
                            the Mailbox
         NPACAddons 010 142 Web to Oracle Interface Screen 3: Query 
                            the Folder -- Choose a Folder
         NPACAddons 011 143 Web to Oracle Interface Screen 4: Query 
                            the Folder
      CPS616webDBMS 024 144 Query by mail header
         NPACAddons 012 145 Web to Oracle Interface Screen 5: Query by
                             Mail Header -- Choose a Folder
         NPACAddons 013 146 Web to Oracle Interface Screen 6: Query by
                             mail header
         NPACAddons 021 147 Web to Oracle Interface Screen 14: Query 
                            Result -- Browse Mail Body --1
         NPACAddons 022 148 Web to Oracle Interface Screen 15: Query 
                            Result -- Browse Mail Body --2
      CPS616webDBMS 025 149 Query by date
         NPACAddons 014 150 Web to Oracle Interface Screen 7: Query by
                             Date --1
         NPACAddons 015 151 Web to Oracle Interface Screen 8: Query by
                             Date --2
      CPS616webDBMS 026 152 Query by Subject 
         NPACAddons 016 153 Web to Oracle Interface Screen 9: Query by
                             Subject --1
         NPACAddons 017 154 Web to Oracle Interface Screen 10: Query 
                            by Subject --2
      CPS616webDBMS 027 155 Query  by Sender     
         NPACAddons 018 156 Web to Oracle Interface Screen 11: Query 
                            by Sender
      CPS616webDBMS 028 157 Incorporating new mail into the Database 
                            from your UNIX mailbox --I
         NPACAddons 019 158 Web to Oracle Interface Screen 12: 
                            Incorporate New Mail from Web Page -- 
                            Choose a folder
      CPS616webDBMS 029 159 Incorporating new mail into the Database 
                            from your UNIX mailbox --II
         NPACAddons 020 160 Web to Oracle Interface Screen 13: 
                            Incorporate New Mail
      CPS616webDBMS 030 161 Format of Query results from all query 
                            options 
         NPACAddons 013 162 Web to Oracle Interface Screen 6: Query by
                             mail header
         NPACAddons 021 163 Web to Oracle Interface Screen 14: Query 
                            Result -- Browse Mail Body --1
         NPACAddons 022 164 Web to Oracle Interface Screen 15: Query 
                            Result -- Browse Mail Body --2
      CPS616webDBMS 031 165 Query options to be added in the future to
                             Oracle-based Web Mail System 

List of Foils Used as they occur

RDBMS HPDC95 MasterMasters for Full Relational Database Presentation 
                    prepared for HPDC-4 Tutorial

CPS616RDBMS1       First Part (Motivation, Theory) of Parallel 
                    Relational Databases

NPACAddons         Collection of GIF Images for General NPAC Projects 
                    1995-March96

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

CPS616webDBMS      CPS600 Presentation on Linkage of Web to 
                    Relational(Oracle) Databases

RDBMS HPDC95 MasterMasters for Full Relational Database Presentation 
                    prepared for HPDC-4 Tutorial

CPS616RDBMS1       First Part (Motivation, Theory) of Parallel 
                    Relational Databases

NPACAddons         Collection of GIF Images for General NPAC Projects 
                    1995-March96

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

CPS616webDBMS      CPS600 Presentation on Linkage of Web to 
                    Relational(Oracle) Databases

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