-
公开(公告)号：US20080040348A1
公开(公告)日：2008-02-14
申请号：US11461926
申请日：2006-08-02
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个投影被添加到其他节点。 设计师继续添加预算，直到达到空间预算。
-
公开(公告)号：US20230093900A1
公开(公告)日：2023-03-30
申请号：US17955263
申请日：2022-09-28
摘要： The various implementations described herein include methods and systems of data governance. In one aspect, a method of purging backup data includes obtaining a database table having a corresponding data policy and generating an encrypted version of the database table by applying an encryption key, including encrypting at least a portion of the database table. The method further includes identifying an expiration date for the encryption key based on the data policy, and storing the encryption key, the expiration date, and an encryption identifier for the encryption key in an encryption table. The method also includes receiving a command to back up the database table and, in response to the command, generating a backup of the encrypted version of the database table. The method further includes storing the backup and, when a current date is at least the expiration date for the encryption key, deleting the encryption key.
-
公开(公告)号：US10007686B2
公开(公告)日：2018-06-26
申请号：US11461926
申请日：2006-08-02
IPC分类号： G06F17/30
CPC分类号： G06F16/22 , G06F16/221
摘要： 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.
-
-
搜索结果
3 条记录 (耗时 0.014 秒)
