arXivDaily arXiv每日学术速递 周一至周五更新
arXiv周末暂无论文更新,休息一下吧,周末愉快~~
arXiv 2104.12615cs.DBhep-ex
收藏

评价高能物理数据的查询语言和系统[扩展版]

Evaluating Query Languages and Systems for High-Energy Physics Data [Extended Version]

Dan Graur, Ingo Müller, Mason Proffitt, Ghislain Fourny, Gordon T. Watts, Gustavo Alonso

摘要:

在高能物理(HEP)领域,一般的查询语言,特别是SQL,已被有限地接受。这是令人惊讶的,因为HEP数据分析很好地匹配了SQL模型:数据是完全结构化的,并且大多使用标准操作符进行查询。为了深入了解为什么会出现这种情况,我们使用HEP基准对六种不同的通用数据处理平台进行了全面分析。评估的结果是现有解决方案的有趣且相当复杂的画面:它们的查询语言在如何表达自然和简洁的HEP查询模式方面差异很大。此外,它们中的大多数也比粒子物理学家今天使用的特定领域系统慢一到两个数量级。这些观察结果表明,虽然数据库系统和它们的查询语言在原则上是可行的工具,为HEP,重要的工作仍然是使他们相关的HEP研究人员。

英文摘要:

In the domain of high-energy physics (HEP), query languages in general and SQL in particular have found limited acceptance. This is surprising since HEP data analysis matches the SQL model well: the data is fully structured and queried using mostly standard operators. To gain insights on why this is the case, we perform a comprehensive analysis of six diverse, general-purpose data processing platforms using an HEP benchmark. The result of the evaluation is an interesting and rather complex picture of existing solutions: Their query languages vary greatly in how natural and concise HEP query patterns can be expressed. Furthermore, most of them are also between one and two orders of magnitude slower than the domain-specific system used by particle physicists today. These observations suggest that, while database systems and their query languages are in principle viable tools for HEP, significant work remains to make them relevant to HEP researchers.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