Scientific Technologies Corp.

Tyrus Peace

Stefanie Handrick

Nathan Winchester

Overview•IWeb•Current unmerge functionality•UI design•Use cases/test cases•Class design•Implementation•Schedule•Difficulties•The future

IWeb•Database of patient immunization records maintained by state governments

•Immunization records automatically added from a variety of sources

•Deduplication functions exist to prevent duplicate records

•Patient information accessed through a web application

Information Storage with IWeb

Reserve:Client1

Provider1

Reserve:Client1

Provider2

Reserve:Client1

Provider3

Reserve:Client1

Provider4

Reserve:Client1

Provider5

Master:Client1

Provider3

Merging Records with IWeb

Reserve:Client1

Provider1

Reserve:Client1

Provider2

Master:Client1

Provider2

Reserve:Client2

Provider3

Reserve:Client2

Provider4

Master:Client2

Provider3

Client 1 is the same

as Client 2.

• Users have to use an Adelphi application that isn’t integrated with the existing web app.

• Individually remove reserve records that are not associated with the correct master

• These records function as their own masters after being unmerged.

• Master/reserve records must be merged back together to correct the bad merge

Unmerging Records in IWeb:The Old Workflow

• Unmerge will be integrated into the existing web app.

• Take the ID of the patient to unmerge as input.

Improving IWeb’s Unmerge: The New Workflow

• List all reserve records associated with the patient in question

• Select two or more to become master records for the newly unmerged clients

Improving IWeb’s Unmerge: The New Workflow

• List the remaining reserve records and allow them to be associated with one of the previously selected master records.

Improving IWeb’s Unmerge: The New Workflow

• Patient ID doesn’t exist.

• The user defines less than two new master records for the unmerge.

• Not all reserve records are assigned to new master records.

• The user navigates away from the page or cancels in the middle of an unmerge.

Special Test Cases

• com.stchome.siis.accessors.UnmergeAccessor

– setMaster– updateReserve– getRecords

• com.stchome.siis.managers.UnmergeManager

– setMaster– updateReserve– getRecords

• com.stchome.siis.siisweb.actions.UnmergeAction– execute– Validate

• com.stchome.siis.siisweb.forms.UnmergeForm• com.stchome.siis.siisweb.forms.UnmergeMasterForm• com.stchome.siis.siisweb.forms.UnmergeReserveForm

Class Design

• com.stchome.siis.siisweb.forms.UnmergeForm• com.stchome.siis.siisweb.forms.UnmergeMasterForm• com.stchome.siis.siisweb.forms.UnmergeReserveForm

– Separate JSP pages for each of these forms.• Layout

– Must be dynamic to handle different amounts of clients

• Style– Must match current web app guidlines

Class Design

• Researched SVN solutions. Either charged monthly fees or didn’t offer the privacy our project required.

• Purchased a refurbished USPS machine with Xubuntu Linux installed for use as a Subversion server.

• 500MHz, 512MB RAM, $125

Version Control for the Project

• Eclipse• IDE

• Ant• XML make files for Java projects

• Tomcat• Deploying the web app for local testing

• Oracle DB• Database for local testing of the web app

Implementation of the Environment

Our schedule

  Week of:22-Jan

29-Jan

5-Feb

12-Feb

19-Feb

26-Feb

5-Mar

12-Mar

19-Mar

26-Mar

2-Apr

9-Apr

16-Apr

23-Apr

30-Apr

Phase                                

Conceptualization                                

  Problem                              

  Requirements                              

Analysis                                

  Use cases                              

  Test cases                              

Design                                

 Data structures                              

  Algorithms                              

  User interface                              

Implementation                                

  Coding                              

  Testing                              

Difficulties• Learning Struts and JDBC

– Only one team member was familiar with this kind of project.

• Subversion– Network issues– Unable to check in entire project

• Meeting with STC– Our advisor’s position in the company is currently

changing.– Design questions– Only recently got approval of our current design.

• Finish implementation stage

• Test the application with the integrated merge feature

• Compile the final report with user guide and other documentation

What’s Left?

Thank You

Any questions?