Vector reads for array updates
    1.
    发明申请
    Vector reads for array updates 有权
    向量读取数组更新

    公开(公告)号:US20050262110A1

    公开(公告)日:2005-11-24

    申请号:US10848869

    申请日:2004-05-18

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30315

    摘要: An array update operation which specifies number of (row-identifier, value) pairs for updating rows in a table of a database is implemented as follows. A block-identifier of a block (on disk) that holds a row identified by a row-identifier in a specified pair is looked up using a database index, and the block-identifier thus found is stored in a structure. Use of a row-identifier to look up the corresponding block-identifier, and the storage of the block-identifier in the structure are repeatedly performed, for each of several specified pairs. Next, a vector read is performed, to read and store in a cache, each block identified by a block-identifier in the structure, and all the blocks that have been read are stored in the cache during a single function call. Thereafter, rows identified in specified pairs are modified, in blocks currently in the cache, using the values in the specified pairs.

    摘要翻译: 指定数据库表中更新行的(行标识符,值)对数的数组更新操作如下。 使用数据库索引来查找保存由指定对中的行标识符标识的行的块(在磁盘上)的块标识符,并且由此找到的块标识符被存储在结构中。 对于几个指定的对中的每一个,重复执行使用行标识符来查找对应的块标识符,并且对结构中的块标识符的存储被重复执行。 接下来,执行向量读取,以读取和存储在高速缓存中,由结构中的块标识符标识的每个块以及所读取的所有块在单个功能调用期间被存储在高速缓存中。 此后,使用指定对中的值,以当前在高速缓存中的块中修改以指定对标识的行。

    Vector reads for array updates
    2.
    发明授权
    Vector reads for array updates 有权
    向量读取数组更新

    公开(公告)号:US07734581B2

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

    申请号:US10848869

    申请日:2004-05-18

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30315

    摘要: An array update operation which specifies number of (row-identifier, value) pairs for updating rows in a table of a database is implemented as follows. A block-identifier of a block (on disk) that holds a row identified by a row-identifier in a specified pair is looked up using a database index, and the block-identifier thus found is stored in a structure. Use of a row-identifier to look up the corresponding block-identifier, and the storage of the block-identifier in the structure are repeatedly performed, for each of several specified pairs. Next, a vector read is performed, to read and store in a cache, each block identified by a block-identifier in the structure, and all the blocks that have been read are stored in the cache during a single function call. Thereafter, rows identified in specified pairs are modified, in blocks currently in the cache, using the values in the specified pairs.

    摘要翻译: 指定数据库表中更新行的(行标识符,值)对数的数组更新操作如下。 使用数据库索引来查找保存由指定对中的行标识符标识的行的块(在磁盘上)的块标识符,并且由此找到的块标识符被存储在结构中。 对于几个指定的对中的每一个,重复执行使用行标识符来查找对应的块标识符,并且对结构中的块标识符的存储被重复执行。 接下来,执行向量读取,以读取和存储在高速缓存中,由结构中的块标识符标识的每个块以及所读取的所有块在单个功能调用期间被存储在高速缓存中。 此后,使用指定对中的值,以当前在高速缓存中的块中修改以指定对标识的行。

    Distributed authentication, authorization and accounting
    3.
    发明授权
    Distributed authentication, authorization and accounting 失效
    分布式认证,授权和会计

    公开(公告)号:US08763088B2

    公开(公告)日:2014-06-24

    申请号:US12518636

    申请日:2007-12-12

    IPC分类号: H04L9/32 H04L29/06

    摘要: In some embodiments, computer systems, storage mediums, and methods are provided for controlling a connecting device's access to a plurality of computer networks. In other embodiments, the provided computer systems, storage mediums, and methods may provide for authentication, authorization, and accounting of connecting devices connecting to a plurality of computer networks. In other embodiments, the provided computer systems, storage mediums, and methods may provide for the distribution of authentication routing data and authorization policies among a plurality of computer networks. In yet other embodiments, the provided computer systems, storage mediums, and methods may provide for the distribution of accounting among a plurality of computer networks.

    摘要翻译: 在一些实施例中,提供了计算机系统,存储介质和方法,用于控制连接设备对多个计算机网络的访问。 在其他实施例中,所提供的计算机系统,存储介质和方法可以提供连接到多个计算机网络的连接设备的认证,授权和记帐。 在其他实施例中,提供的计算机系统,存储介质和方法可以在多个计算机网络之间提供认证路由数据和授权策略的分发。 在其他实施例中,所提供的计算机系统,存储介质和方法可以在多个计算机网络之间提供计费分配。

    Aggregate functions in DML returning clause
    4.
    发明授权
    Aggregate functions in DML returning clause 有权
    DML返回子句中的聚合函数

    公开(公告)号:US08108443B2

    公开(公告)日:2012-01-31

    申请号:US10662095

    申请日:2003-09-12

    申请人: Ashish Thusoo

    发明人: Ashish Thusoo

    IPC分类号: G06F17/30 G06F7/00 G06F17/00

    摘要: A statement is provided having a clause that can specify an aggregate function that is performed on a set of data. The statement may alter the data in the data set by deleting or updating the data. The clause may be a returning clause that accepts one or more aggregate functions for its arguments, operates on the set of data, and returns the result of the aggregate function without returning the entire set of data. Alternatively, a statement is provided for changing multiple sets of data without the need to place the multiple sets in a single array.

    摘要翻译: 提供了一个语句,该语句具有可以指定对一组数据执行的聚合函数的子句。 该语句可以通过删除或更新数据来更改数据集中的数据。 该子句可以是一个返回子句,它接受一个或多个聚合函数的参数,对该数据集进行操作,并返回聚合函数的结果,而不返回整个数据集。 或者,提供了用于更改多组数据的语句,而不需要将多个集合放置在单个数组中。

    Efficient query processing of XML data using XML index
    10.
    发明授权
    Efficient query processing of XML data using XML index 有权
    使用XML索引对XML数据进行高效查询处理

    公开(公告)号:US07398265B2

    公开(公告)日:2008-07-08

    申请号:US10944170

    申请日:2004-09-16

    IPC分类号: G06F17/30

    摘要: A method and apparatus is provided for translating queries, such as path expressions and SQL/XML constructs, into SQL statements to be executed against an XML index, which improves processor time as opposed to applying path expressions directly to the original XML documents to extract the desired information. Simple path expressions, filter expressions, descendant axes, wildcards, logical expressions, relational expressions, literals, and other path expressions are all translated into SQL for efficient querying of an XML index. Similarly, rules for translating SQL/XML constructs into SQL are provided.

    摘要翻译: 提供了一种方法和装置,用于将诸如路径表达式和SQL / XML结构之类的查询转换为针对XML索引执行的SQL语句,这样可以提高处理器时间,而不是将路径表达式直接应用于原始XML文档来提取 所需信息。 简单的路径表达式,过滤器表达式,后代轴,通配符,逻辑表达式,关系表达式,文字和其他路径表达式都被转换为SQL,以便有效地查询XML索引。 同样,提供了将SQL / XML结构转换为SQL的规则。