Abstract query building with selectability of aggregation operations and grouping
    11.
    发明授权
    Abstract query building with selectability of aggregation operations and grouping 失效
    抽象查询构建与聚合操作和分组的可选性

    公开(公告)号:US08161034B2

    公开(公告)日:2012-04-17

    申请号:US12345391

    申请日:2008-12-29

    IPC分类号: G06F7/00 G06F17/30

    摘要: Systems and articles of manufacture for query building with selectability of aggregation operations and grouping. Abstract queries are composed on the basis of a data abstraction model abstractly describing data in the database. The abstract queries may include result criterions and aggregation operations to be performed with respect to the result criterions for generating aggregation information. An object is generated containing query entities and allowing a user to selectively (i) generate a first executable query corresponding to the abstract query inclusive of the aggregation operation and aggregation logic; and (ii) generate a second executable query corresponding to the abstract query exclusive of the aggregation operation and aggregation logic.

    摘要翻译: 用于查询构建的系统和制造,具有聚合操作和分组的可选性。 抽象查询是在抽象地描述数据库中的数据的数据抽象模型的基础上组成的。 抽象查询可以包括关于生成聚合信息的结果标准要执行的结果标准和聚合操作。 生成包含查询实体的对象,并且允许用户选择性地(i)生成与包括聚合操作和聚合逻辑的抽象查询相对应的第一可执行查询; 和(ii)生成排除了聚合操作和聚合逻辑的抽象查询对应的第二可执行查询。

    Automated data model extension through data crawler approach
    12.
    发明授权
    Automated data model extension through data crawler approach 失效
    通过数据抓取方式自动数据模型扩展

    公开(公告)号:US07827159B2

    公开(公告)日:2010-11-02

    申请号:US12049277

    申请日:2008-03-15

    IPC分类号: G06F17/00

    CPC分类号: G06F17/30864

    摘要: Methods, systems, and articles of manufacture for accessing data stored in multiple data sources. Such methods employ an automated software agent to maintain a collection of data sources available for querying. The data sources may all reside within a single local network or may be distributed throughout multiple locations. Generally, the automated software agent searches a given domain for additional data sources according to a defined set of selection criteria. After discovering an additional data source, the automated software agent configures a query application to reflect the availability the additional data source. Further, the automated software agent may periodically evaluate the collection of data sources against the selection criteria and remove those that are either no longer available or no longer satisfy the selection criteria.

    摘要翻译: 用于访问存储在多个数据源中的数据的方法,系统和制品。 这样的方法使用自动化软件代理来维护可用于查询的数据源的集合。 数据源可以全部驻留在单个本地网络中,或者可以分布在多个位置。 通常,自动化软件代理根据定义的选择标准集搜索给定域中的附加数据源。 在发现附加数据源之后,自动化软件代理配置查询应用程序以反映可用性附加数据源。 此外,自动软件代理可以根据选择标准周期性地评估数据源的收集,并去除不再可用或不再满足选择标准的那些。

    ABSTRACT QUERY BUILDING WITH SELECTABILITY OF AGGREGATION OPERATIONS AND GROUPING
    13.
    发明申请
    ABSTRACT QUERY BUILDING WITH SELECTABILITY OF AGGREGATION OPERATIONS AND GROUPING 失效
    摘要查询具有集合操作和分组的可选性

    公开(公告)号:US20090119270A1

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

    申请号:US12345391

    申请日:2008-12-29

    IPC分类号: G06F17/30

    摘要: Systems and articles of manufacture for query building with selectability of aggregation operations and grouping. Abstract queries are composed on the basis of a data abstraction model abstractly describing data in the database. The abstract queries may include result criterions and aggregation operations to be performed with respect to the result criterions for generating aggregation information. An object is generated containing query entities and allowing a user to selectively (i) generate a first executable query corresponding to the abstract query inclusive of the aggregation operation and aggregation logic; and (ii) generate a second executable query corresponding to the abstract query exclusive of the aggregation operation and aggregation logic.

    摘要翻译: 用于查询构建的系统和制造,具有聚合操作和分组的可选性。 抽象查询是在抽象地描述数据库中的数据的数据抽象模型的基础上组成的。 抽象查询可以包括关于生成聚合信息的结果标准要执行的结果标准和聚合操作。 生成包含查询实体的对象,并且允许用户选择性地(i)生成与包括聚合操作和聚合逻辑的抽象查询相对应的第一可执行查询; 和(ii)生成排除了聚合操作和聚合逻辑的抽象查询对应的第二可执行查询。

    Automated data model extension through data crawler approach
    14.
    发明授权
    Automated data model extension through data crawler approach 失效
    通过数据抓取方式自动数据模型扩展

    公开(公告)号:US08165989B2

    公开(公告)日:2012-04-24

    申请号:US12041854

    申请日:2008-03-04

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

    CPC分类号: G06F17/30864

    摘要: Methods, systems, and articles of manufacture for accessing data stored in multiple data sources. Such methods employ an automated software agent to maintain a collection of data sources available for querying. The data sources may all reside within a single local network or may be distributed throughout multiple locations. Generally, the automated software agent searches a given domain for additional data sources according to a defined set of selection criteria. After discovering an additional data source, the automated software agent configures a query application to reflect the availability the additional data source. Further, the automated software agent may periodically evaluate the collection of data sources against the selection criteria and remove those that are either no longer available or no longer satisfy the selection criteria.

    摘要翻译: 用于访问存储在多个数据源中的数据的方法,系统和制品。 这样的方法使用自动化软件代理来维护可用于查询的数据源的集合。 数据源可以全部驻留在单个本地网络中,或者可以分布在多个位置。 通常,自动化软件代理根据定义的选择标准集搜索给定域中的附加数据源。 在发现附加数据源之后,自动化软件代理配置查询应用程序以反映可用性附加数据源。 此外,自动软件代理可以根据选择标准周期性地评估数据源的收集,并去除不再可用或不再满足选择标准的那些。

    Creating a logical table from multiple differently formatted physical tables having different access methods
    16.
    发明授权
    Creating a logical table from multiple differently formatted physical tables having different access methods 有权
    从具有不同访问方式的多个不同格式的物理表创建逻辑表

    公开(公告)号:US08112459B2

    公开(公告)日:2012-02-07

    申请号:US11016203

    申请日:2004-12-17

    IPC分类号: G06F17/30

    摘要: Embodiments of the present invention provide methods for constructing a database abstraction model that includes logical fields that map to a logical table. The logical table is constructed using data extracted from multiple, differently formatted physical tables. The logical table allows logically related data stored in multiple databases to appear as data from a single table. Relationships between data stored in multiple, differently formatted databases are maintained and logical fields that include multiple access methods that map to the multiple databases are replaced with a single access method that maps to the logical table. Data relationships that are defined for the database abstraction model are modified to reflect the logical table.

    摘要翻译: 本发明的实施例提供了构建数据库抽象模型的方法,该模型包括映射到逻辑表的逻辑字段。 使用从多个不同格式的物理表提取的数据构建逻辑表。 逻辑表允许存储在多个数据库中的逻辑相关数据显示为来自单个表的数据。 维护存储在多个不同格式的数据库中的数据之间的关系,并且将包含映射到多个数据库的多个访问方法的逻辑字段替换为映射到逻辑表的单个访问方法。 为数据库抽象模型定义的数据关系被修改以反映逻辑表。

    AUTOMATED DATA MODEL EXTENSION THROUGH DATA CRAWLER APPROACH
    17.
    发明申请
    AUTOMATED DATA MODEL EXTENSION THROUGH DATA CRAWLER APPROACH 失效
    自动数据模型通过数据采集器方法进行扩展

    公开(公告)号:US20080162500A1

    公开(公告)日:2008-07-03

    申请号:US12049277

    申请日:2008-03-15

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30864

    摘要: Methods, systems, and articles of manufacture for accessing data stored in multiple data sources. Such methods employ an automated software agent to maintain a collection of data sources available for querying. The data sources may all reside within a single local network or may be distributed throughout multiple locations. Generally, the automated software agent searches a given domain for additional data sources according to a defined set of selection criteria. After discovering an additional data source, the automated software agent configures a query application to reflect the availability the additional data source. Further, the automated software agent may periodically evaluate the collection of data sources against the selection criteria and remove those that are either no longer available or no longer satisfy the selection criteria.

    摘要翻译: 用于访问存储在多个数据源中的数据的方法,系统和制品。 这样的方法使用自动化软件代理来维护可用于查询的数据源的集合。 数据源可以全部驻留在单个本地网络中,或者可以分布在多个位置。 通常,自动化软件代理根据定义的选择标准集搜索给定域中的附加数据源。 在发现附加数据源之后,自动化软件代理配置查询应用程序以反映可用性附加数据源。 此外,自动软件代理可以根据选择标准周期性地评估数据源的收集,并去除不再可用或不再满足选择标准的那些。

    Methods, systems and articles of manufacture for abstract query building with selectability of aggregation operations and grouping
    18.
    发明授权
    Methods, systems and articles of manufacture for abstract query building with selectability of aggregation operations and grouping 失效
    用于抽象查询构建的方法,系统和制造,具有聚合操作和分组的可选性

    公开(公告)号:US07149731B2

    公开(公告)日:2006-12-12

    申请号:US10723759

    申请日:2003-11-26

    IPC分类号: G06F17/30

    摘要: Methods, systems and articles of manufacture for query building with selectability of summary information. A user interface exposes a plurality of query composition elements for building abstract queries is defined by a data abstraction model. The user interface allows a user to select and apply aggregation operations to result fields of a given abstract query, and further allows a user to define result groups for the given query. The user interface further allows a user to selectively specify whether the given query will be executed as an aggregation query (by applying the aggregation operations), in which case summary information is returned according to the specified result group(s).

    摘要翻译: 用于查询建筑的方法,系统和制品,具有摘要信息的可选性。 暴露用于构建抽象查询的多个查询组合元素的用户界面由数据抽象模型定义。 用户界面允许用户选择并应用聚合操作到给定抽象查询的结果字段,并且还允许用户定义给定查询的结果组。 用户界面还允许用户选择性地指定给定查询是否将作为聚合查询执行(通过应用聚合操作),在这种情况下,根据指定的结果组返回摘要信息。

    Automated data model extension through data crawler approach

    公开(公告)号:US08224872B2

    公开(公告)日:2012-07-17

    申请号:US10877235

    申请日:2004-06-25

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30864

    摘要: Methods, systems, and articles of manufacture for accessing data stored in multiple data sources. Such methods employ an automated software agent to maintain a collection of data sources available for querying. The data sources may all reside within a single local network or may be distributed throughout multiple locations. Generally, the automated software agent searches a given domain for additional data sources according to a defined set of selection criteria. After discovering an additional data source, the automated software agent configures a query application to reflect the availability the additional data source. Further, the automated software agent may periodically evaluate the collection of data sources against the selection criteria and remove those that are either no longer available or no longer satisfy the selection criteria.

    Abstract query building with selectability of aggregation operations and grouping
    20.
    发明授权
    Abstract query building with selectability of aggregation operations and grouping 失效
    抽象查询构建与聚合操作和分组的可选性

    公开(公告)号:US07472117B2

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

    申请号:US11469001

    申请日:2006-08-31

    IPC分类号: G06F17/30

    摘要: Methods, systems and articles of manufacture for query building with selectability of aggregation operations and grouping. Abstract queries are composed on the basis of a data abstraction model abstractly describing data in the database. The abstract queries may include result criterions and aggregation operations to be performed with respect to the result criterions for generating aggregation information. An object is generated containing query entities and allowing a user to selectively (i) generate a first executable query corresponding to the abstract query inclusive of the aggregation operation and aggregation logic; and (ii) generate a second executable query corresponding to the abstract query exclusive of the aggregation operation and aggregation logic.

    摘要翻译: 用于查询构建的方法,系统和制品,具有聚合操作和分组的可选性。 抽象查询是在抽象地描述数据库中的数据的数据抽象模型的基础上组成的。 抽象查询可以包括关于生成聚合信息的结果标准要执行的结果标准和聚合操作。 生成包含查询实体的对象,并且允许用户选择性地(i)生成与包括聚合操作和聚合逻辑的抽象查询相对应的第一可执行查询; 和(ii)生成排除了聚合操作和聚合逻辑的抽象查询对应的第二可执行查询。