| |
 |
| Paper: |
The SuperMacho+SuperNova Survey Database Design: Supporting Time Domain Analysis of GB to TB Astronomical Datasets |
| Volume: |
295, Astronomical Data Analysis Software and Systems XII |
| Page: |
299 |
| Authors: |
Hiriart, R.; Smith, C.; Becker, A.; Stubbs, C.; Rest, A.; Miknaitis, G.; Prochter, G. |
| Abstract: |
Two large scale survey projects to discover transient events have recently been initiated at NOAO's Cerro Tololo Inter-American Observatory (CTIO) in Chile. The SuperMacho project seeks to detect and follow microlensing events toward the Large Magellanic Cloud (LMC) and the ESSENCE Supernova project seeks to detect and follow intermediate to high-redshift supernovae. Together, these projects (SM+SN) present challenging data management needs both due to the large size of the datasets and the kind of analysis to be performed on the data. The database requirements of the SM+SN projects can be divided into three broad categories: support for the survey operation, storage and analysis of the data that comes from the image reduction and transient detection pipeline, and communication of the results to the project users and the astronomical community. Current relational database technologies are being applied to address these requirements. The open source database PostgreSQL has been selected for the implementation of the system. This work presents the design of the database, along with some performance considerations that are necessary for the fast retrieval of information, thus allowing the development of data mining applications to take full advantage of the database. |
|
|
|
|
|
