arXivDaily arXiv每日学术速递 周一至周五更新
arXiv 2009.10669cs.DB
收藏

没有“指数”这种东西!下一篇:500篇索引论文

There is No Such Thing as an "Index"! or: The next 500 Indexing Papers

Jens Dittrich, Joris Nix, Christian Schön

摘要:

索引结构是查询处理和一般计算机科学的构造块。自从计算机技术出现以来,就有了索引结构。从那时起,每年都有无数的指数结构被发明和发布。在本文中,我们认为,“发明一个指数”的想法是一个误导性的概念摆在首位。它类似于“发明一个物理查询计划”。这篇论文是一个范式转变,我们建议完全放弃手工制作索引结构的想法(就像在B树上的二叉搜索树到任何形式的学习索引一样)。本文提出了一个新的自动索引培育框架--索引结构的遗传生成(GENE).它是基于这样的观察,即几乎所有的索引结构都是沿着三个主要维度组装的:(1)结构构建块,例如,B树由两种不同的结构节点类型(内部节点和叶节点)组装而成,(2)一对不变量,例如,对于B树,所有路径具有相同的长度,以及(3)关于节点的内部布局(行或列布局等)的决定。我们提出了一个通用的索引框架,可以模仿许多现有的索引结构沿这些方面。基于这个框架,我们提出了一个通用的遗传索引生成算法,给定的工作量和优化目标,可以自动组装和变异,换句话说,“繁殖”新的索引结构“物种”。在我们的实验中,我们遵循多个目标。我们重新审视数据库技术中的一些古老的智慧。给定一个特定的工作量,GENE甚至会产生一个索引,相当于我们的教科书和论文目前推荐的这种工作量吗?或者我们可以做得更多?我们的初步结果强烈表明,生成索引是设计索引结构的下一步。

英文摘要:

Index structures are a building block of query processing and computer science in general. Since the dawn of computer technology there have been index structures. And since then, a myriad of index structures are being invented and published each and every year. In this paper we argue that the very idea of "inventing an index" is a misleading concept in the first place. It is the analogue of "inventing a physical query plan". This paper is a paradigm shift in which we propose to drop the idea to handcraft index structures (as done for binary search trees over B-trees to any form of learned index) altogether. We present a new automatic index breeding framework coined Genetic Generic Generation of Index Structures (GENE). It is based on the observation that almost all index structures are assembled along three principal dimensions: (1) structural building blocks, e.g., a B-tree is assembled from two different structural node types (inner and leaf nodes), (2) a couple of invariants, e.g., for a B-tree all paths have the same length, and (3) decisions on the internal layout of nodes (row or column layout, etc.). We propose a generic indexing framework that can mimic many existing index structures along those dimensions. Based on that framework we propose a generic genetic index generation algorithm that, given a workload and an optimization goal, can automatically assemble and mutate, in other words 'breed' new index structure 'species'. In our experiments we follow multiple goals. We reexamine some good old wisdom from database technology. Given a specific workload, will GENE even breed an index that is equivalent to what our textbooks and papers currently recommend for such a workload? Or can we do even more? Our initial results strongly indicate that generated indexes are the next step in designing index structures.

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

↑