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

公开(公告)号：US11775527B2

公开(公告)日：2023-10-03

申请号：US17356827

申请日：2021-06-24

Applicant: Oracle International Corporation

Inventor： Krishnan Meiyyappan ,  Semen Ustimenko ,  Adrian Tsz Him Ng ,  Kothanda Umamageswaran

IPC: G06F16/00 ,  G06F16/2455 ,  G06F7/08 ,  G06F16/22 ,  G11C16/10 ,  G11C5/14

CPC classification number: G06F16/24561 ,  G06F7/08 ,  G06F16/2282 ,  G11C5/143 ,  G11C16/10

Abstract: Region summaries of database data are stored in persistent memory of a storage cell. Because the region summaries are stored in persistent memory, when a storage cell is powered off and data in volatile memory is not retained, region summaries are nevertheless preserved in persistent memory. When the storage cell comes online, the region summaries already exist and may be used without the delay attendant to regenerating the region summaries stored in volatile memory.

公开(公告)号：US10042781B2

公开(公告)日：2018-08-07

申请号：US15268524

申请日：2016-09-16

Applicant: Oracle International Corporation

Inventor： Roger D. MacNicol ,  Tirthankar Lahiri ,  Kothanda Umamageswaran ,  Adrian Tsz Him Ng ,  Laura Liaoruo Wang ,  Krishnan Meiyyappan

IPC: G06F17/30 ,  G06F12/14 ,  H04L9/06

Abstract: Techniques are described herein for generating and using in-memory data structures to represent columns in data block sets. In an embodiment, a database management system (DBMS) receives a query for a target data set managed by the DBMS. The query may specify a predicate for a column of the target data set. The predicate may include a filtering value to be compared with row values of the column of the target data set. Prior to accessing data block sets storing the target data set from persistent storage, the DBMS identifies an in-memory summary that corresponds to a data block set, in an embodiment. The in-memory summary may include in-memory data structures, each representing a column stored in the data block set. The DBMS determines that a particular in-memory data structure exists in the in-memory summary that represents a portion of values of the column indicated in the predicate of the query. Based on the particular in-memory data structure, the DBMS determines whether or not the data block set can possibly contain the filtering value in the column of the target data set. Based on this determination, the DBMS skips or retrieves the data block set from the persistent storage as part of the query evaluation.

公开(公告)号：US20170206199A1

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

申请号：US15410496

申请日：2017-01-19

Applicant: Oracle International Corporation

Inventor： Kothanda Umamageswaran ,  Krishnan Meiyyappan ,  Adrian Tsz Him Ng ,  Vijay Sridharan ,  Wei Zhang ,  Ke Hu ,  Xin Zeng

IPC: G06F17/30 ,  G06F3/06

CPC classification number: G06F16/24552 ,  G06F16/27

Abstract: According to embodiments, a derived cache that is derived from a first instance of particular data is used to speed up queries and other operations over a second instance of the particular data. Traditionally, a DBMS generates and uses derived cache data only for the database data from which the derived data was derived. However, according to embodiments, derived cache data associated with a first instance of database data is relocated to the location of a second, newly created, instance of the database data. Since the derived cache data is derived from an identical copy of the database data, the cache data derived for the first instance can successfully be used to speed up applications running over the second instance of the database data.

公开(公告)号：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查询的数据请求，并且服务于 请求与存储层的单元服务器协调。

公开(公告)号：US20210326343A1

公开(公告)日：2021-10-21

申请号：US17356827

申请日：2021-06-24

Applicant: Oracle International Corporation

Inventor： Krishnan Meiyyappan ,  Semen Ustimenko ,  Adrian Tsz Him Ng ,  Kothanda Umamageswaran

IPC: G06F16/2455 ,  G06F7/08 ,  G06F16/22

Abstract: Region summaries of database data are stored in persistent memory of a storage cell. Because the region summaries are stored in persistent memory, when a storage cell is powered off and data in volatile memory is not retained, region summaries are nevertheless preserved in persistent memory. When the storage cell comes online, the region summaries already exist and may be used without the delay attendant to regenerating the region summaries stored in volatile memory.

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

公开(公告)号：US10198363B2

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

申请号：US15268524

申请日：2016-09-16

Applicant: Oracle International Corporation

Inventor： Roger D. MacNicol ,  Tirthankar Lahiri ,  Kothanda Umamageswaran ,  Adrian Tsz Him Ng ,  Laura Liaoruo Wang ,  Krishnan Meiyyappan

IPC: G06F17/30 ,  G06F12/14 ,  H04L9/06

Abstract: Techniques are described herein for generating and using in-memory data structures to represent columns in data block sets. In an embodiment, a database management system (DBMS) receives a query for a target data set managed by the DBMS. The query may specify a predicate for a column of the target data set. The predicate may include a filtering value to be compared with row values of the column of the target data set. Prior to accessing data block sets storing the target data set from persistent storage, the DBMS identifies an in-memory summary that corresponds to a data block set, in an embodiment. The in-memory summary may include in-memory data structures, each representing a column stored in the data block set. The DBMS determines that a particular in-memory data structure exists in the in-memory summary that represents a portion of values of the column indicated in the predicate of the query. Based on the particular in-memory data structure, the DBMS determines whether or not the data block set can possibly contain the filtering value in the column of the target data set. Based on this determination, the DBMS skips or retrieves the data block set from the persistent storage as part of the query evaluation.

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

公开(公告)号：US20190102433A1

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

申请号：US15721328

申请日：2017-09-29

Applicant: Oracle International Corporation

Inventor： Krishnan Meiyyappan ,  Semen Ustimenko ,  Adrian Tsz Him Ng ,  Kothanda Umamageswaran

IPC: G06F17/30 ,  G06F7/08 ,  G11C16/10

Abstract: Region summaries of database data are stored in persistent memory of a storage cell. Because the region summaries are stored in persistent memory, when a storage cell is powered off and data in volatile memory is not retained, region summaries are nevertheless preserved in persistent memory. When the storage cell comes online, the region summaries already exist and may be used without the delay attendant to regenerating the region summaries stored in volatile memory.