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

1. 发明授权

US07007009B2 Representation for data used in query optimization 失效
公开(公告)号：US07007009B2
公开(公告)日：2006-02-28
申请号：US09810973
申请日：2001-03-15
申请人： Robert Joseph Bestgen , Curtis Neal Boger , John David Dietel , Randy L. Egan
发明人： Robert Joseph Bestgen , Curtis Neal Boger , John David Dietel , Randy L. Egan
IPC分类号： G60F17/30
CPC分类号： G06F17/30469 , Y10S707/99933 , Y10S707/99934 , Y10S707/99943
摘要： Optimizers must work with numeric data from a variety of sources including column statistics, estimated filter factors, record counts estimated costs and the like. Embodiments provided herein define and represent any such numeric measurements as a Vector of N dimensions, where n is a number of aspects of measurements that a particular optimizer is configured to consider. A particular embodiment provides a 4-dimensional vector where the dimensions represent magnitude, confidence, variance interval, and penalty. Examples of measurements considered by the optimizer, and which may be represented as a vector, include cost, estimated selectivity of a predicate, estimated number of records returned from part or all of a query, estimated record fanout when joining one file to another, etc.

2. 发明授权

US06449660B1 Object-oriented I/O device interface framework mechanism 失效
标题翻译：面向对象的I / O设备接口框架机制
公开(公告)号：US06449660B1
公开(公告)日：2002-09-10
申请号：US08509619
申请日：1995-07-31
申请人： William Frederick Berg , John David Dietel , Edward John Rowlance
发明人： William Frederick Berg , John David Dietel , Edward John Rowlance
IPC分类号： G06F300
CPC分类号： G06F9/4411
摘要： At the most general level, the I/O framework mechanism of the present invention is made up of three interdependent controllers. These controllers are referred to herein as the hardware resource administrator, the information controller, and the device controller. The hardware resource administrator is responsible for organizing information about I/O devices and for making the organized information available to the other controllers. The information controller is responsible for gathering information about I/O devices and for changing and/or updating certain I/O device information. Accordingly, the information controller is made up of individual objects that each represent the characteristics of a particular I/O device. The device controller is responsible for controlling the actual operation of the individual devices, and for performing statistical and diagnostic analysis on the individual I/O devices.
摘要翻译：在最一般的层面上，本发明的I / O框架机构由三个相互依赖的控制器组成。这些控制器在这里被称为硬件资源管理员，信息控制器和设备控制器。硬件资源管理员负责组织有关I / O设备的信息，并将有组织的信息提供给其他控制器。信息控制器负责收集有关I / O设备的信息，以及更改和/或更新某些I / O设备信息。因此，信息控制器由各自表示特定I / O设备的特性的各个对象组成。设备控制器负责控制各个设备的实际操作，并对各个I / O设备进行统计和诊断分析。

3. 发明申请

US20070212967A1 Thermal control nonwoven material 有权
标题翻译：热控非织造材料
公开(公告)号：US20070212967A1
公开(公告)日：2007-09-13
申请号：US11799551
申请日：2007-05-01
申请人： Peter Grynaeus , Duncan Russell , Terry O'Regan , David Dietel , Susan Johnson
发明人： Peter Grynaeus , Duncan Russell , Terry O'Regan , David Dietel , Susan Johnson
IPC分类号： D04H13/00
CPC分类号： D06M23/12 , A43B1/00 , A43B7/34 , A43B17/003 , A43B19/00 , A43B23/07 , D04H1/413 , D04H1/64 , D21H21/14 , D21H21/54 , Y10T428/2913 , Y10T428/2915 , Y10T428/2927 , Y10T428/2984 , Y10T442/2016 , Y10T442/2738 , Y10T442/60 , Y10T442/614
摘要： A nonwoven textile having reversible enhanced thermal control properties, the material comprising: a bat or web bonded by polymeric binder containing thermal control material within the interior of the bat or web, wherein the thermal control material is dispersed throughout the interior of the polymeric binder, and wherein the thermal control material is substantially entirely within the interior of the nonwoven textile.
摘要翻译：一种具有可逆增强的热控制性能的非织造织物，所述材料包括：通过在蝙蝠或纤维网内部含有热控制材料的聚合物粘合剂粘合的蝙蝠或网，其中所述热控制材料分散在聚合物粘合剂的整个内部，并且其中所述热控制材料基本上完全位于所述非织造织物的内部。

4. 发明授权

