-
公开(公告)号：US20240119041A1
公开(公告)日：2024-04-11
申请号：US18476207
申请日：2023-09-27
Applicant: Oracle International Corporation
Inventor： Juan R. Loaiza , Sachin Vijakumar Sonawane , Mahesh Baburao Girkar , Wei-Ming Hu
CPC classification number: G06F16/2365 , G06F16/2282 , G06F16/2379 , H04L9/0894
Abstract: A blockchain object stores multiple user blockchains, each blockchain comprising an ordered set of records in the blockchain object. The records of a user blockchain have the same blockchain key value. Users can create multiple blockchains by establishing respective blockchain key values for the blockchains. Like blocks in a blockchain, the records in a user blockchain are ordered by a sequence of numbers that is specific to the user blockchain; each user blockchain has its own sequence of numbers. Each record in a user blockchain holds a sequence number in a field of the blockchain object. An efficient mechanism maintains and assigns a sequence number to a record when appended to a user blockchain.
-
公开(公告)号：US20210073209A1
公开(公告)日：2021-03-11
申请号：US16923279
申请日：2020-07-08
Applicant: Oracle International Corporation
Inventor： Juan R. Loaiza , Wei-Ming Hu , Amrish Srivastava , Mahesh Baburao Girkar , James W. Stamos
Abstract: Herein are high throughput techniques for incorporating cryptographic blockchains into relational data. In an embodiment, a computer indicates, in a database dictionary in a database, that a relational table is for blockchain storage. The relational table contains application column(s). In response to that indication, the relational table is associated with system column(s) that are unmodifiable by administrators and clients of the database. The system column(s) include a cryptographic hash column. A request to store a particular value in a particular application column is received from a client. In response to receiving the request, a cryptographic hash value is calculated for a new row for the relational table. In the relational table, the computer stores the new row that contains: the particular value in the particular application column, and the cryptographic hash value in the cryptographic hash column.
-
公开(公告)号：US09495431B2
公开(公告)日：2016-11-15
申请号：US14067129
申请日：2013-10-30
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor： Amrish Srivastava , Yunrui Li , Mahesh Baburao Girkar
Abstract: A method, apparatus, and system for multi-instance redo apply is provided for standby databases. A multi-instance primary database generates a plurality of redo records, which are received and applied by a physical standby running a multi-instance standby database. Each standby instance runs a set of processes that utilize non-blocking, single-task threads for high parallelism. At each standby instance for the multi-instance redo, the plurality of redo records are merged into a stream from one or more redo strands in logical time order, distributed to standby instances according to determined apply slave processes using an intelligent workload distribution function, reemerged after receiving updates from remote instances, and applied in logical time order by the apply slave processes. Redo apply progress is tracked at each instance locally and also globally, allowing a consistent query logical time to be maintained and published to service database read query requests concurrently with the redo apply.
-
公开(公告)号：US12137172B2
公开(公告)日：2024-11-05
申请号：US17584640
申请日：2022-01-26
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor： Sachin Vijakumar Sonawane , Juan R. Loaiza , Mahesh Baburao Girkar , Mark Rakhmilevich , Wei-Ming Hu
Abstract: In Secure-Asynchronous Signing, when a record is inserted into a collection of records by a user, the user specifies a registered digital certificate to associate with the record. The digital certificate was previously registered by the user. To subsequently sign a record, the user provides a digital signature. The digital signature is validated using data in the record and a public key of the digital certificate that was associated with the row. Invalid digital signatures are detected and rejected regardless of how long afterward the attempt to sign the row occurs after inserting the row.
-
公开(公告)号：US20230145520A1
公开(公告)日：2023-05-11
申请号：US17524436
申请日：2021-11-11
Applicant: Oracle International Corporation
Inventor： Sachin Vijakumar Sonawane , Mahesh Baburao Girkar
IPC: G06F16/27 , G06F16/2455
CPC classification number: G06F16/273 , G06F16/2455
Abstract: Techniques described herein allow a standby DBMS to maintain consistency of results for transactions that include redirected DML commands without requiring the standby DBMS to delay execution of queries that do not require changed objects. Specifically, a standby session records DML target object (DTO) record with information regarding DML-changed objects and transaction information from the primary DBMS. Using DTO records, the standby DBMS ensures that results of any additional queries include changes made by the redirected DML commands without delaying execution of queries that do not access changed objects. If a target object in a standby query is in a DTO record, then query execution is delayed until the standby database is updated to the timestamp indicated in the DTO record. Thus, the delayed query has access to changes made by the DML command. Otherwise, the query is immediately executed without waiting for the standby database synchronization.
-
Patent Agency Ranking
公开(公告)号：US11640391B2
公开(公告)日：2023-05-02
申请号：US16923279
申请日：2020-07-08
Applicant: Oracle International Corporation
Inventor： Juan R. Loaiza , Wei-Ming Hu , Amrish Srivastava , Mahesh Baburao Girkar , James W. Stamos , Sachin Sonawane
IPC: G06F16/23 , G06F16/2455 , H04L9/06 , G06F16/22 , H04L9/00
Abstract: Herein are high throughput techniques for incorporating cryptographic blockchains into relational data. In an embodiment, a computer indicates, in a database dictionary in a database, that a relational table is for blockchain storage. The relational table contains application column(s). In response to that indication, the relational table is associated with system column(s) that are unmodifiable by administrators and clients of the database. The system column(s) include a cryptographic hash column. A request to store a particular value in a particular application column is received from a client. In response to receiving the request, a cryptographic hash value is calculated for a new row for the relational table. In the relational table, the computer stores the new row that contains: the particular value in the particular application column, and the cryptographic hash value in the cryptographic hash column.
-
公开(公告)号：US10152396B2
公开(公告)日：2018-12-11
申请号：US14270117
申请日：2014-05-05
Applicant: Oracle International Corporation
Inventor： Jonghyun Lee , Yunrui Li , Mahesh Baburao Girkar , Amrish Srivastava
Abstract: A method, apparatus, and system for a time-based checkpoint target is provided for standby databases. Change records received from a primary database are applied for a standby database, creating dirty buffer queues. As the change records are applied, a mapping is maintained, which maps timestamps to logical times of change records that were most recently applied at the timestamp for the standby database. On a periodic dirty buffer queue processing interval, the mapping is used to determine a target logical time that is mapped to a target timestamp that is prior to a present timestamp by at least a checkpoint delay. The dirty buffer queues are then processed up to the target logical time, creating an incremental checkpoint. On a periodic header update interval, file headers reflecting a consistent logical time for the checkpoint are also updated. The intervals and the checkpoint delay are adjustable by user or application.
-
公开(公告)号：US09619541B2
公开(公告)日：2017-04-11
申请号：US14067129
申请日：2013-10-30
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor： Amrish Srivastava , Yunrui Li , Mahesh Baburao Girkar
Abstract: A method, apparatus, and system for multi-instance redo apply is provided for standby databases. A multi-instance primary database generates a plurality of redo records, which are received and applied by a physical standby running a multi-instance standby database. Each standby instance runs a set of processes that utilize non-blocking, single-task threads for high parallelism. At each standby instance for the multi-instance redo, the plurality of redo records are merged into a stream from one or more redo strands in logical time order, distributed to standby instances according to determined apply slave processes using an intelligent workload distribution function, reemerged after receiving updates from remote instances, and applied in logical time order by the apply slave processes. Redo apply progress is tracked at each instance locally and also globally, allowing a consistent query logical time to be maintained and published to service database read query requests concurrently with the redo apply.
-
公开(公告)号：US12182100B2
公开(公告)日：2024-12-31
申请号：US18476207
申请日：2023-09-27
Applicant: Oracle International Corporation
Inventor： Juan R. Loaiza , Sachin Vijakumar Sonawane , Mahesh Baburao Girkar , Wei-Ming Hu
Abstract: A blockchain object stores multiple user blockchains, each blockchain comprising an ordered set of records in the blockchain object. The records of a user blockchain have the same blockchain key value. Users can create multiple blockchains by establishing respective blockchain key values for the blockchains. Like blocks in a blockchain, the records in a user blockchain are ordered by a sequence of numbers that is specific to the user blockchain; each user blockchain has its own sequence of numbers. Each record in a user blockchain holds a sequence number in a field of the blockchain object. An efficient mechanism maintains and assigns a sequence number to a record when appended to a user blockchain.
-
公开(公告)号：US12050620B2
公开(公告)日：2024-07-30
申请号：US17524436
申请日：2021-11-11
Applicant: Oracle International Corporation
Inventor： Sachin Vijakumar Sonawane , Mahesh Baburao Girkar
IPC: G06F16/27 , G06F16/2455
CPC classification number: G06F16/273 , G06F16/2455
Abstract: Techniques described herein allow a standby DBMS to maintain consistency of results for transactions that include redirected DML commands without requiring the standby DBMS to delay execution of queries that do not require changed objects. Specifically, a standby session records DML target object (DTO) record with information regarding DML-changed objects and transaction information from the primary DBMS. Using DTO records, the standby DBMS ensures that results of any additional queries include changes made by the redirected DML commands without delaying execution of queries that do not access changed objects. If a target object in a standby query is in a DTO record, then query execution is delayed until the standby database is updated to the timestamp indicated in the DTO record. Thus, the delayed query has access to changes made by the DML command. Otherwise, the query is immediately executed without waiting for the standby database synchronization.
-
-
-
-
-
-
-
-
-
Search Results
24
records
(took 0.017 seconds)
