Case Studies

Strengthening Database Performance

Customer Challenges

Our Defense customer is responsible for the collection and secure management of information on detainees at DoD operated facilities. They required specific application development and maintenance support to enhance the functionality of their databases and prevent the loss of mission-critical information and intelligence.

AI Solution Features

AI’s software engineers and database administrators worked with USSOUTHCOM software development teams to overhaul the application architecture, design, code base, and database structure.  We supported the USSOUTHCOM team by modifying, normalizing, recreating and developing new database code and application architecture to work with many iterations of coding for new application releases. We assisted in the restoration of inoperative databases and successfully implemented their first ever Oracle-based enterprise logging database. Our comprehensive understanding of the innerworkings of the coding and workflow in the customer’s application allowed our team to reverse engineer deteriorating database tables and identify relevant orphaned data. In addition to our application and database development support, our engineers provided training to include creating  a 165 page custom training manual for the entire user base, including administrators, analysts and management personnel. We continually adjusted the training curriculum based on end user experience feedback and student critique.

Benefits to the Customer Mission

  • AI’s application and database development support significantly enhanced intelligence collection and detainee case management capability. Key benefits included:
  • Enhanced software functionality and automation
  • Hardened software security architecture minimizing data loss and unauthorized access
  • Enhanced compliance with Presidential Preservation Orders, Federal Mandates, and security standards such as DISTA STIGs, NIST, and RMF
  • Increased efficiency of information and intelligence querying and case management



An Acacia Group Company