专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

31. 发明授权

US07346690B1 Deferred piggybacked messaging mechanism for session reuse 有权
标题翻译：延迟捎带的消息传递机制，用于会话重用
公开(公告)号：US07346690B1
公开(公告)日：2008-03-18
申请号：US10160128
申请日：2002-05-30
申请人： Bipul Sinha , Amit Ganesh , Lakshminarayanan Chidambaran
发明人： Bipul Sinha , Amit Ganesh , Lakshminarayanan Chidambaran
IPC分类号： G06F15/16 , G06F7/00
CPC分类号： G06F17/30286 , Y10S707/99942
摘要： 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.
摘要翻译：这里描述的是重用在远程参与者上已建立的会话来执行自主事务的会话重用方法。会话被重复使用，以避免影响会话状态的方式不利于稍后执行包含事务。当在本地参与者开始自主交易时，如果包含的交易是分布式交易，则在远程参与者上发起自主交易的请求被推迟或不被发送。该请求可以稍后发送，使用搭载邮件系统捎带到另一个消息。当结束自主交易时，本地参与者可以向远程参与者发送请求，请求远程参与者开始执行其相应的包含交易。该请求捎带到另一个消息，并且因此被传送而不必分别发送请求，避免信息往返。

32. 发明申请

US20060122963A1 System and method for performing a data uniqueness check in a sorted data set 有权
标题翻译：用于在排序数据集中执行数据唯一性检查的系统和方法
公开(公告)号：US20060122963A1
公开(公告)日：2006-06-08
申请号：US10984113
申请日：2004-11-08
申请人： Jonathan Klein , Bipul Sinha , Amit Ganesh
发明人： Jonathan Klein , Bipul Sinha , Amit Ganesh
IPC分类号： G06F17/30
CPC分类号： G06F17/30312 , G06F17/30371
摘要： Embodiments of the present invention include a method for performing a data uniqueness check in a set of sorted data blocks comprising accessing data to be inserted into the set of sorted data blocks, determining a proper data block of the set of sorted data blocks for which the data to be inserted should be located based on a first sorting key. The method further includes examining the proper data block for an existing data entry and if the proper data block is empty, the method further includes inserting the data to be inserted into the proper data block of the set of sorted data blocks.
摘要翻译：本发明的实施例包括一种用于在一组分类数据块中执行数据唯一性检查的方法，包括访问要插入到该排序数据块集合中的数据，确定该排序数据块集合中的适当数据块，应插入的数据应基于第一个排序键来定位。该方法还包括检查现有数据条目的正确数据块，如果正确的数据块为空，则该方法还包括将要插入的数据插入到该排序数据块集合的正确数据块中。

33. 发明申请

US20050278359A1 Providing mappings between logical time values and real time values in a multinode system 有权
标题翻译：在多节点系统中提供逻辑时间值和实时值之间的映射
公开(公告)号：US20050278359A1
公开(公告)日：2005-12-15
申请号：US10866234
申请日：2004-06-10
申请人： Wanli Yang , Bipul Sinha , Amit Ganesh
发明人： Wanli Yang , Bipul Sinha , Amit Ganesh
IPC分类号： G06F7/00
CPC分类号： G06F17/30557 , Y10S707/99952
摘要： 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。

34. 发明申请

US20050055381A1 Active queries filter extraction 审中-公开
标题翻译：主动查询过滤提取
公开(公告)号：US20050055381A1
公开(公告)日：2005-03-10
申请号：US10866433
申请日：2004-06-10
申请人： Amit Ganesh , Bipul Sinha , Srinivas Vemuri
发明人： Amit Ganesh , Bipul Sinha , Srinivas Vemuri
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.
摘要翻译：查询结果集是其内容由查询定义的数据主体类型的示例。对数据库的修改可以改变查询的结果，因此这样一个数据体的内容，比如结果集，应该是什么。活动查询是一种使数据库服务器能够检测数据库更改的方法，可更改为客户端注册的查询结果，并通知客户端这些更改。通知可以被发送到例如负责维护由查询生成的结果集缓存的一致性的高速缓存管理器。该通知通知高速缓存管理器需要什么时候和/或需要什么改变来维持高速缓存的一致性。

35. 发明授权

