Intro Presentation Fall 2004

1
Intro PresentationFall 2004

• Project Partners
• Tippecanoe County Probation Department (Kipp
  Scott)
• Jasper County Probation Department (Michael Sinks)

2
What Well Be Discussing

• What is Judicial Database Systems (JDS)?
• JDS Projects
• Old Interface ( Retiring )
• Jasper Interface
• Visual Basic .Net ( Front-End - JDS.2GO )
• Reporting
• ASP ( Web Interface )
• Mobility
• On the JDS Horizon
• JTAC
• Entrepreneurship ( I2P Competition )
• Commercialization?
• Questions Answers

3
JDS Spring 2004 Team Organization
4
JDS Spring 2004 Timeline
5
JDS Evolution
Tippecanoe County Access Front-End (v2.5)
Jasper County Access Front-End
DOS-Based QA
Web Interface
JDS.2GO VB.NET Front-End
6
Access Tippecanoe Front-End

• Current software being used by Tippecanoe County
  Adult Probation Office
• Being used to track 8000 clients
• Approximately 15 officers and staff use every
  day
• Judicial Database System v 2.5 built with
  Microsoft Access
• Replaced by JDS.2GO

7
Access Jasper Front-End

• The Jasper County Database needs an Access
  front-end similar to Tippecanoes.
• Major Differences
• 3 sets of data -- Adult, Juvenile and Intake
• Search Board
• Still under development

ADULT
INTAKE
Queries
JUVENILE
ACTIVE
CLOSED
TRANSFER
ACTIVE
CLOSED
ACTIVE
TRANSFER
8
Access Jasper Front-End

• Sent updated version of the front-end to Jasper,
  which incorporates the latest bug fixes, and
  already received feedbacks
• Latest status - Jasper county has expressed
  interest in JDS.2GO, awaiting full deployment to
  Tippecanoe

9
Access Common Form Layout (Tipp Jasper)
10
Access Probation Data Tabs

• All tabs, except Probation Terms and Programs
  tab, exist in both Tippecanoe and Jasper.
• -The Probation Terms and Programs tab only exists
  in Tippecanoe

11
Access Search Board Difference
Tippecanoe
Jasper
12
Access Jaspers Intake Database
13
VB.NET JDS.2GO

• Judicial Database Systems 2nd Generation Objects
• Next generation VB.NET custom front-end for
  Tippecanoe County.
• Provides a more scalable and robust solution for
  current counties as well as future project
  partners.
• Project partner is in possession of final deploy
  version. JDS.2GO v 1.0.

14
VB.NET JDS.2GO - Feature List

• Main functionality (Search, Browse, Save)
• MDI (Multiple-Document Interface)
• ClientTypes
• New Connection Dialog
• Data-Scrubbing and On-the-fly Data-Conversion
• Interpreted Searching
• Required Fields
• Most Recent Record First
• Timers to determine timing bottlenecks
• Complex Report Generation using Crystal Reports
• Keyboard Hotkeys
• Dynamic Value Generation
• Casenote Multiview
• Increased Usability of Navigation
• BLOB Image Drag and Drop
• Polymorphic Class Hierarchy
• Web Interface allow clients to submit
  information over the internet
• Mobile Interface allows probationers to use
  database on laptop

15
VB.NET JDS.2GO - MDI Interface
16
VB.NET JDS.2GO - ClientTypes
Adult
Juvenile
17
VB.NET JDS.2GO - Data Scrubbing
18
VB.NET JDS.2GO - Connection Dialog
19
VB.NET Report Generation

• Crystal Reports gives very flexible connectivity
  and selection criteria to generate quality
  reports easily and quickly
• Provides built in exporting functions to excel,
  PDF, rich text, and Microsoft Word documents
• Provides drill-down capability, so general
  accounting reports can be drilled-down into to
  see underlying details of the data.
• Easy integration into VB.NET.

20
VB.NET Reports Tab
21
JDS.2GO Statistics Report
22
ASP Web Development

• The web-based client interface allows clients to
  submit information over the internet.
• This information has previously been submitted
  through conventional mail or in-person visits.
• A new web design developed for Tippecanoe County
  Probation Department
• Functionality was specifically requested by
  project partner

23
ASP Security Model Design
24
ASP Web Interface
25
ASP Web Design
26
ASP Web Interface Forms
27
ASP Officer Interface
28
Mobile Data Access Overview
JDS.2GO will implement a mobile interface where
officers will be able to take a modifiable
version, created by SQLs replication services
downloaded to the mobile device, of the database
on site via a Tablet PC or PDA.
Replicated Data Transfer
29
Mobile Data Access Overview

• Early stage of development of JDSMobile, a
  prototype of the scaled-down version of the
  database, to be used on Pocket PC platform.
• Technology used Microsofts .Net Compact
  Framework and SQLCE 2.0 database engine
• Profile tab is partially done with a basic
  search by last name function

30
Business Intellectual Property

• Categorical Classes
• 707 Data Processing Database and File
  Management or Data Structures
• 715 Data Processing Presentation Processing of
  a Document
• 717 Data Processing Software Development,
  Installation, and Management

31
Business Intellectual Property

• Similar Patents
• 6,591,272 Method and apparatus to make and
  transmit objects from a database on a server
  computer to a client computer
• 6,636,529 Network access method and network
  access server therefor
• 6,640,303 System and method for encryption using
  transparent keys
• 6,628,307 User interface for internet
  application
• 6,085,084 Automated creation of a list of
  disallowed network points for use in connection
  blocking

32
Business JTAC Partnership

• Judicial Technology and Automation Committee
  (JTAC)
• JTAC, based in Indianapolis, is currently
  developing a statewide initiative to connect all
  government judicial agencies
• Working with Computer Associates
• JDS monitors JTAC progress frequently
• JTAC has indicated no successful test launches as
  of yet

33
Business Entrepreneurship

• Problem project partner left without support for
  long periods of time (summer, winter break)
• 2003 entered International Idea-2-Product
  competition in Austin, Texas
• Won First Place Prize Award at first annual EPICS
  I2P Entrepreneurship Competition
• JDS is putting portion of winnings toward
  business development

34
Business Commercialization?

• Effort towards making JDS a full-time business to
  accommodate project partners needs
• Working with Professor Ed Coyle and Krannerts
  MBA program to develop business model
• Two venture capitalists have expressed
  interesting in licensing or purchasing of rights
  to JDS.2GO.
• JDS continues to explore possibilities of
  commercialization.

35
Conclusion

• Thoughts
• Questions