公开(公告)号：US20110067008A1

公开(公告)日：2011-03-17

申请号：US12559338

申请日：2009-09-14

申请人： Deepti Srivastava ,  Wilson Chan ,  John Hsu ,  Eugene Ho ,  Tolga Yurek ,  Beverly Zane ,  Angelo Pruscino

发明人： Deepti Srivastava ,  Wilson Chan ,  John Hsu ,  Eugene Ho ,  Tolga Yurek ,  Beverly Zane ,  Angelo Pruscino

IPC分类号： G06F9/44

CPC分类号： G06F11/3636 ,  G06F11/3466 ,  G06F2201/865

摘要： Techniques for adaptive trace logging include, in one embodiment, obtaining input data on trace logging behavior and computing resources used by trace logging. Based on the obtained input data, an adaptive trace logging module automatically takes action at runtime to reduce the amount of computing resources consumed by tracing logging. For example, the action taken may include decreasing a trace logging level of an executing software program to reduce the number of trace logging messages added to a trace log. In another embodiment, the techniques include detecting a condition of an executing software program that warrants a change to a trace logging level of the executing program. The adaptive trace logging module automatically changes the trace logging level of the executing program as-needed for the detected condition. For example, the adaptive trace logging module may increase the trace logging level of an executing program upon detecting a deadlock or other abnormal condition of the executing program. By automatically increasing the trace logging level upon detecting an abnormal condition, additional trace logging messages may be written to a trace log aiding diagnosis and troubleshooting of the condition.

摘要翻译： 在一个实施例中，用于自适应跟踪记录的技术包括获取跟踪记录行为和跟踪记录使用的计算资源的输入数据。 基于获得的输入数据，自适应跟踪记录模块在运行时自动执行操作，以减少跟踪记录所消耗的计算资源量。 例如，采取的措施可能包括减少执行软件程序的跟踪日志记录级别，以减少添加到跟踪日志中的跟踪日志记录消息的数量。 在另一个实施例中，这些技术包括检测执行软件程序的条件，该程序保证对执行程序的跟踪记录级别的改变。 自适应跟踪记录模块根据检测到的条件自动更改执行程序的跟踪记录级别。 例如，自适应跟踪记录模块可以在检测到执行程序的死锁或其他异常状况时增加执行程序的跟踪记录级别。 通过在检测到异常情况后自动增加跟踪日志记录级别，可能会向跟踪记录中写入附加的跟踪记录消息，以帮助诊断和排除故障。

公开(公告)号：US09529694B2

公开(公告)日：2016-12-27

申请号：US12559338

申请日：2009-09-14

申请人： Deepti Srivastava ,  Wilson Chan ,  John Hsu ,  Eugene Ho ,  Tolga Yurek ,  Beverly Zane ,  Angelo Pruscino

发明人： Deepti Srivastava ,  Wilson Chan ,  John Hsu ,  Eugene Ho ,  Tolga Yurek ,  Beverly Zane ,  Angelo Pruscino

IPC分类号： G06F9/44 ,  G06F11/36 ,  G06F11/34

CPC分类号： G06F11/3636 ,  G06F11/3466 ,  G06F2201/865

摘要： Techniques for adaptive trace logging include, in one embodiment, obtaining input data on trace logging behavior and computing resources used by trace logging. Based on the obtained input data, an adaptive trace logging module automatically takes action at runtime to reduce the amount of computing resources consumed by tracing logging. For example, the action taken may include decreasing a trace logging level of an executing software program to reduce the number of trace logging messages added to a trace log. In another embodiment, the techniques include detecting a condition of an executing software program that warrants a change to a trace logging level of the executing program. The adaptive trace logging module automatically changes the trace logging level of the executing program as-needed for the detected condition. For example, the adaptive trace logging module may increase the trace logging level of an executing program upon detecting a deadlock or other abnormal condition of the executing program. By automatically increasing the trace logging level upon detecting an abnormal condition, additional trace logging messages may be written to a trace log aiding diagnosis and troubleshooting of the condition.

