公开(公告)号：US11829349B2

公开(公告)日：2023-11-28

申请号：US14709018

申请日：2015-05-11

Applicant: Oracle International Corporation

Inventor： Tirthankar Lahiri ,  Derek Taylor ,  Nagender Bandi ,  John Miller ,  Chi-Kim Hoang ,  Ryder Rishel ,  Varadarajan Aravamudhan ,  Chih-Ping Wang ,  Susan Cheung ,  Samuel Drake ,  Paul Tuck ,  David Aspinwall

IPC: G06F16/23 ,  G06F16/27

CPC classification number: G06F16/2379 ,  G06F16/27

Abstract: A database is stored as a plurality of database shards in a distributed database grid comprising a plurality of grid elements, each including a mid-tier database system. A first grid element receives, from an application executing in the same memory as a mid-tier database system of the first grid element, a first database transaction including at least one database operation on specific data stored in a first database shard that belongs to the first grid element. The first grid element performs and commits the first database transaction without participation of another grid element of the plurality of grid elements. The first grid element receives a second database transaction that requires access to another database shard that does not belong to the first grid element. Multiple grid elements of the plurality of grid elements perform the second database transaction and commit the second database transaction using a two-phase commit protocol.

公开(公告)号：US11709784B2

公开(公告)日：2023-07-25

申请号：US17214564

申请日：2021-03-26

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Hideaki Kimura ,  Garret F. Swart ,  Spyros Blanas ,  Tirthankar Lahiri ,  Juan R. Loaiza ,  Jesse Kamp ,  Avneesh Pant

IPC: G06F13/00 ,  G06F12/1081 ,  G06F16/23 ,  G06F15/173

CPC classification number: G06F12/1081 ,  G06F15/17331 ,  G06F16/2379 ,  G06F2212/621

Abstract: Techniques are described for offloading remote direct memory operations (RDMOs) to “execution candidates”. The execution candidates may be any hardware capable of performing the offloaded operation. Thus, the execution candidates may be network interface controllers, specialized co-processors, FPGAs, etc. The execution candidates may be on a machine that is remote from the processor that is offloading the operation, or may be on the same machine as the processor that is offloading the operation. Details for certain specific RDMOs, which are particularly useful in online transaction processing (OLTP) and hybrid transactional/analytical (HTAP) workloads, are provided.

公开(公告)号：US11449458B2

公开(公告)日：2022-09-20

申请号：US17071169

申请日：2020-10-15

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Tirthankar Lahiri ,  Juan R. Loaiza ,  Garret F. Swart ,  Jesse Kamp ,  Avneesh Pant ,  Hideaki Kimura

IPC: G06F9/455 ,  G06F9/54 ,  G06F15/173 ,  G06F15/167

Abstract: Techniques are provided to allow more sophisticated operations to be performed remotely by machines that are not fully functional. Operations that can be performed reliably by a machine that has experienced a hardware and/or software error are referred to herein as Remote Direct Memory Operations or “RDMOs”. Unlike RDMAs, which typically involve trivially simple operations such as the retrieval of a single value from the memory of a remote machine, RDMOs may be arbitrarily complex. The techniques described herein can help applications run without interruption when there are software faults or glitches on a remote system with which they interact.

公开(公告)号：US11409733B2

公开(公告)日：2022-08-09

申请号：US16948306

申请日：2020-09-11

Applicant: Oracle International Corporation

Inventor： Teck Hua Lee ,  Tirthankar Lahiri ,  Yunrui Li

IPC: G06F16/23 ,  G06F16/22

Abstract: An approach is described to provide a method, a computer program product, and a computer system to implement hole punching. The described approach provides an automated way to free up space without requiring manual intervention by a DBA to manually reorganize database objects to free up space.

公开(公告)号：US11379403B2

公开(公告)日：2022-07-05

申请号：US17071174

申请日：2020-10-15

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Tirthankar Lahiri ,  Juan R. Loaiza ,  Garret F. Swart ,  Jesse Kamp ,  Avneesh Pant ,  Hideaki Kimura

IPC: G06F9/54 ,  G06F15/167 ,  G06F15/173 ,  G06F9/455

Abstract: Techniques are provided to allow more sophisticated operations to be performed remotely by machines that are not fully functional. Operations that can be performed reliably by a machine that has experienced a hardware and/or software error are referred to herein as Remote Direct Memory Operations or “RDMOs”. Unlike RDMAs, which typically involve trivially simple operations such as the retrieval of a single value from the memory of a remote machine, RDMOs may be arbitrarily complex. The techniques described herein can help applications run without interruption when there are software faults or glitches on a remote system with which they interact.

公开(公告)号：US11334445B2

公开(公告)日：2022-05-17

申请号：US16232860

申请日：2018-12-26

Applicant: Oracle International Corporation

Inventor： Tirthankar Lahiri ,  Martin Reames ,  Kao Makino ,  Ananth Raghavan ,  Chih-Ping Wang ,  Mutsumi Kogawa ,  Jorge Luis Issa Garcia

