公开(公告)号：WO02093420A3

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

申请号：PCT/GB0202123

申请日：2002-05-09

Applicant: IBM ,  IBM UK

Inventor： COTNER CURT ,  PICKEL JAMES ,  WATTS JULIE

IPC: G06F12/00 ,  G06F11/14 ,  G06F17/30

CPC classification number: G06F11/1474 ,  G06F17/30353 ,  G06F17/30575 ,  G06F2201/80 ,  Y10S707/99938 ,  Y10S707/99952

Abstract: System, method, and program product for managing transactions on a plurality of Database Management Systems residing on separate participant servers and a coordinator server, A single transaction proceeds by multiple steps across more then one of the plurality of Database Management Systems as participants. Savepoints are assigned to the participants across the Database Management System, with at least one savepoint within a multiple step transaction. The DBMS responds to application requests to rollback to savepoint by rolling back the transaction, across the Database Management System participants, to the savepoint Further disclosed is a program product that contains code, which, either as written on the medium, or as instantiated in RAM, or both, controls the operation of a distributed database management system.

Abstract translation: 用于管理驻留在单独的参与者服务器和协调器服务器上的多个数据库管理系统上的事务的系统，方法和程序产品。单个事务通过作为参与者的多个数据库管理系统中的多个数据库多个步骤进行。 保存点被分配给跨数据库管理系统的参与者，在多步事务中至少有一个保存点。 DBMS通过将数据库管理系统参与者的事务回滚到保存点来响应应用程序请求回滚到保存点。另外披露的是一个程序产品，其中包含代码，无论是在介质上写入还是在RAM中实例化 ，或两者都控制分布式数据库管理系统的操作。

公开(公告)号：WO03065690A2

公开(公告)日：2003-08-07

申请号：PCT/EP0214910

申请日：2002-12-19

Applicant: IBM ,  IBM FRANCE

Inventor： GANDURI SHRIVAM ,  PICKEL JAMES

IPC: G06F12/00 ,  G06F9/50 ,  H04L29/06 ,  H04L29/08 ,  H04L29/12

CPC classification number: H04L29/12009 ,  H04L29/12047 ,  H04L61/15 ,  H04L67/1002 ,  H04L67/1008 ,  H04L67/1038 ,  Y10S707/99952 ,  Y10S707/99953

Abstract: The present invention is directed to a method and system for connecting a client to a database managed by a network of computer systems having a plurality of database management system (DBMS) members. The method and system includes providing a shared network address for the plurality of DBMS members, which is used by the client to connect to an active DBMS member of the plurality of DBMS members. Through the aspects of the present invention, the shared network address allows the client to connect, via a network router, to any one of the plurality of DBMS members so long as one member is active. Once the client is connected to one member, the member sends to the client a list of all active members and their respective workloads. The list also includes member-specific network address corresponding to each member so that the client can distribute work evenly across the active members and also perform a resynchronization process with a DBMS member after a first connection with the DBMS member has been interrupted.

Abstract translation: 本发明涉及一种用于将客户机连接到由具有多个数据库管理系统（DBMS）成员的计算机系统的网络管理的数据库的方法和系统。 所述方法和系统包括为所述多个DBMS成员提供共享网络地址，所述共享网络地址由所述客户端用于连接到所述多个DBMS成员的活动DBMS成员。 通过本发明的方面，只要一个成员是活动的，共享网络地址允许客户端经由网络路由器连接到多个DBMS成员中的任何一个。 一旦客户端连接到一个成员，该成员向客户端发送所有活动成员及其相应工作负载的列表。 该列表还包括与每个成员相对应的成员特定网络地址，以便客户端可以跨活动成员均匀分配工作，并且在与DBMS成员的第一次连接中断之后还与DBMS成员执行重新同步过程。

公开(公告)号：AT367045T

公开(公告)日：2007-08-15

申请号：AT02798366

申请日：2002-12-19

Applicant: IBM

Inventor： GANDURI SHRIVAM ,  PICKEL JAMES

IPC: G06F12/00 ,  H04L29/12 ,  G06F9/50 ,  H04L29/06 ,  H04L29/08

