arXivDaily arXiv每日学术速递 周一至周五更新
arXiv 2209.01635cs.DBcs.OS
收藏

虚拟内存中的自适应存储视图

Towards Adaptive Storage Views in Virtual Memory

Felix Schuhknecht, Justus Henneberg

摘要:

传统上,DBMS将其存储层与索引层分离。虽然存储层物理上实现了数据库并提供了对数据库的低级访问方法,但顶部的索引层可以更快地定位搜索到的条目。虽然这清楚地分离的关注,它也增加了一个层次的间接已经复杂的执行path.In这项工作中,我们提出了一种替代设计:而不是保守地分离两个层,我们自然融合它们集成自适应粗粒度索引方案直接到存储层。我们这样做是通过利用操作系统提供的虚拟内存管理子系统的工具:在最底层,我们将数据库内容具体化为物理主存的形式。最重要的是,我们允许创建任意多个虚拟内存存储视图,这些视图映射到具有某些感兴趣属性的数据库子集。这种创建完全自适应地作为查询处理的副产品发生。为了加快查询应答,我们将每个查询自动路由到最合适的虚拟视图。通过这种方式,我们自然地在其核心中索引存储层,并逐渐提高所提供的扫描性能。

英文摘要:

Traditionally, DBMSs separate their storage layer from their indexing layer. While the storage layer physically materializes the database and provides low-level access methods to it, the indexing layer on top enables a faster locating of searched-for entries. While this clearly separates concerns, it also adds a level of indirection to the already complex execution path. In this work, we propose an alternative design: Instead of conservatively separating both layers, we naturally fuse them by integrating an adaptive coarse-granular indexing scheme directly into the storage layer. We do so by utilizing tools of the virtual memory management subsystem provided by the OS: On the lowest level, we materialize the database content in form of physical main memory. On top of that, we allow the creation of arbitrarily many virtual memory storage views that map to subsets of the database having certain properties of interest. This creation happens fully adaptively as a side-product of query processing. To speed up query answering, we route each query automatically to the most fitting virtual view(s). By this, we naturally index the storage layer in its core and gradually improve the provided scan performance.

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

↑