Design of experimental data governance module for chemical material formulation

doi:10.3969/j.issn.1000-5641.2022.05.001

Abstract

Abstract:

As a new type of production factor, data elements are becoming key to enterprise development. As an important component of national economic production, the chemical material industry must upgrade their data information system according to the needs of its construction. In this regard, a tailored data governance module is proposed for managing experimental formula data in the chemical material industry. The data governance module proposes the use of corresponding data standards and specifications according to the current business scenario of the enterprise. The system obtains data from the front end, improves its quality, stores it in a database, evaluates the data from the back end, and finally returns it to the front end for display, thereby creating a closed-loop negative feedback system.

Key words: data governance, chemical industry, data assets

CLC Number:

TP311.5

Yiming YU, Yuchen HONG, Ye WANG, Qiwen DONG. Design of experimental data governance module for chemical material formulation[J]. Journal of East China Normal University(Natural Science), 2022, 2022(5): 1-13.

Figures/Tables 13

Fig.1

Fig.2

Fig.3

Fig.4

Fig.5

Fig.6

Fig.7

Fig.8

Fig.9

Fig.10

Table 1

Basic function test cases"

用例编号	功能模块	测试步骤	预期结果	实际结果
1	数据管理, 数据导入	1. 下载 604 室仿真数据表模板; 2. 根据模板新建 EXCEL 表; 3. 填充测试数据; 4. 上传数据.	1. 在 604 科室仿真数据库表中能找到这条新插　入的数据; 2. 在业务数据界面查询到这条数据.	通过
2	元数据管理, 新建元数据	1. 新建界面选择 604 科室; 2. 新建表名 t_tdm_604数据表; 3. 新建表中文名 604TDM 数据表.	1. 在元数据查询中查到该表; 2. 在数据管理页面, 查到生成的上传模板.	通过
3	元数据管理, 修改元数据	1. 元数据修改界面查询 604TDM 数据表; 2. 新增字段“环氧值”.	1. 数据库中表结构变成修改后的内容; 2. 上传模板格式为修改后的内容.	通过
4	数据质量, 新增数据标准	1. 新增数据标准界面; 2. 数据检验规则选正确性检测; 3. 数据质量属性选异常值检测; 4. 数据表填 604TDM 数据表; 5.选择应用列为“环氧值”.	生成待审批状态的数据标准.	通过
5	数据质量, 质量方案审核	1. 审核界面; 2. 选择“主任研究师”管理角色; 3. 审核用例编号 4 的新增数据标准.	1. 审核通过则在数据标准显示生效记录; 2. 对其有修改、删除和查询操作.	通过
6	数据质量, 异常值处理	1. 修改新增的 TDM 数据表数据中的“环氧值”; 2. 修改为“2”, (精度要求两位小数).	1. 异常值处理界面出现该条数据; 2. 提示精度错误; 3. 有修改操作.	通过
7	数据资产, 稽核打分	1. 选择计算配方力学性能表; 2. 选择配方标签1; 3. 燃速规则选高, 下限为 0 mm/s, 上限为　9.2 mm/s, 权重 0.5 (满格1) ; 4. 室温拉伸强度规则选高, 下限 0 MPa, 上限　0.8 MPa, 权重 0.5; 5. 运行规则; 6. 勾选数据; 7. 保存.	1. 按照燃速和室温拉伸强度进行排序; 2. 可以勾选需要保存的数据; 3. 在配方力学性能打分表中有勾选的数据.	通过
8	数据资产, 数据资产大屏展示	不同身份权限进入推进剂设计驾驶舱界面.	1. “主任研究师”权限, 配方力学性能数据展示的　是数据打分保存的排序数据; 2. “行政指挥”不显示该数据界面.	通过

Table 1

Table 2

Fig.11

References 14