US08856083B2 Framework to optimize delete all row operations on database objects to improve throughput, query ability and flashback 有权
标题翻译：优化框架来删除数据库对象上的所有行操作，以提高吞吐量，查询能力和回发
公开(公告)号：US08856083B2
公开(公告)日：2014-10-07
申请号：US11450092
申请日：2006-06-09
申请人： Amit Ganesh , Niloy Mukherjee , Manosiz Bhattacharyya , Bipul Sinha
发明人： Amit Ganesh , Niloy Mukherjee , Manosiz Bhattacharyya , Bipul Sinha
IPC分类号： G06F7/00 , G06F17/30 , G06F17/00
CPC分类号： G06F17/30442
摘要： A bulk delete operation with reduced latency allows for retrieval of deleted data. Each database object holds a Delete SCN indicating when a bulk delete operation was last performed. Each row in the database object holds a Row Modification SCN indicating when the row was last updated. A bulk delete is performed by writing the old value of the Delete SCN to the undo tablespace and updating the Delete SCN. No undo information is stored for the rows. A write is performed by finding a deleted row, storing undo information for the deleted row and writing over the deleted row. To read from the database object, a rollback operation is performed, if necessary. Those rows are then retrieved for which the Row Modification SCN is higher than the Delete SCN and is less than or equal to the timestamp for the requested data.
摘要翻译：减少延迟的批量删除操作允许检索已删除的数据。每个数据库对象保存一个删除SCN，指示上次执行批量删除操作的时间。数据库对象中的每一行都保存一行行修改SCN，指示行何时上次更新。通过将删除SCN的旧值写入undo表空间并更新删除SCN来执行批量删除。没有为行存储撤消信息。通过查找删除的行，存储删除的行的撤消信息并写入被删除的行来执行写入。要从数据库对象读取，必要时执行回滚操作。然后检索行修改SCN高于删除SCN并且小于或等于所请求数据的时间戳的那些行。

36. 发明申请

US20100036831A1 GENERATING CONTINUOUS QUERY NOTIFICATIONS 有权
标题翻译：生成连续查询通知
公开(公告)号：US20100036831A1
公开(公告)日：2010-02-11
申请号：US12189078
申请日：2008-08-08
申请人： Srinivas S. Vemuri , Bipul Sinha , Amit Ganesh , Subramanyam B. Chitti
发明人： Srinivas S. Vemuri , Bipul Sinha , Amit Ganesh , Subramanyam B. Chitti
IPC分类号： G06F17/30
CPC分类号： G06F17/30516
摘要： Techniques are described to allow a query to be registered as a persistent stored entity within the database, and to generate notifications as and when the query result changes continuously as long as the query continues to be registered with the database. According to one aspect, for a table referenced in a query, a filter condition is generated based, at least in part, on a predicate of the query. Then, the database server determines whether the filter condition is satisfied by either a before image of a row, or an after image of the row, that was modified by a transaction. If the filter condition is satisfied by either the before image or the after image, then the query is added to a first set of queries whose result sets may have been affected by the transaction. From among the first set of queries, a second set of queries that have result sets that were actually affected by the transaction is determined. Notifications are then sent based on the second set of queries.
摘要翻译：描述技术来允许将查询注册为数据库内的持久存储实体，并且只要查询继续向数据库注册，就可以随着查询结果不断更改而生成通知。根据一个方面，对于在查询中引用的表，基于至少部分地基于查询的谓词生成过滤条件。然后，数据库服务器通过由事务修改的行的先前图像或行的后续图像来确定滤波器条件是否满足。如果过滤条件由前图像或后图像所满足，则将查询添加到其结果集可能受事务影响的第一组查询中。从第一组查询中，确定具有实际受事务影响的结果集的第二组查询。然后基于第二组查询发送通知。

37. 发明授权

