slides

judgedrunkshipΔιακομιστές

17 Νοε 2013 (πριν από 3 χρόνια και 8 μήνες)

127 εμφανίσεις

Course Introduction

Dr. Shiyong Lu

shiyong@cs.wayne.edu

Wayne State Univesrity

About the Instructor


Advising students


Teaching database classes


Research on scientific workflows

http://www.cs.wayne.edu/~shiyong/

Dr. Shiyong Lu

3


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


4

What is this course about?


Transaction processing (ACID)


Concurrency control


Locking & logging


Distributed databases and transactions


5

Goal of the course


Knowledge of transaction processing,
concurrency control, and distributed
databases


Apply the knowledge to collaborative
editing of scientific workflows.



6

Prerequisite



CSC6710 Or with the permission of the
instructor


Java, JDBC and SQL programming

7

Instructor’s office hours

Instructor:


Shiyong Lu (shiyong@wayne.edu)


Office: 3006 Maccabees bldg




Telephone: 577
-
1667


Office hours: Tu, Th 11
-
12PM or by
appointment.


8

TA office hours


None


Office: TBA


Telephone: TBA


Office hours: TBA.


9

Course load and grading


(45 %) 3 Assignments, 15% each.


(40 %) One course project, two parts, graded
together in the end.


(15 %) Final exam.

10

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.



11

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.

12

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.