公开(公告)号：US20110208757A1

公开(公告)日：2011-08-25

申请号：US12712767

申请日：2010-02-25

申请人： Hochak HUNG ,  Kumar RAJAMANI ,  Jaebock LEE ,  Phillip YAM

发明人： Hochak HUNG ,  Kumar RAJAMANI ,  Jaebock LEE ,  Phillip YAM

IPC分类号： G06F17/30

CPC分类号： G06F17/30442

摘要： Disclosed are improved methods, systems, and mediums for cursor sharing and cursor pruning. According to some approaches, existing child cursors are distinguished using a cursor sharing criteria node structure. A sharing criteria node (also referred to as a “diagnostic” node) is created when a sharing criteria mismatch/failure happens. The node contains information about why the child cursor could not be shared and also information that can be used to quickly re-evaluate this sharing criterion in the future.

摘要翻译： 公开了用于光标共享和光标修剪的改进的方法，系统和介质。 根据一些方法，使用游标共享标准节点结构来区分现有的子游标。 当共享标准不匹配/故障发生时，创建共享标准节点（也称为“诊断”节点）。 该节点包含有关为什么不能共享子游标的信息，以及可以用来快速重新评估此共享标准的信息。

公开(公告)号：US20080098046A1

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

申请号：US11875478

申请日：2007-10-19

申请人： David M. Alpern ,  Alan Choi ,  Chandrasekharan Iyer ,  Jaebock Lee ,  Kumar Rajamani ,  Shrikanth Shankar ,  Guhan Viswanathan ,  William Waddington ,  Philip Yam

发明人： David M. Alpern ,  Alan Choi ,  Chandrasekharan Iyer ,  Jaebock Lee ,  Kumar Rajamani ,  Shrikanth Shankar ,  Guhan Viswanathan ,  William Waddington ,  Philip Yam

IPC分类号： G06F17/30

CPC分类号： G06F17/3051 ,  G06F17/30306 ,  G06F17/30371

摘要： A database may facilitate zero-downtime upgrades by concurrently maintaining multiple editions of database objects for use by both pre-upgrade and post-upgrade clients of a database application. Operations performed within the database are associated with an edition based on, for example, an initiating client or transaction. When an operation references an object or data, the database automatically performs the operation using the object or data associated with the edition with which the operation is itself associated. The database may determine the associated edition without explicit identification of the associated edition in a query or in code. Thus, no client or stored procedure code changes are necessary to reflect a new edition added during an update. Data changes in one edition may be automatically and immediately propagated to the other edition through the use of cross-edition triggers, thereby allowing both pre-upgrade and post-upgrade clients to remain fully functional throughout an upgrade.

摘要翻译： 数据库可以通过同时维护数据库对象的多个版本来促进零停机升级，供数据库应用程序的升级前和升级后客户端使用。 在数据库内执行的操作与基于例如发起客户端或事务的版本相关联。 当操作引用对象或数据时，数据库将使用与操作本身相关联的版本相关联的对象或数据自动执行操作。 数据库可以确定相关版本，而无需在查询或代码中显式标识相关联的版本。 因此，不需要客户端或存储过程代码更改来反映更新期间添加的新版本。 一个版本中的数据更改可能会通过使用跨版本触发器自动立即传播到其他版本，从而允许升级前和升级后客户端在升级过程中保持全面的功能。

公开(公告)号：US08849794B2

公开(公告)日：2014-09-30

申请号：US13052928

申请日：2011-03-21

申请人： Kumar Rajamani ,  Namit Jain

发明人： Kumar Rajamani ,  Namit Jain

IPC分类号： G06F17/30

CPC分类号： G06F17/30433

摘要： A method system and program for performing a query in which context and information including opcodes accompanies an execution plan for the query. The opcodes determine operations to retrieve a set of bind variables. The execution plan and context information shared by a plurality of application programs.

摘要翻译： 一种用于执行查询的方法系统和程序，其中包括操作码的上下文和信息伴随着查询的执行计划。 操作码确定检索一组绑定变量的操作。 由多个应用程序共享的执行计划和上下文信息。

公开(公告)号：US08301667B2

公开(公告)日：2012-10-30

申请号：US12712767

申请日：2010-02-25

申请人： Hochak Hung ,  Kumar Rajamani ,  Jaebock Lee ,  Philip Yam

发明人： Hochak Hung ,  Kumar Rajamani ,  Jaebock Lee ,  Philip Yam

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

