Query generator
    1.
    发明授权
    Query generator 有权
    查询生成器

    公开(公告)号:US07467152B2

    公开(公告)日:2008-12-16

    申请号:US09730826

    申请日:2000-12-07

    IPC分类号: G06F17/30

    摘要: The present invention relates to a query generator for generating a query for obtaining selected data from a database. The query generator includes a processor which is adapted to receive an input indicating the selected data to be obtained. The processor then analyses the input to determine whether the input requires a joining of data in different tables, and an aggregation step. If so, the processor generates a query which causes the database to aggregate the data within each of the tables as required; and, join the aggregated data, the joined aggregated data representing the selected data.

    摘要翻译: 本发明涉及一种查询生成器,用于从数据库生成用于获取所选数据的查询。 查询生成器包括处理器,其适于接收指示要获取的所选数据的输入。 然后,处理器分析输入以确定输入是否需要在不同的表中加入数据,以及聚合步骤。 如果是这样,处理器会生成一个查询,导致数据库根据需要汇总每个表中的数据; 并加入聚合数据,表示所选数据的连接聚合数据。

    User interface
    4.
    发明授权

    公开(公告)号:US06670972B2

    公开(公告)日:2003-12-30

    申请号:US09730751

    申请日:2000-12-07

    IPC分类号: G09G500

    CPC分类号: G06F3/04847

    摘要: The present invention relates to a user interface control for controlling the value of a variable in a processing system. The user interface control includes, a display, an input device and a processor. The processor is adapted to cooperate with the display and the input device to generate an input representation on the display, the input representation allowing the value of the variable to be specified by the user using the input device. The processor then generates a graphical representation on the display, the graphical representation showing a relationship between the variable and a parameter. Finally, the processor generates an indicator on the display, the indicator indicating a value of the parameter for the value of the variable specified using the input representation.