Transcript Medical Record Broker

Medical Record Broker
By Aarti Nankani
Topics of Discussion
Introduction of the customer, their
problem and their role
Main computing environment issues
Project Accomplishments
Database Structure
The components of the EJB
Logic of checkpoint() method used
Technology and tools for executing new
development effort
Introduction
The Customer is Mid America Heart
Institute, a recognized cardiovascular
center of excellence.
Their current computing environment
does
not
support
a
distributed
component-based
computing
environment.
The customer defines the requirements,
project scope and the user interface.
Computing Environment Issues
Their current computing environment is not
scalable, flexible, or interoperable.
The data in their database is manipulated
through custom-made applications or
programs wasting valuable time that could
be spent analyzing the data.
Duplicate patient_ids have been created in
the past because the data was not normalized
and database integrity was compromised.
Project accomplishments
Developed an OO middleware
Developed a configurable database
connection
Extract data from the sample database
Perform server-side applications
Check for matches in the database based
on
Last name
First name
SSN
Result - return whether matches found or
not.
Database Structure
Made in MS ACCESS
Simple
Has only 8 fields which are:
Patient ID
Lastname
Middlename
Firstname
SSN
DOB
Sex
Race
The EJB Patient has….
Remote Interface
Defined for the Patient EJB.
Class Patient Bean implements the
method checkpatient().
Home Interface
Creates an instance of the PatientBean
class on the server.
Returns a remote reference to an Patient
interface on the client.
Continued..
class PatientClient
Creates an instance of the Patient EJB on the EJB
server.
Calls its checkpatient() method to update the
database.
class PatientServlet
Provides a user interface.
Calls the Patient EJB by passing to it a few
parameters.
The EJB then returns a result which the servlet
displays to the Web client.
Continued..
class PatientBean
It contains the implementation for the
checkpatient method.
It also includes empty method bodies for
the methods prescribe by the Session
Bean interface.
The checkpatient() method
Takes in three parameters
Last name
First name
SSN
Forms a connection between the
server and the database using JDBC
Communicates with the database
using SQL query.
Logic of checkpatient()
Defines a variable no_of_hits to show the
number of records having same last name
and first name in the database.
If no_of_hits is greater than or equal to one
it compares the SSN given in the parameter
to the SSN present in the database.
If the SSNs match then no record is added.
Continued….
If not a new record is added to the database.
If no_of_hits is zero then a new record is
added to the database.
Technology and tools for
executing new development
effort
JAVA2 Enterprise Edition 1.3 and 2.0 -provide
server-side and client-side support for
developing enterprise, multitier
applications
Together 5.5 -UML modeling tool
JBOSS 2.4.1- application server
ANT 1.4 -Java based build tool
TOMCAT 4.0 / JETTY 3.1.0 - web server
MS Access 2000 - database