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

1. 发明申请

US20220114164A1 SYSTEM AND METHOD FOR HIGH PERFORMANCE MULTI-STATEMENT INTERACTIVE TRANSACTIONS WITH SNAPSHOT ISOLATION IN A SCALE-OUT DATABASE 有权
公开(公告)号：US20220114164A1
公开(公告)日：2022-04-14
申请号：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.

2. 发明授权

US10678791B2 Using shared dictionaries on join columns to improve performance of joins in relational databases 有权
公开(公告)号：US10678791B2
公开(公告)日：2020-06-09
申请号：US15602009
申请日：2017-05-22
申请人： Oracle International Corporation
发明人： Shasank K. Chavan , Dina Thomas , Ajit Mylavarapu , Prashant Gaharwar , Tirthankar Lahiri , Jesse Kamp
IPC分类号： G06F16/2453 , G06F16/22 , G06F16/9535 , G06F16/2455 , G06F7/24
摘要： Techniques are described for encoding join columns that belong to the same domain with a common dictionary. The tables are encoded with dictionary indexes that make the comparison operation of a join query a quick equality check of two integers and there is no need to compute any hashes during execution. Additionally, the techniques described herein minimize the bloom filter creation and evaluation cost as well because the dictionary indexes serve as hash values into the bloom filter. If the bloom filter is as large as the range of dictionary indexes, then the filter is no longer a probabilistic structure and can be used to filter rows in the probe phase with full certainty without any significant overhead.

3. 发明申请

US20190026339A1 Framework To Transfer Rows in Storage Format, Standard Format, or Combination Thereof 审中-公开
公开(公告)号：US20190026339A1
公开(公告)日：2019-01-24
申请号：US16040551
申请日：2018-07-20
申请人： ORACLE INTERNATIONAL CORPORATION
发明人： Mehul D. Bastawala , Ajit Mylavarapu
IPC分类号： G06F17/30
摘要： A server receives a query and checks how columns in rows responsive to the query are to be sent to a client. Based on one result of checking, the server prepares and transmits a redacted version of one or more rows or portions thereof. The redacted version may be prepared by discarding from the retrieved rows or portions thereof, any columns that are to not be sent, by applying a specific redaction technique, while maintaining columns that are to be sent in a database storage format in which the retrieved rows are stored. Based on another result of checking, the server prepares and transmits a raw version of the retrieved rows or portions thereof, in the database storage format. Based on yet another result of checking, the server extracts columns selected by the query to memory and sends processed versions of the rows or portions thereof.

4. 发明授权

US11971869B2 System and method for an ultra highly available, high performance, persistent memory optimized, scale-out database 有权
公开(公告)号：US11971869B2
公开(公告)日：2024-04-30
申请号：US17974152
申请日：2022-10-26
申请人： 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/11 , G06F16/174 , G06F16/18 , G06F16/21 , G06F16/23 , G06F16/27
CPC分类号： G06F16/2255 , G06F16/128 , G06F16/1756 , G06F16/1865 , G06F16/217 , G06F16/2322 , G06F16/27
摘要： 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.

5. 发明授权

US11599421B2 System and method for transaction continuity across failures in a scale-out database 有权
公开(公告)号：US11599421B2
公开(公告)日：2023-03-07
申请号：US17137745
申请日：2020-12-30
申请人： Oracle International Corporation
发明人： Ajit Mylavarapu , Vasudha Krishnaswamy , Sukhada Pendse , Solmaz Kolahi , Ankita Kumar , Garret F. Swart , Tirthankar Lahiri , Juan R. Loaiza
IPC分类号： G06F16/22 , G06F11/14
摘要： 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.

6. 发明申请

US20220114153A1 SYSTEM AND METHOD FOR AN ULTRA HIGHLY AVAILABLE, HIGH PERFORMANCE, PERSISTENT MEMORY OPTIMIZED, SCALE-OUT DATABASE 有权
公开(公告)号：US20220114153A1
公开(公告)日：2022-04-14
申请号：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/21 , G06F16/23 , G06F16/27 , G06F16/11 , G06F16/18 , G06F16/174
摘要： 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.

7. 发明申请

US20170255675A1 USING SHARED DICTIONARIES ON JOIN COLUMNS TO IMPROVE PERFORMANCE OF JOINS IN RELATIONAL DATABASES 审中-公开
公开(公告)号：US20170255675A1
公开(公告)日：2017-09-07
申请号：US15602009
申请日：2017-05-22
申请人： Oracle International Corporation
发明人： Shasank K. Chavan , Dina Thomas , Ajit Mylavarapu , Prashant Gaharwar , Tirthankar Lahiri , Jesse Kamp
IPC分类号： G06F17/30
摘要： Techniques are described for encoding join columns that belong to the same domain with a common dictionary. The tables are encoded with dictionary indexes that make the comparison operation of a join query a quick equality check of two integers and there is no need to compute any hashes during execution. Additionally, the techniques described herein minimize the bloom filter creation and evaluation cost as well because the dictionary indexes serve as hash values into the bloom filter. If the bloom filter is as large as the range of dictionary indexes, then the filter is no longer a probabilistic structure and can be used to filter rows in the probe phase with full certainty without any significant overhead.

