MODEL OF SEMANTIC INTEGRATION OF INFORMATION SYSTEMS PROPERTIES IN RELAY DATABASE REENGINEERING PROBLEMS
DOI:
https://doi.org/10.30837/ITSSI.2020.14.005Keywords:
data model, data semantics, database, data integration, heterogeneous information systemAbstract
The subject of research is methods of semantic integration of subject areas of heterogeneous information systems and distributed databases. This class of systems are created on the basis of database technologies, are widespread and used in all areas of economic activity. Such systems are characterized by high complexity of design, maintenance and modification. The purpose of the research is the development of a subject area model based on the semantic properties and relationships of data elements; development of effective technology of integration of information resources of heterogeneous computer systems on the basis of technology of management of database systems; research and formalization of classes of inhomogeneity of data structures aimed at solving the problem of determining the types of information objects. Development of tools for the design and maintenance of application problems for the integration of heterogeneous information systems and distributed databases. Results: the analysis of existing methods and models of integration of subject areas on the basis of semantic properties and connections of data elements is carried out; developed an effective mathematical model, technology and algorithm for semantic integration of information resources of heterogeneous computer systems for relational databases; investigated and formalized classes of inhomogeneity of data structures aimed at solving the problem of determining the types of information objects; the model is developed and means of the logical description of properties of information objects for definition of border of the considered subject area are investigated. Conclusion: the article considers a formalized infographic model of the subject area, which focuses on the semantic relationships between information objects of databases. An axiomatic approach to the description of the subject area is formulated, which allows to consider the problem of modeling the relations of the elements of the subject area in the form of a set of rules that determine the existence of data elements. On the basis of the analysis of structures and models of databases of information systems the general approach to construction of the universal technology focused on the decision of problems of management of heterogeneous information resources of computer systems is defined.
References
Cycritis, D., Lokhovsky, F. (1985), Data Models : Trans. from English, Мoscow, Finance and Statistics, 344 p.
Maltsev, A. I. (1970), Algebraic systems, Мoscow, Nauka, 392 p.
Martin, J. (1980), Database Organization in Computing Systems :Tr. from English, Мoscow, Mir, 662 p.
Buslіk, M. M. (1993), Optimal image of a real database : Monograph, Кyiv, ІSDO, 84 p.
Date, K. (2001), Introduction to database systems : trans. from English, Мoscow, Publishing House "Williams", 1072 p.
Tanyanskiy, S. (2005), "Semanticheskaya model' predmetnoyoblasti v zadachakh integratsii neodnorodnykh informatsionnykh sistem", Vestnik Khersonskogo Natsional'nogo tekhnicheskogo universiteta, Kherson, No 1 (21), P. 52–59.
Yesin, V. I. (2012), "Reinzhynirynh isnuyuchykh baz danykh", Systemy obrobkyynformatsyy, KHNU im. V. N. Karazina, Kharkiv, Vol. 2, No. 3 (101), P. 188–191.
Avrunin, O. G., Bodianskyi, Ye. V., Kalashnyk, M. V., Semenets, V. V., Filatov, V. O. (2018), Suchasni intelektualni tekhnolohii funktsionalnoi medychnoi diahnostyky, KhNURE, Kharkiv, 236 p. DOI: 10.30837/978-966-659-236-4.
Bermúdez Ruiz, F. J., García Molina, J., Díaz García, O. (2017), "On the application of model-driven engineering in data reengineering", Information Systems, No. 72, P. 136–160. DOI: 10.1016/j.is.2017.10.004.
Blackstock, S., Salami, B., Cummings, G. G. (2018), "Organisational antecedents, policy and horizontal violence among nurses: An integrative review", Journal of Nursing Management, No. 26 (8), P. 972–991. DOI: 10.1111/jonm.12623.
Filatov, V., Rudenko, D. Grinyova, E. (2014), "Means of integration of heterogeneous data corporate information and telecommunication systems", Proceedings of the 24th International Crimean Conference Microwave and Telecommunication Technology (CriMiCo-2014), 7-13 sept. 2014, Sevastopol, Ukraine, P. 399–400.
Fioravanti, S., Mattolini, S., Patara, F., Vicario, E. (2016), "Experimental performance evaluation of different data models for a reflection software architecture over NoSQL persistence layers", Paper presented at the ICPE 2016 - Proceedings of the 7th ACM/SPEC International Conference on Performance Engineering, P. 297–308. DOI: 10.1145/2851553.2851561.
Glava, M., Malakhov, V. (2018), "Information Systems Reengineering Approach Based on the Model of Information Systems Domains", International Journal of Software Engineering and Computer Systems (IJSECS), University Malaysia Pahang, Vol. 4, Р. 95–105. DOI: 10.15282/ijsecs.4.1.2018.8.0041.
Tsalenko, M. Sh. (1989), Modeling semantics in databases, Мoscow, Nauka, 288 p.
Filatov, V., Radchenko, V. (2015), "Reengineering relational database on analysis functional dependent attribute", Proceedings of the X Intern. Scient. and Techn. Conf. "Computer Science & Information Technologies" (CSIT’2015), 14-17 sept. 2015, Lviv, Ukraine, P. 85–88.
Kosenko, V. (2017), "Principles and structure of the methodology of risk-adaptive management of parameters of information and telecommunication networks of critical application systems", Innovative Technologies and Scientific Solutions for Industries, No. 1 (1), P. 46–52. DOI: https://doi.org/10.30837/2522-9818.2017.1.046.
Korneev, V. V., Gareev, A. F., Vasyutin, S. V., Reich, V. V. (2001), Database, Intellectual information processing, 2nd ed., Мoscow, Nolidge, 496 p.
Dubois, D., Prades, A. (1990), Theory of opportunities. Applications to the representation of knowledge in computer science, Мoscow, Radio and communication, 288 p.
Filatov, V., Semenets, V. (2018), "Methods for Synthesis of Relational Data Model in Information Systems Reengineering Problems", Proceedings of the International Scientific-Practical Conference "Problems of Infocommunications. Science and Technology" (PIC S&T-2018), 9-12 oct. 2018, Kharkiv, Ukraine, P. 247–251.
Filatov, V., Kovalenko, A. (2020), Fuzzy systems in data mining tasks. DOI: 10.1007/978-3-030-35480-0_6.
Sichkarenko, V. A. (2002), SQL 99 Database Developer Guide, Мoscow, DiaSoftUP, 816 p.
Filatov, V. (2014), "Fuzzy models presentation and realization by mean sof relational systems", Econtechmod:aninternational quarterly journal on economics in technology, new technologies and modelling processes, Lublin, Rzeszow, Vol. 3, No. 3, P. 99–102.
Filatov, V. A. (2004), Mul'tiagentnyye tekhnologii integratsii geterogennykh in formatsionnykh system I raspredelennykh baz dannykh, Dis. d-ratekhn. nauk: 05.13.06, KHNURE, Kharkiv, Ukraine, 341 p.
Rumbaugh, J., Blaha, M. (1991), Object-Oriented Modeling and Design, N. J., Prentice Hall, 348 p.
Maatuk, A. M., Ali, M. A., Aljawarneh, S. (2015), "An algorithm for constructing XML schema documents from relational databases", Paper presented at the ACM International Conference Proceeding Series, 24-26 September-2015. DOI: 10.1145/2832987.2833007.
Maran, V., Augustin, I., Machado, G. M., Lima, J. C. D., Machado, A., De Oliveira, J. P. M. (2017), "Database ontology-supported query for ubiquitous environments", Paper presented at the WebMedia 2017 - Proceedings of the 23rd Brazillian Symposium on Multimedia and the Web, P. 185–188. DOI: 10.1145/3126858.3131575.
Maran, V., Machado, A., Machado, G. M., Augustin, I., de Oliveira, J. P. M. (2018), "Domain content querying using ontology-based context-awareness in information systems", Data and Knowledge Engineering, No. 115, P. 152–173. DOI: 10.1016/j.datak.2018.03.003.
Rob, P., Coronel, K. (2004), Database Systems: Design, Implementation, and Management : Trans. from English, SPb., BHV- Petersburg, 1023 p.
Langefors, B. (1980), "Infological models and information user views", Inform. Systems, Vol. 5, P. 17–32.
Pérez-Castillo, R., De Guzmán, I. G. R., Caivano, D., Piattini, M. (2012), "Database schema elicitation to modernize relational databases", Paper presented at the ICEIS 2012 - Proceedings of the 14th International Conference on Enterprise Information Systems, P. 126–132.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2020 Oleg Avrunin, Oleksiy Vlasov, Valentin Filatov
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Our journal abides by the Creative Commons copyright rights and permissions for open access journals.
Authors who publish with this journal agree to the following terms:
Authors hold the copyright without restrictions and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License (CC BY-NC-SA 4.0) that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
Authors are able to enter into separate, additional contractual arrangements for the non-commercial and non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
Authors are permitted and encouraged to post their published work online (e.g., in institutional repositories or on their website) as it can lead to productive exchanges, as well as earlier and greater citation of published work.