Share Email Print

Proceedings Paper

Distributed database schema
Author(s): John Burke; Jon Ericson; Ardvas Mousessian
Format Member Price Non-Member Price
PDF $17.00 $21.00

Paper Abstract

The Science Data Processing System (SDPS) application, described herein as an example, has had a long development cycle. The SDPS application incorporates IDL, C++, and Perl programming languages, with significant use of an Oracle Relational Database Management System (RDBMS). The time involved from initial design, 1996, to operational deployment, on July 15th, 2004, with the launch of the Aura spacecraft, spans several releases of the Oracle RDBMS. New database versions usher in new features and performance enhancements, sometimes requiring modifications to custom application code to take full advantage of improvements in technology. For a project with an aggressive release schedule, major redesigns of the custom code could jeopardize the successful completion of mission criteria. Over time, higher throughput requirements and hardware improvements in the application computing infrastructure revealed database performance bottlenecks due to increased scanning frequency of ever-growing tables and indexes. The Distributed Schema (DS) database redesign successfully addressed the database scalability and performance limitations, with only minor SIPS application changes and no changes to the TES SDPS application.

Paper Details

Date Published: 27 September 2007
PDF: 10 pages
Proc. SPIE 6677, Earth Observing Systems XII, 667713 (27 September 2007); doi: 10.1117/12.734802
Show Author Affiliations
John Burke, Raytheon Intelligence and Information Systems (United States)
Jon Ericson, Raytheon Intelligence and Information Systems (United States)
Ardvas Mousessian, Raytheon Intelligence and Information Systems (United States)

Published in SPIE Proceedings Vol. 6677:
Earth Observing Systems XII
James J. Butler; Jack Xiong, Editor(s)

© SPIE. Terms of Use
Back to Top