期刊名称：International Journal of Computer Science and Information Technologies
电子版ISSN：0975-9646
出版年度：2014
卷号：5
期号：2
页码：2578-2581
出版社：TechScience Publications
摘要：With the development of computer network and database, traditional database has been increasing unable to meet the needs of data sharing and interoperability. Meanwhile, it is impossible to abandon all the existing database systems; therefore, the research of simultaneously accessing and processing data from a number of databases has become an inevitable trend. For the Health care information system its not the issue to retrieve the information from their own databases. But when we want the information other than the own databases, then its an issue to get that information to our system. And the data which we want from other health care organizations may not be in same format. To solve this problem the proposed architecture is to integrate different geographically dispersed databases that are heterogeneous with regard to their logical schemas.For the Integration of heterogeneous databases MyAccess , MySQL, SQL and Oracle databases are taken. These databases are having different characteristics of data types and semantic conflictions may occure while integrating heterogeneous databases. Using the technology of Java , SQL Language the heterogeneous database integration system is proposed and designed and key technologies are also described in detail. For the queries which are frequently fired to the databases for retrieving the information, the materialized view is created. By creating materialized view the information which requires most to the user is stored in the dataware house. Because of which response to the frequent queries is fast, no need to search the the whole database. It reduces the overhead for the frequent queries and gives fast response to the fired quieries
关键词：Data Integration; data transformation;Heterogeneous databases; Java Technology; SQL query
