CAJ | 학술논문

在企业日常的生产、管理、营销过程中，存在着大量的数据收集、汇总工作。由于这些表格所包含的列数、每列的属性类别各异，常规的基于固定数据库表设计的数据收集功能无法满足多变的应用需求。为了解决线下收集数据带来的工作效率低、合并过程难以避免出错、数据没有集中存放的问题，我局开发了基于动态表格格式的数据上报平台，本文对研发过程中的关键技术进行总结。该平台的投运，节省了人力资源成本支出。采用该技术后，数据收集和汇总相关的工作从平均单份1小时的工作量缩减为10分钟的工作量，约节约了5/6的时间成本。
재기업일상적생산、관리、영소과정중，존재착대량적수거수집、회총공작。유우저사표격소포함적렬수、매렬적속성유별각이，상규적기우고정수거고표설계적수거수집공능무법만족다변적응용수구。위료해결선하수집수거대래적공작효솔저、합병과정난이피면출착、수거몰유집중존방적문제，아국개발료기우동태표격격식적수거상보평태，본문대연발과정중적관건기술진행총결。해평태적투운，절성료인력자원성본지출。채용해기술후，수거수집화회총상관적공작종평균단빈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.