Invention Grant
- Patent Title: Messages with delayed delivery in an in-database sharded queue
-
Application No.: US15827839Application Date: 2017-11-30
-
Publication No.: US10678614B2Publication Date: 2020-06-09
- Inventor: Devendra Singh , Mukesh Jaiswal , Shubha Bose , Abhilash Tomar
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Becker Bingham LLP
- Main IPC: G06F9/54
- IPC: G06F9/54 ; G06F12/0868 ; G06F16/22 ; G06F16/27 ; G06F16/2455

Abstract:
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.
Public/Granted literature
- US20190163545A1 MESSAGES WITH DELAYED DELIVERY IN AN IN-DATABASE SHARDED QUEUE Public/Granted day:2019-05-30
Information query