MULTI-VERSION CONCURRENCY CONTROL ON IN-MEMORY SNAPSHOT STORE OF ORACLE IN-MEMORY DATABASE
    2.
    发明申请
    MULTI-VERSION CONCURRENCY CONTROL ON IN-MEMORY SNAPSHOT STORE OF ORACLE IN-MEMORY DATABASE 审中-公开
    存储器内存数据库的内存存储器的多版本同步控制

    公开(公告)号:WO2015041968A1

    公开(公告)日:2015-03-26

    申请号:PCT/US2014/055571

    申请日:2014-09-15

    Abstract: Techniques are provided for maintaining data persistently in one format, but making that data available to a database server in more than one format. For example, one of the formats in which the data is made available for query processing is based on the on-disk format, while another of the formats in which the data is made available for query processing is independent of the on-disk format. Data that is in the format that is independent of the disk format may be maintained exclusively in volatile memory to reduce the overhead associated with keeping the data in sync with the on-disk format copies of the data.

    Abstract translation: 提供的技术用于以一种格式持续保持数据,但使数据库可以以多种格式提供给数据库服务器。 例如,数据可用于查询处理的格式之一是基于磁盘格式,而数据可用于查询处理的另一种格式与磁盘格式无关。 独立于磁盘格式的格式的数据可以专门保存在易失性存储器中,以减少与保持数据与数据的磁盘格式副本同步的开销。

    METHOD AND APPARATUS FOR AUTOMATICALLY CLASSIFYING DATA
    3.
    发明申请
    METHOD AND APPARATUS FOR AUTOMATICALLY CLASSIFYING DATA 审中-公开
    用于自动分类数据的方法和装置

    公开(公告)号:WO2009058474A1

    公开(公告)日:2009-05-07

    申请号:PCT/US2008/075139

    申请日:2008-09-03

    CPC classification number: G06F21/6227

    Abstract: One embodiment of the present invention provides a system for automatically classifying data in a database. During operation, the system receives and executes a database operation. Next, the system automatically determines if any data was modified as a result of executing the database operation. If so, for each data item that was modified, the system automatically determines if the data item is associated with a classification-rule. If so, the system automatically reclassifies the data item according to the classification-rule. If not, the system leaves a classification of the data item unchanged.

    Abstract translation: 本发明的一个实施例提供一种用于在数据库中自动分类数据的系统。 在运行期间,系统接收并执行数据库操作。 接下来,由于执行数据库操作,系统会自动确定是否修改了任何数据。 如果是,对于修改的每个数据项,系统自动确定数据项是否与分类规则相关联。 如果是这样,系统会根据分类规则自动重新分类数据项。 如果没有,系统会保留数据项的分类。

    EFFICIENT HARDWARE INSTRUCTIONS FOR SINGLE INSTRUCTION MULTIPLE DATA PROCESSORS
    5.
    发明申请
    EFFICIENT HARDWARE INSTRUCTIONS FOR SINGLE INSTRUCTION MULTIPLE DATA PROCESSORS 审中-公开
    高效的硬件指令,用于单个指令多个数据处理器

    公开(公告)号:WO2014150913A2

    公开(公告)日:2014-09-25

    申请号:PCT/US2014/024523

    申请日:2014-03-12

    Abstract: A method and apparatus for efficiently processing data in various formats in a single instruction multiple data ("SIMD") architecture is presented. Specifically, a method to unpack a fixed-width bit values in a bit stream to a fixed width byte stream in a SIMD architecture is presented. A method to unpack variable-length byte packed values in a byte stream in a SIMD architecture is presented. A method to decompress a run length encoded compressed bit-vector in a SIMD architecture is presented. A method to return the offset of each bit set to one in a bit-vector in a SIMD architecture is presented. A method to fetch bits from a bit-vector at specified offsets relative to a base in a SIMD architecture is presented. A method to compare values stored in two SIMD registers is presented.

    Abstract translation: 提出了一种在单指令多数据(“SIMD”)结构中有效处理各种格式的数据的方法和装置。 具体地说,提出了一种在SIMD架构中将位流中的固定宽度位值解包为固定宽度字节流的方法。 介绍了一种解码SIMD架构中字节流中可变长度字节打包值的方法。 提出了一种在SIMD架构中解压缩运行长度编码的压缩位向量的方法。 提出了一种在SIMD架构中将位设置为1的偏移量返回到位向量中的方法。 提出了一种从SIMD架构中相对于基址指定的偏移量从位向量获取位的方法。 提出了一种比较存储在两个SIMD寄存器中的值的方法。

    TECHNIQUES FOR MAINTAINING COLUMN VECTORS OF RELATIONAL DATA WITHIN VOLATILE MEMORY
    6.
    发明申请
    TECHNIQUES FOR MAINTAINING COLUMN VECTORS OF RELATIONAL DATA WITHIN VOLATILE MEMORY 审中-公开
    维护相关数据在波形存储器中的列向量的技术

    公开(公告)号:WO2013086384A1

    公开(公告)日:2013-06-13

    申请号:PCT/US2012/068531

    申请日:2012-12-07

    CPC classification number: G06F17/30315 G06F9/3887 G06F17/30339 G06F17/30595

    Abstract: Techniques are provided for more efficiently using the bandwidth of the I/O path between a CPU and volatile memory during the performance of database operation. Relational data from a relational table is stored in volatile memory as column vectors, where each column vector contains values for a particular column of the table. A binary-comparable format may be used to represent each value within a column vector, regardless of the data type associated with the column. The column vectors may be compressed and/or encoded while in volatile memory, and decompressed/decoded on-the-fly within the CPU. Alternatively, the CPU may be designed to perform operations directly on the compressed and/or encoded column vector data. In addition, techniques are described that enable the CPU to perform vector processing operations on the column vector values.

    Abstract translation: 在执行数据库操作期间,提供了技术来更有效地使用CPU和易失性存储器之间的I / O路径的带宽。 来自关系表的关系数据作为列向量存储在易失性存储器中,其中每个列向量包含表的特定列的值。 可以使用二进制可比较的格式来表示列向量中的每个值,而不管与列相关联的数据类型如何。 列向量可以在易失性存储器中被压缩和/或编码,并且在CPU内部实时解压缩/解码。 或者,CPU可以被设计为直接对压缩和/或编码的列向量数据执行操作。 另外,描述使CPU能够对列向量值执行向量处理操作的技术。

    DELTA OPERATIONS ON A LARGE OBJECT IN A DATABASE
    7.
    发明申请
    DELTA OPERATIONS ON A LARGE OBJECT IN A DATABASE 审中-公开
    DELTA在一个大型的对象数据库中的操作

    公开(公告)号:WO2009015049A2

    公开(公告)日:2009-01-29

    申请号:PCT/US2008/070564

    申请日:2008-07-19

    CPC classification number: G06F17/30421 G06F17/30365

    Abstract: A computer (200) modifies data inside an object (201 ) in a database (210) without modifying other data in the remainder of the object (201 ). Insertion of new data (208C) at a specified location in the object (201 ) does not require movement of existing data in the object (201 ). Instead, the computer (200) is programmed to insert new data at a physical end of the object (201 ), and modify metadata (230) based on the specified location. Similarly, deletion of existing data from a specified location in the object (201 ) is performed without movement of other data in the object (201 ), by updating the metadata (230). The computer (200) uses the metadata (230) when reading from the object (201 ), so that the new data (208C) is automatically read whenever the specified location is accessed. The computer (200) may optionally output a handle that is static, relative to other insertions and deletions, to identify specific data within the object (201 ), for use in building indexes on the object (201 ).

    Abstract translation: 计算机(200)修改数据库(210)中的对象(201)内的数据而不修改对象(201)的其余部分中的其他数据。 在对象(201)的指定位置插入新数据(208C)不需要移动对象(201)中的现有数据。 相反,计算机(200)被编程为在对象(201)的物理端插入新数据,并基于指定位置修改元数据(230)。 类似地,通过更新元数据(230),执行从对象(201)中的指定位置删除现有数据而不移动对象(201)中的其他数据。 当从对象(201)读取时,计算机(200)使用元数据(230),使得每当访问指定位置时自动读取新数据(208C)。 计算机(200)可以可选地输出相对于其他插入和删除是静态的句柄,以识别对象(201)内的特定数据,用于在对象(201)上构建索引。

    SYSTEM FOR DETECTING AND CHARACTERIZING SEASONS
    8.
    发明申请
    SYSTEM FOR DETECTING AND CHARACTERIZING SEASONS 审中-公开
    用于检测和表征季节的系统

    公开(公告)号:WO2017151475A1

    公开(公告)日:2017-09-08

    申请号:PCT/US2017/019613

    申请日:2017-02-27

    Abstract: Techniques are described for characterizing and summarizing seasonal patterns detected within a time series. According to an embodiment, a set of time series data is analyzed to identify a plurality of instances of a season, where each instance corresponds to a respective sub-period within the season. A first set of instances from the plurality of instances are associated with a particular class of seasonal pattern. After classifying the first set of instances, a second set of instances may remain unclassified or otherwise may not be associated with the particular class of seasonal pattern. Based on the first and second set of instances, a summary may be generated that identifies one or more stretches of time that are associated with the particular class of seasonal pattern. The one or more stretches of time may span at least one sub-period corresponding to at least one instance in the second set of instances.

    Abstract translation: 描述了用于表征和总结时间序列内检测到的季节性模式的技术。 根据一个实施例,分析一组时间序列数据以识别季节的多个实例,其中每个实例对应于季节内的相应子时段。 来自多个实例的第一组实例与特定类别的季节模式相关联。 在对第一组实例进行分类之后,第二组实例可以保持未分类或否则可能不与特定类型的季节模式相关联。 基于第一组实例和第二组实例,可以生成标识与特定类型的季节模式相关联的一个或多个时间段的概要。 一个或多个时间段可跨越对应于第二组实例中的至少一个实例的至少一个子时段。

    TRACKING ROW AND OBJECT DATABASE ACTIVITY INTO BLOCK LEVEL HEATMAPS
    9.
    发明申请
    TRACKING ROW AND OBJECT DATABASE ACTIVITY INTO BLOCK LEVEL HEATMAPS 审中-公开
    跟踪和对象数据库活动进入块级热源

    公开(公告)号:WO2014052890A1

    公开(公告)日:2014-04-03

    申请号:PCT/US2013/062404

    申请日:2013-09-27

    Abstract: A method, apparatus, and system for tracking row and object database activity into block level heatmaps is provided. Database activity including reads, writes, and creates can be tracked by a database management system at the finest possible level of granularity, or the row and object level. To efficiently record the tracked database activity, a two-part structure is described for writing the activity into heatmaps. A hierarchical in-memory component may use a dynamically allocated sparse pool of bitmap blocks. Periodically, the in-memory component is persisted to a stored representation component, sharable with multiple database instances, which may include consolidated last access times and/or a history of heatmap snapshots to reflect access over time. The heatmaps may then be externalized to database users and applications to provide and support a variety of features.

    Abstract translation: 提供了一种用于将行和对象数据库活动跟踪到块级散热图的方法,装置和系统。 数据库活动(包括读取,写入和创建)可以由数据库管理系统以最高级别的粒度或行和对象级别进行跟踪。 为了有效地记录跟踪的数据库活动,描述了将活动写入热图的两部分结构。 分层内存组件可以使用动态分配的位图块的稀疏池。 周期性地,存储器内部件被持久化到存储的表示组件,可与多个数据库实例共享,这可以包括合并的最后访问时间和/或热映射快照的历史以反映随时间的访问。 然后,热图可以被外部化为数据库用户和应用程序,以提供和支持各种功能。

    TECHNIQUES FOR AUTOMATIC DATA PLACEMENT WITH COMPRESSION AND COLUMNAR STORAGE
    10.
    发明申请
    TECHNIQUES FOR AUTOMATIC DATA PLACEMENT WITH COMPRESSION AND COLUMNAR STORAGE 审中-公开
    自动数据放置与压缩和色谱储存的技术

    公开(公告)号:WO2012159024A1

    公开(公告)日:2012-11-22

    申请号:PCT/US2012/038556

    申请日:2012-05-18

    Abstract: For automatic data placement of database data, a plurality of access-tracking data is maintained. The plurality of access-tracking data respectively corresponds to a plurality of data rows that are managed by a database server. While the database server is executing normally, it is automatically determined whether a data row, which is stored in first one or more data blocks, has been recently accessed based on the access-tracking data that corresponds to that data row. After determining that the data row has been recently accessed, the data row is automatically moved from the first one or more data blocks to one or more hot data blocks that are designated for storing those data rows, from the plurality of data rows, that have been recently accessed.

    Abstract translation: 对于数据库数据的自动数据放置,维持多个访问跟踪数据。 多个访问跟踪数据分别对应于由数据库服务器管理的多个数据行。 当数据库服务器正常执行时,根据与该数据行相对应的访问跟踪数据,自动确定是否最近访问存储在第一个一个或多个数据块中的数据行。 在确定最近访问了数据行之后,数据行被自动从第一个或多个数据块移动到指定用于存储来自多个数据行的那些数据行的一个或多个热数据块,这些数据行具有 最近被访问。

Patent Agency Ranking