1. 4:30-5:20
   YuPing, Jake, Roman
2. The following demos has been prepared and discussed
   1) Oracle JDBC thin driver 
      Demo type: Java applet
      URL: http://mira.npac.syr.edu:1210/jdbc/111-applets/testjdbc.html
         thin driver requires less memory than oci8
              but is also slower
   2) Oracle JDBC driver oci8
      Demo type: command
      Run: login as "oracle"
          cd /localb/oracle/app/oracle/product/8.1.5/
          cd jdbc/demo/samples/oci8/basic-samples
      then type: java Employee
          oci8 driver is faster but needs more memory
   3) XML parser for java v2 (updadte version on July 2th)
      Demo type: Command
      Run: login as "oracle"
           cd /localb/oracle/app/oracle/product/8.1.5/xml21/sample
      a) DOM interface:
         i) DTD in XML file:
            java DOMSample class.xml 
            java DOMSample empl.xml
        ii) DTD out of XML file (family.dtd)  
            java DOMSample family.xml
      b) SAX interface:
         i) DTD in XML file:
            java SAXSample class.xml
            java SAXSample empl.xml 
        ii) DTD out of XML file (family.dtd)
            java SAXSample family.xml
      c) XSL Stylesheet (iden.xsl)
         i) DTD in XML file:
            java XSLSample iden.xsl class.xml
            java XSLSample iden.xsl empl.xml
        ii) DTD out of XML file (family.dtd)
            java XSLSample iden.xsl family.xml
   4) XML SQL Utility for Java
      Only have client_side demo provided by Oracle,
      YuPing will  create server_side demo later.
      Demo type: command
      Run: login as "oracle", source 
      
/localb/oracle/app/oracle/product/8.1.5/xmlsql/OracleXSU/unixenv.csh
      Comment: OracleXML are loaded into the database
      a) generate XML from table of database
         command format:
         java OracleXML getXML [-withDTD] [-user "scott/tiger"] \
            "select * from emp"
          for example:
         java OracleXML getXML -user "scott/tiger" "select * from emp"
          Or you can try your own schema for any tables with at least
one row.
      b) insert XML file into table of database
         command format:
         java OracleXML putXML [-user "scott/tiger"] XMLFile tableName 
            Please try your own schema and map the columns of table with
            XML tags. For Example
         java OracleXML putXML -user "scott/tiger" \
            -filename b.xml  roman-table        
   5) XSQL Servlet
      Demo type: Browser, complete demo needs Internet Explorer 5.0
      URL: http://mira.npac.syr.edu:1210/demo
       Please pay attention to .xsql file and dynamically
       generated raw XML file or HTML file.
      These demos are using the real database
3. Document repository
   - we want to store: DOC, PDF, ASCII, other
        with key-words, totle, author, abstract
   - LOB can be used for this purpose
4. We need to
   - interract with NCSA
   - install InterMedia
   - check LOB
   - sest Application Server (Jweb, DAD)o
5. How to put documents into the DB
   - from Web Interface {through Java Servlet}
   - insert XML {through SQL Utility: command(client),
       program( server)
   How to extract documents from the DB
   - from browser {XSQL servlet to display
            Raw XML
            DHTML
   - generate XML
            DOM
            Raw XML (with or without DTD)