公开(公告)号：WO2022081394A1

公开(公告)日：2022-04-21

申请号：PCT/US2021/053819

申请日：2021-10-06

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： KAMP, Jesse ,  HOLLOWAY, Allison L. ,  HSU, Meichun ,  KIMURA, Hideaki ,  KLOTS, Boris ,  KRISHNASWAMY, Vasudha ,  KULKARNI, Kartik ,  LEE, Teck Hua ,  LI, Yunrui ,  MISHRA, Aurosish ,  MYLAVARAPU, Ajit ,  PENDSE, Sukhada ,  SWART, Garret F. ,  CHAVAN, Shasank K. ,  LAHIRI, Tirthankar ,  LOAIZA, Juan R.

IPC: G06F16/27

Abstract: A shared-nothing database system is provided in which the rows of each table are assigned to "slices", and multiple copies ("duplicas") of each slice are stored across the persistent storage of multiple nodes. Requests to read data from a particular row of the table may be handled by any node that stores a duplica of the slice to which the row is assigned. For each slice, a single duplica of the slice is designated as the "primary duplica". All DML operations are performed by the node that has the primary duplica of the slice to which the target row is assigned. The changes are then propagated other duplicas ("secondary duplicas") of the same slice.

公开(公告)号：WO2022081396A1

公开(公告)日：2022-04-21

申请号：PCT/US2021/053822

申请日：2021-10-06

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： KRISHNASWAMY, Vasudha ,  PENDSE, Sukhada ,  KOLAHI, Solmaz ,  KUMAR, Ankita ,  MYLAVARAPU, Ajit ,  SWART, Garret F. ,  LAHIRI, Tirthankar ,  LOAIZA, Juan R.

IPC: G06F16/27 ,  G06F16/23 ,  G06F16/2455

Abstract: A shared-nothing database system is provided in which the rows of each table are assigned to "slices", and multiple copies ("duplicas") of each slice are stored across the persistent storage of multiple nodes. Requests to read data from a particular row of the table may be handled by any node that stores a duplica of the slice to which the row is assigned. For each slice, a single duplica of the slice is designated as the "primary duplica". All DML operations are performed by the node that has the primary duplica of the slice to which the target row is assigned. The changes are then propagated other duplicas ("secondary duplicas") of the same slice.

公开(公告)号：WO2019046632A1

公开(公告)日：2019-03-07

申请号：PCT/US2018/048939

申请日：2018-08-30

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： LOAIZA, Juan R. ,  LEE, J. William ,  HU, Wei-Ming ,  UMAMAGESWARAN, Kothanda ,  MACNAUGHTON, Neil J.S. ,  LEE, Adam Y.

IPC: G06F12/0868 ,  G06F12/0866 ,  G06F17/30

Abstract: Techniques for implementing a buffer cache for a persistent file system in non-volatile memory is provided. A set of data is maintained in one or more extents in non-volatile random-access memory (NVRAM) of a computing device. At least one buffer header is allocated in dynamic random-access memory (DRAM) of the computing device. In response to a read request by a first process executing on the computing device to access one or more first data blocks in a first extent of the one or more extents, the first process is granted direct read access of the first extent in NVRAM. A reference to the first extent in NVRAM is stored in a first buffer header. The first buffer header is associated with the first process. The first process uses the first buffer header to directly access the one or more first data blocks in NVRAM.

公开(公告)号：WO2022081397A1

公开(公告)日：2022-04-21

申请号：PCT/US2021/053824

申请日：2021-10-06

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： MYLAVARAPU, Ajit ,  KRISHNASWAMY, Vasudha ,  PENDSE, Sukhada ,  KOLAHI, Solmaz ,  KUMAR, Ankita ,  SWART, Garret F. ,  LAHIRI, Tirthankar ,  LOAIZA, Juan R.

IPC: G06F16/27 ,  G06F16/23 ,  G06F16/2455

Abstract: A shared-nothing database system is provided in which the rows of each table are assigned to "slices", and multiple copies ("duplicas") of each slice are stored across the persistent storage of multiple nodes. Requests to read data from a particular row of the table may be handled by any node that stores a duplica of the slice to which the row is assigned. For each slice, a single duplica of the slice is designated as the "primary duplica". All DML operations are performed by the node that has the primary duplica of the slice to which the target row is assigned. The changes are then propagated other duplicas ("secondary duplicas") of the same slice.

公开(公告)号：WO2022081395A1

公开(公告)日：2022-04-21

申请号：PCT/US2021/053820

申请日：2021-10-06

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： BRIDGE, William H. Jr. ,  BROWER, David ,  HSU, Meichun ,  KLOTS, Boris ,  MACNAUGHTON, Neil J S ,  MYLAVARAPU, Ajit ,  PANCHAKSHARAIAH, Umesh ,  SWART, Garret F. ,  LAHIRI, Tirthankar ,  LOAIZA, Juan R.

IPC: G06F16/21 ,  G06F16/215

Abstract: A shared-nothing database system is provided in which the rows of each table are assigned to "slices", and multiple copies ("duplicas") of each slice are stored across the persistent storage of multiple nodes. Requests to read data from a particular row of the table may be handled by any node that stores a duplica of the slice to which the row is assigned. For each slice, a single duplica of the slice is designated as the "primary duplica". All DML operations are performed by the node that has the primary duplica of the slice to which the target row is assigned. The changes are then propagated other duplicas ("secondary duplicas") of the same slice.

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

