Creating Materialized View Over Integrated Heterogeneous Databases


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. Keywords— Data Integration, data transformation, Heterogeneous databases, Java Technology, SQL query

Cite this paper

@inproceedings{JPaturde2014CreatingMV, title={Creating Materialized View Over Integrated Heterogeneous Databases}, author={Ankush J.Paturde and Anil V. Deorankar}, year={2014} }