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

Web-Oracle Integration focussing on use of PL/SQL

Given by Gang Cheng, C.W. Ou, Geoffrey C. Fox at CPS616 Basic Information Track for Computational Science on Winter-Spring Semester 96. Foils prepared 4 April 1996

The Strengths, Weaknesses and Synergy of Web and Database Technologies
Architectures of Web and Oracle RDBMS Integration
A Technical Overview of The Oracle-Web Integration
using wowstub and PL/SQL
Examples of a Web-based Search Interface for the Phone List Database


This mixed presentation uses parts of the following base foilsets which can also be looked at on their own!
CPS616Web-Oracle96M   Master Foilset for Web-Oracle Integration
CPS616webDBMS         CPS600 Presentation on Linkage of Web to 
                       Relational(Oracle) Databases
NPACAddons            Collection of GIF Images for General NPAC 
                       Projects 1995-March96

Table of Contents for Web-Oracle Integration focussing on use of PL/SQL



Third Module in NPAC Tutorial on Oracle and its Integration with Web
   CPS616Web-Oracle96M 001 001 CPS 616 January-April 1996 
                               Computational Science Track on Base 
                               Technology for the Information Age: 
                               Oracle RDBMS and Web Integration
                               Web/Oracle Module 3: Integration of WWW
                                and Oracle RDBMS
   CPS616Web-Oracle96M 002 002 Abstract of Web/Oracle Module 3: 
                               Integration of WWW and Oracle RDBMS
   CPS616Web-Oracle96M 003 003 Key points of Web Technology
   CPS616Web-Oracle96M 004 004 Strengths of Web Technology
   CPS616Web-Oracle96M 005 005 Weak Points in Web Technology
   CPS616Web-Oracle96M 006 006 Key points in database technology - I
   CPS616Web-Oracle96M 007 007 Key points in database technology - II
   CPS616Web-Oracle96M 008 008 The Synergy of Web Networking and 
                               Database Technologies - I    
   CPS616Web-Oracle96M 009 009 Web-Database Synergy - II  
   CPS616Web-Oracle96M 010 010 By integrating a database server into 
                               Web technology, a web server can be 
                               enhanced with:
   CPS616Web-Oracle96M 011 011 By integrating Web into database 
                               technology, a database server can be 
                               enhanced with:
   CPS616Web-Oracle96M 012 012 NPAC Web-Database Applications
   CPS616Web-Oracle96M 013 013 Importance for Key Communities
   CPS616Web-Oracle96M 014 014 Networking and Client-Server 
                               Archtecture in WWW - I
   CPS616Web-Oracle96M 015 015 Networking and Client-Server 
                               Archtecture in WWW - II
   CPS616Web-Oracle96M 016 016 Two Different Strategies for WWW 
                               Client-Server Interactions - I
   CPS616Web-Oracle96M 017 017 Two Different Strategies for WWW 
                               Client-Server Interactions - II
   CPS616Web-Oracle96M 018 018 Basic Features In Database Access -- A 
                               SQL-based Query Interface   
   CPS616Web-Oracle96M 019 019 Basic Client-Server model
   CPS616Web-Oracle96M 020 020 Major Approaches and Components for 
                               Interfacing Web into DB Server 
                               Environment
   CPS616Web-Oracle96M 021 021 Basic WWW DB Integration Model
   CPS616Web-Oracle96M 022 022 The Oracle-Web Integration: A Technical
                                Overview
   CPS616Web-Oracle96M 023 023 Oracle-Web Integration Architecture
   CPS616Web-Oracle96M 024 024 Oracle Web Agent
   CPS616Web-Oracle96M 025 025 Oracle Web Agent Components
   CPS616Web-Oracle96M 026 026 Oracle Approach to Web Information - I
   CPS616Web-Oracle96M 027 027 Oracle Approach to Web Information - II
   CPS616Web-Oracle96M 028 028 Why Use PL/SQL ?
   CPS616Web-Oracle96M 029 029 Oracle Web Agent: Dynamic Creation of 
                               HTML
   CPS616Web-Oracle96M 030 030 Anatomy of a Web Agent URL 
   CPS616Web-Oracle96M 031 031 The WOW OCI program (wowstub)
   CPS616Web-Oracle96M 032 032 WebServer Developer's Toolkit
   CPS616Web-Oracle96M 033 033 Examples of the Use of HTP and HTF - I
   CPS616Web-Oracle96M 034 034 Examples of the Use of HTP and HTF - II
   CPS616Web-Oracle96M 035 035 An Web/Oracle Example - Query A 
                               Person's Phone Number by Last or First 
                               Name From a Web Page
   CPS616Web-Oracle96M 036 036 Web/Oracle Example Overall Set Up - CGI
                                Script - II
   CPS616Web-Oracle96M 037 037 The PL/SQL Package For Phone Example - 
                               I
   CPS616Web-Oracle96M 038 038 The PL/SQL Package For Phone Example - 
                               II
   CPS616Web-Oracle96M 039 039 The Web Page - Search Interface - I
   CPS616Web-Oracle96M 040 040 The Web Page - Search Interface - II
   CPS616Web-Oracle96M 041 041 More Examples of PL/SQL Procedures for 
                               Web/Oracle Application
   CPS616Web-Oracle96M 042 042 Oracle's Latest WebServer 2.0 - I
   CPS616Web-Oracle96M 043 043 Oracle's Latest WebServer 2.0 - II
         CPS616webDBMS 021 044 Web-oracle Mail Database: a case study 
                               of integrating Oracle7 database server 
                               into Web
         CPS616webDBMS 022 045 The Entity-Relation Model
         CPS616webDBMS 023 046 Functionality of the mail database
            NPACAddons 008 047 Web to Oracle Interface Screen 1: Home 
                               Page for the Web-Mail Database
            NPACAddons 009 048 Web to Oracle Interface Screen 2: Query
                                the Mailbox
            NPACAddons 010 049 Web to Oracle Interface Screen 3: Query
                                the Folder -- Choose a Folder
            NPACAddons 011 050 Web to Oracle Interface Screen 4: Query
                                the Folder
         CPS616webDBMS 024 051 Query by mail header
            NPACAddons 012 052 Web to Oracle Interface Screen 5: Query
                                by Mail Header -- Choose a Folder
            NPACAddons 013 053 Web to Oracle Interface Screen 6: Query
                                by mail header
            NPACAddons 021 054 Web to Oracle Interface Screen 14: 
                               Query Result -- Browse Mail Body --1
            NPACAddons 022 055 Web to Oracle Interface Screen 15: 
                               Query Result -- Browse Mail Body --2
         CPS616webDBMS 025 056 Query by date
            NPACAddons 014 057 Web to Oracle Interface Screen 7: Query
                                by Date --1
            NPACAddons 015 058 Web to Oracle Interface Screen 8: Query
                                by Date --2
         CPS616webDBMS 026 059 Query by Subject 
            NPACAddons 016 060 Web to Oracle Interface Screen 9: Query
                                by Subject --1
            NPACAddons 017 061 Web to Oracle Interface Screen 10: 
                               Query by Subject --2
         CPS616webDBMS 027 062 Query  by Sender     
            NPACAddons 018 063 Web to Oracle Interface Screen 11: 
                               Query by Sender
         CPS616webDBMS 028 064 Incorporating new mail into the 
                               Database from your UNIX mailbox --I
            NPACAddons 019 065 Web to Oracle Interface Screen 12: 
                               Incorporate New Mail from Web Page -- 
                               Choose a folder
         CPS616webDBMS 029 066 Incorporating new mail into the 
                               Database from your UNIX mailbox --II
            NPACAddons 020 067 Web to Oracle Interface Screen 13: 
                               Incorporate New Mail
         CPS616webDBMS 030 068 Format of Query results from all query 
                               options 
            NPACAddons 013 069 Web to Oracle Interface Screen 6: Query
                                by mail header
            NPACAddons 021 070 Web to Oracle Interface Screen 14: 
                               Query Result -- Browse Mail Body --1
            NPACAddons 022 071 Web to Oracle Interface Screen 15: 
                               Query Result -- Browse Mail Body --2
         CPS616webDBMS 031 072 Query options to be added in the future
                                to Oracle-based Web Mail System 
         CPS616webDBMS 032 073 Some Current(January 96) NPAC Web-RDBMS
                                Activities -- Enterprise Information 
                               Systems(EIS)
         CPS616webDBMS 033 074 Some Current(January 96) NPAC Web-RDBMS
                                Activities -- Full Text Web Search 
                               System
         CPS616webDBMS 034 075 Some Current(January 96) NPAC Web-RDBMS
                                Activities -- Mixture of well 
                               Structured and Full Text Entitities
         CPS616webDBMS 035 076 Some Current(January 96) NPAC Web-RDBMS
                                Activities -- Parallel Server 
                               Technology

List of Foils Used as they occur

CPS616Web-Oracle96M   Master Foilset for Web-Oracle Integration
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
CPS616webDBMS         CPS600 Presentation on Linkage of Web to 
                       Relational(Oracle) Databases
21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
NPACAddons            Collection of GIF Images for General NPAC 
                       Projects 1995-March96
8 9 10 11 12 13 21 22 14 15 16 17 18 19 20 13 21 22

Sorted List of Foils Used

CPS616Web-Oracle96M   Master Foilset for Web-Oracle Integration
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
CPS616webDBMS         CPS600 Presentation on Linkage of Web to 
                       Relational(Oracle) Databases
21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
NPACAddons            Collection of GIF Images for General NPAC 
                       Projects 1995-March96
8 9 10 11 12 13 13 14 15 16 17 18 19 20 21 21 22 22


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