Database management system and method for query process for the same

Abstract

A database management system for executing database operations in parallel by a plurality of nodes and a query processing method for it are described. The database management system contains a decision management node for deciding a distribution node for retrieving information so as to analyze a query received from an application program, generate a processing procedure for processing the query, and execute the process and a join node for sorting, merging, and joining the information retrieved by the distribution node. When the query process is executed, the distribution node decided by the decision management node retrieves the information to be processed and the join node decided by the decision management node also obtains the result for the query from the retrieved information. The query result is outputted from an output node and transferred to the application program.

1 - 21 . (canceled)  
   
   
       22 . A query operation method for a query processor in a database management system including at least one data source in at least one database as an access target of the query, the method comprising the steps of: 
 analyzing an inputted query to generate at least a processing procedure corresponding to said data source;    selecting an optimized processing procedure from the generated processing procedures for executing the optimized processing procedure;    determining an executing processor which executes said selected optimized processing procedure; and    executing the selected optimized processing procedure.    
   
   
       23 . A query operation system for a query processor in a database management system including at least one data source in at least one database as an access target of the query, the system comprising: 
 means for analyzing an inputted query to generate at least a processing procedure corresponding to said data source;    means for selecting an optimized processing procedure from the generated processing procedures for executing the optimized processing procedure;    means for determining an executing processor which executes said selected optimized processing procedure; and    means for executing the selected optimized processing procedure in said determined executing processor.    
   
   
       24 . A query operation method as claimed in  claim 22 , wherein the analyzing step is performed by a first processor, and said executing processor is different from said first processor.  
   
   
       25 . A query operation method as claimed in  claim 22 , wherein said executing processor is a parallel or pipeline processor.  
   
   
       26 . A query operation system as claimed in  claim 23 , wherein said means for analyzing includes a first processor, and wherein said executing processor is different from said first processor.  
   
   
       27 . A query operation system as claimed in  claim 23 , wherein said executing processor is a parallel or pipeline processor.