-
公开(公告)号：US20180060377A1
公开(公告)日：2018-03-01
申请号：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
CPC classification number: G06F17/30371 , G06F17/30368 , G06F17/30377 , G06F17/3056
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.
-
公开(公告)号：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.
-
公开(公告)号：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.
-
公开(公告)号：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.
-
15.发明申请公开(公告)号：US20160026684A1
公开(公告)日：2016-01-28
申请号：US14805949
申请日：2015-07-22
Applicant: Oracle International Corporation
Inventor： Niloy Mukherjee , Vineet Marwah , Hui Jin , Kartik Kulkarni
CPC classification number: G06F17/30545 , G06F3/061 , G06F3/064 , G06F3/0644 , G06F3/067
Abstract: Techniques are described herein for executing queries on distinct portions of a database object that has been separate into chunks and distributed across the volatile memories of a plurality of nodes in a clustered database system. The techniques involve receiving a query that requires work to be performed on data that resides in a plurality of on disk extents. A parallel query coordinator that is aware of the in-memory distribution divides the work into granules that align with the in-memory separation. The parallel query coordinator then sends each granule to the database server instance with local in memory access to the data required by the granule and aggregates the results to respond to the query.
Abstract translation: 这里描述了用于执行已经分离成块并且分布在群集数据库系统中的多个节点的易失性存储器上的数据库对象的不同部分的技术。 这些技术涉及接收需要对位于多个磁盘盘区上的数据执行工作的查询。 意识到内存分配的并行查询协调器将工作分成与内存分离对齐的颗粒。 并行查询协调器然后将每个粒子发送到数据库服务器实例，并使用本地内存访问粒子所需的数据，并聚合结果以响应查询。
-
Patent Agency Ranking
16.发明申请公开(公告)号：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: 这里描述了用于在集群数据库系统中的多个节点的易失性存储器之间分布数据库对象的不同部分的技术。 该技术涉及将位于多节点集群中的节点上的单个数据库服务器实例设置为用于特定数据集的加载操作主机。 加载操作主机确定数据集如何使用散列函数分成块。 然后，负载操作主机向其他数据库服务器广播一小部分一致性信息，因此每个数据库服务器可以独立地执行散列函数并独立地加载其分配的数据块。
-
公开(公告)号：US11550771B2
公开(公告)日：2023-01-10
申请号：US17070277
申请日：2020-10-14
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
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.
-
18.发明授权公开(公告)号：US10747752B2
公开(公告)日：2020-08-18
申请号：US15892677
申请日：2018-02-09
Applicant: Oracle International Corporation
Inventor： Vasudha Krishnaswamy , Kartik Kulkarni , Sukhada Pendse , Akshay Kulkarni
IPC: G06F16/22 , G06F16/23 , G06F16/27 , G06F3/06 , G06F16/25 , G06F11/00 , G06F11/20 , G06F11/14 , G06F11/16
Abstract: Embodiments store transaction metadata in dedicated pools of allocated memory chunks. Portions of the pools of allocated memory chunks are dedicated to the respective apply slave processes that mine and process change records. Also, the pools of allocated memory chunks are anchored within the structure of a transaction log such that buffering and application of metadata for one transaction does not block required buffering and application of metadata for other transactions. The standby database system pre-processes transaction metadata in preparation for application of the metadata to invalidate appropriate portions of MF data. Further, embodiments divide the work of pre-processing invalidation records among the many apply slave processes that record the invalidation records. A garbage collection selects memory chunks for garbage collection in reverse order of how the chunks were allocated. Also, a deduplication algorithm ensures that typically only a single invalidation message per block is applied to invalidate MF data.
-
公开(公告)号：US10528580B2
公开(公告)日：2020-01-07
申请号：US15008297
申请日：2016-01-27
Applicant: Oracle International Corporation
Inventor： Niloy Mukherjee , Kartik Kulkarni , Tirthankar Lahiri , Vineet Marwah , Juan Loaiza
IPC: G06F17/30 , H04L12/24 , G06F16/2458 , H04L12/26
Abstract: Techniques are described herein for executing queries on distinct portions of a database object that has been separate into chunks and distributed across the volatile memories of a plurality of nodes in a clustered database system. The techniques involve redistributing the in-memory database object portions on changes to the clustered database system. Each node may maintain a mapping indicating which nodes in the clustered database system store which chunks, and timestamps indicating when each mapping entry was created or updated. A query coordinator may use the timestamps to select a database server instance with local in memory access to data required by a portion of a query to process that portion of the query.
-
公开(公告)号：US10275184B2
公开(公告)日：2019-04-30
申请号：US14805949
申请日：2015-07-22
Applicant: Oracle International Corporation
Inventor： Niloy Mukherjee , Vineet Marwah , Hui Jin , Kartik Kulkarni
IPC: G06F7/02 , G06F16/00 , G06F3/06 , G06F16/2458
Abstract: Techniques are described herein for executing queries on distinct portions of a database object that has been separate into chunks and distributed across the volatile memories of a plurality of nodes in a clustered database system. The techniques involve receiving a query that requires work to be performed on data that resides in a plurality of on disk extents. A parallel query coordinator that is aware of the in-memory distribution divides the work into granules that align with the in-memory separation. The parallel query coordinator then sends each granule to the database server instance with local in memory access to the data required by the granule and aggregates the results to respond to the query.
-
-
-
-
-
-
-
-
-
Search Results
22
records
(took 0.019 seconds)
