Methods And Apparatus Using Range Queries For Multi-dimensional Data In A Database
    12.
    发明申请
    Methods And Apparatus Using Range Queries For Multi-dimensional Data In A Database 有权
    使用数据库中多维数据的范围查询的方法和设备

    公开(公告)号:US20100082654A1

    公开(公告)日:2010-04-01

    申请号:US12241305

    申请日:2008-09-30

    CPC classification number: G06F17/30424 G06F17/30592

    Abstract: Embodiments include methods, apparatus, and systems for using range queries in multidimensional data in a database. One embodiment is a method that defines a query box from a search for multidimensional data in a database. The method examines an intersection between a Z-interval and the query box by decomposing the Z-interval into hyper-boxes that are also Z-intervals in Z space. Items in the query box that match the search are discovered.

    Abstract translation: 实施例包括在数据库中的多维数据中使用范围查询的方法,装置和系统。 一个实施例是一种从数据库中的多维数据搜索定义查询框的方法。 该方法通过将Z间隔分解为Z空间中也是Z间隔的超盒子来检查Z间隔和查询框之间的交集。 发现与查询匹配的查询框中的项目。

    DDL and DML support for hybrid columnar compressed tables
    13.
    发明授权
    DDL and DML support for hybrid columnar compressed tables 有权
    DDL和DML支持混合柱状压缩表

    公开(公告)号:US08583692B2

    公开(公告)日:2013-11-12

    申请号:US12871882

    申请日:2010-08-30

    CPC classification number: G06F17/30595

    Abstract: 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.

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

    DDL and DML support for hybrid columnar compressed tables

    公开(公告)号:US08521784B2

    公开(公告)日:2013-08-27

    申请号:US12871882

    申请日:2010-08-30

    Abstract: 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.

Patent Agency Ranking