利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

42 条记录 (耗时 0.024 秒)

    Maintaining global state of distributed transaction managed by an external transaction manager for clustered database systems
    1.
    发明申请
    Maintaining global state of distributed transaction managed by an external transaction manager for clustered database systems 审中-公开
    维护由集群数据库系统的外部事务管理器管理的分布式事务的全局状态

    公开(公告)号：US20080243865A1

    公开(公告)日：2008-10-02

    申请号：US11729473

    申请日：2007-03-28

    申请人： Yong Hu ,  Bipul Sinha ,  Amit Ganesh ,  Juan Loaiza ,  Vivekanandhan Raja

    发明人： Yong Hu ,  Bipul Sinha ,  Amit Ganesh ,  Juan Loaiza ,  Vivekanandhan Raja

    IPC分类号： G06F17/30

    CPC分类号： G06F16/27

    摘要： In accordance with an embodiment of the present invention, a transaction tracking mechanism is provided by a database server cluster to keep track of a global state of a distributed transaction. The global state of the distributed transaction comprises one or more statuses that are associated with one or more transaction branches that are part of the distributed transaction. The global state may be associated with a global lock. Through using the global state in association with the global lock, problems such as partial commits, data inconsistency, access contentions and deadlocks may be avoided when the database server cluster processes the distributed transaction.

    摘要翻译： 根据本发明的实施例，由数据库服务器集群提供事务跟踪机制以跟踪分布式事务的全局状态。 分布式事务的全局状态包括与作为分布式事务的一部分的一个或多个事务分支相关联的一个或多个状态。 全局状态可能与全局锁相关联。 通过使用与全局锁相关联的全局状态，当数据库服务器集群处理分布式事务时，可能会避免诸如部分提交，数据不一致，访问争用和死锁等问题。

    Transportable database
    2.
    发明申请
    Transportable database 有权
    可运输数据库

    公开(公告)号：US20050256908A1

    公开(公告)日：2005-11-17

    申请号：US10966961

    申请日：2004-10-15

    申请人： Wanli Yang ,  Bipul Sinha ,  Amit Ganesh ,  Wei Hu ,  Alok Pareek ,  Alexander Hwang ,  Steven Wertheimer ,  Francisco Sanchez ,  Dmitry Potapov ,  Shen-Ban Meng ,  Juan Loaiza ,  William Bridge ,  J. Lee

    发明人： Wanli Yang ,  Bipul Sinha ,  Amit Ganesh ,  Wei Hu ,  Alok Pareek ,  Alexander Hwang ,  Steven Wertheimer ,  Francisco Sanchez ,  Dmitry Potapov ,  Shen-Ban Meng ,  Juan Loaiza ,  William Bridge ,  J. Lee

    IPC分类号： G06F7/00 ,  G06F17/30

    CPC分类号： G06F17/30569 ,  Y10S707/99942

    摘要： A method and apparatus for creating a target database on a target platform based on a source database on a source platform is provided. A target database is created on the target platform based on data, metadata (for example, data in the system tablespace and control files), and external objects (for example, password files and externally stored tables) comprised within the source database. Data and metadata stored in tablespaces of the source database are converted to the format compatible with the target platform. The conversion of the data and metadata may be performed either at the source database or the target database. Redo information and undo information of the source database are not copied from the source database to the target database. Certain files, e.g., a password files, and links to externally stored object may be recreated on the target database.

    摘要翻译： 提供了一种用于在源平台上基于源数据库在目标平台上创建目标数据库的方法和装置。 基于源数据库中包含的数据，元数据（例如，系统表空间和控制文件中的数据）以及外部对象（例如，密码文件和外部存储的表），在目标平台上创建目标数据库。 存储在源数据库的表空间中的数据和元数据将转换为与目标平台兼容的格式。 可以在源数据库或目标数据库执行数据和元数据的转换。 源数据库的重做信息和撤消信息不会从源数据库复制到目标数据库。 可以在目标数据库上重新创建某些文件，例如密码文件和到外部存储对象的链接。

    Methods for automatic group switching according to a resource plan
    4.
    发明授权
    Methods for automatic group switching according to a resource plan 有权
    根据资源计划自动组切换的方法

    公开(公告)号：US07526767B1

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

    申请号：US09967441

    申请日：2001-09-27

    申请人： Ann Rhee ,  Sumanta Chatterjee ,  Juan Loaiza

    发明人： Ann Rhee ,  Sumanta Chatterjee ,  Juan Loaiza

    IPC分类号： G06F9/46

    CPC分类号： G06F9/5061

    摘要： A resource scheduler is provided for allocating a computer system resource to database management system (DBMS) processes. The resource scheduler operates according to resource plans and resource allocation methods. Each plan allocates the resource according to a resource allocation method. During operation of the DBMS, any of the active plans and resource allocation method may be exchanged for alternate plans or resource allocation methods. The resource scheduler enforces an emphasis resource allocation method in which processor time is allocated in percentages to groups of database processes groupified according to common execution requirements. A selected plan includes multiple process groups and/or sub-plans. The resource scheduler allocates processor time in multiple levels among the sub-plans and groups of database processes. Database processes are automatically switched between the groups of a plan according to switch criteria.

    摘要翻译： 提供资源调度器用于将计算机系统资源分配给数据库管理系统（DBMS）进程。 资源调度器根据资源计划和资源分配方式进行操作。 每个计划根据资源分配方法分配资源。 在DBMS的操作期间，可以为备用计划或资源分配方法交换任何活动计划和资源分配方法。 资源调度器执行强调资源分配方法，其中处理器时间按照按照常规执行要求分组的数据库进程的分组的百分比分配。 选定的计划包括多个进程组和/或子计划。 资源调度程序在数据库进程的子计划和组之间的多个级别中分配处理器时间。 数据库进程根据切换标准在计划组之间自动切换。

    Time model
    5.
    发明授权
    Time model 有权
    时间模型

    公开(公告)号：US07376682B2

    公开(公告)日：2008-05-20

    申请号：US10775513

    申请日：2004-02-09

    申请人： Mark Ramacher ,  Graham S. Wood ,  Juan Loaiza ,  Tirthankar Lahiri ,  Karl Dias

    发明人： Mark Ramacher ,  Graham S. Wood ,  Juan Loaiza ,  Tirthankar Lahiri ,  Karl Dias

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30008 ,  Y10S707/99957

    摘要： Quantifying the impact of wasteful operations on a database system is provided. One or more operations that are determined to be wasteful are received. The impact of the wasteful operations on performance in a database may then be quantified. The database is monitored to determine when a wasteful operation is being performed. When a wasteful operation is detected, a time value is recorded of the time spent on processing the wasteful operation. The time value is stored and used to quantify an impact of a performance problem in a database. The time value may be stored and associated with other time values that are recorded for the same wasteful operation. Thus, the impact of wasteful operations that are performed and processed in a database may be determined.

    摘要翻译： 提供了浪费操作对数据库系统的影响。 接收到被确定为浪费的一个或多个操作。 然后可以量化浪费操作对数据库中的性能的影响。 监视数据库以确定何时执行浪费的操作。 当检测到浪费的操作时，记录处理浪费操作花费的时间的时间值。 时间值被存储并用于量化数据库中性能问题的影响。 时间值可以被存储并且与为相同的浪费操作记录的其他时间值相关联。 因此，可以确定在数据库中执行和处理的浪费操作的影响。

    System for allocating resource using the weight that represents a limitation on number of allowance active sessions associated with each resource consumer group
    6.
    发明授权
    System for allocating resource using the weight that represents a limitation on number of allowance active sessions associated with each resource consumer group 有权
    用于使用代表与每个资源消费者组相关联的允许活动会话的数量的限制的权重来分配资源的系统

    公开(公告)号：US07020878B1

    公开(公告)日：2006-03-28

    申请号：US09967459

    申请日：2001-09-27

    申请人： Ann Rhee ,  Sumanta Chatterjee ,  Juan Loaiza

    发明人： Ann Rhee ,  Sumanta Chatterjee ,  Juan Loaiza

    IPC分类号： G06F9/46

    CPC分类号： G06F9/4881 ,  G06F2209/5019

    摘要： One embodiment of the present invention provides a resource scheduler for allocating a computer system resource, such as memory or mass storage, within a processor, to database management system (DBMS) processes. The resource scheduler operates according to resource plans and resource allocation methods. One or more plans may be configured and loaded with the DBMS. Each plan allocates the resource according to an associated resource allocation method. During operation of the DBMS, any or all of the active plans and resource allocation methods may be exchanged for alternate plans or resource allocation methods. In one embodiment of the invention the resource scheduler enforces a maximum active sessions resource allocation method in which system resources are allocated by limiting the number of active sessions allowed in groups of database processes grouped according to common execution requirements. A selected plan includes multiple process groups and/or sub-plans. The resource scheduler allocates system resources among the sub-plans and groups of database processes according to their associated limits on active session numbers, with sub-plans and groups having higher active session limits getting access to more system resources than sub-plans and groups having lower active session limits.

    摘要翻译： 本发明的一个实施例提供了一种资源调度器，用于将处理器内的诸如存储器或大容量存储的计算机系统资源分配给数据库管理系统（DBMS）处理。 资源调度器根据资源计划和资源分配方式进行操作。 一个或多个计划可以配置并加载到DBMS。 每个计划根据相关资源分配方法分配资源。 在DBMS的操作期间，任何或所有活动计划和资源分配方法可以被交换用于替代计划或资源分配方法。 在本发明的一个实施例中，资源调度器执行最大活动会话资源分配方法，其中通过限制根据共同执行需求分组的数据库进程组允许的活动会话的数量来分配系统资源。 选定的计划包括多个进程组和/或子计划。 资源调度程序根据其对活动会话号码的相关限制，在子计划和数据库进程组之间分配系统资源，具有较高活动会话限制的子计划和组比具有子计划和组的子计划和组具有访问更多的系统资源 活动会话限制较低