TAILIEUCHUNG - Lecture Database system concepts (5/e): Chapter 8 - Silberschatz, Korth, Sudarshan 

This chapter covers application design and development. This chapter emphasizes the construction of database applications with Web-based interfaces. In addition, the chapter covers application security. | 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 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) 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 A formatted report Web Interfaces to Databases Why interface databases to the Web? 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. Web Interfaces to Database (Cont.) 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. Solution: Generate Web documents dynamically from data stored in a database. Can tailor the display based on user information stored in the database. . tailored ads, tailored weather and local news, Displayed information is up-to-date, unlike the static Web pages . stock market .

• Cơ sở dữ liệu
• Database system
• Lecture Database system
• Relational databases
• Database design
• Application design
• Application design
• Web fundamentals
• Database system concepts
• Lecture Database system concepts
• Database systems
• Database languages
• Database system architectures
• Relational database design
• Database system architecture
• File based approach
• Data management systems framework
• Recovery system
• Lecture Database systems
• Database architecture
• Database approach
• Database design process
• Query optimization
• Transaction state
• Concurrency control
• Data analysis
• Information retrieval
• Parallel databases
• Distributed databases
• Advanced application development
• Advanced data types
• Advanced transaction processing
• Relational model
• Basic query structure
• Dynamic SQL
• Tuple relational calculus
• Entity relationship model
• Object­ based databases