CS297-298 Project News Feed

# Tasks to do:
  1. Find out why PotgreSQl system could not detect fcur.so while making fucntions.

# Next meeting (3/13/07)

# Tasks to do:
  1. Find some exaples with compilation instructions for compiling C code into SO (Shared Object), i.e., fcur.c into  fcur.so.

# Next meeting (3/6/07)

# Tasks to do:
  1. Do a "C" example on how to create PostgreSQL Type in Linux environment.  Use GCC or Cygwin complier if possible.

# Next meeting (2/27/07)

# Tasks to do:
  1. Do a "C" example on how to create Type in PostgreSQL, involved Functions.  Use GCC or Cygwin complier.

# Next meeting (2/5/07)

# Reviewed progress on DEFINE TYPE function.

# Tasks to do:

  1. Research on "CREATE LANGUAGE" command for Java.
  2. Go through C examples on "CREATE FUCTION" command.
  3. Alternatively, can we used PL/pgSQL as the primary programming language for the project?
  
# Next meeting (10/2/2006)  
   

# Discussed "CREATE TYPE name..." in more details such as INPUT, OUTPUT functions, and INTERNALLENGTH.

# Tasks to do:

  1. Example on "CREATE TYPE name..." command
  2. Three suggestions on how to insert XML data.
  
# Next meeting (9/26/2006)  

# Discussed XML DTD and Schema.

# Discussed parameterized typing fuctions.

# Tasks to do:

  1. Researched to see which GiST tree to use
  2. Find some "C" or "C++" parsers; or use Java and SAX parser.
  3. Search and study XML DTD and Schema tutorials.
  
# Next meeting (9/12/2006)  
   

# Reviewed CS297 Report.

# Reviewed CS298 Proposal

# Tasks to do:

I.  Add another paragraph to Introduction of CS298 Proposal about PostgreSQL.

II. Submit CS298 Proposal.

# Tasks to do:

I. Revise CS297 Final Report:
  1. Expand future work to 1 page.
  2. Expand introduction to 1 page.  Describe the project in more details.
  3. Give Dr. Pollett a PDF version.

II. Prepare CS298 Proposal:

# Next Meeting: (8/30/2006)

# Reviewed the second draft of the final report.
# Tasks to do:
  1. Continue on the Deliverable #3.
  2. Add some more details to the Deliveralbe #3.

# Reviewed the first draft of the final report.
# Tasks to do:
  1. Continue on the Deliverable #3.
  
# Next Meeting (5/16/2006) 

# Discussed what shoud be on the final report.
# Discussed Deliverable #3
  1. Create two more functions for Tetrahedron.
  
# Next Meeting (5/9/2006)

# Reviewed Deliverable #2 and suggested enhancements:
  1. Revise the description paragraph.
  
# Next Meeting (5/2/2006)

# Additional Tasks to do:
  1. Create one new function for Cube index.
  2. Create five functions for Tetrahedron index.

# Reviewed deliverable #1 and suggested enhancements:
  1. Remove invalid chars for XML parsers before processing and uploading records to DB.  Keep these chars: Tab, CR, Line Feed, and Form Feed.

# Reviewed Deliverable #2 and suggested enhancements:
  1. Replace <font> tag with <style> tag.
  2. Replace <list> tag with <ol> tag.
  3. Replace XHTML 1.0 to 1.1.
  4. Reduce the size of output screen captures.
  5. Rename the file names of output screen captures to short names such as del2_1.jpg, del2_2.jpg

# Next Meeting (4/25/2006)

# Additional Tasks to do:
  1. Create one new function for Cube index.
  2. Slides on how to implement Pyramid index.
  3. PostgreSQL functions for Pyramid index.
  4. How to modify these functions.

# Debuged deliverable #1.
# Reviewed Deliverable #2 and made some suggestions.

# Next Meeting (4/18/2006)

# Tasks to do:
  1. Revise deliverable #1.
  2. Deliverable #2: patial search with tsearch2.  If no results, use regular LIKE operator.
  3. Review trees: B+, KD, R.
  4. Example of GiST implementations for, i.e. Cube.

# Reviewed Deliverable #2 and made some suggestions.

# Next Meeting (4/6/2006)

# Tasks to do:
  1. Revise deliverable #2 to employ "documents" and "document" functions on page 969 of PostgreSQL book.  Search for phrase of words.
  2. Read and prepare slides for GiST chapter.
  3. Revise deliverable #1 to parse any simple XML document.

# Reviewed PowerPoint document, New Inlining Algorithm.
# Reviewed deliverable #1.
# Reviewed work of deliverable #2.

# Next Meeting (3/21/2006)

# Tasks to do:
  1. Minor fixes for PowerPoint document, New Inlining Algorithm.
  2. Continue work on deliverable #2 (Searching docs in digital library DB).
  3. Try to use SAX Parser for deliverable #1.

#Reviewed examples for the translation and decomposition section at the end of PowerPoint doc #3.
# Reviewed deliverable #1.
# Reviewed initial work for deliveralbe #2.

# Next Meeting (3/14/2006)

# Tasks to do:
  1. Try deliverable #1 again with SAX parser (removing html portions and make input file as a well formed xml document.
  2. Continue deliverable #2 (Searching docs in digital library DB).

# Reviewed deliverable #1.
# Reviewed PowperPoint doc #3.
# Installed scripts and made tsearch2 working.

# Next Meeting (3/7/2006)

# Tasks to do:
  1. Some touchup on deliverable #1 before posting up.
  2. Add examples to the translation and decomposition section at the end of PowerPoint doc #3.
  3. Do reading #4.
  4. Install Apache server and PHP.  Start working on Deliverable #2.

# Reviewed the changes of PowerPoint Doc #1 and #2.

# Next Meeting (2/28/2006)

# Tasks to do:
  1. Continue Deliverable #1.
  2. Figure out why tsearch2 functions not working.
  3. Do reading #3.

# Reviewed PowerPoint Doc #2 (tsearch2 package.)

# Next Meeting (2/21/2006)

# Tasks to do:
  1. Can we control "Stop words" and "Stems" in tsearch2 environment?
  2. Demo some working tsearch2 queries.
  3. Show deliverable #1.

# Reviewed power point Doc #1 (Storing and Querying Ordered XML Using a Relational Database System.

# Next Meeting (2/14/2006)
# Task to do:
  1. Send in my short Biography.
  2. Fix up power point doc #1 with xml tree examples.
  3. Reading #2 (how tsearch2 works).
  4. Start programming in Java on programming assignment #1.