Database System Concepts Essay

Submitted By yoganand1627
Words: 4738
Pages: 19
Open Document
Chapter 9: Application Design and
Development

Database System Concepts ­ 6th Edition

9.1

©Silberschatz, Korth and Sudarshan

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

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

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)

Database System Concepts ­ 6th Edition

9.4

©Silberschatz, Korth and Sudarshan

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

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

Uniform Resources Locators
 In the Web, functionality of pointers is provided by Uniform Resource

Locators (URLs).

 URL example:

http://www.acm.org/sigmod


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



An identifier (path name) of a program, plus arguments to be passed to the program
– E.g., http://www.google.com/search?q=silberschatz

Database System Concepts ­ 6th Edition

9.7

©Silberschatz, Korth and Sudarshan

HTML and HTTP
 HTML provides formatting, hypertext link, and image display features


including tables, stylesheets (to alter default formatting), etc.

 HTML also provides input features


Select from a set of options
– Pop­up menus, radio buttons, check lists



Enter values
– Text boxes



Filled in input sent back to the server, to be acted upon by an executable at the server

 HyperText Transfer Protocol (HTTP) used for communication with the

Web server

Database System Concepts ­ 6th Edition

9.8

©Silberschatz, Korth and Sudarshan

Sample HTML Source Text
<html>
<body> <table border>
<tr> <th>ID</th> <th>Name</th> <th>Department</th> </tr>
<tr> <td>00128</td> <td>Zhang</td> <td>Comp. Sci.</td> </tr>
….
</table> <form action="PersonQuery" method=get>
Search for: <select name="persontype"> <option value="student" selected>Student </option> <option
Show More

Related Documents: Database System Concepts Essay

Essay on Database System Concepts

Chapter 4: Intermediate SQL Database System Concepts, 6th Ed. ©Silberschatz, Korth and Sudarshan See www.db­book.com for conditions on re­use Chapter 4: Intermediate SQL  Join Expressions  Views  Transactions  Integrity Constraints  SQL Data Types and Schemas  Authorization Database System Concepts ­ 6th Edition 4.2 ©Silberschatz, Korth and Sudarshan Joined Relations  Join operations take two relations and return as a result another relation.  A join operation is a Cartesian product which requires that…

Words 2879 - Pages 12

Database System Concepts Essay example

Chapter 1: Introduction Database System Concepts, 6th Ed. ©Silberschatz, Korth and Sudarshan See www.db­book.com for conditions on re­use Database Management System (DBMS)  DBMS contains information about a particular enterprise  Collection of interrelated data  Set of programs to access the data  An environment that is both convenient and efficient to use  Database Applications:  Banking: transactions  Airlines: reservations, schedules  Universities: registration, grades…

Words 1215 - Pages 5

Finding Articles On Your Research: Using Library Databases

your research topic – using library databases When looking for articles on your research topic, the most effective tool to use is the library’s databases. These provide you with quality, scholarly articles, appropriate for academic study. Databases & Journal Finder— which one to use? There is sometimes confusion over when to use databases and when to use Journal Finder as both are tools for finding articles. Databases - you use databases when you want to find articles on a…

Words 946 - Pages 4

Assignment Berif Essays

Introduction In this assignment you will consider the nature of information and how an information system can gain a business a competitive advantage. You will plan, design and implement a database solution that meets a specific business scenario. Assignment brief Read the following case study carefully. It is based upon a local estate agency which currently uses a paper based system for processing sales. ------------------------------------------------- Clients wishing to put their…

Words 1498 - Pages 6

Essay about Review Questions Chapter 1 and 2

following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application. a) Data: Known facts that can be recorded and that have implicit meaning. b) Database: Collection of related data. c) DBMS: Is a collection of programs that enables users to maintain a database. d) Database system: Is a compilation of the database and complete definition…

Words 3545 - Pages 15

Online Reservation System Essay examples

so far by the use of Internet websites and online reservation systems, gives competitive advantage to other with same establishment. However, the potential competitive advantage can be transformed into real advantage if only the websites have proper design. As a result, the advocator conducted research on the facts related to the system that might be helpful to its development. The following are the gathered related proposed system: Jeong et al. (2005) discuss the role of website quality in…

Words 3773 - Pages 16

Logical Design Part 1

page paper titled “Logical Design, Part 1” whereas I am a recently hired consultant for ACME Global Consulting to procure requirements for a large database. In this scenario, “Logical Design, Part 1”, I will develop a database management systems to convince a set of clients of the benefits of using the Entity–Relationship model (E-R) in developing a database. In addition, my management would like the following points addressed in my design: (1). List the advantages of a relational model specific…

Words 1449 - Pages 6

Fundamentals of Database Systems Key Assignment Essay examples

Key Assignment Project Fundamentals of Database Systems CS251-1202B-03 June 25, 2012 Table of Contents Project Outline 4 Description of the Database Design Life Cycle (Phase 1 IP) 4 Selected Database Description 4 Tablet and Capsule Antibiotics 4 Powder and Liquid Antibiotics 5 Skin and Coat 5 A Listing And Description Of The 7 Steps Of The SDLC/DBDSL and Their Tasks 6 System Requirements Analysis and Feasibility Study 6 System Analysis 7 Code Generation and Design 9 Implementation…

Words 3571 - Pages 15

Research Paper On Security Policy

security. Security policies should minimize risk while not imposing undue access restrictions on those who need access to resources. This paper includes the password policy, wireless use policy, information logging standard, user privilege policy, database credentials policy and acceptance encryption policy. This paper briefly explains about the scope and procedures of each and every policy. Introduction When defining policies and when living with them from day to day, the reasons for…

Words 2117 - Pages 9

Cs251 Fundamantals of Database Systems Ip 1 - 5 Essay

CS251-1301B-03 Fundamentals of Database Systems Phase 1 -5 Individual Project Robert March 24th, 2013 Table of Contents Project Outline 3 Description of the Database Design Life Cycle 4 The Entity Relationship Diagram 7 The Logical Model and Normalization 9 The Microsoft Access Database 11 The Microsoft Access Database Application 14 References: 18 Project Outline My idea for a project concept is for a granite fabrication and installation company called MasterStoneWorks…

Words 1684 - Pages 7