公开(公告)号：US07451448B1

公开(公告)日：2008-11-11

申请号：US09967068

申请日：2001-09-27

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

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

IPC分类号： G06F9/46 ,  G06F15/173 ,  G06F15/16

CPC分类号： G06F9/5027 ,  G06F2209/504 ,  Y02D10/22

摘要： A computer system is selectively quiesced by preventing selected resource consumers from starting new activity on a computer system, while allowing already-running activity to continue. Resource consumers are divided into resource consumer groups, and some groups are prevented from starting new activity while other groups are allowed to start new activity. A scheduler is used to alternate between resource plans, including a quiescence plan and an operations plan.

摘要翻译： 通过防止所选资源消费者在计算机系统上启动新活动，同时允许已经运行的活动继续，选择性地停止计算机系统。 资源消费者分为资源消费群体，一些群体被禁止开始新活动，而其他群体则被允许开始新的活动。 调度程序用于在资源计划之间进行交替，包括静默计划和操作计划。

公开(公告)号：US07447786B2

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

申请号：US11418782

申请日：2006-05-05

申请人： Juan Loaiza ,  Sashikanth Chandrasekaran ,  Neil Macnaughton

发明人： Juan Loaiza ,  Sashikanth Chandrasekaran ,  Neil Macnaughton

IPC分类号： G06F13/00

CPC分类号： G06F9/526 ,  G06F15/16 ,  G06F15/173

摘要： Described herein are techniques for synchronizing access to resources in a multi node system by establishing a resource as a read-mostly resource based on one or more criteria, and allowing a node to acquire a shared lock, not granted by the master, on the read-mostly resource where no anti-lock exists for the resource.

摘要翻译： 这里描述的是通过基于一个或多个标准将资源建立为主要读取的资源，并且允许节点获取未被主设备授予的共享锁在读取上来同步对多节点系统中的资源的访问的技术 - 资源无资源的资源。

公开(公告)号：US20070244918A1

公开(公告)日：2007-10-18

申请号：US11652782

申请日：2007-01-11

申请人： J. Lee ,  Juan Loaiza ,  Michael Stewart ,  Wei-Ming Hu ,  William Bridge

发明人： J. Lee ,  Juan Loaiza ,  Michael Stewart ,  Wei-Ming Hu ,  William Bridge

IPC分类号： G06F17/24

CPC分类号： G06F11/1471 ,  G06F11/1446 ,  G06F2201/80 ,  Y10S707/99931 ,  Y10S707/99953 ,  Y10S707/99954

摘要： Techniques are described herein for returning a repository to a prior state. The repository may be, for example a database, and the prior state may be, for example the consistent state that the database had at a particular point in time in the past. When a operator-caused error has been introduced to the database by changes made by an already-committed transaction, the techniques described herein may be used to recover from the error by returning the database to a point in time prior to the commit time of the transaction that introduced the error. The techniques involve the generation of “physical undo” information, and the use of the physical undo information in conjunction with physiological undo and physiological redo to efficiently return a repository to the prior state.

摘要翻译： 这里描述了将存储库返回到先前状态的技术。 存储库可以是例如数据库，并且先前状态可以是例如数据库在过去的特定时间点具有的一致状态。 当通过已经提交的事务所做的改变将由操作者导致的错误引入到数据库时，本文描述的技术可以用于通过将数据库返回到在提交时间之前的时间点从错误中恢复 事务引入了错误。 这些技术包括生成“物理撤销”信息，以及使用物理撤消信息结合生理撤消和生理重做，以有效地将存储库返回到先前状态。

公开(公告)号：US07181476B2

公开(公告)日：2007-02-20

申请号：US10427511

申请日：2003-04-30

申请人： J. William Lee ,  Juan Loaiza ,  Michael J. Stewart ,  Wei-Ming Hu ,  William H. Bridge, Jr.

发明人： J. William Lee ,  Juan Loaiza ,  Michael J. Stewart ,  Wei-Ming Hu ,  William H. Bridge, Jr.

IPC分类号： G06F17/30