1	李凌云. 化工行业数字化转型实践及对企业的影响. 河南化工, 2020, 37 (9): 66- 68.
2	李世鹏, 黄金龙, 李波, 等. 固体火箭发动机推进剂性能数据库的开发 [C]// 中国宇航学会固体火箭推进第22届年会论文集. 2005: 253-255.
3	刘冰, 庞琳. 国内外大数据质量研究述评. 情报学报, 2019, 38 (2): 217- 226.
4	杨琳, 高洪美, 宋俊典, 等. 大数据环境下的数据治理框架研究及应用. 计算机应用与软件, 2017, 34 (4): 65- 69.
5	LIU D, WANG J, RAJAKANI K. Upgrading of IOT big data governance scheme in microenterprise governance. Wireless Communications and Mobile Computing, 2022, 2022. doi: 10.1155/2022/9831331.
6	吴信东, 董丙冰, 堵新政, 等. 数据治理技术. 软件学报, 2019, 30 (9): 2830- 2856.
7	AL-BADI A, TARHINI A, KHAN A I. Exploring big data governance frameworks. Procedia Computer Science, 2018, 141, 271- 277.
8	杨东华, 李宁宁, 王宏志. 基于任务合并的并行大数据清洗过程优化. 计算机学报, 2016, 39 (1): 97- 108.
9	IBM Data Governance Council. IBM data governance council maturity model: Building a roadmap for coffecttive data governance [EB/OL]. (2007-10-01)[2022-07-10]. https://scribd.com/doc/294669999/IBM-Data-Governance-Council-Maturity-Model.
10	DGI. DGI data governance framework [EB/OL]. (2009-01-01)[2022-07-10]. http://datagovernance.com.
11	OGIER A, HALL M, BAILEY A. Data management inside the library: Assessing electronic resources data using the data asset framework methodology. Journal of Electronic Resources Librarianship, 2014, 26 (2): 101- 113.
12	韩京宇, 徐立臻, 董逸生. 数据质量研究综述. 计算机科学, 2008, (2): 1- 5.
13	李谦, 白晓明, 张林, 等. 供电企业数据资产管理与数据化运营. 华东电力, 2014, 42 (3): 487- 490.
14	巨克真, 魏珍珍. 电力企业级数据治理体系的研究. 电力信息与通信技术, 2014, 12 (1): 7- 11.

[1]	Xin GONG, Lihua XU, Liang DOU, Ruixiang ZHAO. Redundancy measurement and reduction of automated tests in financial technology [J]. Journal of East China Normal University(Natural Science), 2022, 2022(4): 43-55.
[2]	JI Yu, HE Yi-xuan, WU Guo-qun, WU Min. On evaluation of Bessel functions of the first kind via Prony-like methods [J]. Journal of East China Normal University(Natural Sc, 2019, 2019(6): 42-60.
[3]	ZHANG Tao, ZHANG Xiao-lei, LI Yu-ming, ZHANG Chun-xi, ZHANG Rong. Woodpecker+: Customized workload performance evaluation based on data characteristics [J]. Journal of East China Normal University(Natural Sc, 2019, 2019(5): 190-202.
[4]	ZHANG Heng, CHEN Liang-yu. Optimization of the Levenshtein algorithm and its application in repeatability judgment for test bank [J]. Journal of East China Normal University(Natural Sc, 2018, 2018(5): 154-163.
[5]	LI Jie-ying, LI Yu-ming, ZHANG Xiao-lei, ZHANG Rong. Woodpecker: Fine-grained contention simulation database testing framework [J]. Journal of East China Normal University(Natural Sc, 2018, 2018(2): 77-88.
[6]	YANG Le, LIU Yin-ping, LI Zhi-bin. Emathema: An online automated computing platform for equations [J]. Journal of East China Normal University(Natural Sc, 2017, (3): 20-28.
[7]	ZHAO Da-peng,LIANG Lei,TIAN Xiu-xia,WANG Xiao-ling. Privacy protection in locationbased services: Model and development [J]. Journal of East China Normal University(Natural Sc, 2015, 2015(5): 28-45.
[8]	HAN Wen-wen;WANG Ling;CHEN You-guang . Segmentation Algorithm Based on Subpixel Image (Chinese) [J]. Journal of East China Normal University(Natural Sc, 2007, 2007(3): 100-106.
[9]	. (Chinese) [J]. Journal of East China Normal University(Natural Sc, 2007, 2007(2): 122-125.
[10]	. (Chinese) [J]. Journal of East China Normal University(Natural Sc, 2006, 2006(4): 137-140.
[11]	WANG Yuan-fei;ZHOU Feng;LIU Zhi-qiang;MI Wei-jie;LU Tao;DING Jing-hong. Component GIS for Census in Pudong New Area(Chinese) [J]. Journal of East China Normal University(Natural Sc, 2006, 2006(2): 27-32.
[12]	ZHANG Sheng-xi;ZHANG Wei;LI Guo-qiang;GU Guo-qing. Skew Detection for Form Document Using Vertex-chain-code [J]. Journal of East China Normal University(Natural Sc, 2004, 2004(3): 54-58.