发明名称 Method and apparatus for generating reports using declarative tools
摘要 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.
申请公布号 US6160549(A) 申请公布日期 2000.12.12
申请号 US19970785856 申请日期 1997.01.21
申请人 ORACLE CORPORATION 发明人 TOUMA, ANDRE;DAVIS, RICHARD;SIMSON, DAVID;TILLI, MARCO;BREYER, STEVE
分类号 G06F17/30;(IPC1-7):G06F13/00 主分类号 G06F17/30
代理机构 代理人
主权项
地址