High performant row-level data manipulation using a data layer interface
    1.
    发明授权
    High performant row-level data manipulation using a data layer interface 有权
    使用数据层接口执行高性能行级数据操作

    公开(公告)号:US07769789B2

    公开(公告)日:2010-08-03

    申请号:US11801930

    申请日:2007-05-11

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30377

    摘要: Performing an operation directly on data stored in a database table provides for avoiding generation and processing of SQL statements. A Data Layer interface, comprising a set of APIs, allows internal database server components to call directly to the Data Layer for making fast row changes to a table. According to an embodiment, before making any row change to a table through this Data Layer interface, a shared state data structure is created to hold the metadata about the table. A single shared state can be used for all DML changes to a particular table regardless of what columns are updated or inserted during each DML operation. When a process needs to change a row, the process uses a mutable state based on the shared state of the table.

    摘要翻译: 直接对存储在数据库表中的数据执行操作可避免SQL语句的生成和处理。 包含一组API的数据层接口允许内部数据库服务器组件直接调用数据层,以便对表进行快速行更改。 根据实施例,在通过该数据层接口对表进行任何行更改之前,创建共享状态数据结构以保存关于表的元数据。 无论在每个DML操作期间更新或插入哪些列,单个共享状态可用于对特定表的所有DML更改。 当进程需要更改一行时,进程将使用基于表的共享状态的可变状态。

    High performant row-level data manipulation using a data layer interface
    2.
    发明申请
    High performant row-level data manipulation using a data layer interface 有权
    使用数据层接口执行高性能行级数据操作

    公开(公告)号:US20080281846A1

    公开(公告)日:2008-11-13

    申请号:US11801930

    申请日:2007-05-11

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30377

    摘要: Performing an operation directly on data stored in a database table provides for avoiding generation and processing of SQL statements. A Data Layer interface, comprising a set of APIs, allows internal database server components to call directly to the Data Layer for making fast row changes to a table. According to an embodiment, before making any row change to a table through this Data Layer interface, a shared state data structure is created to hold the metadata about the table. A single shared state can be used for all DML changes to a particular table regardless of what columns are updated or inserted during each DML operation. When a process needs to change a row, the process uses a mutable state based on the shared state of the table.

    摘要翻译: 直接对存储在数据库表中的数据执行操作可避免SQL语句的生成和处理。 包含一组API的数据层接口允许内部数据库服务器组件直接调用数据层,以便对表进行快速行更改。 根据实施例,在通过该数据层接口对表进行任何行更改之前,创建共享状态数据结构以保存关于表的元数据。 无论在每个DML操作期间更新或插入哪些列,单个共享状态可用于对特定表的所有DML更改。 当进程需要更改一行时,进程将使用基于表的共享状态的可变状态。

    ONLINE INDEX BUILDS AND REBUILDS WITHOUT BLOCKING LOCKS
    3.
    发明申请
    ONLINE INDEX BUILDS AND REBUILDS WITHOUT BLOCKING LOCKS 有权
    在线索引建立和重建,没有阻塞锁

    公开(公告)号:US20090037366A1

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

    申请号:US11830545

    申请日:2007-07-30

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30336

    摘要: Techniques are provided for processing a CREATE INDEX statement that avoids one or more locks on the underlying table. The processing of such a statement may be divided into a build phase and a cooperation phase. During the build phase, a journal table is created and published. A snapshot of the table is obtained after the last DML transaction (that was pending at the time the journal table was published) commits. The index is built based on the state of the table as of the snapshot. Any changes to the table while the index is built are recorded in the journal table. During the cooperation phase, the index is partially published. A subsequent DML statement determines whether any changes in the journal table affect the same data as the subsequent DML statement. If so, then those changes are applied to the index followed by the subsequent DML statement.

    摘要翻译: 提供了技术来处理CREATE INDEX语句,以避免基础表上的一个或多个锁。 这种陈述的处理可分为建立阶段和合作阶段。 在构建阶段,创建并发布日志表。 该表的快照是在最后一个DML事务(在发布日志表时挂起的)提交之后获得的。 索引是基于快照的表的状态构建的。 索引构建时对表的任何更改记录在日记表中。 在合作阶段,该指数部分公布。 随后的DML语句确定日记表表中的任何更改是否影响与后续DML语句相同的数据。 如果是这样,那么这些更改将应用​​于后面跟随的DML语句的索引。

    Delta operations on a large object in a database
    6.
    发明授权
    Delta operations on a large object in a database 有权
    数据库中大对象的Delta操作

    公开(公告)号:US07761411B2

    公开(公告)日:2010-07-20

    申请号:US11781103

    申请日:2007-07-20

    IPC分类号: G06F17/00

    CPC分类号: G06F17/30421 G06F17/30365

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

    摘要翻译: 计算机修改未知结构的数据库大对象(LOB)内的数据,而不会修改剩余LOB中的其他数据。 在LOB中的指定位置插入新数据不需要在LOB中移动现有数据。 而是将计算机编程为在LOB的物理端插入新数据,并根据指定的位置修改元数据。 类似地,通过更新元数据来执行在LOB中从LOB中的指定位置删除现有数据而不移动其他数据。 当从LOB读取数据时,计算机使用元数据,以便每当访问指定位置时,新数据都会自动读取。 计算机可以可选地输出相对于其他插入和删除是静态的句柄,以识别LOB内的特定数据,以用于构建LOB上的索引。

    System and method for data encryption
    7.
    发明申请
    System and method for data encryption 有权
    用于数据加密的系统和方法

    公开(公告)号:US20080098236A1

    公开(公告)日:2008-04-24

    申请号:US11584144

    申请日:2006-10-19

    摘要: A method of processing data from a file includes obtaining a first portion of the file, encrypting the first portion of the file to create a first encrypted portion, obtaining a second portion of the file, encrypting the second portion of the file to create a second encrypted portion, and storing the first and second encrypted portions such that each of the first and the second encrypted portions can be individually accessed. A method of processing data from a file includes receiving a request to access a first portion of the file, wherein data in the first portion of the file is encrypted, and data in a second portion of the file is encrypted, and decrypting the data in the first portion, and not the data in the second portion.

    摘要翻译: 一种从文件处理数据的方法包括:获取文件的第一部分,加密文件的第一部分以创建第一加密部分,获得文件的第二部分,加密文件的第二部分以创建第二部分 加密部分,并且存储第一和第二加密部分,使得可以单独访问第一和第二加密部分中的每一个。 一种从文件处理数据的方法包括:接收访问该文件的第一部分的请求,其中该文件的第一部分中的数据被加密,并且该文件的第二部分中的数据被加密,并将该数据解密 第一部分,而不是第二部分中的数据。

    System and method for data encryption
    9.
    发明授权
    System and method for data encryption 有权
    用于数据加密的系统和方法

    公开(公告)号:US07920700B2

    公开(公告)日:2011-04-05

    申请号:US11584144

    申请日:2006-10-19

    IPC分类号: H04K1/04 H04L29/06

    摘要: A method of processing data from a file includes obtaining a first portion of the file, encrypting the first portion of the file to create a first encrypted portion, obtaining a second portion of the file, encrypting the second portion of the file to create a second encrypted portion, and storing the first and second encrypted portions such that each of the first and the second encrypted portions can be individually accessed. A method of processing data from a file includes receiving a request to access a first portion of the file, wherein data in the first portion of the file is encrypted, and data in a second portion of the file is encrypted, and decrypting the data in the first portion, and not the data in the second portion.

    摘要翻译: 一种从文件处理数据的方法包括:获取文件的第一部分,加密文件的第一部分以创建第一加密部分,获得文件的第二部分,加密文件的第二部分以创建第二部分 加密部分,并且存储第一和第二加密部分,使得可以单独访问第一和第二加密部分中的每一个。 一种从文件处理数据的方法包括:接收访问该文件的第一部分的请求,其中该文件的第一部分中的数据被加密,并且该文件的第二部分中的数据被加密,并将该数据解密 第一部分,而不是第二部分中的数据。

    Delta Operations On A Large Object In A Database
    10.
    发明申请
    Delta Operations On A Large Object In A Database 有权
    数据库中大对象上的Delta操作

    公开(公告)号:US20090024578A1

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

    申请号:US11781103

    申请日:2007-07-20

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30421 G06F17/30365

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

    摘要翻译: 计算机修改未知结构的数据库大对象(LOB)内的数据,而不会修改剩余LOB中的其他数据。 在LOB中的指定位置插入新数据不需要在LOB中移动现有数据。 而是将计算机编程为在LOB的物理端插入新数据,并根据指定的位置修改元数据。 类似地,通过更新元数据来执行在LOB中从LOB中的指定位置删除现有数据而不移动其他数据。 当从LOB读取数据时,计算机使用元数据,以便每当访问指定位置时,新数据都会自动读取。 计算机可以可选地输出相对于其他插入和删除是静态的句柄,以识别LOB内的特定数据,以用于构建LOB上的索引。