Plasma and Fusion Research

Volume 18, 1305048 (2023)

Letters

QUEST Database for Tokamak Big Data
Makoto HASEGAWA, Aki HIGASHIJIMA, Ichiro NIIYA, Kazuaki HANADA, Hiroshi IDEI, Takeshi IDO, Ryuya IKEZOE, Takumi ONCHI, Kengo KURODA and Daisuke SAKURAI1)
Research Institute for Applied Mechanics, Kyushu University, 6-1 Kasuga-koen, Kasuga, Fukuoka 816-8580, Japan
1)
Pan-Omics Data-Driven Research Innovation Center, Kyushu University, 6-1 Kasuga-koen, Kasuga, Fukuoka 816-8580, Japan
(Received 21 November 2022 / Accepted 19 April 2023 / Published 5 June 2023)

Abstract

A database has been developed to provide a highly efficient data analysis environment by registering various types of data obtained in the QUEST (Q-shu University Experiment with Steady-State Spherical Tokamak) experiments and providing the data to researchers through standard SQL query output. In conventional experiments, measurements are usually obtained using several instruments, and the results are often stored separately in proprietary formats. An analysis to collect distributed files and convert them into appropriate formats individually was necessary, which led to a decrease in analysis efficiency. In order to build a system to centrally store and provide data, we constructed new servers, each for registering data in a database and for extracting data from the database and visualizing the data. As a result, various real-time monitoring data can be registered in the database, and data retrieval for analysis can be performed easily with a unified user interface. The construction of this database has made it possible to easily retrieve real-time monitoring data and a wide variety of table data, enabling analysis from a new perspective, and improving analysis efficiency.

Keywords

database, big data, SQL, continuous measurement, user interface

DOI: 10.1585/pfr.18.1305048

Full Text

PDF format (240Kbytes) PDF Download

References

  • [1] K. Hanada et al., “Steady-State Operation Scenario and the First Experimental Result on QUEST”, Plasma Fusion Res. 5, S1007 (2010).
  • [2] H. Idei et al., “Electron heating of over-dense plasma with dual-frequency electron cyclotron waves in fully non-inductive plasma ramp-up on the QUEST spherical tokamak”, Nucl. Fusion 60, 016803 (2020).
  • [3] T. Onchi et al., “Non-inductive plasma current ramp-up through oblique injection of harmonic electron cyclotron waves on the QUEST spherical tokamak”, Phys. Plasma 28, 022505 (2021).
  • [4] M. Hasegawa et al., “Modification of plasma control system and hot-wall temperature control system for long-duration plasma sustainment in QUEST”, Fusion Eng. Des. 129, 202 (2018).
  • [5] K. Hanada et al., “Overview of recent progress on steady state operation of all-metal plasma facing wall device QUEST”, Nucl. Mater. Energy 27, 101013 (2021).
  • [6] M. Hasegawa et al., “Extension of Operation Region for Steady State Operation on QUEST by Integrated Control with Hot Walls”, Plasma Fusion Res. 16, 2402034 (2021).
  • [7] M. Hasegawa, D. Sakurai et al., “Towards automated gas leak detection through cluster analysis of mass spectrometer data”, Fusion Eng. Des. 180, 113199 (2022).
  • [8] https://epics.anl.gov/
  • [9] J. Waterhouse et al., “Introduction of ITER CODAC relevant technologies on JET and MAST”, Fusion Eng. Des. 161, 111858 (2020).
  • [10] R. Castro et al., “Soft real-time EPICS extensions for fast control: A case study applied to a TCV equilibrium algorithm”, Fusion Eng. Des. 89, 638 (2014).
  • [11] W. Lee et al., “New control systems at KSTAR compatible with ITER standard technologies”, Fusion Eng. Des. 129, 94 (2018).
  • [12] R. Yamazaki et al., “Development of JT-60SA experiment database system”, Fusion Eng. Des. 155, 111555 (2020).
  • [13] H. Nakanishi et al., “Real-Time Data Streaming and Storing Structure for the LHD's Fusion Plasma Experiments”, IEEE Trans. Nucl. Sci. 63, 222 (2016).
  • [14] https://mariadb.org/
  • [15] https://jupyter.org/