公开(公告)号：US20150006813A1

公开(公告)日：2015-01-01

申请号：US14487358

申请日：2014-09-16

Applicant: Oracle International Corporation

Inventor： Kiran Badrinarain Goyal ,  Neil J.S. Macnaughton ,  Eugene Ho ,  Adam Y. Lee ,  Vipin Gokhale ,  Wei-Ming Hu ,  Juan R. Loaiza ,  Kothanda Umamageswaran ,  Bharat C.V. Baddepudi ,  Boris Erlikhman ,  Alexander Tsukerman ,  Selcuk Aya ,  Roger Hansen ,  Adrian Ng

IPC: G06F12/08 ,  G06F17/30

CPC classification number: G06F12/0866 ,  G06F12/084 ,  G06F12/0888 ,  G06F12/0897 ,  G06F17/30312 ,  G06F17/3048 ,  G06F2212/283 ,  G06F2212/311 ,  G06F2212/312 ,  G06F2212/465

Abstract: Techniques are provided for using an intermediate cache between the shared cache of an application and the non-volatile storage of a storage system. The application may be any type of application that uses a storage system to persistently store data. The intermediate cache may be local to the machine upon which the application is executing, or may be implemented within the storage system. In one embodiment where the application is a database server, the database system includes both a DB server-side intermediate cache, and a storage-side intermediate cache. The caching policies used to populate the intermediate cache are intelligent, taking into account factors that may include which object an item belongs to, the item type of the item, a characteristic of the item, or the type of operation in which the item is involved.

Abstract translation: 提供了在应用的共享缓存和存储系统的非易失性存储之间使用中间缓存的技术。 应用程序可以是使用存储系统持久存储数据的任何类型的应用程序。 中间缓存可以是应用程序正在执行的机器本地，也可以在存储系统内实现。 在应用程序是数据库服务器的一个实施例中，数据库系统包括DB服务器侧中间缓存和存储侧中间缓存。 用于填充中间缓存的缓存策略是智能的，考虑到可能包括项目属于哪个对象，项目的项目类型，项目的特征或涉及项目的操作类型的因素 。

公开(公告)号：US20210081372A1

公开(公告)日：2021-03-18

申请号：US16812833

申请日：2020-03-09

Applicant: Oracle International Corporation

Inventor： J. William Lee ,  William H. Bridge, JR. ,  Ankur Kemkar ,  Vipin Gokhale ,  Sivaram Prasad Soma ,  Vishvesh Mohanarangam Selvakumaar ,  Juan R. Loaiza ,  Wei-Ming Hu ,  Neil J.S. MacNaughton ,  Adam Y. Lee

IPC: G06F16/182 ,  G06F16/16 ,  G06F12/02 ,  G06F12/123 ,  G06F9/4401 ,  G06F9/52 ,  G06F9/50

Abstract: Techniques herein store database blocks (DBBs) in byte-addressable persistent memory (PMEM) and prevent tearing without deadlocking or waiting. In an embodiment, a computer hosts a DBMS. A reader process of the DBMS obtains, without locking and from metadata in PMEM, a first memory address for directly accessing a current version, which is a particular version, of a DBB in PMEM. Concurrently and without locking: a) the reader process reads the particular version of the DBB in PMEM, and b) a writer process of the DBMS replaces, in the metadata in PMEM, the first memory address with a second memory address for directly accessing a new version of the DBB in PMEM. In an embodiment, a computer performs without locking: a) storing, in PMEM, a DBB, b) copying into volatile memory, or reading, an image of the DBB, and c) detecting whether the image of the DBB is torn.

公开(公告)号：US20140095452A1

公开(公告)日：2014-04-03

申请号：US13830349

申请日：2013-03-14

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： J. William LEE ,  Vipin Gokhale ,  Muthu Olagappan ,  Sanket Hase ,  Vivekanandhan Raja ,  Michael John Skarpelos ,  Michael Stewart

IPC: G06F11/14

CPC classification number: G06F3/0619 ,  G06F3/065 ,  G06F3/067 ,  G06F11/1448 ,  G06F11/1469 ,  G06F11/1471 ,  G06F12/084 ,  G06F13/1663 ,  G06F17/30289 ,  G06F17/30292 ,  G06F17/3048 ,  G06F17/30557 ,  G06F17/30566 ,  G06F17/30595 ,  G06F17/30867 ,  G06F21/6218 ,  G06F2201/80 ,  G06F2201/835 ,  G06F2212/60 ,  G06F2212/62

