公开(公告)号：US10802766B2

公开(公告)日：2020-10-13

申请号：US15720959

申请日：2017-09-29

Applicant: Oracle International Corporation

Inventor： Nilesh Choudhury ,  Kothanda Umamageswaran ,  Krishnan Meiyyappan ,  Jia Shi ,  Vijay Sridharan ,  Zuoyu Tao ,  Kai Zhang ,  Semen Ustimenko ,  Salini Selvaraj Kowsalya ,  Somayeh Sardashti

IPC: G06F16/23 ,  G06F3/06 ,  G06F16/18 ,  G06F16/903

Abstract: A shared storage architecture persistently stores database files in non-volatile random access memories (NVRAMs) of computing nodes of a multi-node DBMS. The computing nodes of the multi-node DBMS not only collectively store database data on NVRAMs of the computing nodes, but also host database server instances that process queries in parallel, host database sessions and database processes, and together manage access to a database stored on the NVRAMs of the computing nodes. To perform a data block read operation from persistent storage, a data block may be transferred directly over a network between NVRAM of a computing node that persistently stores the data block to a database buffer in non-volatile RAM of another computing node that requests the data block. The transfer is accomplished using remote direct memory access (“RDMA).

公开(公告)号：US09361232B2

公开(公告)日：2016-06-07

申请号：US13839251

申请日：2013-03-15

Applicant: Oracle International Corporation

Inventor： 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/084 ,  G06F12/08 ,  G06F17/30

CPC classification number: G06F12/084 ,  G06F12/0811 ,  G06F12/0866 ,  G06F12/0888 ,  G06F17/3048 ,  G06F17/30492

Abstract: 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, or d) 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.

Abstract translation: 提供了使用中间缓存来提供扫描操作中涉及的一些项目的技术，而从主存储器提供涉及扫描操作的其他项目。 还提供了用于基于以下因素来确定是否对具有驻留在中间高速缓存中的项目的副本的项目的I / O请求进行服务的技术，例如：a）向其提交I / O请求的用户的身份 ，b）提交I / O请求的服务的身份，c）I / O请求所映射的消费者组的指示，或d）中间缓存是否过载。 还提供了基于与检索项目的请求相关联的逻辑特征来确定是否将项目存储在中间高速缓存中以响应于正被检索的项目的技术。

公开(公告)号：US10387447B2

公开(公告)日：2019-08-20

申请号：US14823212

申请日：2015-08-11

Applicant: Oracle International Corporation

Inventor： Nilesh Choudhury ,  Scott Martin ,  Zuoyu Tao ,  Jia Shi ,  Alexander Tsukerman ,  Kothanda Umamageswaran

IPC: G06F16/27 ,  G06F11/14 ,  G06F3/06

Abstract: Techniques herein are for creating a database snapshot by creating a sparse database. A method involves receiving a creation request to create a sparse database. The creation request has an identity of a parent database. The creation request is processed to create a sparse database. The sparse database has the identity of the parent database. The sparse database does not contain data copied from the parent database. A write request to write data into the sparse database is received. The write request is processed by writing the data into the sparse database. The parent database does not receive the data.

公开(公告)号：US20190102113A1

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

申请号：US15720959

申请日：2017-09-29

Applicant: Oracle International Corporation

Inventor： Nilesh Choudhury ,  Kothanda Umamageswaran ,  Krishnan Meiyyappan ,  Jia Shi ,  Vijay Sridharan ,  Zuoyu Tao ,  Kai Zhang ,  Semen Ustimenko ,  Salini Selvaraj Kowsalya ,  Somayeh Sardashti

IPC: G06F3/06 ,  G06F17/30

Abstract: A shared storage architecture persistently stores database files in non-volatile random access memories (NVRAMs) of computing nodes of a multi-node DBMS. The computing nodes of the multi-node DBMS not only collectively store database data on NVRAMs of the computing nodes, but also host database server instances that process queries in parallel, host database sessions and database processes, and together manage access to a database stored on the NVRAMs of the computing nodes. To perform a data block read operation from persistent storage, a data block may be transferred directly over a network between NVRAM of a computing node that persistently stores the data block to a database buffer in non-volatile RAM of another computing node that requests the data block. The transfer is accomplished using remote direct memory access (“RDMA).

公开(公告)号：US20250094384A1

公开(公告)日：2025-03-20

申请号：US18885231

申请日：2024-09-13

Applicant: Oracle International Corporation

Inventor： Nilesh Choudhury ,  Krishnan Meiyyappan ,  Semen Ustimenko ,  Boris Erlikhman ,  Siddharth Choudhary ,  Scott Martin

IPC: G06F16/11 ,  G06F16/174 ,  G06F16/22 ,  G06F16/27

Abstract: A database-aware storage server provides instant creation of snapshots without the need to create an intermediate test master database. During the snapshot creation time, the source database stays read-write and completes ongoing reads and writes. The database-aware storage server allows creation of layers of writable snapshots in a hierarchy. All these multiple databases share common data blocks. Any new writes performed by the database post snapshot are stored in blocks of sparse files. This promotes space sharing and reduces the total amount of space used by all these related databases. The allocations for the source and all new snapshot databases share the same common pool of storage. The newly created snapshot databases can access the data store directly without going through an intermediate layer.

