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

    公开(公告)号:US08447771B2

    公开(公告)日:2013-05-21

    申请号:US11602537

    申请日:2006-11-20

    IPC分类号: G06F17/30 G06F7/00

    CPC分类号: G06F17/30967 G06F17/30401

    摘要: A query generator is operable to generate a query for retrieving data that satisfy a conditional expression from a database, and/or perform an arbitrary calculation on at least part of the retrieved data. The query generator can receive an input query and analyze the query to ascertain whether it contains a replaceable token. If the query contains a replaceable token, the query generator can replace that token with user input specifying a parameter of the conditional expression and/or the arbitrary calculation, thereby generating an output query for retrieving the data that satisfy the conditional expression and/or performing the arbitrary calculation on the retrieved data.

    摘要翻译: 查询生成器可操作用于生成用于从数据库中检索满足条件表达式的数据的查询,和/或至少部分检索的数据执行任意计算。 查询生成器可以接收输入查询并分析查询以确定它是否包含可替换令牌。 如果查询包含可替换令牌,则查询生成器可以用指定条件表达式和/或任意计算的参数的用户输入替换该令牌,从而生成用于检索满足条件表达式和/或执行的数据的输出查询 对所检索的数据进行任意计算。

    Data storage method and system
    2.
    发明申请
    Data storage method and system 审中-公开
    数据存储方法和系统

    公开(公告)号:US20050240554A1

    公开(公告)日:2005-10-27

    申请号:US10921154

    申请日:2004-08-19

    IPC分类号: G06F9/44 G06F17/30 G06F7/00

    CPC分类号: G06F16/30

    摘要: A data storage method is described which comprises receiving a store command issued by a user in respect of a data object, and in response: 1. ascertaining whether an auxiliary function is associated with the data object; 2. storing the data object; and 3. executing the auxiliary function ascertained in step (a) to be associated with the data object.

    摘要翻译: 描述了一种数据存储方法,其包括:接收由用户针对数据对象发出的存储命令,并作为响应:1.确定辅助功能是否与数据对象相关联; 2.存储数据对象; 以及3.执行步骤(a)中确定的辅助功能与数据对象相关联。

    Method and system for implementing definable actions
    3.
    发明授权
    Method and system for implementing definable actions 有权
    实现可定义动作的方法和系统

    公开(公告)号:US08543527B2

    公开(公告)日:2013-09-24

    申请号:US12684861

    申请日:2010-01-08

    IPC分类号: G06F17/00

    CPC分类号: G06Q10/10

    摘要: A method and system is provided for use in business intelligence and reporting. The method and system are able to implement one or more definable actions when presented with data. The data may be produced by a business intelligence application. The actions may relate to activities performed by a user or an agent. The system comprises an action manager, a repository, a data association manager and an implementation engine. In one embodiment a data mining engine is provided. The system enables the availability of an action in response to the execution of analytic queries to be determined based on a relationship defined by the data association manager. If an action is available, an action definition is used to invoke a target in response to selection of the action by an entity, the invocation of the target including propagating data produced by an analytic engine into the target based on metadata to perform the action.

    摘要翻译: 提供了一种用于商业智能和报告的方法和系统。 当呈现数据时,该方法和系统能够实现一个或多个可定义的动作。 数据可以由商业智能应用程序生成。 这些动作可能与用户或代理执行的活动有关。 该系统包括动作管理器,仓库,数据关联管理器和实现引擎。 在一个实施例中,提供数据挖掘引擎。 该系统使得能够响应于基于由数据关联管理器定义的关系来确定的分析查询的执行来响应于动作的可用性。 如果动作可用,则响应于实体对动作的选择,动作定义被用于调用目标,目标的调用包括基于元数据将由分析引擎生成的数据传播到目标中以执行动作。

    Data retrieval method
    4.
    发明申请
    Data retrieval method 审中-公开
    数据检索方法

    公开(公告)号:US20050278373A1

    公开(公告)日:2005-12-15

    申请号:US10946390

    申请日:2004-09-22

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F16/9024

    摘要: An hierarchical data retrieval method for retrieving an hierarchy of data from a first store is described. The hierarchy of data comprises one or more items of data of a first level, at least one of which is associated with one or more items of data of a second level. The method comprises: i) retrieving from the first store the items of data of the first level only; ii) displaying the items of data of the first level to a user; iii) retrieving from the first store the items of data of the second level associated with one of the items of data of the first level in response to a user request indicating that item of data of the first level; and, iv) displaying the items of data of the second level retrieved in step (iii) in addition to the items of data of the first level.

    摘要翻译: 描述用于从第一商店检索数据层次的分级数据检索方法。 数据层级包括第一级的一个或多个数据项,其中至少一个与第二级的一个或多个数据项相关联。 该方法包括:i)仅从第一存储中检索第一级的数据项; ii)向用户显示第一级的数据项; iii)响应于指示所述第一级的数据项的用户请求,从所述第一存储中检索与所述第一级的数据项之一相关联的所述第二级的数据项; 以及iv)除了所述第一级的数据项之外,还显示在步骤(iii)中检索的所述第二级的数据项。

    Query generation
    5.
    发明申请
    Query generation 有权
    查询生成

    公开(公告)号:US20080120326A1

    公开(公告)日:2008-05-22

    申请号:US11602537

    申请日:2006-11-20

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30967 G06F17/30401

    摘要: A query generator is operable to generate a query for retrieving data that satisfy a conditional expression from a database, and/or perform an arbitrary calculation on at least part of the retrieved data. The query generator can receive an input query and analyze the query to ascertain whether it contains a replaceable token. If the query contains a replaceable token, the query generator can replace that token with user input specifying a parameter of the conditional expression and/or the arbitrary calculation, thereby generating an output query for retrieving the data that satisfy the conditional expression and/or performing the arbitrary calculation on the retrieved data.

    摘要翻译: 查询生成器可操作用于生成用于从数据库中检索满足条件表达式的数据的查询,和/或至少部分检索的数据执行任意计算。 查询生成器可以接收输入查询并分析查询以确定它是否包含可替换令牌。 如果查询包含可替换令牌,则查询生成器可以用指定条件表达式和/或任意计算的参数的用户输入替换该令牌,由此生成用于检索满足条件表达式和/或执行的数据的输出查询 对所检索的数据进行任意计算。

    Query generator
    6.
    发明申请
    Query generator 审中-公开
    查询生成器

    公开(公告)号:US20070239659A1

    公开(公告)日:2007-10-11

    申请号:US11392777

    申请日:2006-03-30

    IPC分类号: G06F17/30

    CPC分类号: G06F16/24534

    摘要: A query generator for generating a query for retrieving a desired set of data from a relational database is disclosed. The query generator is adapted to: a) receive an input query adapted to retrieve a superset of the desired set of data from the database; b) analyse a default filters table comprising one or more filter application criteria, each associated with a default filter condition that refers to data contained in the superset of data; and c) for each filter application criterion that is satisfied, modify the input query in accordance with the associated default filter condition to produce an output query adapted to retrieve the desired set of data only.

    摘要翻译: 公开了一种用于从关系数据库生成用于检索所需数据集的查询的查询生成器。 所述查询生成器适于:a)接收适于从所述数据库检索期望的数据集的超集的输入查询; b)分析包括一个或多个过滤器应用准则的默认过滤器表,每个与过滤器条件相关联,该默认过滤条件涉及包含在数据超集中的数据; 以及c)对于满足的每个过滤器应用标准,根据相关联的默认过滤条件来修改输入查询以产生仅适于检索所需数据集的输出查询。

    METHOD AND SYSTEM FOR IMPLEMENTING DEFINABLE ACTIONS
    7.
    发明申请
    METHOD AND SYSTEM FOR IMPLEMENTING DEFINABLE ACTIONS 有权
    实施可行动作的方法和系统

    公开(公告)号:US20110173680A1

    公开(公告)日:2011-07-14

    申请号:US12684861

    申请日:2010-01-08

    IPC分类号: H04L9/32 G06N5/02 G06F15/18

    CPC分类号: G06Q10/10

    摘要: A method and system is provided for use in business intelligence and reporting. The method and system are able to implement one or more definable actions when presented with data. The data may be produced by a business intelligence application. The actions may relate to activities performed by a user or an agent. The system comprises an action manager, a repository, a data association manager and an implementation engine. In one embodiment a data mining engine is provided. The system enables the availability of an action in response to the execution of analytic queries to be determined based on a relationship defined by the data association manager. If an action is available, an action definition is used to invoke a target in response to selection of the action by an entity, the invocation of the target including propagating data produced by an analytic engine into the target based on metadata to perform the action.

    摘要翻译: 提供了一种用于商业智能和报告的方法和系统。 当呈现数据时,该方法和系统能够实现一个或多个可定义的动作。 数据可以由商业智能应用程序生成。 这些动作可能与用户或代理执行的活动有关。 该系统包括动作管理器,仓库,数据关联管理器和实现引擎。 在一个实施例中,提供数据挖掘引擎。 该系统使得能够响应于基于由数据关联管理器定义的关系来确定的分析查询的执行来响应于动作的可用性。 如果动作可用,则响应于实体对动作的选择,动作定义被用于调用目标,目标的调用包括基于元数据将由分析引擎生成的数据传播到目标中以执行动作。

    Data retrieval method
    8.
    发明申请
    Data retrieval method 有权
    数据检索方法

    公开(公告)号:US20060085406A1

    公开(公告)日:2006-04-20

    申请号:US11125166

    申请日:2005-05-10

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30569

    摘要: A method of retrieving data from any one of a plurality of data sources is disclosed. The data stored by each data source are arranged according to an associated data format. The method comprises: i) issuing a retrieval request for data stored on a designated one of the plurality of data sources to a control process; ii) passing the retrieval request from the control process to the one a plurality of retrieval processes that is associated with the designated data source, said one of the retrieval processes retrieving the requested data from the designated data source and rearranging the retrieved data into a common output format, if it is not already in the common output format; and iii) passing the data in the common output format to the control process.

    摘要翻译: 公开了一种从多个数据源中的任意一个数据源检索数据的方法。 每个数据源存储的数据根据​​相关的数据格式进行排列。 该方法包括:i)向存储在多个数据源中指定的一个数据源上的数据发出检索请求以进行控制处理; ii)将检索请求从控制过程传递到与指定数据源相关联的多个检索过程中的一个,所述检索过程之一从指定数据源检索所请求的数据,并将检索到的数据重新排列成公共 输出格式,如果不是普通的输出格式; 和iii)将公共输出格式的数据传送到控制过程。

    Data retrieval method
    9.
    发明授权
    Data retrieval method 有权
    数据检索方法

    公开(公告)号:US07949675B2

    公开(公告)日:2011-05-24

    申请号:US11125166

    申请日:2005-05-10

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30569

    摘要: A method of retrieving data from any one of a plurality of data sources is disclosed. The data stored by each data source are arranged according to an associated data format. The method comprises: issuing a retrieval request for data stored on a designated one of the plurality of data sources to a control process; passing the retrieval request from the control process to the one a plurality of retrieval processes that is associated with the designated data source, said one of the retrieval processes retrieving the requested data from the designated data source and rearranging the retrieved data into a common output format, if it is not already in the common output format; and passing the data in the common output format to the control process.

    摘要翻译: 公开了一种从多个数据源中的任意一个数据源检索数据的方法。 每个数据源存储的数据根据​​相关的数据格式进行排列。 该方法包括:向存储在多个数据源中指定的一个数据源上的数据发出检索请求到控制过程; 将检索请求从控制过程传递到与指定数据源相关联的多个检索过程中的一个,所述检索过程之一从指定的数据源检索所请求的数据,并将检索的数据重新排列成公共的输出格式 ,如果它不是在共同的输出格式; 并将通用输出格式的数据传送到控制过程。