×

PROCESSING CROSS-TABLE NON-BOOLEAN TERM CONDITIONS IN DATABASE QUERIES

  • US 20090019040A1
  • Filed: 09/26/2008
  • Published: 01/15/2009
  • Est. Priority Date: 01/28/2005
  • Status: Active Grant
First Claim
Patent Images

1. A method for searching for data in a database, the method comprising:

  • receiving a query that is a request for data in the database, wherein the query identifies multiple tables in the database, the query including at least one uneven non-Boolean term condition including an OR condition having two predicates, wherein the OR condition spans and is satisfied by at least two tables of the multiple tables;

    splitting the at least one non-Boolean term condition into a plurality of separate query portions, wherein each predicate of the OR condition is provided to a different one of the separate query portions, each of the separate query portions providing a Boolean term that is satisfied by accessing a different particular one of the at least two tables;

    executing the separate query portions independently of each other to find at least one data result in each of the at least two tables that satisfies the Boolean term of each separate query portion; and

    combining the data result from each separate query portion into a final result that satisfies the query.

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