高校财务数据导入系统的设计和实现

Design and implementation of a College Financial Data Import System

基于.NET三层架构探讨C/S模式下高校财务数据导入系统的实现。针对财务数据不规范、易误操作、批量处理的特点,提出结合日志表、临时表、事务与备份表的方法,解决从外部数据源导入到数据库的若干问题,实施效果满意,可作为同类型导入系统的参考。

This paper describes a successful implementation of a data import system, namely College Financial Data Import System. The implementation is based on . NET three-tier architecture and Client- Server structure. Several approaches-such as database transactions, logging tables, temporary tables, and backup tables are utilized to import the originally flawed, non-standard, batch-input financial data. This implementation can be used as an example for similar systems that aim at importing complex data from external data source into database.