Deferred piggybacked messaging mechanism for session reuse
    31.
    发明授权
    Deferred piggybacked messaging mechanism for session reuse 有权
    延迟捎带的消息传递机制,用于会话重用

    公开(公告)号:US07346690B1

    公开(公告)日:2008-03-18

    申请号:US10160128

    申请日:2002-05-30

    IPC分类号: G06F15/16 G06F7/00

    摘要: Described herein is a session reuse approach that reuses a session already established on a remote participant to execute an autonomous transaction. The session is reused in a manner that avoids affecting the session's state in a way adverse to later execution of the containing transaction. When beginning an autonomous transaction on a local participant, a request to initiate an autonomous transaction on a remote participant is deferred or not sent at all if the containing transaction is a distributed one. The request may be sent later, piggybacked to another message, using a piggyback messaging system. When ending an autonomous transaction, a local participant may send a request to a remote participant requesting that the remote participant commence execution of its respective containing transaction. The request is piggybacked to another message, and is thus transmitted without having to transmit the request separately, avoiding a message round trip.

    摘要翻译: 这里描述的是重用在远程参与者上已建立的会话来执行自主事务的会话重用方法。 会话被重复使用,以避免影响会话状态的方式不利于稍后执行包含事务。 当在本地参与者开始自主交易时,如果包含的交易是分布式交易,则在远程参与者上发起自主交易的请求被推迟或不被发送。 该请求可以稍后发送,使用搭载邮件系统捎带到另一个消息。 当结束自主交易时,本地参与者可以向远程参与者发送请求,请求远程参与者开始执行其相应的包含交易。 该请求捎带到另一个消息,并且因此被传送而不必分别发送请求,避免信息往返。

    Method and apparatus for organizing digital images with embedded metadata
    32.
    发明申请
    Method and apparatus for organizing digital images with embedded metadata 有权
    用嵌入式元数据组织数字图像的方法和装置

    公开(公告)号:US20070043748A1

    公开(公告)日:2007-02-22

    申请号:US11206426

    申请日:2005-08-17

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30265

    摘要: One embodiment of the present invention provides a system that facilitates automatically organizing digital images using metadata which is embedded in the digital images. The system operates by receiving a digital image with embedded metadata, wherein the embedded metadata includes Global Positioning System (GPS) data. The system uses the embedded metadata, including the GPS data, to identify additional metadata associated with the digital image. The system then saves the digital image on a storage medium. In addition, the system saves the embedded metadata and the additional metadata on the storage medium in a searchable format.

    摘要翻译: 本发明的一个实施例提供一种便于使用嵌入在数字图像中的元数据自动组织数字图像的系统。 该系统通过接收具有嵌入式元数据的数字图像来操作,其中嵌入式元数据包括全球定位系统(GPS)数据。 该系统使用嵌入式元数据(包括GPS数据)来识别与数字图像相关联的附加元数据。 然后系统将数字图像保存在存储介质上。 此外,系统以可搜索的格式将嵌入式元数据和附加元数据保存在存储介质上。

    Providing mappings between logical time values and real time values in a multinode system
    33.
    发明申请
    Providing mappings between logical time values and real time values in a multinode system 有权
    在多节点系统中提供逻辑时间值和实时值之间的映射

    公开(公告)号:US20050278359A1

    公开(公告)日:2005-12-15

    申请号:US10866234

    申请日:2004-06-10

    IPC分类号: G06F7/00

    摘要: Techniques are provided for providing mappings between logical time values and real time values in a multinode system. The techniques include, if a first event occurs, then writing an LTV-to-RTV mapping to a non-volatile data structure. If a second event occurs, then a check is performed to determine whether any of the LTV-to-RTV mappings in the volatile data structure are newer than all LTV-to-RTV mappings in a non-volatile data structure. If there are newer mappings in the volatile data structure, then one or more LTV-to-RTV mappings are written to the non-volatile data structure based on those “newer” LTV-to-RTV mappings from the volatile data structure. Upon receiving a request an LTV for a particular RTV, the particular RTV is determined based on information from an information source such as the volatile data structure or the non-volatile data structure.

    摘要翻译: 提供了在多节点系统中提供逻辑时间值和实时值之间的映射的技术。 这些技术包括,如果发生第一个事件,则将LTV-to-RTV映射写入非易失性数据结构。 如果发生第二个事件,则执行检查以确定易失性数据结构中的任何LTV到RTV映射是否比非易失性数据结构中的所有LTV到RTV映射更新。 如果在易失性数据结构中存在较新的映射,则基于来自易失性数据结构的“较新的”LTV到RTV映射,将一个或多个LTV到RTV映射写入非易失性数据结构。 在接收到用于特定RTV的LTV的请求时,基于来自诸如易失性数据结构或非易失性数据结构的信息源的信息确定特定RTV。

    Techniques for resuming a transaction after an error
    34.
    发明授权
    Techniques for resuming a transaction after an error 有权
    发生错误后恢复事务的技术

    公开(公告)号:US06961865B1

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

    申请号:US09993855

    申请日:2001-11-13

    IPC分类号: G06R11/00

    CPC分类号: G06F11/1474 Y10S707/99953

    摘要: Techniques for executing an atomic transaction include performing a first operation of a first set of operations. The atomic transaction involves the first set of operations for causing changes to a first set of data. A first error that prevents completion of the atomic transaction is detected. In response to detecting the first error, a second set of operations is performed for resolving the first error. It is then determined whether a resolution of the first error is obtained in response to performing the second set of operations. If the resolution is obtained, then execution of the first set of operations is resumed. These techniques allow atomic transactions to be resumed after resolving an error without undoing all the operations accomplished for the transaction at the time the error occurred.

    摘要翻译: 用于执行原子事务的技术包括执行第一组操作的第一操作。 原子事务涉及用于引起对第一组数据的改变的第一组操作。 检测到阻止完成原子事务的第一个错误。 响应于检测到第一错误,执行第二组操作以解决第一错误。 然后确定响应于执行第二组操作是否获得第一错误的分辨率。 如果获得分辨率,则恢复第一组操作的执行。 这些技术允许在解决错误后恢复原子事务,而不会撤消在发生错误时为事务完成的所有操作。

    Active queries filter extraction
    35.
    发明申请
    Active queries filter extraction 审中-公开
    主动查询过滤提取

    公开(公告)号:US20050055381A1

    公开(公告)日:2005-03-10

    申请号:US10866433

    申请日:2004-06-10

    IPC分类号: G06F17/30

    CPC分类号: G06F16/24552 G06F16/24568

    摘要: A query result set is an example of a type of body of data whose content is defined by a query. Modifications to a database can change the result of a query and therefore what the content of such a body of data, such as a result set, should be. Active Queries is an approach that enables a database server to detect database changes that alter the result of a query registered for a client and to notify a client of those changes. The notifications may be sent to, for example, a cache manager responsible for maintaining coherency of a result set cache generated by the query. The notification notifies the cache manager of when and/or what changes are needed to maintain the coherency of the cache.

    摘要翻译: 查询结果集是其内容由查询定义的数据主体类型的示例。 对数据库的修改可以改变查询的结果,因此这样一个数据体的内容,比如结果集,应该是什么。 活动查询是一种使数据库服务器能够检测数据库更改的方法,可更改为客户端注册的查询结果,并通知客户端这些更改。 通知可以被发送到例如负责维护由查询生成的结果集缓存的一致性的高速缓存管理器。 该通知通知高速缓存管理器需要什么时候和/或需要什么改变来维持高速缓存的一致性。

    Method and mechanism for determining life intervals for a key in an index
    36.
    发明授权
    Method and mechanism for determining life intervals for a key in an index 有权
    确定索引中键的生命周期的方法和机制

    公开(公告)号:US09400812B2

    公开(公告)日:2016-07-26

    申请号:US13209224

    申请日:2011-08-12

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

    CPC分类号: G06F17/30309

    摘要: Disclosed is a mechanism, system, interface, and process to determine one or more life intervals when given a key. In addition, one or more life intervals can be determined for each key within a range of keys. This type of process is useful for auditing purposes or if it is desire to implement a query upon past versions when a key or range of keys is specified for the data for which past versions is desired. This facilitates algorithms, mechanisms, and processes to implement a query upon past versions.

    摘要翻译: 公开了一种在给予键时确定一个或多个生命周期的机制,系统,界面和过程。 另外,可以在一系列键内为每个键确定一个或多个生命周期。 这种类型的过程对于审计目的是有用的,或者如果希望在为期望的过去版本的数据指定密钥或密钥范围时希望在过去的版本上实现查询。 这有助于算法,机制和过程来实现过去版本的查询。

    Online recovery of user tables using flashback table
    37.
    发明授权
    Online recovery of user tables using flashback table 有权
    使用闪回表在线恢复用户表

    公开(公告)号:US08832038B2

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

    申请号:US12395957

    申请日:2009-03-02

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

    摘要: A method and apparatus for updating databases are disclosed. In response to a flashback request, a database object is restored to a state as of a specified flashback time. The changes introduced into the database object are reversed in a sequence starting with a change introduced into the database object immediately before issuance of the flashback request and ending with a change introduced into the database object immediately after the specified flashback time.

    摘要翻译: 公开了一种用于更新数据库的方法和装置。 响应闪回请求,数据库对象恢复到指定闪回时间的状态。 引入到数据库对象中的更改在序列中颠倒,从在发出闪回请求之前立即引入到数据库对象中的更改开始,并在指定的闪回时间之后立即引入到数据库对象中的更改结束。

    Querying a cascading index that avoids disk accesses
    38.
    发明授权
    Querying a cascading index that avoids disk accesses 有权
    查询避免磁盘访问的级联索引

    公开(公告)号:US08595248B2

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

    申请号:US12469637

    申请日:2009-05-20

    IPC分类号: G06F17/30

    CPC分类号: G06F11/1474 G06F17/30

    摘要: Techniques for maintaining a cascading index are provided. In one approach, one or more branch node compression techniques are applied to the main index of a cascading index. In an approach, a Bloom filter is generated and associated with, e.g., a branch node in the main index. The Bloom filter is used to determine whether, without accessing any leaf blocks, a particular key value exists, e.g., in leaf blocks associated with the branch node. In an approach, a new redo record is generated in response to a merge operation between two levels of the cascading index. The new redo record comprises (a) one or more addresses of blocks that are affected by the merge operation, (b) data is that being “pushed down” to a lower level of the cascading index, and (c) one or more addresses of blocks that are written to disk storage as a result of the merge operation.

    摘要翻译: 提供了维护级联索引的技术。 在一种方法中,一个或多个分支节点压缩技术被应用于级联索引的主索引。 在一种方法中,生成Bloom过滤器并与例如主索引中的分支节点相关联。 Bloom过滤器用于确定在不访问任何叶片块的情况下是否存在特定的键值,例如在与分支节点相关联的叶片块中。 在一种方法中,响应于级联索引的两个级别之间的合并操作,生成新的重做记录。 新的重做记录包括(a)受合并操作影响的块的一个或多个地址,(b)数据被“下推”到级联索引的较低级,以及(c)一个或多个地址 作为合并操作的结果写入磁盘存储的块。

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

    公开(公告)号:US08583692B2

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

    申请号:US12871882

    申请日:2010-08-30

    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.

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

    DDL and DML support for hybrid columnar compressed tables

    公开(公告)号:US08521784B2

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

    申请号:US12871882

    申请日:2010-08-30

    IPC分类号: G06F17/30

    摘要: 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.