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

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

Given by Gang Cheng Marek Podgorny (Geoffrey Fox) at HPDC-4 Tutorial/CPS616 Spring95 on August 1, Pentagon City Virginia. Foils prepared July 23,1995
More Detail! * Foil Index from this file * See also color IMAGE

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

This mixed presentation uses parts of the following base foilsets which can also be looked at on their own!
Masters for Full Relational Database Presentation prepared for HPDC-4 Tutorial
First Part (Motivation, Theory) of Parallel Relational Databases
Collection of GIF Images for General NPAC Projects 1995-March96
Second Part (Benchmarking,Explicit Systems, Textwise) of Parallel Relational Databases
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)

Initial Two Presentations cover Relational Databases
1 Separate IMAGE * Separate HTML Tutorial on Parallel Relational Databases including Oracle, DB2PE on nCUBE2 and IBM SP2
2 Separate IMAGE * Separate HTML Abstract of Parallel Relational Database Tutorial
Start First Presentation Covering
3 Separate IMAGE * Separate HTML Parallel Relational Database Management Systems -- I
4 Separate IMAGE * Separate HTML Abstract of Parallel Relational Database Management Systems -- I
5 Separate IMAGE * Separate HTML Outline of Full Database Presentation
6 Separate IMAGE * Separate HTML Section I:
Parallel Database Technology in Commercial Applications and Industry
7 Separate IMAGE * Separate HTML Motivations for Parallel Databases -- I:
Overview of Parallel Database Appeal
8 Separate IMAGE * Separate HTML Motivations for Parallel Databases -- II:
Inadequacies with Current Mainframe Solutions
9 Separate IMAGE * Separate HTML Motivations for Parallel Databases -- III:
Commercial versus Scientific Applications
10 Separate IMAGE * Separate HTML Motivations for Parallel Databases -- IV:
Market Demand from Competitiveness
11 Separate IMAGE * Separate HTML Application Areas for Parallel Database: commercial, administration, scientific
12 Separate IMAGE * Separate HTML General Classes of Commercial Applications
13 Separate IMAGE * Separate HTML An Application Example ---
Intelligent Business systems
1)Objectives
14 Separate IMAGE * Separate HTML Intelligent Business systems ---
2)Typical Questions
15 Separate IMAGE * Separate HTML Intelligent Business systems ---
3) Major Technology Challenges
16 Separate IMAGE * Separate HTML Intelligent Business systems ---
4) Solutions
17 Separate IMAGE * Separate HTML Major Software and Hardware vendors in Parallel Database Technology
18 Separate IMAGE * Separate HTML Some Current Major Commercial Users
19 Separate IMAGE * Separate HTML Parallel Database Technology and Theory
20 Separate IMAGE * Separate HTML Hardware architectures for parallel DBMS
-- Generic System
21 Separate IMAGE * Separate HTML Hardware Architectures and forms of Parallelism
22 Separate IMAGE * Separate HTML Three (Hardware) architectures for parallel DBMS
23 Separate IMAGE * Separate HTML Notes on Shared Nothing Architecture
24 Separate IMAGE * Separate HTML Shared-data Architecture
25 Separate IMAGE * Separate HTML Shared Data Architecture
26 Separate IMAGE * Separate HTML Note on Oracle nCUBE2 Hybrid Architecture
27 Separate IMAGE * Separate HTML Topological view of MP machines (with ÒScalabilityÓ in mind)
28 Separate IMAGE * Separate HTML Dataflow perspective
29 Separate IMAGE * Separate HTML Parallelisms in parallel database systems
30 Separate IMAGE * Separate HTML Data Partitioning --- How to divide data among multiple disks ?
31 Separate IMAGE * Separate HTML Basic Data Partitioning Schemes
32 Separate IMAGE * Separate HTML Major Approaches in Data Partitioning
33 Separate IMAGE * Separate HTML Danger of Data Skew arises on
Shared Nothing with Data Partitioning
34 Separate IMAGE * Separate HTML Pitfalls in data partitioning
35 Separate IMAGE * Separate HTML Performance Metrics In Parallel Database Systems
36 Separate IMAGE * Separate HTML Performance barriers
37 Separate IMAGE * Separate HTML Some basic terminology for relational database model
38 Separate IMAGE * Separate HTML Examples of Typical Relational Operations
39 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
40 Separate IMAGE * Separate HTML Overview of Structure Query Language (SQL)
41 Separate IMAGE * Separate HTML Features of Structure Query Language (SQL)
42 Separate IMAGE * Separate HTML Major RDBMS functionality
43 Separate IMAGE * Separate HTML What is a 3GL or 4GL?
44 Separate IMAGE * Separate HTML What is PL/SQL -- I ?
45 Separate IMAGE * Separate HTML What is PL/SQL -- II?
46 Separate IMAGE * Separate HTML What is PL/SQL -- III?
47 Separate IMAGE * Separate HTML What is Data Integrity?
48 Separate IMAGE * Separate HTML What are Schemes?
49 Separate IMAGE * Separate HTML What are Roles?
50 Separate IMAGE * Separate HTML What are Profiles and Auditing?
51 Separate IMAGE * Separate HTML What are Two-phase Database Schema?
52 Separate IMAGE * Separate HTML Example: Relational Joins
53 Separate IMAGE * Separate HTML General Structure of Parallel and Sequential Relational Joins
54 Separate IMAGE * Separate HTML Parallel Algorithm for Relational Joins
55 Separate IMAGE * Separate HTML Parallel Database Software Architecture
Distributed Lock Manager
56 Separate IMAGE * Separate HTML Oracle Parallel Relational Database -- Screen1: Oracle Parallel Server
57 Separate IMAGE * Separate HTML Oracle Parallel Relational Database -- Screen2: Parallel Cache Management
58 Separate IMAGE * Separate HTML Parallel Database Software Architecture
59 Separate IMAGE * Separate HTML Oracle Parallel Relational Database -- Screen3: Oracle's Parallel Query
Start Second Presentation here Covering
60 Separate IMAGE * Separate HTML Parallel Relational Database Management Systems II
61 Separate IMAGE * Separate HTML Abstract of Second Part of Parallel Relational Database Systems Presentation
62 Separate IMAGE * Separate HTML Parallel Database efforts at NPAC and in InfoMall
63 Separate IMAGE * Separate HTML NPAC's Experience in Parallel Database Technology
64 Separate IMAGE * Separate HTML nCUBE Database Hardware and Software Infrastructure in NPAC
65 Separate IMAGE * Separate HTML IBM Database Hardware and Software Infrastructure in NPAC
66 Separate IMAGE * Separate HTML InfoMall(NPAC) Parallel Database Evaluation and Benchmarking Service
67 Separate IMAGE * Separate HTML Integrated Decision Support Systems
68 Separate IMAGE * Separate HTML Overview of DR-LINK High Level Natural Language Database Interface
69 Separate IMAGE * Separate HTML Features of DR-LINK High Level Natural Language Database Interface
70 Separate IMAGE * Separate HTML Structure of DR-LINK High Level Database Interface
71 Separate IMAGE * Separate HTML Parallel Oracle7 RDBMS -- A Case Study
72 Separate IMAGE * Separate HTML What is the Oracle Parallel Server -- Introduction ?
73 Separate IMAGE * Separate HTML Oracle Parallel RDBMS Architecture
Overall Structure
74 Separate IMAGE * Separate HTML Oracle Parallel RDBMS Architecture
Parallel Data Query option:
75 Separate IMAGE * Separate HTML Oracle Parallel RDBMS Architecture
Parallel Server option
76 Separate IMAGE * Separate HTML What are the versions of the Oracle Parallel Server ?
77 Separate IMAGE * Separate HTML What is the Oracle Parallel Server File Structure and Architecture?
78 Separate IMAGE * Separate HTML Oracle7 Server Architecture
79 Separate IMAGE * Separate HTML Oracle Parallel Relational Database Server on nCUBE2 -- Screen 1 on Oracle's Parallel Server for nCUBE2
80 Separate IMAGE * Separate HTML Oracle Parallel Relational Database Server on nCUBE2 -- Screen 2 on Oracle's Parallel Server for nCUBE2
81 Separate IMAGE * Separate HTML Oracle Parallel Relational Database Server on nCUBE2 -- Screen 3 on Oracle's Parallel Server for nCUBE2
82 Separate IMAGE * Separate HTML Oracle Parallel Relational Database Server on nCUBE2 -- Screen 4 on Oracle's Parallel Server for nCUBE2
83 Separate IMAGE * Separate HTML The Oracle Server Instance
84 Separate IMAGE * Separate HTML Oracle7 Parallel Server Characteristics
85 Separate IMAGE * Separate HTML The Oracle7 Parallel Server
86 Separate IMAGE * Separate HTML Application Example of Parallel Server (functional parallelism)
87 Separate IMAGE * Separate HTML Parallel Server Option
88 Separate IMAGE * Separate HTML Oracle7 on IBM SPX Architecture
89 Separate IMAGE * Separate HTML Parallel Cache Management (PCM) and Distributed Lock Manager(DLM)
90 Separate IMAGE * Separate HTML Oracle Parallel Server On-Line Recovery
91 Separate IMAGE * Separate HTML Example of failure due to lack of concurrency control
92 Separate IMAGE * Separate HTML Discussion of PCM Lock Example
93 Separate IMAGE * Separate HTML Contention for Shared Resources
94 Separate IMAGE * Separate HTML Using Oracle 7 Server's PCM locks:
95 Separate IMAGE * Separate HTML Consider the following PCM Example
96 Separate IMAGE * Separate HTML Parallel Query Option
97 Separate IMAGE * Separate HTML Parallel Query Processing: Overview
98 Separate IMAGE * Separate HTML Query Processing
99 Separate IMAGE * Separate HTML Three Processing Phases in Parallel Query
100 Separate IMAGE * Separate HTML Example of parallel execution of a full scan
101 Separate IMAGE * Separate HTML Parallel Query Execution
102 Separate IMAGE * Separate HTML The query coordinator dynamically partitions the work among the query servers
103 Separate IMAGE * Separate HTML Data Partitioning in Oracle 7.1.3
104 Separate IMAGE * Separate HTML File Striping in Oracle
105 Separate IMAGE * Separate HTML Benchmarking Parallel RDBMS
106 Separate IMAGE * Separate HTML Industry Benchmarking Tests-I
107 Separate IMAGE * Separate HTML Industry Benchmarking Tests-II
108 Separate IMAGE * Separate HTML Characteristics of DSS Workloads
109 Separate IMAGE * Separate HTML TPC-D - a Decision Support Benchmark?
Overall Structure
110 Separate IMAGE * Separate HTML TPC-D - a Decision Support Benchmark?
Nature of Benchmark Examples
111 Separate IMAGE * Separate HTML TPC-D - a Decision Support Benchmark? Nature of Queries
112 Separate IMAGE * Separate HTML TPC-D - a Decision Support Benchmark?
Problems with TPC-D design
113 Separate IMAGE * Separate HTML TPC-D - a Decision Support Benchmark?
Scalability Issues
114 Separate IMAGE * Separate HTML TPC-D - a Decision Support Benchmark?
Relevance to Real Applications
115 Separate IMAGE * Separate HTML TPC-D - a Decision Support Benchmark?
Overall Evaluation
116 Separate IMAGE * Separate HTML Some Lessons Learned in NPAC's Benchmarking
Now we discuss Linkage of Relational Databases with Web
117 Separate IMAGE * Separate HTML Integration of Database Server and Web Technology
118 Separate IMAGE * Separate HTML Abstract of Web Oracle Integration Presentation
119 Separate IMAGE * Separate HTML Key points in Web Technology
120 Separate IMAGE * Separate HTML Key points in database technology
121 Separate IMAGE * Separate HTML The Synergy of Web Networking and Database Technologies
122 Separate IMAGE * Separate HTML Weak Points in Web Technology
123 Separate IMAGE * Separate HTML Weak Points in Database Technology
124 Separate IMAGE * Separate HTML By integrating a database server into Web technology, a Web server can be enhanced with:
125 Separate IMAGE * Separate HTML By integrating Web into database technology, a Database server can be enhanced with:
126 Separate IMAGE * Separate HTML Interfacing Web server and a database server
-- Basic Features of WWW Client Server System
127 Separate IMAGE * Separate HTML WWW Client Server Relationship
128 Separate IMAGE * Separate HTML Basic features in database access -- a SQL-based query interface
129 Separate IMAGE * Separate HTML Basic Client-Server model
130 Separate IMAGE * Separate HTML Major approaches for interfacing web into DB server environment
131 Separate IMAGE * Separate HTML Basic WWW DB Integration Model
132 Separate IMAGE * Separate HTML Oracle approach to Web-RDBMS Integration
133 Separate IMAGE * Separate HTML Procedural and Programmable mechanisms
134 Separate IMAGE * Separate HTML Web-Oracle-Web (WOW) --- a Web-Oracle interface tool for developing gateways
135 Separate IMAGE * Separate HTML Basic components in WOW
136 Separate IMAGE * Separate HTML Client-Server Architecture for WOW
137 Separate IMAGE * Separate HTML Web-oracle Mail Database: a case study of integrating Oracle7 database server into Web
138 Separate IMAGE * Separate HTML The Entity-Relation Model
139 Separate IMAGE * Separate HTML Functionality of the mail database
140 Separate IMAGE * Separate HTML Web to Oracle Interface Screen 1: Home Page for the Web-Mail Database
141 Separate IMAGE * Separate HTML Web to Oracle Interface Screen 2: Query the Mailbox
142 Separate IMAGE * Separate HTML Web to Oracle Interface Screen 3: Query the Folder -- Choose a Folder
143 Separate IMAGE * Separate HTML Web to Oracle Interface Screen 4: Query the Folder
144 Separate IMAGE * Separate HTML Query by mail header
145 Separate IMAGE * Separate HTML Web to Oracle Interface Screen 5: Query by Mail Header -- Choose a Folder
146 Separate IMAGE * Separate HTML Web to Oracle Interface Screen 6: Query by mail header
147 Separate IMAGE * Separate HTML Web to Oracle Interface Screen 14: Query Result -- Browse Mail Body --1
148 Separate IMAGE * Separate HTML Web to Oracle Interface Screen 15: Query Result -- Browse Mail Body --2
149 Separate IMAGE * Separate HTML Query by date
150 Separate IMAGE * Separate HTML Web to Oracle Interface Screen 7: Query by Date --1
151 Separate IMAGE * Separate HTML Web to Oracle Interface Screen 8: Query by Date --2
152 Separate IMAGE * Separate HTML Query by Subject
153 Separate IMAGE * Separate HTML Web to Oracle Interface Screen 9: Query by Subject --1
154 Separate IMAGE * Separate HTML Web to Oracle Interface Screen 10: Query by Subject --2
155 Separate IMAGE * Separate HTML Query by Sender
156 Separate IMAGE * Separate HTML Web to Oracle Interface Screen 11: Query by Sender
157 Separate IMAGE * Separate HTML Incorporating new mail into the Database from your UNIX mailbox --I
158 Separate IMAGE * Separate HTML Web to Oracle Interface Screen 12: Incorporate New Mail from Web Page -- Choose a folder
159 Separate IMAGE * Separate HTML Incorporating new mail into the Database from your UNIX mailbox --II
160 Separate IMAGE * Separate HTML Web to Oracle Interface Screen 13: Incorporate New Mail
161 Separate IMAGE * Separate HTML Format of Query results from all query options
162 Separate IMAGE * Separate HTML Web to Oracle Interface Screen 6: Query by mail header
163 Separate IMAGE * Separate HTML Web to Oracle Interface Screen 14: Query Result -- Browse Mail Body --1
164 Separate IMAGE * Separate HTML Web to Oracle Interface Screen 15: Query Result -- Browse Mail Body --2
165 Separate IMAGE * Separate HTML Query options to be added in the future to Oracle-based Web Mail System
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


