公开(公告)号：US6058389A

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

申请号：US961597

申请日：1997-10-31

申请人： Sashikanth Chandra ,  Dieter Gawlick ,  Sandeep Jain ,  Hasan Rizvi ,  Premal Shah ,  Alvin To

发明人： Sashikanth Chandra ,  Dieter Gawlick ,  Sandeep Jain ,  Hasan Rizvi ,  Premal Shah ,  Alvin To

IPC分类号： G06F17/30

CPC分类号： G06F17/3056 ,  G06F17/30321 ,  G06F9/546 ,  G06F2209/548 ,  Y10S707/99931

摘要： 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.

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

公开(公告)号：US20060212422A1

公开(公告)日：2006-09-21

申请号：US11245864

申请日：2005-10-07

申请人： Anil Khilani ,  Hasan Rizvi ,  Harish Akali ,  Karen McKeen

发明人： Anil Khilani ,  Hasan Rizvi ,  Harish Akali ,  Karen McKeen

IPC分类号： G06F17/30

CPC分类号： G06F9/45512

摘要： According to one embodiment of the invention, a technique is provided for interactive execution of commands on multiple computer targets. As the commands execute on the remote systems, the user receives feedback in real time. The feedback consists of the status of each command on each system and the output from each command executed on each system, among other items. The feedback is formatted in a user-friendly fashion to enable the user to quickly determine the status of the job, such as which systems have succeeded in executing the commands and which have failed. The feedback also indicates which systems are currently being operated on. The feedback may be viewed in real time as well as saved to a file for later viewing. In one embodiment, the user is also provided with a graphical user interface (GUI).

摘要翻译： 根据本发明的一个实施例，提供了一种用于在多个计算机目标上交互执行命令的技术。 当命令在远程系统上执行时，用户实时接收反馈。 反馈由每个系统上的每个命令的状态和每个系统上执行的每个命令的输出以及其他项目组成。 反馈以用户友好的方式进行格式化，以使用户能够快速确定作业的状态，例如哪些系统成功执行命令并且失败了。 反馈还指出目前正在运行的系统。 反馈可以被实时查看，也可以保存到文件中供以后查看。 在一个实施例中，用户还具有图形用户界面（GUI）。

公开(公告)号：US06490610B1

公开(公告)日：2002-12-03

申请号：US08866842

申请日：1997-05-30

申请人： Hasan Rizvi ,  Ekrem Soylemez ,  Juan R. Loaiza ,  Robert J. Jenkins, Jr.

发明人： Hasan Rizvi ,  Ekrem Soylemez ,  Juan R. Loaiza ,  Robert J. Jenkins, Jr.

IPC分类号： G06F900

CPC分类号： G06F11/2046 ,  G06F11/2028 ,  G06F11/2038 ,  H04L41/0663 ,  H04L43/0811 ,  H04L67/14 ,  H04L69/40 ,  Y10S707/99953

摘要： A method and system for recovering after failure of a first server to which a client was connected for accessing a resource is provided. When it is detected that a connection between the first server and the client has failed, the client is automatically connected with a second server that has access to the resource. After automatically connecting the client, the client accesses the resource through the second server. The client stores information about the state of the session with the first server so that processing can continue where it left off after the client connects with the second server. The client may be pre-connected to the second server prior to the failure of the first server to reduce the latency caused by switching in response to a failure. The second server may be configured to pre-parse the commands that the client issues to the first server to further reduce the latency associated with switching to the second server.

摘要翻译： 提供了一种用于在连接了客户机以访问资源的第一服务器故障之后恢复的方法和系统。 当检测到第一服务器和客户端之间的连接发生故障时，客户机将自动连接到可访问该资源的第二个服务器。 客户端自动连接后，客户端通过第二台服务器访问资源。 客户端存储有关第一台服务器的会话状态的信息，以便在客户端与第二台服务器连接后，处理可以继续停止。 在第一服务器发生故障之前，客户端可能被预连接到第二服务器，以减少由于故障而导致的切换所引起的等待时间。 第二服务器可以被配置为预先解析客户端向第一服务器发出的命令，以进一步减少与切换到第二服务器相关联的延迟。

