Method and apparatus for generating reports using declarative tools

Number of patents in Portfolio can not be more than 2000

United States of America Patent

PATENT NO 5809266
SERIAL NO

08786198

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

The present invention is a method and apparatus for declarative report definition and generation using an enhanced, graphical data model and a graphical user interface (GUI) for graphically specifying data items and data computations to be performed on the data is described. It provides a set of data model objects, a data model painter for creating, defining, and visualizing the data model objects, and a data engine that retrieves the data according to the definition of the data objects. That is, the present invention provides a graphical data model allowing a user to graphically specify both the data and computations to be performed on the data and uses the layout metaphor (i.e., 'painter') to specify the data. Data model objects include: queries, groups, columns, parameters, cross products, and links. Unlike the prior art, allows the use of multiple queries each containing one or more break groups and cross product groups where groups belonging to two different queries are connected by link objects. The resulting structure is therefore a forest of groups where each group contains one or more columns, thereby enlarging the scope of report definition tools available to users.

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
Breyer, Steve San Mateo, CA 2 167
Davis, Richard Half Moon Bay, CA 64 776
Simson, David Burlingame, CA 2 167
Tilli, Marco Hayward, CA 5 299
Touma, Andre Redwood Shores, CA 2 167

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation