EPICS JDS Judicial Database Systems - PowerPoint PPT Presentation

1 / 22
About This Presentation
Title:

EPICS JDS Judicial Database Systems

Description:

JavaJDS is a database driven stand alone software application ... C# Client instead of Java (To facilitate creating familar and user-friendly windows forms) ... – PowerPoint PPT presentation

Number of Views:22
Avg rating:3.0/5.0
Slides: 23
Provided by: benco5
Category:

less

Transcript and Presenter's Notes

Title: 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
Write a Comment
User Comments (0)
About PowerShow.com