IPC: G06F16/23 ,  G06F11/14

Abstract: In an in-memory database management system, non-volatile random access memories (NVRAMs) are used to store database data and control data. Because this data is stored in NVRAM, the data survives system failures. Recovery from a system failure may be accomplished more quickly by, at least in part, modifying the surviving data in NVRAM, rather than loading an entire checkpoint image and applying uncheckpointed transactions needed to synchronize the database. Because in this form of recovery the database state that serves as the starting point for applying change records is the database as stored in the NVRAM, this form of recovery is referred to herein as in-memory-based recovery. Recovery, where the database state that serves as the starting point for applying change records is a checkpoint image, is referred to herein as checkpointed-based recovery. In-memory-based recovery eliminates or reduces the need to perform certain operations that are performed for checkpointed-based recovery.

公开(公告)号：US10474653B2

公开(公告)日：2019-11-12

申请号：US15281718

申请日：2016-09-30

Applicant: Oracle International Corporation

Inventor： Niloy Mukherjee ,  Jesse Kamp ,  Tirthankar Lahiri ,  Maria Colgan ,  Vivekanandhan Raja ,  Vasudha Krishnaswamy ,  Aditi Gupta ,  Kartik Kulkarni

IPC: G06F16/22 ,  G06F3/06 ,  G06F16/27 ,  G06F16/2455

Abstract: Techniques are described herein for distributing distinct portions of a database object across volatile memories of selected nodes of a plurality of nodes in a clustered database system. The techniques involve storing a unit-to-service mapping that associates a unit (a database object or portion thereof) to one or more database services. The one or more database services are mapped to one or more nodes. The nodes to which a service is mapped may include nodes in disjoint database systems, so long as those database systems have access to a replica of the unit. The database object is treated as in-memory enabled by nodes that are associated with the service, and are treated as not in-memory enabled by nodes that are not associated with the service.

公开(公告)号：US20190095346A1

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

申请号：US16144926

申请日：2018-09-27

Applicant: Oracle International Corporation

Inventor： Hariharan Lakshmanan ,  Dhruvil Shah ,  Prashant Gaharwar ,  Shasank K. Chavan ,  Tirthankar Lahiri ,  Saraswathy Narayan

IPC: G06F12/126 ,  G06F17/30

Abstract: Techniques related to automatic cache management are disclosed. In some embodiments, one or more non-transitory storage media store instructions which, when executed by one or more computing devices, cause performance of an automatic cache management method when a determination is made to store a first set of data in a cache. The method involves determining whether an amount of available space in the cache is less than a predetermined threshold. When the amount of available space in the cache is less than the predetermined threshold, a determination is made as to whether a second set of data has a lower ranking than the first set of data by at least a predetermined amount. When the second set of data has a lower ranking than the first set of data by at least the predetermined amount, the second set of data is evicted. Thereafter, the first set of data is cached.

公开(公告)号：US10133667B2

公开(公告)日：2018-11-20

申请号：US15257754

申请日：2016-09-06

Applicant: Oracle International Corporation

Inventor： Niloy Mukherjee ,  Tirthankar Lahiri ,  Juan R. Loaiza ,  Jesse Kamp ,  Prashant Gaharwar ,  Hariharan Lakshmanan ,  Dhruvil Shah

IPC: G06F12/08 ,  G06F3/06 ,  G06F17/30

Abstract: Techniques related to efficient data storage and retrieval using a heterogeneous main memory are disclosed. A database includes a set of persistent format (PF) data that is stored on persistent storage in a persistent format. The database is maintained on the persistent storage and is accessible to a database server. The database server converts the set of PF data to sets of mirror format (MF) data and stores the MF data in a hierarchy of random-access memories (RAMs). Each RAM in the hierarchy has an associated latency that is different from a latency associated with any other RAM in the hierarchy. Storing the sets of MF data in the hierarchy of RAMs includes (1) selecting, based on one or more criteria, a respective RAM in the hierarchy to store each set of MF data and (2) storing said each set of MF data in the respective RAM.

公开(公告)号：US10120895B2

公开(公告)日：2018-11-06

申请号：US15877125

申请日：2018-01-22

Applicant: Oracle International Corporation

Inventor： Jesse Kamp ,  Amit Ganesh ,  Vineet Marwah ,  Vivekanandhan Raja ,  Tirthankar Lahiri ,  Allison L. Holloway ,  Sanket Hase ,  Shasank K. Chavan ,  Niloy Mukherjee ,  Teck Hua Lee ,  Michael J. Gleeson ,  Krishna Kunchithapadam

IPC: G06F17/30 ,  G06F3/06 ,  G06F11/20

Abstract: Techniques are provided for maintaining data persistently in one format, but making that data available to a database server in more than one format. For example, one of the formats in which the data is made available for query processing is based on the on-disk format, while another of the formats in which the data is made available for query processing is independent of the on-disk format. Data that is in the format that is independent of the disk format may be maintained exclusively in volatile memory to reduce the overhead associated with keeping the data in sync with the on-disk format copies of the data.