公开(公告)号：US20130212332A1

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

申请号：US13839251

申请日：2013-03-15

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： 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

CPC classification number: G06F12/084 ,  G06F12/0811 ,  G06F12/0866 ,  G06F12/0888 ,  G06F17/3048 ,  G06F17/30492

Abstract: 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, or d) 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.

Abstract translation: 提供了使用中间缓存来提供扫描操作中涉及的一些项目的技术，而从主存储器提供涉及扫描操作的其他项目。 还提供了用于基于以下因素来确定是否对具有驻留在中间高速缓存中的项目的副本的项目的I / O请求进行服务的技术，例如：a）向其提交I / O请求的用户的身份 ，b）提交I / O请求的服务的身份，c）I / O请求所映射的消费者组的指示，或d）中间缓存是否过载。 还提供了基于与检索项目的请求相关联的逻辑特征来确定是否将项目存储在中间高速缓存中以响应于正被检索的项目的技术。

公开(公告)号：US20250094385A1

公开(公告)日：2025-03-20

申请号：US18885394

申请日：2024-09-13

Applicant: Oracle International Corporation

Inventor： Nilesh Choudhury ,  Juan R. Loaiza ,  Kothanda Umamageswaran ,  Jia Shi ,  Vijay Sridharan ,  Alexander Tsukerman ,  Siddharth Choudhary

IPC: G06F16/13

Abstract: Herein is an accelerated interface between a database server and a storage area network (SAN). Persistent torage being managed for a database is spread across a number of storage buckets. Global distributed storage metadata is used only for tracking the location of storage buckets on different storage servers. With this approach, a very small amount of memory is needed at a global distributed level to maintain the map. Each storage bucket can have any number of mirrored replicas for further increasing speed and reliability. A database server contains a storage bucket map in memory, and uses the map to do database online transaction processing (OLTP) I/O and smart (i.e. offloaded) database operations on storage. This allows for direct I/O between database server and storage server with lower latency and without using slow and remote middleware such as a logical unit number (LUN) metadata server on a separate network element.

公开(公告)号：US12254027B1

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

申请号：US18607314

申请日：2024-03-15

Applicant: Oracle International Corporation

Inventor： Saeed Abedigozalabad ,  Thakur Vishwesh Singh ,  Vijay Sridharan ,  Nilesh Choudhury ,  Mehrnoosh Raoufi

IPC: G06F16/27

Abstract: The illustrative embodiments provide a consensus protocol with a priority-based leadership election approach. Each server or node in the cluster has an associated priority based on the capabilities and capacities of the servers. The leadership election is divided into two phases: a term increase phase and an election voting phase. A candidate sends a message to peers in the cluster to determine whether all peers agree to allow the candidate to increase the term number. If there is no opposition, then the candidate increases the term number and then proceeds to the election voting phase. Each peer determines whether the candidate requesting the term increase has a log that is up to date. If the log of the candidate is equally as advanced as the peer's log, then the peer approves or opposes the term increase based on a priority comparison.

公开(公告)号：US10346362B2

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

申请号：US14849012

申请日：2015-09-09

Applicant: Oracle International Corporation

Inventor： Zuoyo Tao ,  Nilesh Choudhury ,  Scott Martin ,  Mingmin Chen ,  Jia Shi ,  Alexander Tsukerman ,  Kothanda Umamageswaran

IPC: G06F16/174 ,  G06F17/30

Abstract: Techniques herein are for accessing non-materialized blocks of a sparse file. A method involves a storage system receiving a storage command to access a sparse file. A combined content of a set of materialized blocks and a header that identifies one or more non-materialized blocks is assembled. The combined content does not comprise a content of the one or more non-materialized blocks. Responsive to the assembling, the combined content is transferred between the storage system and a computer system.

公开(公告)号：US20160092534A1

公开(公告)日：2016-03-31

申请号：US14823212

申请日：2015-08-11

Applicant: Oracle International Corporation

Inventor： Nilesh Choudhury ,  Scott Martin ,  Zuoyu Tao ,  Jia Shi ,  Alexander Tsukerman ,  Kothanda Umamageswaran

IPC: G06F17/30

CPC classification number: G06F16/27 ,  G06F3/0608 ,  G06F3/0617 ,  G06F11/1435 ,  G06F11/1458

Abstract: Techniques herein are for creating a database snapshot by creating a sparse database. A method involves receiving a creation request to create a sparse database. The creation request has an identity of a parent database. The creation request is processed to create a sparse database. The sparse database has the identity of the parent database. The sparse database does not contain data copied from the parent database. A write request to write data into the sparse database is received. The write request is processed by writing the data into the sparse database. The parent database does not receive the data.

Abstract translation: 这里的技术是通过创建稀疏数据库来创建数据库快照。 一种方法包括接收创建请求以创建稀疏数据库。 创建请求具有父数据库的标识。 处理创建请求以创建稀疏数据库。 稀疏数据库具有父数据库的身份。 稀疏数据库不包含从父数据库复制的数据。 接收到将数据写入稀疏数据库的写入请求。 通过将数据写入稀疏数据库来处理写入请求。 父数据库不接收数据。