公开(公告)号：US06804671B1

公开(公告)日：2004-10-12

申请号：US10353381

申请日：2003-01-28

申请人： Juan R. Loaiza ,  Hasan Rizvi ,  J. William Lee ,  William H. Bridge, Jr. ,  Jonathan D. Klein ,  Alex Tsukerman ,  Gianfranco Putzolu

发明人： Juan R. Loaiza ,  Hasan Rizvi ,  J. William Lee ,  William H. Bridge, Jr. ,  Jonathan D. Klein ,  Alex Tsukerman ,  Gianfranco Putzolu

IPC分类号： G06F1730

CPC分类号： G06F17/30952 ,  Y10S707/959 ,  Y10S707/99937 ,  Y10S707/99942 ,  Y10S707/99955

摘要： A pluggable tablespace is enabled by logically partitioning a database into a set of tablespaces and storing all of the tablespaces disk pointers in tablespace-relative format. A pluggable set of tablespaces is unplugged by generating the associated metadata, and making a binary copy of the tablespaces. The pluggable set of tablespaces is plugged into a target database by making the pluggable set accessible to the target database and incorporating the associated metadata, without patching any of the disk pointers.

摘要翻译： 通过将数据库逻辑分区为一组表空间并以表空间相对格式存储所有表空间磁盘指针来启用可插入表空间。 通过生成相关联的元数据并创建表空间的二进制副本，可以拔掉一组可插拔的表空间。 可插入的表空间集合通过使可插入集合可访问目标数据库并结合相关联的元数据而插入到目标数据库中，而无需修补任何磁盘指针。

公开(公告)号：US5850507A

公开(公告)日：1998-12-15

申请号：US618443

申请日：1996-03-19

申请人： Gary C. Ngai ,  Hasan Rizvi ,  Leng Leng Tan

发明人： Gary C. Ngai ,  Hasan Rizvi ,  Leng Leng Tan

IPC分类号： G06F11/14 ,  G06F11/00

CPC分类号： G06F11/1474 ,  G06F2201/80 ,  Y10S707/99953

摘要： A method and system for recovering after a crash of an instance in a database is disclosed. According to the method, transaction information corresponding to all the transactions that existed in the failed instance is inspected. These transactions that were active at the time the instance crashed are marked as "dead." The database is made available to users after updating the transaction information and before undoing all of the changes or updates performed by dead transactions. The changes made by the dead transactions may be undone by new transactions on a on-demand basis after the database is made available. Specifically, when a new transaction is waiting to obtain a lock on a resource held by another transaction, the new transaction determines whether the owner of the lock is one of the dead transactions. If so, the new transaction rolls back some or all of the changes made by the dead transaction.

摘要翻译： 公开了在数据库中的实例崩溃之后恢复的方法和系统。 根据该方法，检查与失败实例中存在的所有事务相对应的事务信息。 在实例崩溃时活动的这些事务被标记为“死亡”。 数据库在更新事务信息之后以及在撤销由死锁事务执行的所有更改或更新之前可用于用户。 在数据库可用之后，死亡交易所做的更改可能会在需求的基础上被新的交易撤销。 具体来说，当新事务正在等待获取另一个事务所持有的资源的锁时，新的事务将确定该锁的所有者是否是其中一个死锁事务。 如果是这样，新的事务会回滚一些或所有由死的事务所做的更改。

公开(公告)号：US06549901B1

公开(公告)日：2003-04-15

申请号：US09675195

申请日：2000-09-29

申请人： Juan R. Loaiza ,  Hasan Rizvi ,  J. William Lee ,  William H. Bridge, Jr. ,  Jonathan D. Klein ,  Alex Tsukerman ,  Gianfranco Putzolu

