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

公开(公告)号：US20160335310A1

公开(公告)日：2016-11-17

申请号：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: G06F17/30

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.

Abstract translation: 数据库作为多个数据库分片存储在包括多个网格元素的分布式数据库网格中，每个网格元素包括中间层数据库系统。 第一网格元件从与第一网格元素的中间层数据库系统在同一存储器中执行的应用接收第一数据库事务，该第一数据库事务包括存储在第一数据库分片中的特定数据的至少一个数据库操作，该数据库操作属于 第一个网格元素 第一网格元素执行并提交第一数据库事务而不参与多个网格元素中的另一网格元素。 第一个网格元素接收需要访问不属于第一个网格元素的另一个数据库分片的第二个数据库事务。 多个网格元素的多个网格元素执行第二数据库事务并使用两阶段提交协议提交第二数据库事务。

公开(公告)号：US11188516B2

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

申请号：US16522419

申请日：2019-07-25

Applicant: Oracle International Corporation

Inventor： Derek Taylor ,  Chi-Kim Hoang ,  Yu-Han Chou ,  Varadarajan Aravamudhan

IPC: G06F16/23 ,  G06F16/27

Abstract: An approach for consistent database recovery for distributed database systems uses “synchronization points”. A synchronization point is a global timestamp for which across all nodes of a distributed database system, the nodes have stored change records for any transaction occurring at and before the synchronization point in persistent logs. Each node may employ asynchronous flushing. However, on a periodic basis, each node coordinates to establish a synchronization point, which may entail ensuring change records for transactions that committed at or before the synchronization point are stored in persistent logs. In effect, a synchronization point represents that any transaction committed at or before the synchronization point has been durably committed.