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

1. 发明授权

US11550771B2 System and method for an ultra highly available, high performance, persistent memory optimized, scale-out database 有权
公开(公告)号：US11550771B2
公开(公告)日：2023-01-10
申请号：US17070277
申请日：2020-10-14
申请人： Oracle International Corporation
发明人： Jesse Kamp , Allison L. Holloway , Meichun Hsu , Hideaki Kimura , Boris Klots , Vasudha Krishnaswamy , Kartik Kulkarni , Teck Hua Lee , Yunrui Li , Aurosish Mishra , Ajit Mylavarapu , Sukhada Pendse , Garret F. Swart , Shasank K. Chavan , Tirthankar Lahiri , Juan R. Loaiza
IPC分类号： G06F16/22 , G06F16/27 , G06F16/21 , G06F16/174 , G06F16/18 , G06F16/23 , G06F16/11
摘要： A shared-nothing database system is provided in which parallelism and workload balancing are increased by assigning the rows of each table to “slices”, and storing multiple copies (“duplicas”) of each slice across the persistent storage of multiple nodes of the shared-nothing database system. When the data for a table is distributed among the nodes of a shared-nothing system in this manner, requests to read data from a particular row of the table may be handled by any node that stores a duplica of the slice to which the row is assigned. For each slice, a single duplica of the slice is designated as the “primary duplica”. All DML operations (e.g. inserts, deletes, updates, etc.) that target a particular row of the table are performed by the node that has the primary duplica of the slice to which the particular row is assigned. The changes made by the DML operations are then propagated from the primary duplica to the other duplicas (“secondary duplicas”) of the same slice.

2. 发明授权

US11514029B2 System and method for high performance multi-statement interactive transactions with snapshot isolation in a scale-out database 有权
公开(公告)号：US11514029B2
公开(公告)日：2022-11-29
申请号：US17136568
申请日：2020-12-29
申请人： Oracle International Corporation
发明人： Vasudha Krishnaswamy , Sukhada Pendse , Solmaz Kolahi , Ankita Kumar , Ajit Mylavarapu , Garret F. Swart , Tirthankar Lahiri , Juan R. Loaiza
IPC分类号： G06F16/23 , G06F16/27 , G06F16/21
摘要： A shared-nothing database system is provided in which parallelism and workload balancing are increased by assigning the rows of each table to “slices”, and storing multiple copies (“duplicas”) of each slice across the persistent storage of multiple nodes of the shared-nothing database system. When the data for a table is distributed among the nodes of a shared-nothing system in this manner, requests to read data from a particular row of the table may be handled by any node that stores a duplica of the slice to which the row is assigned. For each slice, a single duplica of the slice is designated as the “primary duplica”. All DML operations (e.g. inserts, deletes, updates, etc.) that target a particular row of the table are performed by the node that has the primary duplica of the slice to which the particular row is assigned. The changes made by the DML operations are then propagated from the primary duplica to the other duplicas (“secondary duplicas”) of the same slice.

3. 发明授权

US11256627B2 Directly mapped buffer cache on non-volatile memory 有权
公开(公告)号：US11256627B2
公开(公告)日：2022-02-22
申请号：US16907703
申请日：2020-06-22
申请人： Oracle International Corporation
发明人： Juan R. Loaiza , J. William Lee , Wei-Ming Hu , Kothanda Umamageswaran , Neil J. S. MacNaughton , Adam Y. Lee
IPC分类号： G06F12/0873 , G06F12/0868 , G06F12/0866 , G06F16/13 , G06F16/172
摘要： A method and an apparatus for implementing a buffer cache for a persistent file system in a non-volatile memory is provided. A set of data is maintained in one or more extents in a non-volatile random-access memory (NVRAM) of a computing device. At least one buffer header is allocated in a dynamic random-access memory (DRAM) of the computing device. In response to a read request by a first process executing on the computing device to access one or more first data blocks in a first extent of the one or more extents, the first process is granted direct read access of the first extent in the NVRAM. A reference to the first extent in the NVRAM is stored in a first buffer header. The first buffer header is associated with the first process. The first process uses the first buffer header to directly access the one or more first data blocks in the NVRAM.