US07624112B2 Asynchronously storing transaction information from memory to a persistent storage 有权
标题翻译：将存储器中的事务信息异步存储到持久存储器
公开(公告)号：US07624112B2
公开(公告)日：2009-11-24
申请号：US10407998
申请日：2003-04-03
申请人： Amit Ganesh , Bipul Sinha , Lakshminarayanan Chidambaran
发明人： Amit Ganesh , Bipul Sinha , Lakshminarayanan Chidambaran
IPC分类号： G06F17/00
CPC分类号： G06F9/466
摘要： A method and apparatus for asynchronously storing transaction information related to a transaction is provided. A client process executing on a client may initiate a transaction request with a server. The server processes the transaction, commits the transaction, and writes transaction information associated with the transaction to memory without durably storing the transaction information. Thereafter, the server processing the transaction returns a message to the client that the transaction has been committed. A server process, which performed the transaction, may be reassigned to commit new work. Additional information that may be useful for the client about the result of the transaction may be contained in the message. Next, transaction information stored in memory is durably stored. A log writer may be used to durably store the transaction information to a log file. The client is subsequently notified that the transaction information has been durably stored at a client listening process.
摘要翻译：提供了用于异步地存储与事务相关的交易信息的方法和装置。在客户端上执行的客户端进程可以发起与服务器的事务请求。服务器处理事务，提交事务，并将与事务相关联的事务信息写入到存储器中，而不会持久地存储事务信息。此后，处理该事务的服务器向客户端返回一个消息，即该事务已被提交。执行该事务的服务器进程可能被重新分配以提交新的工作。可能对客户有关事务结果有用的其他信息可能包含在消息中。接下来，存储在存储器中的交易信息被持久地存储。可以使用日志写入器将事务信息持久地存储到日志文件中。随后通知客户事务信息已经在客户端监听过程中持久存储。

38. 发明授权

US07251660B2 Providing mappings between logical time values and real time values in a multinode system 有权
标题翻译：在多节点系统中提供逻辑时间值和实时值之间的映射
公开(公告)号：US07251660B2
公开(公告)日：2007-07-31
申请号：US10866234
申请日：2004-06-10
申请人： Wanli Yang , Bipul Sinha , Amit Ganesh
发明人： Wanli Yang , Bipul Sinha , Amit Ganesh
IPC分类号： G06F17/00 , G06F7/00
CPC分类号： G06F17/30557 , Y10S707/99952
摘要： 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。

39. 发明授权

US06981004B2 Method and mechanism for implementing in-memory transaction logging records 有权
标题翻译：实现内存中事务日志记录的方法和机制
公开(公告)号：US06981004B2
公开(公告)日：2005-12-27
申请号：US10245602
申请日：2002-09-16
申请人： Amit Ganesh , Srinivas Vemuri , Jonathan Klein , Bipul Sinha
发明人： Amit Ganesh , Srinivas Vemuri , Jonathan Klein , Bipul Sinha
IPC分类号： G06F17/30
CPC分类号： G06F17/30368 , G06F17/30371 , Y10S707/99953
摘要： A method and mechanism is disclosed for implementing transaction logging in a database system. In-memory undo records are maintained to log undo information for the database system. Redo records are batch processed, with multiple redo records for a transaction stored on disk at commit time.
摘要翻译：公开了一种在数据库系统中实现事务日志记录的方法和机制。维护内存中的撤销记录以记录数据库系统的撤消信息。重做记录是批量处理的，在提交时存储在磁盘上的事务具有多个重做记录。

40. 发明申请

US20050278350A1 Providing mappings between logical time values and real time values 有权
标题翻译：提供逻辑时间值和实时值之间的映射
公开(公告)号：US20050278350A1
公开(公告)日：2005-12-15
申请号：US10856569
申请日：2004-05-27
申请人： Wanli Yang , Bipul Sinha , Amit Ganesh
发明人： Wanli Yang , Bipul Sinha , Amit Ganesh
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30551 , Y10S707/99952
摘要： Techniques are provided for providing mappings between logical time values and real time values for a database. The techniques include, if a first event related to the database occurs, writing an entry of a current LTV and a current RTV in a volatile mapping data structure; and if a second event related to the database occurs, writing one or more entries in a non-volatile mapping data structure based on information contained in the volatile mapping data structure. The techniques also include, once a request from a requestor to provide an LTV that is mapped to a particular RTV is received, determining the LTV for the particular RTV, based on the particular RTV and information from a source, wherein the source is one of the volatile mapping data structure and the non-volatile mapping data structure; and providing the LTV that is mapped to the particular RTV to the requestor.
摘要翻译：提供了提供数据库的逻辑时间值和实时值之间的映射的技术。这些技术包括：如果发生与数据库相关的第一事件，则在易失性映射数据结构中写入当前LTV和当前RTV的条目; 并且如果发生与数据库有关的第二事件，则基于包含在易失性映射数据结构中的信息，在非易失性映射数据结构中写入一个或多个条目。所述技术还包括，一旦来自请求者提供映射到特定RTV的LTV的请求被接收，则基于特定RTV和来自源的信息确定特定RTV的LTV，其中源是源易失性映射数据结构和非易失性映射数据结构; 以及将映射到特定RTV的LTV提供给请求者。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式