公开(公告)号：US20060106777A1

公开(公告)日：2006-05-18

申请号：US10992400

申请日：2004-11-18

申请人： Michael Faunce ,  Shantan Kethireddy ,  Brian Muras

发明人： Michael Faunce ,  Shantan Kethireddy ,  Brian Muras

IPC分类号： G06F17/30

CPC分类号： G06F17/30469 ,  G06F17/30474 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99945

摘要： A database management system predicts a selectivity for database query conditions requiring a join of records from different tables. The system identifies at least one skewed value in a field specified in the join condition, and constructs, for each skewed value, a set of hypothetical query predicates in which the field specified in the join condition is replaced with a constant equal to the skewed value. The system then predicts the selectivity for the hypothetical predicates, using any appropriate prediction technique. The selectivities of the hypothetical predicates are used to predict a selectivity for the original query.

公开(公告)号：US20080065594A1

公开(公告)日：2008-03-13

申请号：US11938847

申请日：2007-11-13

申请人： Michael Faunce ,  Shantan Kethireddy ,  Brian Muras

发明人： Michael Faunce ,  Shantan Kethireddy ,  Brian Muras

IPC分类号： G06F17/30

CPC分类号： G06F17/30469 ,  G06F17/30474 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99945

摘要： A database management system predicts a selectivity for database query conditions requiring a join of records from different tables. The system identifies at least one skewed value in a field specified in the join condition, and constructs, for each skewed value, a set of hypothetical query predicates in which the field specified in the join condition is replaced with a constant equal to the skewed value. The system then predicts the selectivity for the hypothetical predicates, using any appropriate prediction technique. The selectivities of the hypothetical predicates are used to predict a selectivity for the original query.

摘要翻译： 数据库管理系统预测数据库查询条件的选择性需要来自不同表的记录的连接。 系统识别在连接条件中指定的字段中的至少一个偏斜值，并且针对每个偏斜值构造一组假设查询谓词，其中在连接条件中指定的字段被等于倾斜值的常数替换 。 然后，系统使用任何适当的预测技术来预测假设谓词的选择性。 假设谓词的选择性用于预测原始查询的选择性。

公开(公告)号：US20080052286A1

公开(公告)日：2008-02-28

申请号：US11931255

申请日：2007-10-31

申请人： Michael Faunce ,  Shantan Kethireddy ,  Brian Muras

发明人： Michael Faunce ,  Shantan Kethireddy ,  Brian Muras

IPC分类号： G06F17/30

CPC分类号： G06F17/30469 ,  G06F17/30474 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99945

摘要： A database management system predicts a selectivity for database query conditions requiring a join of records from different tables. The system identifies at least one skewed value in a field specified in the join condition, and constructs, for each skewed value, a set of hypothetical query predicates in which the field specified in the join condition is replaced with a constant equal to the skewed value. The system then predicts the selectivity for the hypothetical predicates, using any appropriate prediction technique. The selectivities of the hypothetical predicates are used to predict a selectivity for the original query.

公开(公告)号：US20070043697A1

公开(公告)日：2007-02-22

申请号：US11207055

申请日：2005-08-18

申请人： Robert Driesch ,  John Edwards ,  Michael Faunce ,  Brian Muras

发明人： Robert Driesch ,  John Edwards ,  Michael Faunce ,  Brian Muras

IPC分类号： G06F17/30

CPC分类号： G06F17/30469

摘要： An apparatus, program product and method generate at least one statistic for a temporary table during optimization of a database query before the temporary table is created. By doing so, optimization can proceed on a database query irrespective of the fact that the temporary table may not be materialized until the database query is ultimately executed.

摘要翻译： 在创建临时表之前，在优化数据库查询期间，设备，程序产品和方法生成临时表的至少一个统计量。 通过这样做，可以在数据库查询上进行优化，而不管在最终执行数据库查询之前临时表可能未被实现的事实。

公开(公告)号：US20060095405A1

公开(公告)日：2006-05-04

申请号：US10977763

申请日：2004-10-29

申请人： Mark Anderson ,  Michael Faunce ,  Brian Muras

发明人： Mark Anderson ,  Michael Faunce ,  Brian Muras

IPC分类号： G06F17/30

CPC分类号： G06F16/22

摘要： Mirroring database statistics, including receiving by a backup application of a backup computer a journal entry representing a requirement for backup database statistics and generating by a statistics engine of the backup computer backup database statistics for a backup database in accordance with the journal entry. Mirroring database statistics according to embodiments of the present invention may also include identifying by an original DBMS of an original database a requirement for backup database statistics and inserting in a database journal by the original DBMS the journal entry representing the requirement for backup database statistics.

摘要翻译： 镜像数据库统计信息，包括由备份计算机的备份应用程序接收表示备份数据库统计信息要求的日志条目，并根据日记帐分录由统计引擎为备份计算机备份数据库统计信息生成备份数据库。 根据本发明的实施例的镜像数据库统计还可以包括由原始数据库对原始数据库标识对备份数据库统计的要求，并由原始DBMS在数据库日志中插入表示备份数据库统计的需求的日志条目。

公开(公告)号：US20060167914A1

公开(公告)日：2006-07-27

申请号：US11044753

申请日：2005-01-27

申请人： Michael Faunce ,  Brian Muras

发明人： Michael Faunce ,  Brian Muras

IPC分类号： G06F17/00 ,  G06F7/00

CPC分类号： G06F17/30442