4. 发明授权

US10956335B2 Non-volatile cache access using RDMA 有权
公开(公告)号：US10956335B2
公开(公告)日：2021-03-23
申请号：US15720972
申请日：2017-09-29
申请人： Oracle International Corporation
发明人： Zuoyu Tao , Jia Shi , Kothanda Umamageswaran , Juan R. Loaiza
IPC分类号： G06F12/0873 , G06F12/0864 , G06F16/22 , G06F16/2455 , G06F12/02 , G06F12/0868 , G06F12/0871 , G06F15/173
摘要： Data blocks are cached in a persistent cache (“NV cache”) allocated from as non-volatile RAM (“NVRAM”). The data blocks may be accessed in place in the NV cache of a “source” computing element by another “remote” computing element over a network using remote direct memory access (“RMDA”). In order for a remote computing element to access the data block in NV cache on a source computing element, the remote computing element needs the memory address of the data block within the NV cache. For this purpose, a hash table is stored and maintained in RAM on the source computing element. The hash table identifies the data blocks in the NV cache and specifies a location of the cached data block within the NV cache.

5. 发明申请

US20210073209A1 SUPPORTING BLOCKCHAIN COLLECTIONS IN A DATABASE 有权
公开(公告)号：US20210073209A1
公开(公告)日：2021-03-11
申请号：US16923279
申请日：2020-07-08
申请人： Oracle International Corporation
发明人： Juan R. Loaiza , Wei-Ming Hu , Amrish Srivastava , Mahesh Baburao Girkar , James W. Stamos
IPC分类号： G06F16/23 , G06F16/22 , H04L9/06
摘要： 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.

6. 发明申请

US20200042489A1 ONE-SIDED RELIABLE REMOTE DIRECT MEMORY OPERATIONS 审中-公开
公开(公告)号：US20200042489A1
公开(公告)日：2020-02-06
申请号：US16055978
申请日：2018-08-06
申请人： Oracle International Corporation
发明人： Tirthankar Lahiri , Juan R. Loaiza , Garret F. Swart , Jesse Kamp , Avneesh Pant , Hideaki Kimura
IPC分类号： G06F15/167 , G06F15/173 , G06F9/54 , G06F9/455
摘要： Techniques are provided to allow more sophisticated operations to be performed remotely by machines that are not fully functional. Operations that can be performed reliably by a machine that has experienced a hardware and/or software error are referred to herein as Remote Direct Memory Operations or “RDMOs”. Unlike RDMAs, which typically involve trivially simple operations such as the retrieval of a single value from the memory of a remote machine, RDMOs may be arbitrarily complex. The techniques described herein can help applications run without interruption when there are software faults or glitches on a remote system with which they interact.

7. 发明授权

US10380021B2 Rapid recovery from downtime of mirrored storage device 有权
公开(公告)号：US10380021B2
公开(公告)日：2019-08-13
申请号：US13801319
申请日：2013-03-13
申请人： Oracle International Corporation
发明人： Juan R. Loaiza , Kothanda Umamageswaran , David Friedman , Jia Shi , Zuoyu Tao , Alex Tsukerman
IPC分类号： G06F12/0868 , G06F12/0804 , G06F11/20 , G06F12/12
摘要： No-loss rapid recovery performs resynchronization efficiently while concurrently allowing availability to mirrored data on the storage device. No-loss rapid recovery has two stages and involves storage devices that have both a non-volatile cache and primary storage and that operate as mirror buddies. The first stage is referred to herein as the buddy-retention stage. During the buddy-retention stage, writes to mirrored data are not performed on the offline mirror buddy but are performed on the online mirror buddy. The mirrored data changed in the online mirrored buddy is retained in the non-volatile cache of the retention buddy. The next stage is referred to herein as the rapid resynchronization stage. In this stage, the changed mirrored data retained by the retention buddy for no-loss rapid recovery is used to resynchronize the offline buddy. The storage device is resynchronized using the changed mirrored data retained in the cache of the mirror buddy.

