QUERY CONDITIONS-BASED SECURITY
    91.
    发明申请
    QUERY CONDITIONS-BASED SECURITY 有权
    基于QUERY条件的安全

    公开(公告)号:US20100185678A1

    公开(公告)日:2010-07-22

    申请号:US12748616

    申请日:2010-03-29

    IPC分类号: G06F17/30

    摘要: A method, system and article of manufacture for managing access to queries and, more particularly, for managing access by multiple users to persistently stored queries. One embodiment provides a method of managing access by multiple users to a predefined query against data in a database. The method comprises associating one or more access rights with at least some portion of the predefined query. When a request to access the predefined query by a first user is received, access to the predefined query by the first user is limited on the basis of the access rights.

    摘要翻译: 一种用于管理对查询的访问的方法,系统和制品,更具体地,用于管理多个用户对永久存储的查询的访问。 一个实施例提供了一种管理多个用户对数据库中的数据进行预定义查询的方法。 该方法包括将一个或多个访问权限与预定义查询的至少一部分相关联。 当接收到由第一用户访问预定义查询的请求时,第一用户对该预定义查询的访问受限于基于访问权限。

    Query conditions-based security
    92.
    发明授权
    Query conditions-based security 失效
    查询基于条件的安全性

    公开(公告)号:US07720858B2

    公开(公告)日:2010-05-18

    申请号:US10897335

    申请日:2004-07-22

    IPC分类号: G06F17/30

    摘要: A method, system and article of manufacture for managing access to queries and, more particularly, for managing access by multiple users to persistently stored queries. One embodiment provides a method of managing access by multiple users to a predefined query against data in a database. The method comprises associating one or more access rights with at least some portion of the predefined query. When a request to access the predefined query by a first user is received, access to the predefined query by the first user is limited on the basis of the access rights.

    摘要翻译: 一种用于管理对查询的访问的方法,系统和制品,更具体地,用于管理多个用户对永久存储的查询的访问。 一个实施例提供了一种管理多个用户对数据库中的数据进行预定义查询的方法。 该方法包括将一个或多个访问权限与预定义查询的至少一部分相关联。 当接收到由第一用户访问预定义查询的请求时,第一用户对该预定义查询的访问受限于基于访问权限。

    Abstract records
    93.
    发明授权
    Abstract records 失效
    摘要记录

    公开(公告)号:US07624097B2

    公开(公告)日:2009-11-24

    申请号:US11035563

    申请日:2005-01-14

    IPC分类号: G06F7/00

    摘要: Embodiments of the invention provide methods, systems, and articles of manufacture improving the process of query composition, query processing, and presenting query results to users of an abstract database. Embodiments of the present invention organize and view data using abstract records. Specifically, users compose a query according to the logical relationships present in the data. Rather than evaluate conditions against a set of rows from a relational table, conditions included in abstract query are evaluated against instances of an abstract record. Instances that satisfy the conditions specified by an abstract query are returned as query results. In a specific case abstract records are used to evaluate a “never exists conditions, that determine the absence of data in an abstract records that satisfy a particular condition.

    摘要翻译: 本发明的实施例提供方法,系统和制品,改进查询组合,查询处理和向抽象数据库的用户呈现查询结果的过程。 本发明的实施例使用抽象记录来组织和查看数据。 具体来说,用户根据数据中存在的逻辑关系构成查询。 不是根据关系表中的一组行来评估条件,而是根据抽象记录的实例来评估抽象查询中包含的条件。 满足抽象查询指定条件的实例作为查询结果返回。 在具体情况下,抽象记录用于评估“从不存在的条件,确定在满足特定条件的抽象记录中不存在数据。

    System and method for sorting data records contained in a query result based on suitability score
    94.
    发明授权
    System and method for sorting data records contained in a query result based on suitability score 失效
    基于适合性分数对查询结果中包含的数据记录进行排序的系统和方法

    公开(公告)号:US07539668B2

    公开(公告)日:2009-05-26

    申请号:US10999494

    申请日:2004-11-30

    IPC分类号: G06F17/30

    摘要: A system, method and article of manufacture for managing query results and, more particularly, for sorting data records contained in a query result obtained in response to execution of a query against a database. In one embodiment, the data records in the query result are sorted on the basis of related information which is retrieved from a corresponding data source. In another embodiment, the sorting is performed on the basis of a value variance which is determined for each of the data records in the query result. In still another embodiment, the sorting is performed on the basis of a requested value range coverage. In yet another embodiment, the sorting is performed on the basis of suitability scores which are determined with respect to analysis routines which are configured for processing the query result.

    摘要翻译: 一种用于管理查询结果的系统,方法和制品,更具体地,用于对包含在响应于针对数据库的查询的执行而获得的查询结果中的数据记录的排序。 在一个实施例中,查询结果中的数据记录基于从相应数据源检索的相关信息进行排序。 在另一个实施例中,基于为查询结果中的每个数据记录确定的值方差来执行排序。 在另一个实施例中,基于请求的值范围覆盖来执行排序。 在另一个实施例中,基于针对被配置用于处理查询结果的分析例程而确定的适合性评分来执行排序。

    DYNAMIC DISCOVERY OF ABSTRACT RULE SET REQUIRED INPUTS
    95.
    发明申请
    DYNAMIC DISCOVERY OF ABSTRACT RULE SET REQUIRED INPUTS 失效
    摘要规定要求输入的动态发现

    公开(公告)号:US20080301108A1

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

    申请号:US12191187

    申请日:2008-08-13

    IPC分类号: G06F17/30

    摘要: A method, system and article of manufacture for processing rule sets and, more particularly, for processing abstract rule sets. One embodiment provides a computer-implemented method of managing execution of an analysis routine on input data. The method comprises receiving input and receiving user-selection of an analysis routine for processing the received input. The analysis routine is defined by at least one abstract rule set having one or more abstract rules each having a conditional statement and a consequential statement. The method further comprises executing the analysis routine on the received input, comprising (i) identifying all required inputs for each abstract rule of the analysis routine, (ii) determining whether the received input includes data for all required inputs, and (iii) if the received input does not include data for one or more of the required inputs, retrieving suitable data for the one or more of the required inputs from the database.

    摘要翻译: 一种用于处理规则集的方法,系统和制品,更具体地说,涉及处理抽象规则集。 一个实施例提供了一种管理输入数据分析程序的执行的计算机实现的方法。 该方法包括接收输入和接收用于处理所接收的输入的分析程序的用户选择。 分析程序由至少一个具有一个或多个抽象规则的抽象规则集定义,每个抽象规则都具有条件​​语句和后续语句。 该方法还包括对所接收的输入执行分析程序,包括(i)识别分析程序的每个抽象规则的所有必需输入,(ii)确定所接收的输入是否包括所有所需输入的数据,以及(iii)如果 所接收的输入不包括用于一个或多个所需输入的数据,从数据库检索所述一个或多个所需输入的合适数据。

    Dynamic discovery of abstract rule set required inputs
    96.
    发明授权
    Dynamic discovery of abstract rule set required inputs 失效
    抽象规则集的动态发现需要输入

    公开(公告)号:US07440945B2

    公开(公告)日:2008-10-21

    申请号:US11272587

    申请日:2005-11-10

    摘要: A method, system and article of manufacture for processing rule sets and, more particularly, for processing abstract rule sets. One embodiment provides a computer-implemented method of managing execution of an analysis routine on input data. The method comprises receiving input and receiving user-selection of an analysis routine for processing the received input. The analysis routine is defined by at least one abstract rule set having one or more abstract rules each having a conditional statement and a consequential statement. The method further comprises executing the analysis routine on the received input, comprising (i) identifying all required inputs for each abstract rule of the analysis routine, (ii) determining whether the received input includes data for all required inputs, and (iii) if the received input does not include data for one or more of the required inputs, retrieving suitable data for the one or more of the required inputs from the database.

    摘要翻译: 一种用于处理规则集的方法,系统和制品,更具体地说,涉及处理抽象规则集。 一个实施例提供了一种管理输入数据分析程序的执行的计算机实现的方法。 该方法包括接收输入和接收用于处理所接收的输入的分析程序的用户选择。 分析程序由至少一个具有一个或多个抽象规则的抽象规则集定义,每个抽象规则都具有条件​​语句和后续语句。 该方法还包括对所接收的输入执行分析程序,包括(i)识别分析程序的每个抽象规则的所有必需输入,(ii)确定所接收的输入是否包括所有所需输入的数据,以及(iii)如果 所接收的输入不包括用于一个或多个所需输入的数据,从数据库检索所述一个或多个所需输入的合适数据。

    Transformation of a physical query into an abstract query
    97.
    发明授权
    Transformation of a physical query into an abstract query 失效
    将物理查询转换为抽象查询

    公开(公告)号:US07333981B2

    公开(公告)日:2008-02-19

    申请号:US11016201

    申请日:2004-12-17

    IPC分类号: G06F17/30

    摘要: Embodiments of the invention provide methods, systems, and articles of manufacture for transforming a physical query (e.g., written in SQL) into an abstract query than can be run against an abstract database described by a database abstraction model. In one embodiment, the transformation occurs as a multiple step process: first, transformation of the physical query into an intermediate representation, such as an abstract query plan, and second, transformation of the intermediate representation into an abstract query. There are thousands upon thousands of existing physical (e.g., SQL) queries. Rather than just abandon these existing queries in favor of an abstract database, embodiments of the present invention provide for reverse query processing, that is, for creating an abstract query of the abstract database from a physical query (e.g., an SQL query) of the physical database underlying the abstraction.

    摘要翻译: 本发明的实施例提供用于将物理查询(例如,以SQL编写)转换成抽象查询的方法,系统和制品,而不是可以针对由数据库抽象模型描述的抽象数据库运行。 在一个实施例中,转换以多步骤过程发生:首先,将物理查询转换为诸如抽象查询计划的中间表示,以及第二,将中间表示转换为抽象查询。 有成千上万的现有物理(例如SQL)查询。 而不是简单地放弃这些现有的查询以支持抽象数据库,本发明的实施例提供反向查询处理,即,用于从所述抽象数据库的物理查询(例如,SQL查询)创建抽象数据库的抽象查询 基础抽象的物理数据库。

    Creation of duration episodes from single time events
    98.
    发明授权
    Creation of duration episodes from single time events 失效
    从单次事件创建持续时间

    公开(公告)号:US07203677B1

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

    申请号:US11326562

    申请日:2006-01-05

    IPC分类号: G06F17/00 G06F12/00

    摘要: One embodiment of the invention provides method for processing a database query that includes an episode-based condition. The method includes determining the time periods associated with one or more duration episodes by analyzing a set of data reflecting values for the episode-based condition captured at various points in time. An episode definition may indicate the substantive data value associated with a duration based event, and the data values used to determine a beginning and ending date/time associated with each episode. Database queries that include the episode-based condition may be composed by specifying a desired value for the episode-based condition used in selecting query results.

    摘要翻译: 本发明的一个实施例提供了一种处理数据库查询的方法,该数据库查询包括基于情节的条件。 该方法包括通过分析反映在不同时间点捕获的基于情节的状况的值的一组数据来确定与一个或多个持续时间相关联的时间段。 剧集定义可以指示与基于持续时间的事件相关联的实质数据值,以及用于确定与每集相关联的开始和结束日期/时间的数据值。 可以通过为选择查询结果中使用的基于剧集的条件指定所需的值来组合包含基于剧集的条件的数据库查询。

    Query conditions-based security
    99.
    发明授权

    公开(公告)号:US09607099B2

    公开(公告)日:2017-03-28

    申请号:US12748616

    申请日:2010-03-29

    IPC分类号: G06F7/00 G06F17/30 G06F21/62

    摘要: A method, system and article of manufacture for managing access to queries and, more particularly, for managing access by multiple users to persistently stored queries. One embodiment provides a method of managing access by multiple users to a predefined query against data in a database. The method comprises associating one or more access rights with at least some portion of the predefined query. When a request to access the predefined query by a first user is received, access to the predefined query by the first user is limited on the basis of the access rights.

    Methods and systems for ordering query results based on annotations
    100.
    发明授权
    Methods and systems for ordering query results based on annotations 有权
    基于注释排序查询结果的方法和系统

    公开(公告)号:US08380708B2

    公开(公告)日:2013-02-19

    申请号:US12041743

    申请日:2008-03-04

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/3053

    摘要: A system, method and article of manufacture for managing query results and, more particularly, for sorting data records contained in a query result obtained in response to execution of a query against a database. In one embodiment, the data records in the query result are sorted on the basis of related information which is retrieved from a corresponding data source. In another embodiment, the sorting is performed on the basis of a value variance which is determined for each of the data records in the query result. In still another embodiment, the sorting is performed on the basis of a requested value range coverage. In yet another embodiment, the sorting is performed on the basis of suitability scores which are determined with respect to analysis routines which are configured for processing the query result.

    摘要翻译: 一种用于管理查询结果的系统,方法和制品,更具体地,用于对包含在响应于针对数据库的查询的执行而获得的查询结果中的数据记录的排序。 在一个实施例中,查询结果中的数据记录基于从相应数据源检索的相关信息进行排序。 在另一个实施例中,基于为查询结果中的每个数据记录确定的值方差来执行排序。 在另一个实施例中,基于请求的值范围覆盖来执行排序。 在另一个实施例中,基于针对被配置用于处理查询结果的分析例程而确定的适合性评分来执行排序。