Please download the dossier by clicking on the dossier button x
×

Multi-part looked-up table fields and its use in data processing operations involving multiple tables of a relational database

  • US 20030131215A1
  • Filed: 01/10/2002
  • Published: 07/10/2003
  • Est. Priority Date: 10/25/2001
  • Status: Active Grant
First Claim
Patent Images

1. A method comprising:

  • parsing a data processing statement;

    identifying table field or fields referenced in said data processing statement, including whether an aggregation operation is to be performed on row values of each of the identified table fields;

    for each identified table field, determining whether the table field is a looked-up field;

    identifying a basis table of which non-looked up ones of said identified table field or fields are members;

    identifying one or more target tables from which said looked-up one or ones of said identified table field or fields are to be looked up; and

    generating a SQL statement, including with said generated SQL statement a FROM clause having a subquery creating a grouped derivative table comprising grouped non-looked-up table fields and aggregated table fields, and one or more JOIN clauses joining the corresponding one or more target tables to the grouped derivative table, if the data processing statement is determined to contain first one or more table fields to have aggregation operations performed on their row values.

View all claims
  • 3 Assignments
Timeline View
Assignment View
    ×
    ×