Autonomous multitenant database cloud service framework

    公开(公告)号:US11327932B2

    公开(公告)日:2022-05-10

    申请号:US16055468

    申请日:2018-08-06

    Abstract: Provided herein are workload management techniques that asynchronously configure pluggable databases within a compute cloud. In an embodiment, the compute cloud receives an administrative request that indicates configuration details for a pluggable database. The compute cloud generates a configuration descriptor that specifies an asynchronous job based on the configuration details of the request. The compute cloud accesses hosting metadata to detect at least one of: a) a current container database that already hosts the pluggable database, b) a target container database that will host the pluggable database, or c) a particular computer that hosts at least one of: the current container database, or the target container database. The compute cloud executes the asynchronous job to configure the pluggable database based on at least one of: the hosting metadata, or the configuration descriptor. Thread pools, lanes, and queues may facilitate load balancing to avoid priority inversion, starvation, and denial of service.

    Cloning a pluggable database in read-write mode

    公开(公告)号:US10922331B2

    公开(公告)日:2021-02-16

    申请号:US15215435

    申请日:2016-07-20

    Abstract: Embodiments create a clone of a PDB while the PDB accepts write operations. While the PDB remains in read-write mode, the DBMS copies the data of the PDB and sends the data to a destination location. The DBMS performs data recovery on the PDB clone based on redo entries that record changes made to the source PDB while the DBMS copied the source PDB files. This data recovery makes all changes, to the PDB clone, that occurred to the source PDB during the copy operation. The redo information, on which the data recovery is based, is foreign to the PDB clone since the redo entries were recorded for a different PDB. In order to apply foreign redo information to perform recovery on the PDB clone, a DBMS managing the PDB clone maintains mapping information that maps PDB source reference information to corresponding information for the PDB clone.

    Provisioning of pluggable databases using a central repository

    公开(公告)号:US10606578B2

    公开(公告)日:2020-03-31

    申请号:US15266902

    申请日:2016-09-15

    Abstract: Techniques herein use rules automation and template pluggable databases to facilitate deployment into container databases. In an embodiment, a system of computers loads rules into a rules engine. Each rule associates a predicate with suitable container databases. The system receives a request to install a target pluggable database. The rules engine detects satisfied rules whose predicates match the request. Based on the suitable container databases of the satisfied rules, the rules engine selects a particular container database. The system installs the target pluggable database into the particular container database. In an embodiment, a system of computers stores a plurality of template pluggable databases in a repository. The repository receives an installation request. Based on the installation request, the system selects a particular template pluggable database. The system installs the particular template pluggable database into a container database.

    AUTONOMOUS MULTITENANT DATABASE CLOUD SERVICE FRAMEWORK

    公开(公告)号:US20190102384A1

    公开(公告)日:2019-04-04

    申请号:US16055468

    申请日:2018-08-06

    Abstract: Provided herein are workload management techniques that asynchronously configure pluggable databases within a compute cloud. In an embodiment, the compute cloud receives an administrative request that indicates configuration details for a pluggable database. The compute cloud generates a configuration descriptor that specifies an asynchronous job based on the configuration details of the request. The compute cloud accesses hosting metadata to detect at least one of: a) a current container database that already hosts the pluggable database, b) a target container database that will host the pluggable database, or c) a particular computer that hosts at least one of: the current container database, or the target container database. The compute cloud executes the asynchronous job to configure the pluggable database based on at least one of: the hosting metadata, or the configuration descriptor. Thread pools, lanes, and queues may facilitate load balancing to avoid priority inversion, starvation, and denial of service.

    STORAGE INTEGRATED SNAPSHOT CLONING FOR DATABASE
    6.
    发明申请
    STORAGE INTEGRATED SNAPSHOT CLONING FOR DATABASE 审中-公开
    数据库存储集成SNAPSHOT克隆

    公开(公告)号:US20150370641A1

    公开(公告)日:2015-12-24

    申请号:US14313926

    申请日:2014-06-24

    CPC classification number: G06F3/065 G06F3/0619 G06F16/128 G06F16/27

    Abstract: Techniques are described herein for cloning a database. According to some embodiments, a database server receives a request to clone a source database. In response to receiving the request, the database server retrieves a set of one or more storage credentials for a set of one or more respective storage systems on which a set of files of the source database are stored. The set of storage credentials grant permission to the database server to create snapshot copies on the set of storage systems. The database server generates, for a target database using the set of storage credentials, a snapshot copy of each respective file in the set of files of the source database. The snapshot copy of the respective file points to the same set of one or more data blocks as the respective file until at least one of the data blocks is modified.

    Abstract translation: 这里描述了用于克隆数据库的技术。 根据一些实施例,数据库服务器接收克隆源数据库的请求。 响应于接收到请求,数据库服务器检索一组一个或多个相应存储系统的一个或多个存储凭证的集合,在该存储系统上存储源数据库的一组文件。 存储凭证集允许数据库服务器在该组存储系统上创建快照副本。 数据库服务器使用该组存储凭据为目标数据库生成源数据库文件集中每个相应文件的快照副本。 相应文件的快照副本指向与相应文件相同的一个或多个数据块集合,直到至少一个数据块被修改。

    Object storage based asynchronous mailbox, eventual consistency for cross-region communication

    公开(公告)号:US12099740B2

    公开(公告)日:2024-09-24

    申请号:US17893656

    申请日:2022-08-23

    CPC classification number: G06F3/065 G06F3/0614 G06F3/0679

    Abstract: Techniques are provided for synchronizing database system metadata between primary and standby persistent storage systems using an object store. A first persistent storage system enabled to store first configuration metadata describing the configuration of the first persistent storage system. A first broker process of the first persistent storage system detects receipt, at an object store endpoint, of a new version of an object message sent by a second broker process of a second persistent storage system. The object message specifies a particular value of a configuration attribute of second configuration metadata from the second persistent storage system. In response to detecting receipt of the new version of the object message, the first broker process reads the particular value of the configuration attribute in the object message. The first broker process sets the configuration attribute in the first configuration metadata to the particular value.

Patent Agency Ranking