Selectively reading data from cache and primary storage
    1.
    发明授权
    Selectively reading data from cache and primary storage 有权
    从缓存和主存储中选择性地读取数据

    公开(公告)号:US09361232B2

    公开(公告)日:2016-06-07

    申请号:US13839251

    申请日:2013-03-15

    Abstract: Techniques are provided for using an intermediate cache to provide some of the items involved in a scan operation, while other items involved in the scan operation are provided from primary storage. Techniques are also provided for determining whether to service an I/O request for an item with a copy of the item that resides in the intermediate cache based on factors such as a) an identity of the user for whom the I/O request was submitted, b) an identity of a service that submitted the I/O request, c) an indication of a consumer group to which the I/O request maps, or d) whether the intermediate cache is overloaded. Techniques are also provided for determining whether to store items in an intermediate cache in response to the items being retrieved, based on logical characteristics associated with the requests that retrieve the items.

    Abstract translation: 提供了使用中间缓存来提供扫描操作中涉及的一些项目的技术,而从主存储器提供涉及扫描操作的其他项目。 还提供了用于基于以下因素来确定是否对具有驻留在中间高速缓存中的项目的副本的项目的I / O请求进行服务的技术,例如:a)向其提交I / O请求的用户的身份 ,b)提交I / O请求的服务的身份,c)I / O请求所映射的消费者组的指示,或d)中间缓存是否过载。 还提供了基于与检索项目的请求相关联的逻辑特征来确定是否将项目存储在中间高速缓存中以响应于正被检索的项目的技术。

    SELECTIVELY READING DATA FROM CACHE AND PRIMARY STORAGE
    2.
    发明申请
    SELECTIVELY READING DATA FROM CACHE AND PRIMARY STORAGE 有权
    从缓存和初级存储中选择读取数据

    公开(公告)号:US20130212332A1

    公开(公告)日:2013-08-15

    申请号:US13839251

    申请日:2013-03-15

    Abstract: Techniques are provided for using an intermediate cache to provide some of the items involved in a scan operation, while other items involved in the scan operation are provided from primary storage. Techniques are also provided for determining whether to service an I/O request for an item with a copy of the item that resides in the intermediate cache based on factors such as a) an identity of the user for whom the I/O request was submitted, b) an identity of a service that submitted the I/O request, c) an indication of a consumer group to which the I/O request maps, or d) whether the intermediate cache is overloaded. Techniques are also provided for determining whether to store items in an intermediate cache in response to the items being retrieved, based on logical characteristics associated with the requests that retrieve the items.

    Abstract translation: 提供了使用中间缓存来提供扫描操作中涉及的一些项目的技术,而从主存储器提供涉及扫描操作的其他项目。 还提供了用于基于以下因素来确定是否对具有驻留在中间高速缓存中的项目的副本的项目的I / O请求进行服务的技术,例如:a)向其提交I / O请求的用户的身份 ,b)提交I / O请求的服务的身份,c)I / O请求所映射的消费者组的指示,或d)中间缓存是否过载。 还提供了基于与检索项目的请求相关联的逻辑特征来确定是否将项目存储在中间高速缓存中以响应于正被检索的项目的技术。

    Method for intelligent, dynamic, realtime, online relocation of pluggable databases across nodes based on system resource pressure

    公开(公告)号:US12242438B1

    公开(公告)日:2025-03-04

    申请号:US18494597

    申请日:2023-10-25

    Abstract: Techniques are provided for implementing a pluggable database monitoring system that groups running processes for the pluggable database into a grouping and monitors resource usage for the grouping to determine whether to migrate the pluggable database to another container. A system identifies a set of running processes associated with a pluggable database. The pluggable database is hosted on a container DBMS, which is hosted on a virtual machine. The system generates a first grouping that contains the set of running processes. The system monitors, in real-time, aggregated resource usage of the first grouping to determine if the aggregated resource usage exceeds a first threshold. In response to the aggregated resource usage of the first grouping exceeding the first threshold, the system migrates the first pluggable database to a second container DBMS.

    Management of shared storage I/O resources
    4.
    发明授权
    Management of shared storage I/O resources 有权
    管理共享存储I / O资源

    公开(公告)号:US09436389B2

    公开(公告)日:2016-09-06

    申请号:US14529436

    申请日:2014-10-31

    CPC classification number: G06F3/061 G06F3/0659 G06F3/067 G06F3/0683

    Abstract: Automated management of shared I/O resources involves use of a policy engine for implementing I/O scheduling group I/O policies. The I/O policies are used for determining whether corresponding I/O requests should be issued to a shared storage system immediately or should be delayed via corresponding policy-based queues. In the context of database systems, a database administrator can specify policies regarding how I/O resources should be used and the database system itself enforces the policies, rather than requiring the database administrator enforce the I/O usage of the database and of the individual users.

    Abstract translation: 共享I / O资源的自动管理涉及使用策略引擎实现I / O调度组I / O策略。 I / O策略用于确定是否应立即向共享存储系统发出相应的I / O请求,或者应通过相应的基于策略的队列进行延迟。 在数据库系统的上下文中,数据库管理员可以指定关于如何使用I / O资源的策略,并且数据库系统本身实施策略,而不是要求数据库管理员强制执行数据库和个人的I / O使用 用户

    EFFICIENT DUAL-OBJECTIVE CACHE
    6.
    发明申请

    公开(公告)号:US20180081959A1

    公开(公告)日:2018-03-22

    申请号:US15685489

    申请日:2017-08-24

    Abstract: Techniques are described herein for effectively managing usage of a shared object cache in a container database management system (DBMS). The shared object cache maintains shared objects belonging to a set of pluggable databases (PDBs) hosted by the container DBMS. In an embodiment, a shared object metadata extension structure (SOMEX) is maintained for each PDB. The SOMEX stores metadata for each shared object of the PDB that resides in the shared object cache. In an embodiment, a share of the shared object cache is maintained for shared objects from each PDB in the set of PDBs based on entries in the SOMEX for the PDB.

    Management Of Shared Storage I/O Resources
    8.
    发明申请
    Management Of Shared Storage I/O Resources 有权
    共享存储I / O资源管理

    公开(公告)号:US20150058498A1

    公开(公告)日:2015-02-26

    申请号:US14529436

    申请日:2014-10-31

    CPC classification number: G06F3/061 G06F3/0659 G06F3/067 G06F3/0683

    Abstract: Automated management of shared I/O resources involves use of a policy engine for implementing I/O scheduling group I/O policies. The I/O policies are used for determining whether corresponding I/O requests should be issued to a shared storage system immediately or should be delayed via corresponding policy-based queues. In the context of database systems, a database administrator can specify policies regarding how I/O resources should be used and the database system itself enforces the policies, rather than requiring the database administrator enforce the I/O usage of the database and of the individual users.

    Abstract translation: 共享I / O资源的自动管理涉及使用策略引擎实现I / O调度组I / O策略。 I / O策略用于确定是否应立即向共享存储系统发出相应的I / O请求,或者应通过相应的基于策略的队列进行延迟。 在数据库系统的上下文中,数据库管理员可以指定关于如何使用I / O资源的策略,并且数据库系统本身实施策略,而不是要求数据库管理员强制执行数据库和个人的I / O使用 用户

Patent Agency Ranking