The associative database technology which is now Relavance was a new technology we successfully applied to a long-standing problem on two Navy projects in the early 2000s. The two related projects, ReMAD and Smart ACHF, involved automation and modernization of systems supporting complex calculations and processes being done using 1970s mainframe technology. The challenge was to assimilate and track a large number of data changes across a data warehouse, sort through 50+ million records, and compute spare/repair part requirements for Navy ships – up to and including aircraft carriers. The challenge was complicated by different configurations of each ship based on incremental upgrades and changing versions of subsystems/parts, complex business logistics rules, and the sheer volume of data (billions of database-equivalent records).
A process that previously took more than a month of manual and semi-automated effort, was reduced to less than 15 minutes using the associative technology now at the core of Relavance. The long, labor intensive exercise became an automated, near real-time computation process – thanks to the power of associative database technology.