30 likes | 128 Vues
Explore 2-tier and 3-tier architectures for database connectivity, comparing complex programming with simplified HTML for clients. Learn about SW distribution, power limitations, and transaction support in this informative guide.
E N D
Models for DB Connectivity Connectivity: 2/3 Tier 2-tier architecture 3-tier architecture • complicated programming • great SW power • logic client-sided • complicated SW distribution • permanent connection with client sided transaction support • simple HTML for client, adjustable complexity for middleware • limited SW power • logic hierarchically distributed • simplest SW distribution (none) • transient connection (data transfer) stateless model no client-side transaction support DBMS DBMS Web Server Browser Browser Swiss Federal Institute of Technology n
Models for DB Connectivity Connectivity: CGI, DLL, ASP CGI DBMS Browser Web Server DLL ASP Swiss Federal Institute of Technology n
Models for DB Connectivity Connectivity: CGI, DLL, ASP Details • Common Gatway Interface • independent programs in separate processes • PERL, REXX, or any prog. language CGI • proprietary: ISAPI, NSAPI • efficient, same process as server • any prog. Language • comfortable development environment (FP, Livewire) • may perjudice server process DLL • Proprietary (see also ColdFusion) • efficient, same process as server • scripts (VB, JS), JApplets, ActiveX controls • comfortable development environment (Visual IDev) ASP Swiss Federal Institute of Technology n