CPC分类号： G06F17/30442

摘要： Disclosed are improved methods, systems, and media for cursor sharing and cursor pruning. According to some approaches, existing child cursors are distinguished using a cursor sharing criteria node structure. A sharing criteria node (also referred to as a “diagnostic” node) is created when a sharing criteria mismatch/failure happens. The node contains information about why the child cursor could not be shared and also information that can be used to quickly re-evaluate this sharing criterion in the future.

摘要翻译： 公开了用于光标共享和光标修剪的改进的方法，系统和媒体。 根据一些方法，使用游标共享标准节点结构来区分现有的子游标。 当共享标准不匹配/失败发生时，创建共享标准节点（也称为诊断节点）。 该节点包含有关为什么不能共享子游标的信息，以及可以用来快速重新评估此共享标准的信息。

公开(公告)号：US20110087642A1

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

申请号：US12576140

申请日：2009-10-08

申请人： Kumar Rajamani ,  Hochak Hung ,  Jaebock Lee ,  Philip Yam

发明人： Kumar Rajamani ,  Hochak Hung ,  Jaebock Lee ,  Philip Yam

IPC分类号： G06F17/30

CPC分类号： G06F17/30997 ,  G06F17/30557 ,  G06F17/30589

摘要： A method and apparatus for efficiently managing cached objects is provided. A mapping is a typed relationship between cached objects. A base object contains content, and a mapped object is mapped to a base object when there is a particular relationship between the mapped object and the base object. The type of mapping defines how the objects in the relationship are treated when the mapped object is created, read, or written. At creation time, the mapping type may define how the mapping relationship is recognized. Sometimes recognizing a relationship requires establishing equivalence between the objects. At read and write time, the mapping type may define on which object a mutual exclusion lock is held, which content is returned or which object's content is updated. A wide range of applications can benefit from enhanced object caching performance, and in addition, application may define application-specific semantics on mapping types as well.

摘要翻译： 提供了一种有效管理缓存对象的方法和装置。 映射是缓存对象之间的类型关系。 基础对象包含内容，并且当映射对象和基础对象之间存在特定关系时，映射对象将映射到基础对象。 映射的类型定义当映射的对象被创建，读取或写入时，关系中的对象如何被对待。 在创建时，映射类型可以定义映射关系如何被识别。 有时识别关系需要建立对象之间的等价性。 在读取和写入时间，映射类型可以定义在哪个对象上保留互斥锁，哪些内容被返回或哪个对象的内容被更新。 广泛的应用程序可以从增强的对象缓存性能中受益，另外，应用程序也可以定义映射类型的特定于应用程序的语义。

公开(公告)号：US20060004828A1

公开(公告)日：2006-01-05

申请号：US10846120

申请日：2004-05-14

申请人： Kumar Rajamani ,  Susan Kotsovolos ,  Russell Green ,  Rajagopalan Govindarajan ,  Jaebock Lee ,  Ho Hung ,  Guhan Viswanathan

发明人： Kumar Rajamani ,  Susan Kotsovolos ,  Russell Green ,  Rajagopalan Govindarajan ,  Jaebock Lee ,  Ho Hung ,  Guhan Viswanathan

IPC分类号： G06F17/00

CPC分类号： G06F17/30286

摘要： A method and apparatus for updating databases are disclosed. An update vector for an object is created for identifying updated attributes. A dependent object is identified and a dependency vector of the dependent object is compared with update vector to determine whether the dependent object depends on the updated attributes.

摘要翻译： 公开了一种用于更新数据库的方法和装置。 创建用于标识更新的属性的对象的更新向量。 识别依赖对象，并将依赖对象的依赖向量与更新向量进行比较，以确定依赖对象是否依赖于更新的属性。

公开(公告)号：US09760658B2

公开(公告)日：2017-09-12

申请号：US12576140

申请日：2009-10-08

申请人： Kumar Rajamani ,  Hochak Hung ,  Jaebock Lee ,  Philip Yam

发明人： Kumar Rajamani ,  Hochak Hung ,  Jaebock Lee ,  Philip Yam

IPC分类号： G06F17/30

CPC分类号： G06F17/30997 ,  G06F17/30557 ,  G06F17/30589

