Approaches and problems of data exchange between information systems

Abstract

The exchange of data between two or more information systems has always been an urgent and complex task. Over the past three decades, this task has passed its evolutionary path from a manual mode of exchange to the possibility of automatic data exchange between systems. In this paper, various modern technologies are considered for the organization of data exchange between information systems, including between OLTP and OLAP-systems. The description of technologies ETL, MDM and technologies based on namespaces, including "The synchronizer TOFI" , developed in the System Research Company "Factor". The formal notion of "data" used in TOFI technology, the TOFI namespace and the functionality of the TOFI synchronizer for data and metadata exchange are described in detail. Functionally, the synchronizer compares the metadata of various information systems based on coding systems, automatically (on schedule) or manually generates metadata, exchanges metadata with other systems, generates data for transmission to another system, receives and transmits a data set from / to another (s) Information system (s), etc. Data exchange based on the TOFI namespace can be performed in an automatic mode based on metadata synchronization.