WebDB - Connecting Databases to the Web Oct 25th, 2000 Gong...

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon
Connecting Databases to the Web Oct 25th, 2000 Gong Zhiguo
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Gong Z.G.--Connecting Databases to the Web 2 How the Web Works The old fashioned way: Web-Browser HTTP-Request GET . .. Web-Server File-System Load File HTML-File HTML-File
Background image of page 2
Gong Z.G.--Connecting Databases to the Web 3 How the Web Works All pages are static Need to generate web pages on the fly depending on user input ?
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Gong Z.G.--Connecting Databases to the Web 4 Some files on server are interpreted as programs depending on either ext., flag or special directory Program is invoked and generates MIME header and HTML on stdout Web-Server Common Gateway Interface (CGI) HTTP-Request HTML-File Web-Server File-System Load File File HTML? HTML Execute Program Program? Output I/O, Network, DB
Background image of page 4
Gong Z.G.--Connecting Databases to the Web 5 Advantages: - Standardized : works for every web-server, browser - Flexible : Any language (C++, Perl, Java, …) can be used Disadvantages: - Statelessness : query-by-query approach - Inefficient : new process for every request - Security : CGI programmer is responsible for security - Updates : To update layout, one has to be a programmer CGI: Discussion
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Gong Z.G.--Connecting Databases to the Web 6 Java Applets Web-Server HTTP-Request HTML-File Web-Server File-System Load File File Load Applet. .. Java-Class Requests Java-Classes Execute Applet. .. Java Virtual Machine (JVM) Server- Process
Background image of page 6
Gong Z.G.--Connecting Databases to the Web 7 Advantages: - Platform independent : works for every web-server and browser supporting Java Disadvantages: - Standalone Character : · Entire session runs inside applet · HTML forms are not used - Inefficient : loading can take a long time . .. - Resource intensive : Client needs to be state of the art - Restrictive : can only connect to server where applet was loaded from (restrictions of Java VM) Note: Server-Process can be written in any language Java Applets: Discussion
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Gong Z.G.--Connecting Databases to the Web 8 Java-Server-Process DB Access in Java Sybase Java Applet TCP/UDP IP Oracle ... JDBC- Driver JDBC- Driver JDBC- Driver JDBC Driver manager
Background image of page 8
Gong Z.G.--Connecting Databases to the Web 9 Previous Approaches - Platform independent and standardized - Simple interface - Lots of programming necessary - Inefficient Server Extensions - Server is extended with handler/module - One handler for all incoming requests - Much more efficient Server Extensions
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Gong Z.G.--Connecting Databases to the Web 10 Server Extensions: The Basic Idea File-System Web-Server HTTP-Request HTML-File Web-Server Load File File HTML? HTML I/O, Network, DB Script? Output Server Extension
Background image of page 10
Gong Z.G.--Connecting Databases to the Web 11 API depends on Server vendor: - Apache Foundation Apache Server: Apache API - Microsoft Internet Information Server: ISAPI - Netscape Enterprise Server: NSAPI One can define it’s own server extension, e.g.
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/23/2009 for the course DBST 663 taught by Professor Tba during the Spring '09 term at MD University College.

Page1 / 41

WebDB - Connecting Databases to the Web Oct 25th, 2000 Gong...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online