CS 525: Advanced Database Organization – Spring 2019 – Yousef

 
. Home
Course Info
Schedule and Slides
Programming Assignments
Quizzes
Exams
Resources
Organization
There will be several programming assignments during the course. Starting from a storage manager you will be implementing your own tiny database-like system from scratch. You will explore how to implement the concepts and data structures discussed in the lectures and readings. The assignments will require the use of skills learned in this course as well as other skills you have developed throughout your program. Each assignment will build upon the code developed during the previous assignment. In the end there will be an optional assignment for extra credit. Each of the regular assignments will have optional parts that give extra credit. All assignments have to be implemented using C. We will specify test cases for the assignments, but you are encouraged to add additional test cases. Detailed descriptions will be linked on this page once an assignment is handed out.
• Assignment 1 – Storage Manager: Implement a storage manager that allows read/writing of blocks to/from a file on disk
• Assignment 2 – Buffer Manager: Implement a buffer manager that manages a buffer of blocks in memory including reading/flushing to disk and block replacement (flushing blocks to disk to make space for reading new blocks from disk)
• Assignment 3 – Record Manager: Implement a simple record manager that allows navigation through records, and inserting and deleting records
• Assignment 4 – B+-Tree Index: Implement a disk-based B+-tree index structure
• Optional Assignment – You can implement an optional assignment to get extra credits
Source Code Management and Handing in Assignments
The assignments will be completed in groups of at most three students. Groups will be determined in the first week of class.
All assignments helper files are avilable on Blackboard
Each student will get her/his own git repository on BitBucket. You do not need to create a repository yourself – we will create a repository for everyone in the course. Git is a distributed version control system. Good introductions to git are gitmagic and the official git documentation.
At the beginning of the semester you should receive an invitation to collaborate on a shared BitBucket repository named cs525ye-f18-username. All your work in this class will be submitted via your shared private repository on BitBucket. We will consider code submitted until midnight of the assignment deadline. Each group has to assign a group leader, this person´s repository will store the submitted version of the source code. If the TA does not retrieve a notification he will choose a random group member’s repository. You can use git to exchange source code from your individual repositories.
Grading of Assignments
The following criteria will be considered in the grading:
• Functionality: Does the code do what it is supposed to do? All all tests completing successfully?
• Documentation: How well documented is the code?
• Code Organization: Is the structure of the code clear and suits the goal?
• Inovation: Does the solution use new and innovative ideas?
We will check for plagiarism. Plagiarism will result in zero points for the assignment, potentially academic sanctions, and may result in an E grade.
Late policies:
• -20% points per day
Optional Assignment Ideas
This is not a comprehensive list. Suggest your own topic or contact the instructor for additional topics in a specific area.
• Implement a standard operator algorithm on top of your record manager
◦ nested loop join
◦ merge join
◦ sorting aggregate
◦ hash aggregate
◦ union
◦ …
Stuff to get familiar with
• See resources page for links to documentation and tutorials
• *nix operating systems
• OS C-library: system calls for accessing and creating files
• GDB – gnu debugger and its GUIs like DDD
• valgrind – debug memory errors
yelmehdwi#@iit.edu.