×

Test generator for database management systems providing tight joins

  • US 7,007,007 B2
  • Filed: 11/03/2004
  • Issued: 02/28/2006
  • Est. Priority Date: 05/14/1998
  • Status: Expired due to Term
First Claim
Patent Images

1. A computer-implemented system for creating a SQL statement, the system comprising:

  • means for generating a SQL statement having a from clause, the from clause include a plurality of table names;

    means for creating a plurality of table sets from the plurality of table names;

    means for iterating of the plurality of table sets until one table set remains and for each iteration performing the tasks of;

    means for selecting a first table set and a second table set from the plurality of table sets;

    means for selecting a first table from the first table set and selecting a second table from the second table set;

    means for selecting a first colunm in the first table and selecting a second colunm from the second table;

    means for inserting into a where clause for the SQL statement a predicate including the first column and the second column; and

    means for merging the first table set and the second table set.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×