DBLP is a computer science bibliography website that collects published papers, including journal papers, conference papers, etc. SIGMOD Edgar F. Codd Innovations Award is the highest honor in the database community, recognizing lifetime achievements that have made a lasting impact on the field. The DBLP entries for all the winners are available at EFCoddAward.zip (by April 30, 2025).
If the XML is not formed, you can manually change it by yourself. e.g., replace "&" with "&".
(Some example queries from course lectures can be found in XQueryExamples.zip. Examples on expressing XQuery in Db2 can be found at db2xquery.zip).
Michael Stonebraker was recognized with the Turing Award in 2014 "for fundamental contributions to the concepts and practices underlying modern database systems.” H won the first SIGMOD Edgar F. Codd Innovations Award in 1992. Carlo Zaniolo is the winner in 2025.
We will write following XML queries using Oxygen XML (instructions on using Oxygen XML). We assume author names are unique. (10 points)
(4 points) Query 1. Write an XQuery to return for each year (sorted in descending order) : 1) the count of papers by Michael Stonebraker in three main database conferences: 1) ACM SIGMOD Conference ("SIGMOD Conference"), 2) VLDB ("Proc. VLDB Endow." and "VLDB", excluding "VLDB J."), and ICDE ("ICDE"). (q1.xquery).
We will load all SIGMOD Edgar F. Codd Innovations Award winners' dblp XML files into an XML database. The schema is defined in createtable.sql and the JDBC codes are available in DBLPImporter.java. Please use the codes to create the table and load all XML documents into the database.
(3 points) Query 2. Please write an XQuery to return the list of authors who ever published with both Michael Stonebraker (the first winner) and Carlo Zaniolo (the latest winner) in the history. (q2.sql).
(3 points) Query 3. Please write an XMLQuery to return the paper(s) with most co-authors for each SIGMOD Edgar F. Codd Innovations Award author (based on root element dblp's "name" attribute). (q3.sql).
Submission: please zip your XQuery files and results (as text files or screenshots) and submit at BrightSpace.