专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US08548985B2 Method and process of query optimization to a given environment via specific abstraction layer domain knowledge 有权
标题翻译：通过特定抽象层领域知识，给定环境查询优化的方法和过程
公开(公告)号：US08548985B2
公开(公告)日：2013-10-01
申请号：US10977765
申请日：2004-10-29
申请人： Richard D. Dettinger , Travis M. Drucker , Brian R. Muras , Jeffrey W. Tenner
发明人： Richard D. Dettinger , Travis M. Drucker , Brian R. Muras , Jeffrey W. Tenner
IPC分类号： G06F17/30
CPC分类号： G06F17/3056
摘要： Methods and apparatus for optimizing an abstract query are disclosed. Embodiments of the present invention allow an abstract database to optimize an abstract query composed from a set of logical fields. Each logical field includes a field name and an access method used to map the logical field to an underlying physical representation of the data. After a user composes an abstract query and submits it for execution, a runtime component and optimization component may be configured to resolve the abstract query to a physical query of the underlying physical data source using an access method associated with each logical field. In addition, as the runtime component builds a query consistent with the schema of the underlying database, an optimizing component may modify the query using any suitable optimization techniques. Different optimization techniques include optimizations based on logical field metadata, optimizations based on the underlying physical data repositories referenced by an access method and optimizations based on the relationships between logical fields or underlying data structures.
摘要翻译：公开了优化抽象查询的方法和装置。本发明的实施例允许抽象数据库优化由一组逻辑字段组成的抽象查询。每个逻辑字段包括字段名称和用于将逻辑字段映射到数据的底层物理表示的访问方法。在用户组成抽象查询并将其提交以执行之后，可以将运行时组件和优化组件配置为使用与每个逻辑字段相关联的访问方法将抽象查询解析为底层物理数据源的物理查询。此外，由于运行时组件构建与基础数据库的模式一致的查询，因此优化组件可以使用任何合适的优化技术来修改查询。不同的优化技术包括基于逻辑字段元数据的优化，基于访问方法引用的底层物理数据存储库的优化和基于逻辑字段或底层数据结构之间的关系的优化。

2. 发明授权

US08224810B2 Abstract classification field specification 失效
标题翻译：抽象分类字段规范
公开(公告)号：US08224810B2
公开(公告)日：2012-07-17
申请号：US12036097
申请日：2008-02-22
申请人： Richard D. Dettinger , Thomas J. Eggebraaten , Jeffrey W. Tenner
发明人： Richard D. Dettinger , Thomas J. Eggebraaten , Jeffrey W. Tenner
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30398 , G06F17/30525 , G06F17/30926
摘要： Techniques are disclosed for storing and rendering a graphical user interface (GUI) that includes a display area for specifying result fields and operators to define an abstract query. Each result field corresponds to a logical field specification of a data abstraction model abstractly describing data in a database. The GUI further includes a display area for specifying classification fields for the abstract query, each classification field including a result field and a classification definition, and the display area including a result field window displaying available result fields and graphical elements configured to allow specification of classification definitions for one or more selected result fields. The classification definition is suitable for dividing data into a plurality of categories. The GUI further includes a selection element for specifying whether the specified classification fields are included with the abstract query for execution, and another selection element for initiating execution of the abstract query.
摘要翻译：公开了用于存储和呈现包括用于指定结果字段的显示区域和用于定义抽象查询的运算符的图形用户界面（GUI）的技术。每个结果字段对应于抽象地描述数据库中的数据的数据抽象模型的逻辑字段规范。 GUI还包括用于指定抽象查询的分类字段的显示区域，每个分类字段包括结果字段和分类定义，并且显示区域包括显示可用结果字段的结果字段窗口和被配置为允许指定分类的图形元素一个或多个选定结果字段的定义。分类定义适合于将数据分割成多个类别。 GUI还包括用于指定指定的分类字段是否包括在用于执行的抽象查询中的选择元素，以及用于发起抽象查询的执行的另一选择元素。

3. 发明申请

