-
公开(公告)号：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.
-
公开(公告)号：US09767178B2
公开(公告)日：2017-09-19
申请号：US14067129
申请日：2013-10-30
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor： Amrish Srivastava , Yunrui Li , Mahesh Baburao Girkar
CPC classification number: G06F17/30575 , G06F11/14 , G06F11/2038 , G06F11/2094 , G06F11/2097 , G06F2201/80
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.
-
公开(公告)号：US20170212817A1
公开(公告)日：2017-07-27
申请号：US15482225
申请日：2017-04-07
Applicant: Oracle International Corporation
Inventor： Amrish Srivastava , Yunrui Li , Mahesh Baburao Girkar
CPC classification number: G06F16/27 , G06F11/14 , G06F11/2038 , G06F11/2094 , G06F11/2097 , G06F2201/80
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, remerged 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.
-
公开(公告)号：US20150317212A1
公开(公告)日：2015-11-05
申请号：US14270117
申请日：2014-05-05
Applicant: Oracle International Corporation
Inventor： Jonghyun Lee , Yunrui Li , Mahesh Baburao Girkar , Amrish Srivastava
IPC: G06F11/14
CPC classification number: G06F11/2038 , G06F11/1438 , G06F11/1458 , G06F11/2097 , G06F17/30067 , G06F17/30353 , G06F2201/80 , G06F2201/82 , G06F2201/835
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.
Abstract translation: 为备用数据库提供了基于时间的检查点目标的方法，装置和系统。 将从主数据库接收的更改记录应用于备用数据库，从而创建脏缓冲区队列。 随着应用更改记录，维护映射，将时间戳映射到最近在备用数据库的时间戳处应用的更改记录的逻辑时间。 在周期性的脏缓冲器队列处理间隔上，该映射用于确定映射到当前时间戳之前至少一个检查点延迟的目标时间戳的目标逻辑时间。 然后将脏缓冲区队列处理到目标逻辑时间，创建一个增量检查点。 在周期性头文件更新间隔中，还会更新反映检查点一致逻辑时间的文件头。 间隔和检查点延迟可由用户或应用程序调整。
-
Patent Agency Ranking
公开(公告)号：US20150120659A1
公开(公告)日：2015-04-30
申请号：US14067129
申请日：2013-10-30
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor： Amrish Srivastava , Yunrui Li , Mahesh Baburao Girkar
IPC: G06F17/30
CPC classification number: G06F17/30575 , G06F11/14 , G06F11/2038 , G06F11/2094 , G06F11/2097 , G06F2201/80
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, remerged 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.
Abstract translation: 为备用数据库提供了一种用于多实例重做应用的方法，装置和系统。 多实例主数据库生成多个重做记录，这些记录由运行多实例备用数据库的物理备用程序接收和应用。 每个备用实例运行一组使用非阻塞单任务线程进行高并行化的进程。 在多实例重做的每个备用实例上，多个重做记录以逻辑时间顺序被合并到来自一个或多个重做链的流中，根据使用智能工作负载分布函数确定的应用从属进程分发到备用实例 在从远程实例接收到更新后，并通过应用从属进程以逻辑时间顺序应用。 重做应用进度在本地和全局的每个实例被跟踪，允许一致的查询逻辑时间被维护和发布，以与重做应用程序同时服务于数据库读取查询请求。
-
公开(公告)号：US11048599B2
公开(公告)日：2021-06-29
申请号：US16215046
申请日：2018-12-10
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.
-
公开(公告)号：US20190108107A1
公开(公告)日：2019-04-11
申请号：US16215046
申请日：2018-12-10
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.
-
公开(公告)号：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.
-
-
-
-
-
-
-
-
-
Search Results
11
records
(took 0.013 seconds)
