Provision of index recommendations for database access

    公开(公告)号:US09773032B2

    公开(公告)日:2017-09-26

    申请号:US13251190

    申请日:2011-09-30

    申请人: Michael L. Perry

    发明人: Michael L. Perry

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30306

    摘要: A cost estimator may estimate execution costs for execution of at least one query against a database, using at least one existing index, if any, and based on estimation criteria determined from analyzing the query execution. A candidate index provider may provide candidate indexes, based on the estimation criteria, and re-estimate the execution costs to obtain updated execution costs, using the candidate indexes. An index recommender may recommend a recommended index, based on the updated execution costs.

    Service desk data transfer interface

    公开(公告)号:US09710569B2

    公开(公告)日:2017-07-18

    申请号:US14467743

    申请日:2014-08-25

    摘要: A system and method for managing data transfer operations includes at least one data server including data stored in a plurality of data fields, at least one transaction server operatively coupled to the at least one data server and configured to provide at least one customizable business rule and a customer relationship application, an information server operatively coupled to the at least one transaction server, and at least one workstation operatively coupled to the information server. The least one workstation includes local memory accessible to the customer relationship application and configured to provide web communication and presentation services to a user of the at least one workstation that are deployed on the information server. The at least one customizable business rule specifies a mapping between the plurality of data fields and the local memory, the mapping having been provided by the user interacting with the web communication and presentation services.

    Automated service time estimation method for IT system resources
    25.
    发明授权
    Automated service time estimation method for IT system resources 有权
    IT系统资源的自动服务时间估计方法

    公开(公告)号:US09350627B2

    公开(公告)日:2016-05-24

    申请号:US13650767

    申请日:2012-10-12

    摘要: Embodiments provide a method for upgrading resources in a system including normalizing a collected dataset, scattering data from the normalized dataset, obtaining a plurality of clusters based on the scattered data, discarding one or more clusters from the plurality of clusters with less than a percentage of a total number of observations, in each cluster, performing clusterwise regression and obtaining linear sub-clusters in a defined number, reducing one or more sub-clusters including applying a refinement procedure, removing one or more sub-clusters that fit to outliers and merging pairs of clusters that fit an equivalent model, updating one or more clusters with the reduced sub-clusters, removing one or more globular clusters, reducing a number of clusters with the refinement procedure, and de-normalizing one or more results.

    摘要翻译: 实施例提供了一种用于升级系统中的资源的方法,包括归一化收集的数据集,从归一化数据集散射数据,基于分散数据获得多个聚类,从多个聚类中丢弃一个或多个聚类, 在每个集群中,总共观察数量执行聚类回归并且以定义的数量获得线性子集群,减少一个或多个子集群,包括应用细化过程,去除适合异常值并合并的一个或多个子集群 适合等效模型的群集对,用减少的子群集更新一个或多个群集,去除一个或多个球状群集,通过细化过程减少群集数量,以及对一个或多个结果进行归一化。

    Statistical identification of instances during reconciliation process
    26.
    发明授权
    Statistical identification of instances during reconciliation process 有权
    和解过程中实例的统计鉴定

    公开(公告)号:US09323801B2

    公开(公告)日:2016-04-26

    申请号:US14204437

    申请日:2014-03-11

    IPC分类号: G06F17/30 G06F7/00 G06F17/00

    摘要: A system for reconciling object for a configuration management databases employs statistical rules to reduce the amount of manual identification required by conventional reconciliation techniques. As users manually identify matches between source and target datasets, statistical rules are developed based on the criteria used for matching. Those statistical rules are then used for future matching. A threshold value is adjusted as the statistical rules are used, incrementing the threshold value when the rule successfully matches source and target objects. If the threshold value exceeds a predetermined acceptance value, the system may automatically accept a match made by a statistical rule. Otherwise, suggestions of possibly applicable rules may be presented to a user, who may use the suggested rules to match objects, causing adjustment of the threshold value associated with the suggested rules used.

    摘要翻译: 用于协调配置管理数据库的对象的系统采用统计规则来减少常规对帐技术所需的手动识别量。 当用户手动识别源数据集和目标数据集之间的匹配时,将根据用于匹配的标准来开发统计规则。 然后将这些统计规则用于将来的匹配。 当使用统计规则时调整阈值,当规则成功匹配源对象和目标对象时,增加阈值。 如果阈值超过预定的接受值,则系统可以自动接受由统计规则进行的匹配。 否则,可能将可能适用的规则的建议呈现给用户,用户可以使用建议的规则来匹配对象,导致与所使用的建议规则相关联的阈值的调整。

    Data set size tracking and management
    27.
    发明授权
    Data set size tracking and management 有权
    数据集大小跟踪和管理

    公开(公告)号:US09251149B2

    公开(公告)日:2016-02-02

    申请号:US12485632

    申请日:2009-06-16

    CPC分类号: G06F17/30067

    摘要: Specified data sets may be tracked from creation to end-of-life (e.g., deletion). Between creation and end-of-life, data set storage changes may be recorded (i.e., when additional storage is allocated or when some storage is released). During a subsequent allocation cycle, this information may be used in conjunction with user-specified allocation rules to manage or control the data set's initial allocation.

    摘要翻译: 指定的数据集可以从创建到生命周期跟踪(例如,删除)。 在创建和报废之间,可能会记录数据集存储变化(即分配额外的存储空间或当某些存储被释放时)。 在随后的分配周期期间,该信息可以与用户指定的分配规则一起使用以管理或控制数据集的初始分配。

    Server management with dynamic construction of pre-boot images
    28.
    发明授权
    Server management with dynamic construction of pre-boot images 有权
    服务器管理与动态构建预启动映像

    公开(公告)号:US09250918B2

    公开(公告)日:2016-02-02

    申请号:US13174668

    申请日:2011-06-30

    申请人: Samir Bayani

    发明人: Samir Bayani

    IPC分类号: G06F9/44 G06F15/177

    摘要: A request handler may receive an image capture request for an operating system (OS) executing on a server. A pre-boot image handler may generate a pre-boot image, based on the image capture request and on the executing operating system. An image handler may capture an image of the operating system, based on the pre-boot image.

    摘要翻译: 请求处理程序可以接收在服务器上执行的操作系统(OS)的图像捕获请求。 预引导映像处理程序可以基于图像捕获请求和执行的操作系统生成预引导映像。 图像处理程序可以基于预启动映像捕获操作系统的映像。

    Method to automatically redirect SRB routines to a zIIP eligible enclave
    29.
    发明授权
    Method to automatically redirect SRB routines to a zIIP eligible enclave 有权
    将SRB例程自动重定向到zIIP符合条件的飞地的方法

    公开(公告)号:US09158572B1

    公开(公告)日:2015-10-13

    申请号:US13612187

    申请日:2012-09-12

    申请人: Michel Laviolette

    发明人: Michel Laviolette

    IPC分类号: G06F9/46 G06F9/50

    摘要: A method to redirect SRB routines from otherwise non-zIIP eligible processes on an IBM z/OS series mainframe to a zIIP eligible enclave is disclosed. This redirection is achieved by intercepting otherwise blocked operations and allowing them to complete processing without errors imposed by the zIIP processor configuration. After appropriately intercepting and redirecting these blocked operations more processing may be performed on the more financially cost effective zIIP processor by users of mainframe computing environments.

    摘要翻译: 披露了将IBM z / OS系列主机上的其他非zIIP合格进程的SRB例程重定向到zIIP符合条件的飞地的方法。 这种重定向是通过拦截否则阻止的操作实现的,并允许它们完成处理,而不会由zIIP处理器配置施加错误。 在适当拦截和重定向这些被阻止的操作之后,可以在大型机计算环境的用户对更经济有效的zIIP处理器执行更多的处理。

    Automating application provisioning for heterogeneous datacenter environments
    30.
    发明授权
    Automating application provisioning for heterogeneous datacenter environments 有权
    自动化异构数据中心环境的应用程序配置

    公开(公告)号:US09122536B2

    公开(公告)日:2015-09-01

    申请号:US12872921

    申请日:2010-08-31

    IPC分类号: G06F15/173 G06F9/50

    摘要: Disclosed are methods and systems to automate the provisioning and deployment of application instances within a heterogeneous data center. In one embodiment, the application provisioning is performed based upon a blueprint and deployment model defining requirements of the provisioned application. In another embodiment, the totality of available resources for provisioning is divided into different segments. When resources are requested and assigned to an incoming provisioning request, the resource pool may be refreshed or augmented as defined by thresholds or forecasting of user needs. The resource pool may be refreshed by recapturing allocated resources that are no longer in use or by configuring resources taken from the reserve. Further, when reserve resources are not available or are below a minimum reserve threshold, capacity planning actions may be initiated or advised.

    摘要翻译: 公开了在异构数据中心内自动化应用实例的配置和部署的方法和系统。 在一个实施例中,基于定义所提供应用的要求的蓝图和部署模型来执行应用供应。 在另一个实施例中,用于供应的可用资源的总和被分成不同的段。 当资源被请求并分配给传入的供应请求时,可以根据用户需求的阈值或预测定义来刷新或增加资源池。 可以通过重新捕获不再使用的分配的资源或者通过配置从备用资源获取的资源来刷新资源池。 此外,当储备资源不可用或低于最低储备金额时,可以开始或建议能力规划行动。