130 likes | 275 Views
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
E N D
Medical Record Broker ByAarti 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 beencreated 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.
Made in MS ACCESS Simple Has only 8 fields which are: Patient ID Lastname Middlename Firstname SSN DOB Sex Race Database Structure
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