CIS 560  Database  Resources
(an old page from a 2005 course).

TOC
   
Access
    Design 
    Oracle
    Java
    Web

Links:          
    Riccardi book supplement  and local 
    Silberschatz   and   Silberschatz book   and local
    Ullman book
    AW DB site
    DMBS's
    Notes folder

Access+VBA:    
     About.com   ...  FL Gulf Coast  Northwind db  

     PPT  , Old VB6 Examples (  Bank Example   and  Students Example and ADODB   VB-ODBC )
     Conversion VB6-to-VB.Net
     ADO concept  ..  ADO API  ..   ADO+VB data binding
     "VB.Net Step by Step"  Chap 3 .. Chap 19 .. Chap 20
     101 VB.Net Examples ..  MSPress
     MSDE   ...    MSDE
     VB.Net 60 Trial version
     .Net connection to Oracle  ..   Driver download

Design
     
Rational Unified Process
      Ambler DataModel profile 
      Rational DataModel profile
      IBM DataModel profile

Oracle

    CIS "How to connect to Oracle"  now it is here http://support.cis.ksu.edu/docs/user/faq/other/Oracle.html
    Oracle9I  Documents   and Concepts Guide , about  naming   and OracleFAQ 
    iSQL*Plus  
    SQL  ,  Bank Example (SQL)   ,     Oracle Slides
    JDeveloper screens   .. JDev viewlets
    Locks
    Tuning tools  .. Booktuning paper  ..  Tuning book .. OraPub tools
    interMedia  Guide   and interMedia Java Classes  Guide
    Support tools:     DBA Studio .. TOAD ..  embarcadero

Java:  developer.java.sun.com
  local Java doc  ...JDBC page  ...basic tutorial ...java.sql   ...and .. javax.sql  ....
  JDBC Short Course
   about JTable   ...
   Dukes Bakery  
   POS example  (with JTable)
  zaurak example (JBuilder)   , example (unix) (world's shortest ... but bad :-(  )
  Oracle:  Oracle jdbc
       more JDBC samples   ....
  ancient classes111.zip  ... local Oracle-jdbc  on  \\files\pc_software\oracle-jdbc\lib
              ojdbc14.jar  ........in  Oracle  folder  in ....
  JDBC home
 

Web connection  to DB
   data sources ...  CISUnix => Camaro
   Classpath information
   J2EE Enterprise Edition ... Servlet API
   old  web links
   Gittleman examples
  Tomcat:  
           Tomcat 5 is now available on all public unix machines and on cislinux(canopus).
            The command to install it for a user is "installtomcat5"
     
It will create a tomcat5 directory in your home directory.
                 old confinguration example
           Windows server   

   more examples in CoreWebProgramming
  XML:   Learning XML  ,  XPath XMLQuerySAX   ( XML on Oracle vs  an XML DB )
           Coverpage  ....XACML
  J2EE  ,  Dukes Bank example;
  Application servers:  comparison chart  ;  JBoss
       Goa

Applications Systems
  SalesForce

Topics Presentations
   Biological databases
   Oracle privileges
   JSP   and ASP.net
   VB2Oracle  and reference
   JDBCODBC
   PerlCode connect to  SASCode
   Locks
   Data access in Mono
   MySQL
   Servlets
   Constraints
   Stored Procedures
   Timing slides and programs
   Data mining
   Indeces

Old topics:
   Image database w Blobs
   Transaction w manual commit / rollback
   Timing of sql operation  (C++ version)
   Perl DB connection  ppt slides,   POS demo ,   source
   Apache user validation using mySQL
   JBuilder DB-aware beans demo project    and  extended, runnable version (use the bat file, but it references C:/JBuilder )
                                                                                                                   (self contained version later)
   Google search API  info page
   Document XML DB info page
   Locks slides  and sample code
   Index files  slides  and sample code
   VB connection to Oracle sample code
   ASPX  tutorial
   Security
    Grid DBs

   Salaries:  Computer World   ,  PayScale_by_years,  Computerworld , CNN  starting $$,
Other DBMS

    CA-IDMS  used by KSU ISO