Office Hours and Days: MW 17:30 to 19:00 and MW 21:45 to
22:20
Course information
Course Description: Computing topics of current interest
in industrial practice. This section focuses specifically on Query
Processing in Industrial-Strength RDBMS. Topics include:
Application Programming
Query Processing
Query Optimization
Query Performance Monitoring
Autonomic Optimization
Prerequisites: CS 157A (with
a grade of "C-" or better) or instructor consent.
Recommended Text:
Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom,
Database Systems: The Complete Book,
Prentice Hall, 2rd ed, 2008, ISBN: 978-0131873254
Required Equipment: Wireless laptop
Student Learning Objectives
On successful completion of this course students should be
able to:
understand database systems from an application programmer's
point of view
understand how the database system processes a query
understand the techniques for database system optimization
monitor and analyze query performance
be acquainted with some future trend in database systems
Course Requirements
Homework: 50%
Midterm Exam I : 15%
Midterm Exam II : 15%
Final Exam: 20%
Tentative Course Calendar
Midterm Exam I (Wednesday, Oct. 1)
Midterm Exam II (Wednesday, Nov. 5)
Final Exam (Wednesday, Dec. 17, 19:45-22:00)
Grading Method
Percentage
Grade
92 and above
A
90 - 91
A-
88 - 89
B+
82 - 87
B
80 - 81
B-
78 - 79
C+
72 - 77
C
70 - 71
C-
60 - 69
D
59 and below
F
No make-up exams will be given and
no late homework will be accepted.
University, College, or Department
Policy Information
Academic integrity statement (from
Office of Judicial Affairs):“Your own commitment to learning, as evidenced by
your enrollment at San JoséStateUniversity, and the University’s Academic Integrity Policy requires
you to be honest in all your academic course work.Faculty are required to report all infractions to the
Office of Student Conduct and Ethical Development.The policy on
academic integrity can be found at http://sa.sjsu.edu/student_conduct.
Campus policy in compliance with
the Americans with Disabilities Act:“If you need course adaptations or accommodations
because of a disability, or if you need special arrangements in case the
building must be evacuated, please make an appointment with me as soon as
possible, or see me during office hours.Presidential
Directive 97-03 requires that students with disabilities register with SJSU
Disability Resource Center to establish a record of their disability.”
Please familiarize yourself with SJSU policies and procedures:
particularly the add/drop
policy. It is your responsibility to know and observe these policies.
However, if there is something about a policy that you don't understand,
please feel free to ask! You can also find answers to many questions at
the Student Advising Center.
Note that this semester the last day to drop without consequence is Friday, Sept. 5, and the last day to add
is Friday, Sept. 12. After these
dates it becomes very difficult to drop or add a class, so be sure you
are in good shape before these dates arrive!