100 likes | 249 Views
DATABASE APPLICATION DEVELOPMENT SAK 3408. The Web and DBMS. The Web as Database Application Platform. Providing users with an interface to one or more database. Requirements for Web-DBMS Integration. The ability to access valuable information in a secure manner.
E N D
DATABASE APPLICATION DEVELOPMENTSAK 3408 The Web and DBMS
The Web as Database Application Platform • Providing users with an interface to one or more database. SAK3408 by PSS
Requirements for Web-DBMS Integration • The ability to access valuable information in a secure manner. • Data and vendor independent connectivity to allow freedom of choice in the selection of DBMS now and in the future. • The ability to interface to the database of any propriety web browser or web server. • A connectivity solution that takes advantage of all the features of an organization’s DBMS. • Acceptable performance. • Minimal administration overhead. • Support for transaction that spam multiple HTTP requests. • Support for session – and application based authetication. SAK3408 by PSS
Web-DBMS Architecture • Considering client-server architecture for DBMS • Traditional two-tier architecture • Three-tier architecture SAK3408 by PSS
Two-tier Application First Tier Tasks Client • User interface • Main business and data • processing logic Second Tier Tasks Database Server • Server-side validation • Database access SAK3408 by PSS
Three-tier Application First Tier Tasks Client • User interface Tasks Second Tier • Business logic • Data processing logic Application Server Tasks Third Tier • Data validation • Database access Database Server SAK3408 by PSS
Advantages of Web-DBMS • Simplicity • Platform independence • Graphical User Interface • Standardization • Cross platform support • Transparent network access • Scalable deployment • Innovation SAK3408 by PSS
Disadvantages of Web-DBMS • Reliability • Security • Cost • Scalability • Limited functional of HTML • Statelessness • Bandwidth • Performance • Immaturity of development tools SAK3408 by PSS
Scripting Languages • Scripting languages allows the creation of functions embedded within HTML code allowing various process to be automated and object to be accessed and manipulated. • Scripting engine seek to resolve the problem of having no functioning application code in the browser. • As the script code embedded in the HTML, it is downloaded every time the page is accessed. • Updating the page in the browser is simply a matter of changing the web document on the server. SAK3408 by PSS
Scripting Engine • JavaScript • VBScript • Per and PHP • JavaSever Pages • Active Server Pages • An so on….. SAK3408 by PSS