Approaches and problems of data exchange between information systems
Keywords:
data, metadata, data exchange, OLTP, OLAP, namespaceAbstract
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.
References
[2] ISO/IEC 2382:2015 Information technology. Vocabulary (2015).
[3] Codd, Edgar F. Providing OLAP to User-Analysts: An IT Mandate // Computerworld. – V. 27, No 30 (1993) : 26.
[4] Codd Edgar F. «A relational model of data for large shared data banks», Comm. ACM, V. 13, No 6 (1970) : 377-387.
[5] Chernyak L. Zadachi upravleniya master-dannyimi [Master data management tasks]», Otkryityie sistemyi, No 5 (2007) : 54-62.
[6] Ofitsialnyiy sayt proekta NIEM [Official website of the project NIEM. Electronic resource], 2006. http://www.niem.gov.
[7] Pristsilla Uolmsli. Sozdanie IEPD NIEM. Modelirovanie sistemyi obmena informatsiey NIEM [Create IEPD NIEM. Modeling the information exchange system NIEM. Electronic resource], 2010. http://www.ibm.com.
[8] Ofitsialnyiy sayt formata obmena dannyimi SDMX [Official website of the Data Exchange Format SDMX. Electronic resource], 2006. http://www.sdmx.org.
[9] Akatkin Yu., Drozhzhinov V., Konyavskiy V. «Standartyi modeley dannyih dlya obmena informatsiey kak instrument importozamescheniya v strategicheskih informatsionnyih sistemah [Standards of data models for information exchange as an instrument for import substitution in strategic information systems]», No 16 (871), (2014) : 26-52.
[10] Ofitsialnyiy sayt protokola FIX http://www.fixtradingcommunity.org. [Official website of the protocol FIX. Electronic resource], 2006.
[11] «Razrabotka sinhronizatora TOFI dlya obmena dannyimi i metadannyimi mezhdu informatsionnyimi sistemami: otchet o NIR (promezhutochnyiy) [Development of the TOFI synchronizer for data and metadata exchange between information systems: Report on research work (interjacent)]», AO "Nats. tsentr nauchno-tehn. inform.": ruk. Gabbasov M.B.; ispoln: Kuanov T.D., Abilkaeva Zh.N. i dr. Astana, No GR 0115RK02743 (2015).
[12] Gabbasov M.B. «Ontologiya tehnologii TOFI [Collection of works on information security]», Sbornik trudov po informatsionnoy bezopasnosti. Astana, (2013).
[13] «Razrabotka sinhronizatora TOFI dlya obmena dannyimi i metadannyimi mezhdu informatsionnyimi sistemami: otchet o NIR (promezhutochnyiy) [Development of the TOFI synchronizer for data and metadata exchange between information systems: Report on research work (interjacent)]», AO "Nats. tsentr nauchno-tehn. inform.": ruk. Gabbasov M.B.; ispoln: Kuanov T.D., Abilkaeva Zh.N. i dr. Astana, No GR 0115RK02743 (2016).
