CS-E4610 - Modern Database Systems, 13.01.2017-31.03.2017

Materials

• Materials
  

  Materials

  • Quiz 0 File PDF document

    The quiz that was handed out in class today.
    it's meant only for self evaluation, no need to return.
    

    
    

  • Lecture 00 File PDF document

    Introduction to the course, logistics, brief review of SQL.
    

    
    

  • Lecture 01 File PDF document

    File organizations and access cost analysis.
    

  • Lecture 02 File PDF document

    B+ Trees, Hash Based Indexing, External Sorting
    

    
    

  • Tutorial 1 File Text file

    The tutorial had two parts:
    - Pen-and-paper questions on b+ tree index, extendible hashing, external sorting, access cost analysis.
    - A postgres session with pgAdmin 4.
    
    Attached files:
    

    • Tutorial 01 - E4610.pdf : main file, notes from the tutorial
    • session.sql : the sql statements we executed using pgAdmin's query tool (available from menu Tools > Query Tool)
      

    
    

    
    

  • Tutorial 1 File PDF document

    Notes for tutorial 1.
    

  • Lecture 03 File PDF document

    Join algorithms, query optimization.
    

    
    

  • Programming environment for assignments (Updated 23-02 and 03-03) File Text file

    The programming environment for the course has been set up so that each student connects to their own Virtual Machine (VM), hosted on CS computers.

    Consult the attached file to find the address of your VM.
    Each line has the following form.
    [student-vm-address]:[student-email]:[student-aalto-id]
    You can find your VM address by searching the file for your Aalto email or id.

    To connect to your VM follow these steps:

    Step 1: Visit version.aalto.fi to upload your public SSH key.
    Once you log in to version.aalto.fi, head to 'Settings' under your profile icon (top right corner) and select the 'SSH Keys' tab. Follow the instructions there to generate (if you haven't already) and upload your SSH keys.
    UPDATE 03-03: 'Your public SSH key' is the key of the machine you use to connect to your VM. For example, if you connect to your VM from kosh.aalto.fi or other aalto machines, you should upload the public SSH key to version.aalto.fi.
    

    Step 2: Open a terminal and connect to your VM via SSH.
    > ssh -X [your-student-aalto-id]@[your-vm-address]

    The '-X' flag is necessary if you wish to use a graphical application, like pgadmin3. Mac users: you will need to install XQuartz to do that.
    UPDATE 27-02: Do this while connected to Aalto network (e.g., through vpn, if you are away).
    

    Step 3 (Optional) : Once you have logged in to your VM, add you public SSH key to ~/.ssh/authorized_keys file. Doing this is not mandatory, but if version.aalto.fi is down, you won't be able to access your VM.
    

  • Lecture 04 File PDF document

    Semistructured data: motivation, examples, query processing, indexing
    

  • Lecture 05 File PDF document

    Lecture 05: information retrieval.
    

    modeling, evaluation, indexing and searching, parallel and distributed IR
    

  • Tutorial 2 URL

    The notebook used for the tutorial is under folder 2017/, file 'mongodb.tutorial.ipynb'.
    

  • Lecture 06 -- top-k retrieval File PDF document
  • Lecture 07 - MapReduce & Spark File PDF document
  • Tutorial 3: Spark URL

    Thy Jupyter notebook and other files for Frederick's tutorial on Spark is on https://github.com/mmathioudakis/moderndb/ under folder 2017.
    

    
    

  • lecture 08 -- map-reduce algorithms File PDF document
  • Lecture 09 -- graph processing File PDF document
  • Grades for Exam of April 2017 Page
  • Grades based on First Exam Page

    These are the grades for all the students who submitted at least one assignment, whether they sat the April exam or not.

    (Obviously, for students who will (re-)take the exam later, the final grade will be recalculated once we have the new exam grade.)
    

  • Grades based on May Exam Page

    Grades (only) for students who sat the May 2017 exam.