Data Mining

Finding buried enterprise data

Business Problem

Find temporary records for update processing

Booking

When criminals are booked, the arrest information is sent to the Criminal History system at the California Department of Justice (CalDOJ).

Court

When the case is concluded in court, a disposition (guilty, not guilty, etc.) is sent to CalDOJ.

Matching the data

The criminal's identification information on the disposition is used to match the arrest information. Sometimes the disposition information cannot be matched to the arrest information. The reasons vary from criminals lying about their identification information, to timing issues related to the receipt of the arrest and disposition data.

Temporary records

When a match cannot be made, a temporary record is created to hold and display the updated information.

Periodic attempt to re-match

Periodic research to see if the original data had subsequently been entered was a tedious and time-consuming task -- an automated solution was needed.

Solution

Automated Data Mining

CloverLeaf developed a solution that periodically attempts to match up the temporary records.

CLETS Queries

A CLETS (California Law Enforcement Telecommunications System) query is performed for each temporary record. The identification information for the subject is parsed and used to submit another query. The results of the second query are used to see if a match can be found.

Updates

When a match is found, an update is sent to consolidate the temporary record with the primary record. The temporary record is then deleted.

CloverLeaf Added Value

Parsing technology developed on a previous CloverLeaf engagement was leveraged to parse the CLETS responses. This reduced the length of the project significantly.

Benefits

  • Temporary records are consolidated automatically.
  • Staff that previously performed the manual research were freed up to perform more important work.

Project Name

Disposition Research Processor

Project Scope

Software Development

  • Requirements Gathering
  • Analysis
  • Solutions Architecture
  • Design
  • Build
  • Unit Testing
  • Deployment
  • Maintenance

Systems Integration

  • Cross-Platform

Technologies

  • Java
  • JSP
  • Oracle
  • PL/SQL
  • Unix

CloverLeaf's CLETS Gateway is used for Criminal History queries and updates.