Abstract: In an approach, a database server maintains a container database which comprises: one or more pluggable databases, a root database that stores an undo log for rolling back transactions on the consolidated database, and a redo log for replaying modifications to the container database. The database server restores a particular pluggable with a backup version that corresponds to a first point in time. The database server generates a clone database loaded with a backup version of the root database that corresponds to the first point in time. The database server applies the redo log to recover the particular pluggable database and the clone database to a second point in time that is later than the first point in time. The database server identifies, based on the clone database, one or more active transactions on the particular pluggable database. The database server rolls back the one or more active transactions.

Abstract translation: 在一种方法中，数据库服务器维护容器数据库，其中包括：一个或多个可插拔数据库，存储用于在统一数据库上回退事务的撤销日志的根数据库，以及用于重播对容器数据库的修改的重做日志。 数据库服务器使用与第一个时间点对应的备份版本恢复特定的可插拔。 数据库服务器生成加载有与第一个时间点相对应的根数据库的备份版本的克隆数据库。 数据库服务器应用重做日志将特定的可插拔数据库和克隆数据库恢复到晚于第一个时间点的第二个时间点。 数据库服务器根据克隆数据库识别特定可插拔数据库上的一个或多个活动事务。 数据库服务器回滚一个或多个活动事务。

公开(公告)号：US10339069B2

公开(公告)日：2019-07-02

申请号：US13831462

申请日：2013-03-14

Applicant: Oracle International Corporation

Inventor： Adam Y. Lee ,  J. William Lee ,  Dmitry Mikhailovich Potapov ,  Neil MacNaughton ,  Vipin Gokhale ,  Bharat Chandra Baddepudi ,  David Vengerov

IPC: G06F12/12 ,  G06F12/128 ,  G06F12/126 ,  G06F16/2455

Abstract: Techniques are provided for managing cached data objects in a mixed workload environment. In an embodiment, a database system receives request to access a target data object. The database system determines whether the request to access the target data object is associated with a first type of workload or a second type of workload. In response to determining that the request is associated with the first type of workload, the target data object replaces a least recently used data object in a cache. In response to determining that the request is associated with the second type of workload, the target data object is cached based on an associated access-level value.

公开(公告)号：US11645241B2

公开(公告)日：2023-05-09

申请号：US16812833

申请日：2020-03-09

Applicant: Oracle International Corporation

Inventor： J. William Lee ,  William H. Bridge, Jr. ,  Ankur Kemkar ,  Vipin Gokhale ,  Sivaram Prasad Soma ,  Vishvesh Mohanarangam Selvakumaar ,  Juan R. Loaiza ,  Wei-Ming Hu ,  Neil J. S. MacNaughton ,  Adam Y. Lee

IPC: G06F16/182 ,  G06F16/16 ,  G06F9/4401 ,  G06F9/50 ,  G06F9/52 ,  G06F12/02 ,  G06F12/123

CPC classification number: G06F16/182 ,  G06F9/4411 ,  G06F9/5027 ,  G06F9/524 ,  G06F12/0246 ,  G06F12/123 ,  G06F16/164 ,  G06F2212/163

Abstract: Techniques herein store database blocks (DBBs) in byte-addressable persistent memory (PMEM) and prevent tearing without deadlocking or waiting. In an embodiment, a computer hosts a DBMS. A reader process of the DBMS obtains, without locking and from metadata in PMEM, a first memory address for directly accessing a current version, which is a particular version, of a DBB in PMEM. Concurrently and without locking: a) the reader process reads the particular version of the DBB in PMEM, and b) a writer process of the DBMS replaces, in the metadata in PMEM, the first memory address with a second memory address for directly accessing a new version of the DBB in PMEM. In an embodiment, a computer performs without locking: a) storing, in PMEM, a DBB, b) copying into volatile memory, or reading, an image of the DBB, and c) detecting whether the image of the DBB is torn.

公开(公告)号：US09405694B2

公开(公告)日：2016-08-02

申请号：US14487358

申请日：2014-09-16

Applicant: Oracle International Corporation

Inventor： Kiran Badrinarain Goyal ,  Neil J. S. Macnaughton ,  Eugene Ho ,  Adam Y. Lee ,  Vipin Gokhale ,  Wei-Ming Hu ,  Juan R. Loaiza ,  Kothanda Umamageswaran ,  Bharat C. V. Baddepudi ,  Boris Erlikhman ,  Alexander Tsukerman ,  Selcuk Aya ,  Roger Hansen ,  Adrian Ng

IPC: G06F12/08 ,  G06F17/30

CPC classification number: G06F12/0866 ,  G06F12/084 ,  G06F12/0888 ,  G06F12/0897 ,  G06F17/30312 ,  G06F17/3048 ,  G06F2212/283 ,  G06F2212/311 ,  G06F2212/312 ,  G06F2212/465

