BAYLOR CSI 3335 - COURSE SYLLABUS (38 pages)

Previewing pages 1, 2, 3, 18, 19, 36, 37, 38 of 38 page document View the full content.
View Full Document

COURSE SYLLABUS



Previewing pages 1, 2, 3, 18, 19, 36, 37, 38 of actual document.

View the full content.
View Full Document
View Full Document

COURSE SYLLABUS

86 views


Pages:
38
School:
Baylor University
Course:
Csi 3335 - Database Design & Application
Database Design & Application Documents
Unformatted text preview:

Chapter 8 Application Design and Development Database System Concepts Silberschatz Korth and Sudarshan See www db book com for conditions on re use Database System Concepts Silberschatz Korth and Sudarshan Chapter 8 Application Design and Development User Interfaces and Tools Web Interfaces to Databases Web Fundamentals Servlets and JSP Building Large Web Applications Authorization in SQL Application Security Database System Concepts 5th Edition Oct 23 2006 8 2 Silberschatz Korth and Sudarshan User Interfaces and Tools Most database users do not use a query language like SQL Forms Graphical user interfaces Report generators Data analysis tools see Chapter 18 Many interfaces are Web based Back end Web server uses such technologies as Java servlets Java Server Pages JSP Active Server Pages ASP PHP Hypertext Preprocessor PHP Database System Concepts 5th Edition Oct 23 2006 8 3 Silberschatz Korth and Sudarshan The World Wide Web The Web is a based on HyperText Markup Language HTML documents HTML documents contain text with formatting instructions hypertext links to other documents Images Active data such as flash movies forms enabling users to enter data which can then be sent back to the Web server HTTP HyperText Transfer Protocol is describes how data is transferred Database System Concepts 5th Edition Oct 23 2006 8 4 Silberschatz Korth and Sudarshan A formatted report Database System Concepts 5th Edition Oct 23 2006 8 5 Silberschatz Korth and Sudarshan Web Interfaces to Databases 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 Examples banks airline and rental car reservations university course registration and grading and statistics Database System Concepts 5th Edition Oct 23 2006 8 6 Silberschatz Korth and Sudarshan Web Interfaces to Database Cont 2 Dynamic generation of documents Limitations of static HTML documents Cannot customize 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 Database System Concepts 5th Edition Oct 23 2006 8 7 Silberschatz Korth and Sudarshan Uniform Resources Locators In the Web functionality of pointers is provided by Uniform Resource Locators URLs URL example http www db book com The first 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 identifies the document within the machine The local identification can be The path name of a file on the machine or A program plus arguments to be passed to the program E g http www google com search q silberschatz A fragment identifier follows Database System Concepts 5th Edition Oct 23 2006 8 8 Silberschatz Korth and Sudarshan Sample HTML Source Text 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 option value Loan Loan select input type text size 5 name number input type submit value submit form body html Database System Concepts 5th Edition Oct 23 2006 8 9 Silberschatz Korth and Sudarshan Display of Sample HTML Source Database System Concepts 5th Edition Oct 23 2006 8 10 Silberschatz Korth and Sudarshan Client Side Scripting and Applets Browsers can fetch certain scripts client side scripts or programs along with documents and execute them in safe mode at the client site Javascript Macromedia Flash and Shockwave for animation games AJAX Applets Client side scripts programs allow documents to be active E g animation by executing programs at the local site E g ensure that values entered by users satisfy some correctness checks Permit flexible interaction with the user Asynchronous downloads speed up interaction by avoiding many round trips to server Database System Concepts 5th Edition Oct 23 2006 8 11 Silberschatz Korth and Sudarshan Client Side Scripting and Security Security mechanisms needed to ensure that malicious scripts do not cause damage to the client machine Easy for limited capability scripting languages harder for general purpose programming languages like Java E g Java s security system ensures that the Java applet code does not make any system calls directly Disallows dangerous actions such as file writes Notifies the user about potentially dangerous actions and allows the option to abort the program or to continue execution Database System Concepts 5th Edition Oct 23 2006 8 12 Silberschatz Korth and Sudarshan Web Servers A Web server can easily serve as a front end to a variety of information services The document name in a URL may identify an executable program that when run generates a HTML document When a HTTP server receives a request for such a document it executes the program and sends back the HTML document that is generated The Web client can pass extra arguments with the name of the document To install a new service on the Web one simply needs to create and install an executable that provides that service The Web browser provides a graphical user interface to the information service PHP an HTML embedded scripting language to allow web developers to write dynamically generated pages quickly Database System Concepts 5th Edition Oct 23 2006 8 13 Silberschatz Korth and Sudarshan Three Tier Web Architecture Database System Concepts 5th Edition Oct 23 2006 8 14 Silberschatz Korth and Sudarshan Two Tier Web Architecture Multiple levels of indirection have overheads Alternative two tier architecture Database System Concepts 5th Edition Oct 23 2006 8 15 Silberschatz Korth and Sudarshan HTTP and Sessions The HTTP protocol is connectionless That is once the server replies to a request the server closes the connection with the client and forgets all about the request In contrast Unix logins and JDBC ODBC connections stay connected until the client disconnects Motivation reduces load on server


View Full Document

Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view COURSE SYLLABUS and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view COURSE SYLLABUS and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?