知搜-全球专利检索

  1. Login
  2. Sign Up

Search Results

21 records (took 0.021 seconds)

    Custom policy driven data placement and information lifecycle management
    11.
    发明授权
    Custom policy driven data placement and information lifecycle management 有权

    公开(公告)号：US10318493B2

    公开(公告)日：2019-06-11

    申请号：US13804581

    申请日：2013-03-14

    Applicant: Oracle International Corporation

    Inventor： Vineet Marwah ,  Hariharan Lakshmanan ,  Ajit Mylavarapu ,  Prashant Gaharwar ,  Amit Ganesh

    IPC: G06F17/30 ,  G06F3/06 ,  G06F16/185 ,  G06F16/21 ,  G06F16/22 ,  G06F16/27 ,  G06F16/11

    Abstract: A method, apparatus, and system for custom policy driven data placement and information lifecycle management in a database management system are provided. A user or database application can specify declarative custom policies that define the movement and transformation of stored database objects. A custom policy defines, for a database object, a custom function to evaluate on an associated database object to determine whether an 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. The custom function is defined by the database user, and can flexibly include any customized business logic using data sources internal and external to the database, including database access statistics such as segment level or block level heatmaps.

    PERIODIC PERFORMANCE OPTIMIZATION THROUGH HEATMAP BASED MANAGEMENT OF AN IN-MEMORY AREA
    12.
    发明申请
    PERIODIC PERFORMANCE OPTIMIZATION THROUGH HEATMAP BASED MANAGEMENT OF AN IN-MEMORY AREA 审中-公开

    公开(公告)号：US20170116232A1

    公开(公告)日：2017-04-27

    申请号：US14922086

    申请日：2015-10-23

    Applicant: Oracle International Corporation

    Inventor： Vineet Marwah ,  Amit Ganesh ,  Hariharan Lakshmanan ,  Prashant Gaharwar ,  Dhruvil Shah

    IPC: G06F17/30

    CPC classification number: G06F16/217

    Abstract: A method, apparatus, and system for periodic performance optimization through heatmap based management of an in-memory area are provided. A heatmap is maintained to track database accesses, and a sliding most recent time window of the heatmap is externalized to a desired granularity level to provide access statistics regarding candidate elements to be possibly placed in the in-memory area. Initially and on a periodic basis, an appropriate knapsack algorithm is chosen based on an analysis on the computational costs versus the benefits of applying various knapsack algorithms for the candidate elements. Using the chosen algorithm in conjunction with a selected performance model, an optimized configuration of the in-memory area is determined. The optimized configuration indicates a set of elements chosen from the candidate elements, optionally specified with compression levels. A task scheduler then schedules the appropriate tasks, working in a coordinated fashion, to reconfigure the in-memory area according to the optimized configuration.

    Policy Driven Data Placement And Information Lifecycle Management
    13.
    发明申请
    Policy Driven Data Placement And Information Lifecycle Management 审中-公开
    政策驱动的数据放置和信息生命周期管理

    公开(公告)号：US20140095449A1

    公开(公告)日：2014-04-03

    申请号：US13804394

    申请日：2013-03-14

    Applicant: ORACLE INTERNATIONAL CORPORATION

    Inventor： Vineet Marwah ,  Hariharan Lakshmanan ,  Ajit Mylavarapu ,  Prashant Gaharwar ,  Amit Ganesh

    IPC: G06F17/30

    CPC classification number: G06F16/185 ,  G06F3/0649 ,  G06F16/113 ,  G06F16/21 ,  G06F16/217 ,  G06F16/22 ,  G06F16/27 ,  G06F17/30073 ,  G06F17/30221 ,  G06F17/30289 ,  G06F17/30306 ,  G06F17/30312 ,  G06F17/30575

    Abstract: 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.

    Abstract translation: 提供了一种用于数据库管理系统中的策略驱动数据放置和信息生命周期管理的方法，装置和系统。 用户或数据库应用程序可以指定定义存储的数据库对象的移动和转换的声明性策略。 策略与数据库对象相关联，也可以被继承。 在触发归档操作之前，策略为数据库对象定义要执行的归档操作，作用域和条件。 归档操作可能包括压缩，数据移动，表集群和其他操作，以将数据库对象放入适用于数据库对象生命周期阶段的存储层。 可以在行级别指定基于访问统计信息的条件，并可以使用段或块级散热图。 策略评估在后台定期进行，操作会作为任务调度程序的任务进行排队。

    Policy driven data placement and information lifecycle management
    14.
    发明授权
    Policy driven data placement and information lifecycle management 有权

    公开(公告)号：US10949403B2

    公开(公告)日：2021-03-16

    申请号：US13804394

    申请日：2013-03-14

    Applicant: Oracle International Corporation

    Inventor： Vineet Marwah ,  Hariharan Lakshmanan ,  Ajit Mylavarapu ,  Prashant Gaharwar ,  Amit Ganesh

    IPC: G06F16/185 ,  G06F16/21 ,  G06F16/22 ,  G06F16/27 ,  G06F16/11 ,  G06F3/06

    Abstract: 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.

    In-memory column-level multi-versioned global dictionary for in-memory databases
    15.
    发明授权
    In-memory column-level multi-versioned global dictionary for in-memory databases 有权

    公开(公告)号：US10726016B2

    公开(公告)日：2020-07-28

    申请号：US15294460

    申请日：2016-10-14

    Applicant: Oracle International Corporation

    Inventor： Shasank K. Chavan ,  Prashant Gaharwar ,  Ajit Mylavarapu ,  Dina Thomas ,  Dennis Lui ,  Sheldon A. K. Lewis ,  Roger D. Macnicol

    IPC: G06F16/2455 ,  G06F16/22 ,  G06F16/33

    Abstract: Techniques are described herein for sharing a dictionary across multiple in-memory compression units (IMCUs). After a dictionary is used to encode a first column vector in a first IMCU, the same dictionary is used to encode a second column vector in a second IMCU. The entries in the dictionary are in sort order to facilitate binary searching when performing value-to-code look-ups. If, during the encoding of the second column vector, values are encountered for which the dictionary does not already have codes, then a “sort-order-boundary” is established after the last entry in the dictionary, and entries for the newly encountered values are added to the dictionary, after the sort-order-boundary. To facilitate value-to-code look-ups, the new entries are also sorted relative to each other, creating a second “sort order set”. A new version of the dictionary may be created when the number of sort order sets in the first version of the dictionary reaches a configurable threshold.

    ON-DEMAND CACHE MANAGEMENT OF DERIVED CACHE
    16.
    发明申请
    ON-DEMAND CACHE MANAGEMENT OF DERIVED CACHE 审中-公开

    公开(公告)号：US20190095346A1

    公开(公告)日：2019-03-28

    申请号：US16144926

    申请日：2018-09-27

    Applicant: Oracle International Corporation

    Inventor： Hariharan Lakshmanan ,  Dhruvil Shah ,  Prashant Gaharwar ,  Shasank K. Chavan ,  Tirthankar Lahiri ,  Saraswathy Narayan

    IPC: G06F12/126 ,  G06F17/30

    Abstract: Techniques related to automatic cache management are disclosed. In some embodiments, one or more non-transitory storage media store instructions which, when executed by one or more computing devices, cause performance of an automatic cache management method when a determination is made to store a first set of data in a cache. The method involves determining whether an amount of available space in the cache is less than a predetermined threshold. When the amount of available space in the cache is less than the predetermined threshold, a determination is made as to whether a second set of data has a lower ranking than the first set of data by at least a predetermined amount. When the second set of data has a lower ranking than the first set of data by at least the predetermined amount, the second set of data is evicted. Thereafter, the first set of data is cached.

    Efficient data storage and retrieval using a heterogeneous main memory
    17.
    发明授权
    Efficient data storage and retrieval using a heterogeneous main memory 有权

    公开(公告)号：US10133667B2

    公开(公告)日：2018-11-20

    申请号：US15257754

    申请日：2016-09-06

    Applicant: Oracle International Corporation

    Inventor： Niloy Mukherjee ,  Tirthankar Lahiri ,  Juan R. Loaiza ,  Jesse Kamp ,  Prashant Gaharwar ,  Hariharan Lakshmanan ,  Dhruvil Shah

    IPC: G06F12/08 ,  G06F3/06 ,  G06F17/30

    Abstract: Techniques related to efficient data storage and retrieval using a heterogeneous main memory are disclosed. A database includes a set of persistent format (PF) data that is stored on persistent storage in a persistent format. The database is maintained on the persistent storage and is accessible to a database server. The database server converts the set of PF data to sets of mirror format (MF) data and stores the MF data in a hierarchy of random-access memories (RAMs). Each RAM in the hierarchy has an associated latency that is different from a latency associated with any other RAM in the hierarchy. Storing the sets of MF data in the hierarchy of RAMs includes (1) selecting, based on one or more criteria, a respective RAM in the hierarchy to store each set of MF data and (2) storing said each set of MF data in the respective RAM.

    IN-MEMORY COLUMN-LEVEL MULTI-VERSIONED GLOBAL DICTIONARY FOR IN-MEMORY DATABASES
    20.
    发明申请
    IN-MEMORY COLUMN-LEVEL MULTI-VERSIONED GLOBAL DICTIONARY FOR IN-MEMORY DATABASES 审中-公开

    公开(公告)号：US20170109406A1

    公开(公告)日：2017-04-20

    申请号：US15294460

    申请日：2016-10-14

    Applicant: Oracle International Corporation

    Inventor： Shasank K. Chavan ,  Prashant Gaharwar ,  Ajit Mylavarapu ,  Dina Thomas ,  Dennis Lui ,  Sheldon A.K. Lewis ,  Roger D. Macnicol

    IPC: G06F17/30 ,  G06F7/24

    CPC classification number: G06F16/24561 ,  G06F16/221 ,  G06F16/3347

    Abstract: Techniques are described herein for sharing a dictionary across multiple in-memory compression units (IMCUs). After a dictionary is used to encode a first column vector in a first IMCU, the same dictionary is used to encode a second column vector in a second IMCU. The entries in the dictionary are in sort order to facilitate binary searching when performing value-to-code look-ups. If, during the encoding of the second column vector, values are encountered for which the dictionary does not already have codes, then a “sort-order-boundary” is established after the last entry in the dictionary, and entries for the newly encountered values are added to the dictionary, after the sort-order-boundary. To facilitate value-to-code look-ups, the new entries are also sorted relative to each other, creating a second “sort order set”. A new version of the dictionary may be created when the number of sort order sets in the first version of the dictionary reaches a configurable threshold.

Patent Agency Ranking