Web Interfaces to Backend Databases
We have two database systems that need work -- a DPS dissertation database system and a genealogy database system.
We are primarily interested in completing the DPS database with a proper web interface.
If time permits, improvements could also be made to the genealogy database system.
The Doctor of Professional Studies (DPS) in Computing at Pace University is a a unique doctoral program
that allows active IT professionals to earn a doctorate degree in three years through part-time study.
There are currently about 70 completed DPS dissertations, see
The DPS dissertation database categorizes dissertations in a number of ways and collects associated information in one location.
Each dissertation is given
- subject matter category: software development - agile, software development - non agile, agile approach in non software development areas,
pattern recognition - biometrics, pattern recognition - other than biometrics, networking, data mining, web/internet related, etc.
- methods used: surveys, interviews, statistical analysis, programming, etc.
- advisor and other committee members
- related publications (no more than 2)
- years to completion
A MySQL database with a PHP web interface was completed last semester using the WinSCP (Windows Secure CoPy) software, see the interface at
DPS Dissertation Database
and the associated
The project this semester will develop an easy-to-use interface to add/delete/modify the tables and queries.
If time permits we will examine for possible extensions the Genealogy system.
Fast Agile XP Deliverables
We will use the agile methodology,
particularly Extreme Programming (XP) which involves small releases and fast turnarounds in roughly two-week iterations.
Many of these deliverables can be done in parallel by different members or subsets of the team.
The following is the current list of deliverables
(ordered by the date initiated,
initiated date marked in bold red if programming involved,
deliverable modifications marked in red,
completion date and related comments marked in green,
pseudo-code marked in blue):
- 2/1 .
Become familiar with the current DPS dissertation database and web interface.
Plan the semester's work with your customers.