8. 发明授权

US10346315B2 Latchless, non-blocking dynamically resizable segmented hash index 有权
公开(公告)号：US10346315B2
公开(公告)日：2019-07-09
申请号：US15606327
申请日：2017-05-26
申请人： Oracle International Corporation
发明人： Siddharth Teotia , Krishna Kunchithapadam , Tirthankar Lahiri , Jesse Kamp , Michael J. Gleeson , Juan R. Loaiza , Garret F. Swart , Neil J. S. MacNaughton , Kam Shergill
IPC分类号： G06F16/22 , G06F16/901 , G06F12/1018 , G06F16/2453
摘要： 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.

9. 发明申请

US20190065383A1 DIRECTLY MAPPED BUFFER CACHE ON NON-VOLATILE MEMORY 审中-公开
公开(公告)号：US20190065383A1
公开(公告)日：2019-02-28
申请号：US15693273
申请日：2017-08-31
申请人： Oracle International Corporation
发明人： Juan R. Loaiza , J. William Lee , Wei-Ming Hu , Kothanda Umamageswaran , Neil J.S. MacNaughton , Adam Y. Lee
IPC分类号： G06F12/0873 , G06F17/30
摘要： A method and apparatus for implementing a buffer cache for a persistent file system in non-volatile memory is provided. A set of data is maintained in one or more extents in non-volatile random-access memory (NVRAM) of a computing device. At least one buffer header is allocated in dynamic random-access memory (DRAM) of the computing device. In response to a read request by a first process executing on the computing device to access one or more first data blocks in a first extent of the one or more extents, the first process is granted direct read access of the first extent in NVRAM. A reference to the first extent in NVRAM is stored in a first buffer header. The first buffer header is associated with the first process. The first process uses the first buffer header to directly access the one or more first data blocks in NVRAM.

10. 发明申请

US20150088805A1 AUTOMATIC CACHING OF SCAN AND RANDOM ACCESS DATA IN COMPUTING SYSTEMS 审中-公开
标题翻译：计算机系统中扫描和随机访问数据的自动访问
公开(公告)号：US20150088805A1
公开(公告)日：2015-03-26
申请号：US14489221
申请日：2014-09-17
申请人： Oracle International Corporation
发明人： Sarat B. Kakarla , Jia Shi , Selcuk Aya , Kothanda Umamageswaran , Juan R. Loaiza
IPC分类号： G06F17/30 , G06F12/08
CPC分类号： G06F17/3048 , G06F17/30306 , G06F17/30592
摘要： Approaches, techniques, and mechanisms are disclosed for improved caching in database systems that deal with multiple data access patterns, such as in database systems that interface with both OLTP and Data Warehouse clients. A cache is deployed between a database server and a storage system that stores data units. Some of the data units accessed by the database server are buffered within the cache. The data units may be associated with data access patterns, such as a random data access pattern or a scan data access pattern, in accordance with which the database server is or appears to be accessing the data units. A processor selects when to cache data units accessed by the database server, based at least on the associated data access patterns. Recent access counts may also be stored for the data units, and may further be utilized to select when to cache data units.
摘要翻译：披露了处理多种数据访问模式的数据库系统中的改进缓存的方法，技术和机制，例如在与OLTP和数据仓库客户端接口的数据库系统中。缓存部署在数据库服务器和存储数据单元的存储系统之间。数据库服务器访问的一些数据单元被缓存在缓存内。数据单元可以与诸如随机数据访问模式或扫描数据访问模式的数据访问模式相关联，数据库服务器根据该数据访问模式或者似乎正在访问数据单元。处理器至少基于相关联的数据访问模式来选择什么时候来高速缓存由数据库服务器访问的数据单元。也可以为数据单元存储最近的访问计数，并且还可以用于选择何时高速缓存数据单元。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式