Oracle International Corporation

Sujatha Janardhanan

Yang Seok Ki

Gaurav Garg

Neerja Bhatt

Alan Robert Downing

Abhishek Saxena

Shubha Bose

Devendra Singh

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.

In-database sharded queue

Growing community of inventors

Foster City, CA, United States of America

Sujatha Janardhanan