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.



This Brief includes a Technical Support Package (TSP).
Document cover
Mission and Assets Database

(reference NPO-44714) is currently available for download from the TSP library.

Don't have an account?



Magazine cover
NASA Tech Briefs Magazine

This article first appeared in the February, 2009 issue of NASA Tech Briefs Magazine (Vol. 33 No. 2).

Read more articles from this issue here.

Read more articles from the archives here.


Overview

The document outlines the Technical Support Package for NASA's Mission and Assets Database (MADB), designated as NPO-44714. This software system is designed to centralize and manage information related to flight project support requirements, view periods, antenna information, and scheduling and forecasting data for the Deep Space Network (DSN). The MADB serves as a crucial tool for mid-range and long-term planning of DSN assets.

MADB features a robust SQL database and a web user interface that allows planning analysts to enter project requirements using interval-based patterns. This flexibility enables users to capture complex project needs more accurately, accommodating multiple view periods and sets of requirements for each mission. The system's architecture supports a hierarchy for classifying view periods, enhancing the organization of project data.

One of the significant improvements of MADB over previous systems, such as the FASTER toolset, is its ability to centralize all DSN planning information into a common standard database. Unlike FASTER, which only allows simple week-based requirements and a single view period per project, MADB offers a more versatile approach. It supports multiple view periods and a customizable multi-mission report generator, allowing users to generate a wide variety of reports that span different projects and timeframes.

The web interface of MADB is platform-independent, enabling users to access the system from any device and interact with the database to generate reports. This accessibility is a significant advantage over earlier systems that were not as user-friendly or flexible.

The document also highlights the integration of MADB with other tools, such as RAPS, TIGRAS, and DRAGON, which collectively assist the Resource Allocation Planning Service in scheduling and forecasting DSN assets. This integration further enhances the capabilities of MADB, making it a comprehensive solution for managing aerospace-related developments.

In summary, the Mission and Assets Database represents a significant advancement in the planning and management of NASA's DSN resources, providing a centralized, flexible, and user-friendly platform for project data management. For further inquiries, the document provides contact information for the Innovative Technology Assets Management team at JPL.