摘要
随着信息化建设的推进,企业各部门都根据自身需求建立了信息管理系统。为解决企业内部异构数据库数据共享的问题,提出了一个基于虚拟视图的异构数据库集成平台的系统架构方案,详细描述了各组件的功能,设计了元数据的数据对象模型,以及它们与XML文件的映射规则,研究和讨论了虚拟视图的定义和SQL语句解析等关键问题。平台采用标准SQL语句作为查询语言,降低了用户的使用难度。设计了一个基于XML的缓存机制,有效地实现了查询优化,提高了系统的响应效率。
With the promotion of information development, enterprises have developed their own information management system based on their requirements. In order to share data among the heterogeneous databases,gives a system architecture of heterogeneous database platform based on virtual view. Each component is described in detail. The designs of mapping between data object model and XML is prescnted. The definition of virtual view and SQL statement parser are discussed mainly. The platform adopts the standard SQL as the query language to reduce the usage difficulty. The cache mechanism based on XML improves the response efficiency, implements the optimization of query.
出处
《计算机技术与发展》
2009年第6期91-94,共4页
Computer Technology and Development