公开(公告)号：WO2021050292A1

公开(公告)日：2021-03-18

申请号：PCT/US2020/048420

申请日：2020-08-28

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： LEE, J. William ,  BRIDGE, JR., William H. ,  KEMKAR, Ankur ,  GOKHALE, Vipin ,  SOMA, Sivaram Prasad ,  SELVAKUMAAR, Vishvesh Mohanarangam ,  LOAIZA, Juan R. ,  HU, Wei-Ming ,  MACNAUGHTON, Neil J.S. ,  LEE, Adam Y.

IPC: G06F16/23 ,  G06F16/25 ,  G06F16/28

Abstract: Techniques herein store database blocks (DBBs) in byte-addressable persistent memory (PMEM) and prevent tearing without deadlocking or waiting. In an embodiment, a computer hosts a DBMS. A reader process of the DBMS obtains, without locking and from metadata in PMEM, a first memory address for directly accessing a current version, which is a particular version, of a DBB in PMEM. Concurrently and without locking: a) the reader process reads the particular version of the DBB in PMEM, and b) a writer process of the DBMS replaces, in the metadata in PMEM, the first memory address with a second memory address for directly accessing a new version of the DBB in PMEM. In an embodiment, a computer performs without locking: a) storing, in PMEM, a DBB, b) copying into volatile memory, or reading, an image of the DBB, and c) detecting whether the image of the DBB is torn.

公开(公告)号：WO2019067937A1

公开(公告)日：2019-04-04

申请号：PCT/US2018/053487

申请日：2018-09-28

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： TAO, Zuoyo ,  SHI, Jia ,  UMAMAGESWARAN, Kothanda ,  LOAIZA, Juan R.

IPC: G06F12/0864 ,  G06F12/0868

Abstract: Data blocks are cached in a persistent cache ("NV cache") allocated from as non-volatile RAM ("NVRAM"). The data blocks may be accessed in place in the NV cache of a "source" computing element by another "remote" computing element over a network using remote direct memory access ("RMDA"). In order for a remote computing element to access the data block in NV cache on a source computing element, the remote computing element needs the memory address of the data block within the NV cache. For this purpose, a hash table is stored and maintained in RAM on the source computing element. The hash table identifies the data blocks in the NV cache and specifies a location of the cached data block within the NV cache.

公开(公告)号：WO2017070627A1

公开(公告)日：2017-04-27

申请号：PCT/US2016/058329

申请日：2016-10-22

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： MACNICOL, Roger D. ,  SHAH, Viral ,  HUA, Xia ,  KAMP, Jesse ,  CHAVAN, Shasank K. ,  COLGAN, Maria ,  LAHIRI, Tirthankar ,  NG, Adrian Tsz Him ,  MEIYYAPPAN, Krishnan ,  GANESH, Amit ,  LOAIZA, Juan R. ,  UMAMAGESWARAN, Kothanda ,  QIN, Yiran

IPC: G06F17/30

CPC classification number: G06F17/30457 ,  G06F3/061 ,  G06F3/0647 ,  G06F3/065 ,  G06F3/067 ,  G06F12/0811 ,  G06F12/0897 ,  G06F17/30312 ,  G06F17/30315 ,  G06F2212/1016 ,  G06F2212/163 ,  G06F2212/225

Abstract: Techniques are provided for storing in in-memory unit (IMU) in a lower-storage tier and copying the IMU to DRAM when needed for query processing. Techniques are also provided for copying IMUs to lower tiers of storage when evicted from the cache of higher tiers of storage. Techniques are provided for implementing functionality of IMUs within a storage system, to enable database servers to push tasks, such as filtering, to the storage system where the storage system may access IMUs within its own memory to perform the tasks. Metadata associated with a set of data may be used to indicate whether an IMU for the data should be created by the database server machine or within the storage system.

Abstract translation: 提供了用于在较低存储层中的内存单元（IMU）中存储以及在需要进行查询处理时将IMU复制到DRAM的技术。 还提供了一些技术，用于将IMU复制到从较高层存储缓存中逐出时的较低存储层。 提供了用于在存储系统内实现IMU的功能的技术，以使数据库服务器能够将诸如过滤之类的任务推送到存储系统，其中存储系统可以访问其自己的存储器内的IMU以执行任务。 与一组数据相关联的元数据可以用于指示数据的IMU应该由数据库服务器机器还是存储系统创建。

公开(公告)号：WO2013025523A1

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

申请号：PCT/US2012/050386

申请日：2012-08-10

Applicant: ORACLE INTERNATIONAL CORPORATION ,  SRINIVASAN, Kesavan P. ,  ERLIKHMAN, Boris ,  LOAIZA, Juan R. ,  SHI, Jia ,  TSUKERMAN, Alexander ,  UMAMAGESWARAN, Kothanda

Inventor： SRINIVASAN, Kesavan P. ,  ERLIKHMAN, Boris ,  LOAIZA, Juan R. ,  SHI, Jia ,  TSUKERMAN, Alexander ,  UMAMAGESWARAN, Kothanda

IPC: G06F11/14 ,  G06F11/20

CPC classification number: G06F11/1443 ,  G06F11/1471 ,  G06F11/2074 ,  G06F17/30377

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

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