专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US11372859B2 Efficiently supporting value style access of MOBs stored in SQL LOB column by providing value based semantics for LOBs in RDBMS 有权
公开(公告)号：US11372859B2
公开(公告)日：2022-06-28
申请号：US16570356
申请日：2019-09-13
申请人： Oracle International Corporation
发明人： Zhen Hua Liu , Geeta Arora , Sriram Krishnamurthy , Sneha Chandrababu , Sunitha Subramanyam
IPC分类号： G06F17/30 , G06F16/2455 , G06F16/22 , G06F16/28
摘要： Described are improved systems, computer program products, and methods for an improved approach to access small to medium size objects (MOBs) stored in LOB data type columns of a RDBMS. The approach includes receiving a SQL statement comprising a retrieval of a large object (LOB). The approach also includes determining whether to return a value of the LOB or a reference to a storage location storing the value of the LOB based on: a data dictionary property of the LOB to return the value of the LOB, a function included in the SQL statement to return the value of the LOB, or a flag derived from a SQL operator tree propagation to return the value of the LOB.

2. 发明申请

US20140372702A1 HANDLING MEMORY PRESSURE IN AN IN-DATABASE SHARDED QUEUE 有权
标题翻译：在数据库中处理记忆压力
公开(公告)号：US20140372702A1
公开(公告)日：2014-12-18
申请号：US14165974
申请日：2014-01-28
申请人： Oracle International Corporation
发明人： Sunitha Subramanyam , Shubha Bose , Anil Madan , Devendra Singh , James W. Stamos , Mukesh Jaiswal
IPC分类号： G06F12/08
CPC分类号： G06F12/0848 , G06F12/0868 , G06F17/30067 , G06F2212/465
摘要： Handling memory pressure in an in-database sharded queue is described. Messages from a plurality of enqueuers are stored in a plurality of shards of a sharded queue. Messages from a first enqueuer are stored in a first shard. A queue table corresponding to the sharded queue is maintained. In volatile memory, a plurality of message caches is maintained, each message cache corresponding to a shard of the plurality of shards. Memory pressure is detected based on memory usage of the volatile memory. To store a specific message from the enqueuer, the specific message is stored in rows of the queue table that are assigned to the first shard. When memory pressure is not detected, the specific message is stored in a first message cache corresponding to the first shard. Subscribers of the sharded queue are caused to dequeue messages from the plurality of shards.
摘要翻译：描述处理数据库内的分片队列中的内存压力。来自多个入站者的消息被存储在分片队列的多个分片中。来自第一个进入者的消息存储在第一个分片中。维护与分片队列对应的队列表。在易失性存储器中，维护多个消息高速缓存，每个消息高速缓存对应于多个分片中的分片。基于易失性存储器的存储器使用来检测存储器压力。要从进入者存储特定消息，特定消息存储在分配给第一个分片的队列表的行中。当未检测到存储器压力时，特定消息存储在与第一分片对应的第一消息高速缓存中。导致分片队列的订阅者从多个分片中发出消息。

3. 发明授权

US09495296B2 Handling memory pressure in an in-database sharded queue 有权
标题翻译：处理数据库内的分片队列中的内存压力
公开(公告)号：US09495296B2
公开(公告)日：2016-11-15
申请号：US14165974
申请日：2014-01-28
申请人： Oracle International Corporation
发明人： Sunitha Subramanyam , Shubha Bose , Anil Madan , Devendra Singh , James W. Stamos , Mukesh Jaiswal
IPC分类号： G06F17/30 , G06F12/08
CPC分类号： G06F12/0848 , G06F12/0868 , G06F17/30067 , G06F2212/465
摘要： Handling memory pressure in an in-database sharded queue is described. Messages from a plurality of enqueuers are stored in a plurality of shards of a sharded queue. Messages from a first enqueuer are stored in a first shard. A queue table corresponding to the sharded queue is maintained. In volatile memory, a plurality of message caches is maintained, each message cache corresponding to a shard of the plurality of shards. Memory pressure is detected based on memory usage of the volatile memory. To store a specific message from the enqueuer, the specific message is stored in rows of the queue table that are assigned to the first shard. When memory pressure is not detected, the specific message is stored in a first message cache corresponding to the first shard. Subscribers of the sharded queue are caused to dequeue messages from the plurality of shards.
摘要翻译：描述处理数据库内的分片队列中的内存压力。来自多个入站者的消息被存储在分片队列的多个分片中。来自第一个进入者的消息存储在第一个分片中。维护与分片队列对应的队列表。在易失性存储器中，维护多个消息高速缓存，每个消息高速缓存对应于多个分片中的分片。基于易失性存储器的存储器使用来检测存储器压力。要从进入者存储特定消息，特定消息存储在分配给第一个分片的队列表的行中。当未检测到存储器压力时，特定消息存储在与第一分片对应的第一消息高速缓存中。导致分片队列的订阅者从多个分片中发出消息。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式