I've looked at all the assignments for which people requested a review of auto-marking, and even some that didn't request it. The final assignment marks should be visible in the sturec page. This has meant that I could clear out all of the LEs. The marks have been entered into Astra and final results ought to be visible in your transcript early this week.
No further correspondence will be entered into.
I've marked the Supp Exams (Tue 31 May). I'll review the assignment marks on Wed 1 June and Thu 2 June. Once that's done, I'll enter them into Astra. After that, it takes a day or so before they arrive in your transcript.
The status field is now active on the sturec page.
1 = assignment 1 mark being reviewed
2 = assignment 2 mark being reviewed
S = supplementary exam
X = plagiarism investigation
Anyone with one of the above should get an LE grade when results are released.
Anyone with ok should get a final mark/grade when results are released.
Marks are released by the University later in the week.
All of the people who asked for a review of their assignment marks will receive a
WD
LE
grade while we sort them out. You should have a real mark+grade by the start of next week.
People who (apparently) plagiarised work in the exam or assignments will also receive a
WD
LE
grade.
How can you tell the difference between mark review and plagiarism? I will be adding a status field to sturec (it is not yet added ) that will contain comma-separated 1 or 2 or X (1 for Ass1 review, 2 for Ass2 review, X for suspected plagiarism.
If you asked for a mark review, but don't have a 1 or 2 in the status field, let me know.
If the status field does not (yet) appear in sturec, don't ask about it.
It seems that the Special Consideration people have been flooded with applications, and so are not reponding quickly to requests just at the moment.
If you didn't sit the exam and you put in for Special Consideration, they will eventually get around to telling you that you have a Supp.
Supp exams will be held in the week of May 23 - 27. I will contact people individually about the exact time. once it's been worked out.
Note: Supp Exams are not available to people who sat the exam on May 12, except under a couple of exceptional circumstances.
I told you what would happen if you left submissions to the last minute.
It happened.
I will be slightly lenient on submission that are late by a few minutes, but otherwise ...
It looks like some of the Data? files don't quite meet the specification of "no-frills" files. This only affects Q3.
Changing the data files now would be extremely difficult, since everyone has already downloaded them.
My suggestion: when checking whether there is room to fit a tuple at the end of the page, require one more byte than is actually necessary according to the spec. Then you should match Data? and pass all the tests.
The example command for q3 was wrong
./q3 myData < data/insert200
It should be
./q3 myData data/input200
I've fixed it in the online version. If you downloaded the paper and have it locally, just note this. All of the *.sh files in the tests directory were correct.
Some people reported that there were two Q2 submission links. Now there's only one.
Around 1pm (Sydney time), the Final Exam page will be opened under the "Exams" sidebar link. Click on the " Instructions " link, and read the instructions..
Then set up your work directory and open the exam paper (links are in "Instructions").
If you have questions, send email to j.a.shepherd@gmail.com (likely to reach me quicker than jas@cse.unsw.edu.au, but you can use the CSE address if you want).
I will either reply directly to you via email if the query is specific to you. If it's an issue that I think everyone needs to know about, I'll post a notice on Webcms3 and email it to the class. To avoid too many questions that ask "Does X mean X?", don't email me, but rather write down any reasonable assumptions you're making and answer the question based on those assumptions.
Submit your answers as you complete the questions . DO NOT leave submission until the last minute. If everyone does that, Give will start to run extremely slowly and your submission may not reach us until after the deadline (which is 5pm Sydney time).
Good luck.
P.S. Please fill out the "exit poll" about how long it took you to complete the exam.
I won't have time until next week to go through all of the requests to have assignment marks reviewed. This means your final mark won't be ready before the submission date for marks. Anyone whose assignment is being reviewed will initially receive a WD or LE grade. This will eventually turn into a final mark and grade once the review is complete. I will also email everyone with reasons why their mark did or didn't change.
Hopefully, I can get the 350 exams marked in three days to get all of the non-reviewed results finalised.
For the exam tomorrow, you start by going to the Exams link in the sidebar. By 1pm tomorrow, there will be a Final Exam heading with a link to Instructions and 8 submission links. Go to the Instructions page and *read* the instructions This page contains links to the exam paper and the work files.
Good Luck.
My inbox is now flooded with queries about Ass2. It will take time to work my way through them, and it won't happen before the exam.
There seems to be some confusion in the wording on the auto-marking output, in particular
It seems that you did not implementing search via hashing.
When you answer queries, if you are doing it properly, you would only examine 2^u pages, where "u" is the number of unknown bits.
To check this, we added a couple of lines of code into page.c and select.c to count the number of times that you called getPage(). The least number of pages would be 2^u, but since you also have to examine overflow pages associated with these pages, we made an allowance for 2 overflow pages for each data page. If you read more pages than this, then we assumed that you were not limiting yourself to just the pages specified by the unknown bits.
Please look at the testing output, not just the summary at the bottom to check how many pages we think you read in answering the last four queries.
We've run the auto-marking on Assignment 2 and you should be able to look at your results via the "Collect Submission" tab on the "Assignment 2 - Submission" page.
Since nearly 100 people got full marks or near full marks, I'm moderately happy with the testing.
Treat the current mark as a lower bound on the mark you're likely to get for the assignment, once we've waded through the inevitable complaints about how unjustly you've been treated in the auto-marking.
If you want to check some of the query tests yourself, the data files and expected query outputs are in the directory
~ cs9315/web/22T1/assignments/ass2/test-files/
Hopefully, this gives you enough information to target your study for the exam, not that I ever thought you should go into an exam thinking "I only need to meet the hurdle to pass the course". You should always be aiming for 100%, regardless of your assignment and quiz marks.
There were about 25 people who did not submit their Assignment 2 work as described in the spec.
I have just
wasted
spent several hours fixing their submissions. I should penalise them, but won't.
Warning: In the exam, if you don't submit each question precisely according to the instructions, then your work for that question will not be marked. We have a very tight timeframe for marking and there is no time to go fixing bad submissions.
The solutions for the 20T1 and 21T1 final exams are now available.
Next task: finish Assignment 2 marking.
In case you hadn't noticed, I've been missing on the forum for a few days. I'm working on a major project for the Faculty (so that your degrees can be accredited), have been flat out on this since last week, and will be working on it for the next few days.
So, I haven't had a chance to follow up on the remaining few assignment 1 marking queries, or help Minyi get started on Assignment 2 marking. The Faculty project should be finished by Sunday, so then I can get back onto COMP9315 stuff again. I want to have all marking sorted by May
5
9 so that you know where you stand going into the exam.
I've put up some past exam papers.
Note that you can't
submit
answers for any of these exams,
even if the instructions make it look like you can.
The sample solutions will be available in Week
11
. 12.
In case you missed the point in the previous notice *and* missed the Online Session on Thursday, I'm unavailable for the whole of the Easter weekend. You'll need to help each other on the Forum.
Before I vanish for easter, a couple of things which I'm sure were answered on the forum, but keep coming up ...
if (r->depth == 0) p = 1;should be
if (r->depth == 0) p = 0;Since we won't be auto-testing starting from depth=0, this won't matter. But you might bump into it doing your own testing.
I guess it was inevitable, but 97% of respondents said that they would like an extension to the Assignment 2 deadline.
Assignment 2 is now due by Tuesday 19 April at 9pm .
There have been 57 submissions so far (from 364 possible).
The weekly preview video is now up. Might be especially useful this week because it has a quick demo of the Assignment 2 testing script.
I've put a simple testing script in the assignment directory. You can run it as
sh /web/cs9315/22T1/assignments/ass2/tests.sh
but you will need to do some setting up first.
You can run tests.sh in any directory but ...
Hopefully it will run on any CSE machine (vxdb, vlab, williams, etc.).
Note that because of the variations in how people implement splitting, etc. It does not give precise expected outputs for the stats executable. The queries, however, should match their expected outputs exactly.
The script produces a lot of output. I would suggest redirecting the script's output to a file and then perusing the file in a text editor.
If you want to see what the data files look like, they live in the directory
/web/cs9315/22T1/assignments/ass2/test-files
I'd suggest creating a new directory, separate from the directory where you're working on the assignment, put the ass2.zip file in that directory and runs tests.sh in that directory.
Ooops ... I messed up the Online Sessions page for Week 08 ... all it's currently got is a link to Thursday's session ... I'll fix it tonight
Last change ... apparently, I am not allowed to run an exam up to 6pm ... the "official" time period is 1pm-5pm ... so the Final Exam will be on Thursday 12 May from 1pm to 5pm
The marks for Assignment 1 have now been copied into SMS/sturec. This includes the application of late penalties, but not yet plagiarism penalties.
Students who scored 0 are being checked, so that mark is not necessarily final. Students who sent email asking for us to check the auto-marking are also being checked; their marks may change.
Regardless of what the recently posted exam timetable might say, the COMP9315 Final Exam will be held on the afternoon of Thursday 12 May (2pm-6pm). Hopefully this will better suit people in different time zones. The exams people told me that there were no clashes at this timeslot, but at least one person has a clash. Let me know if you have one.
We are aware of some issues with assignment 1 marking where some tests are not being run after the server unexpectedly quits.
This is currently being fixed.
This has been fixed.
Also if you have gotten 0 or a very low mark, we will look at your code to see if the mark can be amended. We understand that assignment marks are very important to everyone and we are trying our best to give you all a fair mark. Please be patient. :D
OK ... so I forgot to copy across the additional auto-testing that Minyi ran over the weekend to fix some of the auto-marking issues. Now the (hopefully) final auto-testing results are available via the Assignment 1 Submission page ... click on the Collect Submission tab. Hopefully some of your concerns have gone away with the new round of auto-testing. If they have, please send cs9315@cse email saying "I have no problem with my Assignment 1 marking any more".
The current marking output does not include late penalties. They will be added tonight, and then the marks will be accessible via your sturec page.
If you still want to query Assignment 1 marking, send an email that gives details of why you think you deserve more marks to cs9315@cse.unsw.edu.au. Don't send it directly to me (jas@cse) or Minyi.
The weekly preview is available, Quiz 4 opens at 9am Monday (due 9pm Friday), "final" Assignment 1 marks will be released later today. I say "final" because it's still remotely possible that auto-marking messed up in some cases; let us know if you think this is the case. Auto-marking "messed up" does not include you failing the unseen tests.
Some suggestions for how you might check the validity of your code for Assignment 2 are now available.
This time we don't plan to make an auto-marking-like script (e.g. run_test.py ) available right away. We want you to think about how you can test your code. We may make a run_test -like script available later.
Well ... I'm glad that someone finally pointed out that Quiz 3 still wasn't available.
Someone told me on Monday and I thought I'd fixed it.
Given how late it now is in Week 6, we may as well run it next week (Week 7).
The Assignment 2 spec and setup material is now available.
I'll add Testing Resources for the assignment in the next day or two.
Reminder: there are no Online Sessions this week. But there is a new Quiz and Assignment 2 willl be released later today. Note that Assignment 2 does not require you to have a PostgreSQL server, nor does it require you to use vxdb. Any machine with a C compiler and make (and gdb) will be fine.
Damn! It looks like I have COVID. Not too bad (like a bad cold), but might slow down responses to questions.
If you insist on using VScode, the message entitled " VScode Follow-up " on the COMP3311 website might be useful.
Looks like you've smashed vxdb again.
Some suggestions:
Given this situation, I'll have to move the deadline to 9pm on Monday 21 March.
Hopefully this will lighten the load in the next few days.
I have also asked Systems Support if we can add more resources to vxdb.
Congratulations! You have managed to drive vxdb into the ground by overloading it. At one stage, it had a load average of 900!! (which is outrageously large). I notice that some people are running multiple PostgreSQL servers. There are also a very large number of processes associated with vscode. I told you that vscode was a resource hog. Please try to avoid using it as much as possible.
If you're not sure whether you're running multiple PostgreSQL servers, try the following command on vxdb:
ps uwx | grep pgsql/bin/postgres | grep -v grep
If more than one line appears, then you have multiple servers running. The p0 command won't kill them all, so you'll need to kill them manually using the kill command and the second number on each line of the ps command output.
Even if you can now access the testing stuff, you ought to check your testing directory.
If any of the symbolic links look like this
lrwxrwxrwx 1 jas jas 54 Feb 13 11:23 run_test.py -> /web/cs9315/20T1/assignments/ass1/testing/.run_test.py
Note the 20T1 .
Then you've got an old testing script. It will work (more or less), but you should be using the scripts for 22T1.
How to fix?
This should be resolved now. Apologies for the inconveniences caused. Please let us know in the forums if you're still experiencing issues.
Here's what I see when I log in to vxdb
:jas@nw-syd-vxdb: cd /localstorage/jas/testing :jas@nw-syd-vxdb: ls -l total 76 -rw-r--r-- 1 jas jas 360 Mar 5 15:26 Makefile -rw------- 1 jas jas 3230 Mar 10 18:40 pg.log -rw-r--r-- 1 jas jas 9000 Mar 10 11:28 pname.c -rw-r--r-- 1 jas jas 5000 Mar 10 11:25 pname.source drwxr-xr-x 5 jas jas 72 Mar 10 08:32 results -rwxr-xr-x 1 jas jas 16421 Mar 10 09:58 run.py lrwxrwxrwx 1 jas jas 54 Feb 13 11:23 run_test.py -> /web/cs9315/20T1/assignments/ass1/testing/.run_test.py -rw-r--r-- 1 jas jas 23050 Mar 10 18:40 test.log lrwxrwxrwx 1 jas jas 49 Feb 13 11:23 tests -> /web/cs9315/20T1/assignments/ass1/testing/.tests/ :jas@nw-syd-vxdb: ls tests 0_sanity-checks 1_users 2_students
According to the file/directory modes, you should also all be able to see this.
I can't work out why you can't access the tests. The file permissions all look OK.
Could somebody run the following commands and send me the results:
ls -l /web/cs9315/20T1/assignments/ass1/
ls -l /web/cs9315/20T1/assignments/ass1/testing/
ls -l /web/cs9315/20T1/assignments/ass1/testing/.run_test.py
ls -l /web/cs9315/20T1/assignments/ass1/testing/.tests
The Preview video for week 4 is now available. Quiz 2 is up-and-running (due Friday 9pm). You should all have a working PostgreSQL server by now and be looking at how you might implement the PersonName type for Assignment 1 .
The preview video and content video for Week 3 are now available under Videos and Slides.
I think people misunderstood the meaning of the du -sh command. It does not give you your disk quota. It tells you your current disk usage, which might be way less than your quota.
I have successfully used over 500MB of space on my /localstorage, and I think you can too.
I've put a few moderate sized databases in a directory under the class account. If you can create all three of the databases, you'll be fine. Even if you can create two of them, that's also fine.
Try the following commands on vxdb with your PG server running:
createdb music; psql music -f /web/cs9315/22T1/databases/music.dump createdb pizza; psql pizza -f /web/cs9315/22T1/databases/pizza.dump createdb weblog; psql weblog -f /web/cs9315/22T1/databases/weblog.dump createdb cfps; psql cfps -f /web/cs9315/22T1/databases/cfps.dump<span class="redactor-invisible-space"></span>
You will most likely be able to create the first two databases without difficulty. You may be able to create the weblog database. Trying to create the cfps database will fail, with a "Disk quota exceeded" error.
The above depends on how much other stuff your have in your /localstorage directory. If you have other large files there, you may not even be able to make the music database.
After trying to create cfps , check your disk usage ( du -sh /localstorage/$USER ). You should find that it's over 500MB.
After doing the above, you may as well drop the databases. Certainly drop the cfps database. It is incomplete.
There's no point any more sending me output from du -sh /localstorage/$USER. If you want to send anything, send the output from du -sh /localstorage/$USER/*
Apparently the disk quota is fixed BUT it will only be apparent if you log out of vxdb and then log back in.
If you try that and you still think it's not working, let me know.
System Support say they have fixed this. A new larger quota will be applied next time you login to vxdb.
It is still not fixed. I have asked
again
for it be fixed. If I had the privilege to do this myself, I would have done it last week.
Let me know if this is not the case, and accompany your email with the output of
du -sh /localstorage/$USER
The spec for Assignment 1 is now available. If you read it yesterday, read it again because some things have changed:
I'll talk about the assignment in the Thursday Online Session after you've had a chance to read it.
We'll release a testing harness later in the week.
It looks like the disk quotas on vxdb have slipped back from 600MB to 300MB.
I have no idea how this happened and I have not control ovre disk quotas.
I've asked system support to investigate. May not be resolved tonight. Annoying.
I've posted the Week 2 Preview.
Please get your PostgreSQL servers installed asap. You won't be able to do Assignment 1 without a working PostgreSQL server.
To help people who are having problems and which can't be debugged via email/forum, I'll run a special help session on Monday21 Feb from 1-3pm on Zoom ... if you are having installation problems come to this session and be prepared to share your screen.
I will not be answering any more queries from students claiming that they have errors because they didn't get the "Ready to install" message. Read this Notice again if you think you have a problem. If you don't get any error messages, you do not have a problem. "Leaving directory" is NOT an error message.
It seems that the postgresql-14.1 Makefile does not contain the message
All of PostgreSQL successfully made. Ready to install.
If your compilation ends with something like
make[1]: Leaving directory '/localstorage/YOU/postgresql-14.1/config'
or, at least, produces no ERROR messages, then you should be ok to proceed to
make install
I'll fix the P01 prac description to reflect this.
It looks like the systems support people have fixed the script that creates /localstorage directories.
Next time you login to nw-syd-vxdb, you should end up with a personal /localstorage/$USER directory and you can then do lab P01 as specified.
A couple of issues have arisen as people have tried to do Prac P01
We have informed the systems support people about both issues.
I believe they have fixed increased the disk quotas for COMP9315 students, but you still won't have enough quota to leave all of your COMP3311 21T3 data lying around in /localstorage/$USER.
They haven't given me an ETA for fixing the /localstorage creation issue. I'll let you know as soon as they do.
If you can't wait for /localstorage on vxdb, you can always install a PostgreSQL server on your local machine and start work on the later Pracs there.
Online problem-solving sessions are on Tuesday 12-2 and Thursday 2-4 on Zoom .
All sessions will be recorded.
In the first session (Tue 15 Feb), I'll be playing around with the PostgreSQL server.
Have you dropped COMP9315 but are still receiving this email?
Send me (jas@cse.unsw.edu.au) email to let me know that you have actually dropped and I'll fix your Webcms3 entry to reflect this.
I've put up a couple of polls to find out what you know ...
If you can spare a few minutes to fill them this week, that'd be great
The polls close on Friday.
The oh-so-dramatic Welcome video is now available, along with the Course Introduction .
All of the content videos for the whole term are available via the Videos and Slides link in the sidebar menu.
I'll soon be posting a Week 1 Preview video, with discussion of what you should be doing this week.
The online sessions will be Tuesday 12-2 and Thursday 3-5 on Zoom . If it asks for a passcode: 437321
I've finished writing the Course Outline and made it public.
Welcome to COMP9315! An exploration of the internals of database management systems.
Warning : if you're not a solid C programmer, don't take this course. All of the assignment work and the exam requires you to write complex C programs.