公开(公告)号：US10572469B2

公开(公告)日：2020-02-25

申请号：US15169013

申请日：2016-05-31

Applicant: Oracle International Corporation

Inventor： Atrayee Mullick ,  Niloy Mukherjee ,  Sanket Hase ,  Tirthankar Lahiri ,  Juan Loaiza

IPC: G06F17/30 ,  G06F16/23 ,  G06F16/11 ,  G06F16/18 ,  G06F11/14

Abstract: Techniques for non-disruptive versioning of in-memory units in a database are provided. A database server generates and maintains a first IMU that reflects changes made to a mirrored-data-set up to a first snapshot time, and a second IMU that reflects changes made to the mirrored-data-set up to a second snapshot time. During a first period, the database server responds to updates to first data items in the mirrored data by storing first staleness metadata that indicates that the copies of the first data items in the first IMU are stale. During a second period, the database server responds to updates to second data items in the mirrored data by storing second staleness metadata that indicates that the copies of the second data items in the second IMU are stale. The database server responds to a request by accessing the first IMU or the second IMU.

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

公开(公告)号：US20140164696A1

公开(公告)日：2014-06-12

申请号：US14101306

申请日：2013-12-09

Applicant: Oracle International Corporation

Inventor： Dmitry Potapov ,  Cetin Ozbutun ,  Juan Loaiza ,  Kirk Bradley

IPC: G06F3/06

CPC classification number: G06F3/0689 ,  G06F3/0604 ,  G06F3/064 ,  G06F12/0207 ,  G06F12/0246 ,  G06F12/0607 ,  G06F2212/7208

Abstract: A method, device, and computer readable medium for striping rows of data across logical units of storage with an affinity for columns is provided. Alternately, a method, device, and computer readable medium for striping columns of data across logical units of storage with an affinity for rows is provided. When data of a logical slice is requested, a mapping may provide information for determining which logical unit is likely to store the logical slice. In one embodiment, data is retrieved from logical units that are predicted to store the logical slice. In another embodiment, data is retrieved from several logical units, and the data not mapped to the logical unit is removed from the retrieved data.

Abstract translation: 提供了一种方法，设备和计算机可读介质，用于跨逻辑存储单元条带化数据行，并且具有对列的亲和性。 或者，提供了一种方法，设备和计算机可读介质，用于以对行进行亲和度的跨存储的逻辑单元条带化数据列。 当请求逻辑片的数据时，映射可以提供用于确定哪个逻辑单元可能存储逻辑片的信息。 在一个实施例中，从预测存储逻辑片的逻辑单元检索数据。 在另一个实施例中，从多个逻辑单元检索数据，并且从所检索的数据中去除未映射到逻辑单元的数据。

公开(公告)号：US10250510B2

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

申请号：US14488161

申请日：2014-09-16

Applicant: Oracle International Corporation

Inventor： Vijay Sridharan ,  Richard Frank ,  Jia Shi ,  Kothanda Umamageswaran ,  Juan Loaiza ,  Alexander Tsukerman ,  Bang Nguyen ,  Sumanta Chatterjee

IPC: G06F15/16 ,  H04L12/851 ,  H04L29/08

Abstract: A method and apparatus for intelligent network resource manager for distributed computing systems is provided. A first priority is assigned to a first virtual channel set that includes at least two virtual channels of a plurality of virtual channels associated with a physical communication channel. A second priority is assigned to a second virtual channel set that includes at least one virtual channel of the plurality of virtual channels. The first virtual channel set has more virtual channels than the second virtual channel set. Outbound messages of the first priority are directed to virtual channels of the first virtual channel set. Outbound messages of the second priority are directed to virtual channels of the second virtual channel set. The virtual channels are processed in a round-robin order, where processing includes sending the outbound messages over the physical communication channel.

公开(公告)号：US11586641B2

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

申请号：US16726059

申请日：2019-12-23

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Niloy Mukherjee ,  Kartik Kulkarni ,  Tirthankar Lahiri ,  Vineet Marwah ,  Juan Loaiza

IPC: G06F16/2458 ,  H04L43/0817 ,  H04L41/0668 ,  H04L41/12

Abstract: Techniques are described herein for executing queries on distinct portions of a database object that has been separate into chunks and distributed across the volatile memories of a plurality of nodes in a clustered database system. The techniques involve redistributing the in-memory database object portions on changes to the clustered database system. Each node may maintain a mapping indicating which nodes in the clustered database system store which chunks, and timestamps indicating when each mapping entry was created or updated. A query coordinator may use the timestamps to select a database server instance with local in memory access to data required by a portion of a query to process that portion of the query.

公开(公告)号：US10248471B2

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

申请号：US15267104

申请日：2016-09-15

Applicant: Oracle International Corporation

Inventor： Raunak Rungta ,  Jonathan Giloni ,  Ravi Shankar Thammaiah ,  Sumanta Kumar Chatterjee ,  Juan Loaiza

IPC: G06F9/46 ,  G06F9/52 ,  G06F1/24

