CS453: Databases and State in Web Applications (Part 2)

1
CS453 Databases and State in Web Applications
(Part 2)

• Prof. Tom Horton

2
Readings

• Textbook
• Chapter 17, Transactions
• On the web
• Virtual labs on MySQL
• Other tutorials
• Quick intro two chapters in Just Java
• On-line book
• PHP and MySQL Web Development. 3/e
• http//proquest.safaribooksonline.com/0672326728

3
DBMS and Web Apps

• Server-side applications use a database instead
  of flat files
• What are the advantages of this?

4
Advantages of DBs

• Concurrent access
• Transactional integrity
• Backup, rollback,
• Efficient storage of large amounts of data

5
Relational Database Model

• Leading model of how to organize a DB
• Tables
• Rows and columns
• Keys
• Multiple tables, with rows linked together by
  keys (joins)
• Tables as relationships

6
SQL Structured Query Language

• Common query language for accessing many RDBMS
• Oracle, Postgres, MySQL, Sybase,SQL Server
• Slight variations between implementations
• Common commands
• SELECT for retrieving data
• INSERT, UPDATE
• ALTER

7
Learn More

• Virtual labs, tutorials, etc.
• Suggestions from CS462 veterans?

8
Example