Advertisement

Using the Linked Data for Building of the Production Capacity Planning System of the Aircraft Factory

  • Nadezhda Yarushkina
  • Anton RomanovEmail author
  • Aleksey Filippov
Conference paper
  • 14 Downloads
Part of the Advances in Intelligent Systems and Computing book series (AISC, volume 1156)

Abstract

The basic principles of data consolidation of the production capacities planning system of the large industrial enterprise are formulated in this article. The article describes an example of data consolidation process of two relational databases (RDBs). The proposed approach involves using of ontological engineering methods for extracting metadata (ontologies) from RDB schemas. The research contains an analysis of approaches to the consolidation of RDBs at different levels. The merging of extracted metadata is used to organize the data consolidation process of several RDBs. The difference between the traditional and the proposed data consolidation algorithms is shown, their advantages and disadvantages are considered. The formalization of the integrating data model as system of extracted metadata of RDB schemas is described. Steps for integrating data model building in the process of ontology merging is presented. An example of the integrating data model building as settings for data consolidation process confirms the possibility of practical use of the proposed approach in the data consolidation process.

Keywords

Relational databases Data model schema Metadata Ontology Ontology merging Data consolidation Integrating data model Production capacity planning system 

Notes

Acknowledgments

The study was supported by:

– the Ministry of Science and Higher Education of the Russian Federation in framework of projects 2.4760.2017/8.9 and 2.1182.2017/4.6;

– the Russian Foundation for Basic Research (Projects No. 18-47-732016, 18-47-730022, 17-07-00973, No. 18-47-730019).

References

  1. 1.
    Clark, T., Barn, B.S., Oussena, S.: A method for enterprise architecture alignment. In: Practice-Driven Research on Enterprise Transformation, pp. 48–76. Springer (2012)Google Scholar
  2. 2.
    Rouhani, D.B., et al.: A systematic literature review on enterprise arquitecture implementation methhodologies. Inf. Softw. Technol. 62, 1–20 (2015)CrossRefGoogle Scholar
  3. 3.
    Medini, K., Bourey, J.P.: SCOR-based enterprise architecture methodology. Int. J. Comput. Integr. Manuf. 25, 594–607 (2012)CrossRefGoogle Scholar
  4. 4.
    Poduval, A., et al.: Do More with SOA Integration: Best of Packt. Packt Publishing Ltd, Birmingham, UK (2011)Google Scholar
  5. 5.
    Caselli, V., Binildas, C., Barai, M.: The Mantra of SOA. Service Oriented Architecture with Java, Birmingham, UK (2008)Google Scholar
  6. 6.
    Berna-Martinez, V.J., Zamora, C., Ivette, C., Pérez, M., Paz, F., Paz, L., Ramón, C.: Method for the integration of applications based on enterprise service bus technologies. https://www.wseas.org/multimedia/journals/computers/2018/a445905-1342.pdf. Accessed 20 July 2019 (2018)
  7. 7.
    Bizer, C., Heath, T., Berners-Lee, T.: Linked Data - The Story So Far. http://tomheath.com/papers/bizer-heath-berners-lee-ijswis-linked-data.pdf. Accessed 20 July 2019
  8. 8.
    Gruber, T.: Ontology. http://tomgruber.org/writing/ontology-in-encyclopedia-of-dbs.pdf. Accessed 20 July 2019
  9. 9.
    de Laborda, C.P., Conrad, S.: Relational.OWL: a data and schema representation format based on owl. In: Proceedings of the 2nd Asia-Pacific Conference on Conceptual Modelling, vol. 43, pp. 89–96. Australian Computer Society, Inc (2005)Google Scholar
  10. 10.
    Trinh, Q., Barker, K., Alhajj, R.: RDB2ONT: a tool for generating OWL ontologies from relational database systems. In: International Conference on Internet and Web Applications and Services/Advanced International Conference on Telecommunications 2006, AICT-ICIW 2006, p. 170. IEEE (2006)Google Scholar
  11. 11.
    Trinh, Q., Barker, K., Alhajj, R.: Semantic interoperability between relational database systems. In: 11th International Database Engineering and Applications Symposium, IDEAS 2007, pp. 208–215. IEEE (2007)Google Scholar
  12. 12.
    Barrett, T., Jones, D., Yuan, J., Sawaya, J., Uschold, M., Adams, T., Folger, D.: RDF representation of metadata for semantic integration of corporate information resources. In: International Workshop Real World and Semantic Web Applications, vol. 2002. Citeseer (2002)Google Scholar
  13. 13.
    Bizer, C.: D2R MAP – a database to RDF mapping language. In: Proceedings of the 12th International World Wide Web Conference – Posters (2003)Google Scholar
  14. 14.
    Calvanese, D., Cogrel, B., Komla-Ebri, S., Kontchakov, R., Lanti, D., Rezk, M., Rodriguez-Muro, M., Xiao, G.: Ontop: answering SPARQL queries over relational databases. Semant. Web J. 8, 471–487 (2017)CrossRefGoogle Scholar
  15. 15.
    Yarushkina, N., Romanov, A., Filippov, A., Guskov, G., Grigoricheva, M., Dolganovskaya, A.: The building of the production capacity planning system for the aircraft factory. In: Research Papers Collection Open Semantic Technologies for Intelligent Systems, issue 3, pp. 123–128 (2019)Google Scholar
  16. 16.
    Yarushkina, N., Romanov, A., Filippov, A.: Using ontology engineering methods for organizing the information interaction between relational databases. In: Kuznetsov, S., Panov, A. (eds.) Artificial Intelligence, RCAI. Communications in Computer and Information Science, vol. 1093. Springer, Cham (2019)Google Scholar
  17. 17.
    Alley, G.: Database Migration Tools. In Database Zone (2019). https://dzone.com/articles/database-migration-tools-1. Accessed 20 July 2019
  18. 18.
    Protege — Free open-source ontology editor. https://protege.stanford.edu/. Accessed 20 July 2019

Copyright information

© Springer Nature Switzerland AG 2020

Authors and Affiliations

  • Nadezhda Yarushkina
    • 1
  • Anton Romanov
    • 1
    Email author
  • Aleksey Filippov
    • 1
  1. 1.Ulyanovsk State Technical UniversityUlyanovskRussian Federation

Personalised recommendations