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

公开(公告)号：US11860830B2

公开(公告)日：2024-01-02

申请号：US16287569

申请日：2019-02-27

Applicant: Oracle International Corporation

Inventor： Tirthankar Lahiri ,  Martin A. Reames ,  Kirk Edson ,  Neelam Goyal ,  Kao Makino ,  Anindya Patthak ,  Dina Thomas ,  Subhradyuti Sarkar ,  Chi-Kim Hoang ,  Qingchun Jiang

IPC: G06F16/21 ,  G06F16/27

CPC classification number: G06F16/211 ,  G06F16/21 ,  G06F16/278

Abstract: Columns of a table are stored in either row-major format or column-major format in an in-memory DBMS. For a given table, one set of columns is stored in column-major format; another set of columns for a table are stored in row-major format. This way of storing columns of a table is referred to herein as dual-major format. In addition, a row in a dual-major table is updated “in-place”, that is, updates are made directly to column-major columns without creating an interim row-major form of the column-major columns of the row. Users may submit database definition language (“DDL”) commands that declare the row-major columns and column-major columns of a table.

公开(公告)号：US20130198249A1

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

申请号：US13799572

申请日：2013-03-13

Applicant: Oracle International Corporation

Inventor： Chi-Kim Hoang ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang ,  John E. Miller ,  Dilys Thomas ,  Nagender Bandi ,  Susan Cheng

IPC: G06F17/30

CPC classification number: G06F17/30312 ,  G06F12/084

Abstract: A plurality of mid-tier databases form a single, consistent cache grid for data in one or more backend data sources, such as a database system. The mid-tier databases may be standard relational databases. Cache agents at each mid-tier database swap in data from the backend database as needed. Ownership locks maintain consistency in the cache grid. Cache agents prevent database operations that will modify cached data in a mid-tier database unless and until ownership of the cached data can be acquired for the mid-tier database. Cache groups define what backend data may be cached, as well as a general structure in which the backend data is to be cached. Metadata for cache groups is shared to ensure that data is cached in the same form throughout the entire grid. Ownership of cached data can then be tracked through a mapping of cached instances of data to particular mid-tier databases.

Abstract translation: 多个中间层数据库形成用于一个或多个后端数据源（例如数据库系统）中的数据的单一，一致的高速缓存网格。 中间层数据库可以是标准关系数据库。 每个中间层数据库的缓存代理根据需要从后端数据库交换数据。 所有权锁在高速缓存网格中保持一致性。 高速缓存代理阻止数据库操作，将修改中间层数据库中的缓存数据，除非可以为中间层数据库获取缓存数据的所有权。 缓存组定义可以缓存哪些后端数据，以及要缓存后端数据的一般结构。 共享缓存组的元数据，以确保数据在整个网格中以相同的格式缓存。 然后可以通过将缓存的数据实例映射到特定中间层数据库来跟踪缓存数据的所有权。

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

公开(公告)号：US20150088813A1

公开(公告)日：2015-03-26

申请号：US14097575

申请日：2013-12-05

Applicant: Oracle International Corporation

Inventor： Tirthankar Lahiri ,  Martin A. Reames ,  Kirk Edson ,  Neelam Goyal ,  Kao Makino ,  Anindya Patthak ,  Dina Thomas ,  Subhradyuti Sarkar ,  Chi-Kim Hoang ,  Qingchun Jiang

IPC: G06F17/30

CPC classification number: G06F17/30292 ,  G06F17/30289 ,  G06F17/30584

Abstract: Columns of a table are stored in either row-major format or column-major format in an in-memory DBMS. For a given table, one set of columns is stored in column-major format; another set of columns for a table are stored in row-major format. This way of storing columns of a table is referred to herein as dual-major format. In addition, a row in a dual-major table is updated “in-place”, that is, updates are made directly to column-major columns without creating an interim row-major form of the column-major columns of the row. Users may submit database definition language (“DDL”) commands that declare the row-major columns and column-major columns of a table.

Abstract translation: 表的列以存储器内DBA中的行主格式或列主格式存储。 对于给定的表，一列列以列主格式存储; 表的另一组列以行主格式存储。 这种存储表的​​列的方式在本文中被称为双主格式。 此外，双主表中的一行更新为“就地”，即直接对列主列进行更新，而不创建该行的主列列的主要行。 用户可以提交数据库定义语言（“DDL”）命令，声明表的行主列和列主列。

公开(公告)号：US10311154B2

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

申请号：US14097575

申请日：2013-12-05

Applicant: Oracle International Corporation

Inventor： Tirthankar Lahiri ,  Martin A. Reames ,  Kirk Edson ,  Neelam Goyal ,  Kao Makino ,  Anindya Patthak ,  Dina Thomas ,  Subhradyuti Sarkar ,  Chi-Kim Hoang ,  Qingchun Jiang

IPC: G06F17/30

Abstract: Columns of a table are stored in either row-major format or column-major format in an in-memory DBMS. For a given table, one set of columns is stored in column-major format; another set of columns for a table are stored in row-major format. This way of storing columns of a table is referred to herein as dual-major format. In addition, a row in a dual-major table is updated “in-place”, that is, updates are made directly to column-major columns without creating an interim row-major form of the column-major columns of the row. Users may submit database definition language (“DDL”) commands that declare the row-major columns and column-major columns of a table.

公开(公告)号：US09569475B2

公开(公告)日：2017-02-14

申请号：US13799572

申请日：2013-03-13

Applicant: Oracle International Corporation

Inventor： Chi-Kim Hoang ,  Tirthankar Lahiri ,  Marie-Anne Neimat ,  Chih-Ping Wang ,  John E. Miller ,  Dilys Thomas ,  Nagender Bandi ,  Susan Cheng

IPC: G06F17/30 ,  G06F12/08

CPC classification number: G06F17/30312 ,  G06F12/084

Abstract: A plurality of mid-tier databases form a single, consistent cache grid for data in one or more backend data sources, such as a database system. The mid-tier databases may be standard relational databases. Cache agents at each mid-tier database swap in data from the backend database as needed. Ownership locks maintain consistency in the cache grid. Cache agents prevent database operations that will modify cached data in a mid-tier database unless and until ownership of the cached data can be acquired for the mid-tier database. Cache groups define what backend data may be cached, as well as a general structure in which the backend data is to be cached. Metadata for cache groups is shared to ensure that data is cached in the same form throughout the entire grid. Ownership of cached data can then be tracked through a mapping of cached instances of data to particular mid-tier databases.

Abstract translation: 多个中间层数据库形成用于一个或多个后端数据源（例如数据库系统）中的数据的单一，一致的高速缓存网格。 中间层数据库可以是标准关系数据库。 每个中间层数据库的缓存代理根据需要从后端数据库交换数据。 所有权锁在高速缓存网格中保持一致性。 高速缓存代理阻止数据库操作，将修改中间层数据库中的缓存数据，除非可以为中间层数据库获取缓存数据的所有权。 缓存组定义可以缓存哪些后端数据，以及要缓存后端数据的一般结构。 共享缓存组的元数据，以确保数据在整个网格中以相同的格式缓存。 然后可以通过将缓存的数据实例映射到特定中间层数据库来跟踪缓存数据的所有权。

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