An investigation of methods and technologies to integrate an ontological model and relational data
A study of methods and technological solutions on Data Mapping concerning the integration of an ontological and relational data models has been carried out.The main objective of the investigation is to accelerate and reduce the cost of constructing some ontological models for systems that process di...
Збережено в:
| Дата: | 2018 |
|---|---|
| Автори: | , , |
| Формат: | Стаття |
| Мова: | Ukrainian |
| Опубліковано: |
Інститут проблем реєстрації інформації НАН України
2018
|
| Теми: | |
| Онлайн доступ: | http://drsp.ipri.kiev.ua/article/view/158518 |
| Теги: |
Додати тег
Немає тегів, Будьте першим, хто поставить тег для цього запису!
|
| Назва журналу: | Data Recording, Storage & Processing |
Репозитарії
Data Recording, Storage & Processing| id |
drspiprikievua-article-158518 |
|---|---|
| record_format |
ojs |
| spelling |
drspiprikievua-article-1585182019-12-27T02:04:16Z An investigation of methods and technologies to integrate an ontological model and relational data Дослідження методів і технологій інтеграції онтологічної моделі з реляційними даними Senchenko, V. R. Boychenko, O. A. Boychenko, A. V. ontological model relational model OWL SQL SPARQL data management financial control state budget Protégé 5 онтологічна модель реляційна модель OWL SQL SPARQL контроль державного бюджету Protégé 5 A study of methods and technological solutions on Data Mapping concerning the integration of an ontological and relational data models has been carried out.The main objective of the investigation is to accelerate and reduce the cost of constructing some ontological models for systems that process distributed data in a heterogeneous environment.At present, the theoretical basis for the integration of various data models (Data Mapping) is a di-rection that has been defined as Ontology-based data integration. The theoretical and practical develop-ment of this area is the Ontology-Based Data Access (OBDA) approach, which integrates ontological models presented in the form of RDF graphs with relational data.The methodology of Data Mapping application for distributed data processing systems has been developed. As an example the process of data models consolidation for Ukrainian State Budget monitor-ing system is given. The database of Ukrainian State Budget monitoring system consists of many rela-tional tables, which contain reports of the State Treasury on the implementation of revenue and expendi-ture parts of both state and municipal budgets, as well as the regional section. In addition, the database contains data on lending and arrears of budget institutions.The ontology model connects to data sources through a declarative specification provided in terms of display, including classes and their properties.The given application converts a SPARQL queries into a SQL query to the relational database. The generated SQL query may be execute by the Oracle 11g database driver, which returns the result as a data snapshot. Then, to improve the performance of SPARQL queries, it should be used the semantic query optimization method.Indicative application of the methodology on the example of the construction of an ontological model of the system of monitoring the state budget of Ukraine in Protege 5. It has been demonstrated the results of the execution of the SPARQL-queries to the relational data of the budget process under the Oracle 11g Database. It has been shown the directions semantic optimization for SPARQL-queries, which allow improving obtained data quality.The proposed methodology allows: to integrate data presented by different models — ontological and relational knowledge acquisition; to overcome constraints when databases based on outdated data models are being merged with modern ontological-oriented systems; to eliminate data redundancy in designing knowledge-based systems. Проведено дослідження методів і технологічних рішень щодо інтеграції онтологічної моделі з реляційними даними — Data Mapping. Основною метою є прискорення та зменшення вартості побудови онтологічних моделей систем, які оперують з розподіленими даними в гетерогенному середовищі. Запропоновано методологію застосування методів Data Mapping для систем обробки розподілених даних на прикладі побудови онтологічної моделі системи моніторингу Державного бюджету України. Показано напрями семантичної оптимізації SPARQL-запитів, які дозволяють поліпшити якість отриманих даних. Інститут проблем реєстрації інформації НАН України 2018-09-18 Article Article application/pdf http://drsp.ipri.kiev.ua/article/view/158518 10.35681/1560-9189.2018.20.3.158518 Data Recording, Storage & Processing; Vol. 20 No. 3 (2018); 91–101 Регистрация, хранение и обработка данных; Том 20 № 3 (2018); 91–101 Реєстрація, зберігання і обробка даних; Том 20 № 3 (2018); 91–101 1560-9189 uk http://drsp.ipri.kiev.ua/article/view/158518/157873 Авторське право (c) 2021 Реєстрація, зберігання і обробка даних |
| institution |
Data Recording, Storage & Processing |
| collection |
OJS |
| language |
Ukrainian |
| topic |
ontological model relational model OWL SQL SPARQL data management financial control state budget Protégé 5 онтологічна модель реляційна модель OWL SQL SPARQL контроль державного бюджету Protégé 5 |
| spellingShingle |
ontological model relational model OWL SQL SPARQL data management financial control state budget Protégé 5 онтологічна модель реляційна модель OWL SQL SPARQL контроль державного бюджету Protégé 5 Senchenko, V. R. Boychenko, O. A. Boychenko, A. V. An investigation of methods and technologies to integrate an ontological model and relational data |
| topic_facet |
ontological model relational model OWL SQL SPARQL data management financial control state budget Protégé 5 онтологічна модель реляційна модель OWL SQL SPARQL контроль державного бюджету Protégé 5 |
| format |
Article |
| author |
Senchenko, V. R. Boychenko, O. A. Boychenko, A. V. |
| author_facet |
Senchenko, V. R. Boychenko, O. A. Boychenko, A. V. |
| author_sort |
Senchenko, V. R. |
| title |
An investigation of methods and technologies to integrate an ontological model and relational data |
| title_short |
An investigation of methods and technologies to integrate an ontological model and relational data |
| title_full |
An investigation of methods and technologies to integrate an ontological model and relational data |
| title_fullStr |
An investigation of methods and technologies to integrate an ontological model and relational data |
| title_full_unstemmed |
An investigation of methods and technologies to integrate an ontological model and relational data |
| title_sort |
investigation of methods and technologies to integrate an ontological model and relational data |
| title_alt |
Дослідження методів і технологій інтеграції онтологічної моделі з реляційними даними |
| description |
A study of methods and technological solutions on Data Mapping concerning the integration of an ontological and relational data models has been carried out.The main objective of the investigation is to accelerate and reduce the cost of constructing some ontological models for systems that process distributed data in a heterogeneous environment.At present, the theoretical basis for the integration of various data models (Data Mapping) is a di-rection that has been defined as Ontology-based data integration. The theoretical and practical develop-ment of this area is the Ontology-Based Data Access (OBDA) approach, which integrates ontological models presented in the form of RDF graphs with relational data.The methodology of Data Mapping application for distributed data processing systems has been developed. As an example the process of data models consolidation for Ukrainian State Budget monitor-ing system is given. The database of Ukrainian State Budget monitoring system consists of many rela-tional tables, which contain reports of the State Treasury on the implementation of revenue and expendi-ture parts of both state and municipal budgets, as well as the regional section. In addition, the database contains data on lending and arrears of budget institutions.The ontology model connects to data sources through a declarative specification provided in terms of display, including classes and their properties.The given application converts a SPARQL queries into a SQL query to the relational database. The generated SQL query may be execute by the Oracle 11g database driver, which returns the result as a data snapshot. Then, to improve the performance of SPARQL queries, it should be used the semantic query optimization method.Indicative application of the methodology on the example of the construction of an ontological model of the system of monitoring the state budget of Ukraine in Protege 5. It has been demonstrated the results of the execution of the SPARQL-queries to the relational data of the budget process under the Oracle 11g Database. It has been shown the directions semantic optimization for SPARQL-queries, which allow improving obtained data quality.The proposed methodology allows: to integrate data presented by different models — ontological and relational knowledge acquisition; to overcome constraints when databases based on outdated data models are being merged with modern ontological-oriented systems; to eliminate data redundancy in designing knowledge-based systems. |
| publisher |
Інститут проблем реєстрації інформації НАН України |
| publishDate |
2018 |
| url |
http://drsp.ipri.kiev.ua/article/view/158518 |
| work_keys_str_mv |
AT senchenkovr aninvestigationofmethodsandtechnologiestointegrateanontologicalmodelandrelationaldata AT boychenkooa aninvestigationofmethodsandtechnologiestointegrateanontologicalmodelandrelationaldata AT boychenkoav aninvestigationofmethodsandtechnologiestointegrateanontologicalmodelandrelationaldata AT senchenkovr doslídžennâmetodívítehnologíjíntegracííontologíčnoímodelízrelâcíjnimidanimi AT boychenkooa doslídžennâmetodívítehnologíjíntegracííontologíčnoímodelízrelâcíjnimidanimi AT boychenkoav doslídžennâmetodívítehnologíjíntegracííontologíčnoímodelízrelâcíjnimidanimi AT senchenkovr investigationofmethodsandtechnologiestointegrateanontologicalmodelandrelationaldata AT boychenkooa investigationofmethodsandtechnologiestointegrateanontologicalmodelandrelationaldata AT boychenkoav investigationofmethodsandtechnologiestointegrateanontologicalmodelandrelationaldata |
| first_indexed |
2024-04-21T19:33:59Z |
| last_indexed |
2024-04-21T19:33:59Z |
| _version_ |
1796974092720537600 |