key DandB URL http://www.dbisna.com/ * Dun & Bradstreet by gcheng on July 22,1995
Times 1 Foils referenced Script
key IBM URL http://www.ibm.com/ * IBM Corp. by gcheng on July 22,1995
Times 1 Foils referenced Script
key IBMDB2PESP2 URL http://www.austin.ibm.com/services/vendors/tech/aixpert/may94/aixpert_may94_db2par.html * DB2 Parallel Edition on SP2 by gcheng on July 22,1995
Times 1 Foils referenced Script
key IBMOracleSP2 URL http://www.austin.ibm.com/services/vendors/tech/aixpert/may94/aixpert_may94_oracle.html * Parallel Oracle 7 on SP2 by gcheng on July 22,1995
Times 1 Foils referenced Script
key IBMSP2 URL http://lscftp.kgn.ibm.com/pps/ * IBM SP2 by gcheng on July 22,1995
Times 1 Foils referenced Script
key NPACOracleServer URL http://kayak.npac.syr.edu:1963/ * NPAC Oracle 7 Database Server by gcheng on July 22,1995
Times 1 Foils referenced Script
key NPACWebRDBMS URL http://greatwall.npac.syr.edu:1963/PDB/web-db.html * Integration of Web and RDBMS by gcheng on July 22,1995
Times 1 Foils referenced Script
key NPACWebRDBMSdemo1 URL http://kayak.npac.syr.edu:1963/cgi-bin/cps600/index_home * CPS600 Demo Mailbox Database by gcheng on July 22,1995
Times 1 Foils referenced Script
key NPACWebRDBMSdemo2 URL http://kayak.npac.syr.edu:1963/cgi-bin/travel/index_home * TravelVenture Demo by gcheng on July 22,1995
Times 1 Foils referenced Script
key NPACpdb1 URL http://www.npac.syr.edu/NPAC1/PUB/marek/proj4.html * Parallel Database Project at NPAC by gcheng on July 22,1995
Times 1 Foils referenced Script
key NPACpdb2 URL http://greatwall.npac.syr.edu:1963/PDB/index.html * NPAC Parallel RDBMS WWW page by gcheng on July 22,1995
Times 1 Foils referenced Script
key NPACpdbhard URL http://www.npac.syr.edu/NPAC1/PUB/infra2/section3.2.html#SECTION0002000000000000000 * NPAC's Parallel RDBMS Hardware Infrastructure by gcheng on July 22,1995
Times 1 Foils referenced Script
key Oracle URL http://www.oracle.com/ * Oracle Corp. by gcheng on July 22,1995
Times 2 Foils referenced Script Script
key OracleFAQ URL http://www.bf.rmit.edu.au/~dtb/orafaq/contents.html * Oracle General FAQ by gcheng on July 22,1995
Times 2 Foils referenced Script Script
key OracleWWW URL http://dozer.us.oracle.com:8080/ * Oracle World Wide Web Interface Kit by gcheng on July 22,1995
Times 1 Foils referenced Script
key SQLStandards URL http://www.jcc.com/sql_stnd.html * SQL Standards Home Page by gcheng on July 22,1995
Times 2 Foils referenced Script Script
key nCUBE URL http://earthcube.mit.edu/ * nCUBE by gcheng on July 22,1995
Times 1 Foils referenced Script
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