摘要
目前企业信息化系统发展日趋深化,系统之间的关联日益错综复杂。系统之间的数据交互通常采用数据库导出、导入技术实现,而很多情况下,出于数据安全的考虑,在一些大型企业中数据库权限的管控非常严格,因此很多还依赖人工二次录入。一方面,庞大的数据量使得业务系统在多数时间下都在等待数据录入,影响业务系统工作效率;另一方面,由于人为因素的不可控,使得人工录入的数据质量难以保证。为解决以上问题,提出一种基于动作重放的自动执行数据输入的方法,采用自动化方法加速数据录入,从而保障录入的数据质量,该方法主要包含3个步骤:记录系统界面的数据录入步骤、对数据录入步骤进行整合、将数据录入步骤转化为可执行的事件。该文基于真实业务系统对该方法进行了案例分析,分析结果表明了方法的可行性。
With the development of information system in companies,interoperation among systems becomes necessary and more and more complicated. To handle data interoperation, one of the most frequently used approaches is database export/import. However, considering data security, database export/import is usually strictly limited, especially in large companies. As a result, a safer way, i. e. manual data entry through system user interfaces, is commonly adopted. Manual data entry, on the one hand, is very inefficient in case that the amount of data can be huge. On the other hand, the data quality is difficult to guarantee because manual method is usually error- prone. To solve the problems, we proposed an action replay based method to automatically perform data entry so as to improve the efficiency as well as ensure the quality of the input data. Our approach can be summarized in 3 steps : recording the data entry steps in the system user interface, data entry steps optimization, converting data entry steps into an executable program. We conducted case studies using two real-worht information systems and the results showed the feasibility of our approach.
出处
《自动化与仪器仪表》
2017年第12期35-37,共3页
Automation & Instrumentation
基金
电力数据持续数据质量监视与辅助改善系统研发(GDKJXM20161895(030600KK52160021)