Hi, I posted the grading of P2.2. Some people get 0 because of opening or other staff. Please make an appointment with me among 1:00 -1:15, 1:15-1:30, ....,...
Hi, My group(Linda and Chiquita) would like to meet you at 1.00 on Monday. Please schedule us at that time if you have that slot vacant. Thanking you, Chiquita...
For those who need regrade, please check the Calendar of our group on next Monday to select a time slot. Some time slots are occupied. You can modify the...
Hi Lixia, I have a doubt regarding the A4.1 test cases. In class we understood that Estimate is called before the call to Apply, where as in our test cases...
Hi Lixia, Chris In all test cases, you incrementally apply the CNF. I had a small doubt regarding this. For ex. in q2, you first use the CNF "(c_custkey = ...
Joyesh Mishra
jmishra@...
Apr 5, 2008 11:33 pm
136
Please test your project using the test cases. I will post a new test driver later....
Hi, There is an overflow condition when we try to join two large tables. Consider second query: Relation: supplier, partsupp T(supplier) = 10000, (partsupp) =...
Hi all-- I wanted to send out a quick note regarding the test cases. The "correct" answers suplied by Lixia are the results that she got *actually running* the...
Hi Lixia, I had a doubt about the provided test cases code. In query 1, (l_returnflag = 'R') AND (l_discount < 0.04 OR l_shipmode = 'MAIL') I believe the...
Hi Chris/Lixia, I have a doubt regarding the queries having aliases like Q4,5,6. I think for alias queries, we should be passing alias names in relnames array,...
Hi, You can get the correct answer if you process the second OR list with a different formula which takes into account the fact that the two comparisons in the...
Again, keep in mind my last email: Lixia did not calculate these values, she actually ran the queries to get the values. So there might be no way for you to...
Hi All, Regarding this case, please create a new relation array of all the aliases and pass it instead of passing rel. Passing the old rel array won't be ...
Joyesh Mishra
jmishra@...
Apr 8, 2008 11:11 pm
146
Hi All, I forget to tell Chris that all the results are my estimations. If you use the methods taught in class and you should get all the results almost same...
Hi For q5 and q7, you don't need to addArr for "o_orderdate", "l_receiptdate", since it is "> " estimation. The number of tuple is 1/3 of the original one. ...
Hi Lixia, As per the spec, in case a attribute in the parseTree does not belong to the relations passed to estimate/apply, an error should be flagged. Hence, ...
Joyesh Mishra
jmishra@...
Apr 9, 2008 4:06 pm
150
Both way are okay. ... Hence, ... to get ... initialization ... s.AddAtt(relName[1], ... but the ... is not ... test ... executed ... the test...
After submitting the assignment to CourseTools, I attempted to download it to test it out. But it downloads an empty file named query. Has anyone else...
Jose Boada
jboada@...
Apr 10, 2008 1:10 am
152
Yes, I faced the same problem yesterday. Today, I tried uploading assignment again, but same result :( .... When I try to download submitted assignment I get...
Chris/Lixia, Does this represent a problem with the submission? We noticed on the download page that the File Name and Assignment name seem to be switched. ...
Jose Boada
jboada@...
Apr 10, 2008 7:46 pm
154
Hi Subi and Lixia-- Can you take a look at everyone's concerns ragarding the submission tool? --Chris -- ...
Since different teams have different input dbfile names and formats, it is hard for me to grade your A3. Every group has 10 minutes to demo. Please select a...