摘要翻译： 在一个实施例中，用于自适应跟踪记录的技术包括获取跟踪记录行为和跟踪记录使用的计算资源的输入数据。 基于获得的输入数据，自适应跟踪记录模块在运行时自动执行操作，以减少跟踪记录所消耗的计算资源量。 例如，采取的措施可能包括减少执行软件程序的跟踪日志记录级别，以减少添加到跟踪日志中的跟踪日志记录消息的数量。 在另一个实施例中，这些技术包括检测执行软件程序的条件，该程序保证对执行程序的跟踪记录级别的改变。 自适应跟踪记录模块根据检测到的条件自动更改执行程序的跟踪记录级别。 例如，自适应跟踪记录模块可以在检测到执行程序的死锁或其他异常状况时增加执行程序的跟踪记录级别。 通过在检测到异常情况后自动增加跟踪日志记录级别，可以向跟踪日志中写入附加的跟踪记录消息，以帮助诊断和故障排除。

公开(公告)号：US20060288144A1

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

申请号：US11156318

申请日：2005-06-16

申请人： Wilson Chan ,  Angelo Pruscino ,  Stefan Roesch ,  Michael Zoll ,  Tolga Yurek ,  Eugene Ho

发明人： Wilson Chan ,  Angelo Pruscino ,  Stefan Roesch ,  Michael Zoll ,  Tolga Yurek ,  Eugene Ho

IPC分类号： G06F12/14

CPC分类号： G06F9/526 ,  G06F2209/522 ,  Y10S707/99938

摘要： Techniques are described herein for handling lock-related inconsistencies. As mentioned above, such inconsistencies occur when two or more sets of lock information, relating to the same resource, convey inconsistent information about locks requested and/or granted on that resource. In general, the techniques involve causing the locally-stored lock information about a resource to be sent to the master node of the resource. The master node of the resource compares the lock information thus received against the lock information maintained by the master node. Based on the comparison, the master node determines how to resolve the lock-related inconsistency, and sends messages to those nodes that need to change their local lock information for the resource. Once all of the lock information has been made consistent, the resource made available for access. Because the lock-related inconsistency is resolved without restarting nodes, the availability required to correct the inconsistency.

摘要翻译： 本文描述了处理与锁相关的不一致性的技术。 如上所述，当与相同资源相关的两组或多组锁定信息传达关于在该资源上请求和/或授予的锁定的不一致的信息时，会发生这种不一致。 一般来说，这些技术涉及将关于资源的本地存储的锁定信息发送到资源的主节点。 资源的主节点将由此接收的锁定信息与由主节点维护的锁定信息进行比较。 基于比较，主节点确定如何解决与锁相关的不一致，并向需要更改其资源的本地锁信息的那些节点发送消息。 一旦所有的锁信息一致，该资源就可用于访问。 由于锁定相关的不一致性在不重新启动节点的情况下得到解决，所以需要更改不一致的可用性。

公开(公告)号：US20070185872A1

公开(公告)日：2007-08-09

申请号：US11346822

申请日：2006-02-03

申请人： Eugene Ho ,  Wilson Wai Chan ,  Tak Wang ,  Angelo Pruscino ,  Tolga Yurek

发明人： Eugene Ho ,  Wilson Wai Chan ,  Tak Wang ,  Angelo Pruscino ,  Tolga Yurek

IPC分类号： G06F17/30

CPC分类号： G06F9/526 ,  G06F2209/522 ,  G06F2209/523

摘要： A method and apparatus for managing locks in a database system is provided. A master node grants a lock on a first resource and a group of resources that includes the first resource to a first requester node. The requester node receives a mapping corresponding to the group of resources that may indicate that a lock already exists for a second resource in the group. If the requester node desires a lock on a resource located in the group, the requester node grants itself the lock without notifying the master node. A second requester node requests a lock for a particular resource in the group of resources. The first requester node grants the lock on the particular resource and updates the mapping to indicate that a different node holds a lock for the particular resource.

摘要翻译： 提供了一种用于管理数据库系统中的锁的方法和装置。 主节点向包括第一资源的第一资源和一组资源授予对第一请求者节点的锁定。 请求者节点接收对应于可以指示组中的第二资源的锁已经存在的资源组的映射。 如果请求者节点希望对位于组中的资源进行锁定，则请求者节点自己给予锁定而不通知主节点。 第二个请求者节点向资源组中的特定资源请求锁。 第一个请求者节点授予对特定资源的锁定，并更新映射以指示不同的节点持有特定资源的锁。

公开(公告)号：US08103642B2

公开(公告)日：2012-01-24

申请号：US11346822

申请日：2006-02-03

