CSCI E-259 Final Project Proposal

i. Project Management System

ii. Nelson Dupere

iii. Abstract

My proposal is to create a web-based time management system that can be used to track projects and time for multiple users. The system will use an XML database for storage, retrieval, and reporting of the information.

iv. What

Name

XML Project Mgmt.

Description:

There will be several files in the system primarily for tracking users, projects, and time. If possible, I will use Xindice as the underlying database. The project file will consist of a title, description, type, and one or more users with a status. The user file will store their name, ID, password, and perhaps a role. The time file will store time by project and user.

Type:

  • Major
  • Minor
  • Issue
  • Admin

Assignees:

  • Nelson Dupere
  • Joe Schmoe

 

Project

Mon

Tue

Wed

Thur

Fri

Sat

Sun

Total

XML Project Mgmt.

4.5

3.5

8

Xtube enhancement

0.5

7.5

8

Rewrite SVG

1.0

1

Minor XSD change

1.0

1

Minor Fix for Joe S.

2.0

2

Issue 10312345

0.5

4.0

3.0

7.5

Issue 24456001

7.0

1.0

8

Admin

2.0

2

Total

7.5

7.5

7.5

7.5

7.5

37.5

v. Why

I chose this project originally because I have to track my hours at work and submit them to my manager in spreadsheet form. He takes all the spreadsheet data and aggregates the information into reports. I had hoped to be able to replace that process.

However, I now do not think it is feasible to implement this system at work for several reasons. First, we have neither a spare server, nor the in-house staff to maintain and configure it if we did. Second, I would not be able to handle the extra responsibility of maintaining the application.

So, I am now approaching this an academic exercise.

vi. How

Much of my system will utilize techniques from previous projects the servlets and and login page, for example. XSLT will be used to generate the timesheet and any reports. The most challenging piece would be to implement Xindice for the database. There is a lot of information on the website referring to collections and indexes that will require further research. Integrating this into the project would be very rewarding.

vii. Questions

I could add more functionality to the system, such as administration, and restricting access to reports based on authorities, flexible reporting, etc. Should I try to work that into the project or will I overextend myself trying to get Xindice to work? Will someone be able to install/configure Xindice on the "nice" system at Harvard?