发明人： Juan R. Loaiza ,  Hasan Rizvi ,  J. William Lee ,  William H. Bridge, Jr. ,  Jonathan D. Klein ,  Alex Tsukerman ,  Gianfranco Putzolu

IPC分类号： G06F1730

CPC分类号： G06F17/30952 ,  Y10S707/99937

摘要： Provided are mechanisms that may be used to support efficient exportation of user data stored in a database system. According to an aspect of the present invention, a database system is configured to store data for users in separate repositories referred to as tablespaces. To store data in this manner, a database system may be configured in variety of ways.

摘要翻译： 提供了可用于支持存储在数据库系统中的用户数据的有效输出的机制。 根据本发明的一个方面，数据库系统被配置为将数据存储在被称为表空间的分开的存储库中。 为了以这种方式存储数据，可以以各种方式配置数据库系统。

公开(公告)号：US06199110B1

公开(公告)日：2001-03-06

申请号：US08866204

申请日：1997-05-30

申请人： Hasan Rizvi ,  Ekrem Soylemez ,  Juan R. Loaiza

发明人： Hasan Rizvi ,  Ekrem Soylemez ,  Juan R. Loaiza

IPC分类号： G06F1730

CPC分类号： H04L67/1034 ,  G06F17/30348 ,  H04L67/1002 ,  H04L67/14 ,  H04L69/329 ,  H04L69/40 ,  Y10S707/99953

摘要： A method and apparatus are provided for passing a client from a first server to which the client was connected for accessing a resource, to a second server for accessing the resource. While executing, the first server ceases to respond to the client. After the client detects that the first server has ceased to respond to the client, the client is automatically connected with the second server that has access to the resource. After automatically connecting the client, the client accesses the resource through the second server. The client stores information about the state of the session with the first server so that processing can continue where it left off after the client connects with the second server. The client may be pre-connected to the second server prior to the failure of the first server to reduce the latency caused by switching in response to a failure. The second server may be configured to pre-parse the commands that the client issues to the first server to further reduce the latency associated with switching to the second server.

摘要翻译： 提供了一种方法和装置，用于将客户端从客户端连接的用于访问资源的第一服务器传递到用于访问资源的第二服务器。 在执行时，第一个服务器停止响应客户端。 在客户端检测到第一台服务器已经停止响应客户端之后，客户机将自动连接到具有访问该资源的第二台服务器。 客户端自动连接后，客户端通过第二台服务器访问资源。 客户端存储有关第一台服务器的会话状态的信息，以便在客户端与第二台服务器连接后，处理可以继续停止。 在第一服务器发生故障之前，客户端可能被预连接到第二服务器，以减少由于故障而导致的切换所引起的等待时间。 第二服务器可以被配置为预先解析客户端向第一服务器发出的命令，以进一步减少与切换到第二服务器相关联的延迟。

公开(公告)号：US06182241B2

公开(公告)日：2001-01-30

申请号：US09141765

申请日：1998-08-27

申请人： Gary C. Ngai ,  Hasan Rizvi ,  Leng Leng Tan

发明人： Gary C. Ngai ,  Hasan Rizvi ,  Leng Leng Tan

IPC分类号： H02H305

CPC分类号： G06F11/1474 ,  G06F2201/80 ,  Y10S707/99953

摘要： An approach for recovering after premature termination of a plurality of transactions involves: A) selecting a previously unselected transaction from the plurality of transactions; B) processing the selected transaction by undoing the lesser of a predetermined number of changes made by the selected transaction and all changes made by the selected transaction; and C) repeating steps A) and B) until all of the plurality of transactions have been processed. Another aspect of the approach involves: A) selecting a previously unselected transaction from the plurality of transactions, wherein the selected transaction is the previously unselected transaction from the plurality of transactions that made the fewest number of changes in the database; B) processing the selected transaction by undoing one or more changes in the database made by the selected transaction; and C) repeating steps A) and B) until all transactions from the plurality of transactions have been processed.

