公开(公告)号：WO2014052917A1

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

申请号：PCT/US2013/062451

申请日：2013-09-27

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： MARWAH, Vineet ,  LAKSHMANAN, Hariharan ,  MYLAVARAPU, Ajit ,  GAHARWAR, Prashant ,  GANESH, Amit

IPC: G06F17/30

CPC classification number: G06F17/30221 ,  G06F3/0649 ,  G06F17/30073 ,  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 may optionally invoke user-defined functions, and may be based on access statistics 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: 提供了一种用于数据库管理系统中的策略驱动数据放置和信息生命周期管理的方法，装置和系统。 用户或数据库应用程序可以指定定义存储的数据库对象的移动和转换的声明性策略。 策略与数据库对象相关联，也可以被继承。 在触发归档操作之前，策略为数据库对象定义要执行的归档操作，作用域和条件。 归档操作可能包括压缩，数据移动，表集群和其他操作，以将数据库对象放入适用于数据库对象生命周期阶段的存储层。 条件可以可选地调用用户定义的功能，并且可以基于在行级别指定的访问统计信息，并且可以使用段或块级散热图。 策略评估在后台定期进行，操作会作为任务调度程序的任务进行排队。

公开(公告)号：EP2901323B1

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

申请号：EP13776657.2

申请日：2013-09-27

Applicant: Oracle International Corporation

Inventor： MARWAH, Vineet ,  LAKSHMANAN, Hariharan ,  MYLAVARAPU, Ajit ,  GAHARWAR, Prashant ,  GANESH, Amit

IPC: G06F16/21

公开(公告)号：EP2901323A1

公开(公告)日：2015-08-05

申请号：EP13776657.2

申请日：2013-09-27

Applicant: Oracle International Corporation

Inventor： MARWAH, Vineet ,  LAKSHMANAN, Hariharan ,  MYLAVARAPU, Ajit ,  GAHARWAR, Prashant ,  GANESH, Amit

IPC: G06F17/30

Abstract: Techniques for activity tracking, data classification, and in-database archiving are described. Activity tracking refers to techniques that collect statistics related to user access patterns, such as the frequency or recency with which users access particular database elements. The statistics gathered through activity tracking can be supplied to data classification techniques to automatically classify the database elements or to assist users with manually classifying the database elements. Then, once the database elements have been classified, in-database archiving techniques can be employed to move database elements to different storage tiers based on the classifications. However, although the techniques related to activity tracking, data classification, and in-database archiving may be used together as described above; each technique may also be practiced separately.