公开(公告)号：US10296462B2

公开(公告)日：2019-05-21

申请号：US13840811

申请日：2013-03-15

Applicant: Oracle International Corporation

Inventor： Juan Loaiza ,  Amit Ganesh ,  Roger Macnicol ,  Jesse Kamp ,  Allison Holloway ,  Adrian Ng ,  Vineet Marwah

IPC: G06F12/08 ,  G06F12/0875 ,  G06F16/22 ,  G06F16/2455

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.

公开(公告)号：US20150006813A1

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

申请号：US14487358

申请日：2014-09-16

Applicant: Oracle International Corporation

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

公开(公告)号：US09898490B2

公开(公告)日：2018-02-20

申请号：US14313984

申请日：2014-06-24

Applicant: Oracle International Corporation

Inventor： Umesh Panchaksharaiah ,  Krishnan Meiyyappan ,  Kothanda Umamageswaran ,  Alex Tsukerman ,  Semen Ustimenko ,  Adrian Ng ,  Devang Mundhra ,  Yinian Qi

IPC: G06F17/30

CPC classification number: G06F17/30339 ,  G06F17/30289

Abstract: Techniques are described herein for supporting multiple versions of a database server within a database machine comprising a separate database layer and storage layer. In an embodiment, the database layer includes compute nodes each hosting one or more instances of a database server. The storage layer includes storage nodes each hosting one or more instances of a storage server, also referred to herein as a “cell server.” In general, the database servers may receive data requests, such as SQL queries, from client applications and service the requests in coordination with the cell servers of the storage layer.

公开(公告)号：US20140281247A1

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

申请号：US13840811

申请日：2013-03-15

Applicant: Oracle International Corporation

Inventor： Juan Loaiza ,  Amit Ganesh ,  Roger Macnicol ,  Jesse Kamp ,  Allison Holloway ,  Adrian Ng ,  Vineet Marwah

IPC: G06F12/08

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

公开(公告)号：US09405694B2

公开(公告)日：2016-08-02

申请号：US14487358

申请日：2014-09-16

Applicant: Oracle International Corporation

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

公开(公告)号：US20150088880A1

公开(公告)日：2015-03-26

申请号：US14313984

申请日：2014-06-24

Applicant: Oracle International Corporation

Inventor： Umesh Panchaksharaiah ,  Krishnan Meiyyappan ,  Kothanda Umamageswaran ,  Alex Tsukerman ,  Semen Ustimenko ,  Adrian Ng ,  Devang Mundhra ,  Yinian Qi

IPC: G06F17/30

CPC classification number: G06F17/30339 ,  G06F17/30289

Abstract: Techniques are described herein for supporting multiple versions of a database server within a database machine comprising a separate database layer and storage layer. In an embodiment, the database layer includes compute nodes each hosting one or more instances of a database server. The storage layer includes storage nodes each hosting one or more instances of a storage server, also referred to herein as a “cell server.” In general, the database servers may receive data requests, such as SQL queries, from client applications and service the requests in coordination with the cell servers of the storage layer.

Abstract translation: 这里描述了用于支持数据库机器中的多个版本的技术，该数据库机器包括单独的数据库层和存储层。 在一个实施例中，数据库层包括每个托管数据库服务器的一个或多个实例的计算节点。 存储层包括每个托管存储服务器的一个或多个实例的存储节点，在本文中也称为“小区服务器”。通常，数据库服务器可以从客户端应用接收诸如SQL查询的数据请求，并且服务于 请求与存储层的单元服务器协调。

公开(公告)号：US10528590B2

公开(公告)日：2020-01-07

申请号：US14726372

申请日：2015-05-29

Applicant: Oracle International Corporation

Inventor： Adrian Ng ,  Krishnan Meiyyappan ,  Alexander Tsukerman ,  Dmitry Potapov

IPC: G06F3/06 ,  G06F16/22 ,  G06F16/27

Abstract: Techniques for optimizing a query with an extrema function are provided. In main memory, a data summary is maintained for a plurality of extents stored by at least one storage server. The data summary includes an extent minimum value and an extent maximum value for one or more columns. A storage server request is received, from a database server, based on a query with an extrema function applied to a particular column of a particular table. The data summaries for a set of relevant extents are processed by maintaining at least one global extrema value corresponding to the extrema function and, for each relevant extent of the set of relevant extents, determining whether to scan records of the relevant extent based on at least one of the global extrema value and an extent summary value of the data summary of the relevant extent.

公开(公告)号：US09715517B2

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

申请号：US14313984

申请日：2014-06-24

Applicant: Oracle International Corporation

Inventor： Umesh Panchaksharaiah ,  Krishnan Meiyyappan ,  Kothanda Umamageswaran ,  Alex Tsukerman ,  Semen Ustimenko ,  Adrian Ng ,  Devang Mundhra ,  Yinian Qi

IPC: G06F17/30

Abstract: Techniques are described herein for supporting multiple versions of a database server within a database machine comprising a separate database layer and storage layer. In an embodiment, the database layer includes compute nodes each hosting one or more instances of a database server. The storage layer includes storage nodes each hosting one or more instances of a storage server, also referred to herein as a “cell server.” In general, the database servers may receive data requests, such as SQL queries, from client applications and service the requests in coordination with the cell servers of the storage layer.