|Back to CS Home Page|
Computer Science Course Information
|Course No.||CIS 632||Sections||001|
|Title||Advanced Database Systems Design|
|Prerequisite(s)||It is assumed that you have taken a graduate database class before and understand the relational data model well.
It is assumed that you know SQL.
It is assumed that you have extensive experience in programming.
|Instructor|| James Geller
|Instructor Office Hours|
|Description||Review your SQL and learn more of it.
Study small parts of other languages that are needed in system building.
We are interested in systems that have a Web frontend and a relational database backend.
Study a few advanced topics on databases, such as XML, OODBs, DB security,multimedia and parallel databases and ontologies.
9-01 PL/SQL as "normal" language
PL/SQL accessing tables
OO Principles of OODBs
Inserting etc. in PL/SQL
Triggers in PL/SQL
Objects in SQL
Intro to XML
XML in SQL
Querying System tables
More on System Tables
The dbms_sql package
Web Database systems
JDBC, CGI WebDBs
Advanced SQL Lessons
More Advanced SQL Lessons
You Choose the Topic
|Text Book(s)||Oracle 9i Programming: A Primer by Rajshekar Sunderraman.
Addison Wesley 2003.
|Time & Place||Friday 10:00 am - 12:55 pm, Kupf 106|
The assignments will be assigned points from the following maximum:
Homework 1: 50
Homework 2: 50
Homework 3: 75
Homework 4: 75
At the end of the semester, I will add up your total points and curve the results for the whole class. The top 25% of the class are guaranteed to get an A. IN ADDITION, students with 550 points or more are also guaranteed an A. However, with 549 points you MIGHT very well get a B+. It all depends on the curve.
Academic Honor Code
The NJIT academic honor code
(http://www.njit.edu/academics/honorcode.php)applies in full to this
class. Note in particular that copying programs, in full or in part, is
forbidden. You may discuss ideas and concepts with your fellow
students, but you may NOT copy any code.