Adaptive parallel query optimization method for ground measurement and control system database of environmental control and life support system
10.16289/j.cnki.1002-0837.2024.06007
- VernacularTitle:环控生保地面测控系统数据库自适应并行查询优化方法的研究
- Author:
Jingsong YANG
1
;
Xiaoma LIU
;
Zhen ZHANG
;
Aoqing WU
;
Zhuo PENG
Author Information
1. 中国航天员科研训练中心,北京 100094
- Keywords:
ECLSS;
database;
query optimization method;
adaptive;
parallel query
- From:Space Medicine & Medical Engineering
2024;35(6):367-370
- CountryChina
- Language:Chinese
-
Abstract:
The long-term ground state monitoring of the Manned spacecraft environmental control and life support system(ECLSS)is accumulating huge amount of measurement point data everyday,so how to manage and query the data of each measurement point efficiently is a key problem.Aiming at the inefficiency of traditional SQLServer database multi-table query logic based on union operation when the number of sub-tables in the database is relatively large,this paper designs an adaptive rowwise segmentation algorithm,which can select the optimal number of rowwise tangent queries according to different query time intervals,so as to make full use of the system's multithreading for parallel querying.The typical query scenario test proves that compared with the traditional query method,the designed query optimization method can obviously improve the query efficiency and significantly reduce the query time.
