中国科学院机构知识库网格
Chinese Academy of Sciences Institutional Repositories Grid
首页 机构 成果 学者
  
  1. CAS IR Grid
  2. 合肥物质科学研究院
  3. 中国科学院合肥物质科学研究院
EAST plant data storage system based on IoTDB time series database

文献类型：期刊论文

作者Yang, Guang1,2; Wang, Feng2; Fan, Dixin1,2
刊名FUSION ENGINEERING AND DESIGN
出版日期2024-10-01
卷号207
关键词EAST Plant data Time series database Data storage IoTDB
ISSN号0920-3796
DOI10.1016/j.fusengdes.2024.114648
通讯作者Wang, Feng(wangfeng@ipp.ac.cn)
英文摘要EAST (Experimental Advanced Superconducting Tokamak) has been in operation since 2006. With increasing operation time, the volume of plant data stored in MySQL has steadily grown to several billion rows. The current storage architecture centered around the relational database has shown poor performance when facing massive time series data, so it is crucial to adopt TSDB (Time Series Database) for storing plant data. In initial testing, IoTDB demonstrated a performance advantage of at least 2 times over other TSDBs in terms of both write throughput and large-scale queries for plant data management. However, as the inflexible underlying infrastructure of EAST, the plant database cannot be easily modified directly. To remedy this problem, we propose a MySQL-IoTDB Hierarchical Mechanism (MIHM). Specifically, we utilized a MySQL master-slave to IoTDB cluster design to seamlessly transfer the performance burden from relational database to TSDB IoTDB. Extensive tests on the EAST plant data demonstrate that MIHM-based plant data storage system has increased the write throughput by 20 times and the large-scale data querying speed by 100 times compared to previous systems.
WOS研究方向Nuclear Science & Technology
语种英语
WOS记录号WOS:001304356400001
出版者ELSEVIER SCIENCE SA
源URL[http://ir.hfcas.ac.cn:8080/handle/334002/134969]  
专题中国科学院合肥物质科学研究院
通讯作者Wang, Feng
作者单位1.Univ Sci & Technol China, Hefei, Anhui, Peoples R China
2.Chinese Acad Sci, Hefei Inst Phys Sci, Inst Plasma Phys, Hefei, Anhui, Peoples R China
推荐引用方式
GB/T 7714		 Yang, Guang,Wang, Feng,Fan, Dixin. EAST plant data storage system based on IoTDB time series database[J]. FUSION ENGINEERING AND DESIGN,2024,207.
APA Yang, Guang,Wang, Feng,&Fan, Dixin.(2024).EAST plant data storage system based on IoTDB time series database.FUSION ENGINEERING AND DESIGN,207.
MLA Yang, Guang,et al."EAST plant data storage system based on IoTDB time series database".FUSION ENGINEERING AND DESIGN 207(2024).

入库方式： OAI收割

来源：合肥物质科学研究院

浏览0
下载0
收藏0
其他版本

除非特别说明，本系统中所有内容都受版权保护，并保留所有权利。