摘要： Building database statistics for use by a query optimizer is beneficial but may over utilize system resources. Accordingly, the frequency that statistics are rebuilt is controlled in order to minimize the effect of the system. In particular, the staleness of the data and the time since the last statistics collection are used to determine whether or not to re-collect statistics. Even for relatively stale data, statistics are not rebuilt until a predetermined time period has passed.

摘要翻译： 构建数据库统计信息以供查询优化器使用是有益的，但可能会过度利用系统资源。 因此，为了最小化系统的影响，控制统计重建的频率。 具体来说，数据的平均化以及自上次统计收集以来的时间被用于确定是否重新收集统计数据。 即使对于相对过时的数据，统计数据也不会重建，直到预定时间段过去。

公开(公告)号：US20050228772A1

公开(公告)日：2005-10-13

申请号：US10815231

申请日：2004-03-31

申请人： Michael Faunce ,  Brian Muras

发明人： Michael Faunce ,  Brian Muras

IPC分类号： G06F17/30

CPC分类号： G06F17/30454 ,  G06F17/30312 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99935

摘要： A database query optimizer determines when no optimal index for a query exists, determines whether a sub-optimal index exists, and if so, uses statistical information for each additional key in the sub-optimal index to rewrite the query in a manner that allows traversing the sub-optimal index. The sub-optimal index is then probed using the rewritten query, and the number of estimated returned rows is then used to optimize the query.

摘要翻译： 数据库查询优化器确定何时不存在查询的最佳索引，确定是否存在次优索引，如果是，则使用次优索引中每个附加密钥的统计信息以允许遍历的方式重写查询 次优指标。 然后使用重写的查询探测次优索引，然后使用估计的返回行数来优化查询。

公开(公告)号：US20060074875A1

公开(公告)日：2006-04-06

申请号：US10955742

申请日：2004-09-30

申请人： Michael Faunce ,  Wayne Sadecki

发明人： Michael Faunce ,  Wayne Sadecki

IPC分类号： G06F17/30

CPC分类号： G06F16/2462 ,  G06F16/24542

摘要： A database management system associates, for one or more database fields, a respective representation of cardinality with different discrete subsets of database records, the subsets preferably being defined by different quantiles of an equal height histogram. The system predicts a relative number of records responsive to a query condition using the representation of cardinality of a quantile in which a query-specified value lies. Preferably, a relative number of responsive records is estimated as a quantile size representation divided by a cardinality representation. The system uses this prediction to determine an optimum query execution strategy. Preferably, the system derives histogram data including cardinality and ordinal numbers corresponding to each quantile using sampling techniques.

摘要翻译： 数据库管理系统针对一个或多个数据库字段将基数的相应表示与数据库记录的不同离散子集相关联，子集优选地由相等高度直方图的不同分位数来定义。 该系统使用查询指定值所在的分位数的基数表示来预测响应于查询条件的记录的相对数量。 优选地，响应记录的相对数量被估计为分数位置大小表示除以基数表示。 系统使用该预测来确定最佳查询执行策略。 优选地，系统使用采样技术来导出包括对应于每个分位数的基数和序数的直方图数据。

公开(公告)号：US20070053173A1

公开(公告)日：2007-03-08

申请号：US11497773

申请日：2006-08-02

申请人： Michael Faunce

发明人： Michael Faunce

IPC分类号： F21V33/00

CPC分类号： F21V33/006 ,  F21Y2115/10 ,  H01H9/182

摘要： Disclosed is a night lighting system retrofittable with existing wall switches for illuminating an area around the wall switches. The night lighting system comprises: a wall plate having at least one switch receiving slot capable of receiving a switch, at least one lens assembly disposed on the wall plate, a printed circuit board having at least one light emitting diode and interface wires electrically connecting the night lighting system to a power switch. The lens assembly has a chamber protruding from a back surface of the wall plate, and a lens covering a front end of the chamber. The chamber is capable of receiving at least a portion of the light emitting diode, such that, light from the light emitting diode passes-though the lens to illuminate an area around the switch.

摘要翻译： 公开了一种夜间照明系统，可以利用现有的墙壁开关进行改装，以照亮墙壁开关周围的区域。 夜间照明系统包括：壁板，其具有能够接收开关的至少一个开关接收槽，设置在壁板上的至少一个透镜组件，具有至少一个发光二极管的印刷电路板和电连接 夜间照明系统到电源开关。 透镜组件具有从壁板的后表面突出的室和覆盖室的前端的透镜。 该室能够接收至少一部分发光二极管，使得来自发光二极管的光通过透镜，以照亮开关周围的区域。

公开(公告)号：US20070127241A1

公开(公告)日：2007-06-07

申请号：US11657436

申请日：2007-01-23

申请人： Michael Faunce

发明人： Michael Faunce

IPC分类号： F21V23/04

CPC分类号： F21V33/006 ,  F21Y2115/10 ,  H01H9/182 ,  Y10S362/80

摘要： The present invention is a low power and low heat dissipating, low illumination system that is based in an electrical box cover plate, preferably in a light switch cover plate. It allows for the maintenance of an electrical bleed current through the fluorescent light controlled by that light switch so as to keep a minimal thermal differential between the unlit and lit light. The light switch cover plate has a series of imbedded LEDs that illuminate an area all around the light switch. The unit is retrofittable on conventional light switches.

摘要翻译： 本发明是一种低功率和低散热低照度系统，其基于电气箱盖板，优选地在光开关盖板中。 它允许通过由该光开关控制的荧光灯维持放电电流，以便在未点亮和点亮的光之间保持最小的热差。 灯开关盖板具有一系列嵌入式LED，用于照亮灯开关周围的区域。 该装置可以在传统的灯开关上进行改装。