supporting the joint medical workstation project€¦ · akamai summer internship . akimeka, llc...
TRANSCRIPT
![Page 1: Supporting the Joint Medical Workstation Project€¦ · Akamai Summer Internship . Akimeka, LLC • IM/IT services and solutions provider . Health Care Systems Solutions Information](https://reader035.vdocuments.us/reader035/viewer/2022081617/605820105e80c422df553a3f/html5/thumbnails/1.jpg)
Supporting the Joint Medical Workstation
Project Glenda Ramos
Mentor: Matt Rauls Maui Community College
Akamai Summer Internship
![Page 2: Supporting the Joint Medical Workstation Project€¦ · Akamai Summer Internship . Akimeka, LLC • IM/IT services and solutions provider . Health Care Systems Solutions Information](https://reader035.vdocuments.us/reader035/viewer/2022081617/605820105e80c422df553a3f/html5/thumbnails/2.jpg)
Akimeka, LLC
• IM/IT services and solutions provider
![Page 3: Supporting the Joint Medical Workstation Project€¦ · Akamai Summer Internship . Akimeka, LLC • IM/IT services and solutions provider . Health Care Systems Solutions Information](https://reader035.vdocuments.us/reader035/viewer/2022081617/605820105e80c422df553a3f/html5/thumbnails/3.jpg)
Health Care Systems
Solutions
Information Assurance
Logistics Systems
Infrastructure Solutions
Joint Medical Workstation
![Page 4: Supporting the Joint Medical Workstation Project€¦ · Akamai Summer Internship . Akimeka, LLC • IM/IT services and solutions provider . Health Care Systems Solutions Information](https://reader035.vdocuments.us/reader035/viewer/2022081617/605820105e80c422df553a3f/html5/thumbnails/4.jpg)
Joint Medical Workstation (JMEWS)
![Page 5: Supporting the Joint Medical Workstation Project€¦ · Akamai Summer Internship . Akimeka, LLC • IM/IT services and solutions provider . Health Care Systems Solutions Information](https://reader035.vdocuments.us/reader035/viewer/2022081617/605820105e80c422df553a3f/html5/thumbnails/5.jpg)
JMEWS Capabilities
DISEASE TRACKING STATUS OF FACILITIES
CURRENT SUPPLIES
REPORTS (TEXT AND VISUAL)
![Page 6: Supporting the Joint Medical Workstation Project€¦ · Akamai Summer Internship . Akimeka, LLC • IM/IT services and solutions provider . Health Care Systems Solutions Information](https://reader035.vdocuments.us/reader035/viewer/2022081617/605820105e80c422df553a3f/html5/thumbnails/6.jpg)
![Page 7: Supporting the Joint Medical Workstation Project€¦ · Akamai Summer Internship . Akimeka, LLC • IM/IT services and solutions provider . Health Care Systems Solutions Information](https://reader035.vdocuments.us/reader035/viewer/2022081617/605820105e80c422df553a3f/html5/thumbnails/7.jpg)
Support Tasks
JMEWS DEVELOPMENT
STIGS JAVA STORED PROCEDURE
DATABASE
NETWORK
APPLICATION SERVICES
OPERATING SYSTEM Windows 2000/XP/2003
ORACLE WAREHOUSE
BUILDER
![Page 8: Supporting the Joint Medical Workstation Project€¦ · Akamai Summer Internship . Akimeka, LLC • IM/IT services and solutions provider . Health Care Systems Solutions Information](https://reader035.vdocuments.us/reader035/viewer/2022081617/605820105e80c422df553a3f/html5/thumbnails/8.jpg)
STIGS
Apply Check and Load
Server/Computer
SRRS FIX RESULT
![Page 9: Supporting the Joint Medical Workstation Project€¦ · Akamai Summer Internship . Akimeka, LLC • IM/IT services and solutions provider . Health Care Systems Solutions Information](https://reader035.vdocuments.us/reader035/viewer/2022081617/605820105e80c422df553a3f/html5/thumbnails/9.jpg)
• Software Requirements – JDK (Java Development Kit 1.2 or
higher)
– Oracle Database
Java Stored Procedure
![Page 10: Supporting the Joint Medical Workstation Project€¦ · Akamai Summer Internship . Akimeka, LLC • IM/IT services and solutions provider . Health Care Systems Solutions Information](https://reader035.vdocuments.us/reader035/viewer/2022081617/605820105e80c422df553a3f/html5/thumbnails/10.jpg)
Java Stored Procedure
WRITE YOUR JAVA CODE
LOAD AND RESOLVE YOUR JAVA CODE
PUBLISH YOUR JAVA CODE
RUN/CALL YOUR JAVA CODE
![Page 11: Supporting the Joint Medical Workstation Project€¦ · Akamai Summer Internship . Akimeka, LLC • IM/IT services and solutions provider . Health Care Systems Solutions Information](https://reader035.vdocuments.us/reader035/viewer/2022081617/605820105e80c422df553a3f/html5/thumbnails/11.jpg)
Sample Commands/Scripts
loadjava -u uid/password@dbconnection -v -resolve c:\file.java
CREATE OR REPLACE FUNCTION
FUNC_JAVA(parameter IN VARCHAR2) RETURN VARCHAR2 AS
LANGUAGE JAVA NAME 'com.akimeka.db.oracle.utilities.file.program(java.lang.String) return java.lang.String';
/
![Page 12: Supporting the Joint Medical Workstation Project€¦ · Akamai Summer Internship . Akimeka, LLC • IM/IT services and solutions provider . Health Care Systems Solutions Information](https://reader035.vdocuments.us/reader035/viewer/2022081617/605820105e80c422df553a3f/html5/thumbnails/12.jpg)
Run/Call Java Code
CREATE OR REPLACE TRIGGER trigger_name BEFORE INSERT ON table_name REFERENCING NEW AS
NEW OLD AS OLD FOR EACH ROW DECLARE BEGIN :NEW.VAR := FUNC_JAVA(:NEW.CODE); END; /
![Page 13: Supporting the Joint Medical Workstation Project€¦ · Akamai Summer Internship . Akimeka, LLC • IM/IT services and solutions provider . Health Care Systems Solutions Information](https://reader035.vdocuments.us/reader035/viewer/2022081617/605820105e80c422df553a3f/html5/thumbnails/13.jpg)
Oracle Warehouse Builder
• Software Requirements – Oracle Database 10gR2 • Oracle Workflow Server 2.6.4
– Oracle Warehouse Builder 10.2.0.1.31 – Operating System (Windows XP Pro)
![Page 14: Supporting the Joint Medical Workstation Project€¦ · Akamai Summer Internship . Akimeka, LLC • IM/IT services and solutions provider . Health Care Systems Solutions Information](https://reader035.vdocuments.us/reader035/viewer/2022081617/605820105e80c422df553a3f/html5/thumbnails/14.jpg)
TARGET TABLE MAPPING
EXTERNAL TABLE FLAT
FILES
PROCESS FLOW
Oracle Warehouse Builder
![Page 15: Supporting the Joint Medical Workstation Project€¦ · Akamai Summer Internship . Akimeka, LLC • IM/IT services and solutions provider . Health Care Systems Solutions Information](https://reader035.vdocuments.us/reader035/viewer/2022081617/605820105e80c422df553a3f/html5/thumbnails/15.jpg)
![Page 16: Supporting the Joint Medical Workstation Project€¦ · Akamai Summer Internship . Akimeka, LLC • IM/IT services and solutions provider . Health Care Systems Solutions Information](https://reader035.vdocuments.us/reader035/viewer/2022081617/605820105e80c422df553a3f/html5/thumbnails/16.jpg)
Acknowledgements
• Management and Staff of Akimeka • JMEWS Team • Maui Community College • Center for Adaptive Optics • Maui Economic Development Board • National Science Foundation
– This project is supported by the National Science Foundation under cooperative agreement No. AST-9876783.
![Page 17: Supporting the Joint Medical Workstation Project€¦ · Akamai Summer Internship . Akimeka, LLC • IM/IT services and solutions provider . Health Care Systems Solutions Information](https://reader035.vdocuments.us/reader035/viewer/2022081617/605820105e80c422df553a3f/html5/thumbnails/17.jpg)
MAHALO!