-
公开(公告)号：US20240184803A1
公开(公告)日：2024-06-06
申请号：US18438154
申请日：2024-02-09
Applicant: Oracle International Corporation
Inventor： Yunrui Li , Giridhar Ravipati , Ian Neall , Frank Lange , Jing Zheng , Mahesh Girkar , David Gagne , Nitin Karkhanis , Sadhana Kyathappala , Qingguang Cui
CPC classification number: G06F16/27 , G06F11/1471 , G06F16/2358 , G06F16/2365 , G06F2201/82
Abstract: Herein is high availability for online transaction processing with redundancy and redo for a federation of pluggable databases and container databases. In an embodiment of a federation of container database management systems that includes a first container database, first redo data of a first pluggable database in a second container database is obtained based on a database dictionary in the first container database. To the first pluggable database in the first container database, the first redo data of the first pluggable database in the second container database is applied. Based on the database dictionary in the first container database, second redo data of a second pluggable database in a third container database is obtained. To the second pluggable database in the first container database, without modifying content of the first pluggable database in the first container database, the second redo data of the second pluggable database in the third container database is applied.
-
公开(公告)号：US11971869B2
公开(公告)日：2024-04-30
申请号：US17974152
申请日：2022-10-26
Applicant: Oracle International Corporation
Inventor： Jesse Kamp , Allison L. Holloway , Meichun Hsu , Hideaki Kimura , Boris Klots , Vasudha Krishnaswamy , Kartik Kulkarni , Teck Hua Lee , Yunrui Li , Aurosish Mishra , Ajit Mylavarapu , Sukhada Pendse , Garret F. Swart , Shasank K. Chavan , Tirthankar Lahiri , Juan R. Loaiza
CPC classification number: G06F16/2255 , G06F16/128 , G06F16/1756 , G06F16/1865 , G06F16/217 , G06F16/2322 , G06F16/27
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.
-
公开(公告)号：US11847110B2
公开(公告)日：2023-12-19
申请号：US17202024
申请日：2021-03-15
Applicant: Oracle International Corporation
Inventor： Sachin Vijaykumar Sonawane , Mahesh Baburao Girkar , Yunrui Li , Thomas Baby , Vivekanandhan Raja
CPC classification number: G06F16/2365 , G06F16/2379 , G06F16/275 , G06F11/1458
Abstract: A database session in an active standby server on which an active standby database resides receives a DML statement. The session is suspended while the statement is redirected over a database link to a primary database on which the statement is executed. Information associated with execution of the statement is communicated to the session in the active standby server. Redo records describing changes to the contents of the primary database are applied to the active standby database and control is returned to the session. Prior to commitment of a transaction including the statement, a query directed to data to which the statement was directed is received at the active standby server from a client and executed on the active standby database absent use of a database link based on whether information associated with a database session associated with the client matches the information associated with execution of the statement.
-
公开(公告)号：US11720416B2
公开(公告)日：2023-08-08
申请号：US16570895
申请日：2019-09-13
Applicant: Oracle International Corporation
Inventor： Graham Ivey , Yunrui Li
CPC classification number: G06F9/522 , G06F9/4418 , G06F9/46 , G06F9/465 , G06F9/466 , G06F9/467 , G06F9/48 , G06F9/485 , G06F9/4806 , G06F9/4812 , G06F9/4843 , G06F9/4887 , G06F9/50 , G06F9/52 , G06F9/524 , G06F9/526 , G06F9/544 , G06F16/252
Abstract: A computer's processes and/or threads generate and store in memory, data to reimplement or reverse a transaction on a database, so that the database can be recovered. This data is written to persistent memory storage (“persisted”) by another process, for which the processes and/or threads may wait. This wait includes at least a sleep phase, and additionally a spin phase which is entered if after awakening from sleep and checking (“on-awakening” check), the data to be persisted is found to not have been persisted. To sleep in the sleep phase, each process/thread specifies a sleep duration determined based at least partially on previous results of on-awakening checks. The previous results in which to-be-persisted data was found to be not persisted are indications the sleeps were insufficient, and these indications are counted and used to determine the sleep duration. Repeated determination of sleep duration makes the sleep phase adaptive.
-
公开(公告)号：US20230033806A1
公开(公告)日：2023-02-02
申请号：US17389835
申请日：2021-07-30
Applicant: Oracle International Corporation
Inventor： Yunrui Li , Giridhar Ravipati , Ian Neall , Frank Lange , Jing Zheng , Mahesh Girkar , David Gagne , Nitin Karkhanis , Sadhana Kyathappala , Qingguang Cui
Abstract: Herein is high availability for online transaction processing with redundancy and redo for a federation of pluggable databases and container databases. In an embodiment of a federation of container database management systems that includes a first container database, first redo data of a first pluggable database in a second container database is obtained based on a database dictionary in the first container database. To the first pluggable database in the first container database, the first redo data of the first pluggable database in the second container database is applied. Based on the database dictionary in the first container database, second redo data of a second pluggable database in a third container database is obtained. To the second pluggable database in the first container database, without modifying content of the first pluggable database in the first container database, the second redo data of the second pluggable database in the third container database is applied.
-
Patent Agency Ranking
公开(公告)号：US20220114153A1
公开(公告)日：2022-04-14
申请号：US17070277
申请日：2020-10-14
Applicant: Oracle International Corporation
Inventor： Jesse Kamp , Allison L. Holloway , Meichun Hsu , Hideaki Kimura , Boris Klots , Vasudha Krishnaswamy , Kartik Kulkarni , Teck Hua Lee , Yunrui Li , Aurosish Mishra , Ajit Mylavarapu , Sukhada Pendse , Garret F. Swart , Shasank K. Chavan , 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.
-
公开(公告)号：US11068437B2
公开(公告)日：2021-07-20
申请号：US15266340
申请日：2016-09-15
Applicant: Oracle International Corporation
Inventor： Margaret Susairaj , Giridhar Ravipati , Kumar Rajamani , Yunrui Li , Jaebock Lee , Sanket Jain
Abstract: Techniques are provided for using a sparse file to create a hot archive of a pluggable database of a container database. In an embodiment and while a source pluggable database is in service, a source database server creates a clone of the source pluggable database. Also while the source pluggable database is in service, the source database server creates an archive of the source pluggable database that is based on the clone. Eventually, a need arises to consume the archive. A target database server (which may also be the source database server) creates a target pluggable database based on the archive.
-
18.发明授权公开(公告)号：US10891291B2
公开(公告)日：2021-01-12
申请号：US15339525
申请日：2016-10-31
Applicant: Oracle International Corporation
Inventor： Yunrui Li , Kumar Rajamani
IPC: G06F16/2453 , G06F16/951 , G06F16/2458 , G06F16/23 , G06F16/22 , G06F16/27 , G06F16/25
Abstract: A refreshable PDB clone is associated with a PDB-specific logical timestamp (LT) service that continuously reflects the LT of the most recent changes that have fully committed within the PDB clone during a refresh operation. Such an LT service is used to perform queries over the changing data in the PDB clone while the PDB clone is undergoing a refresh operation. Furthermore, a PDB-specific LT service can facilitate write operations in a standby CDB, where the standby CDB is a physical standby of a source CDB. Specifically, a standby CDB is configured with a private read-write PDB that does not replicate data from the source CDB. This private PDB may accommodate a write operation required by a query over data in the standby CDB. A PDB-specific LT service provides LTs for such a private PDB where the PDB-specific LT service provides LTs to order changes made within the private PDB.
-
公开(公告)号：US10809916B2
公开(公告)日：2020-10-20
申请号：US15489482
申请日：2017-04-17
Applicant: Oracle International Corporation
Inventor： Anjan Kumar Amirishetty , Yunrui Li , Tolga Yurek , Wilson Wai Shun Chan
Abstract: Techniques related to instance recovery using Bloom filters are disclosed. A multi-node node database management system (DBMS) includes a first database server instance and a second database server instance. A recovery set includes a set of data blocks that have been modified by a first database server instance and not persisted. A Bloom filter is generated to indicate whether data blocks are excluded from the recovery set. The Bloom filter is sent to the second database server instance, which determines whether the Bloom filter indicates that a particular data block is excluded from the recovery set. Based on determining that the Bloom filter indicates that the particular data block is excluded from the recovery set, access to the particular data block is granted.
-
公开(公告)号：US20200026774A9
公开(公告)日：2020-01-23
申请号：US15266340
申请日：2016-09-15
Applicant: Oracle International Corporation
Inventor： Margaret Susairaj , Giridhar Ravipati , Kumar Rajamani , Yunrui Li , Jaebock Lee , Sanket Jain
Abstract: Techniques are provided for using a sparse file to create a hot archive of a pluggable database of a container database. In an embodiment and while a source pluggable database is in service, a source database server creates a clone of the source pluggable database. Also while the source pluggable database is in service, the source database server creates an archive of the source pluggable database that is based on the clone. Eventually, a need arises to consume the archive. A target database server (which may also be the source database server) creates a target pluggable database based on the archive.
-
-
-
-
-
-
-
-
-
Search Results
87
records
(took 0.025 seconds)
