ISE 326 -  Database Systems Engineering
Semester 2 5770

Topics     Reading     Projects     Grading     Lectures     Policies

Time: Sunday 11:00 - 13:00 in Caravan 510
Targil: Tuesday 8:00 - 9:00 in Room 202

Instructor:

    Michael J. May
      e-mail: mjmay (AT) kinneret,ac,il
      office hours: Wednesday. 11:00-12:00 (and by appointment)

Metargel:

    Dan Koenig
    email: koenig22@

    
The full detailed syllabus for the course is available here.

Reminder: Final A grades on Telem.

Topics:

  • Transaction Management: Checking for conflicts and recovering from failures
  • Parallel and Distributed Databases: Architectures, Storage, Indexing, and Queries
    • Included in this is a discussion of query evaluation and indexing as necessary
  • Object Oriented Databases: Abstract Data Types, Inheritance
  • Data Warehousing

Reading

The following book contains useful course material, and much of the lecture content is derived from them (and other sources). Copies of these books are on reserve in the Kinneret Library.

  • Database Management Systems (3rd edition) by Ramakrishnanand and Gehrke
In addition, the following books, papers, and web sites provide supplementary material. Reading selections from these sources will be announced in class.
  • Database System Concepts (5th edition) by Silberschatz, Korth, and Sudarshan
  • First Course in Database Systems (2nd edition) by Ullman and Widom
  • An Introduction to Database Systems (6th edition) by Date
  • Fundamentals of Database Systems (3rd edition) by Elmasri and Navathe

Project and Assignments

Assignment 1:  Transactions.   Due 11 April 2010 at 11:59pm.
                       גרסא בעברית.

Assignment 2: Multiversion Concurrency Control. Designer code. Due 5 May 2010 at 11:59pm.
                      גרסא בעברית
Assignment 3: Hash Join. Designer code. Due 7 June 2010 at 11:59pm.
                      גרסא בעברית בקרוב.
                      SailorNames BoatNames Colors
                      SailorGenerator Tool.
Assignment 4: User Defined Types and OLAP. Due 27 June 2010 at 11:59pm.
                      Temperatures Creator Tool. (now contains Locations too).
                      Designer Code.

New: Submission instructions: You may submit work using Telem, in person, or by sending email to the address ise326 at gmail.  If you send email to the ise326 address, you will receive an auto-answer response acknowledging that a message has been received.

Grading Criteria

  •   4%   Quizzes
  • 16%   Programming Projects / Assignments
  • 80%   Final Exam

Lecture Slides and Notes

Schedule
Date
 Topic
 Notes
7 March Review of Transaction Management [pdf][code designer]
14 March
 View and Conflict Serializability
 [pdf][targil sailors code]
21 March
 Lock Management
 [pdf][targil]
11 April
 Specialized Locking Techniques
[pdf1][targil]
18 April
 Crash Recovery (short)
 [pdf][targil]
25 April
 Intro to Parallel DBs, Parallelization
[pdf][no targil - יום העצמאות]
2 May
 Intro to Query Evaluation
 [pdf][targil]
9 May
 Parallelizing Algorithms & Queries, Intro to Distributed DBs
 [pdf][targil]
16 May
 OODBMS, ORDBMS, Structured Data Types
 [pdf1, pdf2][targil]
23 May
 Operations on Structured Data Types, Inheritance, Object Ids
 [pdf][no targil - שבועות]
30 May
 Decision Support, OLAP
 [pdf][targil, sols]
6 June
 OLAP Queries
 [pdf][targil, sols]
13 June
 OLAP Implementation, Data Warehouses, View Materialization
 [pdf][targil, data, sols]
23 June at 10:00
 Maintaining Materialized Views
 [pdf][targil, data, sols]
22 June
 Targil: Course Review

TBA
 Final Exam Moed A
TBA
 Final Exam Moed B

Academic Integrity

Since Kinneret College does not have a unified code of academic integrity, this course will abide by the University of Pennsylvania's Code of Academic Integrity. In particular, for individual projects and group projects, the following guidelines should be followed:
  • For individual projects, you must type in and edit your own code, documentation, and any other materials submitted for grading.
    • Copying someone else's file is not allowed.
    • Allowing someone else to copy a file of yours, either explicitly or implicitly by leaving your code unprotected, is not allowed.
    • Editing each other's files is not allowed
  • Regarding the ethics of what you may or may not discuss with others:
    • "High level" discussions are fine.
      For example, discussions about the problem statement.
    • "Low level" discussions are fine.
      For example, discussions about C syntax or using gdb, understanding compiler error messages, understanding the mechanics of the tools and libraries used for the projects.
    • "Mid level" discussions require discretion. In this CIS course, discussions at this level must be limited.  Unless explicitly stated otherwise, you may not collaborate significantly with classmates (except group project members) at this level.  If you have minor discussions with others at this level or get help from outside resources (tutors, web sites, etc), you must cite at the top of the submitted projects the names of the people or websites who helped you and how they did. For example: 
            /**
             * Chris Brown
             * Project 1
             * 5/6/2008
             * I received tips from Jo Johnson on the i/o and example.com/mem.htm on memory
             */
  • If there is any doubt about the use of external sources or collabortation, please ask for clarification by the course staff.