摘要
在信息处理领域,存在大量数据信息需要进行校验,以确保数据的准确性、一致性、真实性,基于此提出了一种较为通用的批量数据检索方法,并开发了针对学位备案系统中学位授予信息的批量数据检索工具软件。该方法采用客户端的方案,使用数据库驱动程序以屏蔽异构数据源的差异,数据的读取、比对由批量数据检索软件执行;数据的检索基于批量检索方法定义的规则;数据库模式信息采用了数据库名-数据库表名-字段名组成的层次结构,以树来显示。开发的软件支持Oracle,SQLserver,Excel等数据源,并具有跨平台的特性。
A large quantity of data need to be validated to ensure accuracy, consistency and authenticity in the field of information processing. This paper introduces a general method of bulk data validation and develops a tool application. This application is a client to the data source. It accesses the data sources through drivers provided by the individual data source vendor. So the application is independent of specific data source. The application reads and validates data. It retrieves data according to the rule defined by the method. Database schema information is shown in the form of tree, which contains the name of database, the name of table and the name of field. The application can validate data from Oracle, SQL Server, Excel and so on, and it can run cross-platform.
出处
《计算机系统应用》
2010年第5期63-67,共5页
Computer Systems & Applications