专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

2. 发明申请

US20080040348A1 Automatic Vertical-Database Design 有权
标题翻译：自动垂直数据库设计
公开(公告)号：US20080040348A1
公开(公告)日：2008-02-14
申请号：US11461926
申请日：2006-08-02
申请人： Shilpa Lawande , Alexander Rasin , Omer Trajman , Stanley B. Zdonik
发明人： Shilpa Lawande , Alexander Rasin , Omer Trajman , Stanley B. Zdonik
IPC分类号： G06F7/00
CPC分类号： G06F17/30312 , G06F17/30315
摘要： An automatic physical-layout designer for a database-management system determines the database's physical layout from a set of training queries, the database's logical design, and a parameter k that indicates how many storage nodes can be lost without losing access to any of the data. The designer lays the database out as a column store such that the stored columns constitute redundant projections on the system's different storage nodes. It repeatedly identifies a projection, whose addition to the design will result in the greatest performance improvement for the training queries. In doing so, it takes into account the different compression formats to which the different projections lend themselves. When a projection has been identified as one to be added, it is added on one node, and k projections having the same columns are added to other nodes. The designer continues thus adding projections until a space budget has been reached.
摘要翻译：用于数据库管理系统的自动物理布局设计器从一组训练查询，数据库的逻辑设计和参数k确定数据库的物理布局，其指示可以丢失多少个存储节点而不会丢失对任何数据的访问。设计人员将数据库放置为列存储，使得存储的列在系统的不同存储节点上构成冗余投影。它重复地识别一个投影，除了设计之外，训练查询的性能将会最大化。在这样做的时候，它考虑到不同的投影对自己不同的压缩格式。当投影被识别为要添加的投影时，它被添加到一个节点上，并且具有相同列的k个投影被添加到其他节点。设计师继续添加预算，直到达到空间预算。

IPRDB

热门服务

关于我们

友情链接

联系方式