Abstract: Systems for managing shared computing resources. In a multi-process computing environment a concurrency object data structure pertaining to a shared resource is made available to be accessed by two or more processing entities. The concurrency object comprises a consecutive read count that tracks the number of consecutive read requests that have been received for shared read access to the shared resource. A shared concurrency access state is entered based on comparison of the consecutive read count to a threshold value. Entering the shared concurrency access state begins a period during which grant of further shared access requests do not require semaphore operations or other atomic operations that pertains to the shared resource.

公开(公告)号：US20170344593A1

公开(公告)日：2017-11-30

申请号：US15169013

申请日：2016-05-31

Applicant: Oracle International Corporation

Inventor： Atrayee Mullick ,  Niloy Mukherjee ,  Sanket Hase ,  Tirthankar Lahiri ,  Juan Loaiza

IPC: G06F17/30 ,  G06F11/14

CPC classification number: G06F16/2329 ,  G06F11/1446 ,  G06F11/1451 ,  G06F16/128 ,  G06F16/1873 ,  G06F16/2358 ,  G06F16/24552 ,  G06F16/258 ,  G06F16/273 ,  G06F2201/80 ,  G06F2201/84

Abstract: Techniques for non-disruptive versioning of in-memory units in a database are provided. A database server generates and maintains a first IMU that reflects changes made to a mirrored-data-set up to a first snapshot time, and a second IMU that reflects changes made to the mirrored-data-set up to a second snapshot time. During a first period, the database server responds to updates to first data items in the mirrored data by storing first staleness metadata that indicates that the copies of the first data items in the first IMU are stale. During a second period, the database server responds to updates to second data items in the mirrored data by storing second staleness metadata that indicates that the copies of the second data items in the second IMU are stale. The database server responds to a request by accessing the first IMU or the second IMU.

公开(公告)号：US20130024612A1

公开(公告)日：2013-01-24

申请号：US13633091

申请日：2012-10-01

Applicant: Oracle International Corporation

Inventor： Dmitry Potapov ,  Cetin Ozbutun ,  Juan Loaiza ,  Kirk Bradley

IPC: G06F12/00

CPC classification number: G06F3/0689 ,  G06F3/0604 ,  G06F3/064 ,  G06F12/0207 ,  G06F12/0246 ,  G06F12/0607 ,  G06F2212/7208

Abstract: A method, device, and computer readable medium for striping rows of data across logical units of storage with an affinity for columns is provided. Alternately, a method, device, and computer readable medium for striping columns of data across logical units of storage with an affinity for rows is provided. When data of a logical slice is requested, a mapping may provide information for determining which logical unit is likely to store the logical slice. In one embodiment, data is retrieved from logical units that are predicted to store the logical slice. In another embodiment, data is retrieved from several logical units, and the data not mapped to the logical unit is removed from the retrieved data.

Abstract translation: 提供了一种方法，设备和计算机可读介质，用于跨逻辑存储单元条带化数据行，并且具有对列的亲和性。 或者，提供了一种方法，设备和计算机可读介质，用于以对行进行亲和度的跨存储的逻辑单元条带化数据列。 当请求逻辑片的数据时，映射可以提供用于确定哪个逻辑单元可能存储逻辑片的信息。 在一个实施例中，从预测存储逻辑片的逻辑单元检索数据。 在另一个实施例中，从多个逻辑单元检索数据，并且从所检索的数据中去除未映射到逻辑单元的数据。

公开(公告)号：US11086902B2

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

申请号：US16144126

申请日：2018-09-27

Applicant: Oracle International Corporation

Inventor： Steven McGee ,  Jiangbin Luo ,  Benedicto Garin ,  Mahesh Girkar ,  Michael Harvey ,  Nitin Karkhanis ,  Steve Lee ,  Juan Loaiza ,  Robert McGuirk ,  Hongjie Yang

IPC: G06F16/27

Abstract: Disclosed are methods and apparatuses to provide a redo repeater that allows for no data loss protection without the performance impact to the primary database even when a significant geographical distance separates the primary and standby databases. The Repeater is a lightweight entity that receives redo from the primary database with the purpose of redistributing that redo throughout the primary/standby system configuration. The Repeater able to extend no data loss protection and switchover functionality to terminal standby databases even though the primary database does not need to have a direct connection with those destinations.

公开(公告)号：US10742560B2

公开(公告)日：2020-08-11

申请号：US16287521

申请日：2019-02-27

Applicant: Oracle International Corporation

Inventor： Vijay Sridharan ,  Richard Frank ,  Jia Shi ,  Kothanda Umamageswaran ,  Juan Loaiza ,  Alexander Tsukerman ,  Bang Nguyen ,  Sumanta Chatterjee

IPC: H04L12/851 ,  H04L29/08

Abstract: A method and apparatus for intelligent network resource manager for distributed computing systems is provided. A first priority is assigned to a first virtual channel set that includes at least two virtual channels of a plurality of virtual channels associated with a physical communication channel. A second priority is assigned to a second virtual channel set that includes at least one virtual channel of the plurality of virtual channels. The first virtual channel set has more virtual channels than the second virtual channel set. Outbound messages of the first priority are directed to virtual channels of the first virtual channel set. Outbound messages of the second priority are directed to virtual channels of the second virtual channel set. The virtual channels are processed in a round-robin order, where processing includes sending the outbound messages over the physical communication channel.