13_2 Application Development and Administration

13_2 Application Development and Administration - Web...

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

View Full Document Right Arrow Icon
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 Web Interfaces to Databases Performance Tuning Performance Benchmarks Standardization E-Commerce Legacy Systems
Background image of page 2
3 The Web is a distributed information system based on hypertext. Most Web documents are hypertext documents formatted via the HyperText Markup Language (HTML) HTML documents contain text along with font speciFcations, and other formatting instructions hypertext links to other documents, which can be associated with regions of the text. forms , enabling users to enter data which can then be sent back to the Web server
Background image of page 3

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

View Full DocumentRight Arrow Icon
4 Why interface databases to the Web? 1. Web browsers have become the de-facto standard user interface to databases Enable large numbers of users to access databases from anywhere Avoid the need for downloading/installing specialized code, while providing a good graphical user interface E.g.: Banks, Airline/Car reservations, University course registration/grading, …
Background image of page 4
5 2. Dynamic generation of documents Limitations of static HTML documents Cannot customize Fxed Web documents for individual users. Problematic to update Web documents, especially if multiple Web documents replicate data. Solution: Generate Web documents dynamically from data stored in a database. Can tailor the display based on user information stored in the database. E.g. tailored ads, tailored weather and local news, … Displayed information is up-to-date, unlike the static Web pages E.g. stock market information, . . Rest of this section: introduction to Web technologies needed for interfacing databases with the Web
Background image of page 5

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

View Full DocumentRight Arrow Icon
6 In the Web, functionality of pointers is provided by Uniform Resource Locators (URLs). URL example: http://www.bell-labs.com/topics/book/db-book The Frst part indicates how the document is to be accessed “http” indicates that the document is to be accessed using the Hyper Text Transfer Protocol. The second part gives the unique name of a machine on the Internet. The rest of the URL identiFes the document within the machine. The local identiFcation can be: The path name of a Fle on the machine, or An identiFer (path name) of a program, plus arguments to be passed to the program E.g. http://www.google.com/search?q=silberschatz
Background image of page 6
7 HTML provides formatting, hypertext link, and image display features. HTML also provides input features Select from a set of options Pop-up menus, radio buttons, check lists Enter values Text boxes Filled in input sent back to the server, to be acted upon by an executable at the server HyperText Transfer Protocol (HTTP) used for communication with the Web server
Background image of page 7

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

View Full DocumentRight Arrow Icon
8 <html> <body> <table border cols = 3> <tr> <td> A-101 </td> <td> Downtown </td> <td> 500 </td> </tr> </table> <center> The <i>account</i> relation </center> <form action=“BankQuery” method=get> Select account/loan and enter number <br> <select name=“type”> <option value=“account” selected> Account
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/24/2011 for the course CS 585 at USC.

Page1 / 71

13_2 Application Development and Administration - Web...

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

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