-
公开(公告)号:JPH10247203A
公开(公告)日:1998-09-14
申请号:JP916498
申请日:1998-01-20
Applicant: IBM
Inventor: AGARWAL RAMESH CHANDRA , JHINGRAN ANANT DEEP , MALKEMUS TIMOTHY RAY , PADMANABHAN SRIRAM KOLIJIVADI
Abstract: PROBLEM TO BE SOLVED: To improve the efficiency of constitution and processing by generating a vector record block through the use of data from plural input records guided from a relation database and applying at least one vector operator of an inquiry processing tree to a block. SOLUTION: The relational database system 20 manages plural databases 24, which are the set of database tables 26. A table 26 includes a row or the set of records 28 and all the records are provided with the same or similar structure. The schema of a table describes a column 30 forming a record in which the data type of its column is included. Then, data is inquired through inquiring language. In order to process inquiry, the system 20 compiles inquiring to an operator tree. For example, input/output is executed by an operator tree in simple inquiry such as SELECT a, sum (b) from t1 group by (a).
-
公开(公告)号:CZ9904221A3
公开(公告)日:2000-10-11
申请号:CZ422199
申请日:1998-05-27
Applicant: IBM
Inventor: DIAS DANIEL MANUEL , JHINGRAN ANANT DEEP , KING RICHARD PERVIN , POLYZOIS CHRISTOS
IPC: G06F11/14
-
公开(公告)号:CA2288016C
公开(公告)日:2004-11-16
申请号:CA2288016
申请日:1998-05-27
Applicant: IBM
Inventor: JHINGRAN ANANT DEEP , KING RICHARD PERVIN , DIAS DANIEL MANUEL , POLYZOIS CHRISTOS
IPC: G06F11/14
Abstract: A method and system for recovering from a failure of a processing node in a partitioned shared nothing database processing system are provided. The processing system may include a pair of processing nodes having twin-tailed-connected thereto a storage device. A first processing node of the pair of processing nodes has a first database instanc e running thereon which accesses a first data partition on the storage device prior to the failure. Upon detection of the failure, access t o the first data partition on the storage device is provided to a third, spare processing node through the second processing node of the pair of processing nodes. The third processing node runs a replacement database instance for the first database instance which was running on the first processing node prior to the failure thereof. The replacement database instance accesses the first data partition on the storage device through the second processing node, thereby recovering from the failure of the first processing node. Access to the first data partition may include using a virtual shared disk utility having a server portion on the second processing node and a client portion on the third processing node.
-
公开(公告)号:HU0003427A2
公开(公告)日:2001-02-28
申请号:HU0003427
申请日:1998-05-27
Applicant: IBM
Inventor: DIAS DANIEL MANUEL , JHINGRAN ANANT DEEP , KING RICHARD PERVIN , POLYZOIS CHRISTOS
IPC: G06F11/14
-
公开(公告)号:PL337021A1
公开(公告)日:2000-07-31
申请号:PL33702198
申请日:1998-05-27
Applicant: IBM
Inventor: DIAS DANIEL MANUEL , JHINGRAN ANANT DEEP , KING RICHARD PERVIN , POLYZOIS CHRISTOS
IPC: G06F11/14
-
公开(公告)号:CA2288016A1
公开(公告)日:1998-12-03
申请号:CA2288016
申请日:1998-05-27
Applicant: IBM
Inventor: DIAS DANIEL MANUEL , JHINGRAN ANANT DEEP , KING RICHARD PERVIN , POLYZOIS CHRISTOS
IPC: G06F11/14
Abstract: A method and system for recovering from a failure of a processing node in a partitioned shared nothing database processing system are provided. The processing system may include a pair of processing nodes having twin-tailed-connected thereto a storage device. A first processing node of the pair of processing nodes has a first database instance running thereon which accesses a first data partition on the storage device prior to the failure. Upon detection of the failure, access to the first data partition on the storage device is provided to a third, spare processing node through the second processing node of the pair of processing nodes. The third processing node runs a replacement database instance for the first database instance which was running on the first processing node prior to the failure thereof. The replacement database instance accesses the first data partition on the storage device through the second processing node, thereby recovering from the failure of the first processing node. Access to the first data partition may include using a virtual shared disk utility having a server portion on the second processing node and a client portion on the third processing node.
-
-
-
-
-