CPC分类号： G06F11/1471 ,  G06F11/1446 ,  G06F2201/80 ,  Y10S707/99931 ,  Y10S707/99953 ,  Y10S707/99954

摘要： Techniques are described herein for returning a repository to a prior state. The repository may be, for example a database, and the prior state may be, for example the consistent state that the database had at a particular point in time in the past. When a operator-caused error has been introduced to the database by changes made by an already-committed transaction, the techniques described herein may be used to recover from the error by returning the database to a point in time prior to the commit time of the transaction that introduced the error. The techniques involve the generation of “physical undo” information, and the use of the physical undo information in conjunction with physiological undo and physiological redo to efficiently return a repository to the prior state.

公开(公告)号：US07577675B2

公开(公告)日：2009-08-18

申请号：US10427321

申请日：2003-04-30

申请人： Waleed Ojeil ,  Sumanta Chatterjee ,  Juan Loaiza

发明人： Waleed Ojeil ,  Sumanta Chatterjee ,  Juan Loaiza

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

CPC分类号： G06F17/30315 ,  Y10S707/99933 ,  Y10S707/99943 ,  Y10S707/99945 ,  Y10S707/99953

摘要： A method and apparatus for determining a mapping of a database object to storage layers is provided. According to one aspect, a database server generates views that represent which components of each storage layer store parts of the object. The views are based on information that the database server automatically gathers from one or more vendor libraries. Each library implements a common API. Each storage layer is associated with a library. The database server passes the object's identifier to each library's implementation of a get-mapping routine of the API. A process that is associated with the storage layer that recognizes the object's identifier responds with the identity of one or more components of the storage layer that store one or more parts of the object. The database server recursively uses this information to obtain mappings between storage layer components and underlying storage layer components.

摘要翻译： 提供了一种用于确定数据库对象到存储层的映射的方法和装置。 根据一个方面，数据库服务器生成视图，其表示每个存储层的哪些组件存储对象的部分。 视图基于数据库服务器自动从一个或多个供应商库收集的信息。 每个库都实现了一个通用的API。 每个存储层与一个库相关联。 数据库服务器将对象的标识符传递给API的Get-mapping例程的每个库的实现。 与识别对象的标识符的存储层相关联的进程以存储对象的一个​​或多个部分的存储层的一个或多个组件的身份进行响应。 数据库服务器会递归地使用此信息来获取存储层组件和底层存储层组件之间的映射。

公开(公告)号：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.

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

公开(公告)号：US20080071997A1

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

申请号：US11521908

申请日：2006-09-15

申请人： Juan Loaiza ,  Neil MacNaughton ,  Eugene Ho ,  Vipin Gokhale ,  Kiran Goyal ,  Tirthankar Lahiri

发明人： Juan Loaiza ,  Neil MacNaughton ,  Eugene Ho ,  Vipin Gokhale ,  Kiran Goyal ,  Tirthankar Lahiri

IPC分类号： G06F13/00 ,  G06F12/14

CPC分类号： G06F9/526 ,  G06F17/30362 ,  G06F2209/523

摘要： Techniques are provided for performing changes to a resource governed by a locking mechanism. An entity (such as a server instance in a database system cluster) requests permission to modify the resource. In response to the request, the entity receives a first lock on the resource, which grants permission to perform the change to the resource without making the change permanent. After receiving the first lock, the entity performs the change to a copy of the resource that resides in shared memory without making another copy of the resource. After performing the change and until receiving permission to make the change permanent, the entity prevents the change to the resource from becoming permanent. After performing the change, the entity receives a second lock on the resource, which grants the entity permission to make the change permanent. After receiving the second lock, the entity ceases to prevent the change to the resource from becoming permanent.

摘要翻译： 提供了用于对由锁定机构管理的资源进行更改的技术。 实体（如数据库系统集群中的服务器实例）请求修改资源的权限。 响应于该请求，实体在资源上接收到第一个锁定，该权限允许对资源执行更改，而不会使更改永久性。 在接收到第一个锁定之后，实体对驻留在共享内存中的资源的副本执行更改，而不创建资源的另一个副本。 执行变更后，直到获得变更永久性的许可，实体将防止资源变为永久性。 执行更改后，实体将在资源上收到第二个锁定，该实体授予实体永久性更改权限。 收到第二个锁后，实体停止防止资源变为永久性。