Abstract: Techniques are provided for using an intermediate cache between the shared cache of an application and the non-volatile storage of a storage system. The application may be any type of application that uses a storage system to persistently store data. The intermediate cache may be local to the machine upon which the application is executing, or may be implemented within the storage system. In one embodiment where the application is a database server, the database system includes both a DB server-side intermediate cache, and a storage-side intermediate cache. The caching policies used to populate the intermediate cache are intelligent, taking into account factors that may include which object an item belongs to, the item type of the item, a characteristic of the item, or the type of operation in which the item is involved.

Abstract translation: 提供了在应用的共享缓存和存储系统的非易失性存储之间使用中间缓存的技术。 应用程序可以是使用存储系统持久存储数据的任何类型的应用程序。 中间缓存可以是应用程序正在执行的机器本地，也可以在存储系统内实现。 在应用程序是数据库服务器的一个实施例中，数据库系统包括DB服务器侧中间缓存和存储侧中间缓存。 用于填充中间缓存的缓存策略是智能的，考虑到可能包括项目属于哪个对象，项目的项目类型，项目的特征或涉及项目的操作类型的因素 。

公开(公告)号：US09298564B2

公开(公告)日：2016-03-29

申请号：US13830349

申请日：2013-03-14

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： J. William Lee ,  Vipin Gokhale ,  Muthu Olagappan ,  Sanket Hase ,  Vivekanandhan Raja ,  Michael John Skarpelos ,  Michael Stewart

IPC: G06F17/30 ,  G06F11/14 ,  G06F21/62

CPC classification number: G06F3/0619 ,  G06F3/065 ,  G06F3/067 ,  G06F11/1448 ,  G06F11/1469 ,  G06F11/1471 ,  G06F12/084 ,  G06F13/1663 ,  G06F17/30289 ,  G06F17/30292 ,  G06F17/3048 ,  G06F17/30557 ,  G06F17/30566 ,  G06F17/30595 ,  G06F17/30867 ,  G06F21/6218 ,  G06F2201/80 ,  G06F2201/835 ,  G06F2212/60 ,  G06F2212/62

Abstract: In an approach, a database server maintains a container database which comprises: one or more pluggable databases, a root database that stores an undo log for rolling back transactions on the consolidated database, and a redo log for replaying modifications to the container database. The database server restores a particular pluggable with a backup version that corresponds to a first point in time. The database server generates a clone database loaded with a backup version of the root database that corresponds to the first point in time. The database server applies the redo log to recover the particular pluggable database and the clone database to a second point in time that is later than the first point in time. The database server identifies, based on the clone database, one or more active transactions on the particular pluggable database. The database server rolls back the one or more active transactions.

Abstract translation: 在一种方法中，数据库服务器维护一个容器数据库，它包括：一个或多个可插拔数据库，存储用于在统一数据库上回滚事务的撤销日志的根数据库，以及重播对容器数据库的修改的重做日志。 数据库服务器使用与第一个时间点对应的备份版本恢复特定的可插拔。 数据库服务器生成加载有与第一个时间点相对应的根数据库的备份版本的克隆数据库。 数据库服务器应用重做日志将特定的可插拔数据库和克隆数据库恢复到晚于第一个时间点的第二个时间点。 数据库服务器根据克隆数据库识别特定可插拔数据库上的一个或多个活动事务。 数据库服务器回滚一个或多个活动事务。

公开(公告)号：US20140095802A1

公开(公告)日：2014-04-03

申请号：US13831462

申请日：2013-03-14

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Adam Y. Lee ,  J. William Lee ,  Dmitry Mikhailovich Potapov ,  Neil MacNaughton ,  Vipin Gokhale ,  Bharat Chandra Baddepudi ,  David Vengerov

IPC: G06F12/12

CPC classification number: G06F12/128 ,  G06F12/126 ,  G06F16/24561

Abstract: Techniques are provided for managing cached data objects in a mixed workload environment. In an embodiment, a database system receives request to access a target data object. The database system determines whether the request to access the target data object is associated with a first type of workload or a second type of workload. In response to determining that the request is associated with the first type of workload, the target data object replaces a least recently used data object in a cache. In response to determining that the request is associated with the second type of workload, the target data object is cached based on an associated access-level value.

Abstract translation: 提供了在混合工作负载环境中管理缓存数据对象的技术。 在一个实施例中，数据库系统接收访问目标数据对象的请求。 数据库系统确定访问目标数据对象的请求是否与第一类工作负载或第二类工作负载相关联。 响应于确定该请求与第一类型的工作负载相关联，目标数据对象将替换高速缓存中最近最少使用的数据对象。 响应于确定该请求与第二类型的工作负载相关联，基于相关联的访问级别值来缓存目标数据对象。