Moed C
|
Time change due to "Atzeret Zikaron". Moed C will take place on Thur. Apr. 22nd at 14:00. |
| פורסם ב-14/4/2004, 14:03:03 Created on 14/4/2004, 14:03:03 Создано14/4/2004, 14:03:03 تم النشر ب-14/4/2004, 14:03:03 |
Moed C
|
For all those on reserve duty during moed B, Moed C will be on Thur. Apr. 22nd at 12 noon. Whoever wants to attend should notice on advance. Regards, Course Staff |
| פורסם ב-29/3/2004, 10:08:14 Created on 29/3/2004, 10:08:14 Создано29/3/2004, 10:08:14 تم النشر ب-29/3/2004, 10:08:14 |
Exam grades - Moed B
|
The Moed B exam grades are now available online. Appeals on the exam grades should be submitted in writing no later than 13.4 at 12:00 (noon) to Guy's mailbox at the 5th floor. Do NOT submit appeals to the course's box. The final grades will be published in a later time. Moed B Solution can be found on the course website: http://webcourse.cs.technion.ac.il/236363/Winter2003-2004/ho/WCFiles/Winter04B.zip Regards, Course staff |
| פורסם ב-27/3/2004, 00:59:42 Created on 27/3/2004, 00:59:42 Создано27/3/2004, 00:59:42 تم النشر ب-27/3/2004, 00:59:42 |
Moed A Solution
|
Moed A solution was published. http://webcourse.cs.technion.ac.il/236363/Winter2003-2004/ho/WCFiles/Winter04A.zip Regards, Course staff |
| פורסם ב-19/2/2004, 01:38:14 Created on 19/2/2004, 01:38:14 Создано19/2/2004, 01:38:14 تم النشر ب-19/2/2004, 01:38:14 |
Exam grades - Moed A
|
The exam grades are now available online. Appeals on the exam grades should be submitted in writing no later than 29.2 at 12:00 (noon) to Guy's mailbox at the 5th floor. Do NOT submit appeals to the course's box. The final grades will be published in a later time. |
| פורסם ב-15/2/2004, 19:34:57 Created on 15/2/2004, 19:34:57 Создано15/2/2004, 19:34:57 تم النشر ب-15/2/2004, 19:34:57 |
Normal Forms - FAQ
|
Check the Normal Forms section. http://webcourse.cs.technion.ac.il/236363/Winter2003-2004/ho/WCFiles/FAQ-Normal.zip Regards, Course staff |
| פורסם ב-31/1/2004, 10:22:49 Created on 31/1/2004, 10:22:49 Создано31/1/2004, 10:22:49 تم النشر ب-31/1/2004, 10:22:49 |
Dry4 postponed
|
Dry4 assignment submission is postponed until Tuesday noon (12:00) 3/2/04. Be aware that it is the final deadline and no postponements will be granted anymore! Regards, Course staff |
| עדכון אחרון ב-27/1/2004, 09:03:08 Last updated on 27/1/2004, 09:03:08 Последняя модификация27/1/2004, 09:03:08 تمت الحتلنة الأخيرة ب-27/1/2004, 09:03:08 |
Xpath intersection
|
Xpath intersection example was published in the course material section under XML. URL: http://webcourse.cs.technion.ac.il/236363/Winter2003-2004/ho/WCFiles/intersection.zip Regards, Course staff |
| פורסם ב-26/1/2004, 15:14:18 Created on 26/1/2004, 15:14:18 Создано26/1/2004, 15:14:18 تم النشر ب-26/1/2004, 15:14:18 |
Wet Graded
|
Final data set is located in test_* tables. URL: http://www.cs.technion.ac.il/~ronbeg/236363_wet_logs/ contains compilation log + status logs + final tests. |
| פורסם ב-20/1/2004, 12:31:13 Created on 20/1/2004, 12:31:13 Создано20/1/2004, 12:31:13 تم النشر ب-20/1/2004, 12:31:13 |
Dry 4 assignment is published
|
Dry4 home assignment published at the "assignments" section of the course homepage. The submission is in pairs until 1/2/04, to the course cell. Any questions concerning the exercise should be sent by e-mail to uevelineatcs.technion.ac.il. Pay attention that no extensions will be granted, since the solution will be published the day after submission. Regards, Course staff |
| פורסם ב-15/1/2004, 12:41:09 Created on 15/1/2004, 12:41:09 Создано15/1/2004, 12:41:09 تم النشر ب-15/1/2004, 12:41:09 |
XML tutorial
| An updated version of the XML tutorial was published. |
| פורסם ב-12/1/2004, 10:26:30 Created on 12/1/2004, 10:26:30 Создано12/1/2004, 10:26:30 تم النشر ب-12/1/2004, 10:26:30 |
Dry2 was checked
|
Dry2 was graded and returned to the cells at the secretariat. The solution can be found at the assignment's page. Appeals can be submitted to Lina's mailbox (on 5th floor). Please understand the solution before you submit your appeal. Regards, Course staff. |
| פורסם ב-7/1/2004, 14:54:55 Created on 7/1/2004, 14:54:55 Создано7/1/2004, 14:54:55 تم النشر ب-7/1/2004, 14:54:55 |
Wet Assignment
| We provide another set of test cases @ the home assignment url. |
| פורסם ב-1/1/2004, 18:25:52 Created on 1/1/2004, 18:25:52 Создано1/1/2004, 18:25:52 تم النشر ب-1/1/2004, 18:25:52 |
Wet Assignment
|
Wet assignment due date is postponed to the 6/1/04 12:00 noon. We will accept late submissions, from 6/1/04 12:01 noon to 9/1/04 12:00 noon, at the cost of subtracting 5 points per half day. This does not apply for late submissions due to MILUIM, which should be submitted via email. |
| פורסם ב-29/12/2003, 22:45:04 Created on 29/12/2003, 22:45:04 Создано29/12/2003, 22:45:04 تم النشر ب-29/12/2003, 22:45:04 |
Wet's FAQ
|
Wet's FAQ is on site. It contains Q-and-A regarding: SQL and dates, Recommend, EReport and CoAuthorsRel commands. |
| פורסם ב-25/12/2003, 11:40:50 Created on 25/12/2003, 11:40:50 Создано25/12/2003, 11:40:50 تم النشر ب-25/12/2003, 11:40:50 |
Dry1 checked
|
Dry1 graded and returned to the cells at the secretariate. Moreover, solution published at the assignments page (with some notes). If you have any questions send an e-mail to Guy ukorlandatcs.technion.ac.il. Regards, Course staff |
| עדכון אחרון ב-25/12/2003, 10:03:55 Last updated on 25/12/2003, 10:03:55 Последняя модификация25/12/2003, 10:03:55 تمت الحتلنة الأخيرة ب-25/12/2003, 10:03:55 |
HW2, question 3 clarification
|
Please refer to the "Question 3 clarification" document, which can be found in home assignments -> Dry 2. Regards, Course staff. |
| עדכון אחרון ב-15/12/2003, 21:07:54 Last updated on 15/12/2003, 21:07:54 Последняя модификация15/12/2003, 21:07:54 تمت الحتلنة الأخيرة ب-15/12/2003, 21:07:54 |
Dry2 postponed
|
Dry2 assignment submission is postponed until Wednesday noon 17/12, 12:00. Be aware that the Wet assignment submission date won't be changed. Regards, Course staff |
| פורסם ב-11/12/2003, 11:08:23 Created on 11/12/2003, 11:08:23 Создано11/12/2003, 11:08:23 تم النشر ب-11/12/2003, 11:08:23 |
wet assignment is updated
|
Wet assignment on site is updated. Please refer to the revised files. Sorry for the inconvenience. |
| פורסם ב-7/12/2003, 14:23:05 Created on 7/12/2003, 14:23:05 Создано7/12/2003, 14:23:05 تم النشر ب-7/12/2003, 14:23:05 |
Wet - clarification
|
The proper way to check your program using input\output files is: wet parameters of 1st test >& 1.out diff -w 1.out 1.sol The corresponding section in wet's document was updated. |
| פורסם ב-7/12/2003, 13:47:13 Created on 7/12/2003, 13:47:13 Создано7/12/2003, 13:47:13 تم النشر ب-7/12/2003, 13:47:13 |
Dry2 - hint for Question 2
|
In case the original query cannot be converted to any semi-join query, you have to construct a collection of relation instances (i.e. non-empty instances for R1, R2 and so on) on which semijoins are useless. Regards, Course staff |
| פורסם ב-7/12/2003, 13:03:48 Created on 7/12/2003, 13:03:48 Создано7/12/2003, 13:03:48 تم النشر ب-7/12/2003, 13:03:48 |
Dry2 was updated
|
There was a minor correction in Question 2 D in the indexes of the joins. Regards, Course staff |
| פורסם ב-7/12/2003, 13:02:30 Created on 7/12/2003, 13:02:30 Создано7/12/2003, 13:02:30 تم النشر ب-7/12/2003, 13:02:30 |
Few corrections in Dry2.
|
Please refer to the updated version of the assignment. Sorry for the inconveniency, Lina. |
| עדכון אחרון ב-3/12/2003, 14:51:22 Last updated on 3/12/2003, 14:51:22 Последняя модификация3/12/2003, 14:51:22 تمت الحتلنة الأخيرة ب-3/12/2003, 14:51:22 |
Complementary tutorial on 3/12
|
Lina will give a complementary tutorial on Wednesday (3/12) at 12:30 (Taub 6). Regards, Course staff |
| עדכון אחרון ב-1/12/2003, 18:36:13 Last updated on 1/12/2003, 18:36:13 Последняя модификация1/12/2003, 18:36:13 تمت الحتلنة الأخيرة ب-1/12/2003, 18:36:13 |
DBMS: Wet assignment published
|
Wet assignment was published at the assignments page. Submission is until 4/1/04 (both electronically and printout - see details in the assignment). Sampe test cases will be published later. Moreover, the FAQ page at the course site will be updated periodically (with your questions and our answers). Any questions concerning the assignment should be sent by e-mail to uronbegatcs.technion.ac.il You are encouraged to start writing the assignment in the near future, since it might take some time to deal with all the requirements. Regards, Course staff |
| פורסם ב-30/11/2003, 22:17:37 Created on 30/11/2003, 22:17:37 Создано30/11/2003, 22:17:37 تم النشر ب-30/11/2003, 22:17:37 |
DBMS: Dry 2 assignment published
|
Dry2 home assignment published at the "assignments" section of the course homepage. The submission is in pairs until 15/12/03 10:30am, to the course cell. Any questions concerning the exercise should be sent by e-mail to uevelineatcs.technion.ac.il You can use the "Find a partner" section of the course site in order to find a pair for homeworks submission. Regards, Course staff |
| עדכון אחרון ב-27/11/2003, 15:28:42 Last updated on 27/11/2003, 15:28:42 Последняя модификация27/11/2003, 15:28:42 تمت الحتلنة الأخيرة ب-27/11/2003, 15:28:42 |
Updated Lecture 3
|
The revised version is now on the webcourse site. Regards, Course Stuff. |
| פורסם ב-19/11/2003, 12:35:14 Created on 19/11/2003, 12:35:14 Создано19/11/2003, 12:35:14 تم النشر ب-19/11/2003, 12:35:14 |
ODL + OQL Self Reading Assignment
|
Note that there is a difference between 2002 and 1997 editions of "A First Course In DBS". In 2002 Edition you should read: - Chapter 4, sections: 4.1, 4.2, 4.3. - Chapter 9, sections: 9.1, 9.2. In 1997 Edition you should read: - Chapter 2, sections: 2.1, 2.4. - Chapter 8, sections: 8.1, 8.2, 8.3. |
| פורסם ב-18/11/2003, 17:00:01 Created on 18/11/2003, 17:00:01 Создано18/11/2003, 17:00:01 تم النشر ب-18/11/2003, 17:00:01 |
dry1 postponed
|
Due to some complains about the Technion servers over the weekend and the web-db overload, Dry1 assignment submission is postponed until Sunday noon (23/11 12:00). Please notice that there won't be any more postpones due to this reason in the future. Regards, Course staff |
| פורסם ב-16/11/2003, 16:55:15 Created on 16/11/2003, 16:55:15 Создано16/11/2003, 16:55:15 تم النشر ب-16/11/2003, 16:55:15 |
Dry1 - FAQ
|
Q. I got "Sorry, we have reached the maximal number of connections" while trying to connect the web-db, what should I do? A. Connect the pgsql DBMS through the telnet interface, as shown in class and explained in the ex' |
| פורסם ב-16/11/2003, 14:34:27 Created on 16/11/2003, 14:34:27 Создано16/11/2003, 14:34:27 تم النشر ب-16/11/2003, 14:34:27 |
Dry1 - FAQ
|
Q: How can I find out if a field is a substring of another? A: ... WHERE field1 LIKE '%' || field2 || '%' or ... WHERE position(field2 in field1)>0 Regards, Course staff |
| עדכון אחרון ב-13/11/2003, 11:05:48 Last updated on 13/11/2003, 11:05:48 Последняя модификация13/11/2003, 11:05:48 تمت الحتلنة الأخيرة ب-13/11/2003, 11:05:48 |
dry1 update
|
Table Order changed to Orders, due to some unexplained technical problems. |
| פורסם ב-5/11/2003, 17:44:13 Created on 5/11/2003, 17:44:13 Создано5/11/2003, 17:44:13 تم النشر ب-5/11/2003, 17:44:13 |
DBMS: dry1 assignment published
|
Dry1 home assignment published at the "assignments" section of the course homepage. The submission is in pairs until 20/11/03, to the course cell. Any questions concerning the exercise should be sent by e-mail to ukorlandatcs.technion.ac.il You can use the "Find a partner" section of the course site in order to find a pair for homeworks submission. Regards, Course staff |
| עדכון אחרון ב-5/11/2003, 15:37:17 Last updated on 5/11/2003, 15:37:17 Последняя модификация5/11/2003, 15:37:17 تمت الحتلنة الأخيرة ب-5/11/2003, 15:37:17 |
Complementary lecture on 7/12
|
Oded will give a complementary lecture on Sunday 7/12 (16:30-18:30) in Taub 2. Regards, Course staff |
| פורסם ב-5/11/2003, 12:25:17 Created on 5/11/2003, 12:25:17 Создано5/11/2003, 12:25:17 تم النشر ب-5/11/2003, 12:25:17 |
DBMS announcements
|
1. The Complementary tutorial on Wednesday will take place in Taub 6. 2. The lectures and tutorials can also be found on the web accessible outside the Technion: http://www.cs.technion.ac.il/~cs236363/lectures/oshmu/ http://www.cs.technion.ac.il/~cs236363/tutPPT/ Regards, Course staff |
| עדכון אחרון ב-3/11/2003, 19:16:07 Last updated on 3/11/2003, 19:16:07 Последняя модификация3/11/2003, 19:16:07 تمت الحتلنة الأخيرة ب-3/11/2003, 19:16:07 |
Complementary tutorial on 5/11
|
Guy will give a Complementary tutorial for the Sunday 10:30 group (14), on Wednesday 5/11 13:30. |
| פורסם ב-2/11/2003, 11:59:20 Created on 2/11/2003, 11:59:20 Создано2/11/2003, 11:59:20 تم النشر ب-2/11/2003, 11:59:20 |
DBMS announcements
|
1. Tuesday tutorial (group 13) moved to Taub 3. 2. Wednesday tutorial (group 15) moved to Taub 6. Regards, Course staff |
| פורסם ב-19/10/2003, 10:59:09 Created on 19/10/2003, 10:59:09 Создано19/10/2003, 10:59:09 تم النشر ب-19/10/2003, 10:59:09 |