On the national level, the National Crime Information Center (NCIC) maintains a central database of stolen articles and vehicles and wanted and missing persons. However, on a state-by-state basis, each state has unique information requirements and has no control over the central information; they may need to enhance NCIC data. Mirroring the NCIC database, OpenFox® Hotfile allows regional, state, county, and municipal agencies to customize NCIC files while accessing, sharing and reporting that information efficiently.
Hotfile Application [HFA]
The Hotfile application helps manage and control intrastate and NCIC records for efficient record sharing. The application is implemented in SQLSERVER or Oracle RDBMS technology and is fully integrated with the OpenFox® Message Switch.
The OpenFox® HotFiles system is currently installed in sixteen (16) State systems. The HotFiles system is generally composed of both State specific files as well as NCIC mirror files. State specific files are usually files that are not supported by NCIC, such as in-state warrants, towed vehicles, etc.
The HotFiles system can be implemented in either SQLSERVER or the Oracle RDBMS, providing a choice of environments. Much like the OpenFox® Information Broker Message Switching system, the HotFiles system utilizes configurations rather than hard coding to define transaction processing and response creation.
The HotFiles system is fully integrated with the OpenFox® Information Broker Message Switching system and utilizes XML message formats. The HotFiles system supports all law enforcement transactions received from the network as well as direct access to the database. In addition the HotFiles system provides maintenance and reporting capabilities for the system administrators.
The Hotfile application provides support for the following important capabilities:
HotFile Utility Package
Until now, OpenFox® users accessed the Hotfile database objects through OpenFox® Information Broker Message Switch transactions. The OpenFox® Hotfile Utility provides a simple tool for the Hotfile administrator to perform normal maintenance and administration functions on typical Hotfile implementations.
The OpenFox® Hotfile Utility Package has been developed using Oracle Forms and Reports, which allows flexible expansion and addition of individual types of Hotfile implementations.
The OpenFox® Hotfile Utility Package provides functions such as:
Fox logo screen
This feature allows the system administrator to run the normal message transactions against the base tables and supplemental tables. It provides access to supplemental tables and look-up tables that are related to the certain row occurrence of the base table. It also allows a simple search by key identifier(s).
Master Search Capability
The OpenFox® Hotfile Utility Package provides the capability to search a certain identifier, or some combination of identifiers, against Hotfile base tables, supplemental tables and look-up tables. This function will allow the user to jump between possible search hits and the base records. Standard Oracle® Form runtime environment will also allow users to print out possible search hits and count total hits.
Check Database Space Utilization
This feature of the OpenFox® Hotfile Utility Package allows users to monitor the information of free space for the Oracle database instance.
Check Database Space