-
公开(公告)号:US10248685B2
公开(公告)日:2019-04-02
申请号:US15253626
申请日:2016-08-31
Applicant: Oracle International Corporation
Inventor: Kartik Kulkarni , Juan R. Loaiza , Vivekanandhan Raja , Kothanda Umamageswaran , Sanket Hase , Vasudha Krishnaswamy , Tirthankar Lahiri
IPC: G06F17/30
Abstract: A minimum value (MV) is computed for start timestamps that each correspond to an uncommitted transaction. In an embodiment, the MV is computed for a pluggable database that is open on at least first and second instances of a database. The MV is computed for the first instance as of a first current timestamp (CT). The MV and the first CT are communicated to a second instance that has a second CT. If the first and second CTs are equal, the second instance store the MV. If the first CT is bigger, the second CT also becomes equal to the first CT. If the first CT is smaller, the MV is discarded, and the first CT becomes equal to the second CT. In an embodiment, if the MV remains unchanged for a predetermined time period, a start timestamp corresponding to the MV is advanced to a current or future timestamp.
-
52.
公开(公告)号:US20180341653A1
公开(公告)日:2018-11-29
申请号:US15606322
申请日:2017-05-26
Applicant: Oracle International Corporation
Inventor: Siddharth Teotia , Krishna Kunchithapadam , Jesse Kamp , Tirthankar Lahiri , Michael J. Gleeson , Juan R. Loaiza , Garret F. Swart , Neil J.S. MacNaughton , Kam Shergill
IPC: G06F17/30 , G06F15/173 , G06F12/1045
Abstract: Techniques are provided for enabling a requesting entity to retrieve data that is managed by a database server instance from the volatile memory of a server machine that is executing the database server instance. The techniques allow the requesting entity to retrieve the data from the volatile memory of the host server machine without involving the database server instance in the retrieval operation. Because the retrieval does not involve the database server instance, the retrieval may succeed even when the database server instance has stalled or become unresponsive. In addition, direct retrieval of data using the techniques described herein will often be faster and more efficient than retrieval of the same information through conventional interaction with the database server instance.
-
公开(公告)号:US20180341596A1
公开(公告)日:2018-11-29
申请号:US15606327
申请日:2017-05-26
Applicant: Oracle International Corporation
Inventor: Siddharth Teotia , Krishna Kunchithapadam , Tirthankar Lahiri , Jesse Kamp , Michael J. Gleeson , Juan R. Loaiza , Garret F. Swart , Neil J.S. MacNaughton , Kam Shergill
IPC: G06F12/1018 , G06F17/30
CPC classification number: G06F12/1018 , G06F12/0864 , G06F12/0868 , G06F12/126 , G06F12/128 , G06F16/2255 , G06F16/2453 , G06F16/9014 , G06F2212/1041 , G06F2212/313 , G06F2212/621
Abstract: A hashing scheme includes a cache-friendly, latchless, non-blocking dynamically resizable hash index with constant-time lookup operations that is also amenable to fast lookups via remote memory access. Specifically, the hashing scheme provides each of the following features: latchless reads, fine grained lightweight locks for writers, non-blocking dynamic resizability, cache-friendly access, constant-time lookup operations, amenable to remote memory access via RDMA protocol through one sided read operations, as well as non-RDMA access.
-
公开(公告)号:US20170116269A1
公开(公告)日:2017-04-27
申请号:US15331599
申请日:2016-10-21
Applicant: Oracle International Corporation
Inventor: Roger D. Macnicol , Viral Shah , Xia Hua , Jesse Kamp , Shasank K. Chavan , Maria Colgan , Tirthankar Lahiri , Adrian Tsz Him Ng , Krishnan Meiyyappan , Amit Ganesh , Juan R. Loaiza , Kothanda Umamageswaran , Yiran Qin
IPC: G06F17/30 , G06F12/0811 , G06F12/0897 , G06F3/06
CPC classification number: G06F16/24539 , G06F3/061 , G06F3/0647 , G06F3/065 , G06F3/067 , G06F12/0811 , G06F12/0897 , G06F16/22 , G06F16/221 , G06F2212/1016 , G06F2212/163 , G06F2212/225
Abstract: Techniques are provided for storing in in-memory unit (IMU) in a lower-storage tier and copying the IMU to DRAM when needed for query processing. Techniques are also provided for copying IMUs to lower tiers of storage when evicted from the cache of higher tiers of storage. Techniques are provided for implementing functionality of IMUs within a storage system, to enable database servers to push tasks, such as filtering, to the storage system where the storage system may access IMUs within its own memory to perform the tasks. Metadata associated with a set of data may be used to indicate whether an IMU for the data should be created by the database server machine or within the storage system.
-
公开(公告)号:US08977597B2
公开(公告)日:2015-03-10
申请号:US14073832
申请日:2013-11-06
Applicant: Oracle International Corporation
Inventor: Amit Ganesh , Juan R. Loaiza , Krishna Kunchithapadam
CPC classification number: G06F11/1474 , G06F17/30
Abstract: Techniques for maintaining a cascading index are provided. In one approach, one or more branch node compression techniques are applied to the main index of a cascading index. In an approach, a Bloom filter is generated and associated with, e.g., a branch node in the main index. The Bloom filter is used to determine whether, without accessing any leaf blocks, a particular key value exists, e.g., in leaf blocks associated with the branch node. In an approach, a new redo record is generated in response to a merge operation between two levels of the cascading index. The new redo record comprises (a) one or more addresses of blocks that are affected by the merge operation, (b) data is that being “pushed down” to a lower level of the cascading index, and (c) one or more addresses of blocks that are written to storage as a result of the merge operation.
Abstract translation: 提供了维护级联索引的技术。 在一种方法中,一个或多个分支节点压缩技术被应用于级联索引的主索引。 在一种方法中,生成Bloom过滤器并与例如主索引中的分支节点相关联。 Bloom过滤器用于确定在不访问任何叶片块的情况下是否存在特定的键值,例如在与分支节点相关联的叶片块中。 在一种方法中,响应于级联索引的两个级别之间的合并操作,生成新的重做记录。 新的重做记录包括(a)受合并操作影响的块的一个或多个地址,(b)数据被“下推”到级联索引的较低级,以及(c)一个或多个地址 作为合并操作的结果写入存储器的块。
-
公开(公告)号:US08874807B2
公开(公告)日:2014-10-28
申请号:US13971158
申请日:2013-08-20
Applicant: Oracle International Corporation
Inventor: Sue K. Lee , Vivekananda C. Kolla , Akshay D. Shah , Sumanta Chatterjee , Margaret Susairaj , Juan R. Loaiza , Alexander Tsukerman , Sridhar Subramaniam
CPC classification number: G06F17/30498 , G06F3/0611 , G06F3/0659 , G06F3/067 , G06F12/00 , G06F17/3033 , G06F17/30492
Abstract: Techniques are provided for managing, within a storage system, the sequence in which I/O requests are processed by the storage system based, at least in part, on one or more logical characteristics of the I/O requests. The logical characteristics may include, for example, the identity of the user for whom the I/O request was submitted, the service that submitted the I/O request, the database targeted by the I/O request, an indication of a consumer group to which the I/O request maps, the reason why the I/O request was issued, a priority category of the I/O request, etc. Techniques are also provided for automatically establishing a scheduling policy within a storage system, and for dynamically changing the scheduling policy in response to changes in workload.
Abstract translation: 提供了技术,用于至少部分地基于I / O请求的一个或多个逻辑特性在存储系统内管理由存储系统处理I / O请求的序列。 逻辑特征可以包括例如提交I / O请求的用户的身份,提交I / O请求的服务,I / O请求所针对的数据库,消费者组的指示 I / O请求映射到哪里,发出I / O请求的原因,I / O请求的优先类别等。还提供了用于在存储系统内自动建立调度策略,并且为了动态地 根据工作负载的变化改变调度策略。
-
公开(公告)号:US12298946B2
公开(公告)日:2025-05-13
申请号:US17966736
申请日:2022-10-14
Applicant: Oracle International Corporation
Inventor: Zhen Hua Liu , Juan R. Loaiza , Sundeep Abraham , Shubha Bose , Hui Joe Chang , Shashank Gugnani , Beda Christoph Hammerschmidt , Tirthankar Lahiri , Ying Lu , Douglas James McMahon , Aurosish Mishra , Ajit Mylavarapu , Sukhada Pendse , Ananth Raghavan
IPC: G06F16/20 , G06F16/21 , G06F16/2453 , G06F16/84
Abstract: JSON Duality Views are object views that return JDV objects. JDV objects are virtual because they are not stored in a database as JSON objects. Rather, JDV objects are stored in shredded form across tables and table attributes (e.g. columns) and returned by a DBMS in response to database commands that request a JDV object from a JSON Duality View. Through JSON Duality Views, changes to the state of a JDV object may be specified at the level of a JDV object. JDV objects are updated in a database using optimistic lock.
-
公开(公告)号:US12137172B2
公开(公告)日:2024-11-05
申请号:US17584640
申请日:2022-01-26
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor: Sachin Vijakumar Sonawane , Juan R. Loaiza , Mahesh Baburao Girkar , Mark Rakhmilevich , Wei-Ming Hu
Abstract: In Secure-Asynchronous Signing, when a record is inserted into a collection of records by a user, the user specifies a registered digital certificate to associate with the record. The digital certificate was previously registered by the user. To subsequently sign a record, the user provides a digital signature. The digital signature is validated using data in the record and a public key of the digital certificate that was associated with the row. Invalid digital signatures are detected and rejected regardless of how long afterward the attempt to sign the row occurs after inserting the row.
-
公开(公告)号:US20230281190A1
公开(公告)日:2023-09-07
申请号:US18117810
申请日:2023-03-06
Applicant: Oracle International Corporation
Inventor: Ajit Mylavarapu , Vasudha Krishnaswamy , Sukhada Pendse , Solmaz Kolahi , Ankita Kumar , Garret F. Swart , Juan R. Loaiza , Tirthankar Lahiri
CPC classification number: G06F16/2379 , G06F16/285
Abstract: One or more engine instances are executed on each host to form an engine cluster. A plurality of control instances are executed on a first set of hosts to form a control cluster and comprise a control instance leader and one or more control instance followers. In response to a first host indicating a failure of a neighbor host, a pair-wise focused investigation is initiated to check peer-to-peer connections between the first host and the neighbor host. In response to one or more additional hosts indicating failures of neighbor hosts while the pair-wise focused investigation is being performed, a wide investigation is performed to check connections between the control cluster and the plurality of hosts. One or more hosts are added to an eviction list and an eviction protocol is performed to evict the one or more hosts from the engine cluster using the eviction list.
-
公开(公告)号: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.
-
-
-
-
-
-
-
-
-