Abstract: A method and system for connecting a client to a database managed by a network of computer systems having a plurality of database management system (DBMS) members includes providing a shared network address for the plurality of DBMS members, which is used by the client to connect to an active DBMS member of the plurality of DBMS members. Through the aspects of the present invention, the shared network address allows the client to connect, via a network router, to any one of the plurality of DBMS members so long as one member is active. Once the client is connected to one member, the member sends to the client a list of all active members and their respective workloads. The list also includes member-specific network addresses corresponding to each member so that the client can distribute work evenly across the active members and also perform a resynchronization process with a DBMS member after a first connection with the DBMS member has been interrupted.

公开(公告)号：CA2443100A1

公开(公告)日：2002-11-21

申请号：CA2443100

申请日：2002-05-09

Applicant: IBM

Inventor： WATTS JULIE ,  COTNER CURT ,  PICKEL JAMES

IPC: G06F12/00 ,  G06F11/14 ,  G06F17/30

Abstract: System, method, and program product for managing transactions on a plurality of Database Management Systems residing on separate participant servers and a coordinator server, A single transaction proceeds by multiple steps across more then one of the plurality of Database Management Systems as participants. Savepoints are assigned to the participants across the Database Management System, with at least one savepoint within a multiple step transaction. The DBMS responds to application requests to rollback to savepoint by rolling back the transaction, across the Database Management System participants, to the savepoint Further disclosed is a program product that contains code, which, either as written on the medium, or as instantiated in RAM, or both, controls the operation of a distributed database management system.

公开(公告)号：CA2443100C

公开(公告)日：2008-03-25

申请号：CA2443100

申请日：2002-05-09

Applicant: IBM

Inventor： COTNER CURT ,  PICKEL JAMES ,  WATTS JULIE

IPC: G06F12/00 ,  G06F17/30 ,  G06F11/14

Abstract: System, method, and program product for managing transactions on a plurality of Database Management Systems residing on separate participant servers and a coordinator server, A single transaction proceeds by multiple steps across more then one of the plurality of Database Management Systems as participants. Savepoints are assigned to the participants across the Database Management System, with at least one savepoint within a multiple step transaction. The DBMS responds to application requests to rollback to savepoint by rolling back the transaction, across the Database Management System participants, to the savepoint Further disclosed is a program product that contains code, which, either as written on the medium, or as instantiated in RAM, or both, controls the operation of a distributed database management system.

公开(公告)号：DE60221156D1

公开(公告)日：2007-08-23

申请号：DE60221156

申请日：2002-12-19

Applicant: IBM

Inventor： GANDURI SHRIVAM ,  PICKEL JAMES

IPC: G06F12/00 ,  H04L29/12 ,  G06F9/50 ,  H04L29/06 ,  H04L29/08

Abstract: A method and system for connecting a client to a database managed by a network of computer systems having a plurality of database management system (DBMS) members includes providing a shared network address for the plurality of DBMS members, which is used by the client to connect to an active DBMS member of the plurality of DBMS members. Through the aspects of the present invention, the shared network address allows the client to connect, via a network router, to any one of the plurality of DBMS members so long as one member is active. Once the client is connected to one member, the member sends to the client a list of all active members and their respective workloads. The list also includes member-specific network addresses corresponding to each member so that the client can distribute work evenly across the active members and also perform a resynchronization process with a DBMS member after a first connection with the DBMS member has been interrupted.

公开(公告)号：DE60221156T2

公开(公告)日：2008-03-20

申请号：DE60221156

申请日：2002-12-19

Applicant: IBM

Inventor： GANDURI SHRIVAM ,  PICKEL JAMES

IPC: G06F12/00 ,  H04L29/12 ,  G06F9/50 ,  H04L29/06 ,  H04L29/08

Abstract: A method and system for connecting a client to a database managed by a network of computer systems having a plurality of database management system (DBMS) members includes providing a shared network address for the plurality of DBMS members, which is used by the client to connect to an active DBMS member of the plurality of DBMS members. Through the aspects of the present invention, the shared network address allows the client to connect, via a network router, to any one of the plurality of DBMS members so long as one member is active. Once the client is connected to one member, the member sends to the client a list of all active members and their respective workloads. The list also includes member-specific network addresses corresponding to each member so that the client can distribute work evenly across the active members and also perform a resynchronization process with a DBMS member after a first connection with the DBMS member has been interrupted.