Streamline data management with SQL database
How Aciron does it
An American global aerospace, defense, and security company needed consulting regarding data management. They needed to collect large amount of data sets into one place in order to analyze it. The key aspects of the application were to enable the data store to ingest large files and enable them for quick retrieval. Above all, security was a high priority.
The energy division we assisted is part of a leading global security & aerospace defense contractor. They were in the process of developing and testing battery prototypes. The tests conducted on the prototypes generated a massive amount of data. This data needed to be paired with metadata from the prototype apparatus. While inefficient, the company was using multiple solutions to store and analyze data.
Aciron began this project with a Phase 0 dedicated to fleshing out the requirements. This phase allowed the client and the Aciron team to fully understand the scope. In addition, it prompted the technical specifications. As a part of Phase 0, Aciron developed a clickable prototype. This allowed the client to understand the proposed layout. The prototype was developed iteratively. The client gave direct feedback prior to any development. The prototype served as a clear roadmap and was invaluable to maintaining a timeline. Storyboards, process flow diagrams, and business rules documentation were created. This procedure ensured that once the system was developed, it would function as defined.
After several rounds of collaborative meetings, the prototype was approved. Therefore, the project moved into Phase 1. The first three portions of the application were developed according to the defined requirements defined. Once development and internal testing were complete, the application was deployed to a test environment. Then, the client performed user acceptance testing ("UAT"). During UAT, the client identified necessary tweaks and modifications. The issues identified during UAT were fixed and implemented. Then the application was deployed.
Aciron developed a web-based application with a SQL server back-end database. It allowed the client to track their battery component inventory, build batteries, and set up tests. Additionally, it stored, processed, and managed the resulting test data. The database paired the test data with the apparatus metadata. Users analyze this data via a sophisticated search and reporting functionality. The data from all of the battery prototypes aggregates in one location. It greatly improved the team's efficiency. The system centered around a robust security framework. This secured the highest level of protection for the sensitive data. The user-friendly interface of the front-end application let users to easily perform advanced functions. Users could interact with the data without writing highly technical queries. Users can simply enter the criteria and the system displays results in a user-friendly format.
The custom test data application helped the client better organize and standardize their data management. The data is more accessible to users company-wide. Therefore, it improved collaboration and sharing of knowledge across departments. The system is currently in Phase 2 of development. It includes the test data processing components.