申请人： Eugene Ho ,  Wilson Wai Shun Chan ,  Tak Fung Wang ,  Angelo Pruscino ,  Tolga Yurek

发明人： Eugene Ho ,  Wilson Wai Shun Chan ,  Tak Fung Wang ,  Angelo Pruscino ,  Tolga Yurek

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

CPC分类号： G06F9/526 ,  G06F2209/522 ,  G06F2209/523

摘要： A method and apparatus for managing locks in a database system is provided. A master node grants a lock on a first resource and a group of resources that includes the first resource to a first requester node. The requester node receives a mapping corresponding to the group of resources that may indicate that a lock already exists for a second resource in the group. If the requester node desires a lock on a resource located in the group, the requester node grants itself the lock without notifying the master node. A second requester node requests a lock for a particular resource in the group of resources. The first requester node grants the lock on the particular resource and updates the mapping to indicate that a different node holds a lock for the particular resource.

摘要翻译： 提供了一种用于管理数据库系统中的锁的方法和装置。 主节点向包括第一资源的第一资源和一组资源授予对第一请求者节点的锁定。 请求者节点接收对应于可以指示组中的第二资源的锁已经存在的资源组的映射。 如果请求者节点希望对位于组中的资源进行锁定，则请求者节点自己给予锁定而不通知主节点。 第二个请求者节点向资源组中的特定资源请求锁。 第一个请求者节点授予对特定资源的锁定，并更新映射以指示不同的节点持有特定资源的锁。

公开(公告)号：US07315910B2

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

申请号：US11156318

申请日：2005-06-16

申请人： Wilson Wai Shun Chan ,  Angelo Pruscino ,  Stefan Roesch ,  Michael Zoll ,  Tolga Yurek ,  Eugene Ho

发明人： Wilson Wai Shun Chan ,  Angelo Pruscino ,  Stefan Roesch ,  Michael Zoll ,  Tolga Yurek ,  Eugene Ho

IPC分类号： G06F12/14 ,  G06F7/00 ,  G06F11/00 ,  G06F9/46

CPC分类号： G06F9/526 ,  G06F2209/522 ,  Y10S707/99938

摘要： Techniques are described herein for handling lock-related inconsistencies. As mentioned above, such inconsistencies occur when two or more sets of lock information, relating to the same resource, convey inconsistent information about locks requested and/or granted on that resource. In general, the techniques involve causing the locally-stored lock information about a resource to be sent to the master node of the resource. The master node of the resource compares the lock information thus received against the lock information maintained by the master node. Based on the comparison, the master node determines how to resolve the lock-related inconsistency, and sends messages to those nodes that need to change their local lock information for the resource. Once all of the lock information has been made consistent, the resource made available for access.

摘要翻译： 本文描述了处理与锁相关的不一致性的技术。 如上所述，当与相同资源相关的两组或多组锁定信息传达关于在该资源上请求和/或授予的锁定的不一致的信息时，会发生这种不一致。 一般来说，这些技术涉及将关于资源的本地存储的锁定信息发送到资源的主节点。 资源的主节点将由此接收的锁定信息与由主节点维护的锁定信息进行比较。 基于比较，主节点确定如何解决与锁相关的不一致，并向需要更改其资源的本地锁信息的那些节点发送消息。 一旦所有的锁信息一致，该资源就可用于访问。

公开(公告)号：US07921090B2

公开(公告)日：2011-04-05

申请号：US11450179

申请日：2006-06-09

申请人： Eugene Ho ,  Kotaro Ono ,  Neil Macnaughton ,  Michael Zoll ,  Herbert van den Bergh

发明人： Eugene Ho ,  Kotaro Ono ,  Neil Macnaughton ,  Michael Zoll ,  Herbert van den Bergh

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

CPC分类号： G06F17/30362

摘要： Methods and apparatuses for providing access to data in a cluster database are described. Embodiments of the invention include identifying situations in which many nodes require relatively equal access to a data block, and taking appropriate measures to improve the performance of the system in these situations. For example, a node may automatically downgrade its lock from an X lock to an S lock as soon as it has finished a modification of the data. S locks are sent to other nodes in the system as soon as a modification is complete. Modifications to the data are also sent to other nodes in the system as soon as a modification is complete. Depending on the size of the data modification, the entire data block may be sent, or only the modifications to the data may be sent.