US20120179712A1 ENCODED MATRIX INDEX 有权
标题翻译：编码矩阵索引
公开(公告)号：US20120179712A1
公开(公告)日：2012-07-12
申请号：US13422560
申请日：2012-03-16
申请人： Robert J. Bestgen , Thomas J. Eggebraaten , Jeffrey W. Tenner
发明人： Robert J. Bestgen , Thomas J. Eggebraaten , Jeffrey W. Tenner
IPC分类号： G06F17/30
CPC分类号： G06F17/30324 , G06F19/28
摘要： A method, apparatus, and program product are provided for creating an Encoded Matrix Index for a column in a database table. An element of the column for all rows in the database table is compared to a corresponding reference value in a reference data structure, and in response to at least one value for the element of the column not matching the reference value, indicating a variation in a variation data structure and creating a value data structure. Queries executed using the Encoded Matrix Index include terms associated with a sub-column defined in a column of a database table. The variation data structure is accessed to determine whether any variation exists between rows belonging to a sub-column of the database table. If no variation exists, a value is accessed from the reference data structure; otherwise, a value for each row of the sub-column is accessed from a value data structure.
摘要翻译：提供了一种方法，装置和程序产品，用于为数据库表中的列创建编码矩阵索引。将数据库表中所有行的列的元素与参考数据结构中的对应参考值进行比较，并响应于不匹配参考值的列的元素的至少一个值，指示在变化数据结构和创建价值数据结构。使用编码矩阵索引执行的查询包括与数据库表的列中定义的子列相关联的术语。访问变体数据结构以确定属于数据库表的子列的行之间是否存在变化。如果不存在变化，则从参考数据结构访问值; 否则，从值数据结构访问子列的每一行的值。

4. 发明授权

US08161034B2 Abstract query building with selectability of aggregation operations and grouping 失效
标题翻译：抽象查询构建与聚合操作和分组的可选性
公开(公告)号：US08161034B2
公开(公告)日：2012-04-17
申请号：US12345391
申请日：2008-12-29
申请人： Richard D. Dettinger , Daniel P. Kolz , Richard J. Stevens , Jeffrey W. Tenner
发明人： Richard D. Dettinger , Daniel P. Kolz , Richard J. Stevens , Jeffrey W. Tenner
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30412 , G06F17/30489 , Y10S707/99932 , Y10S707/99933
摘要： 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）生成排除了聚合操作和聚合逻辑的抽象查询对应的第二可执行查询。

5. 发明授权

US08122048B2 Context sensitive term expansion with dynamic term expansion 有权
标题翻译：具有动态期限扩展的上下文敏感项扩展
公开(公告)号：US08122048B2
公开(公告)日：2012-02-21
申请号：US12564383
申请日：2009-09-22
申请人： Richard D. Dettinger , David G. Herbeck , Jeffrey W. Tenner , Eric W. Will
发明人： Richard D. Dettinger , David G. Herbeck , Jeffrey W. Tenner , Eric W. Will
IPC分类号： G06F17/30
CPC分类号： G06F17/30398 , G06F17/30427 , G06F17/30672 , Y10S707/99933 , Y10S707/99934
摘要： Methods, articles of manufacture and systems for searching collections of data using context sensitive expanded term searching using dynamic term expansion are provided. The collection of data may be a relational database, text document, or any other type of searchable collection of data. In either case, a query including a search condition based on a specified search term may be modified to include additional conditions based on a set of expanded (e.g., conceptually-related) search terms dynamically linked with the query. For some embodiments, a user may be given the ability to choose whether the set of expanded search terms are dynamically linked with the query or not.
摘要翻译：提供了使用动态术语扩展的上下文敏感扩展术语搜索的方法，制品和用于搜索数据集合的系统。数据的收集可以是关系数据库，文本文档或任何其他类型的可搜索的数据集合。在任一情况下，可以修改包括基于指定搜索项的搜索条件的查询，以便基于与查询动态链接的一组扩展（例如，概念上相关的）搜索项来包括附加条件。对于一些实施例，可以向用户提供选择该扩展搜索项集合是否与查询动态链接的能力。

6. 发明授权

US07890524B2 Dynamic database access via standard query language and abstraction technology 有权
标题翻译：通过标准查询语言和抽象技术实现动态数据库访问
公开(公告)号：US07890524B2
公开(公告)日：2011-02-15
申请号：US12113127
申请日：2008-04-30
申请人： Richard D. Dettinger , Jeffrey W. Tenner
发明人： Richard D. Dettinger , Jeffrey W. Tenner
IPC分类号： G06F7/00
CPC分类号： G06F17/30427 , Y10S707/99932 , Y10S707/99934 , Y10S707/99942
摘要： Methods, systems, and articles of manufacture that allow saved abstract queries to be referenced from within query statements constructed using standard query languages, such as Structured Query Language (SQL), are provided.
摘要翻译：提供了允许保存的抽象查询从使用标准查询语言构造的查询语句（如结构化查询语言（SQL））中引用的方法，系统和制品。

7. 发明授权

