Index

• Announcements
• Course Information
• Lecture Notes
• Projects (Related Resources)
  • Project 0. [Descriptions]. [Code]. No submission needed.
  • Project 1. [Code], [Descriptions], [Additional Commands]. Due on November 7, 2007, Wednesday, 11:45 PM. Submit it on EEE.
  • Project 2. [Code]; [Updated fs code]; [Open Test Cases]; . Due on December 7, 2007, Friday, 11:45 PM. Submit it on EEE.
• Homeworks (Gradiance GOAL):
  • Homework 1: due on October 16, Tuesday, 11:59pm. (6 questions)
  • Homework 2: due on October 22, Monday, 11:59pm. (3 questions)
  • Homework 3: due on November 2, Friday, 11:59pm. (3 questions)
  • Homework 4: due on November 11, Sunday, 11:59pm. (6 questions)
  • Homework 5: due on November 22, Thursday, 11:59pm. (5 questions)
  • Homework 6: due on December 3, Monday, 11:59pm. (5 questions)
  • Homework 7: due on December 9, Sunday, 11:59pm. (5 questions)
• Resources

Announcements

• (12/10/2007) During this final week, I will have my office hour at the regular hours (Tu/Thur, 2 - 3 pm). If you want to meet me at a different time, please email me.
• (12/4/2007) According to the university final schedule, our final will be on on December 14, Friday, from 10:30 to 12:30 pm. It will be in the class room. We use the same requirements as the midterm. We will cover all the materials of the course, with more emphasis on materials not covered by the midterm.
• (12/4/2007) Homework 7 is on Gradiance. It will be due on December 9, Sunday, 11:59pm.
• (12/4/2007) The office hour of the instructor today (Dec. 4) has been canceled. If you want to meet the instructor, please email him to make an appointment.
• (12/2/2007) In the fs/fs.h file, we have the following macro to define the limit of file-name lengths.

             #define MAX_FILENAME_LEN           ( 15 )
  

  This limit might be too short for your design. Please change it to:

             #define MAX_FILENAME_LEN           ( 100 )
  

• (11/27/2007) Project 2 requires a parameter for the block size of the file system. For this reason, you should add the following line to the file fs/fs.h:

  #define FS_DEFAULT_BLOCKSIZE ( 4096 )
  

  Then you can use this parameter to design your B+ tree. In our test cases, we can change the macro to a different value, and your IX module should still work.

  In addition, the IX module needs the RM to get the metadata of a table. For this reason, you need to add and implement the following function to the IX_Manager class in ix/ix.h:

    RC setRM(RM &rm);    // set the record manager (to get metadata of a table)
  

  Our test cases will call this function.
• (11/27/2007) Homework 6 is on Gradiance. It will be due on December 3, Monday, 11:59pm.
• Previous Announcements

Course Information

• General Information. The following are a few important entries:
  • Course Goals
    
  • Instructor and Office Hours
    
  • Working in Groups
    
  • Grading Policy
    
  • Prerequisites
    
  • Time and Place
    
  • Textbooks
    
  • Electronic Lists
    

Lecture Notes

Resources

• Click http://www.gradiance.com/pearson to log into GOAL. The class token on Gradiance for this class is: 9641C054.
• Purchase a Gradiance online access code:
  • The "Database Systems: The Complete Book" with a Gradiance access card ($133.20).
  • Gradiance access card only ($34.00)
• Major database courses at UCI: CS122A, CS122B, CS222, CS223, CS224.
• UCI Calendar (07-08)