Dynamically Selecting Alternative Query Access Plans
    3.
    发明申请
    Dynamically Selecting Alternative Query Access Plans 失效
    动态选择替代查询访问计划

    公开(公告)号:US20070282794A1

    公开(公告)日:2007-12-06

    申请号:US11839926

    申请日:2007-08-16

    IPC分类号: G06F7/00

    摘要: A query access plan for executing a database query is dynamically selected from among multiple alternative query access plans based on the availability of computer resources allocated for running the query. Preferably, a first query access plan is generated based on resources then available, and if it is possible to provide additional resources, one or more alternative plans are generated based on the additional resources. If an alternative plan is significantly better than the original plan based on a comparison of query related parameters, the alternative is chosen for executing the query. Additional resources for running the query may be provided from logically partitioned and/or grid environments.

    摘要翻译: 基于分配用于运行查询的计算机资源的可用性,从多个备选查询访问计划中动态地选择用于执行数据库查询的查询访问计划。 优选地,基于随后可用的资源来生成第一查询访问计划,并且如果可以提供附加资源,则基于附加资源生成一个或多个备选计划。 如果基于查询相关参数的比较,替代计划明显优于原始计划,则选择替代方案来执行查询。 可以从逻辑分区和/或网格环境提供用于运行查询的其他资源。

    Apparatus and method for inhibiting non-critical access based on measured performance in a database system
    5.
    发明申请
    Apparatus and method for inhibiting non-critical access based on measured performance in a database system 有权
    基于数据库系统中的测量性能来抑制非关键访问的装置和方法

    公开(公告)号:US20060064426A1

    公开(公告)日:2006-03-23

    申请号:US10948774

    申请日:2004-09-23

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30365

    摘要: A database system has a contention monitor which determines when the level of contention for accessing or inserting records in the database rises above a threshold, and inhibits non-critical access to the database to reduce the level of contention. In a preferred embodiment, the level of contention is determined by periodically measuring the time for an INSERT operation on the database, and comparing the time to a threshold derived from a baseline time measurement for the operation during a time of normal database activity. Thus the contention level is inferred from the time to do the operation, in this case the INSERT query. In one embodiment, the contention monitor notifies a system administrator to take action to reduce the contention. In another embodiment, the contention monitor informs the system to take action automatically according to predetermined selections by the system administrator.

    摘要翻译: 数据库系统具有竞争监视器,其确定何时访问或插入数据库中的记录的竞争级别高于阈值,并且禁止对数据库的非关键访问以降低竞争级别。 在优选实施例中,通过周期性地测量数据库上的INSERT操作的时间,并将时间与从正常数据库活动期间的操作的基线时间测量得出的阈值进行比较来确定争用级别。 因此,从执行操作的时间推断争用级别,在这种情况下是INSERT查询。 在一个实施例中,争用监视器通知系统管理员采取行动以减少争用。 在另一个实施例中,争用监控器通知系统根据系统管理员的预定选择自动采取行动。

    Apparatus and method for initializing diagnostic functions when specified run-time error criteria are satisfied
    6.
    发明申请
    Apparatus and method for initializing diagnostic functions when specified run-time error criteria are satisfied 有权
    指定运行时错误标准时,初始化诊断功能的装置和方法

    公开(公告)号:US20060048013A1

    公开(公告)日:2006-03-02

    申请号:US10932731

    申请日:2004-09-02

    IPC分类号: G06F11/00

    CPC分类号: G06F11/366

    摘要: A run-time monitor allows defining sets of run-time error criteria and corresponding diagnostic action to take when the run-time error criteria is satisfied. One way to define the run-time error criteria is to take a baseline measurement of run-time errors that occur during normal processing conditions. A run-time error criteria may then be defined that is based on the baseline measurement. In this manner, a rate of run-time errors that normally occur may be ignored, while a rate of run-time errors in excess of the run-time error criteria could automatically initiate diagnostic action. In this manner, the ability of a programmer to debug run-time errors is significantly enhanced.

    摘要翻译: 运行时监视器允许在满足运行时错误标准时定义运行时错误标准集和相应的诊断动作。 定义运行时错误标准的一种方法是对在正常处理条件下发生的运行时错误进行基线测量。 然后可以基于基线测量定义运行时错误标准。 以这种方式,通常发生的运行时错误率可能被忽略,而运行时错误超出运行时错误标准的速率可以自动启动诊断动作。 以这种方式,程序员调试运行时错误的能力显着增强。

    Apparatus and method for autonomically adjusting configuration parameters for a server when a different server fails
    7.
    发明申请
    Apparatus and method for autonomically adjusting configuration parameters for a server when a different server fails 有权
    当不同的服务器发生故障时,用于自动调整服务器的配置参数的设备和方法

    公开(公告)号:US20060294207A1

    公开(公告)日:2006-12-28

    申请号:US11149490

    申请日:2005-06-09

    IPC分类号: G06F15/177

    摘要: A load balancer detects a server failure, and sends a failure notification message to the remaining servers. In response, one or more of the remaining servers may autonomically adjust their configuration parameters, thereby allowing the remaining servers to better handle the increased load caused by the server failure. One or more of the servers may also include a performance measurement mechanism that measures performance before and after an autonomic adjustment of the configuration parameters to determine whether and how much the autonomic adjustments improved the system performance. In this manner server computer systems may autonomically compensate for the failure of another server computer system that was sharing the workload.

    摘要翻译: 负载平衡器检测到服务器故障,并向其余的服务器发送故障通知消息。 作为响应,一个或多个剩余服务器可以自主地调整其配置参数,从而允许其余服务器更好地处理由服务器故障引起的增加的负载。 一个或多个服务器还可以包括性能测量机制,其在配置参数的自主调整之前和之后测量性能,以确定自主调整是否以及多少改善系统性能。 以这种方式,服务器计算机系统可以自主地补偿共享工作负载的另一服务器计算机系统的故障。

    Apparatus and method to advertise to the consumer based off a digital image
    8.
    发明申请
    Apparatus and method to advertise to the consumer based off a digital image 审中-公开
    基于数字图像向消费者做广告的装置和方法

    公开(公告)号:US20050018216A1

    公开(公告)日:2005-01-27

    申请号:US10624852

    申请日:2003-07-22

    IPC分类号: G06F15/00 G06Q30/00

    CPC分类号: G06Q30/02

    摘要: The present invention provides an apparatus, method and program product for analyzing a digital image for consumer identifying characteristics, and generating advertisements specifically to the consumer based on the identifying characteristics of the digital image. The analysis of the digital image may involve object recognition, text recognition and/or metadata analysis of a selected digital image. The present invention may be implemented, for example, within a photo kiosk or digital minilab. The generated advertisements may utilize a variety of media, including on-screen displays on the photo kiosk, a customized coupon, or a photo jacket insert.

    摘要翻译: 本发明提供了一种用于分析用于消费者识别特征的数字图像的装置,方法和程序产品,并且基于数字图像的识别特性,专门针对消费者生成广告。 数字图像的分析可以涉及所选数字图像的对象识别,文本识别和/或元数据分析。 本发明可以例如在照相亭或数字小型存储箱内实现。 生成的广告可以利用各种媒体,包括在照相亭上的屏幕显示,定制的优惠券或照片外套插入物。

    DATABASE BREAKPOINT APPARATUS AND METHOD
    9.
    发明申请
    DATABASE BREAKPOINT APPARATUS AND METHOD 失效
    数据库断点设备和方法

    公开(公告)号:US20080098363A1

    公开(公告)日:2008-04-24

    申请号:US11957426

    申请日:2007-12-15

    IPC分类号: G06F9/44

    摘要: An apparatus and method define the concept of a “database breakpoint.” One or more conditions in the database are specified as a database breakpoint in a debug environment for debugging a computer program that accesses the database. When the database conditions exist, one or more debug functions may be performed with respect to the execution of the computer program. Examples of debug functions include halting execution of the computer program and halting operations to the database by other programs. With both the computer program and database halted, the user may then interrogate the database to determine its state, and may interrogate the program to determine its state. Database breakpoints greatly enhance the utility of a debugger by providing additional conditions for debugging a computer program that accesses a database.

    摘要翻译: 一种设备和方法定义了“数据库断点”的概念。 数据库中的一个或多个条件在调试环境中指定为数据库断点,用于调试访问数据库的计算机程序。 当存在数据库条件时,可以针对计算机程序的执行执行一个或多个调试功能。 调试功能的示例包括停止计算机程序的执行和其他程序停止对数据库的操作。 随着计算机程序和数据库都停止,用户然后可以询问数据库以确定其状态,并且可以询问程序以确定其状态。 数据库断点通过提供调试访问数据库的计算机程序的附加条件,大大提高了调试器的效用。