论文标题

朝着从关系数据库到属性图的完整直接映射

Towards a Complete Direct Mapping From Relational Databases To Property Graphs

论文作者

Boudaoud, Abdelkrim, Mahfoud, Houari, Chikh, Azeddine

论文摘要

找到通过图模型表示的复杂数据越来越普遍。与关系模型相反,图形为执行复杂数据的分析任务提供了高容量。由于仍然在关系表中介绍了大量数据,因此有必要了解如何将这些数据转换为图。本文提出了一个完整的映射过程,该过程允许将任何关系数据库(架构和实例)转换为属性图数据库(架构和实例)。与现有映射相反,我们的解决方案保留了三个基本映射属性,即:信息保存,语义保存和查询保存。此外,我们研究将所有SQL查询映射到等效的Cypher查询中,这使我们的解决方案实用。现有的解决方案要么是不完整的,要么基于非执行查询语言。因此,这项工作是将关系映射到图形的第一个完整且实用的解决方案。

It is increasingly common to find complex data represented through the graph model. Contrary to relational models, graphs offer a high capacity for executing analytical tasks on complex data. Since a huge amount of data is still presented in terms of relational tables, it is necessary to understand how to translate this data into graphs. This paper proposes a complete mapping process that allows transforming any relational database (schema and instance) into a property graph database (schema and instance). Contrary to existing mappings, our solution preserves the three fundamental mapping properties, namely: information preservation, semantic preservation and query preservation. Moreover, we study mapping any SQL query into an equivalent Cypher query, which makes our solution practical. Existing solutions are either incomplete or based on non-practical query language. Thus, this work is the first complete and practical solution for mapping relations to graphs.

扫码加入交流群

加入微信交流群

微信交流群二维码

扫码加入学术交流群,获取更多资源