公开(公告)号：US20100077107A1

公开(公告)日：2010-03-25

申请号：US12563073

申请日：2009-09-18

申请人： Sue K. Lee ,  Vivekananda C. Kolla ,  Akshay D. Shah ,  Sumanta Chatterjee ,  Margaret Susairaj ,  Juan R. Loaiza ,  Alexander Tsukerman ,  Sridhar Subramaniam

发明人： Sue K. Lee ,  Vivekananda C. Kolla ,  Akshay D. Shah ,  Sumanta Chatterjee ,  Margaret Susairaj ,  Juan R. Loaiza ,  Alexander Tsukerman ,  Sridhar Subramaniam

IPC分类号： G06F13/00 ,  G06F3/00

CPC分类号： G06F17/30498 ,  G06F3/0611 ,  G06F3/0659 ,  G06F3/067 ,  G06F12/00 ,  G06F17/3033 ,  G06F17/30492

摘要： Techniques are provided for managing, within a storage system, the sequence in which I/O requests are processed by the storage system based, at least in part, on a one or more logical characteristics of the I/O requests. The logical characteristics may include, for example, the identity of the user for whom the I/O request was submitted, the service that submitted the I/O request, the database targeted by the I/O request, an indication of a consumer group to which the I/O request maps, the reason why the I/O request was issued, a priority category of the I/O request, etc. Techniques are also provided for automatically establishing a scheduling policy within a storage system, and for dynamically changing the scheduling policy in response to changes in workload.

摘要翻译： 提供了技术，用于至少部分地基于I / O请求的一个或多个逻辑特性，在存储系统内管理由存储系统处理I / O请求的序列。 逻辑特征可以包括例如提交I / O请求的用户的身份，提交I / O请求的服务，I / O请求所针对的数据库，消费者组的指示 I / O请求映射到哪里，发出I / O请求的原因，I / O请求的优先类别等。还提供了用于在存储系统内自动建立调度策略，并且为了动态地 根据工作负载的变化改变调度策略。

公开(公告)号：US08521923B2

公开(公告)日：2013-08-27

申请号：US13418150

申请日：2012-03-12

申请人： Sue K. Lee ,  Vivekananda C. Kolla ,  Akshay D. Shah ,  Sumanta Chatterjee ,  Margaret Susairaj ,  Juan R. Loaiza ,  Alexander Tsukerman ,  Sridhar Subramaniam

发明人： Sue K. Lee ,  Vivekananda C. Kolla ,  Akshay D. Shah ,  Sumanta Chatterjee ,  Margaret Susairaj ,  Juan R. Loaiza ,  Alexander Tsukerman ,  Sridhar Subramaniam

IPC分类号： G06F3/00

CPC分类号： G06F17/30498 ,  G06F3/0611 ,  G06F3/0659 ,  G06F3/067 ,  G06F12/00 ,  G06F17/3033 ,  G06F17/30492

摘要： Techniques are provided for managing, within a storage system, the sequence in which I/O requests are processed by the storage system based, at least in part, on one or more logical characteristics of the I/O requests. The logical characteristics may include, for example, the identity of the user for whom the I/O request was submitted, the service that submitted the I/O request, the database targeted by the I/O request, an indication of a consumer group to which the I/O request maps, the reason why the I/O request was issued, a priority category of the I/O request, etc. Techniques are also provided for automatically establishing a scheduling policy within a storage system, and for dynamically changing the scheduling policy in response to changes in workload.

摘要翻译： 提供了技术，用于至少部分地基于I / O请求的一个或多个逻辑特性在存储系统内管理由存储系统处理I / O请求的序列。 逻辑特征可以包括例如提交I / O请求的用户的身份，提交I / O请求的服务，I / O请求所针对的数据库，消费者组的指示 I / O请求映射到哪里，发出I / O请求的原因，I / O请求的优先类别等。还提供了用于在存储系统内自动建立调度策略，并且为了动态地 根据工作负载的变化改变调度策略。

公开(公告)号：US08145806B2

公开(公告)日：2012-03-27

申请号：US12563073

申请日：2009-09-18

申请人： Sue K. Lee ,  Vivekananda C. Kolla ,  Akshay D. Shah ,  Sumanta Chatterjee ,  Margaret Susairaj ,  Juan R. Loaiza ,  Alexander Tsukerman ,  Sridhar Subramaniam

发明人： Sue K. Lee ,  Vivekananda C. Kolla ,  Akshay D. Shah ,  Sumanta Chatterjee ,  Margaret Susairaj ,  Juan R. Loaiza ,  Alexander Tsukerman ,  Sridhar Subramaniam

IPC分类号： G06F3/00

CPC分类号： G06F17/30498 ,  G06F3/0611 ,  G06F3/0659 ,  G06F3/067 ,  G06F12/00 ,  G06F17/3033 ,  G06F17/30492

摘要： Techniques are provided for managing, within a storage system, the sequence in which I/O requests are processed by the storage system based, at least in part, on a one or more logical characteristics of the I/O requests. The logical characteristics may include, for example, the identity of the user for whom the I/O request was submitted, the service that submitted the I/O request, the database targeted by the I/O request, an indication of a consumer group to which the I/O request maps, the reason why the I/O request was issued, a priority category of the I/O request, etc. Techniques are also provided for automatically establishing a scheduling policy within a storage system, and for dynamically changing the scheduling policy in response to changes in workload.

