-
公开(公告)号：US11599421B2
公开(公告)日：2023-03-07
申请号：US17137745
申请日：2020-12-30
Applicant: Oracle International Corporation
Inventor： Ajit Mylavarapu , Vasudha Krishnaswamy , Sukhada Pendse , Solmaz Kolahi , Ankita Kumar , Garret F. Swart , Tirthankar Lahiri , Juan R. Loaiza
Abstract: A shared-nothing database system is provided in which parallelism and workload balancing are increased by assigning the rows of each table to “slices”, and storing multiple copies (“duplicas”) of each slice across the persistent storage of multiple nodes of the shared-nothing database system. When the data for a table is distributed among the nodes of a shared-nothing system in this manner, requests to read data from a particular row of the table may be handled by any node that stores a duplica of the slice to which the row is assigned. For each slice, a single duplica of the slice is designated as the “primary duplica”. All DML operations (e.g. inserts, deletes, updates, etc.) that target a particular row of the table are performed by the node that has the primary duplica of the slice to which the particular row is assigned. The changes made by the DML operations are then propagated from the primary duplica to the other duplicas (“secondary duplicas”) of the same slice.
-
公开(公告)号：US20220114164A1
公开(公告)日：2022-04-14
申请号：US17136568
申请日：2020-12-29
Applicant: Oracle International Corporation
Inventor： Vasudha Krishnaswamy , Sukhada Pendse , Solmaz Kolahi , Ankita Kumar , Ajit Mylavarapu , Garret F. Swart , Tirthankar Lahiri , Juan R. Loaiza
Abstract: A shared-nothing database system is provided in which parallelism and workload balancing are increased by assigning the rows of each table to “slices”, and storing multiple copies (“duplicas”) of each slice across the persistent storage of multiple nodes of the shared-nothing database system. When the data for a table is distributed among the nodes of a shared-nothing system in this manner, requests to read data from a particular row of the table may be handled by any node that stores a duplica of the slice to which the row is assigned. For each slice, a single duplica of the slice is designated as the “primary duplica”. All DML operations (e.g. inserts, deletes, updates, etc.) that target a particular row of the table are performed by the node that has the primary duplica of the slice to which the particular row is assigned. The changes made by the DML operations are then propagated from the primary duplica to the other duplicas (“secondary duplicas”) of the same slice.
-
公开(公告)号：US20230281190A1
公开(公告)日：2023-09-07
申请号：US18117810
申请日：2023-03-06
Applicant: Oracle International Corporation
Inventor： Ajit Mylavarapu , Vasudha Krishnaswamy , Sukhada Pendse , Solmaz Kolahi , Ankita Kumar , Garret F. Swart , Juan R. Loaiza , Tirthankar Lahiri
CPC classification number: G06F16/2379 , G06F16/285
Abstract: One or more engine instances are executed on each host to form an engine cluster. A plurality of control instances are executed on a first set of hosts to form a control cluster and comprise a control instance leader and one or more control instance followers. In response to a first host indicating a failure of a neighbor host, a pair-wise focused investigation is initiated to check peer-to-peer connections between the first host and the neighbor host. In response to one or more additional hosts indicating failures of neighbor hosts while the pair-wise focused investigation is being performed, a wide investigation is performed to check connections between the control cluster and the plurality of hosts. One or more hosts are added to an eviction list and an eviction protocol is performed to evict the one or more hosts from the engine cluster using the eviction list.
-
公开(公告)号：US20220114058A1
公开(公告)日：2022-04-14
申请号：US17137745
申请日：2020-12-30
Applicant: Oracle International Corporation
Inventor： Ajit Mylavarapu , Vasudha Krishnaswamy , Sukhada Pendse , Solmaz Kolahi , Ankita Kumar , Garret F. Swart , Tirthankar Lahiri , Juan R. Loaiza
Abstract: A shared-nothing database system is provided in which parallelism and workload balancing are increased by assigning the rows of each table to “slices”, and storing multiple copies (“duplicas”) of each slice across the persistent storage of multiple nodes of the shared-nothing database system. When the data for a table is distributed among the nodes of a shared-nothing system in this manner, requests to read data from a particular row of the table may be handled by any node that stores a duplica of the slice to which the row is assigned. For each slice, a single duplica of the slice is designated as the “primary duplica”. All DML operations (e.g. inserts, deletes, updates, etc.) that target a particular row of the table are performed by the node that has the primary duplica of the slice to which the particular row is assigned. The changes made by the DML operations are then propagated from the primary duplica to the other duplicas (“secondary duplicas”) of the same slice.
-
公开(公告)号：US20240273087A1
公开(公告)日：2024-08-15
申请号：US18633209
申请日：2024-04-11
Applicant: Oracle International Corporation
Inventor： Ajit Mylavarapu , Vasudha Krishnaswamy , Sukhada Pendse , Solmaz Kolahi , Ankita Kumar , Garret F. Swart , Tirthankar Lahiri , Juan R. Loaiza
CPC classification number: G06F16/2379 , G06F16/285
Abstract: One or more engine instances are executed on each host to form an engine cluster. A plurality of control instances are executed on a first set of hosts to form a control cluster and comprise a control instance leader and one or more control instance followers. In response to a first host indicating a failure of a neighbor host, a pair-wise focused investigation is initiated to check peer-to-peer connections between the first host and the neighbor host. In response to one or more additional hosts indicating failures of neighbor hosts while the pair-wise focused investigation is being performed, a wide investigation is performed to check connections between the control cluster and the plurality of hosts. One or more hosts are added to an eviction list and an eviction protocol is performed to evict the one or more hosts from the engine cluster using the eviction list.
-
Patent Agency Ranking
公开(公告)号：US11983170B2
公开(公告)日：2024-05-14
申请号：US18117810
申请日：2023-03-06
Applicant: Oracle International Corporation
Inventor： Ajit Mylavarapu , Vasudha Krishnaswamy , Sukhada Pendse , Solmaz Kolahi , Ankita Kumar , Garret F. Swart , Tirthankar Lahiri , Juan R. Loaiza
CPC classification number: G06F16/2379 , G06F16/285
Abstract: One or more engine instances are executed on each host to form an engine cluster. A plurality of control instances are executed on a first set of hosts to form a control cluster and comprise a control instance leader and one or more control instance followers. In response to a first host indicating a failure of a neighbor host, a pair-wise focused investigation is initiated to check peer-to-peer connections between the first host and the neighbor host. In response to one or more additional hosts indicating failures of neighbor hosts while the pair-wise focused investigation is being performed, a wide investigation is performed to check connections between the control cluster and the plurality of hosts. One or more hosts are added to an eviction list and an eviction protocol is performed to evict the one or more hosts from the engine cluster using the eviction list.
-
公开(公告)号：US12271372B2
公开(公告)日：2025-04-08
申请号：US18633209
申请日：2024-04-11
Applicant: Oracle International Corporation
Inventor： Ajit Mylavarapu , Vasudha Krishnaswamy , Sukhada Pendse , Solmaz Kolahi , Ankita Kumar , Garret F. Swart , Tirthankar Lahiri , Juan R Loaiza
Abstract: One or more engine instances are executed on each host to form an engine cluster. A plurality of control instances are executed on a first set of hosts to form a control cluster and comprise a control instance leader and one or more control instance followers. In response to a first host indicating a failure of a neighbor host, a pair-wise focused investigation is initiated to check peer-to-peer connections between the first host and the neighbor host. In response to one or more additional hosts indicating failures of neighbor hosts while the pair-wise focused investigation is being performed, a wide investigation is performed to check connections between the control cluster and the plurality of hosts. One or more hosts are added to an eviction list and an eviction protocol is performed to evict the one or more hosts from the engine cluster using the eviction list.
-
公开(公告)号：US11514029B2
公开(公告)日：2022-11-29
申请号：US17136568
申请日：2020-12-29
Applicant: Oracle International Corporation
Inventor： Vasudha Krishnaswamy , Sukhada Pendse , Solmaz Kolahi , Ankita Kumar , Ajit Mylavarapu , Garret F. Swart , Tirthankar Lahiri , Juan R. Loaiza
Abstract: A shared-nothing database system is provided in which parallelism and workload balancing are increased by assigning the rows of each table to “slices”, and storing multiple copies (“duplicas”) of each slice across the persistent storage of multiple nodes of the shared-nothing database system. When the data for a table is distributed among the nodes of a shared-nothing system in this manner, requests to read data from a particular row of the table may be handled by any node that stores a duplica of the slice to which the row is assigned. For each slice, a single duplica of the slice is designated as the “primary duplica”. All DML operations (e.g. inserts, deletes, updates, etc.) that target a particular row of the table are performed by the node that has the primary duplica of the slice to which the particular row is assigned. The changes made by the DML operations are then propagated from the primary duplica to the other duplicas (“secondary duplicas”) of the same slice.
-
公开(公告)号：US10372699B2
公开(公告)日：2019-08-06
申请号：US15264978
申请日：2016-09-14
Applicant: Oracle International Corporation
Inventor： Xiaoming He , Solmaz Kolahi , Vivekanandhan Raja , Tirthankar Lahiri , Vasudha Krishnaswamy , Sanket Hase
IPC: G06F16/23
Abstract: Techniques are described for maintaining coherency of a portion of a database object populated in the volatile memories of multiple nodes in a database cluster. The techniques involve maintaining a local invalidation bitmap for which identifies block-level invalidity data and item-level invalidity data. In response to detecting a patch-up triggering event, a particular node identifies, in the block-level invalidity data, blocks that have been marked as invalid. For each block that has been marked as invalid, the node identifies specific items that have changed and marks the items as invalid in the item-level invalidity data. The node then updates the block-level invalidity data to indicate that the blocks are no longer invalid.
-
公开(公告)号：US20180075079A1
公开(公告)日：2018-03-15
申请号：US15264978
申请日：2016-09-14
Applicant: Oracle International Corporation
Inventor： Xiaoming He , Solmaz Kolahi , Vivekanandhan Raja , Tirthankar Lahiri , Vasudha Krishnaswamy , Sanket Hase
IPC: G06F17/30
CPC classification number: G06F16/2322 , G06F16/2365
Abstract: Techniques are described for maintaining coherency of a portion of a database object populated in the volatile memories of multiple nodes in a database cluster. The techniques involve maintaining a local invalidation bitmap for which identifies block-level invalidity data and item-level invalidity data. In response to detecting a patch-up triggering event, a particular node identifies, in the block-level invalidity data, blocks that have been marked as invalid. For each block that has been marked as invalid, the node identifies specific items that have changed and marks the items as invalid in the item-level invalidity data. The node then updates the block-level invalidity data to indicate that the blocks are no longer invalid.
-
-
-
-
-
-
-
-
-
Search Results
10
records
(took 0.015 seconds)
