Welcome to Data microBases, Step by Step.

Over the course of this project, you will build a query processing engine that lets you run SQL queries over CSV files. As in the real world, you will get design specs that dictate what you need to accomplish and what resources (time, memory) you have to accomplish them with. There are multiple ways to accomplish these goals. Although some ways are better than others, you will be penalized for following poor design practices: The project is cumulative, so poor design early on will make your life much more difficult on the later projects. Fear not, however, for between the lectures, project specs, office hours, course forums, and other resources for communicating with your group, instructors, and classmates, you will receive tons of guidance on what has and and hasn't worked for students in the past (and your professor).

In this preliminary (good programmers count from 0) step, you will create a DµBStep account, prepare your build environment, and verify that everything works by submitting a simple Hello World program.

The Submission System

Let's first get familiar with the submission system.  It's located at

http://dubstep.odin.cse.buffalo.edu

Or you can click on the "DµBStep" link from the course syllabus.  

odin_submissions

After loading up the website, you will need to create an account.

login

When creating an account, be sure to use your UB email address.  If you don't have a UB email address, contact the teacher or a TA as soon as possible.

create

After you create an account, you'll receive an email with an activation token.  Click on the link in the email, or copy it into your browser's location bar.

Forming Groups

Find up to three other students in the class, and elect one member of your group to be the leader.  You'll also need a group name.  Be creative.  This is how you'll show up on the leaderboards.  The group leader should go to the Manage Group tab and click "Or Start a Group..."

invitations
groupcreated
After creating and naming your group, your leader should click "Invite more..." on the Manage Group tab and add all remaining group members by their email addresses.

invite

All team members should now be able to accept their invitation by logging in and going to their Manage Group tab.

accept

GIT and Source Code Management

For submissions, and for your group's convenience, DµBStep provides your group with a GIT repository.  If you don't know how to use GIT, it's an important skill to have.  Numerous tutorials and reference materials are available, including

If you don't want to dive headfirst into GIT, a nice user-friendly front-end is SourceTree http://www.sourcetreeapp.com. Alternatively, read on below for a quick and dirty intro to the three GIT commands you can't live without.

The upstream URL of your team's GIT repository is available from the Manage Group tab.

gitrepo

To access the repository, you'll first need to register your GIT public key.  An overview of public key management can be found here.  A public key should look something like this (with no line breaks):

ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDgX8jMmapRQ7pIJ0JV9zfvkqef/OBV//y3t0ceV5KaZ4DMlcn+xzonR/OR4cTuAyQRyQK3TlamleUATQe9JAieaI3dodnCfrN7C16RiqkB6iQorpCC+LdkdM7n3rVtleIAY93Imoq6tJEf+boeLz7EtB6I7OJSZ+NgRv5Z4vvF2hlgJrXaCr+ofURm/lLOHB1AdcZiXVL8tPOVl/FG170/i1fI+Y1eyQtko10XlHTHx4bGavYMsOKWoVjTBCruH8/VmiaUY7RBTn8Qg+yOQZPIOTrtWxRm0/Q373hKn8Xt+Dh38tHL3Z8X2C4jup/JFRmoT+nH6m9pB79IcnBNYa7V okennedy@sif

Uploading Your Public Key

From the Manage Account tab, click on "Upload public key..."

pubkey

Copy the entire public key into the field provided and add a short description (useful if you work on multiple computers).

pubkey2

You should now be able to clone your team's GIT repository:

gitclone

A Quick and Dirty Intro to GIT

Once you have cloned a copy your repository (a directory called teamX, where X is your group ID), you'll need some organization.  The grading script will attempt to compile all of the java files in your repository, but for your own sanity and ease of compilation it can be helpful to keep your repository organized. It's common to create a directory named src at the root of your git repository.  Create that now. ```

cd teamX mkdir src mkdir src/dubstep touch src/dubstep/Main.java ```

Now you need to make git aware of the file you just added

> git add src/dubstep/Main.java

Next, you need to create a commit checkpoint -- a marker indicating that your local copy of the repository is in a stable state.

> git commit -a

The -a flag commits all files that have changed (you still need to manually add files that are new).  You will be asked to provide a message that describes the changes that you've just made to the code.  Finally, you need to send the changes to the central repository.

> git push

The files are now in your global repository.  Your teammates can now receive your changes by pulling them from the central repository.

> git pull

If this works, you should be all set.

Submitting Code

To have your project graded, go to the Home Page tab, click "Show" for the project you want to submit, and click "Create new submission".

project

A snapshot of your repository will be taken, and your entire group will receive an email notification once your project has been graded. You may only have one submission pending at any given time, but you may resubmit as many times as you like.

The grading script operates as follows:

  1. Recursively scan through your GIT repository for all files ending in .java
  2. Compile all of these files (with all course-provided classes in the classpath). Compilation is performed using the Java 1.8 SDK. Do not use features from later versions of java or your submission will not compile!
  3. Attempt to run your project as
    java -cp your_code.jar:{classes} dubstep.Main {arguments}
  4. Validate the output.

If these steps fail for any reason, your submission will receive a 0 and you will need to resubmit. A log of the compilation and testing process will be made available on the submission page so that you may correct any errors that occur.

Project 0: Hello World!

Create a class dubstep.Main with a main function that that prints out the following (with no newlines or extraneous whitespace) and exits.

We, the members of our team, agree that we will not submit any code that we have not written ourselves, share our code with anyone outside of our group, or use code that we have not written ourselves as a reference.

Make sure your class compiles, push your (committed) repository, and hit Submit.


This page last updated 2024-03-26 10:38:50 -0400