Intelligent open query cursor management
    1.
    发明授权
    Intelligent open query cursor management 有权
    智能打开查询光标管理

    公开(公告)号:US08768904B2

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

    申请号:US11622532

    申请日:2007-01-12

    CPC分类号: G06F17/30442

    摘要: An enhanced mechanism for intelligently managing an open query cursor built from a query access plan (AP) by a query optimizer of a database management system (DBMS). In an embodiment, a cursor management system (CMS) detects whether an open query cursor was previously requested for use within another job. If the open query cursor was previously requested, the CMS intelligently manages the query cursor for subsequent use within a different job. For example, the open query cursor may be recycled for subsequent use within the different job. Hence, system resources are not wasted in building and destroying the same cursors for multiple jobs. Alternatively, the query cursor may be pre-built before the cursor is requested for subsequent use within the different job. The CMS may also obtain, release and re-obtain locks for cursors being managed. Alternatively, the job that uses the cursor may obtain the lock.

    摘要翻译: 一种增强的机制,用于智能地管理由数据库管理系统(DBMS)的查询优化器从查询访问计划(AP)构建的打开查询游标。 在一个实施例中,光标管理系统(CMS)检测先前是否请求在另一个作业中使用的打开查询光标。 如果先前请求了打开的查询光标,CMS将智能地管理查询光标,以便后续在不同的作业中使用。 例如,打开的查询光标可以被再循环以用于不同作业中的后续使用。 因此,系统资源不会浪费在构建和销毁多个作业的相同光标上。 或者,可以在请求光标以在后续使用不同作业之前预建查询光标。 CMS还可以获取,释放和重新获取正在管理的游标的锁。 或者,使用光标的作业可以获得锁定。

    Database query optimization using index carryover to subset an index
    2.
    发明授权
    Database query optimization using index carryover to subset an index 有权
    数据库查询优化使用索引携带来子集索引

    公开(公告)号:US08412700B2

    公开(公告)日:2013-04-02

    申请号:US12013036

    申请日:2008-01-11

    IPC分类号: G06F15/16 G06F17/20

    CPC分类号: G06F17/30442

    摘要: A method, apparatus and program product use a first index associated with a field in a database table to identify a range of records in the database table that includes instances of a first key value in the field and use the identified range of records to subset a second index associated with another field in a database table. The database query identifies the first key value for the field in the database table and the second key value for the other field in the database table. By doing so, information from an index may be carried over and applied to another index to subset the other index, often reducing the quantity of entries that are searched in the other index and improving performance.

    摘要翻译: 方法,装置和程序产品使用与数据库表中的字段相关联的第一索引来标识数据库表中的记录范围,其包括该字段中的第一键值的实例,并使用所识别的记录范围来子集 与数据库表中另一个字段关联的第二个索引。 数据库查询标识数据库表中字段的第一个键值,数据库表中另一个字段的第二个键值。 通过这样做,来自索引的信息可以被转移并应用于另一个索引以对另一个索引进行子集,通常减少在另一个索引中搜索的条目的数量并提高性能。

    Automated detection of spoken numbers in voice messages
    3.
    发明授权
    Automated detection of spoken numbers in voice messages 有权
    在语音留言中自动检测语音号码

    公开(公告)号:US08265934B2

    公开(公告)日:2012-09-11

    申请号:US12099392

    申请日:2008-04-08

    IPC分类号: G10L15/00

    CPC分类号: G10L15/26

    摘要: An apparatus and program product utilize voice recognition to process voice messages in an automated manner to detect spoken numbers contained therein. Detected spoken numbers can then be utilized to set a start position at which to begin playback of a voice message, e.g., to permit a user to locate and transcribe a telephone number spoken by a message sender. Automated number detection may also be utilized to automatically dial telephone numbers mentioned in a voice message, as well as in the display of textual representations of such numbers to a user.

    摘要翻译: 一种装置和程序产品利用语音识别以自动方式处理语音消息以检测其中包含的口语数字。 然后可以使用检测到的语音号码来设置开始播放语音消息的起始位置,例如允许用户定位和转录由消息发送者说出的电话号码。 也可以使用自动号码检测来自动拨打语音消息中提及的电话号码,以及向用户显示这些号码的文本表示。

    INTELLIGENT PRE-STARTED JOB AFFINITY FOR NON-UNIFORM MEMORY ACCESS COMPUTER SYSTEM
    4.
    发明申请
    INTELLIGENT PRE-STARTED JOB AFFINITY FOR NON-UNIFORM MEMORY ACCESS COMPUTER SYSTEM 有权
    针对非统一存储器访问计算机系统的智能预定工作

    公开(公告)号:US20120174108A1

    公开(公告)日:2012-07-05

    申请号:US13421141

    申请日:2012-03-15

    IPC分类号: G06F9/46

    CPC分类号: G06F9/5033

    摘要: A method, apparatus, and program product select a pre-started job from among a plurality of pre-started jobs in which to perform a task in a computer system with a NUMA configuration. An attempt to perform a task is received as a connection. Information associated with the connection is compared to information associated with a plurality of pre-started jobs. In response to comparing the information, it is determined either that a pre-started job was previously used to perform the task or that no pre-started job was previously used to perform the task. In response to either determination, another pre-started job is determined in which to perform the task. The other pre-started job is determined based on affinity with the task, and may be reallocated to perform the task.

    摘要翻译: 一种方法,装置和程序产品从其中在具有NUMA配置的计算机系统中执行任务的多个预先启动的作业中选择预先启动的作业。 作为连接接收到执行任务的尝试。 与连接相关联的信息与与多个预启动作业相关联的信息进行比较。 响应于比较信息,确定先前启动的作业以前用于执行任务或者没有预先启动的作业以前用于执行任务。 响应于任一确定,确定执行任务的另一预先启动的作业。 另一个预先启动的作业是根据与任务的亲和性确定的,并且可以被重新分配以执行该任务。

    Method for autonomically generating a query implementation that meets a defined performance specification
    5.
    发明授权
    Method for autonomically generating a query implementation that meets a defined performance specification 失效
    用于自动生成满足定义的性能规范的查询实现的方法

    公开(公告)号:US08161037B2

    公开(公告)日:2012-04-17

    申请号:US10860402

    申请日:2004-06-03

    IPC分类号: G06F17/20 G06F15/16

    CPC分类号: G06F17/30433 G06F17/30463

    摘要: A database query optimizer allows specifying a performance specification for a query. When an access plan is created, the actual performance for executing the query using the access plan is determined and compared to the performance specification for the query. If the actual performance does not satisfy the performance specification for the query, the query optimizer autonomically generates a different access plan to see if the performance improves. If an access plan that meets the performance specification is generated, the new access plan is stored in the access plan cache for the query. If no access plan can be generated that meets the performance specification for the query, the access plan that provided the best performance is selected and stored in the access plan cache for the query.

    摘要翻译: 数据库查询优化器允许为查询指定性能规范。 当创建访问计划时,确定使用访问计划执行查询的实际性能,并将其与查询的性能规范进行比较。 如果实际性能不符合查询的性能规范,则查询优化器将自动生成不同的访问计划,以查看性能是否提高。 如果生成符合性能规范的访问计划,则新访问计划将存储在查询的访问计划缓存中。 如果不能生成满足查询性能规范的访问计划,则提供最佳性能的访问计划被选择并存储在查询的访问计划缓存中。

    System for on demand task optimization
    6.
    发明授权
    System for on demand task optimization 有权
    系统用于按需任务优化

    公开(公告)号:US08055941B2

    公开(公告)日:2011-11-08

    申请号:US12358725

    申请日:2009-01-23

    IPC分类号: G06F11/00

    CPC分类号: G06F11/3409 G06F11/3442

    摘要: An apparatus and program product determine information indicative of a performance differential between operation of a computer with the standby resource activated and operation of the computer with the standby resource inactivated. The information is communicated to a user. The standby resource may be activated in response to the determination.

    摘要翻译: 设备和程序产品确定指示计算机的操作与激活的备用资源的操作之间的性能差异的信息以及停用了备用资源的计算机的操作。 该信息被传送给用户。 备用资源可以响应于该确定被激活。

    Method and meeting scheduler for automated meeting scheduling using delegates, representatives, quorums and teams
    7.
    发明授权
    Method and meeting scheduler for automated meeting scheduling using delegates, representatives, quorums and teams 失效
    使用代表,代表,法定人数和团队自动会议安排的方法和会议日程安排

    公开(公告)号:US07925529B2

    公开(公告)日:2011-04-12

    申请号:US11874228

    申请日:2007-10-18

    IPC分类号: G06Q10/00

    摘要: A method, meeting scheduler and computer program product are provided for automated meeting scheduling using delegates, representatives, quorums, and teams. Meeting settings and invitees data are stored for a meeting. The meeting settings and invitees data includes invitee attendance type, delegates, representatives, quorums, and teams data. A solution time block for automated meeting scheduling including at least a subset of a plurality of selected invitees is identified utilizing the invitee attendance type, delegates, representatives, quorums, and teams data. A selection score is calculated for each potential time block for automated meeting scheduling utilizing the stored meeting settings and invitees data including the invitee attendance type, delegates, representatives, quorums, and teams data. The solution time block for automated meeting scheduling including a subset of a plurality of selected invitees is identified utilizing the calculated selection score.

    摘要翻译: 提供了一种方法,会议调度程序和计算机程序产品,用于使用代表,代表,法定人数和团队进行自动会议安排。 存储会议设置和被邀请者的数据。 会议设置和受邀者数据包括受邀人员出席类型,代表,代表,法定人数和团队数据。 使用被邀请者出席类型,代表,代表,仲裁和团队数据来识别包括多个被选择的受邀者的至少一个子集的自动会议安排的解决时间块。 使用存储的会议设置来计算用于自动会议安排的每个潜在时间块的选择分数,并且邀请包括被邀请人出席类型,代表,代表,仲裁和团队数据的数据。 使用所计算的选择分数来识别包括多个所选被邀请者的子集的自动会议调度的解决时间块。

    Web server apparatus and method for virus checking
    8.
    发明授权
    Web server apparatus and method for virus checking 有权
    用于病毒检查的Web服务器装置和方法

    公开(公告)号:US07895340B2

    公开(公告)日:2011-02-22

    申请号:US11619190

    申请日:2007-01-03

    IPC分类号: G06F15/16 G06F11/30 G06F12/14

    摘要: A web server computer system includes a virus checker and mechanisms for checking e-mails and their attachments, downloaded files, and web sites for possible viruses. The virus checker allows a web server to perform virus checking of different types of information real-time as the information is requested by a web client. In addition, a web client may also request that the server perform virus checking on a particular drive on the web client. If this case, the web server may receive information from the web client drive, scan the information for viruses, and inform the web client whether any viruses were found. In the alternative, the web server may download a client virus checker to the web client and cause the client virus checker to be run on the web client. The preferred embodiments thus eliminate the need for virus checking software to be installed on each web client.

    摘要翻译: Web服务器计算机系统包括病毒检查器和用于检查电子邮件及其附件,下载的文件和可能的病毒的网站的机制。 病毒检查器允许Web服务器根据Web客户端请求的信息实时执行不同类型信息的病毒检查。 另外,web客户端还可以请求服务器对web客户端上的特定驱动器执行病毒检查。 如果是这种情况,Web服务器可能会从Web客户端驱动器接收信息,扫描病毒信息,并通知Web客户端是否发现任何病毒。 或者,Web服务器可以将客户端病毒检查器下载到web客户端,并使客户端病毒检查器在web客户端上运行。 因此,优选实施例免除了要安装在每个web客户端上的病毒检查软件的需要。

    Background index bimapping for faster query performance
    9.
    发明授权
    Background index bimapping for faster query performance 有权
    背景索引双击以更快的查询性能

    公开(公告)号:US07890495B2

    公开(公告)日:2011-02-15

    申请号:US12027067

    申请日:2008-02-06

    IPC分类号: G06F7/00 G06F17/30

    摘要: A database engine and a system running a database engine utilize a dynamic bitmap updating routine to avoid the delay associated with building an entire bitmap. When running a query on a table, the database engine can build a bitmap over a column of the table that helps avoid unnecessary I/O operations to retrieve records. The database engine initializes the bitmap so that all elements have a value of “1”, or active, and proceeds to scan and retrieve the records of the table according to the bitmap using a first process. Any retrieved record is further analyzed to determine if it is part of the result set. Concurrently, a second process is initiated which continually updates the values within the bitmap according to a set of selection criteria. As the first process continues to operate, more and more elements of the bitmap are set to “0”, or inactive, so that the first process can avoid unnecessary I/O operations.

    摘要翻译: 数据库引擎和运行数据库引擎的系统利用动态位图更新例程来避免与构建整个位图相关的延迟。 在表上运行查询时,数据库引擎可以在表的列上构建位图,以帮助避免不必要的I / O操作来检索记录。 数据库引擎初始化位图,使所有元素的值为“1”或活动,然后继续使用第一个进程根据位图扫描和检索表的记录。 进一步分析任何检索的记录,以确定它是否是结果集的一部分。 同时,启动第二过程,其根据一组选择标准不断更新位图内的值。 当第一个进程继续运行时,位图的越来越多的元素被设置为“0”或不活动,以便第一个进程可以避免不必要的I / O操作。

    Automated spell analysis
    10.
    发明授权
    Automated spell analysis 有权
    自动拼写分析

    公开(公告)号:US07669112B2

    公开(公告)日:2010-02-23

    申请号:US11828890

    申请日:2007-07-26

    IPC分类号: G06F17/00

    摘要: An apparatus, program product and method utilize automated analysis techniques to assist in the determination of acceptable usages of linguistic terms (e.g., words, phrases, acronyms, etc.). In particular, an acceptable usage of a linguistic term in a document on the Internet may be determined by detecting a spell definition tag in the document. In response to detecting the spell definition tag, automatically adding the acceptable variant of the linguistic term to an electronic dictionary.

    摘要翻译: 一种装置,程序产品和方法利用自动分析技术来帮助确定语言术语(例如,单词,短语,缩写等)的可接受的用途。 特别地,可以通过检测文档中的拼写定义标签来确定互联网上的文档中的语言术语的可接受的使用。 响应于检测到拼写定义标签,自动将语言术语的可接受变体添加到电子词典中。