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

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

公开(公告)号：US11086876B2

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

申请号：US15721328

申请日：2017-09-29

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

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.

公开(公告)号：US10678788B2

公开(公告)日：2020-06-09

申请号：US15331599

申请日：2016-10-21

Applicant: Oracle International Corporation

Inventor： Roger D. Macnicol ,  Viral Shah ,  Xia Hua ,  Jesse Kamp ,  Shasank K. Chavan ,  Maria Colgan ,  Tirthankar Lahiri ,  Adrian Tsz Him Ng ,  Krishnan Meiyyappan ,  Amit Ganesh ,  Juan R. Loaiza ,  Kothanda Umamageswaran ,  Yiran Qin

IPC: G06F16/2453 ,  G06F16/22 ,  G06F3/06 ,  G06F12/0811 ,  G06F12/0897

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.

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

公开(公告)号：US20170116269A1

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

申请号：US15331599

申请日：2016-10-21

Applicant: Oracle International Corporation

Inventor： Roger D. Macnicol ,  Viral Shah ,  Xia Hua ,  Jesse Kamp ,  Shasank K. Chavan ,  Maria Colgan ,  Tirthankar Lahiri ,  Adrian Tsz Him Ng ,  Krishnan Meiyyappan ,  Amit Ganesh ,  Juan R. Loaiza ,  Kothanda Umamageswaran ,  Yiran Qin

IPC: G06F17/30 ,  G06F12/0811 ,  G06F12/0897 ,  G06F3/06

CPC classification number: G06F16/24539 ,  G06F3/061 ,  G06F3/0647 ,  G06F3/065 ,  G06F3/067 ,  G06F12/0811 ,  G06F12/0897 ,  G06F16/22 ,  G06F16/221 ,  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.

公开(公告)号：US10936616B2

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

申请号：US14733691

申请日：2015-06-08

Applicant: Oracle International Corporation

Inventor： Dmitry Mikhailovich Potapov ,  Krishnan Meiyyappan ,  Alexander Tsukerman ,  Kothanda Umamageswaran ,  Semen Ustimenko ,  Wei Zhang ,  Adrian Tsz Him Ng ,  Daniel McClary ,  Allen Brumm ,  James Stenoish ,  Robert K. Abbott

IPC: G06F16/2453 ,  G06F16/25

Abstract: A storage system communicatively coupled to a database management system (DBMS performs storage-side scanning of data sources that are not stored in native database storage format of the DBMS. Data sources for external tables are accessible in a storage system referred to as a distributed data access system (DDAS), e.g. a Hadoop Distributed File System. To execute a query that references an external table, a DBMS first generates an execution plan. The DDAS supplies the DBMS with information that specifies each portion of the data source, and specifies which data node to use to access the portion. The DBMS sends a request for each portion to the respective data node, requesting that the data node generate rows from data in the portion. The request may specify scanning criteria, specifying one or more columns to project and/or filter on, and code modules for the data node to execute to generate records.

公开(公告)号：US20150356158A1

公开(公告)日：2015-12-10

申请号：US14733691

申请日：2015-06-08

Applicant: Oracle International Corporation

Inventor： Dmitry Mikhailovich Potapov ,  Krishnan Meiyyappan ,  Alexander Tsukerman ,  Kothanda Umamageswaran ,  Semen Ustimenko ,  Wei Zhang ,  Adrian Tsz Him Ng ,  Daniel McClary ,  Allen Brumm ,  James Stenoish ,  Robert K. Abbott

IPC: G06F17/30

Abstract: A storage system communicatively coupled to a DBMS performs storage-side scanning of data sources that are not stored in the native database storage format of the DBMS. Data sources for external tables are accessible in a storage system referred to herein as a distributed data access system, e.g. a Hadoop Distributed File System. To execute a query that references an external table, a DBMS first generates an execution plan. The distributed data access system supplies the DBMS with information that specifies each portion of the data source, and specifies which data node to use to access the portion. The DBMS sends a request for each portion to the respective data node, the request requesting that the data node generate rows from data in the portion. The request may specify scanning criteria, specifying one or more columns to project and/or filter on. The request may also specify code modules for the data node to execute to generate rows or records and columns.

Abstract translation: 通信地耦合到DBMS的存储系统对不存储在DBMS的本地数据库存储格式的数据源执行存储侧扫描。 用于外部表的数据源可在本文称为分布式数据访问系统的存储系统中访问，例如， 一个Hadoop分布式文件系统。 要执行引用外部表的查询，DBMS首先生成执行计划。 分布式数据访问系统向DBMS提供指定数据源的每个部分的信息，并指定要用于访问该部分的数据节点。 DBMS向每个数据节点发送每个部分的请求，该请求请求数据节点从该部分中的数据生成行。 请求可以指定扫描条件，指定一个或多个列进行投影和/或过滤。 该请求还可以指定用于数据节点执行的代码模块以生成行或记录和列。