8. 发明申请

US20140095448A1 AUTOMATED INFORMATION LIFECYCLE MANAGEMENT USING LOW ACCESS PATTERNS 有权
标题翻译：自动化信息使用低访问模式的生物管理
公开(公告)号：US20140095448A1
公开(公告)日：2014-04-03
申请号：US13826075
申请日：2013-03-14
申请人： ORACLE INTERNATIONAL CORPORATION
发明人： Vineet Marwah , Hariharan Lakshmanan , Ajit Mylavarapu , Prashant Gaharwar , Amit Ganesh
IPC分类号： G06F17/30
CPC分类号： G06F17/30221 , G06F3/0649 , G06F17/30073 , G06F17/30289 , G06F17/30306 , G06F17/30312 , G06F17/30575
摘要： A method, apparatus, and system for automated information lifecycle management using low access patterns in a database management system are provided. A user or the database can store policy data that defines an archiving action when meeting an activity-level condition on one or more database objects. The archiving actions may include compression, data movement, and other actions to place the database object in an appropriate storage tier for a lifecycle phase of the database object. The activity-level condition may specify the database object meeting a low access pattern, optionally for a minimum time period. Various criteria including access statistics for the database object and cost characteristics of current and target compression levels or storage tiers may be considered to determine the meeting of the activity-level condition. The policies may be evaluated on an adjustable periodic basis and may utilize a task scheduler for minimal performance impact.
摘要翻译：提供了一种在数据库管理系统中使用低访问模式的自动信息生命周期管理的方法，装置和系统。用户或数据库可以存储在满足一个或多个数据库对象上的活动级别条件时定义归档操作的策略数据。归档操作可以包括压缩，数据移动和其他动作，以将数据库对象放置在数据库对象的生命周期阶段的适当的存储层中。活动级别条件可以指定满足低访问模式的数据库对象，可选地在最短时间段内。可以考虑包括数据库对象的访问统计和当前和目标压缩级别或存储层的成本特征的各种标准来确定活动级别条件的会议。这些策略可以在可调周期的基础上进行评估，并且可以利用任务调度器来最小的性能影响。

9. 发明公开

US20240126763A1 EXTENDING DATABASE DATA WITH INTENDED USAGE INFORMATION 审中-公开
公开(公告)号：US20240126763A1
公开(公告)日：2024-04-18
申请号：US18099034
申请日：2023-01-19
申请人： Oracle International Corporation
发明人： Tirthankar Lahiri , Juan R. Loaiza , Beda Christoph Hammerschmidt , Andrew Witkowski , Sankar Subramanian , Sabina Petride , Ajit Mylavarapu , Gerald Venzl
IPC分类号： G06F16/2455 , G06F16/22
CPC分类号： G06F16/24565 , G06F16/221 , G06F16/24554
摘要： Disclosed herein are techniques for storing, within a database system, metadata that indicates an intended usage (IU). Once created, an IU may be assigned to a column to (a) indicate how the column is intended to be used, and (b) affect how the database server behaves when database operations involve values from the column. The IU assigned to a column supplements, but does not replace, the datatype definition for the column. Each IU may have an IU-bundle. The IU-bundle of an IU indicates how the database server behaves with respect to any column that is assigned the IU. For example, the IU-bundle may indicate constraints that the database server must validate during operations on values from columns assigned to the IU. Techniques are also described for implementing multi-column IUs and flexible IUs.

10. 发明授权

US11556505B2 Policy driven data placement and information lifecycle management 有权
公开(公告)号：US11556505B2
公开(公告)日：2023-01-17
申请号：US17159070
申请日：2021-01-26
申请人： ORACLE INTERNATIONAL CORPORATION
发明人： Vineet Marwah , Hariharan Lakshmanan , Ajit Mylavarapu , Prashant Gaharwar , Amit Ganesh
IPC分类号： G06F16/185 , G06F16/21 , G06F16/22 , G06F16/27 , G06F16/11 , G06F3/06
摘要： A method, apparatus, and system for policy driven data placement and information lifecycle management in a database management system are provided. A user or database application can specify declarative policies that define the movement and transformation of stored database objects. The policies are associated with a database object and may also be inherited. A policy defines, for a database object, an archiving action to be taken, a scope, and a condition before the archiving action is triggered. Archiving actions may include compression, data movement, table clustering, and other actions to place the database object into an appropriate storage tier for a lifecycle phase of the database object. Conditions based on access statistics can be specified at the row level and may use segment or block level heatmaps. Policy evaluation occurs periodically in the background, with actions queued as tasks for a task scheduler.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式