Mission and Assets Database (MADB) Version 1.0 is an SQL database system with a Web user interface to centralize information. The database stores flight project support resource requirements, view periods, antenna information, schedule, and forecast results for use in mid-range and long-term planning of Deep Space Network (DSN) assets.

Project requirements can be entered using interval-based patterns, which allow planning analysts to capture project requirements more accurately. Project information can be stored in such a way as to allow multiple sets to be entered for various scenario studies. For example, a mission can have multiple view periods and many sets of requirements. This extends to schedules and forecasts as well. The Web component of this system allows users to modify this information and to generate graphical and tabular reports from it.

Unlike other toolsets used previously, MADB allows the user to enter requirements in the most flexible way. It also allows for many view periods for each project as well as a hierarchy system for classifying them. MADB- generated reports can span multiple projects and view periods. MADB uses an industry-standard SQL database, which enables future generic software improvement and multiple levels of access. The Web interface also can be accessed from any platform.

The RAPS TIGRAS and DRAGON tools are tightly integrated with MADB. Together they are used by the Resource Allocation Planning Service to schedule and forecast DSN assets.

This program was written by John Baldwin, Silvino Zendejas, Sandy Gutheinz, Chester Borden, and Yeou-Fang Wang of Caltech for NASA’s Jet Propulsion Laboratory.

This software is available for commercial licensing. Please contact Karina Edmonds of the California Institute of Technology at (626) 395-2322. Refer to NPO-44714.

NASA Tech Briefs Magazine

This article first appeared in the February, 2009 issue of NASA Tech Briefs Magazine.

Read more articles from this issue here.

Read more articles from the archives here.