作者投稿和查稿 主编审稿 专家审稿 编委审稿 远程编辑

计算机工程 ›› 2009, Vol. 35 ›› Issue (20): 37-40. doi: 10.3969/j.issn.1000-3428.2009.20.013

• 软件技术与数据库 • 上一篇    下一篇

非结构化Word数据表与RDB间的存储转换

黄 蔚,张 璟,李军怀,白 敏   

  1. (西安理工大学计算机科学与工程学院,西安 710048)
  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2009-10-20 发布日期:2009-10-20

Storage Conversion Between Unstructured Word Data Table and RDB

HUANG Wei, ZHANG Jing, LI Jun-huai, BAI Min   

  1. (School of Computer Science and Engineering, Xi’an University of Technology, Xi’an 710048)
  • Received:1900-01-01 Revised:1900-01-01 Online:2009-10-20 Published:2009-10-20

摘要: 针对信息系统中非结构化信息Word数据表与关系数据库之间的数据交互,提出一种基于PIA和ADO.NET技术的Word数据表互操作方法。该方法通过Word PIA对象操作Word表格,采用数据提取、数据规范化检查、虚拟表定义、分段导入和表格定制等策略解决关系数据库与Word表格之间的数据转换问题,将Word表格数据批量导入数据库,导出数据库数据生成Word数据表。通过应用案例验证该方法的可行性和实用性。

关键词: 非结构化信息, PIA技术, ADO.NET技术, Word数据表, 数据转换

Abstract: Aiming at data exchange between unstructured information Word data table of information systems and Relational Database(RDB), this paper proposes an interoperability method of Word data table based on PIA and ADO.NET techniques. This method solves the data conversion problems between Word table and RDB by operating Word table through Word PIA object and adopting strategies such as data extraction, data standardization inspection, virtual table definition, sub-paragraph injection and table customization. It realizes volume data importing implemented from Word table data to database and data exporting supported from database to Word data table. The feasibility and practicality of the method is verified through application cases.

Key words: unstructured information, PIA technique, ADO.NET technique, Word data table, data conversion

中图分类号: