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

1. 发明申请

US20190163545A1 MESSAGES WITH DELAYED DELIVERY IN AN IN-DATABASE SHARDED QUEUE 审中-公开
公开(公告)号：US20190163545A1
公开(公告)日：2019-05-30
申请号：US15827839
申请日：2017-11-30
申请人： Oracle International Corporation
发明人： Devendra Singh , Mukesh Jaiswal , Shubha Bose , Abhilash Tomar
IPC分类号： G06F9/54 , G06F17/30 , G06F12/0868
摘要： A DBMS maintains delayed and non-delayed messages within a non-delay shard and a delay shard that function as a pair. The DBMS stages non-delayed messages in enqueue-time order within the non-delay shard, and maintains a non-delay dequeue pointer that moves in physical order of the enqueued non-delay messages. The DBMS stages delayed messages in enqueue-time order within bucket shards of the delay shard. Each bucket shard, of a delay shard, represents a time span of delivery times, and messages are assigned thereto based on message delivery time. The delay dequeue pointer comprises a sub-routine to determine the message with the minimum delivery time within a current bucket shard with a time span that includes the current time. The DBMS delivers the next available message out of the delayed and non-delayed shards by comparing the delivery time of the next available message from each shard and delivering the earliest available message.

2. 发明申请

US20180060145A1 MESSAGE CACHE MANAGEMENT FOR MESSAGE QUEUES 有权
公开(公告)号：US20180060145A1
公开(公告)日：2018-03-01
申请号：US15254278
申请日：2016-09-01
申请人： Oracle International Corporation
发明人： Mukesh Jaiswal , Shubha Bose , James W. Stamos , Alan R. Downing , Devendra Singh
IPC分类号： G06F9/54 , G06F12/0875
CPC分类号： G06F9/546 , G06F12/0875 , G06F2209/548 , G06F2212/453
摘要： A method and apparatus for message cache management for message queues is provided. A plurality of messages from a plurality of enqueuers are enqueued in a queue comprising one or more shards, each shard comprising one or more subshards. A message cache is maintained in memory. Enqueuing a message includes enqueuing the message in a current subshard of a particular shard, which includes storing the message in a cached subshard corresponding to the current subshard of the particular shard. For each dequeuer-shard pair, a dequeue rate is determined. Estimated access time data is generated that includes an earliest estimated access time for each of a plurality of subshards based on the dequeuer-shard pair dequeue rates. A set of subshards is determined for storing as cached subshards in the message cache based on the earliest estimated access times for the plurality of subshards.

3. 发明授权

US09495296B2 Handling memory pressure in an in-database sharded queue 有权
标题翻译：处理数据库内的分片队列中的内存压力
公开(公告)号：US09495296B2
公开(公告)日：2016-11-15
申请号：US14165974
申请日：2014-01-28
申请人： Oracle International Corporation
发明人： Sunitha Subramanyam , Shubha Bose , Anil Madan , Devendra Singh , James W. Stamos , Mukesh Jaiswal
IPC分类号： G06F17/30 , G06F12/08
CPC分类号： G06F12/0848 , G06F12/0868 , G06F17/30067 , G06F2212/465
摘要： Handling memory pressure in an in-database sharded queue is described. Messages from a plurality of enqueuers are stored in a plurality of shards of a sharded queue. Messages from a first enqueuer are stored in a first shard. A queue table corresponding to the sharded queue is maintained. In volatile memory, a plurality of message caches is maintained, each message cache corresponding to a shard of the plurality of shards. Memory pressure is detected based on memory usage of the volatile memory. To store a specific message from the enqueuer, the specific message is stored in rows of the queue table that are assigned to the first shard. When memory pressure is not detected, the specific message is stored in a first message cache corresponding to the first shard. Subscribers of the sharded queue are caused to dequeue messages from the plurality of shards.
摘要翻译：描述处理数据库内的分片队列中的内存压力。来自多个入站者的消息被存储在分片队列的多个分片中。来自第一个进入者的消息存储在第一个分片中。维护与分片队列对应的队列表。在易失性存储器中，维护多个消息高速缓存，每个消息高速缓存对应于多个分片中的分片。基于易失性存储器的存储器使用来检测存储器压力。要从进入者存储特定消息，特定消息存储在分配给第一个分片的队列表的行中。当未检测到存储器压力时，特定消息存储在与第一分片对应的第一消息高速缓存中。导致分片队列的订阅者从多个分片中发出消息。

4. 发明申请

US20220164320A1 AUTONOMOUS DEPLOYMENT OF MULTIPLE DATABASE FILE SYSTEMS 有权
公开(公告)号：US20220164320A1
公开(公告)日：2022-05-26
申请号：US17387708
申请日：2021-07-28
申请人： Oracle International Corporation
发明人： Parthasarathy Elangadu Raghunathan , Shishir Mathur , Shubha Bose , Aurosish Mishra
IPC分类号： G06F16/188 , G06F11/34 , G06F16/11 , G06F9/48
摘要： A manager file system (MFS) runs as a user space file system. The MFS, implemented using an OS process, exposes a mount point as a communication endpoint to the single process. Mounting, unmounting, and changing configuration of individual database file systems (DBFSs) are done by overloading extended attributes on the mount point. The MFS services all DBFSs mounted at different mount points registered to the single process of the MFS and ensures optimal resource utilization among the DBFSs in the single process while guaranteeing resource isolation. Multiple MFSs may be created to manage sets of DBFSs.

5. 发明授权

US10540217B2 Message cache sizing 有权
公开(公告)号：US10540217B2
公开(公告)日：2020-01-21
申请号：US15685270
申请日：2017-08-24
申请人： Oracle International Corporation
发明人： Mukesh Jaiswal , Shubha Bose , James W. Stamos , Alan R. Downing
IPC分类号： G06F9/54 , G06F12/0811
摘要： A method and apparatus for message cache sizing are provided. A plurality of messages from one or more enqueuers are enqueued in a queue comprising at least one shard. Each shard includes one or more subshards. A message cache configured to store a plurality of cached subshards is maintained in memory. The plurality of messages is dequeued from the message cache by one or more dequeuers. An estimated enqueue rate is determined for each shard. An estimated dequeue rate is determined for each dequeuer-shard pair. Estimated restore overhead data is determined over a range of candidate message cache sizes based on the estimated enqueue rate for each shard and the estimated dequeue rate for each dequeuer-shard pair. A preferred message cache size is determined based on the estimated restore overhead data.

6. 发明申请

US20180081745A1 MESSAGE CACHE SIZING 审中-公开
公开(公告)号：US20180081745A1
公开(公告)日：2018-03-22
申请号：US15685270
申请日：2017-08-24
申请人： Oracle International Corporation
发明人： Mukesh Jaiswal , Shubha Bose , James W. Stamos , Alan R. Downing
IPC分类号： G06F9/54 , G06F12/0811
摘要： A method and apparatus for message cache sizing are provided. A plurality of messages from one or more enqueuers are enqueued in a queue comprising at least one shard. Each shard includes one or more subshards. A message cache configured to store a plurality of cached subshards is maintained in memory. The plurality of messages is dequeued from the message cache by one or more dequeuers. An estimated enqueue rate is determined for each shard. An estimated dequeue rate is determined for each dequeuer-shard pair. Estimated restore overhead data is determined over a range of candidate message cache sizes based on the estimated enqueue rate for each shard and the estimated dequeue rate for each dequeuer-shard pair. A preferred message cache size is determined based on the estimated restore overhead data.

7. 发明申请

US20220164321A1 SCALABLE FRAMEWORK FOR MANAGING CONCURRENT ACCESSES TO DATABASE FILE SYSTEMS 有权
公开(公告)号：US20220164321A1
公开(公告)日：2022-05-26
申请号：US17387718
申请日：2021-07-28
申请人： Oracle International Corporation
发明人： Parthasarathy Elangadu Raghunathan , Shishir Mathur , Shubha Bose , Aurosish Mishra
IPC分类号： G06F16/188 , G06F16/13 , G06F9/455
摘要： A manager file system (MFS) runs as a user space file system. The MFS, implemented using an OS process, exposes a mount point as a communication endpoint to the single process. Mounting, unmounting, and changing configuration of individual database file systems (DBFSs) are done by overloading extended attributes on the mount point. The MFS services all DBFSs mounted at different mount points registered to the single process of the MFS and ensures optimal resource utilization among the DBFSs in the single process while guaranteeing resource isolation.

