A Framework for Integration and Standardization of Data from Heterogeneous Sources

It is clear that in today’s organizations, new and existing applications require access to data stored in several pre-existing databases held at several local and remote locations. Therefore, a main criterion required by most complex organizations, is the provision of collaboration possibilities and information integration mechanisms among distributed, heterogeneous, and autonomous database systems. The development of an application provides interoperability and information integration among distributed systems, via the deployment of database standards and emerging Internet technologies. It is one of the most challenging approaches in the area of integrating heterogeneous information from autonomous sites. In this context, the work described in this paper focuses on the design and development of a Generic Information Exchange (GIE) System. The system supports a wide variety of applications with efficient means for their interconnection and interoperation, while preserving their heterogeneity, distribution, and full autonomy. An example of the interoperability problem is found in the healthcare domain, where each hospital, or even each department in a hospital, maintains its own database. In this environment it is very important to permit users to locate and access data from several remote databases, supporting the needs of patient care, daily operations of the hospitals and research consultations. It necessitates the sharing and exchange of data related to clinical, administrative, managerial and research (statistical) information.