Distributed database system providing data and space management methodology
    13.
    发明授权
    Distributed database system providing data and space management methodology 有权
    分布式数据库系统提供数据和空间管理方法

    公开(公告)号:US09152666B2

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

    申请号:US12055194

    申请日:2008-03-25

    IPC分类号: G06F17/30

    摘要: A distributed database system providing data and space management methodology. In one embodiment a system for allocating resources amongst a plurality of database servers sharing resources comprises: an input module for receiving user input for allocating resources shared amongst a plurality of database servers and establishing thresholds for utilization of resources at each database server; a monitoring module at each database server for monitoring local resource utilization at each database server and sending a request for balancing resources to a second database server when local resource utilization reaches an established threshold at a first database server; and a load balancing module for receiving the request for balancing resources and determining whether to adjust resources allocated to the first database server and the second database server in response to the request.

    摘要翻译: 提供数据和空间管理方法的分布式数据库系统。 在一个实施例中,用于在共享资源的多个数据库服务器之间分配资源的系统包括:输入模块,用于接收用于分配在多个数据库服务器之间共享的资源的用户输入,并为每个数据库服务器处的资源建立阈值; 每个数据库服务器处的监视模块,用于在本地资源利用率达到第一数据库服务器上建立的阈值时监视每个数据库服务器的本地资源利用率,并发送平衡资源到第二数据库服务器的请求; 以及负载平衡模块,用于接收所述用于平衡资源的请求,并且响应于所述请求确定是否调整分配给所述第一数据库服务器和所述第二数据库服务器的资源。

    Output system and method for restoring location arrangement of output devices
    15.
    发明授权
    Output system and method for restoring location arrangement of output devices 有权
    用于恢复输出设备位置布置的输出系统和方法

    公开(公告)号:US08504735B2

    公开(公告)日:2013-08-06

    申请号:US13495217

    申请日:2012-06-13

    IPC分类号: G06F3/00

    摘要: A docking device for restoring location arrangement of output devices is provided according to an aspect of the present invention. The docking device includes a transmission module configured to obtain output information from an information generation module and transmit it to an output device and an identifier storage module configured to store an identifier corresponding to the output device. An output system and method for restoring a location arrangement of output devices are also provided.

    摘要翻译: 根据本发明的一个方面,提供一种用于恢复输出装置的位置布置的对接装置。 对接装置包括:传输模块,被配置为从信息生成模块获取输出信息,并将其发送到输出设备;以及标识符存储模块,被配置为存储对应于输出设备的标识符。 还提供了用于恢复输出设备的位置布置的输出系统和方法。

    Optimizing lock acquisition on transaction logs
    16.
    发明授权
    Optimizing lock acquisition on transaction logs 有权
    优化事务日志上的锁获取

    公开(公告)号:US07899794B2

    公开(公告)日:2011-03-01

    申请号:US12052417

    申请日:2008-03-20

    IPC分类号: G06F17/00

    摘要: A system, method, and computer program product for improving physical lock acquisition for database transaction logs are described herein. In an embodiment, the method operates by receiving a request for a transaction log page and determining whether a requested log page is newly-allocated or already exists. A determination is made regarding whether the last log page is being modified. A physical lock is taken on the requested log page when it has been determined that the requested log page is not newly-allocated and that the last log page is not being modified. Operations on the last log page are synchronized without a physical lock when it is determined that the requested log page is newly-allocated or that the last log page is being modified.

    摘要翻译: 本文描述了用于改进数据库事务日志的物理锁获取的系统,方法和计算机程序产品。 在一个实施例中,该方法通过接收对事务日志页面的请求并确定所请求的日志页面是新被分配还是已经存在来操作。 确定最后一个日志页面是否被修改。 当确定所请求的日志页面不被新分配并且最后一个日志页面未被修改时,将在所请求的日志页面上执行物理锁定。 当确定所请求的日志页面被新分配或者最后一个日志页面被修改时,上一个日志页面上的操作被同步而没有物理锁定。

    OUTPUT SYSTEM AND METHOD FOR RESTORING LOCATION ARRANGEMENT OF OUTPUT DEVICES
    17.
    发明申请
    OUTPUT SYSTEM AND METHOD FOR RESTORING LOCATION ARRANGEMENT OF OUTPUT DEVICES 审中-公开
    用于恢复输出设备的位置布置的输出系统和方法

    公开(公告)号:US20100174832A1

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

    申请号:US12648468

    申请日:2009-12-29

    IPC分类号: G06F13/00 G06F3/00

    摘要: A docking device for restoring location arrangement of output devices is provided according to an aspect of the present invention. The docking device includes a transmission module configured to obtain output information from an information generation module and transmit it to an output device and an identifier storage module configured to store an identifier corresponding to the output device. An output system and method for restoring a location arrangement of output devices are also provided.

    摘要翻译: 根据本发明的一个方面,提供一种用于恢复输出装置的位置布置的对接装置。 对接装置包括:传输模块,被配置为从信息生成模块获取输出信息,并将其发送到输出设备;以及标识符存储模块,被配置为存储对应于输出设备的标识符。 还提供了用于恢复输出设备的位置布置的输出系统和方法。

    Optimizing Lock Acquisition on Transaction Logs
    18.
    发明申请
    Optimizing Lock Acquisition on Transaction Logs 有权
    优化事务日志中的锁获取

    公开(公告)号:US20090240739A1

    公开(公告)日:2009-09-24

    申请号:US12052417

    申请日:2008-03-20

    IPC分类号: G06F17/30

    摘要: A system, method, and computer program product for improving physical lock acquisition for database transaction logs are described herein. In an embodiment, the method operates by receiving a request for a transaction log page and determining whether a requested log page is newly-allocated or already exists. A determination is made regarding whether the last log page is being modified. A physical lock is taken on the requested log page when it has been determined that the requested log page is not newly-allocated and that the last log page is not being modified. Operations on the last log page are synchronized without a physical lock when it is determined that the requested log page is newly-allocated or that the last log page is being modified.

    摘要翻译: 本文描述了用于改进数据库事务日志的物理锁获取的系统,方法和计算机程序产品。 在一个实施例中,该方法通过接收对事务日志页面的请求并确定所请求的日志页面是新被分配还是已经存在来操作。 确定最后一个日志页面是否被修改。 当确定所请求的日志页面不被新分配并且最后一个日志页面未被修改时,将在所请求的日志页面上执行物理锁定。 当确定所请求的日志页面被新分配或者最后一个日志页面被修改时,上一个日志页面上的操作被同步而没有物理锁定。

    Database system providing self-tuned parallel database recovery
    19.
    发明授权
    Database system providing self-tuned parallel database recovery 有权
    数据库系统提供自调并行数据库恢复

    公开(公告)号:US07447710B2

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

    申请号:US10710868

    申请日:2004-08-09

    IPC分类号: G06F12/00 G06F17/30

    摘要: A database system providing self-tuned parallel database recovery is described. In one embodiment, for example, in a database system, a method is described for performing recovery operations using an optimal number of recovery threads, the method comprises steps of: (a) spawning an initial recovery thread to perform recovery operations; (b) measuring I/O (input/output) performance with the initial recovery thread; (c) spawning a subsequent recovery thread to perform recovery operations; (d) measuring I/O performance with the subsequent recovery thread; and (e) as long as I/O performance does not degrade beyond a preselected percentage, repeating steps (c) and (d) for spawning a desired number of additional recovery threads. In another embodiment, the database system auto-tunes the cache during performance of database recovery operations to optimize the performance of recovery operations.

    摘要翻译: 描述了提供自调谐并行数据库恢复的数据库系统。 在一个实施例中,例如,在数据库系统中,描述了使用最佳数量的恢复线程执行恢复操作的方法,所述方法包括以下步骤:(a)产生初始恢复线程以执行恢复操作; (b)用初始恢复线测量I / O(输入/输出)性能; (c)产生后续恢复线程执行恢复操作; (d)用随后的恢复线测量I / O性能; 和(e)只要I / O性能不降低超过预选百​​分比,重复步骤(c)和(d)以产生所需数量的其他恢复线程。 在另一个实施例中,数据库系统在执行数据库恢复操作期间自动调整缓存以优化恢复操作的性能。

    Distributed Database System Providing Data and Space Management Methodology
    20.
    发明申请
    Distributed Database System Providing Data and Space Management Methodology 有权
    分布式数据库系统提供数据和空间管理方法

    公开(公告)号:US20080235298A1

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

    申请号:US12056201

    申请日:2008-03-26

    IPC分类号: G06F17/30

    摘要: A distributed database system providing data and space management methodology. In a distributed database system having an allocation page for tracking allocation and deallocation of data pages including a deallocation bit for tracking data page deallocation, a method for determining when to clear the deallocation bit during recovery comprises: during runtime operation, generating log records recording allocation and deallocation of data pages, setting the deallocation bit during deallocation of a data page by a transaction, and clearing the deallocation bit after the transaction has committed; during recovery following a failure, identifying a particular log record corresponding to the deallocation bit set during deallocation of a given data page; determining whether the deallocation of the given data page recorded in the particular log record committed prior to the failure; and if the deallocation of the given data page committed prior to the failure, clearing the deallocation bit.

    摘要翻译: 提供数据和空间管理方法的分布式数据库系统。 在具有跟踪分配页面的分配页面的分布式数据库系统中,包括用于跟踪数据页面解除分配的分配位的数据页面的分配页面,用于在恢复期间确定何时清除分配位的方法包括:在运行时操作期间,生成日志记录记录分配 和数据页面的解除分配,在通过交易解除数据页面的处理期间设置解除分配位,以及在交易提交之后清除分配位; 在故障恢复期间,识别与在给定数据页的释放期间设置的解除分配位相对应的特定日志记录; 确定在故障之前是否在特定日志记录中记录的给定数据页的释放是否被提交; 并且如果在发生故障之前提交的给定数据页面被释放,则清除分配位。