Transcript Performance Comparison of Database Access over the Internet

Web-based Software Development
- An introduction
The Client/Server Model
 Process to process communication (PPC)
 The underlying
programming.
platform
of
Web-based Software
Development
the
client/server
2
The Client/Server Model
 Two Tier (Traditional) Client/Server Model
Exercise: Name a commonly used client/server technique.
 Sockets programming
Web-based Software
Development
3
The Client/Server Model
 Three Tier Client/Database/Server Model
?
?
APIs:
JDBC
ADO
Web-based Software
Development
4
The Client/Server Model
 Two Tier Web Based Model
Web-based Software
Development
5
Three Tier Web Based Model
Web-based Software
Development
6
Multi-Tier Web Based Model
Various configurations?
 Multiple Databases
 Multiple application instances
 Distributed Databases
 Web server farm
Web-based Software
Development
7
Sample Web Based Applications
 dynamic web pages – interactive i/o
 multimedia presentations
 Web based multi-player games
 access to remote databases
 connectivity to legacy computer systems
 front end of a transaction application
 intranet applications
 scientific simulation and visualization
Web-based Software
Development
8
Sample Web Based Applications
- scientific simulation and visualization
Web-based Software
Development
9
Representative Web technology
- Client Side Development
• Interpreted or executed by the client (that is, the Web browser).
• Note: Web pages are originally stored on the Web server.
Web-based Software
Development
10
Representative Web technology
- Client Side Development
 Issues with client side scripting
• Inconsistent support across the Web browsers
• Source exposed to the viewer
• Awkward connectivity to back-end (e.g., ODBC)
• Security
Web-based Software
Development
11
Representative Web technology
- Server Side Development
• Interpreted or executed by the server side applications.
•The result is then sent back to the Web browser.
Web-based Software
Development
12
Representative Web technology
 Server Side Technologies
• Common Gateway Interface (CGI)
• Active Server Pages (ASP)
• Java Servlets
• Java Server Pages (JSP)
• Distributed Components-Based Technology
(
CORBA, DCOM, EJB, RMI, … )
Web-based Software
Development
13
Representative Web technology
 Database Connections
• JDBC: Java Database Connectivity
• ODBC: Open Database Connectivity
• OLE-DB
• ADO: ActiveX Data Objects
Web-based Software
Development
14
Representative Web technology
Components
Programming Tools
- languages, technologies and APIs
Web Browsers
Internet Explorer, Netscape Navigator
Java Virtual Machines (JVMs), plugins, activeX components, ...
Web Servers
Apache, IIS, …
Client-side programming:
HTML, JAVA Applets, Java Script, VB
Script, VRML, XML, …
Applications (Servers)
Oracle Application Server, WebSphere
Advanced Server, WebLogic,
Netscape Enterprise Server, …
Server-side programming:
Java Servlets, Java Server Pages,
Active Server Pages, CGI, Java
Script, VB Script, ...
Database Servers
Oracle Database Server, MS SQL
Server, IBM DB2, SyBase, Informix, …
ODBC, JDBC, ADO, SQL Net,
SQLJ, ...
Web-based Software
Development
15
Follow-ups:
• Read MSS Chapters 1 & 2 (part of Assignment 1)
Next:
• Overview of cryptography
Web-based Software
Development
16