数据库系统大量数据高效录入工具的设计实现

The Design of Efficient Logging Tool with Massive Data in the Data Base System

为了给信息系统准确、高效地录入大量初始数据,提出应用Excel的模板及VBA编程技术,基于Excel二次开发"大量数据高效录入工具",将大量初始数据录入工作分散到各组中并行进行的策略.具有开发成本低,录入工具界面友好、操作灵活、功能强大,能方便实现对录入数据校验及合并,适应当前大多数录入人员对Excel比较熟悉的习惯,有效克服了以往信息系统录入功能键盘鼠标混用,不能按用户习惯控制焦点,若在网络环境下上传数据有延迟,数据量大时录入明显变慢的等问题.最后,以"义务教育少年儿童数据录入系统"为例,说明了开发"大量数据高效录入工具"的功能、关键技术及应用实践.

In order to put in a great number of initial data into the information system efficiently and accurately, the design of efficient logging tool with massive data, which is based on the Excel secondary development and uses both the template of Excel and VBA programming technology is being used. Further, the final strategy utilizes this very tool to separate a large number of logging works with initial data into different working groups. It has plenty of advantages such as low cost of development, friendly interface of inputting tool, flexible operations and powerful functions. Also it can both achieve the verification and merging of logging data, which suits most familiar habits of data entry clerk at present. As a result it has efficiently overcome the problems below： the blend between mouse and keyboard in the previous logging system, incontrollable focus according to users＇ habits, the delay of uploading data under the network environment and obviously the slow speed when facing oversized data. Finally, take ＂The data logging system of children＇s compulsory education ＂for instance, this article illustrates functions, key technologies and application practice of efficient logging tool with massive data.