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

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

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