CS178 Database Management

1
CS178 Database Management

• Spring 2009

2
Introduction

• Lab instructor
• Peter Letzler
• peter.letzler_at_gmail.com
• Office Hours TBA
• Lab page will be linked from the course page
• http//www.seas.gwu.edu/bhagiweb/cs178/

3
Very Important!

• When sending emails to the TA
• specify CS178 in the subject
• allow 1-2 weekdays for reply
• do not use Bcc

4
Today

• Fill out the survey
• Apply for a mysql account
• What do I expect from students in the lab
• CS178 Lab Outline

5
Fill out the survey
6
What do I expect from students in the lab

• Project assigned by Prof. Narahari
• Homework assigned by Prof. Narahari
• Programming assignments
• Submit using Blackboard
• Due at 11.59pm
• No late submissions will be accepted, except
• You are allowed to have a 7 days late submission,
  once in a semester, no questions asked. This is
  valid ONLY for programming assignments.

7
What do I expect from students in the lab

• Grading policy for programming assignments
• Queries with syntactic errors will not be
  considered.
• Run your queries before sending them
• If the query works, it is likely you will get all
  the points for it

8
What do I expect from students in the lab

• I will explain everything in the lab. Be there!
• You are expected to play with the tools on your
  own and learn at least enough to do the project.
• Start early this way we might have time to
  answer to your questions

9
Lab Outline

• What we will do
• SQL, SQL Plus, PL SQL, etc
• Programming Assignments
• Project Walkthroughs
• PHP, JDBC

10
Database and DBMS

• Database is a collection of data. (ex.
  information about students at GW, products in a
  store amazon )
• DBMS ( Database Management System) is a program
  designed to assist in maintaining and utilizing
  databases.
• ex. Oracle, MySQL, Microsoft SQL Server,
  postgreSQL
• Applications that use a database through a DBMS
• direct queries
• web applications
• desktop applications

11
Multi-tier architecture

• Web client (ex. Firefox)
• Web server (ex. Apache)
• Application server (ex Php)
• Database server (ex. MySql)