DATABASE APPLICATION DEVELOPMENT SAK 3408
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.
DATABASE APPLICATION DEVELOPMENT SAK 3408
E N D
Presentation Transcript
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