US07870145B2 Utilization of logical fields with conditional constraints in abstract queries 有权
标题翻译：在抽象查询中利用条件约束的逻辑域
公开(公告)号：US07870145B2
公开(公告)日：2011-01-11
申请号：US12106717
申请日：2008-04-21
申请人： Richard D. Dettinger , Jeffrey W. Tenner
发明人： Richard D. Dettinger , Jeffrey W. Tenner
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30398 , Y10S707/918 , Y10S707/99933
摘要： Methods, systems, and articles of manufacture are provided for enhancing abstract queries by utilizing logical fields with conditional constraints. Building abstract queries with logical fields configured with conditional constraints allows for optimized physical queries to be generated from corresponding abstract queries.
摘要翻译：提供了方法，系统和制造条件，以通过利用具有条件约束的逻辑域来增强抽象查询。使用配置有条件约束的逻辑字段构建抽象查询允许从相应的抽象查询生成优化的物理查询。

8. 发明授权

US07827159B2 Automated data model extension through data crawler approach 失效
标题翻译：通过数据抓取方式自动数据模型扩展
公开(公告)号：US07827159B2
公开(公告)日：2010-11-02
申请号：US12049277
申请日：2008-03-15
申请人： Richard D. Dettinger , Daniel P. Kolz , Richard J. Stevens , Jeffrey W. Tenner
发明人： Richard D. Dettinger , Daniel P. Kolz , Richard J. Stevens , Jeffrey W. Tenner
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.
摘要翻译：用于访问存储在多个数据源中的数据的方法，系统和制品。这样的方法使用自动化软件代理来维护可用于查询的数据源的集合。数据源可以全部驻留在单个本地网络中，或者可以分布在多个位置。通常，自动化软件代理根据定义的选择标准集搜索给定域中的附加数据源。在发现附加数据源之后，自动化软件代理配置查询应用程序以反映可用性附加数据源。此外，自动软件代理可以根据选择标准周期性地评估数据源的收集，并去除不再可用或不再满足选择标准的那些。

9. 发明申请

US20090182708A1 DEALING WITH COMPOSITE DATA THROUGH DATA MODEL ENTITIES 有权
标题翻译：通过数据模型实体处理复合数据
公开(公告)号：US20090182708A1
公开(公告)日：2009-07-16
申请号：US12409193
申请日：2009-03-23
申请人： RICHARD D. DETTINGER , Jennifer L. LaRocca , Richard J. Stevens , Jeffrey W. Tenner
发明人： RICHARD D. DETTINGER , Jennifer L. LaRocca , Richard J. Stevens , Jeffrey W. Tenner
IPC分类号： G06F17/30
CPC分类号： G06F17/30398 , Y10S707/962 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99936 , Y10S707/99942 , Y10S707/99952
摘要： The present invention is generally directed to a system, method and article of manufacture for accessing data represented abstractly through an abstraction model. In one embodiment, a data repository abstraction layer provides a logical view of an underlying data repository that is independent of the particular manner of data representation. A query abstraction layer is also provided and is based on the data repository abstraction layer. A runtime component performs conversion of an abstract query (i.e., a request for results or a request to modify data) into a form that can be used against a particular physical data representation. Abstract and/or physical queries are transformed according to model entities which define a relationship between logical fields of the data repository abstraction layer.
摘要翻译：本发明一般涉及通过抽象模型抽象地访问数据的系统，方法和制品。在一个实施例中，数据存储库抽象层提供独立于数据表示的特定方式的底层数据存储库的逻辑视图。还提供查询抽象层，并基于数据库抽象层。运行时组件执行将抽象查询（即，对结果的请求或修改数据的请求）转换成可以针对特定物理数据表示使用的形式。根据定义数据库抽象层的逻辑字段之间的关系的模型实体来转换抽象和/或物理查询。

10. 发明申请

US20090119270A1 ABSTRACT QUERY BUILDING WITH SELECTABILITY OF AGGREGATION OPERATIONS AND GROUPING 失效
标题翻译：摘要查询具有集合操作和分组的可选性
公开(公告)号：US20090119270A1
公开(公告)日：2009-05-07
申请号：US12345391
申请日：2008-12-29
申请人： Richard D. Dettinger , Daniel P. Kolz , Richard J. Stevens , Jeffrey W. Tenner
发明人： Richard D. Dettinger , Daniel P. Kolz , Richard J. Stevens , Jeffrey W. Tenner
IPC分类号： G06F17/30
CPC分类号： G06F17/30412 , G06F17/30489 , Y10S707/99932 , Y10S707/99933
摘要： 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）生成排除了聚合操作和聚合逻辑的抽象查询对应的第二可执行查询。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式