一个通用数据清洗服务器的设计与实现

The Design and Implementation of a Universal Data Cleaning Server

以一个计算机辅助联网审计系统中审计规则的配置和生成为背景,描述了一个通用数据清洗服务器的设计与实现过程。提出了一种模型的存储与视图分离的方法,解决了配置信息与执行语句不一致的矛盾,使得该数据清洗服务器灵活和有效地满足了用户对数据加工的要求,能自动完成应用系统对数据的处理,可以成为一个相对通用的数据加工规则的自动生成及调度执行的系统。

Based on the configuring and generating of audit regulations for Computer-Aided Online Audit System, this article describes the process of the design and implementation of a universal data cleaning server. In the article, it isolates the model storage from the view and resolves the inconsistencies between configuration information and executing languages. This flexible and effective method meets users＇ requirements to data processing, and has the ability to process data automatically as welt. This system can be a universal tool for generating and executing the data processing regulations.