Welcome to Metal Mine! Today is Share:

Metal Mine ›› 2023, Vol. 52 ›› Issue (11): 213-220.

Previous Articles     Next Articles

Tracing Management of Unit Name and Statistical Caliber Change in Statistical Information System

LIU Qianpeng1,2 SUN Xiaoyu1 ZHAO Yongjiao3 ZHANG Bo3 WANG Renyan1 #br#   

  1. 1. School of Resources and Civil Engineering,Northeastern University,Shenyang 110004,China;2. Yutong Bus Co. ,Ltd. ,Zhengzhou 450061,China;3. Inner Mongolia Pingzhuang Coal Industry (Group) Co. ,Ltd. ,Chifeng 024000,China
  • Online:2023-11-15 Published:2024-01-02

Abstract: The company name and statistical caliber are the basic information in the statistical information system. However,due to the major strategic adjustment,business reorganization or organizational change of the group company,it is inevitable to change the company name and statistical caliber. Aiming at the problems of unit name tracing,summary data integration and unit sorting in statistical caliber caused by the change of unit name and statistical caliber,a unified unit coding rule is studied and designed,and a historical information tracing method based on time is proposed. Based on the expression statement of database high-performance nested query,a single data table is designed for statistical caliber management. For the unit information management,two solutions of multi data table and single data table are designed. Through the comparative analysis of the two solutions through the occupation of database space and system response time,the single data table scheme is selected. In order to facilitate the unified calling of codes,multiple program interfaces are written in C# language,which realizes the effective management of unit name,data summary and statistical caliber,and has achieved good results in the practical application of the comprehensive statistical information system of Pingzhuang Coal Industry Group.

Key words: unit name,statistical caliber,unified coding,information tracing