基于动态表格格式的数据上报平台的研发

Research and development of data reporting platform based on dynamic structured table

在企业日常的生产、管理、营销过程中,存在着大量的数据收集、汇总工作。由于这些表格所包含的列数、每列的属性类别各异,常规的基于固定数据库表设计的数据收集功能无法满足多变的应用需求。为了解决线下收集数据带来的工作效率低、合并过程难以避免出错、数据没有集中存放的问题,我局开发了基于动态表格格式的数据上报平台,本文对研发过程中的关键技术进行总结。该平台的投运,节省了人力资源成本支出。采用该技术后,数据收集和汇总相关的工作从平均单份1小时的工作量缩减为10分钟的工作量,约节约了5/6的时间成本。

In daily manufacturing, management and marketing of our company,there are a huge number of data collection tasks. Since the variety of the total number of columns and the type of each column, the regular data collection funcion based on fixed database table design can not satisfy the various business requirements. To solve the efficiency problems bringing by offline data collection, we developped a data reporting platform based on dynamic structured table. This paper is about the key technologies related to the research and development process of this platform. The application of this platform reduces the cost of human resources. On average, each data collection task takes about one hour, which now takes about 10 minutes. That is to say, it saves about 5/6 time for each task.