0


针对OBDA的SPARQL OPTIONAL的有效处理

Efficient Handling of SPARQL OPTIONAL for OBDA
课程网址: http://videolectures.net/iswc2018_cogrel_efficient_sparql_obda/  
主讲教师: Benjamin Cogrel
开课单位: 博赞博尔扎诺自由大学
开课时间: 2018-11-22
课程语种: 英语
中文简介:
OPTIONAL是SPARQL中处理缺失信息的关键特性。虽然该运算符被广泛使用,但它也以其复杂性而闻名,这使得使用OPTIONAL高效地评估查询变得困难。在本文中,我们在标准的基于本体的数据访问(OBDA)设置中解决了这一挑战,其中数据存储在SQL关系数据库中,并通过R2RML映射作为虚拟RDF图公开。我们从SPARQL的一个片段到关系代数(RA)的简洁翻译开始,它充分尊重包语义和三值逻辑。这种转换依赖于LEFT JOIN运算符和联合函数的广泛使用。然后,我们提出了一些优化技术,以减少生成的SQL查询的大小并改进其结构。我们的优化捕获了JOIN、LEFT JOIN、联合和数据库完整性约束(如属性可空性和唯一性)以及外键约束之间的交互。最后,我们在几个OBDA基准上实证验证了我们的技术的有效性。
课程简介: OPTIONAL is a key feature in SPARQL for dealing with missing information. While this operator is being used extensively, it is also known for its complexity, which can make it challenge to evaluate queries with OPTIONAL efficiently. In this paper, we tackle this challenge in the standard Ontology-Based Data Access (OBDA) setting, where the data is stored in a SQL relational database and is exposed as a virtual RDF graph by the means of an R2RML mapping. We start with a succinct translation of a fragment of SPARQL into Relational Algebra (RA) that fully respects bag semantics and three-valued logic. This translation relies on extensive use of the LEFT JOIN operator and coalesce function. We then propose a number of optimisation techniques for reducing the size and improving the structure of generated SQL queries. Our optimisations capture interactions between JOIN, LEFT JOIN, coalesce and database integrity constraints such as attribute nullability and uniqueness, and foreign key constraints. Finally, we empirically verify effectiveness of our techniques over several OBDA benchmarks.
关 键 词: SPARQL中处理缺失信息; 运算符被广泛使用; R2RML映射; 虚拟RDF图公开
课程来源: 视频讲座网
数据采集: 2023-01-11:cyh
最后编审: 2023-01-11:cyh
阅读次数: 24