-
51.发明申请公开(公告)号：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.
-
公开(公告)号：US20180144023A1
公开(公告)日：2018-05-24
申请号：US15877125
申请日：2018-01-22
Applicant: Oracle International Corporation
Inventor： Jesse Kamp , Amit Ganesh , Vineet Marwah , Vivekanandhan Raja , Tirthankar Lahiri , Allison L. Holloway , Sanket Hase , Shasank K. Chavan , Niloy Mukherjee , Teck Hua Lee , Michael J. Gleeson , Krishna Kunchithapadam
CPC classification number: G06F17/30377 , G06F3/0619 , G06F3/065 , G06F3/0665 , G06F3/0689 , G06F11/2058 , G06F17/30315 , G06F17/30442 , G06F17/30575 , G06F17/30581 , G06F2201/80 , G06F2201/855
Abstract: Techniques are provided for maintaining data persistently in one format, but making that data available to a database server in more than one format. For example, one of the formats in which the data is made available for query processing is based on the on-disk format, while another of the formats in which the data is made available for query processing is independent of the on-disk format. Data that is in the format that is independent of the disk format may be maintained exclusively in volatile memory to reduce the overhead associated with keeping the data in sync with the on-disk format copies of the data.
-
公开(公告)号：US20180096010A1
公开(公告)日：2018-04-05
申请号：US15281718
申请日：2016-09-30
Applicant: Oracle International Corporation
Inventor： Niloy Mukherjee , Jesse Kamp , Tirthankar Lahiri , Maria Colgan , Vivekanandhan Raja , Vasudha Krishnaswamy , Aditi Gupta , Kartik Kulkarni
CPC classification number: G06F16/221 , G06F3/0604 , G06F3/064 , G06F3/067 , G06F16/2282 , G06F16/24552 , G06F16/27
Abstract: Techniques are described herein for distributing distinct portions of a database object across volatile memories of selected nodes of a plurality of nodes in a clustered database system. The techniques involve storing a unit-to-service mapping that associates a unit (a database object or portion thereof) to one or more database services. The one or more database services are mapped to one or more nodes. The nodes to which a service is mapped may include nodes in disjoint database systems, so long as those database systems have access to a replica of the unit. The database object is treated as in-memory enabled by nodes that are associated with the service, and are treated as not in-memory enabled by nodes that are not associated with the service.
-
公开(公告)号：US20180081767A1
公开(公告)日：2018-03-22
申请号：US15273273
申请日：2016-09-22
Applicant: Oracle International Corporation
Inventor： Xiaoming He , Vivekanandhan Raja , Tirthankar Lahiri , Sanket Hase
Abstract: Techniques are described for maintaining coherency of a portion of a database object mirrored in a particular node of a database. The techniques involve maintaining invalidation logs which identify transactions that have committed to a database. Based on the invalidation logs, the particular node generates invalid-row ID metadata which identifies, for each system change number, one or more rows that are not transactionally consistent with data stored in the database object as of said system change number.
-
Patent Agency Ranking
公开(公告)号：US09875259B2
公开(公告)日：2018-01-23
申请号：US14565906
申请日：2014-12-10
Applicant: Oracle International Corporation
Inventor： Niloy Mukherjee , Tirthankar Lahiri , Vineet Marwah , Kartik Kulkarni
CPC classification number: G06F17/30289 , G06F12/023 , G06F17/3033 , G06F17/30566 , G06F2212/251
Abstract: Techniques are described herein for distributing distinct portions of a database object across the volatile memories of a plurality of nodes in a clustered database system. The techniques involve establishing a single database server instance located on a node in a multi-node cluster as a load-operation master for a particular data set. The load-operation master determines how the data set may be separated into chunks using a hash function. The load-operation master then broadcasts a small payload of consistency information to other database servers, so each database server may independently execute the hash function and independently load their respectively assigned chunks of data.
-
公开(公告)号：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.
-
58.发明申请公开(公告)号：US20160026660A1
公开(公告)日：2016-01-28
申请号：US14565906
申请日：2014-12-10
Applicant: Oracle International Corporation
Inventor： Niloy Mukherjee , Tirthankar Lahiri , Vineet Marwah , Kartik Kulkarni
CPC classification number: G06F17/30289 , G06F12/023 , G06F17/3033 , G06F17/30566 , G06F2212/251
Abstract: Techniques are described herein for distributing distinct portions of a database object across the volatile memories of a plurality of nodes in a clustered database system. The techniques involve establishing a single database server instance located on a node in a multi-node cluster as a load-operation master for a particular data set. The load-operation master determines how the data set may be separated into chunks using a hash function. The load-operation master then broadcasts a small payload of consistency information to other database servers, so each database server may independently execute the hash function and independently load their respectively assigned chunks of data.
Abstract translation: 这里描述了用于在集群数据库系统中的多个节点的易失性存储器之间分布数据库对象的不同部分的技术。 该技术涉及将位于多节点集群中的节点上的单个数据库服务器实例设置为用于特定数据集的加载操作主机。 加载操作主机确定数据集如何使用散列函数分成块。 然后，负载操作主机向其他数据库服务器广播一小部分一致性信息，因此每个数据库服务器可以独立地执行散列函数并独立地加载其分配的数据块。
-
公开(公告)号：US11971869B2
公开(公告)日：2024-04-30
申请号：US17974152
申请日：2022-10-26
Applicant: Oracle International Corporation
Inventor： 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
CPC classification number: G06F16/2255 , G06F16/128 , G06F16/1756 , G06F16/1865 , G06F16/217 , G06F16/2322 , G06F16/27
Abstract: 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.
-
公开(公告)号：US20240119031A1
公开(公告)日：2024-04-11
申请号：US18115629
申请日：2023-02-28
Applicant: Oracle International Corporation
Inventor： Tirthankar Lahiri , Srikrishnan Suresh , Beda Christoph Hammerschmidt , Adrian Daniel Popescu , Jesse Kamp , Zhen Hua Liu
CPC classification number: G06F16/212 , G06F16/2365 , G06F16/258
Abstract: A computer analyzes a relational schema of a database to generate a data entry schema and encodes the data entry schema as JSON. The data entry schema is sent to a database client so that the client can validate entered data before the entered data is sent for storage. From the client, entered data is received that conforms to the data entry schema because the client used the data entry schema to validate the entered data before sending the data. Into the database, the entered data is stored that conforms to the data entry schema. The data entry schema and the relational schema have corresponding constraints on a datum to be stored, such as a range limit for a database column or an express set of distinct valid values. A constraint may specify a format mask or regular expression that values in the column should conform to, or a correlation between values of multiple columns.
-
-
-
-
-
-
-
-
-
Search Results
96
records
(took 0.024 seconds)