US06915290B2 Database query optimization apparatus and method that represents queries as graphs 失效
标题翻译：将查询表示为图形的数据库查询优化装置和方法
公开(公告)号：US06915290B2
公开(公告)日：2005-07-05
申请号：US10014996
申请日：2001-12-11
申请人： Robert Joseph Bestgen , Curtis Boger , John David Dietel , Robert Victor Downer
发明人： Robert Joseph Bestgen , Curtis Boger , John David Dietel , Robert Victor Downer
IPC分类号： G06F17/30
CPC分类号： G06F17/30436 , G06F17/30463 , Y10S707/99932
摘要： A database query optimizer constructs a graph comprising nodes, relations, and expressions. The query optimizer then constructs execution plans for sub-parts of the graph. The combination of execution plans make up the overall execution plan for the query. The execution plan information is appended to the graph itself, allowing changing an execution plan in one portion of the graph without necessarily changing execution plans in other portions of the graph. By representing a query using the graph of the preferred embodiments that includes execution plan information, the query optimizer is able to evaluate the execution plans of different options quickly and efficiently, thereby enhancing the performance of the query optimizer.
摘要翻译：数据库查询优化器构建包含节点，关系和表达式的图。然后，查询优化器构建图形子部分的执行计划。执行计划的组合构成查询的总体执行计划。执行计划信息附加到图形本身，允许在图的一部分中改变执行计划，而不必在图的其他部分中改变执行计划。通过使用包括执行计划信息的优选实施例的图表示查询，查询优化器能够快速有效地评估不同选项的执行计划，从而增强查询优化器的性能。

5. 发明授权

US06754652B2 Database query optimizer framework with dynamic strategy dispatch 有权
标题翻译：数据库查询优化器框架与动态策略调度
公开(公告)号：US06754652B2
公开(公告)日：2004-06-22
申请号：US10113174
申请日：2002-03-29
申请人： Robert Joseph Bestgen , Curtis Boger , John David Dietel , Robert Victor Downer
发明人： Robert Joseph Bestgen , Curtis Boger , John David Dietel , Robert Victor Downer
IPC分类号： G06F1730
CPC分类号： G06F17/30463 , Y10S707/99933 , Y10S707/99934
摘要： An apparatus, program product and method utilize a query optimizer that relies upon a plurality of dynamically-dispatchable active strategy entities to generate an optimized execution plan for a database query. The plurality of active strategy entities form a optimizer framework from which the knowledge available to the optimizer, and the intelligence utilized by the optimizer in generating execution plans, may be represented in a structured, flexible, extensible and easily-modifiable manner.
摘要翻译：设备，程序产品和方法利用依赖于多个可动态分派的主动策略实体来生成针对数据库查询的优化执行计划的查询优化器。多个主动策略实体形成优化器框架，从优化器框架可以以结构化，灵活，可扩展和易于修改的方式来表示优化器可用的知识以及优化器在生成执行计划中使用的智能。

6. 发明授权

US07409387B2 Materialized query table matching with query expansion 有权
标题翻译：物化查询表与查询扩展匹配
公开(公告)号：US07409387B2
公开(公告)日：2008-08-05
申请号：US11068264
申请日：2005-02-28
申请人： John David Dietel
发明人： John David Dietel
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30457 , Y10S707/99933 , Y10S707/99934
摘要： Methods, apparatuses, and computer program products for materialized query table matching are provided that include receiving a database query, retrieving a materialized query table (MQT) from data storage accessible to a database management system, selecting a join in the materialized query table between a table that is not invoked by the query and a table that is invoked in the query, determining whether the selected join is lossless, and expanding the query to include the lossless join if the selected join is lossless, expanding the query to include the lossless join. Determining whether the selected join is lossless may be carried out by losslessly joining the table that is not invoked by the query to the query, and determining whether the lossless join to the query matches the selected join of the materialized query table.
摘要翻译：提供了用于物化查询表匹配的方法，装置和计算机程序产品，包括接收数据库查询，从数据库管理系统可访问的数据存储中检索物化查询表（MQT），在物理化查询表中选择一个连接查询中未调用的表和查询中调用的表，确定所选连接是否为无损，并且如果所选连接无损，则扩展查询以包括无损连接，将查询扩展为包含无损连接。确定所选择的连接是否是无损的，可以通过将查询未被调用的表无损地加入查询来执行，并且确定对查询的无损连接是否与所述实体化查询表的所选连接相匹配。

7. 发明授权

US07171398B2 Outer and exception join to inner join normalization 有权
标题翻译：外部和异常连接到内部连接规范化
公开(公告)号：US07171398B2
公开(公告)日：2007-01-30
申请号：US10687286
申请日：2003-10-16
申请人： Robert Joseph Bestgen , John David Dietel , Robert Victor Downer
发明人： Robert Joseph Bestgen , John David Dietel , Robert Victor Downer
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , G06F17/30466 , Y10S707/99932
摘要： An apparatus, program product and method utilize a query optimizer that identifies Join types in a query plan that can be replaced to facilitate optimization of the plan. If the query plan is considered to have a tree-graph representation, then the optimizer locates Join nodes to be replaced and substitutes an Inner Join node and additional nodes that do not inhibit optimization strategies and algorithms. As a result, all Outer Joins, whether left or right, and all Exception Joins, whether left or right, can be removed from the query plan before performing optimizations such as predicate movement, GROUP BY movement, ORDER BY movement, and Join enumeration.
摘要翻译：设备，程序产品和方法利用查询优化器来识别可以替换的查询计划中的连接类型，以促进计划的优化。如果查询计划被认为具有树形图表示，那么优化器定位要替换的连接节点，并替代内部连接节点和不抑制优化策略和算法的其他节点。因此，在进行优化，如谓词移动，GROUP BY移动，ORDER BY运动和Join枚举之前，可以从查询计划中删除所有外部连接（无论是左侧还是右侧）以及所有异常连接（无论是左侧还是右侧）。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式