Modern Technologies of Information Integration from Independent Sources and their Application in the Construction of an Information System that Combines Transport Timetables

Abstract


The problem of constructing an integrating system combining bus timetables of different bus depots is considered. We suppose that these bus depots are independent and, possibly, located at different regions of the country. The purpose of this integrated system is, in particular, the easement of finding available bus routes between two given points. To solve this problem, it is proposed to use an approach combining the advantages of mediator and data repository technologies. The article considers a model of three data sources, which are bus depots that display information about their timetables. It is assumed that all sources have similar conceptual schemes, but they have their own specific characteristics. In particular, there may be different names of tables and attributes in different sources and different distribution of attributes throw tables. Also at some sources may be an absence of certain attributes. We construct correspondence tables and a mediator that translate user queries to the sources. To identify the necessary sources, a small auxiliary repository is maintained that contains information about the stop points served by each of the sources. We describe the technology for updating the repository and the executing strategy for the user query, using the information contained in the repository.


A S Pankratov

pankratov_as@rudn.university
<p>Peoples&rsquo; Friendship University of Russia (RUDN University)</p>

6 Miklukho-Maklaya St., Moscow, 117198, Russian Federation

Information Technologies Department

A Kh Psheunov

psheunov.a@yandex.ru
<p>Peoples&rsquo; Friendship University of Russia (RUDN University)</p>

6 Miklukho-Maklaya St., Moscow, 117198, Russian Federation

Information Technologies Department

  • M.S. Vorobyova, Development of the Model of Data Integration in Information and Control Systems, in: V. N. Kuturnov (Ed.), Modernization of education in the context of globalization: Round-table discussion “Education through Science and Innovation”, 2005, sept. 14–15, 2005, pp. 26–28, in Russian.
  • 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” (2(71)) (2009) 26–32, 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.
  • H. Garsia-Molina, J. Ullman, J. Widom, Database Systems: the Complete Book, Williams, 2003.
  • A.M. Valuev, A.A. Yakunkhov, The Task of Choosing the Rational Route using Public Transport, in: Managing the Development of Large-Scale Systems: Proceedings of the Sixth International Conference, Vol. II, Moscow, 2012, pp. 31–33, in Russian.

Views

Abstract - 40

PDF (Russian) - 12


Copyright (c) 2017 Pankratov A.S., Psheunov A.K.

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