Transcript Overview of Databases and Transaction Processing

Course Introduction
Dr. Shiyong Lu
[email protected]
Wayne State Univesrity
About the Instructor
•Advising students
•Teaching database classes
•Research on scientific workflows
http://www.cs.wayne.edu/~shiyong/
Dr. Shiyong Lu
CSC7710:Database Management System II
• Time: 4:30-5:50PM TuTh
• Place: State Hall 318
• Webpage:
http://www.cs.wayne.edu/~shiyong/csc7710/csc7710.html
3
What is this course about?
•
•
•
•
Transaction processing (ACID)
Concurrency control
Locking & logging
Distributed databases and transactions
4
Goal of the course
• Knowledge of transaction processing,
concurrency control, and distributed
databases
• Apply the knowledge to collaborative
editing of scientific workflows.
5
Prerequisite
• CSC6710 Or with the permission of the
instructor
• Java, JDBC and SQL programming
6
Instructor’s office hours
Instructor:
• Shiyong Lu ([email protected])
• Office: 3006 Maccabees bldg
• Telephone: 577-1667
• Office hours: Tu, Th 11-12PM or by
appointment.
7
TA office hours
•
•
•
•
None
Office: TBA
Telephone: TBA
Office hours: TBA.
8
Course load and grading
• (45 %) 3 Assignments, 15% each.
• (40 %) One course project, two parts, graded
together in the end.
• (15 %) Final exam.
9
Late work penalty
You can have one late assignment submission
up to one week without any penalty. Please
email me in advance when you need to use
your execuse. If late excuse is not used, a
penalty of 2 % per day will be assessed up
to one week. No credits will be given for
works handed in one week after the due
date. The late excuse cannot be used for the
final project.
10
Academic honesty
Copying an assignment from another student
in this class or obtaining a solution from
some other source will lead to an automatic
failure for this course and to a disciplinary
action. Allowing another student to copy
one's work will be treated as an act of
academic dishonesty, leading to the same
penalty as copying.
11
Assignment 1
1. Install Ubuntu http://www.ubuntu.com/
2. Learn Linux commands:
https://sites.google.com/site/swfwiki/
3. Install mysql: http://www.mysql.com/
4. Install Apache Tomcat:
http://tomcat.apache.org/
5. Write a Web-based application that uses
HTML, Javascript, Java, and mysql.
12