Patent ID: 6760718
Filing Date: 2004-07-06
Classification: G06F,Y10S

Abstract:
A database operation processor comprising:a database for storing data; a query analyzer for inputting and analyzing a query statement for the database; an operation expression generator for generating an operation expression for executing the query statement by inputting an analysis result of the query analyzer; and an operation expression executor for executing the operation expression generated by the operation expression generator and obtaining data satisfying the query statement from the database, wherein the database stores a plurality of tables storing records including at least one column, the operation expression generator includes a self-join detector for detecting join processing for joining records stored in two tables, according to a join condition, by receiving an analysis result of the query analyzer, detecting if the join processing detected is self-join operation processing where the two tables are the same and the join condition is a join condition for the same column, and generating a self-join operation expression for executing the self-join operation processing detected, and the operation expression executor executes the self-join operation expression generated by the self-join detector and produces a result of the self-join operation processing.