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

Resolving horizontal partitioning and schematic variances using metadatabase approach.

by Poon, Koon-hei.Thesis (M.Phil.)--Chinese University of Hong Kong, 2000.Includes bibliographical references (leaves 80-83).Abstracts in English and Chinese.Chapter CHAPTER 1 --- INTRODUCTION --- p.6Chapter CHAPTER 2 --- LITERATURE REVIEW --- p.13Chapter 2.1. --- BACKGROUND --- p.13Chapter 2.2. --- example systems --- p.20Chapter 2.2.1 --- Multibase --- p.20Chapter 2.2.2. --- Mermai d --- p.23Chapter 2.2.3. --- The Metadatabase Approach --- p.26Chapter 2.3. --- SUMMARY --- p.29Chapter CHAPTER 3 --- THE METADATABASE APPROACH --- p.31Chapter 3.1. --- Two-Stage Entity Relationship (TSER) model --- p.31Chapter 3.2. --- The GIRD --- p.34Chapter 3.3. --- The Metadatabase system in action --- p.36Chapter 3.3. --- global query formulations and processing in the metadatabase system --- p.37Chapter CHAPTER 4 --- PROBLEM OUTLINES FOR HORIZONTAL PARTITIONING AND ITS VARIANTS --- p.39Chapter 4.1. --- Horizontal partitioning --- p.39Chapter 4.2. --- Level of abstraction --- p.41Chapter 4.3. --- Schematic variances --- p.42Chapter 4.4. --- Summary --- p.43Chapter 4.5. --- The Scenario --- p.44Chapter 4.6. --- Populating the Metadatabase --- p.48Chapter CHAPTER 5 --- THE ENHANCEMENTS FOR GLOBAL QUERY WITH HORIZONTAL PARTITIONED DATA OBJECTS --- p.51Chapter 5.1. --- Identifying partitioned data objects --- p.51Chapter 5.2. --- Additional metadata for the horizontal partitioned data objects --- p.52Chapter 5.3. --- Complications of horizontal partitioning problem --- p.54Chapter 5.3.1. --- Level of abstraction --- p.55Chapter 5.3.2. --- Schematic variances --- p.57Chapter 5.4. --- Global query with horizontal partitioning data objects --- p.59Chapter 5.5. --- Housing the new metadata --- p.68Chapter 5.6. --- Example --- p.72Chapter CHAPTER 6 --- ANALYSIS --- p.75Chapter CHAPTER 7 --- CONCLUSION AND FUTURE WORKS --- p.78REFERENCES --- p.80APPENDICES --- p.84Chapter A. --- GIRD Definitions --- p.84Chapter A1. --- GIRD Model --- p.84Chapter A2. --- GIRD/SER Contents --- p.84Chapter A3. --- GIRD/OER Constructs --- p.87Chapter A4. --- Definition of Meta-attributes --- p.89Chapter B. --- Problems Representations in Relation Algebra --- p.96Chapter B1. --- Horizontal problem --- p.96Chapter B2. --- Level of abstraction --- p.96Chapter B3. --- Schematic Variance --- p.97Chapter C. --- Details of local systems --- p.9

EU H2020 MSCA RISE Project FIRST - “virtual Factories: Interoperation suppoRting buSiness innovation”

FIRST – “virtual Factories: Interoperation suppoRting buSiness innovation”, is a European H2020 project, founded by the RESEARCH AND INNOVATION STAFF EXCHANGE (RISE) Work Programme as part of the Marie Skłodowska-Curie actions. The project concerns with Manufacturing 2.0 and aims at providing the new technology and methodology to describe manufacturing assets; to compose and integrate the existing services into collaborative virtual manufacturing processes; and to deal with evolution of changes. This Chapter provides an overview of the state of the art for the research topics related to the project research objectives, and then it presents the progresses the project achieved up to now towards the implementation of the proposed innovations

Interconnectivity via a consolidated type hierarchy and XML

We propose building a software system that passes any message type between legacy Command, Control, Communications, Computer, Intelligence, Surveillance and Reconnaissance (C4ISR) systems. The software system presents significant cost savings to the Department of Defense (DoD) because it allows us continued use of already purchased systems without changing the system itself. In the midst of the information age, the DoD cannot get information to the warfighter. We still maintain and use heterogeneous legacy systems, which send limited information via a set of common messages developed for a specific domain or branch of DoD. Our ability to communicate with one message format does not meet our needs today, though these stovepipe C4ISR systems still provide vital information. By combining these systems, we will have a synergistic effect on our information operations because of the shared information. Our translator will resolve data representational differences between the legacy systems using a model entitled the Common Type Hierarchy (CTH) . The CTH stores the relationships between different data representations and captures what is needed to perform translations between the different representations. We will use the platform neutral extensible Mark-up Language (XML) as an enabling technology for the CTH modelhttp://www.archive.org/details/interconnectivit00lyttCaptain, United States ArmyLieutenant, United States NavyApproved for public release; distribution is unlimited