统计信息系统中单位名称及统计口径变化追溯管理

金属矿山 ›› 2023, Vol. 52 ›› Issue (11): 213-220.

统计信息系统中单位名称及统计口径变化追溯管理

刘乾鹏^1,2孙效玉¹ 赵永娇³ 张博³ 王仁炎¹

1. 东北大学资源与土木工程学院,辽宁沈阳 110004;2. 宇通客车股份有限公司,河南郑州 450061;3. 内蒙古平庄煤业(集团)有限责任公司,内蒙古赤峰 024000

出版日期:2023-11-15 发布日期:2024-01-02
基金资助:
国家自然科学基金项目(编号:51674063);“十三五”国家重点研发计划项目(编号:2016YFC0801608)。

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

LIU Qianpeng^1,2 SUN Xiaoyu¹ ZHAO Yongjiao³ ZHANG Bo³ WANG Renyan¹ #br#

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

摘要： 单位名称和统计口径是统计信息系统中的基础信息,但是由于集团公司重大战略调整、业务重组或组织变革,难免引起单位名称及统计口径变化。针对单位名称及统计口径变化所产生的单位名称追溯、汇总数据集成和统计口径中单位排序等问题,研究设计了统一的单位编码规则,提出了以时间为节点的历史信息追溯方法。基于数据库高性能嵌套查询的表达式语句,对统计口径管理设计了单一数据表;对单位信息管理设计了多数据表和单一数据表两种解决方案,通过数据库空间占用和系统响应时间对两种解决方案进行对比分析,择优选择了单一数据表方案。为方便代码统一调用,采用 C#语言编写多个程序接口,实现了单位名称、数据汇总和统计口径的有效管理,在平庄煤业集团综合统计信息系统的实际运用中取得了良好的效果。

关键词: 单位名称, 统计口径, 统一编码, 信息追溯

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

刘乾鹏, 孙效玉, 赵永娇, 张博, 王仁炎. 统计信息系统中单位名称及统计口径变化追溯管理[J]. 金属矿山, 2023, 52(11): 213-220.

LIU Qianpeng, SUN Xiaoyu, ZHAO Yongjiao, ZHANG Bo, WANG Renyan. Tracing Management of Unit Name and Statistical Caliber Change in Statistical Information System[J]. Metal Mine, 2023, 52(11): 213-220.