Recitation #6 Slides

The slides for the sixth recitation (r6) are available through the link below:

http://www-student.cse.buffalo.edu/~dlessa/cse462-SP10/r6.pdf

UPDATE: DBLP Practice Queries

The DBLP practice queries have been updated with minor syntax fixes to support the Oracle SQL dialect. In particular, because of the two non-standard features below:

1. Oracle does not support the keyword AS in FROM for aliasing, but you can specify aliases without AS.

2. The set difference relational operator in Oracle is MINUS rather than EXCEPT.

For other non-standard features in Oracle see:

http://infolab.stanford.edu/~ullman/fcdb/oracle/or-nonstandard.html

New slides: Conceptual Database Design

Clarification: Paper and Publication

Guys,

For the purposes of Project #1, paper and publication are synonyms and correspond to an entity in the DBLP_ENTITY table. For question 1.1, you should restrict your search to entities of type inproceedings, as explained in the last recitation (r5).

Demian

Top-K

The Java library file for the first project (p5) is available through the link below:

http://www-student.cse.buffalo.edu/~dlessa/cse462-SP10/topK.jar


About the library:

• TopKImpl is the skeleton class that you must implement. It is a stub that implements the TopK interface. You may create any number of helper methods in this class.
  

• ScoringFunction is the interface that defines the signature of a scoring function. A sample implementation of scoring function, ScoringFunctionImpl, is provided for you to test your implementation.

• Tuple is a simple class that extracts and encapsulates a single tuple from a ResultSet object.
  

• OraConnectionProxy is a helper class for you to connect to Oracle. Use if you like it. First, you must modify the user name and password in order to connect to Oracle.

• Launcher has a main method that you can use to test your implementation. Two queries are provided with code calling your Top-K implementation. Test data is available to help you check if your algorithm is running correctly (the data has been commented out).
  

If you have any questions, feel free to send me an e-mail.

Recitation #5 Slides

The slides for the fifth recitation (r5) are available through the link below:

http://www-student.cse.buffalo.edu/~dlessa/cse462-SP10/r5.pdf


Observation about query 2.1 in the project.

I want to make this absolutely clear. Your query may return any number of rows satisfying the given criteria (it doesn't matter how many rows the query returns). However, the third row in the result must be the one containing the "author who published the THIRD smallest number of papers amongst the authors with more than 400 publications." This can only be achieved using the ORDER BY clause.

Project #1