Document and Track Messages Easier

Compatible with both Oracle and Java, the Archive & Retrieval system allows users to store, log, access and display message traffic processed by the OpenFox™ Message Switch. Our many years of experience developing systems for law enforcement have helped us identify and implement capabilities useful to the law enforcement environment.

The Archive and Retrieval System includes the following capabilities:

Fully automated Extract and Store OpenFox™ Information Broker Message Switch traffic at regular intervals; the recommended interval is daily.

An administration utility that assists in the archiving and restoration of extracted data sets to and from tape for extended management of accumulated data.

Powerful and flexible access/display using Oracle Forms and Reports and Java that allows the user to search and select logged data using index values and strings. The retrieved message data can be displayed, printed, or selected for forwarding to any destination known to the Message Switch.

 

 

Oracle

The system uses fast and easy Oracle Relational database management tools in addition to UNIX/AIX™ or Windows NT® and client functionality.

Query Transaction
The query in the example below illustrates an Oracle Forms in which a user has entered the date “3/2/2000” and has provided the search criteria to search for all messages sent or received in the first minute after midnight. When the user clicks on the “run query” button, a message displays informing the user that the query is running. While the graphical user interface (GUI) features comfortable colors and plain easy to use buttons and text boxes for data entry, the resulting returned data set will be familiar and easy to understand. After the user finishes entering values in the first form and presses the “execute query” button, a second form appears with the results of the query.

 

Summary Screen
The Summary Screen shows the Oracle Forms user messages found during the query, allowing the user to quickly scan through the returned messages. The results of the query are displayed on the following Oracle Forms screen.

 

 

Another feature of the Archive & Retrieval System is the ability to scan the text of messages on the summary screen. This feature displays a pop-up window displaying the text of the selected message. The following Oracle Forms screen illustrates this feature.

 

 

Printing Summary
The Archive & Retrieval System gives the user the ability to print a report of selected items from the Summary screen. The user can print the report on the screen or a printer. The following Oracle Forms screens illustrate this function.

 

1st Printing Summary

 

2nd Printing Summary

 

Java

The system also uses fast and easy Java database management tools. Query Transaction
The query in the example below illustrates the Java query transaction.

 

 

Summary Screen
The Summary Screen shows the Java query results.

 

Summary Screen

 

Pop-Up Message Window
The following screen illustrates the pop-up message window in Java.

 

 

Printing Summary
The following screens illustrate the Java printing summary function.

 

1st Printing Summary