公开(公告)号：US20110029569A1

公开(公告)日：2011-02-03

申请号：US12871882

申请日：2010-08-30

申请人： Amit GANESH ,  Vikram KAPOOR ,  Vineet MARWAH ,  Kam SHERGILL ,  Roger MacNICOL ,  Sachin KULKARNI ,  Jesse KAMP

发明人： Amit GANESH ,  Vikram KAPOOR ,  Vineet MARWAH ,  Kam SHERGILL ,  Roger MacNICOL ,  Sachin KULKARNI ,  Jesse KAMP

IPC分类号： G06F17/30

CPC分类号： G06F17/30595

摘要： Techniques for storing and manipulating tabular data are provided. According to one embodiment, a user may control whether tabular data is stored in row-level or column-major format. Furthermore, the user may control the level of data compression to achieve an optimal balance between query performance and compression ratios. Tabular data from within the same table may be stored in both column-major and row-major format and compressed at different levels. In addition, tabular data can migrate between column-major format and row-major format in response to various events. For example, in response to a request to update or lock a row stored in column-major format, the row may be migrated and subsequently stored into row-major format. In one embodiment, table partitions are used to enhance data compression techniques. For example, compression tests are performed on a representative table partition, and a compression map is generated and applied to other table partitions.

摘要翻译： 提供了存储和操作表格数据的技术。 根据一个实施例，用户可以控制表格数据是以行主列还是列主格式存储。 此外，用户可以控制数据压缩的水平，以实现查询性能和压缩比之间的最佳平衡。 来自同一表格的表格数据可以以列主和行主格式存储，并在不同级别进行压缩。 此外，响应于各种事件，表格数据可以在列主格式和行主格式之间迁移。 例如，响应于更新或锁定以列主格式存储的行的请求，该行可以被迁移并且随后被存储为行主格式。 在一个实施例中，表分区用于增强数据压缩技术。 例如，压缩测试在代表性的表格分区上执行，生成压缩映射并将其应用于其他表格分区。