公开(公告)号：US10592416B2

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

申请号：US13288785

申请日：2011-11-03

申请人： Bharat Chandra Baddepudi ,  Juan R. Loaiza ,  Wei-Ming Hu ,  Kothanda Umamageswaran ,  Alex Tsukerman ,  Boris Erlikhman ,  J. William Lee ,  Jia Shi ,  Kiran B. Goyal ,  Selcuk Aya

发明人： Bharat Chandra Baddepudi ,  Juan R. Loaiza ,  Wei-Ming Hu ,  Kothanda Umamageswaran ,  Alex Tsukerman ,  Boris Erlikhman ,  J. William Lee ,  Jia Shi ,  Kiran B. Goyal ,  Selcuk Aya

IPC分类号： G06F12/08 ,  G06F12/0868

摘要： A storage device uses non-volatile memory devices for caching. The storage device operates in a mode referred to herein as write-back mode. In write-back mode, a storage device responds to a request to write data by persistently writing the data to a cache in a non-volatile memory device and acknowledges to the requestor that the data is written persistently in the storage device. The acknowledgement is sent without necessarily having written the data that was requested to be written to primary storage. Instead, the data is written to primary storage later.

公开(公告)号：US10430338B2

公开(公告)日：2019-10-01

申请号：US12691146

申请日：2010-01-21

申请人： Kothanda Umamageswaran ,  Juan R. Loaiza ,  Umesh Panchaksharaiah ,  Alexander Tsukerman ,  Timothy L. Shetler ,  Bharat C. V. Baddepudi ,  Boris Erlikhman ,  Kiran B. Goyal ,  Nilesh Choudhury ,  Susy Fan ,  Poojan Kumar ,  Selcuk Aya ,  Sue-Kyoung Lee

发明人： Kothanda Umamageswaran ,  Juan R. Loaiza ,  Umesh Panchaksharaiah ,  Alexander Tsukerman ,  Timothy L. Shetler ,  Bharat C. V. Baddepudi ,  Boris Erlikhman ,  Kiran B. Goyal ,  Nilesh Choudhury ,  Susy Fan ,  Poojan Kumar ,  Selcuk Aya ,  Sue-Kyoung Lee

IPC分类号： G06F12/08 ,  G06F12/084 ,  G06F16/2455 ,  G06F12/0888 ,  G06F12/0811 ,  G06F12/0866

摘要： Techniques are provided for using an intermediate cache to provide some of the items involved in a scan operation, while other items involved in the scan operation are provided from primary storage. Techniques are also provided for determining whether to service an I/O request for an item with a copy of the item that resides in the intermediate cache based on factors such as a) an identity of the user for whom the I/O request was submitted, b) an identity of a service that submitted the I/O request, c) an indication of a consumer group to which the I/O request maps, d) whether the I/O request is associated with an offloaded filter provided by the database server to the storage system, or e) whether the intermediate cache is overloaded. Techniques are also provided for determining whether to store items in an intermediate cache in response to the items being retrieved, based on logical characteristics associated with the requests that retrieve the items.

公开(公告)号：US20100122026A1

公开(公告)日：2010-05-13

申请号：US12691146

申请日：2010-01-21

申请人： Kothanda Umamageswaran ,  Juan R. Loaiza ,  Umesh Panchaksharaiah ,  Alexander Tsukerman ,  Timothy L. Shetler ,  Bharat C.V. Baddepudi ,  Boris Erlikhman ,  Kiran B. Goyal ,  Nilesh Choudhury ,  Susy Fan ,  Poojan Kumar ,  Selcuk Aya ,  Sue-Kyoung Lee

发明人： Kothanda Umamageswaran ,  Juan R. Loaiza ,  Umesh Panchaksharaiah ,  Alexander Tsukerman ,  Timothy L. Shetler ,  Bharat C.V. Baddepudi ,  Boris Erlikhman ,  Kiran B. Goyal ,  Nilesh Choudhury ,  Susy Fan ,  Poojan Kumar ,  Selcuk Aya ,  Sue-Kyoung Lee

IPC分类号： G06F12/08 ,  G06F12/00

CPC分类号： G06F12/084 ,  G06F12/0811 ,  G06F12/0866 ,  G06F12/0888 ,  G06F16/24552 ,  G06F16/24557

摘要： Techniques are provided for using an intermediate cache to provide some of the items involved in a scan operation, while other items involved in the scan operation are provided from primary storage. Techniques are also provided for determining whether to service an I/O request for an item with a copy of the item that resides in the intermediate cache based on factors such as a) an identity of the user for whom the I/O request was submitted, b) an identity of a service that submitted the I/O request, c) an indication of a consumer group to which the I/O request maps, d) whether the I/O request is associated with an offloaded filter provided by the database server to the storage system, or e) whether the intermediate cache is overloaded. Techniques are also provided for determining whether to store items in an intermediate cache in response to the items being retrieved, based on logical characteristics associated with the requests that retrieve the items.

