【作者】 陈秀莉；

【导师】 王茜；

【作者基本信息】 东南大学 ， 计算机应用技术， 2006， 硕士

【摘要】 医药销售领域的计算机信息化已有一段历史,尽管很多医药销售公司已开展了网上销售业务,但其可访问的药品资源信息都是源于本企业的数据库;由于各企业操作系统、数据库管理系统异构性以及数据库对语义描述的能力弱等问题的存在,难以实现医药销售公司对药品资源信息共享和数据交互需求。为了在电子商务环境下的企业间协同经营与运作,为了能够迅速适应企业的发展变化,跨平台的异构数据交互已成为急需解决的商业壁垒。本文通过对网上医药销售的业务需求分析,首先设计了一个用Web service技术构建的医药销售管理系统,该应用系统的客户端可以访问分布的多个不同的数据服务(分散在各地的多台数据库服务器),而且这些数据服务器提供的数据库可以是异构的。其次,本文以医药销售管理系统为例,研究了分布式异构数据库之间数据交换的实现方法。提出了基于Web service的异构数据库之间数据交换的解决方案,即数据的提供方在网上通过Web services提供服务,而数据的访问者通过引用Web services的方法获取提供方的数据并用数据交换工具将其转换为本地可用的(可识别的)数据。数据交换工具利用本体的概念、采用医药领域的标准术语作为电子商务环境下的医药销售公司间异构系统交换数据的数据字典。具体来说,数据交换工具将给定的源数据模式,依据标准的数据模式(数据字典),转换为本地目标数据模式。数据按照源模式与目标模式之间的映射关系进行交换,实现数据所代表的物理意义的融合。最后,论文通过原型系统的实现验证了所提出的数据转换工具的可行性和有效性。更多还原

【Abstract】 There has been a long history for computer informatization in the medicine sales field. Although many medicine sales companies have their online marketing, their accessible resource information comes from databases of their own enterprises. Because of the differences among the operating systems and the database management systems and the weakness for semantic descriptions of the databases, etc., it is difficult to realize the information sharing and data exchanging among medicine sales companies. In order to coordinate the business management and the operations among enterprises under E-commence environment and in order to meet the development of enterprises, the data exchange cross-platforms has become a commercial barrier to be solved urgently.In this paper, the business requirements of online medicine sales have been analyzed. A medicine sales management system based on Web service technology is designed. One client can access multiple distributed data services (several database servers scattered over internet) in this application system, and the data provided by those databases could be heterogenic.Then, the research on implementation methods for the data exchanges between distributed heterogenic databases has been done in this paper by taking the medicine sales management system as an example. The data exchange solution based on Web services has been introduced. In other words, a provider provides its services online through Web services, whereas consumers invoke Web services and obtain the provider’s data over internet. After that, the data from provider will be convert to the local available (recognizable) data using the data exchange tool.The data exchange tool is based on the concept of Ontology and adopts the standard terminologies of the medicine field as the data dictionary used for the data exchange between different medicine sales companies under E-business environment. Specifically speaking, a given source data pattern can be converted to a local target data pattern according to the standard data pattern (the data dictionary) by the data exchange tool. Data could be transferred from the source database into the target database according to the mapping relationship between the source pattern and the target pattern. In this way, the data integration could be realized.Finally, the feasibility and validity of the proposed data exchange tool are verified through the implementation of the prototype system.更多还原