System and method for performance complex heterogeneous database queries using a single SQL expression

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 6341277
SERIAL NO

09289020

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

Query objects are created by a client process. The query objects have one or more sub-query objects and one or more execute methods that are capable of operating on their respective query object to produce one or more query expressions. All of the execute methods are capable of producing the respective query expression that is compatible with a structured query language. A compound query contains one or more boolean expressions of one or more of the query objects. The compound query has one or more compound execute methods which invoke one or more the execute methods of each of the query objects. Each of the execute methods returns their respective query expression and the compound execute method uses one or more common table expressions to combine the query expressions to form a single compound query expression that represents the boolean expression. This single expression can be execute against a database to return a result without executing any of the query expressions against the database individually.

Loading the Abstract Image... loading....

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

  • INTERNATIONAL BUSINESS MACHINES CORPORATION

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Brereton, JoAnn Piersa Hawthorne, NY 6 232
Coden, Anna Rosa Bronx, NY 5 297
Schwartz, Michael Stephen Bronx, NY 12 599

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation