Design and implementation of the NPOI database and website

K. Newman; A. M. Jorgensen; M. Landavazo; B. Sun; D. J. Hutter; J. T. Armstrong; David Mozurkewich; N. Elias; G. T. van Belle; H. R. Schmitt; E. K. Baines

doi:10.1117/12.2057186

24 July 2014 Design and implementation of the NPOI database and website

K. Newman, A. M. Jorgensen, M. Landavazo, B. Sun, D. J. Hutter, J. T. Armstrong, David Mozurkewich, N. Elias, G. T. van Belle, H. R. Schmitt, E. K. Baines

Author Affiliations +

Proceedings Volume 9146, Optical and Infrared Interferometry IV; 914630 (2014) https://doi.org/10.1117/12.2057186
Event: SPIE Astronomical Telescopes + Instrumentation, 2014, Montréal, Quebec, Canada

Abstract

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.

Citation Download Citation

K. Newman, A. M. Jorgensen, M. Landavazo, B. Sun, D. J. Hutter, J. T. Armstrong, David Mozurkewich, N. Elias, G. T. van Belle, H. R. Schmitt, and E. K. Baines "Design and implementation of the NPOI database and website", Proc. SPIE 9146, Optical and Infrared Interferometry IV, 914630 (24 July 2014); https://doi.org/10.1117/12.2057186

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

Members: $17.00

Non-members: $21.00 ADD TO CART

PROCEEDINGS
4 PAGES

DOWNLOAD PAPER SAVE TO MY LIBRARY

GET CITATION

RIGHTS & PERMISSIONS

Get copyright permission Get copyright permission on Copyright Marketplace

KEYWORDS

Databases

Stars

Interfaces

Binary data

Interferometers

Precision optics

Analytical research

Show All Keywords

Keywords/Phrases

Search In:

Publication Years