William Beaumont's MSCS544 Class

The Project

• P1

  • The XML data (in accordance with the DTD)
  • The XML data (in accordance with the XML Schema)
  • The Document Type Declaration (DTD)
  • The W3C XML Schema (XSD)
  • The Cascading Stylesheet (CSS)

• P2

  • The XML data

  • The queries

    • Q1: What are the U.S. states whose Senators both have the same party affiliation (Democrat, Republican, Independent, and Independent Democrat)?
      XML Output
      XSLT Transformation
      HTML Output
    • Q2: What are the most common first names in the Senate?
      XML Output
      XSLT Transformation
      HTML Output
    • Q3: How do the members of the Senate rank in terms of age, from youngest to oldest?
      XML Output
    • Q4: How do the members of the Senate rank in terms of how long they have held the office, from shortest time period to longest?
      XML Output
    • Q5: Which members of the Senate are technically up for re-election in 2008 (leaving aside whether they have declared that they will not run again)?
      XML Output
    • Q6: Who are the Junior members of the Senate? Who are the Senior members?
      XML Output
    • Q7: What are the U.S. states where the Governor and both Senators all have the same party affiliation (Democrat, Republican, Independent, and Independent Democrat)?
      XML Output
    • Q8: How do the Governors of each state rank in terms of how long they have held the office?
      XML Output

• P3

  • The XML data
  • XML-Relational Schema Mapping

  • SQL scripts to build and populate the relational schema

    • Oracle
    • MySQL

  • The queries

    • Q1: What are the U.S. states whose Senators both have the same party affiliation (Democrat, Republican, Independent, and Independent Democrat)?
      SQL
      SQL/XML
    • Q2: What are the most common first names in the Senate?
      SQL
      SQL/XML
    • Q3: How do the members of the Senate rank in terms of age, from youngest to oldest?
      SQL
      SQL/XML
    • Q4: How do the members of the Senate rank in terms of how long they have held the office, from shortest time period to longest?
      SQL
      SQL/XML
    • Q5: Which members of the Senate are technically up for re-election in 2008 (leaving aside whether they have declared that they will not run again)?
      SQL
      SQL/XML
    • Q6: Who are the Junior members of the Senate? Who are the Senior members?
      SQL
      SQL/XML
    • Q7: What are the U.S. states where the Governor and both Senators all have the same party affiliation (Democrat, Republican, Independent, and Independent Democrat)?
      SQL
      SQL/XML
    • Q8: How do the Governors of each state rank in terms of how long they have held the office?
      SQL
      SQL/XML

The Paper

• My paper presentation on "SQL/XML, XQuery, and Native XML Programming Languages" by Jonathan Robie