Building an Integrated Information System that Mergethe Databases of Companies Providing Cargo Carriers

Cover Page

Abstract


The task of integrating information contained in databases of various companies that providecargo carriers is considered in the article. It is assumed that these companies are independentand each of them maintains its own database about its employees, customers, number and pa-rameters of carries, services and orders. The article simulates three such independent databases(information sources) and describes a scheme for constructing an integrated system based onthem, in particular, for the convenience of customers when searching for carriers with the neces-sary parameters (dimensions and load-carrying capacity). To solve this problem, it is proposedto use an approach combining the advantages of mediator and data repository technologies. Itis assumed that all sources have similar conceptual schemes, but they have their own specificcharacteristics. In particular, there may be different names of tables and attributes in differ-ent sources and different distribution of attributes throw tables. Certain attributes may alsobe absent at some sources. We construct correspondence tables and a mediator that translateuser queries to the sources. To identify the necessary sources, a small auxiliary repository ismaintained that contains information about the parameters of the carriers that each source has.The user of the integrated system enters data on the weight and dimensions of his cargo, then,using the information of the repository, the system determines the appropriate trucking compa-nies to which the user request is broadcast. After combining all the answers that came from thesources, the client receives full information with a list of suitable companies, prices and otherconditions for the execution of the order.


A S Pankratov

Principal contact for editorial correspondence.
pankratov_as@rudn.university
Information Technologies Department Peoples’ Friendship University of Russia (RUDN University) 6 Miklukho-Maklaya St., Moscow, 117198, Russian Federation

Pankratov A. S. - Candidate of Physical and Mathematical Sciences, associate professor of Informational Technologies Department of Peoples’ Friendship University of Russia (RUDN University)

A Mazri

psheunov.a@yandex.ru
Information Technologies Department Peoples’ Friendship University of Russia (RUDN University) 6 Miklukho-Maklaya St., Moscow, 117198, Russian Federation

Mazri A. - student of Informational Technologies Department of Peoples’ Friendship University of Russia (RUDN University)

  • T. Connolly, C. Begg, Database Systems: A Practical Approach to Design, Implementation, and Management, Williams, Moscow, 2003.
  • H. Garsia-Molina, J. Ullman, J. Widom, Database Systems: The Complete Book, Williams, Moscow, 2003.
  • D. V. Torshin, Organization of an United, Integrated Space Based on Data Exchange Universal Format, Scientific and technical sheets of St-Petersburg Polytechnic University. Series: Information Sciences. Telecommunications. Management 71 (2) (2009) 26–32, in Russian.
  • L. Chernyak, Data Integration: Syntax and Semantics, Open Systems. DBMS (10) (2009) 24–29, in Russian.
  • S. V. Kirsanov, V. N. Kovalenko, E. I. Kovalenko, A. Y. Kulikov, M. A. Shifrin, The Technology of Integration of Medical Image Archives, Doctor and Information Technology (2) (2013) 59–70, in Russian.
  • A. S. Pankratov, Integration Technology of Heterogeneous Databases Exampled by Consolidation of Electronic Medical Cards, Artificial Intelligence and Decision Making (4) (2011) 60–67, in Russian.
  • A. M. Valuev, A. S. Pankratov, Modern Technologies for Information Integration from Independed Databases and Ways for Application in the Problems of Planning and Management, Mining informational and analytical bulletin (scientific and technical journal) (7) (2013) 170–174, in Russian.
  • A. S. Pankratov, A. Kh. Psheunov, Modern Technologies Integration of Information from Independent Sources and Their Using for the Construction of an Information System that Combines Transport Timetables, Bulletin of Russian Peoples’ Friendship University. Series: Mathematics, Information Sciences and Physics (3) (2017) 232–242, in Russian.
  • M. Coveney, D. Ganster, B. Hartlen, D. King, The Strategy Gap: Leveraging Technology to Execute Winning Strategies, Alpina Business Books, Moscow, 2004, in Russian.

Views

Abstract - 30

PDF (Russian) - 4


Copyright (c) 2017 Pankratov A.S., Mazri A.

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.