摘要翻译： 提供了使用中间缓存来提供扫描操作中涉及的一些项目的技术，而从主存储器提供涉及扫描操作的其他项目。 还提供了用于基于以下因素来确定是否对具有驻留在中间高速缓存中的项目的副本的项目的I / O请求进行服务的技术，例如：a）向其提交I / O请求的用户的身份 b）提交I / O请求的服务的身份，c）I / O请求所映射的消费者组的指示，d）I / O请求是否与由所述I / O请求提供的卸载过滤器相关联 数据库服务器到存储系统，或e）中间缓存是否重载。 还提供了基于与检索项目的请求相关联的逻辑特征来确定是否将项目存储在中间高速缓存中以响应于正被检索的项目的技术。

公开(公告)号：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服务器侧中间缓存和存储侧中间缓存。 用于填充中间缓存的缓存策略是智能的，考虑到可能包括项目属于哪个数据库对象的因素，项目的项目类型，项目的特征; 或涉及项目的数据库操作。

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

IPC分类号： G06F12/08 ,  G06F17/30

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服务器侧中间缓存和存储侧中间缓存。 用于填充中间缓存的缓存策略是智能的，考虑到可能包括项目属于哪个数据库对象的因素，项目的项目类型，项目的特征; 或涉及项目的数据库操作。

公开(公告)号：US20130326152A1

公开(公告)日：2013-12-05

申请号：US13485557

申请日：2012-05-31

申请人： Juan R. Loaiza ,  KOTHANDA UMAMAGESWARAN ,  BORIS ERLIKHMAN ,  DAVID FRIEDMAN ,  JIA SHI ,  ZUOYU TAO ,  ALEX TSUKERMAN

发明人： Juan R. Loaiza ,  KOTHANDA UMAMAGESWARAN ,  BORIS ERLIKHMAN ,  DAVID FRIEDMAN ,  JIA SHI ,  ZUOYU TAO ,  ALEX TSUKERMAN

IPC分类号： G06F12/08

CPC分类号： G06F11/2082 ,  G06F3/0629 ,  G06F12/00 ,  G06F12/08 ,  G06F12/0802

摘要： Dirty data in a storage device is made current through rapid re-silvering, which uses a mirrored and up-to-date version of the dirty data from another storage device to recover the data. Because under rapid re-silvering cache metadata in volatile memory survives the failure of the cache, the cache metadata is used to determine which subset of data from the other storage device needs to be copied to the storage device being re-silvered. During re-silvering, cache metadata is used to determine which I/O requests from clients are requests for data that is not stale.

摘要翻译： 存储设备中的脏数据通过快速重新刷新而成为最新版本，其使用来自另一存储设备的镜像和最新版本的脏数据来恢复数据。 因为在快速重新刷新缓存中，缓存中的元数据可以在高速缓存的故障中幸存下来，所以使用高速缓存元数据来确定来自其他存储设备的哪个数据子集需要被复制到被重新映射的存储设备。 在重新镀银期间，使用缓存元数据来确定来自客户端的哪些I / O请求是不过时的数据请求。

公开(公告)号：US09063908B2

公开(公告)日：2015-06-23

申请号：US13485557

申请日：2012-05-31

申请人： Juan R. Loaiza ,  Kothanda Umamageswaran ,  Boris Erlikhman ,  David Friedman ,  Jia Shi ,  Zuoyu Tao ,  Alex Tsukerman

发明人： Juan R. Loaiza ,  Kothanda Umamageswaran ,  Boris Erlikhman ,  David Friedman ,  Jia Shi ,  Zuoyu Tao ,  Alex Tsukerman

IPC分类号： G06F12/00 ,  G06F11/20 ,  G06F3/06 ,  G06F12/08

CPC分类号： G06F11/2082 ,  G06F3/0629 ,  G06F12/00 ,  G06F12/08 ,  G06F12/0802

摘要： Dirty data in a storage device is made current through rapid re-silvering, which uses a mirrored and up-to-date version of the dirty data from another storage device to recover the data. Because under rapid re-silvering cache metadata in volatile memory survives the failure of the cache, the cache metadata is used to determine which subset of data from the other storage device needs to be copied to the storage device being re-silvered. During re-silvering, cache metadata is used to determine which I/O requests from clients are requests for data that is not stale.

摘要翻译： 存储设备中的脏数据通过快速重新刷新而成为最新版本，其使用来自另一存储设备的镜像和最新版本的脏数据来恢复数据。 因为在快速重新刷新缓存中，缓存中的元数据可以在高速缓存的故障中幸存下来，所以使用高速缓存元数据来确定来自其他存储设备的哪个数据子集需要被复制到被重新映射的存储设备。 在重新镀银期间，使用缓存元数据来确定来自客户端的哪些I / O请求是不过时的数据请求。

公开(公告)号：US08909996B2

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

申请号：US13346656

申请日：2012-01-09

申请人： Kesavan P. Srinivasan ,  Boris Erlikhman ,  Juan R. Loaiza ,  Jia Shi ,  Alexander Tsukerman ,  Kothanda Umamageswaran

