Database Systems

Support Materials

• Helpful Information on Using ORACLE (From Stanford),
  including SQL commands, bulk loading, pl/sql, jdbc, and so on!. (html)

• How to get to ORACLE at WPI (SQLPLUS)? .

• In order to connect to the Oracle database on WPI using JDBC, you need to have download the "classes12.zip" package for JDBC connection from the Oracle's web site at "http://technet.oracle.com/software/tech/java/sqlj_jdbc/software_index.htm" or, ( download the file "classes12.zip" from WPI. )

• Oracle's web site at "http://technet.oracle.com/software/tech/java/sqlj_jdbc/software_index.htm" also has a variety of code examples for using JDBC.

• JDBC Introduction (by John Russo, 2007):
  
  • description (pdf).
    
  • dropship.sql
    
  • insship.sql
    
  • makship.sql
    

• One nice on-line server for database related literature is http://www.informatik.uni-trier.de/~ley/db/index.html

  Elementary DB Material:

  • Introductory Material on Sets, Relations and Functions can be found here.
  • Another introduction to set theory can be found here
    
    
  • DB I at other universities
    • Stanford
    • Wisconsin
    
    
  • ER Model
    • The original paper that introduced ER in 1976 can be obtained here
    
    
  • Example Views can be found here
    
  • Example Stored Procedures and Triggers can be found here

  More material useful for projects

  • Oracle Documentation is available here
  • MySQL Documentation is available here
    
    Reference on HTML Forms
    http://www.w3.org/TR/REC-html40/interact/forms.html
    http://www.w3schools.com/html/html_forms.asp
    
    Handout on Perl/CGI, and how to use Perl DBI with Oracle/mySQL ps pdf
    Code for the above can be found at: http://www.wpi.edu/~mmani/perlSamples
    
    
    Extra Reference on Perl DBI: http://search.cpan.org/~timb/DBI/DBI.pm
    
    Simple user authentication mechanisms using Perl and examples can be found here. ps pdf
    
    Handout on JDBC ps pdf
    Introduction to JDBC with Oracle from Stanford can be found here
    Reference on calling procedures/functions using java.sql.CallableStatement: http://java.sun.com/j2se/1.4.2/docs/api/java/sql/CallableStatement.html
    
    Handout on servlets ps pdf
    Extra Reference for Servlets can be found here or here

    If you are using servlets, you might bundle up your code as a Web ARchive (WAR). Test your WAR before submitting it. Documentation on how to build your WAR file is available here
    
    

  • Embedded SQL
    • Sample code for using SQL with C on Oracle (Pro*C):ps pdf
    • More sample code on Pro*C ps pdf
    • SQL can be used with C++ on Oracle (Pro*C)ps pdf
      
      
    • Extra reference on using SQL with C on Oracle can be found here
      
      
    • Sample code for using SQL with Java (SQLJ): ps pdf
    
    
  • Some sample pieces of code for building applications can be found here
  The CS WPI suggestions for documenting your software can be found at Documentation Standard.