SQL-RAMS (where "SQL" signifies Structured Query Language and "RAMS" signifies Rocketdyne Automated Management System) is a successor to the legacy version of RAMS — a computer program used to manage all work, nonconformance, corrective action, and configuration management on rocket engines and ground support equipment at Stennis Space Center. The legacy version resided in the FileMaker Pro software system and was constructed in modules that could act as standalone programs.

There was little or no integration among modules. Because of limitations on file management capabilities in FileMaker Pro, and because of difficulty of integration of FileMaker Pro with other software systems for exchange of data using such industry standards as SQL, the legacy version of RAMS proved to be limited, and working to circumvent its limitations too time-consuming. In contrast, SQL-RAMS is an integrated SQL-server-based program that supports all data-exchange software industry standards. Whereas in the legacy version, it was necessary to access individual modules to gain insight into a particular work-status document, SQL-RAMS provides access through a single-screen presentation of core modules. In addition, SQL-RAMS enables rapid and efficient filtering of displayed statuses by predefined categories and test numbers. SQL-RAMS is rich in functionality and encompasses significant improvements over the legacy system. It provides users the ability to perform many tasks, which in the past required administrator intervention. Additionally, many of the design limitations have been corrected, allowing for a robust application that is user centric.

This program was written by Victor O. Alfaro and Nancy J. Casey of The Boeing Co. for Stennis Space Center.

Inquiries concerning rights for the commercial use of this invention should be addressed to

the Intellectual Property Manager
Stennis Space Center
(228) 688-1929.

Refer to SSC-00207.

NASA Tech Briefs Magazine

This article first appeared in the November, 2005 issue of NASA Tech Briefs Magazine.

Read more articles from the archives here.