Patent ID: 7318058

Claim:
A computer implemented system for processing a many-to-one-to-many relationship, the system comprising: a parallel detail analysis module for detecting a many-to-one-to-many relationship among elements; and a parallel detail transformation module for generating a SQL: 1999 statement to handle the many-to-one-to-many relationship, the parallel detail transformation module including: means for constructing a first LEFT OUTER JOIN between a master table and a first detail table based on a first foreign key relationship; means for constructing a first select list containing a primary key of the master table, detail information from the master table and the first detail table, and the OLAP function specification ROW_NUMBER( ) OVER (PARTITION BY M.P 1 ORDER BY M.P 1 ); means for constructing a first temporary derived table based on the select list and the outer join; means for constructing a second LEFT OUTER JOIN between the master table and a second detail table based on a second foreign key relationship; means for constructing a second list containing the primary key, detail information from the master table and the second detail table, and the OLAP function specification ROW_NUMBER( ) OVER (PARTITION BY M.P 1 ORDER BY M.P 1 ); means for constructing a second temporary derived table based on the second select list and the second outer join; and means for constructing a final SELECT statement that stitches together the first and second derived tables using a FULL OUTER JOIN with a join condition based on the primary key and the ROW_NUMBER functions.