24 July 2014 Design and implementation of the NPOI database and website
Author Affiliations +
The Navy Precision Optical Interferometer (NPOI) has been recording astronomical observations for nearly two decades, at this point with hundreds of thousands of individual observations recorded to date for a total data volume of many terabytes. To make maximum use of the NPOI data it is necessary to organize them in an easily searchable manner and be able to extract essential diagnostic information from the data to allow users to quickly gauge data quality and suitability for a specific science investigation. This sets the motivation for creating a comprehensive database of observation metadata as well as, at least, reduced data products. The NPOI database is implemented in MySQL using standard database tools and interfaces. The use of standard database tools allows us to focus on top-level database and interface implementation and take advantage of standard features such as backup, remote access, mirroring, and complex queries which would otherwise be time-consuming to implement. A website was created in order to give scientists a user friendly interface for searching the database. It allows the user to select various metadata to search for and also allows them to decide how and what results are displayed. This streamlines the searches, making it easier and quicker for scientists to find the information they are looking for. The website has multiple browser and device support. In this paper we present the design of the NPOI database and website, and give examples of its use.
© (2014) COPYRIGHT Society of Photo-Optical Instrumentation Engineers (SPIE). Downloading of the abstract is permitted for personal use only.
K. Newman, K. Newman, A. M. Jorgensen, A. M. Jorgensen, M. Landavazo, M. Landavazo, B. Sun, B. Sun, D. J. Hutter, D. J. Hutter, J. T. Armstrong, J. T. Armstrong, David Mozurkewich, David Mozurkewich, N. Elias, N. Elias, G. T. van Belle, G. T. van Belle, H. R. Schmitt, H. R. Schmitt, E. K. Baines, E. K. Baines, "Design and implementation of the NPOI database and website", Proc. SPIE 9146, Optical and Infrared Interferometry IV, 914630 (24 July 2014); doi: 10.1117/12.2057186; https://doi.org/10.1117/12.2057186


Navy precision optical interferometer database
Proceedings of SPIE (September 11 2012)
NOAO observing proposal processing system
Proceedings of SPIE (January 01 2002)
CADOR and TAROT: a virtual observatory
Proceedings of SPIE (July 13 2008)

Back to Top