公开(公告)号：WO2011031689A1

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

申请号：PCT/US2010/048023

申请日：2010-09-07

Applicant: ORACLE INTERNATIONAL CORPORATION ,  GOYAL, Kiran Badrinarain ,  HO, Eugene ,  LEE, Adam Y. ,  GOKHALE, Vipin ,  HU, Wei-Ming ,  LOAIZA, Juan R. ,  UMAMAGESWARAN, Kothanda ,  BADDEPUDI, Bharat C.V. ,  ERLIKHMAN, Boris ,  TSUKERMAN, Alexander ,  SELCUK, Aya ,  HANSEN, Roger ,  NG, Adrian

Inventor： GOYAL, Kiran Badrinarain ,  HO, Eugene ,  LEE, Adam Y. ,  GOKHALE, Vipin ,  HU, Wei-Ming ,  LOAIZA, Juan R. ,  UMAMAGESWARAN, Kothanda ,  BADDEPUDI, Bharat C.V. ,  ERLIKHMAN, Boris ,  TSUKERMAN, Alexander ,  SELCUK, Aya ,  HANSEN, Roger ,  NG, Adrian

IPC: G06F12/08 ,  G06F17/30

CPC classification number: G06F12/0866 ,  G06F12/084 ,  G06F12/0888 ,  G06F12/0897 ,  G06F17/30312 ,  G06F17/3048 ,  G06F2212/283 ,  G06F2212/311 ,  G06F2212/312 ,  G06F2212/465

Abstract: Techniques are provided for using an intermediate cache between the shared cache of an application and the non-volatile storage of a storage system. The application may be any type of application that uses a storage system to persistently store data. The intermediate cache may be local to the machine upon which the application is executing, or may be implemented within the storage system. In one embodiment where the application is a database server, 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 object an item belongs to, the item type of the item, a characteristic of the item, or the type of operation in which the item is involved.

Abstract translation: 提供了在应用的共享缓存和存储系统的非易失性存储之间使用中间缓存的技术。 应用程序可以是使用存储系统持久存储数据的任何类型的应用程序。 中间缓存可以是应用程序正在执行的机器本地，也可以在存储系统内实现。 在应用程序是数据库服务器的一个实施例中，数据库系统包括DB服务器侧中间缓存和存储侧中间缓存。 用于填充中间缓存的缓存策略是智能的，考虑到可能包括项目属于哪个对象，项目的项目类型，项目的特征或涉及项目的操作类型的因素 。

公开(公告)号：WO2014149615A1

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

申请号：PCT/US2014/019880

申请日：2014-03-03

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： LOAIZA, Juan ,  GANESH, Amit ,  MACNICOL, Roger ,  KAMP, Jesse ,  HOLLOWAY, Allison ,  NG, Adrian ,  MARWAH, Vineet

IPC: G06F17/30

CPC classification number: G06F12/0875 ,  G06F17/30312 ,  G06F17/3048

Abstract: A method for accelerating queries using dynamically generated columnar data in a flash cache is provided. In an embodiment, a method comprises a storage device receiving a first request for data that is stored in the storage device in a base major format in one or more primary storage devices. The storage device comprises a cache. The base major format is any one of: a row-major format, a column-major format and a hybrid-columnar format. Based on first one or more criteria, it is determined whether to rewrite the data into rewritten data in a rewritten major format. In response to determining to rewrite the data into rewritten data in a rewritten major format, the storage device rewrites at least a portion of the data into particular rewritten data in the rewritten major format. The rewritten data is stored in the cache.

Abstract translation: 提供了一种使用Flash缓存中的动态生成的列数据来加速查询的方法。 在一个实施例中，一种方法包括存储设备，其以一个或多个主存储设备中的主要主要格式接收存储在存储设备中的数据的第一请求。 存储设备包括高速缓存。 基本主要格式是以下主题之一：行主格式，列主格式和混合列格式。 基于第一个或多个标准，确定是否以重写的主要格式将数据重写为重写的数据。 响应于确定以重写的主要格式将数据重写为重写数据，存储设备将至少一部分数据重写为重写的主要格式的特定重写数据。 重写的数据存储在缓存中。

公开(公告)号：EP2478442B1

公开(公告)日：2020-08-12

申请号：EP10760825.9

申请日：2010-09-07

Applicant: Oracle International Corporation

Inventor： GOYAL, Kiran Badrinarain ,  HO, Eugene ,  LEE, Adam Y. ,  GOKHALE, Vipin ,  HU, Wei-Ming ,  LOAIZA, Juan R. ,  UMAMAGESWARAN, Kothanda ,  BADDEPUDI, Bharat C.V. ,  ERLIKHMAN, Boris ,  TSUKERMAN, Alexander ,  SELCUK, Aya ,  HANSEN, Roger ,  NG, Adrian

IPC: G06F12/0866 ,  G06F12/0888 ,  G06F12/0897

公开(公告)号：EP2973018A1

公开(公告)日：2016-01-20

申请号：EP14714833.2

申请日：2014-03-03

Applicant: Oracle International Corporation

Inventor： LOAIZA, Juan ,  GANESH, Amit ,  MACNICOL, Roger ,  KAMP, Jesse ,  HOLLOWAY, Allison ,  NG, Adrian ,  MARWAH, Vineet

IPC: G06F17/30

CPC classification number: G06F12/0875 ,  G06F17/30312 ,  G06F17/3048

Abstract: A method for accelerating queries using dynamically generated columnar data in a flash cache is provided. In an embodiment, a method comprises a storage device receiving a first request for data that is stored in the storage device in a base major format in one or more primary storage devices. The storage device comprises a cache. The base major format is any one of: a row-major format, a column-major format and a hybrid-columnar format. Based on first one or more criteria, it is determined whether to rewrite the data into rewritten data in a rewritten major format. In response to determining to rewrite the data into rewritten data in a rewritten major format, the storage device rewrites at least a portion of the data into particular rewritten data in the rewritten major format. The rewritten data is stored in the cache.

公开(公告)号：EP2478442A1

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

申请号：EP10760825.9

申请日：2010-09-07

Applicant: Oracle International Corporation

Inventor： GOYAL, Kiran Badrinarain ,  HO, Eugene ,  LEE, Adam Y. ,  GOKHALE, Vipin ,  HU, Wei-Ming ,  LOAIZA, Juan R. ,  UMAMAGESWARAN, Kothanda ,  BADDEPUDI, Bharat C.V. ,  ERLIKHMAN, Boris ,  TSUKERMAN, Alexander ,  SELCUK, Aya ,  HANSEN, Roger ,  NG, Adrian

IPC: G06F12/08 ,  G06F17/30

Abstract: 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.