EPICS JDS Judicial Database Systems

1
EPICS JDS Judicial Database Systems

• 2006 Final Presentation

2
JavaJDS

• JavaJDS is a database driven stand alone software
  application that is accessible from any internet
  capable machine.
• JavaJDS tracks person related information for
  county offices.

3
JavaJDS Technology
Web/Database Server Machine
Client Machine
ADO.NET
Microsoft ASP.NET
C Web Service
Microsoft Internet Information Server (IIS)
Port 443
SQL
SOAP HTTPS
SQL Server Database
Axis Client
JavaJDS GUI Client
Port 1433
Firewall
4
JavaJDS Features

• JavaJDS Data Anywhere
• Users can access their data securely through a
  remote location
• Security
• Web access encrypted via SSL (Secure Socket
  Layers)
• Ensures database information will remain where it
  belongs, in the hands of the proper users.
• Cross Platform
• Written in Java, the client application can be
  run on Windows, Mac or Linux platforms.

5
JavaJDS Project

• Current Status
• Prototype Delivery and Feedback Phase
• GUI Status
• Most tabs implemented and data populated into the
  fields when a search is ran.
• Web Service Status
• Operational web service that retrieves data from
  the database and passes it on to the client.
• SSL encryption in the works.

6
Client/Server SOAP and Web Services

• What this means
• Secure and effective way for an application and
  server to send and receive data over HTTP with
  SSL.
• Advantages
• Secure
• Doesnt use traditional method of accessing data
  from database.
• Implementation of SSL encrypts data over HTTP
  traffic.
• HTTP
• Sends data over HTTP which is used for common
  internet traffic.

7
Client/Server SOAP and Web Services

• Windows Server 2003
• Currently running IIS 6.0 with .NET Framework 1.1
• A standard read only web service written in C
• Accepts a query from JavaJDS client.
• Opens a connection to SQL Server 2000.
• Pass the query to be ran on SQL Server 2000.
• Retrieves results from query execution.
• Passes results in string format to be processed
  and displayed in JavaJDS.

8
Client/Server SOAP and Web Services

• Windows Server 2003
• Created temp certificate for SSL encryption
• Can connect to web server securely, however
  having problems with JavaJDS using SSL
  certificate.
• Windows Server 2000
• Currently running SQL Server 2000.
• SQL Server 2000 hosts the Adult_Probation
  database that all queries are ran against.

9
Future Plans of Web Services

• Integration of SSL with JavaJDS.
• Adding methods to web service that will enable
  write functions to the database.

10
Structure of the Interface

• JavaJDS Main Screen
• Buttons for executing queries, navigation
• Tabs
• Display specific information according to header
• Fields
• Populated with database information
• Tab Navigation Buttons
• Navigation through multiple drug screens, cases,
  etc.

11
Graphical User Interface
12
Flow of Data Within GUI

• Fields are filled out on Profile Tab by user
• Execute Query sends a query to SQL Database
• SELECT MainID FROM tblProfile WHERE
• Returns a list of main IDs that match the users
  search
• A second SQL query gathers information for each
  tab
• SELECT from tblProfile WHERE MainID id
• Fields are populated with the returned data
• Navigation buttons on main screen move through
  the mainID list

13
Flow of Data Within GUI

• Certain tabs have a third SQL query
• SELECT DrugScreenID from tblDrugScreen WHERE
  MainIDDrugScreen id
• Gathers a list of multiple entries for a single
  tab
• Specific buttons on each tab allow movement
  through multiple entries
• SELECT from tblDrugScreen WHERE
  MainIDDrugScreen id " and " DrugScreenID
  drugid
• Each time a button is pressed JavaJDS makes a
  call to the web service/SQL database

14
Java Web Start

• http//jdsserver.ecn.purdue.edu/webstart/JavaJDS
  .jnlp
• Most up to date version of JavaJDS software is
  downloaded to the client machine
• Can be integrated into Windows desktop
• Temporary location right now, more secure
  solution is necessary

15
Future Plans of GUI

• Complete tabs
• Case Notes, Reports, and Receipts
• Allow searching through any tab
• More aesthetic interface
• Change structure to resemble the look of the
  older database software

16
Home with Hope HWH

• Final Presentation
• Spring 2006

17
HWH

• Home With Hope
• Who - A halfway house for individuals recovering
  from substance abuse.
• Need Supplement and eventually replace the use
  of paperwork to track clients with electronic
  means.
• Solution Set up a database to track clients and
  develop a front-end application to work with it.

18
Our Solution

• Microsoft Access Database (mdb) stand-alone
  application was in early development stages last
  semester.
• This semester, it was decided (with project
  partner approval) that it would be best to
  abandon this model and instead follow a path
  similar to JavaJDS.
• Advantages
• Flexibility and extensibility
• Ability to integrate sub-teams
• More consistent with members knowledge.

19
Current Status

• Main Program (HWHDB)
• Main (container) form with a tab strip, menu,
  and navigation buttons for moving through records
• Fields in Profile, Photo, Legal and Case Notes
  tabs
• Framework in place for handling the necessary
  datasets
• Web Service Test Client (HWHWSClient)
• Able to send test queries to SQL database on
  jdsserver

20
Technologies Used

• Virtually identical to JavaJDS (To further
  parallel development)
• Differences
• C Client instead of Java (To facilitate
  creating familar and user-friendly windows forms)
• For simplicity, there are no plans for SSL
  support to be included in initial release. (The
  web service has been developed anticipating
  future support, but the initial version will most
  likely be restricted to an intranet or to a local
  machine)

21
Current Application Rough Database Diagram
22
Future

• Design SQL Server database tailored to HWHs
  needs
• Process results after querying database
• Ability to create new records and update the
  database
• Ability to connect to a local database rather
  than through the web service
• Finish up tabs Accounts and Reports
• Install alpha version for project partner testing