5.1.jdbc - Web Applications Engineering: Database Access...

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

View Full Document Right Arrow Icon
Web Applications Engineering: Database Access using JDBC Service Oriented Computing Group, CSE, UNSW Week 5 Acknowledgement: Some examples are originated from Dr. David Edmond from School of Information Systems, QUT, Brisbane. H. Paik, S. Venugopal (CSE, UNSW) COMP9321, 11s1 Week 5 1 / 51
Background image of page 1

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

View Full DocumentRight Arrow Icon
Data is Everywhere Wal-Mart - 1 mil. transactions an hour - 2.5 PB Facebook - 40 billion photos Sloan Digital Sky Survey - 140 TB in 10 years How do we store and access this data over the web ? H. Paik, S. Venugopal (CSE, UNSW) COMP9321, 11s1 Week 5 2 / 51
Background image of page 2
Case 1: E-Commerce website H. Paik, S. Venugopal (CSE, UNSW) COMP9321, 11s1 Week 5 3 / 51
Background image of page 3

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

View Full DocumentRight Arrow Icon
Case 1: E-Commerce website Data operations are mainly transactions (Reads and Writes) ACID (Atomicity, Consistency, Isolation, Durability) properties are important Operations are mostly on-line Response time should be quick but important to maintain security and reliability of transactions H. Paik, S. Venugopal (CSE, UNSW) COMP9321, 11s1 Week 5 4 / 51
Background image of page 4
Case 2: Image serving website H. Paik, S. Venugopal (CSE, UNSW) COMP9321, 11s1 Week 5 5 / 51
Background image of page 5

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

View Full DocumentRight Arrow Icon
Case 2: Image serving website Data operations are mainly fetching large files (Reads) ACID requirements can be relaxed Operations are mainly on-line High bandwidth requirement H. Paik, S. Venugopal (CSE, UNSW) COMP9321, 11s1 Week 5 6 / 51
Background image of page 6
Case 3: Search website H. Paik, S. Venugopal (CSE, UNSW) COMP9321, 11s1 Week 5 7 / 51
Background image of page 7

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

View Full DocumentRight Arrow Icon
Case 3: Search website Data operations are mainly reading index files for answering queries (Reads) ACID requirements can be relaxed Index compilation is performed off-line due to the large size of source data (the entire Web) Response times must be as fast as possible. H. Paik, S. Venugopal (CSE, UNSW) COMP9321, 11s1 Week 5 8 / 51
Background image of page 8
Relational Databases Data is stored as a collection of tuples that groups attributes e.g. (student-id, name, birthdate, courses) Data is visualized as tables where the tuples are the rows and the attributes form the columns Tables can be related to each other through specific columns. Each row in a table has at least one unique attribute. H. Paik, S. Venugopal (CSE, UNSW) COMP9321, 11s1 Week 5 9 / 51
Background image of page 9

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

View Full DocumentRight Arrow Icon
Relational Databases Why RDBMS ? (PHP and MySQL Web Development, Third Edition, SAMS) RDBMSs can provide faster access to data than flat files. RDBMSs can be easily queried to extract sets of data that fit certain criteria. RDBMSs have built-in mechanisms for dealing with concurrent access so that you, as a programmer, don’t have to worry about it. RDBMSs provide random access to your data. RDBMSs have built-in privilege systems. H. Paik, S. Venugopal (CSE, UNSW) COMP9321, 11s1 Week 5 10 / 51
Background image of page 10
Delicious Baking Company Cars Database Table Cars: Web application for Cars: H. Paik, S. Venugopal (CSE, UNSW) COMP9321, 11s1 Week 5 11 / 51
Background image of page 11

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

View Full DocumentRight Arrow Icon
Structured Query Language (SQL) Is a means to query and manipulate data stored in relational databases. Is a declarative language in which operations are expressed in
Background image of page 12
Image of page 13
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/20/2011 for the course COMP 9417 taught by Professor Some during the Three '11 term at University of New South Wales.

Page1 / 51

5.1.jdbc - Web Applications Engineering: Database Access...

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

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