Method and system for a self-healing query access plan
    41.
    发明授权
    Method and system for a self-healing query access plan 有权
    自愈式查询访问计划的方法和系统

    公开(公告)号:US08775412B2

    公开(公告)日:2014-07-08

    申请号:US10754010

    申请日:2004-01-08

    CPC classification number: G06F17/30595 G06F17/30474

    Abstract: A self-healing database engine and optimizer framework support automatically responding to execution errors to allow continued execution of a query plan. Upon encountering an execution error, the database engine automatically initiates a rebuilding of the query plan and executes the rebuilt execution plan. If an error is encountered in the rebuilt query plan then the query implementation methods are analyzed. If a query function is identified for which an alternative implementation method is available, then this alternative implementation method is substituted to create a new query plan. The new query plan is then executed to determine if the error is corrected.

    Abstract translation: 自修复数据库引擎和优化器框架支持自动响应执行错误,以允许继续执行查询计划。 遇到执行错误时,数据库引擎会自动启动重建查询计划并执行重建的执行计划。 如果在重建的查询计划中遇到错误,则会分析查询实现方法。 如果识别出可用的替代实现方法的查询功能,则替代该替代实现方法来创建新的查询计划。 然后执行新的查询计划以确定错误是否被更正。

    Method and system for pricing a programming event viewed by subscriber group
    44.
    发明授权
    Method and system for pricing a programming event viewed by subscriber group 失效
    用户组查看的编程事件的定价方法和系统

    公开(公告)号:US08015583B2

    公开(公告)日:2011-09-06

    申请号:US09749106

    申请日:2000-12-27

    Abstract: A method and apparatus for group billing purchasers of transmitted programming events is provided. In one embodiment, a subscriber group includes two or more individual subscribers who receive programming from a programming provider. The individual subscribers periodically elect to view a program provided via the program provider. The program is provided on a pay-per-view basis, meaning that the program provider requires a sum of money to be paid in order to view the program. The sum of money is determined according to the number of viewers in a single subscriber group. In one embodiment, the subscribers interact during a program via a network connection.

    Abstract translation: 提供了一种用于发送节目事件的组计费购买者的方法和装置。 在一个实施例中,订户组包括从节目提供者接收节目的两个或多个个体订户。 个别用户定期选择查看通过节目提供商提供的节目。 该计划是按照每次付费的方式提供的,这意味着节目提供商需要支付一笔钱才能查看节目。 货币总额根据单个用户组中的观众人数确定。 在一个实施例中,订户在节目期间经由网络连接进行交互。

    Method applying transitive closure to group by and order by clauses
    45.
    发明授权
    Method applying transitive closure to group by and order by clauses 有权
    应用传递闭包到组和按顺序的方法

    公开(公告)号:US07720840B2

    公开(公告)日:2010-05-18

    申请号:US10754011

    申请日:2004-01-08

    CPC classification number: G06F17/30454

    Abstract: A database engine and optimizer framework support the use of transitive closure to assist in rewriting GROUP BY and ORDER BY clauses to reduce the number of referenced tables (optimally to a single table if possible) and to free the join order selected for the query plan. The SQL parser and optimizer, by performing transitive closure on the selection, or search, conditions is able to identify which fields referenced by the ORDER BY and GROUP BY clauses can be replaced with equivalent fields to improve the performance of the query. In one instance, the fields are replaced so that the ORDER BY or GROUP BY clause references only a single table. If more than one such possible ORDER BY or GROUP BY clause exists, then the optimizer selects from among the different possible clauses to select the one that provides the best performing join order.

    Abstract translation: 数据库引擎和优化器框架支持使用传递闭包来帮助重写GROUP BY和ORDER BY子句以减少引用表的数量(如果可能的话,最优化为单个表),并释放为查询计划选择的连接顺序。 SQL解析器和优化器通过对选择或搜索条件执行传递闭包能够识别由ORDER BY和GROUP BY子句引用的字段可以替换为等效字段来提高查询的性能。 在一个实例中,字段被替换,以便ORDER BY或GROUP BY子句仅引用单个表。 如果存在多个此类可能的ORDER BY或GROUP BY子句,则优化器从不同的可能子句中选择以选择提供最佳性能的连接顺序的子句。

    Squeezable rebroadcast files
    46.
    发明授权
    Squeezable rebroadcast files 失效
    可压缩的转播文件

    公开(公告)号:US07707602B2

    公开(公告)日:2010-04-27

    申请号:US11101059

    申请日:2005-04-07

    Abstract: A method of providing rebroadcast programming includes encoding a rebroadcast program, specifying a preferred play time, and providing a broadcast that fits the preferred play time. The encoding of the rebroadcast program can use a replay plan which prioritizes portions of the rebroadcast. A priority can be assigned to commercials which have been made to be shortened or dropped, or an alternative commercial substituted, depending on time limitations. A rebroadcast packaging and playlist are provided. The specifying a preferred play time can be done by one of the following ways: specifying the preferred play time in response to a specific user request; specifying the preferred play time based on a user profile; specifying the preferred play time automatically by another program; connecting a replay timing to other events, wherein the other events includes setting an automatic pause when phone calls come in, lengthening a rebroadcast on certain days, and shortening a rebroadcast based on location of an automobile; providing a radio/television player which has functions of pause and replay which can be selected by the user to deduct time dynamically during the rebroadcast and which performs at least one of: replaying the broadcast; reacting to the need to pause/rewind; respecifying the adjusted time; playing unlistened to material at a later time; and displaying a list of unlistened/unviewed segments. A default play time for the rebroadcast program is used if no time is otherwise specified.

    Abstract translation: 提供转播节目的方法包括编码转播节目,指定优选播放时间,以及提供适合于优选播放时间的广播。 转播节目的编码可以使用重播计划,其优先重播部分转播。 可以根据时间限制将优先级分配给已被缩短或下降的商业广告或替代商业替代。 提供转播包装和播放列表。 指定优选播放时间可以通过以下方式之一来完成:响应于特定用户请求指定首选播放时间; 基于用户简档指定首选播放时间; 由另一个程序自动指定首选播放时间; 将重播时间连接到其他事件,其中所述其他事件包括当电话进入时设置自动暂停,在某些日子延长重播,并且基于汽车的位置缩短重播; 提供具有暂停和重放功能的无线电/电视播放器,用户可以在重播期间动态地扣除时间并且执行以下各项中的至少一个:播放广播; 对需要暂停/倒带作出反应; 重新调整调整时间; 在以后的时间播放未听的材料; 并显示未浏览/未审核段的列表。 如果没有指定时间,则使用转播程序的默认播放时间。

    Method and apparatus for query optimization and management of sleepy drives
    47.
    发明授权
    Method and apparatus for query optimization and management of sleepy drives 有权
    睡眠驱动器的查询优化和管理方法和装置

    公开(公告)号:US07653826B1

    公开(公告)日:2010-01-26

    申请号:US12356434

    申请日:2009-01-20

    Abstract: The invention, in an embodiment, relates to optimizing database performance by taking advantage of sleepy drives. The invention analyzes queries to indexes based on usage frequency, and determines whether to access an index stored on a sleepy drive, or perform an alternate access plan based on green optimization. Furthermore, the invention transfers data, such as, for example, indexes, files, data areas, journals, and statistics, between active and sleepy drives based on usage frequency. In another embodiment, the invention provides an improved sleepy drive which optimizes energy savings by a graduated degree based on a speed setting. In yet another embodiment, the invention controls when read-write heads are unloaded from disks to reduce drag and power consumption by a disk drive.

    Abstract translation: 在一个实施例中,本发明涉及通过利用睡眠驱动来优化数据库性能。 本发明基于使用频率分析对索引的查询,并且确定是否访问存储在睡眠驱动器上的索引,或者基于绿色优化来执行替代访问计划。 此外,本发明基于使用频率,在活动和睡眠驱动器之间传送数据,例如索引,文件,数据区域,期刊和统计信息。 在另一个实施例中,本发明提供一种改进的睡眠驱动器,其基于速度设置优化节能度量级。 在另一个实施例中,本发明控制读写头从盘上卸载以减少磁盘驱动器的阻力和功耗。

    Address watch breakpoints with basing pointers
    48.
    发明授权
    Address watch breakpoints with basing pointers 失效
    用基准指针查看断点

    公开(公告)号:US07526756B2

    公开(公告)日:2009-04-28

    申请号:US10955736

    申请日:2004-09-30

    CPC classification number: G06F11/3636

    Abstract: A method, apparatus, system, and signal-bearing medium that, in an embodiment, receive a request for an address watch breakpoint to a variable, determine that the variable is referenced via a basing pointer expression, and monitor for initialization of the basing pointer prior to monitor for a change to the contents of the variable that is pointed to by the basing pointer expression. In an embodiment, the basing pointer expression is implemented as an instruction that uses an indirect addressing mode. In an embodiment, the basing pointer is determined to be uninitialized, and thus needs monitoring for initialization, by detecting an error that results from adding an offset for the variable to the contents of the basing pointer, or by detecting an error when the result of the adding is used as a pointer. In an embodiment, the basing pointer expression comprises a plurality of basing pointers, each of which is monitored for initialization in turn. In this way, the user is freed from the difficulty involved in attempting to determine where and if the basing pointer is set prior to monitoring for a modification to a variable that is pointed to by the basing pointer.

    Abstract translation: 在一个实施例中,一种方法,装置,系统和信号承载介质,其接收对变量的地址监视断点的请求,确定通过基准指针表达式引用该变量,并监视基准指针的初始化 在监视基准指针表达式指向的变量的内容之前。 在一个实施例中,基准指针表达式被实现为使用间接寻址模式的指令。 在一个实施例中,基准指针被确定为未初始化,并且因此需要监视初始化,通过检测通过将变量的偏移添加到基准指针的内容而导致的错误,或者当检测到结果为 该添加用作指针。 在一个实施例中,基准指针表达式包括多个基准指针,依次监视每个基准指针以进行初始化。 以这种方式,在监视基准指针指向的变量的修改之前,用户可以摆脱尝试确定在哪里以及是否设置基准指针的困难。

    Canceling window close commands
    50.
    发明授权
    Canceling window close commands 失效
    取消窗口关闭命令

    公开(公告)号:US07464341B2

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

    申请号:US11171774

    申请日:2005-06-30

    CPC classification number: G06F9/451

    Abstract: A method, apparatus, system, and signal-bearing medium that, in an embodiment, receive a close command directed to a window, and determine whether the close command was received within a close threshold time of the display of the window. If the close command was received within the threshold time, in various embodiments, a close dialog is displayed, the window is faded, the window is shrunk, or a status message is displayed indicating that the window is closing. If a cancel command is received within a cancel-close threshold, the closing of the window is canceled. If the number of times the cancel command has been received for the window exceeds a cancel threshold, then in various embodiments, the close threshold is increased, magnification is recommended, a sound option is recommended, or speech recognition is recommended. In an embodiment, in response to a close command directed to a window, a determination is made whether the number of times the window has been resized is greater than a resize threshold. If the window has been resized greater than the resize threshold, in various embodiments, the cancel dialog is displayed, the window is faded, the window is shrunk, or a status message is displayed indicating that the window is closing. In another embodiment, if input to a window has been received within an input threshold time since the window was opened, then a confirmation message is displayed.

    Abstract translation: 一种方法,装置,系统和信号承载介质,其在一个实施例中接收到指向窗口的关闭命令,并且确定在窗口显示的接近阈值时间内是否接收到关闭命令。 如果在阈值时间内接收到关闭命令,则在各种实施例中,显示关闭对话,窗口褪色,窗口缩小,或显示表示窗口关闭的状态消息。 如果在取消 - 关闭阈值内接收到取消命令,则窗口的关闭被取消。 如果已经为窗口接收到取消命令的次数超过了取消阈值,则在各种实施例中,提高关闭阈值,建议放大,推荐声音选项,或者推荐语音识别。 在一个实施例中,响应于指向窗口的关闭命令,确定窗口被调整大小的次数是否大于调整大小阈值。 如果窗口被调整大于调整大小阈值,则在各种实施例中,显示取消对话框,窗口褪色,窗口缩小或显示状态消息,指示窗口正在关闭。 在另一个实施例中,如果从窗口打开以来在输入阈值时间内接收到窗口的输入,则显示确认消息。

Patent Agency Ranking