METHOD AND SYSTEM FOR APPLYING COLLATING PROCESSING TREE TO RELATIONAL DATABASE

    公开(公告)号:JPH10247203A

    公开(公告)日:1998-09-14

    申请号:JP916498

    申请日:1998-01-20

    Applicant: IBM

    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).

    METHOD AND SYSTEM FOR RECOVERY IN A PARTITIONED SHARED NOTHING DATABASE SYSTEM USING VIRTUAL SHARED DISKS

    公开(公告)号:CA2288016C

    公开(公告)日:2004-11-16

    申请号:CA2288016

    申请日:1998-05-27

    Applicant: IBM

    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.

    METHOD AND SYSTEM FOR RECOVERY IN A PARTITIONED SHARED NOTHING DATABASE SYSTEM USING VIRTUAL SHARED DISKS

    公开(公告)号:CA2288016A1

    公开(公告)日:1998-12-03

    申请号:CA2288016

    申请日:1998-05-27

    Applicant: IBM

    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.

Patent Agency Ranking