摘要： A method and apparatus for efficiently managing cached objects is provided. A mapping is a typed relationship between cached objects. A base object contains content, and a mapped object is mapped to a base object when there is a particular relationship between the mapped object and the base object. The type of mapping defines how the objects in the relationship are treated when the mapped object is created, read, or written. At creation time, the mapping type may define how the mapping relationship is recognized. Sometimes recognizing a relationship requires establishing equivalence between the objects. At read and write time, the mapping type may define on which object a mutual exclusion lock is held, which content is returned or which object's content is updated. A wide range of applications can benefit from enhanced object caching performance, and in addition, application may define application-specific semantics on mapping types as well.

公开(公告)号：US08005792B2

公开(公告)日：2011-08-23

申请号：US11129717

申请日：2005-05-13

申请人： Russell John Green ,  Subhransu Basu ,  Shrikanth Shankar ,  Kumar Rajamani ,  Ho Chak Hung ,  Jaebock Lee

发明人： Russell John Green ,  Subhransu Basu ,  Shrikanth Shankar ,  Kumar Rajamani ,  Ho Chak Hung ,  Jaebock Lee

IPC分类号： G06F7/00

CPC分类号： G06F17/30356

摘要： Versioned metadata allows multiple versions of metadata for a given object to exist concurrently on a system thereby supporting the parallel execution of operations which would otherwise be mutually exclusive. Metadata updates are permitted while other objects maintain access to another version of the metadata through a versioning infrastructure. The versioning infrastructure allows the creation of new versions of metadata, maintains obsolete versions in the system as long as they are being used by any object, and deletes the obsolete versions once they are no longer in use.

摘要翻译： 版本化元数据允许给定对象的多个版本的元数据同时存在于系统上，从而支持并行执行否则将是相互排斥的操作。 允许元数据更新，而其他对象通过版本控制基础架构可以访问其他版本的元数据。 版本控制基础架构允许创建新的元数据版本，只要系统使用它们，就可以在系统中维护过时的版本，并在不再使用过时的版本后删除它们。

公开(公告)号：US20110173182A1

公开(公告)日：2011-07-14

申请号：US13052928

申请日：2011-03-21

申请人： Kumar RAJAMANI ,  Namit JAIN

发明人： Kumar RAJAMANI ,  Namit JAIN

IPC分类号： G06F17/30

CPC分类号： G06F17/30433

摘要： A method system and program for performing a query in which context and information including opcodes accompanies an execution plan for the query. The opcodes determine operations to retrieve a set of bind variables. The execution plan and context information shared by a plurality of application programs.

摘要翻译： 一种用于执行查询的方法系统和程序，其中包括操作码的上下文和信息伴随着查询的执行计划。 操作码确定检索一组绑定变量的操作。 由多个应用程序共享的执行计划和上下文信息。

公开(公告)号：US07734580B2

公开(公告)日：2010-06-08

申请号：US11818975

申请日：2007-01-29

申请人： Tirthankar Lahiri ,  Kiran Goyal ,  Jia Shi ,  Wei-Ming Hu ,  Neil MacNaughton ,  Jaebock Lee ,  Bharat Baddepudi ,  Yunrui Li ,  J. William Lee ,  Vipin Gokhale ,  Mark Dilman ,  Niloy Mukherjee ,  Vinay Srihari ,  Kumar Rajamani ,  Hochak Hung

发明人： Tirthankar Lahiri ,  Kiran Goyal ,  Jia Shi ,  Wei-Ming Hu ,  Neil MacNaughton ,  Jaebock Lee ,  Bharat Baddepudi ,  Yunrui Li ,  J. William Lee ,  Vipin Gokhale ,  Mark Dilman ,  Niloy Mukherjee ,  Vinay Srihari ,  Kumar Rajamani ,  Hochak Hung

IPC分类号： G06F17/30

CPC分类号： G06F11/2097 ,  G06F11/2035 ,  G06F11/2048 ,  G06F12/0815

摘要： A standby database system or another replica data system replicates changes, made to data blocks at a source database system or another primary data copy, to replicas of the data blocks at the standby database system or other replica. While replicating the changes to the data blocks thereof, the standby database system (or other replica) receives queries (or reads) issued thereto and computes the queries based on data read from the data blocks thereof.

摘要翻译： 备用数据库系统或其他副本数据系统将对源数据库系统或其他主数据副本上的数据块进行的更改复制到备用数据库系统或其他副本上的数据块的副本。 在对其数据块进行复制的同时，备用数据库系统（或其他副本）接收对其发出的查询（或读取），并根据从其数据块读取的数据来计算查询。