| In recent years, the rapid development of information technology and network technology accelerates enterprise's implementation on information construction. However, hand-management model is often using by many old Chinese enterprises and emerging small and medium-sized enterprises. While some enterprises had the foresight, they tend to have several different information systems at the same time, which means that a number of data sources exist simultaneously. In order to achieve the construction of enterprise information technology, avoid waste of resources and realize resources sharing to a great extent, many enterprises are now facing the important problem of integrating these different data sources.In this graduation design, based on designing and developing pharmaceutical purchase-sale-stock system of Tianjin Joint Venture, China National Pharmaceutical Industry Corporation Limited, module integrated data in all areas is developed to meet the corporate demand on resources sharing, transparency in heterogeneous data sources and support in decision analysis. A solving scheme for pharmaceutical purchase-sale-stock system is proposed on the basis of heterogeneous data integration. The key technology is investigated and the purchase-sale-stock system of the Tianjin Joint Venture is designed.The methods and procedures of software development are fully practiced and carefully explored in this graduation design with the theoretical and technological knowledge of software development learned from the major of software project, in which theory is used to direct practice.The main content and character are as follows:1. The current development of purchase-sale-stock system and the schemes for heterogeneous data sources integration are narrated.2. The feasibility to develop this system is discussed.3. The development and implementation technology of this system and the scheme for data sources integration based on extensible markup language (XML) are clarified. 4. Mainly based on the theory in software project, the development process are elaborated, including requirement analysis, preliminary design and database design, detailed design, test and so on.5. Taking Windows XP as the development platform, along with SQL Server 2005, Visual Studio 2005 and C# as the development tools, the desired functions are realized with implementation cost reduced, implementation accelerated and return on investment increased. |