Sigma 4 has experience with several database packages, however, our database of choice is the relational database system 4th Dimension (4D) by 4D, Inc. The 4D system offers standalone single user, client/server multiuser as well as Internet options that allow databases to be created to address most business needs. Sigma 4 has been a 4D Development Partner for many years.
Past Databases Developed
Orion...the Hunter - a commercial system developed and sold by Sigma 4 for Law Enforement, Investigative and Security Services. This system has eighteen modules to allow the cataloging and relating of all categories of investigative information. A specially developed search feature "the Hunter" allows the user to rapidly "surf" through data to find previously unknown relations.
Enterprise Business System developed under contract for a national food production company. This client/server system stored product catalog, client and vendor information and allowed orders to be processed auto adjusting for weekly market rate changes. Users could then produce and print production schedules from these orders. The system then automatically consolidated orders for shipment based on weight and region, allowing for manual adjustments as needed. Multiple reports could be viewed online or printed and/or emailed by the system to include Detailed Client/Vendor Information, Client Order History, Order Confirmations, Shipping Manifests and Bill Of Lading Sheets.
Grant Application System developed under contract for a university consortium. The system was accessed through a website and allowed the entire application and review process to be automated. While the original manual method required a team of five people and took up to two hours to input a submitted application, this system allowed the entire process to be handled by one person.
Security Product System developed under contract in support of the US Food and Drug Administration (FDA). The system was accessed through a website and allowed pharmaceutical companies to research and keep up-to-date on changes in security technologies used to safeguard their products from counterfeiting and tampering.
GIS System developed under contact for a county in New York. This system was used in conjunction with a commercial mapping program to provide a Geographic Information System (GIS) capable of supporting a county level deployment to catalog and maintain county resources.
Mission Planning and Simulation System developed under contract for the US Navy. This system was used to enter and store mission participant parameters (i.e. times, speeds, headings, altitudes, etc.) for multi player, extended schedule Test and Evaluation exercises. Stored information could be created or modified graphically while linked to a commercial mapping program through a custom designed interactive user interface. These missions could then be simulated graphically by the system in real time or accelerated mode to review and refine each exercise before conducting the expensive live missions.
Data Conversion and Mapping System developed under contract for Jet Propulsion Laboratories (JPL) in support of the FAA Automation effort. This system was used to import frequently updated raw digital map data obtained from NOAA, extract individual air routes, restricted areas, navigation beacon locations, etc., store it in catalog form for reference and when necessary link to a commercial mapping program to draw requested information on area maps. Coordinate transformation of data from Lat/Long to Lambert Conformal was also performed within the program as required.
Risk Analysis System developed for the US Army. This system used US Census data and linked to a commercial mapping program to determine the least populated corridor for long range, multi state missile testing.
Past Database Work
Insurance Quote and Sales Support System - worked under contract for a Fortune 500 insurance company to update and enhance their client/server system. This system was used nationally by their agents and telemarketers to provide quotes for home and vehicle insurance. The system linked with several other national and state database systems to obtain driving record, vehicle accident history and demographic rate information needed to calculate policy rates.