公开(公告)号：US6058389A

公开(公告)日：2000-05-02

申请号：US961597

申请日：1997-10-31

Applicant: Sashikanth Chandra ,  Dieter Gawlick ,  Sandeep Jain ,  Hasan Rizvi ,  Premal Shah ,  Alvin To

Inventor： Sashikanth Chandra ,  Dieter Gawlick ,  Sandeep Jain ,  Hasan Rizvi ,  Premal Shah ,  Alvin To

IPC: G06F17/30

CPC classification number: G06F17/3056 ,  G06F17/30321 ,  G06F9/546 ,  G06F2209/548 ,  Y10S707/99931

Abstract: An advanced message queuing system is integrated into a database system. A queue is an ordered list of messages. Messages are requests for processing by an application. Messages are database objects and can represent events or data. Messages comprise user data and control information such as a queue name. Each queue is part of a table in a relational database. A queue table holds a set of queues. Dictionary tables store configuration information describing queues and queue tables. Messages are entered into a queue by instructing the database system using an enqueuing command attached to a message and control information. The control information describes how to order, schedule, and execute the message, and can include a result queue name into which a result message is written after execution. The system responds to a dequeuing command by delivering a copy of a message from the queue. A user can define message order within a queue, message delay factors, and exception processing. Messages may be retained in their queues after delivery and can be preserved, queried, documented, correlated, reviewed and tracked, alone or in a set comprising a transaction, regardless of message state or execution state. The system can be used to develop large-scale, message-oriented distributed applications. Existing development tools for database applications can also be used to develop queuing applications. Administrative functions to create, delete, and specify access control for queues are provided. The system provides transactional integrity; a single transaction applies to both the database and the queue. A single transaction log is maintained.

Abstract translation: 高级消息队列系统被集成到数据库系统中。 队列是消息的有序列表。 消息是应用程序处理的请求。 消息是数据库对象，可以表示事件或数据。 消息包括诸如队列名称的用户数据和控制信息。 每个队列是关系数据库中表的一部分。 队列表包含一组队列。 字典表存储描述队列和队列表的配置信息。 通过使用附加到消息和控制信息的入队命令来指示数据库系统，将消息输入队列。 控制信息描述如何订购，调度和执行消息，并且可以包括在执行结果消息之后写入的结果队列名称。 系统通过从队列传递消息的副本来响应出队命令。 用户可以定义队列内的消息顺序，消息延迟因子和异常处理。 消息可以在交付之后保留在他们的队列中，并且可以单独地或在包括事务的集合中被保留，查询，记录，关联，审查和跟踪，而不管消息状态或执行状态如何。 该系统可用于开发大规模，面向消息的分布式应用程序。 数据库应用程序的现有开发工具也可用于开发排队应用程序。 提供了管理功能来创建，删除和指定队列的访问控制。 系统提供事务完整性; 单个事务也适用于数据库和队列。 维护一个事务日志。