Query generation method for queries for inline views for aggregation referring to identified subgraphs

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 7797307
APP PUB NO 20070185833A1
SERIAL NO

11340599

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

A query generator for generating a query which retrieves a desired set of data from a relational database and performs one or more aggregation functions on the set of data is disclosed. The query generator is adapted to: a) receive user input indicating the desired set of data and the aggregation functions to be performed; b) identify each join subgraph for the desired set of data; c) for each join subgraph identified in step (b), generate an inline view which, on execution, performs all of the aggregation functions that refer only to data within that join subgraph; and d) generate an output query comprising the inline views generated in step (c) as arguments of a join.

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

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

Patent OwnerAddress
ORACLE INTERNATIONAL CORPORATION500 ORACLE PARKWAY MAIL STOP 5OP7 REDWOOD SHORES CA 94065

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Turkel, Joel Boston, US 3 101
Venkatasubramanian, Raghuram Union City, US 23 569

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation