Computer Science Course Information
Back to CS Home Page

Computer Science Course Information

Level >Graduate >FALL_2005 >List >

Advanced Database Systems Design

Course No. CIS 632
Sections 001
Title Advanced Database Systems Design
Course Website
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
  • Office Room No. : 4307 GITC
  • Office Phone : 973 596-3383
  • Fax : 973-596-5777
  • Email :
  • Website:
  • Lab : Semantic Web & Ontologies Lab
  • Instructor Office Hours
    Description Review your SQL and learn more of it.
    Learn PL/SQL.
    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.
    Topics Introduction
    9-01 PL/SQL as "normal" language
    PL/SQL accessing tables
    OO Principles of OODBs
    Inserting etc. in PL/SQL
    Object-Oriented DBs
    Triggers in PL/SQL
    Object-Relational DB
    Objects in SQL
    Intro to XML
    XML in SQL
    Database Security
    Querying XML
    Parallel Databases
    Querying System tables
    Multi-Media Databases
    More on System Tables
    The dbms_sql package
    Web Database systems
    JDBC, CGI WebDBs
    Advanced SQL Lessons
    JavaScript WebDBs II
    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
    Other Info Grading:
    The assignments will be assigned points from the following maximum:

    Midterm: 150
    Final: 200
    Homework 1: 50
    Homework 2: 50
    Homework 3: 75
    Homework 4: 75
    Total 600

    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
    ( 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.

    Registrar's Website