-
公开(公告)号: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).