Web Database

Table of Content

Why Web Database Publishing

• Popularity of the World Wide Web
• Static Versus Interactive Pages
• Graphical User Interface
• Platform Independence
• Network Access
• Standard Interface
• Easily Expanded
• Summary
• Question

The Internet and the World Wide Web

• The Internet (TCP/IP, OSI Model)
• Client/Server Model (The Client, The Server)
• Summary
• Question

An Overview of HTML

• General Format, Header Tags, Body Tags
• URL
• Summary
• Questions

User Input

• The Basics
• Fill-Out Forms Using the FORM Tag (INPUT Tag, Menus, Multline Text Input)
• Sample Forms
• Imagemaps (Server-Side Imagemaps, Client-Side Imagemaps)
• HTML Editors
• Summary
• Questions

Common Gateway Interface (CGI) Basics

• Overview
• CGI in UNIX
  • Client to Server
  • Server to External Program
  • External Program to Server
  • Server to Client
  • Sample Program
  • Server Configuration
• CGI in Windows
  • Launching the External Program
  • The CGI Data File
  • Sample Program
  • Server Configuration
  • Windows 95 and Windows NT
• CGI in Mac OS
  • Invocation of the External Program
  • Data Transfer
  • Server Configuration
• MIME in Web Applications
• Summary
• Questions

Database Basics

• What is Database (Data Collection, Data Organization)
• Database Client/Server Model (The Server, The Client)
• SQL
  • Creating a Table
  • Data Insertion
  • Queries
  • Joins
  • Sub-queries
  • Union
  • Modifying Data
  • Functions
  • Backup and Recovery
  • Locks
• A Word on Data Integrity
• Database Systems
• Summary
• Questions

Application Design

• HTTP Server (Setting Up the HTTP Server)
• HTTP Client
• Compiler/Interpreter
• Database System
• Application Design (Function, User Interface, Implementation)
• Specifying the Program Flow
• Summary
• Question

Choosing a Programming Language

• Overview
• C (cgic: ANSI C library for CGI Programming, LIBCGI, CGIHTML)
• C++
• Perl
• TCL
• Shell Script
• Visual Basic
• PowerBuilder
• Java
  • (JDBC API
  • JDBC Driver Interface
  • Application Usage
  • Data Types
  • An Example)
• JavaScript
• Visual Basic Script
• Summary
• Question

Choosing the Right Tool

• Overview
• DB2WWW (Data Security)
• dbCGI
• DBperl
• Genera
• GSQL (The PROC File, Writing the Database Back-End)
• Informix CGI Interface Kit
• Ingres Tools Archive
• Mini SQL
• ORALink
• (More example ...)

The Final Application

• Looking at the Overall Picture
• Networked Database Server
• Non-Networked Database Server
• Networking Considerations
• How Does CGI Fit in the Picture (CGI Program Communication with the Database)
• How Java Changes the Picture
• Summary
• Questions

Security Issues

• The Problem
• S-HTTP
  • Authentication
  • Privacy
  • HTTP Encapsulation
  • Negotiation
  • Vulnerabilities
• SSL (Vulnerabilities)
• Securing Your Server
• CGI Security
• Java and Security
• Other Issues
• Summary
• Questions

Maintaining Your Application

• Documentation
  • Network Connections
  • Security Documentation
  • Application Documentation
• Performance Monitoring
• Common Bugs
• Expanding Your Application
• Summary
• Questions

Sample Application: Conference Registration System

• Specifications
• Environment
• CGI Program

Sample Application: Trouble Reporting System

• Specifications
• Environment
• CGI Program
  • Main Screen
  • Reporting a Problem
  • Problem Resolution
  • Problem Lookup

Sample Application: Using the JDBC

• Specification
• Environment
• Java Program

Real World Applications

• Federal Express
• American Airlines
• Switchboard
• StockMaster
• University of Missouri Course Catalog
• The Wall Street Journal
• Lombard
• Wells Fargo
• Patient Record Database
• Live Java Graphs

New Technologies

• Internet Architecture
• Application Servers
• Java
• Networking
• Security
• Databases
• Active X Controls
• Network PC

////////