Database management system and method for query process for the same
First Claim
1. A database management system comprising, a decision management node having analysis means of receiving a query, analyzing said query, and generating the query processing procedure and decision means of deciding the distribution nodes and join nodes for performing the execution process on the basis of the query analysis result by said analysis means;
- at least one distribution node having storage means of distributing and storing the database to be queried and distribution means of retrieving information from said storage means and distributing the retrieved information to other nodes;
at least one join node having sorting means of sorting information distributed from said distribution node, merge means of merging said plurality of sorted information, if any, and join means of joining a query on the basis of said merged information;
an output node having output means of outputting the result for the query obtained from said join node; and
a network for transferring data between said nodes.
0 Assignments
0 Petitions
Accused Products
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.
-
Citations
2 Claims
-
1. A database management system comprising,
a decision management node having analysis means of receiving a query, analyzing said query, and generating the query processing procedure and decision means of deciding the distribution nodes and join nodes for performing the execution process on the basis of the query analysis result by said analysis means; -
at least one distribution node having storage means of distributing and storing the database to be queried and distribution means of retrieving information from said storage means and distributing the retrieved information to other nodes;
at least one join node having sorting means of sorting information distributed from said distribution node, merge means of merging said plurality of sorted information, if any, and join means of joining a query on the basis of said merged information;
an output node having output means of outputting the result for the query obtained from said join node; and
a network for transferring data between said nodes.
-
-
2-19. -19. (canceled)
Specification