摘要翻译： 在多个交易提前终止之后恢复的方法包括：A）从多个交易中选择先前未选择的交易; B）通过撤销由所选择的交易进行的预定数量的改变中的较小者以及由所选择的交易进行的所有改变来处理所选择的交易; 和C）重复步骤A）和B），直到所有多个事务已被处理。 该方法的另一方面涉及：A）从所述多个事务中选择先前未选择的事务，其中所选择的事务是来自所述多个事务中的先前未选择的事务，所述事务在所述数据库中作出最少数量的更改; B）通过撤销由所选择的事务所做的数据库中的一个或多个变化来处理所选择的事务; 和C）重复步骤A）和B），直到来自多个事务的所有交易已被处理。

公开(公告)号：US06738971B2

公开(公告)日：2004-05-18

申请号：US09266046

申请日：1999-03-10

申请人： Sashikanth Chandrasekaran ,  Hasan Rizvi

发明人： Sashikanth Chandrasekaran ,  Hasan Rizvi

IPC分类号： G06F946

CPC分类号： G06F9/466

摘要： A method and apparatus are provided for using a resource manager to coordinate the committing of a distributed transaction. According to the method, a first set of changes is communicated to a first resource manager. In communicating the first set of changes, the changes are directly communicated to the first resource manager without being received at a second resource manager. A second set of changes is communicated to the second resource manager. In communicating the second set of changes, the changes are directly communicated to the second resource manager without being received at the first resource manager. Either the first resource manager or the second resource manager is selected as a committing coordinator. A commit request message is transmitted to the committing coordinator to request that the first set of changes be committed at the first resource manager and that the second set of changes be committed at the second resource manager. In response to receiving the commit request message, the committing coordinator causes, as an atomic unit of work, the first set of changes to be committed at the first resource manager and the second set of changes to be committed at the second resource manager.

摘要翻译： 提供了一种使用资源管理器来协调分布式事务的提交的方法和装置。 根据该方法，将第一组改变传送给第一资源管理器。 在传送第一组更改时，将更改直接传递给第一资源管理器，而不在第二资源管理器处接收。 第二组更改通知给第二个资源管理器。 在通信第二组改变时，将改变直接传送到第二资源管理器而不在第一资源管理器处被接收。 选择第一个资源管理器或第二个资源管理器作为提交协调器。 提交请求消息被发送到提交协调器以请求在第一资源管理器处提交第一组更改，并且在第二资源管理器处提交第二组更改。 响应于接收到提交请求消息，提交协调器导致在第一资源管理器处提交的第一组更改作为原子工作单元，以及将在第二资源管理器处提交的第二组更改。

公开(公告)号：US5734896A

公开(公告)日：1998-03-31

申请号：US641330

申请日：1996-04-30

申请人： Hasan Rizvi ,  Anupam Bhide

发明人： Hasan Rizvi ,  Anupam Bhide

IPC分类号： G06F9/46 ,  G06F11/14 ,  G06F17/30 ,  G05F17/30

CPC分类号： G06F11/1474 ,  G06F17/30371 ,  G06F9/466 ,  Y10S707/99953

摘要： A computer system and method are provided in which an existing database instance is able to report the status of an externally initiated distributed transaction that existed in another database instance that has crashed. The existing database instance is also able to roll back or commit the changes made by the externally initiated distributed transaction in response to instructions from the external coordinator process that initiated the transaction. Because the existing database instance is able to perform these services, the external coordinator process does not have to wait for the crashed database instance to be revived to complete the distributed transaction.

摘要翻译： 提供了一种计算机系统和方法，其中现有数据库实例能够报告存在于已经崩溃的另一数据库实例中的外部发起的分布式事务的状态。 现有数据库实例还能够回滚或提交由外部发起的分布式事务所做的更改，以响应来自外部协调程序进程的指令。 因为现有的数据库实例能够执行这些服务，所以外部协调器进程不必等待崩溃的数据库实例被复原才能完成分布式事务。