Home

Visualizing Acquisition, Processing, and Network Statistics Through Database Queries

NASA’s Jet Propulsion Laboratory, Pasadena, California

Given a date range, the UAVSAR MySQL database is queried to evaluate data acquisition, processing status, and network performance, and uses the Google Charts API to dynamically return images of pie and bar charts to visualize processing and network statistics. The MySQL database is populated with relevant data that includes processing status, as well as network performance (ping and sample file downloads). Then, using the open Google Charts API, the metrics are displayed for any desired date range.

This innovation is meant to be a flexible method to display metrics based on MySQL database entries. Given a date range and various other search criteria, this software queries the UAVSAR MySQL database for data acquisition, processing, and network statistics. These are visualized in a Web browser using HTML, CSS, JavaScript, Perl, and the Google Charts API. The data acquisition and processing information are automatically populated into the database once new data is acquired or processed. The network performance information is populated by running a script that checks the network uptime and download rate.

This type of interface for processing metrics and network statistics would be valuable to any task that reports processing metrics, or any task that is partnering with, via the Internet, a data center that receives and distributes the processed data.

This work was done by Sarah L. Flores, Wayne W. Tung, Yang Zheng, and Bruce D. Chapman of Caltech for NASA’s Jet Propulsion Laboratory. For more information, contact This email address is being protected from spambots. You need JavaScript enabled to view it..

The software used in this innovation is available for commercial licensing. Please contact Dan Broderick at This email address is being protected from spambots. You need JavaScript enabled to view it.. Refer to NPO-47889.