Flexs - A Logical Model for Physical Data Layout
Flexs - A Logical Model for Physical Data Layout
复制标题
DOI：
10.1007/978-3-319-10518-5_7
复制
发表时间：
2014
期刊：
影响因子：
--
通讯作者：
H. Voigt;Alfred Hanisch;Wolfgang Lehner
中科院分区：
文献类型：
--
作者：
H. Voigt;Alfred Hanisch;Wolfgang Lehner
在新的应用领域和硬件趋势的推动下，数据库的研究和开发开始向许多新的和专门的体系结构发展。特别是在物理数据布局领域，专业解决方案已针对特定应用表现出卓越的性能。这一趋势对于研发以及那些首先需要顶级性能的人来说是非常好的。然而，对于那些具有中等性能需求的用户来说，通用但灵活的数据库系统具有降低TCO的好处。关于物理数据布局，与专用系统中可用的各种物理数据布局相比，更通用的系统相当不灵活。特别地，宏观特征，即，数据如何分组和聚类，通常是硬编码的，不能通过配置改变。我们提出了Flexs，一个声明性的存储描述语言的物理数据布局的宏观特征。Flex允许描述物理数据布局，从行和列存储布局到不规则数据的数据布局，如垂直模式。使用Flex，可以将存储引擎配置为使用特定的物理数据布局。Flexs有助于为大多数通用数据库系统提供专门的物理数据布局。
Driven by novel application domains and hardware trends database research and development set off to many novel and specialized architectures. Particularly in the area of physical data layout, specialized solutions have shown exceptional performance for specific applications. This trend is great for research and development and for those in need of top-level performance first and foremost. For those with moderate performance needs, however, a universal but flexible database system has the benefit of lower TCO. Regarding physical data layout, the more general systems are fairly inflexible compared to the variety of physical data layouts available in specialized systems. Particularly, the macroscopic characteristics, i.e., how the data is grouped and clustered, are generally hard-coded and cannot be changed by configuration. We present Flexs, a declarative storage description language for the macroscopic characteristics of physical data layouts. Flexs allows describing physical data layouts ranging from the row and column store layouts to data layouts for irregular data such as vertical schema. Using Flexs, a storage engine can be configured to use a specific physical data layout. Flexs contributes to make specialized physical data layouts available to the broad majority of universal database systems.