You may calculate your course total score using the weight given in the first day of class (and posted on the course page). Below are the numeric ranges for the letter grades. Note that the grades of three people were lowered from A- to the B range due to wrongdoings during the final exam.
A+ 94-98 2 A 83-89 12 A- 75-80 9 B+ 69-71 6 B 62-66 4 B- worse 3 C+ worst 1 W 1
I posted practice problems for the midterm exam. We will have a final review on Thursday of next week, during which questions about the practice problems will be answered. The final exam will be inclusive; its scope will include relational databases, object and object-relational databases, XML databases, query processing and optimization, distributed databases, and OLAP and data mining.
There is a slight difference between the slides posted and slides I used in lecture today: in the one I used, on slide 28 (semijoin introduction example, in Chapter 18), Step 2 sends Q to A (not sending to C), and Step 3 sends transcript to A and do join at A (not computing join at C and sending result to A), and total cost is even better (405K instead of 465K).
`While working on project2, I found the following documents very useful:
XPath 1.0: http://www.deepx.com/resources/quickref/XPath-1.0.pdf
XSD: Structures 1.0: http://www.deepx.com/resources/quickref/XSD1-1.0.pdf
XSD: Datatypes 1.0: http://www.deepx.com/resources/quickref/XSD2-1.0.pdf
These are in-a-nutshell documents that are very useful as a quick reference.
I think some students can also benefit from these documents. Would you please post them on our class page?'
Added slides for new version of the part on XQuery in Chapter 17.
Please include your project description in your handin on Thursday, unless you want to use any original description you had given me.
`After spending some time at DB2 documentation page I found out one manual that I think might be very useful in developing DB2 applications. It is called "Application Development Guide", the pdf file is here:
and HTML version is here:
What I really liked there is that the material was organized much better than in SQL reference. For example, to find out everything about structured type one should look at chapter 12. It covers such topics as creation of such types, inserting tuples of these types (by using mutator and observer functions) and so on.
I think that other students might want to look at this manual as well so it might be worth placing these urls to the course page.'
Both DB2net1 and DB2app1 samples there should work on both the Suns and the Grad PCs, but after testing all, our TA Bin found one problem with the DB2app1 sample on the Grad PCs. Our system admin expects to fix it next week; for now you could use one of the other three options.
My understanding is that DB2net1 is slower but is easier to work with, while DB2app1 requires the DB2 client software to be installed on the system and for the databases you will be accessing to be cataloged. You should be able to use DB2net1 from home with appropriate setup as indicated at the bottom of the new instruction page; you could also use DB2app1 from home if you also download appropriate DB2 client software from IBM website.
If you have any further problems connecting to DB2, send email to ntadminATcsDOTsunysbDOTedu and cc me.
If you have given me an incomplete description, you will need to fix it. For example, many descriptions I've been reading simply did not list precise queries or set-valued data. BTW, many of you did not include email addresses in what you've given me.
sbpub machines have been moved from Room 2206 to 1204.
Added Handout P1 for Project Part I. Added also links to Trans Labs, IBM DB2 UDB V7 SQL References, Java and JDBC Specifications, etc.
Students working in the Solaris environment can use one of the
sbpub machines in Room 2206. Students working in NT
can use the PCs in Room 1239, the graduate NT lab.
There is a correction to the little account information sheet you
received today: There is a problem with using the
dbregister command on our Solaris machines. The problem
appears to be related to Solaris. In order to register on a Solaris
(Sun) machine, you will need to
cd to the
directory and run the program directly.
If you have any problems with your DB2 account, send email to ntadminATcsDOTsunysbDOTedu.