公开(公告)号：US07017156B1

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

申请号：US09967458

申请日：2001-09-27

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

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

IPC分类号： G06F9/46

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

摘要： Access to computer system resources is regulated by computing an estimated execution time for an operation which seeks to use the resources. Once computed, the estimated execution time is used to make decisions about granting the operation access to the computer system resources. Operations which have an estimated execution time greater than a user-supplied maximum estimated execution time allowable for the operation are denied access to the computer system resources. Operations which are denied access are rescheduled for later operation, queued, or aborted.

摘要翻译： 对计算机系统资源的访问通过计算寻求使用资源的操作的估计执行时间来进行调节。 一旦计算出来，估计的执行时间用于作出关于授予对计算机系统资源的操作访问的决定。 估计执行时间大于操作允许的用户提供的最大估计执行时间的操作被拒绝访问计算机系统资源。 重新安排拒绝访问的操作，以便稍后操作，排队或中止。

公开(公告)号：US20050171945A1

公开(公告)日：2005-08-04

申请号：US11088340

申请日：2005-03-23

申请人： Carol Colrain ,  Namit Jain ,  Juan Loaiza

发明人： Carol Colrain ,  Namit Jain ,  Juan Loaiza

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

CPC分类号： G06F17/3048 ,  G06F17/30433 ,  Y10S707/99934 ,  Y10S707/99953

摘要： A system and method for enabling a second database instance to more quickly process a request to execute a database statement that has previously been executed by a first database instance is described. In one embodiment, the method involves sending the database statement from the first database instance to the second database instance, and generating by the second database instance one or more structures needed to prepare the statement for execution, such as a parse tree and an execution plan for the statement. If at some point in the future, the second database instance receives a request to execute the same statement, the above structures can be used for execution, thereby eliminating the need for one or more potentially time-consuming operations, such as generation of a parse tree or execution plan for the statement.

公开(公告)号：US20050114621A1

公开(公告)日：2005-05-26

申请号：US10746471

申请日：2003-12-23

申请人： Tirthankar Lahiri ,  Poojan Kumar ,  Brian Hirano ,  Arvind Nithrakashyap ,  Kant Patel ,  Kiran Goyal ,  Juan Loaiza

发明人： Tirthankar Lahiri ,  Poojan Kumar ,  Brian Hirano ,  Arvind Nithrakashyap ,  Kant Patel ,  Kiran Goyal ,  Juan Loaiza

IPC分类号： G06F9/50 ,  G06F12/02 ,  G06F12/00

CPC分类号： G06F9/5016 ,  G06F12/023

摘要： Allocation of memory is optimized across multiple pools of memory, based on minimizing the time it takes to successfully retrieve a given data item from each of the multiple pools. First data is generated that indicates a hit rate per pool size for each of multiple memory pools. In an embodiment, the generating step includes continuously monitoring attempts to access, or retrieve a data item from, each of the memory pools. The first data is converted to second data that accounts for a cost of a miss with respect to each of the memory pools. In an embodiment, the second data accounts for the cost of a miss in terms of time. How much of the memory to allocate to each of the memory pools is determined, based on the second data. In an embodiment, the steps of converting and determining are automatically performed, on a periodic basis.

摘要翻译： 基于最小化从多个池中的每一个成功检索给定数据项所需的时间，内存分配在多个内存池之间进行了优化。 生成第一个数据，指示每个多个内存池的每个池大小的命中率。 在一个实施例中，生成步骤包括连续地监视从每个存储器池访问或检索数据项的尝试。 第一个数据被转换成相对于每个存储器池来计算缺失成本的第二数据。 在一个实施例中，第二数据考虑到时间方面的错过的成本。 基于第二数据确定分配给每个存储器池的存储器的多少。 在一个实施例中，周期性地自动执行转换和确定的步骤。