Challenge of Design Data Exchange between heterogeneous Database Schema

The development of complex systems becomes increasingly difficult. The diversity and number of tools necessary to develop such a system is extensive. One solution to exchange engineering data between these tools is the Standard for Product Data Exchange (STEP), ISO 10303. It offers domain specific database schema called application protocols. This paper analyses the problems of the data exchange between tools via an application protocol. and proposes a Transformation Report, which records individual transformation steps during the exchange between two different tools. The Transformation Report supports the understanding of the data exchange process and helps correcting incomplete or incorrect transformed data

Scaling Heterogeneous Databases and the Design of Disco

Access to large numbers of data sources introduces new problems for users of heterogeneous distributed databases. End users and application programmers must deal with unavailable data sources. Database administrators must deal with incorporating new sources into the model. Database implementors must deal with the translation of queries between query languages and schemas. The Distributed Information Search COmponent (Disco) 1 addresses these problems. Query processing semantics are developed to process queries over data sources which do not return answers. Data modeling techniques manage connections to data sources. The component interface to data sources flexibly handles different query languages and translates queries. This paper describes (a) the distributed mediator architecture ofDisco, (b) its query processing semantics, (c) the data model and its modeling of data source connections, and (d) the interface to underlying data sources. 1

An Ontology Based Approach To The Integration Of Heterogeneous Information Systems Supporting Integrated Provincial Administration In Khon Kaen, Thailand

Information systems are a necessity to the administration of organizations. In a recent reform to the Thai administration, the governor of each province is entrusted with the full responsibility for the strategic planning and execution of the Integrated Provincial Administration (IPA). This presents a big challenge and many difficult problems for a potentially fast growing, both economically and demographically, province, such as Khon Kaen. To provide the administrator of the province with reliable and up to date information, the Provincial Operation Centre (POC) has been set up and assigned the task of collecting all required information from disparate information systems, many of which are legacy systems. This information lacks interoperability and integration of data due to many different structures and semantic heterogeneity encountered in many information systems. This research is a part of a collaborative data sources community development project. It attempts to aid high-level decision makers by using ontology to resolve heterogeneities among many disparate data sources. After relevant data sources are identified, they are analysed to reveal important and corresponding concepts, attributes and relations. They are then used in the creation of ontologies to resolve schematic and semantic conflicts in the data sources. The integration of many heterogeneous information systems will provide a unified view of information facilitating the provincial administrator in his decision making

Towards interoperability in heterogeneous database systems

Distributed heterogeneous databases consist of systems which differ physically and logically, containing different data models and data manipulation languages. Although these databases are independently created and administered they must cooperate and interoperate. Users need to access and manipulate data from several databases and applications may require data from a wide variety of independent databases. Therefore, a new system architecture is required to manipulate and manage distinct and multiple databases, in a transparent way, while preserving their autonomy. This report contains an extensive survey on heterogeneous databases, analysing and comparing the different aspects, concepts and approaches related to the topic. It introduces an architecture to support interoperability among heterogeneous database systems. The architecture avoids the use of a centralised structure to assist in the different phases of the interoperability process. It aims to support scalability, and to assure privacy and nfidentiality of the data. The proposed architecture allows the databases to decide when to participate in the system, what type of data to share and with which other databases, thereby preserving their autonomy. The report also describes an approach to information discovery in the proposed architecture, without using any centralised structure as repositories and dictionaries, and broadcasting to all databases. It attempts to reduce the number of databases searched and to preserve the privacy of the shared data. The main idea is to visit a database that either containsthe requested data or knows about another database that possible contains this data