摘要翻译： 描述了用于提供对群集数据库中的数据的访问的方法和装置。 本发明的实施例包括识别许多节点需要对数据块相对相等的访问的情况，并且在这些情况下采取适当的措施来提高系统的性能。 例如，一旦节点完成数据的修改，节点就可以自动将其锁定从X锁降级到S锁。 一旦修改完成，S锁将被发送到系统中的其他节点。 一旦修改完成，对数据的修改也将发送到系统中的其他节点。 根据数据修改的大小，可以发送整个数据块，或者仅可以发送对数据的修改。

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

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

公开(公告)号：US20070257693A1

公开(公告)日：2007-11-08

申请号：US11417964

申请日：2006-05-03

申请人： Bret Stott ,  Philip Yeung ,  John Brooks ,  Benedict Lau ,  Chanh Tran ,  Eugene Ho

发明人： Bret Stott ,  Philip Yeung ,  John Brooks ,  Benedict Lau ,  Chanh Tran ,  Eugene Ho

IPC分类号： G01R31/02

CPC分类号： G01R31/31716 ,  G11C29/022

摘要： An integrated circuit is described. The integrated circuit includes an interface circuit that includes a transmitter and a receiver. A generator in the integrated circuit is selectively coupled to the transmitter. The generator is to provide a test sequence that is output by the transmitter during a test mode of operation. A memory in the integrated circuit is selectively coupled to the generator and the receiver. The memory is to receive and synchronize the test sequence and a signal corresponding to the test sequence that is received by the receiver. A logic circuit in the integrated circuit is to compare the test sequence and the signal.

摘要翻译： 描述了集成电路。 集成电路包括包括发射机和接收机的接口电路。 集成电路中的发生器选择性地耦合到发射机。 发生器将提供在测试操作模式期间由发射器输出的测试序列。 集成电路中的存储器选择性地耦合到发生器和接收器。 存储器是接收并同步测试序列和对应于由接收机接收的测试序列的信号。 集成电路中的逻辑电路是比较测试序列和信号。

公开(公告)号：US20110066791A1

公开(公告)日：2011-03-17

申请号：US12631985

申请日：2009-12-07

申请人： Kiran Badrinarain Goyal ,  Neil J.S. Macnaughton ,  Eugene Ho ,  Adam Y. Lee ,  Vipin Gokhale ,  Wei-Ming Hu ,  Juan R. Loaiza ,  Kothanda Umamageswaran ,  Bharat C.V. Baddepudi ,  Boris Erlikhman ,  Alexander Tsukerman ,  Selcuk Aya ,  Roger Hansen ,  Adrian Ng

发明人： Kiran Badrinarain Goyal ,  Neil J.S. Macnaughton ,  Eugene Ho ,  Adam Y. Lee ,  Vipin Gokhale ,  Wei-Ming Hu ,  Juan R. Loaiza ,  Kothanda Umamageswaran ,  Bharat C.V. Baddepudi ,  Boris Erlikhman ,  Alexander Tsukerman ,  Selcuk Aya ,  Roger Hansen ,  Adrian Ng

IPC分类号： G06F12/00

CPC分类号： G06F12/0866 ,  G06F12/084 ,  G06F12/0888 ,  G06F12/0897 ,  G06F17/30312 ,  G06F17/3048 ,  G06F2212/283 ,  G06F2212/311 ,  G06F2212/312 ,  G06F2212/465

摘要： Techniques are provided for using an intermediate cache between the shared cache of a database server and the non-volatile storage of a storage system. The intermediate cache may be local to the machine upon which the database server is executing, or may be implemented within the storage system. In one embodiment, the database system includes both a DB server-side intermediate cache, and a storage-side intermediate cache. The caching policies used to populate the intermediate cache are intelligent, taking into account factors that may include which database object an item belongs to, the item type of the item, a characteristic of the item; or the database operation in which the item is involved.

摘要翻译： 提供了在数据库服务器的共享缓存和存储系统的非易失性存储之间使用中间缓存的技术。 中间缓存可以是数据库服务器在其上执行的机器的本地，或者可以在存储系统内实现。 在一个实施例中，数据库系统包括DB服务器侧中间缓存和存储侧中间缓存。 用于填充中间缓存的缓存策略是智能的，考虑到可能包括项目属于哪个数据库对象的因素，项目的项目类型，项目的特征; 或涉及项目的数据库操作。