Chapter 9:Application Design and Development Application Programs and User Interfaces Web Fundamentals Servlets and JSP Application Architectures Rapid Application Development Application Performance Application Security Encryption and Its Applications Database System Concepts-6th Edition 9.2 @Silberschatz,Korth and Sudarshan
Database System Concepts - 6 9.2 ©Silberschatz, Korth and Sudarshan th Edition Chapter 9: Application Design and Development Application Programs and User Interfaces Web Fundamentals Servlets and JSP Application Architectures Rapid Application Development Application Performance Application Security Encryption and Its Applications
Application Programs and User Interfaces Most database users do not use a query language like SQL An application program acts as the intermediary between users and the database Applications split into front-end middle layer backend Front-end:user interface Forms Graphical user interfaces Many interfaces are Web-based Database System Concepts-6th Edition 9.3 @Silberschatz,Korth and Sudarshan
Database System Concepts - 6 9.3 ©Silberschatz, Korth and Sudarshan th Edition Application Programs and User Interfaces Most database users do not use a query language like SQL An application program acts as the intermediary between users and the database Applications split into front-end middle layer backend Front-end: user interface Forms Graphical user interfaces Many interfaces are Web-based
Application Architecture Evolution Three distinct era's of application architecture mainframe(1960's and 70's) personal computer era(1980's) We era(1990's onwards) Terminals Desktop PCs Web browsers Application Application Program Program Propietary Network or dial up phone lines Local Area Network Internet Mainframe Computer Web Application Server Database Database (a)Mainframe Era (b)Personal Computer Era (c)Web era Database System Concepts-6th Edition 9.4 @Silberschatz,Korth and Sudarshan
Database System Concepts - 6 9.4 ©Silberschatz, Korth and Sudarshan th Edition Application Architecture Evolution Three distinct era’s of application architecture mainframe (1960’s and 70’s) personal computer era (1980’s) We era (1990’s onwards)
Web Interface 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 Javascript,Flash and other scripting languages run in browser,but are downloaded transparently Examples:banks,airline and rental car reservations,university course registration and grading,an so on. Database System Concepts-6th Edition 9.5 @Silberschatz,Korth and Sudarshan
Database System Concepts - 6 9.5 ©Silberschatz, Korth and Sudarshan th Edition Web Interface 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 Javascript, Flash and other scripting languages run in browser, but are downloaded transparently Examples: banks, airline and rental car reservations, university course registration and grading, an so on
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 Database System Concepts-6th Edition 9.6 @Silberschatz,Korth and Sudarshan
Database System Concepts - 6 9.6 ©Silberschatz, Korth and Sudarshan th Edition 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