Application of SQL database to the control system of MOIRCS

Tomohiro Yoshikawa, Koji Omata, Masahiro Konishi, Takashi Ichikawa, Ruyji Suzuki, Chihiro Tokoku, Yuka Katsuno Uchimoto, Tetsuo Nishimura

Research output: Chapter in Book/Report/Conference proceedingConference contribution

5 Citations (Scopus)


MOIRCS (Multi-Object Infrared Camera and Spectrograph) is a new instrument for the Subaru telescope. In order to perform observations of near-infrared imaging and spectroscopy with cold slit mask, MOIRCS contains many device components, which are distributed on an Ethernet LAN. Two PCs wired to the focal plane array electronics operate two HAWAII2 detectors, respectively, and other two PCs are used for integrated control and quick data reduction, respectively. Though most of the devices (e.g., filter and grism turrets, slit exchange mechanism for spectroscopy) are controlled via RS232C interface, they are accessible from TCP/IP connection using TCP/IP to RS232C converters. Moreover, other devices are also connected to the Ethernet LAN. This network distributed structure provides flexibility of hardware configuration. We have constructed an integrated control system for such network distributed hardwares, named T-LECS (Tohoku University - Layered Electronic Control System). T-LECS has also network distributed software design, applying TCP/IP socket communication to interprocess communication. In order to help the communication between the device interfaces and the user interfaces, we defined three layers in T-LECS; an external layer for user interface applications, an internal layer for device interface applications, and a communication layer, which connects two layers above. In the communication layer, we store the data of the system to an SQL database server; they are status data, FITS header data, and also meta data such as device configuration data and FITS configuration data. We present our software system design and the database schema to manage observations of MOIRCS with Subaru.

Original languageEnglish
Title of host publicationAdvanced Software and Control for Astronomy
Publication statusPublished - 2006 Oct 17
EventAdvanced Software and Control for Astronomy - Orlando, FL, United States
Duration: 2006 May 242006 May 26

Publication series

NameProceedings of SPIE - The International Society for Optical Engineering
ISSN (Print)0277-786X


OtherAdvanced Software and Control for Astronomy
Country/TerritoryUnited States
CityOrlando, FL


  • Instrument control system
  • Linux
  • Near-infrared
  • SQL database

ASJC Scopus subject areas

  • Electronic, Optical and Magnetic Materials
  • Condensed Matter Physics
  • Computer Science Applications
  • Applied Mathematics
  • Electrical and Electronic Engineering


Dive into the research topics of 'Application of SQL database to the control system of MOIRCS'. Together they form a unique fingerprint.

Cite this