-
公开(公告)号:US08868831B2
公开(公告)日:2014-10-21
申请号: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
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服务器侧中间缓存和存储侧中间缓存。 用于填充中间缓存的缓存策略是智能的,考虑到可能包括项目属于哪个数据库对象的因素,项目的项目类型,项目的特征; 或涉及项目的数据库操作。
-
公开(公告)号:US08775479B2
公开(公告)日:2014-07-08
申请号:US11830642
申请日:2007-07-30
申请人: Nirman Kumar , Kaan Baloglu , Dheeraj Pandey , Krishna Kunchithapadam , Sujatha Muthulingam , Vipin Gokhale , Bharat Baddepudi
发明人: Nirman Kumar , Kaan Baloglu , Dheeraj Pandey , Krishna Kunchithapadam , Sujatha Muthulingam , Vipin Gokhale , Bharat Baddepudi
IPC分类号: G06F17/30
CPC分类号: G06F17/30318 , G06F17/3048
摘要: A method, system and computer program product are described for state maintenance of a large object. In one approach, the method, system and computer program product perform by associating one or more buffers with a transaction involving a large object, the large object data may be accessed using the one or more buffers during the transaction, and storing data for the large object from the one or more buffers in one or more sets of contiguous blocks.In one approach, a system performs state maintenance of a large object with a cache that associates one or more buffers with a transaction involving a large object, the large object data may be accessed using the one or more buffers during the transaction, and the cache stores large object data from the one or more buffers in one or more sets of contiguous blocks in storage.
摘要翻译: 描述了用于大对象的状态维护的方法,系统和计算机程序产品。 在一种方法中,方法,系统和计算机程序产品通过将一个或多个缓冲器与涉及大对象的事务相关联来执行,可以在事务期间使用一个或多个缓冲区来访问大对象数据,并且存储大的数据 一个或多个连续块集合中的一个或多个缓冲器的对象。 在一种方法中,系统使用将一个或多个缓冲器与涉及大对象的事务相关联的高速缓存执行大对象的状态维护,可以在事务期间使用一个或多个缓冲区来访问大对象数据,并且高速缓存 在存储中的一个或多个连续块集合中存储来自一个或多个缓冲器的大对象数据。
-
公开(公告)号: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服务器侧中间缓存和存储侧中间缓存。 用于填充中间缓存的缓存策略是智能的,考虑到可能包括项目属于哪个数据库对象的因素,项目的项目类型,项目的特征; 或涉及项目的数据库操作。
-
公开(公告)号:US07600063B2
公开(公告)日:2009-10-06
申请号: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分类号: G06F12/00
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.
摘要翻译: 提供了用于对由锁定机构管理的资源进行更改的技术。 实体(如数据库系统集群中的服务器实例)请求修改资源的权限。 响应于该请求,实体在资源上接收到第一个锁定,该权限允许对资源执行更改,而不会使更改永久性。 在接收到第一个锁定之后,实体对驻留在共享内存中的资源的副本执行更改,而不创建资源的另一个副本。 执行变更后,直到获得变更永久性的许可,实体将防止资源变为永久性。 执行更改后,实体将在资源上收到第二个锁定,该实体授予实体永久性更改权限。 收到第二个锁后,实体停止防止资源变为永久性。
-
公开(公告)号:US20090037495A1
公开(公告)日:2009-02-05
申请号:US11830642
申请日:2007-07-30
申请人: Nirman Kumar , Kaan Baloglu , Dheeraj Pandey , Krishna Kunchithapadam , Sujatha Muthulingam , Vipin Gokhale , Bharat Baddepudi
发明人: Nirman Kumar , Kaan Baloglu , Dheeraj Pandey , Krishna Kunchithapadam , Sujatha Muthulingam , Vipin Gokhale , Bharat Baddepudi
IPC分类号: G06F12/16
CPC分类号: G06F17/30318 , G06F17/3048
摘要: A method, system and computer program product are described for state maintenance of a large object. In one approach, the method, system and computer program product perform by associating one or more buffers with a transaction involving a large object, the large object data may be accessed using the one or more buffers during the transaction, and storing data for the large object from the one or more buffers in one or more sets of contiguous blocks.In one approach, a system performs state maintenance of a large object with a cache that associates one or more buffers with a transaction involving a large object, the large object data may be accessed using the one or more buffers during the transaction, and the cache stores large object data from the one or more buffers in one or more sets of contiguous blocks in storage.
摘要翻译: 描述了用于大对象的状态维护的方法,系统和计算机程序产品。 在一种方法中,方法,系统和计算机程序产品通过将一个或多个缓冲器与涉及大对象的事务相关联来执行,可以在事务期间使用一个或多个缓冲区来访问大对象数据,并且存储大的数据 一个或多个连续块集合中的一个或多个缓冲器的对象。 在一种方法中,系统使用将一个或多个缓冲器与涉及大对象的事务相关联的高速缓存执行大对象的状态维护,可以在事务期间使用一个或多个缓冲区来访问大对象数据,并且高速缓存 在存储中的一个或多个连续块集合中存储来自一个或多个缓冲器的大对象数据。
-
公开(公告)号: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
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.
摘要翻译: 提供了用于对由锁定机构管理的资源进行更改的技术。 实体(如数据库系统集群中的服务器实例)请求修改资源的权限。 响应于该请求,实体在资源上接收到第一个锁定,该权限允许对资源执行更改,而不会使更改永久性。 在接收到第一个锁定之后,实体对驻留在共享内存中的资源的副本执行更改,而不创建资源的另一个副本。 执行变更后,直到获得变更永久性的许可,实体将防止资源变为永久性。 执行更改后,实体将在资源上收到第二个锁定,该实体授予实体永久性更改权限。 收到第二个锁后,实体停止防止资源变为永久性。
-
公开(公告)号: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.
摘要翻译: 备用数据库系统或其他副本数据系统将对源数据库系统或其他主数据副本上的数据块进行的更改复制到备用数据库系统或其他副本上的数据块的副本。 在对其数据块进行复制的同时,备用数据库系统(或其他副本)接收对其发出的查询(或读取),并根据从其数据块读取的数据来计算查询。
-
公开(公告)号:US20080235291A1
公开(公告)日:2008-09-25
申请号: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.
摘要翻译: 备用数据库系统或其他副本数据系统将对源数据库系统或其他主数据副本上的数据块进行的更改复制到备用数据库系统或其他副本上的数据块的副本。 在对其数据块进行复制的同时,备用数据库系统(或其他副本)接收对其发出的查询(或读取),并根据从其数据块读取的数据来计算查询。
-
-
-
-
-
-
-