Distributed database schema

John Burke; Jon Ericson; Ardvas Mousessian

doi:10.1117/12.734802

27 September 2007 Distributed database schema

John Burke, Jon Ericson, Ardvas Mousessian

Proceedings Volume 6677, Earth Observing Systems XII; 667713 (2007) https://doi.org/10.1117/12.734802
Event: Optical Engineering + Applications, 2007, San Diego, California, United States

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 15^th, 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.

Citation Download Citation

John Burke, Jon Ericson, and Ardvas Mousessian "Distributed database schema", Proc. SPIE 6677, Earth Observing Systems XII, 667713 (27 September 2007); https://doi.org/10.1117/12.734802

ACCESS THE FULL ARTICLE

INSTITUTIONAL
Select your institution to access the SPIE Digital Library.

SELECT YOUR INSTITUTION

PERSONAL
Sign in with your SPIE account to access your personal subscriptions or to use specific features such as save to my library, sign up for alerts, save searches, etc.

PERSONAL SIGN IN

No SPIE Account? Create one

PURCHASE THIS CONTENT

SUBSCRIBE TO DIGITAL LIBRARY

50 downloads per 1-year subscription

Members: $195

Non-members: $335 ADD TO CART

25 downloads per 1 - year subscription

Members: $145

Non-members: $250 ADD TO CART

PURCHASE SINGLE ARTICLE

Includes PDF, HTML & Video, when available