|
|
基于RDB-RDF模式映射的数据转换方法研究
|
Abstract:
随着语义web的发展，现代web希望数据能够采用资源描述框架(RDF)的格式，这是一种机器可读的形式，能够在无需人工干预的情况下共享和重用数据。但是目前大多数数据仍然存储在关系数据库中，现有的将关系数据转换为资源描述框架的方法由于映射不佳，未能产生预期的结果，因此，本文提出了一种基于RDB-RDF模式映射的数据转换方法，从形式化定义出发，使用模式映射，借助于映射描述，结合数据物化和按需映射，避免数据全部转储的方法，使SPARQL查询转换为SQL查询时简单便捷，提高转换效率和数据检索时间。此外本方法还对关系数据库进行了扩充，能够实现对象关系数据库转换为资源描述框架。最后给出方法的整体思路，各项结果表明，新的方法既能够保持语义，又能够提高速度，实现了比传统方法更加易于理解的映射方法。
With the development of semantic web, modern web expects data to be in Resource Description Framework (RDF) format, which is a machine-readable form that enables sharing and reusing data without human intervention. However, most of the data are still stored in relational databases, and existing methods for converting relational data to Resource Description Framework fail to produce the desired results due to poor mapping, therefore, in this paper, we propose a data conversion method based on RDB-RDF schema mapping, using from formal definitions, schema mapping with the help of mapping descriptions, and combining data materialization and on-demand mapping, to avoid all data dumping, the method makes the conversion of SPARQL query to SQL query simple and convenient and improves the conversion efficiency and data retrieval time. In addition, this method also extends the relational database, which can realize the conversion of object-relational database to resource description framework. Finally, the overall idea of the method is given, and the results show that the new method is able to maintain the semantics and improve the speed, and realize the mapping method which is easier to understand than the traditional method.
| [1] | Berners-Lee, T., Hendler, J. and Lassila, O. (2001) The Semantic Web. Scientific American, 284, 34-43.
https://www.scientificamerican.com/article/the-semantic-web
https://doi.org/10.1038/scientificamerican0501-34 |
| [2] | Nesrine, L., Mimoun, M., Ahmed, L., et al. (2017) On De-mand ETL of RDB to RDF Mapping for Linked Enterprise Data. International Journal of Strategic Information Tech-nology and Applications, 8, 91-100.
http://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/IJSITA.2017070106
https://doi.org/10.4018/IJSITA.2017070106 |
| [3] | Arenas-Guerrero, J., Scrocca, M., Iglesias-Molina, A., et al. (2021) Knowledge Graph Construction with R2RML and RML: An ETL System-Based Overview. |
| [4] | A Direct Map-ping of Relational Data to RDF. https://www.w3.org/TR/rdb-direct-mapping/ |
| [5] | R2RML: RDB to RDF Mapping Language. https://www.w3.org/TR/r2rml/ |
| [6] | Unbehauen, J., Stadler, C. and Auer, S. (2013) Optimizing SPARQL-to-SQL Rewriting. Proceedings of International Conference on Information Integration and Web-Based Ap-plications & Services, Vienna, 2-4 December 2013, 324-330.
https://doi.org/10.1145/2539150.2539247 |
| [7] | Zhang, F., Ma, Z.M. and Yan, L. (2011) Construction of Ontolo-gies from Object-Oriented Database Models. Integrated Computer Aided Engineering, 18, 327-347. |
| [8] | Idrissi, B.E. (2022) RDF/OWL Storage and Management in Relational Database Management Systems: A Comparative Study. Jour-nal of King Saud University—Computer and Information Sciences, 34, 7604-7620.
https://doi.org/10.1016/j.jksuci.2021.08.018 |
| [9] | 张永威, 张岩, 唐新余, 等. 关系型数据的知识抽取和RDF转换框架及实现[J/OL]. 计算机工程与应用, 2022, 58(17): 213-223.
https://kns.cnki.net/kcms2/article/abstract?v=3uoqIhG8C44YLTlOAiTRKibYlV5Vjs7iJTKGjg9uTdeTsOI_ra5_XQaS6ni5SKIh-2f6XO3TvG8CVmb6O0b3JVH9tVEoYw7r&uniplatform=NZKPT |
| [10] | Siow, E., Tiropanis, T. and Hall, W. (2016) SPARQL-to-SQL on Internet of Things Databases and Streams. In: Groth, P., Simperl, E., Gray, A., et al., Eds., The Semantic Web—ISWC 2016, Vol. 9981, Springer International Publishing, Cham, 515-531. https://link.springer.com/10.1007/978-3-319-46523-4_31
https://doi.org/10.1007/978-3-319-46523-4_31 |
| [11] | Pequeno, V.M., Vidal, V.M.P., Casanova, M.A., et al. (2014) Specifying Complex Correspondences between Relational Schemas and RDF Models for Generating Customized R2RML Mappings. In: Proceedings of the 18th International Database Engineering & Applications Symposium on IDEAS’14, ACM Press, Porto, 96-104.
http://dl.acm.org/citation.cfm?doid=2628194.2628233
https://doi.org/10.1145/2628194.2628233 |
| [12] | Sengupta, K., Haase, P., Schmidt, M., et al. (2013) Editing R2RML Mappings Made Easy. |
| [13] | Sequeda, J., Tirmizi, S., Corcho, O. and Miranker, D. (2011) Survey of Directly Mapping SQL Databases to the Semantic Web. The Knowledge Engineering Review, 26, 445-486.
https://www.cambridge.org/core/journals/knowledge-engineering-review/article/abs/survey-of-directly-mapping-sql-databases-to-the-semantic-web/0688CCA9A831376C4EE5DCE09382563B |
| [14] | 鲁佳文, 严丽. 对象关系数据库到RDF(S)的映射方法[J]. 计算机科学, 2021, 48(10): 145-151. |
| [15] | Hazber, M.A.G., Li, R., Xu, G., et al. (2016) An Approach for Automatically Generating R2RML-Based Direct Mapping from Relational Databases. In: Che, W., Han, Q., Wang, H., et al., Eds., Social Computing, Vol. 623, Springer, Singapore, 151-169. http://link.springer.com/10.1007/978-981-10-2053-7_15
https://doi.org/10.1007/978-981-10-2053-7_15 |
| [16] | Mathur, S.N., O’Sullivan, D. and Brennan, R. (2018) Milan: Automatic Generation of R2RML Mappings. |
| [17] | 王嘉庆, 杨卫东, 何亦征. 关系数据库的实体间关系提取方法的研究[J]. 计算机应用与软件, 2019, 36(10): 10-16, 38. |
| [18] | Michel, F., Montagnat, J. and Faron-Zucker, C. (2014) A Survey of RDB to RDF Translation Approaches and Tools. |
| [19] | SPARQL by Example. https://www.w3.org/2009/Talks/0615-qbe/ |
| [20] | Abatal, A., Alaoui, K., Alaoui, L., et al. (2019) SQL2SPARQL4RDF: Automatic SQL to SPARQL Conversion for RDF Querying. In: Proceedings of the 4th International Conference on Big Data and Internet of Things, ACM, Rabat, 1-9. https://doi.org/10.1145/3372938.3372968 |
| [21] | Natarajan, S., Vairavasundaram, S., Teekaraman, Y., et al. (2021) Schema-Based Mapping Approach for Data Transformation to En-rich Semantic Web. Wireless Communications and Mobile Computing, 2021, Article ID: 8567894.
https://www.hindawi.com/journals/wcmc/2021/8567894/
https://doi.org/10.1155/2021/8567894 |
