The CrimeStar Corporation located in San Jose, California specializes in law enforcement and public safety technology solutions. Established in 1999 they provide communication and information management systems to agencies around the United States. Their customers include all divisions of law enforcement and public safety from the Private Investigator to Federal Law Enforcement Agencies. Alec Gagne is the Owner and Lead Developer for the CrimeStar Corporation. In 1997, he created CrimeStar’s Records Management System (RMS), which was the first in a series of high quality, easy to use, affordable software solutions. Alec was the person responsible for introducing Stonefield Query as the report writer for CrimeStar products.
CrimeStar’s RMS is the flagship product for the company and there are two editions of the software. The Enterprise edition is for medium to large agencies with several facilities that store large amounts of data. The Professional edition is for small to medium size agencies with a single facility that store a moderate amount of data.
The CrimeStar Problem
Since its creation in 1997, CrimeStar RMS has undergone numerous revisions to reflect changing laws and advancements in technology. The original program, now the Professional Edition, was developed on a LAN architecture in Microsoft Visual FoxPro® and featured Query Maker as the report writer. When large agencies with multiple user groups and several facilities began to adopt CrimeStar’s RMS, Alec saw the need to take a client-server approach and the program underwent its first major revision.
The Enterprise Edition incorporated Microsoft SQL Server®, and provided clients with a more reliable system to run on a WAN architecture. They encountered a major developmental issue when they tested the beta version of the new Crime-Star RMS. Query Maker could report against Visual FoxPro but was incompatible with the new SQL Server. They now faced a dilemma on how to deal with the ad-hoc query reports. As they searched for a solution, they encountered another major issue.
The program uses codified fields and most third party report writers are incapable of linking codified tables. CrimeStar delayed the release of the new Enterprise Edition because of the limited ad-hoc query capabilities of Query Maker. Alec needed a data mining and reporting solution with ad-hoc query capabilities that could link codified fields and work against Visual FoxPro and SQL Server.
Alec signed an Original Equipment Manufacturers agreement with Stonefield. Stonefield Query is now the official reporting tool for all CrimeStar software and is packaged as a private labeled solution called CrimeStar RMS Report Creator. “Stonefield Query is an affordable solution that meets my standards of quality ease of use and efficiency,” said Alec.
CrimeStar RMS featuring Stonefield Query (stonefieldquery.com) is the technology of choice for today’s progressive law enforcement officials and is the standard by which all other law enforcement software is measured. “If you are looking for an affordable easy-to-use ad-hoc query tool that expands the ability of your software and gives your end-users the ability to generate their own reports,” said Alec, “you need to invest in Stonefield Query. It will certainly improve the profitability of your business.”
A free 30 day trial download is available at the Stonefield Software Inc.
For more information on Stonefield Query Software or to receive a review copy of Stonefield Query Software visit the website.
To arrange an interview with partners Doug Hennig or Mickey Kupchyk, please call 1-800-563-1119