8. 发明授权

US10678614B2 Messages with delayed delivery in an in-database sharded queue 有权
公开(公告)号：US10678614B2
公开(公告)日：2020-06-09
申请号：US15827839
申请日：2017-11-30
申请人： Oracle International Corporation
发明人： Devendra Singh , Mukesh Jaiswal , Shubha Bose , Abhilash Tomar
IPC分类号： G06F9/54 , G06F12/0868 , G06F16/22 , G06F16/27 , G06F16/2455
摘要： A DBMS maintains delayed and non-delayed messages within a non-delay shard and a delay shard that function as a pair. The DBMS stages non-delayed messages in enqueue-time order within the non-delay shard, and maintains a non-delay dequeue pointer that moves in physical order of the enqueued non-delay messages. The DBMS stages delayed messages in enqueue-time order within bucket shards of the delay shard. Each bucket shard, of a delay shard, represents a time span of delivery times, and messages are assigned thereto based on message delivery time. The delay dequeue pointer comprises a sub-routine to determine the message with the minimum delivery time within a current bucket shard with a time span that includes the current time. The DBMS delivers the next available message out of the delayed and non-delayed shards by comparing the delivery time of the next available message from each shard and delivering the earliest available message.

9. 发明授权

US09996404B2 Message cache management for message queues 有权
公开(公告)号：US09996404B2
公开(公告)日：2018-06-12
申请号：US15254278
申请日：2016-09-01
申请人： Oracle International Corporation
发明人： Mukesh Jaiswal , Shubha Bose , James W. Stamos , Alan R. Downing , Devendra Singh
IPC分类号： G06F3/00 , G06F9/44 , G06F9/48 , G06F13/00 , G06F9/54 , G06F12/0875
CPC分类号： G06F9/546 , G06F12/0875 , G06F2209/548 , G06F2212/453
摘要： A method and apparatus for message cache management for message queues is provided. A plurality of messages from a plurality of enqueuers are enqueued in a queue comprising one or more shards, each shard comprising one or more subshards. A message cache is maintained in memory. Enqueuing a message includes enqueuing the message in a current subshard of a particular shard, which includes storing the message in a cached subshard corresponding to the current subshard of the particular shard. For each dequeuer-shard pair, a dequeue rate is determined. Estimated access time data is generated that includes an earliest estimated access time for each of a plurality of subshards based on the dequeuer-shard pair dequeue rates. A set of subshards is determined for storing as cached subshards in the message cache based on the earliest estimated access times for the plurality of subshards.

10. 发明申请

US20140372486A1 In-Database Sharded Queue 有权
标题翻译：数据库内分片队列
公开(公告)号：US20140372486A1
公开(公告)日：2014-12-18
申请号：US14095543
申请日：2013-12-03
申请人： Oracle International Corporation
发明人： Shubha Bose , Devendra Singh , Neerja Bhatt , Sujatha Janardhanan , Gaurav Garg , Yang Seok Ki , Abhishek Saxena , Alan Downing
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , G06F9/546 , G06F17/30575 , G06F17/30607
摘要： A method and apparatus for an in-database sharded queue that supports JMS session ordering is provided. Messages from a plurality of enqueuers are stored in a plurality of shards of a particular queue. For each enqueuer, all messages are stored in only one of the shards. Each shard includes one or more subshards, each subshard having one or more partitions of a queue table maintained by a relational database system. All messages from a first enqueuer are stored in partitions of the queue table that are assigned to a first shard of the plurality of shards. All messages from a second enqueuer are stored in partitions of the queue table that are assigned to a second shard of the plurality of shards. Subscribers of the particular queue are caused to dequeue messages from the plurality of shards.
摘要翻译：提供了一种支持JMS会话排序的数据库内分片队列的方法和装置。来自多个入站者的消息被存储在特定队列的多个分片中。对于每个进入者，所有消息都只存储在其中一个分片中。每个分片包括一个或多个子硬件，每个子硬件具有由关系数据库系统维护的队列表的一个或多个分区。来自第一入站者的所有消息都存储在分配给多个分片的第一分片的队列表的分区中。来自第二进入者的所有消息都存储在分配给多个分片的第二分片的队列表的分区中。导致特定队列的订阅者从多个分片中出现消息。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式