webdatabases

webdatabases - Database System Concepts ©Silberschatz,...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Database System Concepts ©Silberschatz, Korth and Sudarshan See www.db-book.com for conditions on re-use ©Silberschatz, Korth and Sudarshan Database System Concepts Chapter 8: Application Design and Chapter 8: Application Design and Development Development ©Silberschatz, Korth and Sudarshan 8.2 Database System Concepts - 5 th Edition, Aug 9, 2005. Chapter 8: Application Design and Development Chapter 8: Application Design and Development ■ User Interfaces and Tools ■ Web Interfaces to Databases ■ Web Fundamentals ■ Servlets and JSP ■ Building Large Web Applications ■ Triggers ■ Authorization in SQL ■ Application Security ©Silberschatz, Korth and Sudarshan 8.3 Database System Concepts - 5 th Edition, Aug 9, 2005. User Interfaces and Tools 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) ©Silberschatz, Korth and Sudarshan 8.4 Database System Concepts - 5 th Edition, Aug 9, 2005. The World Wide Web The World Wide Web ■ 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 specifications, 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 ©Silberschatz, Korth and Sudarshan 8.5 Database System Concepts - 5 th Edition, Aug 9, 2005. A formatted report A formatted report ©Silberschatz, Korth and Sudarshan 8.6 Database System Concepts - 5 th Edition, Aug 9, 2005. Web Interfaces to Databases Web Interfaces to Databases 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 ● Examples: banks, airline and rental car reservations, university course registration and grading, an so on. ©Silberschatz, Korth and Sudarshan 8.7 Database System Concepts - 5 th Edition, Aug 9, 2005. Web Interfaces to Database (Cont.) Web Interfaces to Database (Cont.) 1. Dynamic generation of documents ● Limitations of static HTML documents Cannot customize fixed Web documents for individual users. Problematic to update Web documents, especially if multiple Web documents replicate data....
View Full Document

This note was uploaded on 02/17/2010 for the course ACS ACS-3911 taught by Professor Chen during the Spring '10 term at Windsor.

Page1 / 30

webdatabases - Database System Concepts ©Silberschatz,...

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

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