摘要翻译： 提供了技术，用于至少部分地基于I / O请求的一个或多个逻辑特性，在存储系统内管理由存储系统处理I / O请求的序列。 逻辑特征可以包括例如提交I / O请求的用户的身份，提交I / O请求的服务，I / O请求所针对的数据库，消费者组的指示 I / O请求映射到哪里，发出I / O请求的原因，I / O请求的优先类别等。还提供了用于在存储系统内自动建立调度策略，并且为了动态地 根据工作负载的变化改变调度策略。

公开(公告)号：US20120173774A1

公开(公告)日：2012-07-05

申请号：US13418150

申请日：2012-03-12

申请人： Sue K. Lee ,  Vivekananda C. Kolla ,  Akshav D. Shah ,  Sumanta Chatterjee ,  Margaret Susairaj ,  Juan R. Loaiza ,  Alexander Tsukerman ,  Sridhar Subramaniam

发明人： Sue K. Lee ,  Vivekananda C. Kolla ,  Akshav D. Shah ,  Sumanta Chatterjee ,  Margaret Susairaj ,  Juan R. Loaiza ,  Alexander Tsukerman ,  Sridhar Subramaniam

IPC分类号： G06F3/00

CPC分类号： G06F17/30498 ,  G06F3/0611 ,  G06F3/0659 ,  G06F3/067 ,  G06F12/00 ,  G06F17/3033 ,  G06F17/30492

摘要： Techniques are provided for managing, within a storage system, the sequence in which I/O requests are processed by the storage system based, at least in part, on one or more logical characteristics of the I/O requests. The logical characteristics may include, for example, the identity of the user for whom the I/O request was submitted, the service that submitted the I/O request, the database targeted by the I/O request, an indication of a consumer group to which the I/O request maps, the reason why the I/O request was issued, a priority category of the I/O request, etc. Techniques are also provided for automatically establishing a scheduling policy within a storage system, and for dynamically changing the scheduling policy in response to changes in workload.

摘要翻译： 提供了技术，用于至少部分地基于I / O请求的一个或多个逻辑特性在存储系统内管理由存储系统处理I / O请求的序列。 逻辑特征可以包括例如提交I / O请求的用户的身份，提交I / O请求的服务，I / O请求所针对的数据库，消费者组的指示 I / O请求映射到哪里，发出I / O请求的原因，I / O请求的优先类别等。还提供了用于在存储系统内自动建立调度策略，并且为了动态地 根据工作负载的变化改变调度策略。

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

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

公开(公告)号：US08935227B2

公开(公告)日：2015-01-13

申请号：US13449192

申请日：2012-04-17

申请人： Johnny Quan Zhou ,  Nilesh Choudhury ,  Juan R. Loaiza ,  Dmitry Mikhailovich Potapov ,  Alexander Tsukerman ,  Kothanda Umamageswaran

发明人： Johnny Quan Zhou ,  Nilesh Choudhury ,  Juan R. Loaiza ,  Dmitry Mikhailovich Potapov ,  Alexander Tsukerman ,  Kothanda Umamageswaran

IPC分类号： G06F17/30

CPC分类号： G06F17/30492 ,  G06F17/3048

摘要： In a consumer-producer distributed model of computing, consumers request data from producers and perform computing work on the data received from the producers, thereby transforming the data. At least some of the computing work performed by a consumer on data provided by the producer is commutable between the consumer and producer, that is, either the producer as well as the consumer can perform the computing work on the data. A producer redistributes commutable based on the work load of the producer and consumer as well as other factors.

摘要翻译： 在消费者生产者分布式计算模式中，消费者从生产者那里请求数据，并对从生产者接收的数据执行计算工作，从而转换数据。 消费者对生产者提供的数据执行的至少一些计算工作在消费者和生产者之间是可交换的，也就是说，生产者以及消费者可以对数据执行计算工作。 生产者根据生产者和消费者的工作量以及其他因素重新分配可交换的生产者和消费者。

公开(公告)号：US20130275402A1

公开(公告)日：2013-10-17

申请号：US13449192

申请日：2012-04-17

申请人： Johnny Quan Zhou ,  Nilesh Choudhury ,  Juan R. Loaiza ,  Dmitry Mikhailovich Potapov ,  Alexander Tsukerman ,  Kothanda Umamageswaran

发明人： Johnny Quan Zhou ,  Nilesh Choudhury ,  Juan R. Loaiza ,  Dmitry Mikhailovich Potapov ,  Alexander Tsukerman ,  Kothanda Umamageswaran

IPC分类号： G06F17/30 ,  G06F15/173

CPC分类号： G06F17/30492 ,  G06F17/3048

摘要： In a consumer-producer distributed model of computing, consumers request data from producers and perform computing work on the data received from the producers, thereby transforming the data. At least some of the computing work performed by a consumer on data provided by the producer is commutable between the consumer and producer, that is, either the producer as well as the consumer can perform the computing work on the data. A producer redistributes commutable based on the work load of the producer and consumer as well as other factors.

摘要翻译： 在消费者生产者分布式计算模式中，消费者从生产者那里请求数据，并对从生产者接收的数据执行计算工作，从而转换数据。 消费者对生产者提供的数据执行的至少一些计算工作在消费者和生产者之间是可交换的，也就是说，生产者以及消费者可以对数据执行计算工作。 生产者根据生产者和消费者的工作量以及其他因素重新分配可交换的生产者和消费者。

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

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

公开(公告)号：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）中间缓存是否重载。 还提供了基于与检索项目的请求相关联的逻辑特征来确定是否将项目存储在中间高速缓存中以响应于正被检索的项目的技术。