ch8 - Chapter 8: Application Design and Chapter Development...

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
©Silberschatz, Korth and Sudarshan 8.2 Database System Concepts - 5 th Edition, Oct 23, 2006. 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
Background image of page 2
©Silberschatz, Korth and Sudarshan 8.3 Database System Concepts - 5 th Edition, Oct 23, 2006. User Interfaces and Tools User Interfaces and Tools ± Most database users do not use a query language like SQL. z Forms z Graphical user interfaces z Report generators z Data analysis tools (see Chapter 18) ± Many interfaces are Web-based ± Back-end (Web server) uses such technologies as z Java servlets z Java Server Pages (JSP) z Active Server Pages (ASP)
Background image of page 3

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

View Full DocumentRight Arrow Icon
©Silberschatz, Korth and Sudarshan 8.4 Database System Concepts - 5 th Edition, Oct 23, 2006. 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 z text along with font specifications, and other formatting instructions z hypertext links to other documents, which can be associated with regions of the text. z forms , enabling users to enter data which can then be sent back to the Web server
Background image of page 4
©Silberschatz, Korth and Sudarshan 8.5 Database System Concepts - 5 th Edition, Oct 23, 2006. A formatted report A formatted report
Background image of page 5

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

View Full DocumentRight Arrow Icon
©Silberschatz, Korth and Sudarshan 8.6 Database System Concepts - 5 th Edition, Oct 23, 2006. 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 z Enable large numbers of users to access databases from anywhere z Avoid the need for downloading/installing specialized code, while providing a good graphical user interface z Examples: banks, airline and rental car reservations, university course registration and grading, an so on.
Background image of page 6
©Silberschatz, Korth and Sudarshan 8.7 Database System Concepts - 5 th Edition, Oct 23, 2006. Web Interfaces to Database (Cont.) Web Interfaces to Database (Cont.) 2. Dynamic generation of documents z 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. z
Background image of page 7

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

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

Page1 / 52

ch8 - Chapter 8: Application Design and Chapter Development...

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