发明人： Kesavan P. Srinivasan ,  Boris Erlikhman ,  Juan R. Loaiza ,  Jia Shi ,  Alexander Tsukerman ,  Kothanda Umamageswaran

IPC分类号： G06F11/00 ,  G06F11/14 ,  G06F11/20

CPC分类号： G06F11/1443 ,  G06F11/1471 ,  G06F11/2074 ,  G06F17/30377

摘要： Methods, computer-readable media, and computer systems are provided for initiating storage of data on multiple storage devices and confirming storage of the data after the data has been stored on one but not necessarily all of the devices. A storage server receives, from a client, a request to store data. In response to the request, the storage server initiates, in parallel, storage of the data on multiple storage systems. The storage server detects that the data has been stored on any one of the storage systems, such as an auxiliary system, and, in response, indicates, to the client, that the data has been stored. The storage server may flush or discard data on the auxiliary storage system upon detecting that the data has been successfully stored on a target storage system, where the data persists.

摘要翻译： 提供方法，计算机可读介质和计算机系统用于在多个存储设备上启动数据的存储，并且在数据已经存储在一个但不一定是所有设备上之后确认数据的存储。 存储服务器从客户端接收存储数据的请求。 响应于该请求，存储服务器并行地发起数据在多个存储系统上的存储。 存储服务器检测到数据已经存储在诸如辅助系统的任何一个存储系统上，并且作为响应，向客户端指示已经存储了数据。 检测到数据已被成功存储在数据持续存在的目标存储系统上时，存储服务器可以刷新或丢弃辅助存储系统上的数据。

公开(公告)号：US20130042156A1

公开(公告)日：2013-02-14

申请号：US13346656

申请日：2012-01-09

申请人： Kesavan P. Srinivasan ,  Boris Erlikhman ,  Juan R. Loaiza ,  Jia Shi ,  Alexander Tsukerman ,  Kothanda Umamageswaran

发明人： Kesavan P. Srinivasan ,  Boris Erlikhman ,  Juan R. Loaiza ,  Jia Shi ,  Alexander Tsukerman ,  Kothanda Umamageswaran

IPC分类号： G06F11/14 ,  G06F15/16

CPC分类号： G06F11/1443 ,  G06F11/1471 ,  G06F11/2074 ,  G06F17/30377

摘要： Methods, computer-readable media, and computer systems are provided for initiating storage of data on multiple storage devices and confirming storage of the data after the data has been stored on one but not necessarily all of the devices. A storage server receives, from a client, a request to store data. In response to the request, the storage server initiates, in parallel, storage of the data on multiple storage systems. The storage server detects that the data has been stored on any one of the storage systems, such as an auxiliary system, and, in response, indicates, to the client, that the data has been stored. The storage server may flush or discard data on the auxiliary storage system upon detecting that the data has been successfully stored on a target storage system, where the data persists.

摘要翻译： 提供方法，计算机可读介质和计算机系统用于在多个存储设备上启动数据的存储，并且在数据已经存储在一个但不一定是所有设备上之后确认数据的存储。 存储服务器从客户端接收存储数据的请求。 响应于该请求，存储服务器并行地发起数据在多个存储系统上的存储。 存储服务器检测到数据已经存储在诸如辅助系统的任何一个存储系统上，并且作为响应，向客户端指示已经存储了数据。 检测到数据已被成功存储在数据持续存在的目标存储系统上时，存储服务器可以刷新或丢弃辅助存储系统上的数据。

公开(公告)号：US5890167A

公开(公告)日：1999-03-30

申请号：US852968

申请日：1997-05-08

申请人： William H. Bridge, Jr. ,  Jonathan D. Klein ,  J. William Lee ,  Juan R. Loaiza ,  Alex Tsukerman ,  GianFranco Putzolu

发明人： William H. Bridge, Jr. ,  Jonathan D. Klein ,  J. William Lee ,  Juan R. Loaiza ,  Alex Tsukerman ,  GianFranco Putzolu

IPC分类号： G06F17/30

CPC分类号： G06F17/30339 ,  Y10S707/99942 ,  Y10S707/99953 ,  Y10S707/99955

摘要： A pluggable tablespace is enabled by logically partitioning a database into a set of tablespaces and storing all of the tablespaces disk pointers in tablespace-relative format. A pluggable set of tablespaces is unplugged by exporting the associated metadata, and making a binary copy of the tablespaces. The pluggable set of tablespaces is plugged into a target database by making the pluggable set accessible to the target database and importing the associated metadata, without patching any of the disk pointers.

摘要翻译： 通过将数据库逻辑分区为一组表空间并以表空间相对格式存储所有表空间磁盘指针来启用可插入表空间。 通过导出相关联的元数据并创建表空间的二进制副本，可以插拔一组表空间。 可插拔的表空间集合通过使可插入集合可访问目标数据库并导入相关联的元数据而插入到目标数据库中，而无需修补任何磁盘指针。