会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 61. 发明申请
    • TRANSFORMATION OF A PHYSICAL QUERY INTO AN ABSTRACT QUERY
    • 将物理查询转换为抽象查询
    • US20080147628A1
    • 2008-06-19
    • US12033772
    • 2008-02-19
    • Richard D. DettingerDaniel P. Kolz
    • Richard D. DettingerDaniel P. Kolz
    • G06F17/30
    • G06F17/30436Y10S707/99934Y10S707/99935
    • 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查询)创建抽象数据库的抽象查询 基础抽象的物理数据库。
    • 65. 发明授权
    • Abstract records
    • 摘要记录
    • US08195647B2
    • 2012-06-05
    • US12625071
    • 2009-11-24
    • Richard D. DettingerDaniel P. Kolz
    • Richard D. DettingerDaniel P. Kolz
    • G06F17/30
    • G06F17/3043Y10S707/99931Y10S707/99933Y10S707/99934Y10S707/99943
    • 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.
    • 本发明的实施例提供方法,系统和制品,改进查询组合,查询处理和向抽象数据库的用户呈现查询结果的过程。 本发明的实施例使用抽象记录来组织和查看数据。 具体来说,用户根据数据中存在的逻辑关系构成查询。 不是根据关系表中的一组行来评估条件,而是根据抽象记录的实例来评估抽象查询中包含的条件。 满足抽象查询指定条件的实例作为查询结果返回。 在具体情况下,抽象记录用于评估“从不存在的条件,确定在满足特定条件的抽象记录中不存在数据。
    • 66. 发明授权
    • Ordering query results based on value range filtering
    • 基于值范围过滤来排序查询结果
    • US08185525B2
    • 2012-05-22
    • US12041768
    • 2008-03-04
    • Richard D. DettingerDaniel P. KolzFrederick A. Kulack
    • Richard D. DettingerDaniel P. KolzFrederick A. Kulack
    • G06F7/00
    • 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.
    • 一种用于管理查询结果的系统,方法和制品,更具体地,用于对包含在响应于针对数据库的查询的执行而获得的查询结果中的数据记录的排序。 在一个实施例中,查询结果中的数据记录基于从相应数据源检索的相关信息进行排序。 在另一个实施例中,基于为查询结果中的每个数据记录确定的值方差来执行排序。 在另一个实施例中,基于请求的值范围覆盖来执行排序。 在另一个实施例中,基于针对被配置用于处理查询结果的分析例程而确定的适合性评分来执行排序。
    • 67. 发明授权
    • Automated data model extension through data crawler approach
    • 通过数据抓取方式自动数据模型扩展
    • US08165989B2
    • 2012-04-24
    • US12041854
    • 2008-03-04
    • Richard D. DettingerDaniel P. KolzRichard J. StevensJeffrey W. Tenner
    • Richard D. DettingerDaniel P. KolzRichard J. StevensJeffrey W. Tenner
    • G06F17/00G06F7/00G06F17/30
    • 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.
    • 用于访问存储在多个数据源中的数据的方法,系统和制品。 这样的方法使用自动化软件代理来维护可用于查询的数据源的集合。 数据源可以全部驻留在单个本地网络中,或者可以分布在多个位置。 通常,自动化软件代理根据定义的选择标准集搜索给定域中的附加数据源。 在发现附加数据源之后,自动化软件代理配置查询应用程序以反映可用性附加数据源。 此外,自动软件代理可以根据选择标准周期性地评估数据源的收集,并去除不再可用或不再满足选择标准的那些。
    • 69. 发明授权
    • Management of relationships between database tables
    • 管理数据库表之间的关系
    • US08055683B2
    • 2011-11-08
    • US10965186
    • 2004-10-14
    • Mark A. BrodhunRichard D. DettingerJanice R. GlowackiDaniel P. Kolz
    • Mark A. BrodhunRichard D. DettingerJanice R. GlowackiDaniel P. Kolz
    • G06F7/00
    • G06F17/30604
    • A method, system and article of manufacture for managing relationships between database tables and, more particularly, for identifying and accurately describing relationships between tables in a database. One embodiment provides a method for identifying relationships between tables in a database. The method comprises receiving user input selecting a plurality of tables from the database. The plurality of tables is organized into a logical island defining a logical unit related to a particular logical entity. The method further comprises receiving user input identifying, for each of the plurality of tables, a table column containing information that identifies the particular logical entity in the table, whereby the identified table columns of different tables define logical relationships between the different tables in the logical island. On the basis of the identified table columns, relations specifications are created which describe the logical relationships between the different tables in the logical island.
    • 一种用于管理数据库表之间的关系的方法,系统和制品,更具体地,用于识别和准确描述数据库中的表之间的关系。 一个实施例提供了一种用于识别数据库中的表之间的关系的方法。 该方法包括接收从数据库中选择多个表的用户输入。 多个表被组织成定义与特定逻辑实体相关的逻辑单元的逻辑岛。 所述方法还包括接收用户输入,对于所述多个表中的每一个,识别包含标识所述表中的特定逻辑实体的信息的表列,由此所标识的不同表的表列定义逻辑中不同表之间的逻辑关系 岛。 在识别的表列的基础上,创建了描述逻辑岛中的不同表之间的逻辑关系的关系规范。
    • 70. 发明授权
    • Sorting data records contained in a query result
    • 对查询结果中包含的数据记录进行排序
    • US08027985B2
    • 2011-09-27
    • US12472281
    • 2009-05-26
    • Richard D. DettingerDaniel P. KolzFrederick A. Kulack
    • Richard D. DettingerDaniel P. KolzFrederick A. Kulack
    • G06F17/30
    • G06F17/3053G06F17/30941Y10S707/99933Y10S707/99937
    • A system 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.
    • 一种用于管理查询结果的系统和制品,更具体地,用于对包含在响应于针对数据库的查询的执行而获得的查询结果中的数据记录的排序。 在一个实施例中,查询结果中的数据记录基于从相应数据源检索的相关信息进行排序。 在另一个实施例中,基于为查询结果中的每个数据记录确定的值方差来执行排序。 在另一个实施例中,基于请求的值范围覆盖来执行排序。 在另一个实施例中,基于针对被配置用于处理查询结果的分析例程而确定的适合性评分来执行排序。