DATABASE SYSTEMS AND RELATED QUEUE MANAGEMENT METHODS

摘要

Systems and methods are provided for processing queues in a database system. An exemplary system includes a database having a plurality of queue tables, with each queue table being associated with a different queue type and having a different schema associated therewith. A server coupled to the database determines a number of threads to allocate to a particular queue based at least in part on a number of entries in a queue table and configuration information associated with the queue and allocates that number of threads to the queue. Each thread causes a processing system of the server to retrieve work detail data for a respective subset of entries of the queue of entries from that queue table in a manner that is influenced by schema associated with that queue table and then perform a task corresponding to the queue type using the work detail data.

主权项

1. A computer system comprising:
a database comprising a plurality of queue tables, each queue table of the plurality of queue tables being associated with a different queue type and each queue table having a different schema associated therewith; and a server coupled to the database to determine a first number of threads to allocate to a first queue of entries of the plurality of queue tables based at least in part on a second number of entries in the first queue table associated with the first queue and configuration information associated with the first queue and allocate the first number of threads to the first queue, wherein each thread of the first number causes a processing system of the server to retrieve work detail data for a respective subset of entries of the first queue of entries from the first queue table in a manner that is influenced by first schema associated with the first queue table and perform a task corresponding to the first queue type using the work detail data.