公开(公告)号：US11556505B2

公开(公告)日：2023-01-17

申请号：US17159070

申请日：2021-01-26

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.

公开(公告)号：US11520743B2

公开(公告)日：2022-12-06

申请号：US14079507

申请日：2013-11-13

Applicant: Oracle International Corporation

Inventor： Vikram Kapoor ,  Amit Ganesh ,  Jesse Kamp ,  Sachin Kulkarni ,  Vineet Marwah ,  Kam Shergill ,  Roger Macnicol ,  Manosiz Bhattacharyya

IPC: G06F16/174 ,  G06F16/2455 ,  G06F16/901

Abstract: A database server stores compressed units in data blocks of a database. A table (or data from a plurality of rows thereof) is first compressed into a “compression unit” using any of a wide variety of compression techniques. The compression unit is then stored in one or more data block rows across one or more data blocks. As a result, a single data block row may comprise compressed data for a plurality of table rows, as encoded within the compression unit. Storage of compression units in data blocks maintains compatibility with existing data block-based databases, thus allowing the use of compression units in preexisting databases without modification to the underlying format of the database. The compression units may, for example, co-exist with uncompressed tables. Various techniques allow a database server to optimize access to data in the compression unit, so that the compression is virtually transparent to the user.

公开(公告)号：US20200257663A1

公开(公告)日：2020-08-13

申请号：US16861180

申请日：2020-04-28

Applicant: Oracle International Corporation

Inventor： Vineet Marwah ,  Sujatha Muthulingam ,  Amit Ganesh

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

Abstract: A method, apparatus, and system for tracking row and object database activity into block level heatmaps is provided. Database activity including reads, writes, and creates can be tracked by a database management system at the finest possible level of granularity, or the row and object level. To efficiently record the tracked database activity, a two-part structure is described for writing the activity into heatmaps. A hierarchical in-memory component may use a dynamically allocated sparse pool of bitmap blocks. Periodically, the in-memory component is persisted to a stored representation component, sharable with multiple database instances, which may include consolidated last access times and/or a history of heatmap snapshots to reflect access over time. The heatmaps may then be externalized to database users and applications to provide and support a variety of features.

公开(公告)号：US20190361693A1

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

申请号：US16534896

申请日：2019-08-07

Applicant: Oracle International Corporation

Inventor： Dustin Garvey ,  Timothy Mark Frazier ,  Shriram Krishnan ,  Uri Shaft ,  Amit Ganesh ,  Prasad Ravuri ,  Sampanna Shahaji Salunke ,  Sumathi Gopalakrishnan

IPC: G06F8/65 ,  G06F8/60 ,  G06N20/00 ,  G06F16/906 ,  G06F8/61 ,  G06F9/50

Abstract: Techniques are described herein for scalable clustering of target resources by parameter set. In some embodiments, a plurality of parameter sets of varying length are received, where a parameter set identifies attributes of a target resource. A plurality of signature vectors are generated based on the plurality of parameter sets such that the signature vectors have equal lengths. A signature vector may map to one or more parameter sets of the plurality of parameter sets. A plurality of clusters are generated based on the similarity between signature vectors. Operations may be performed on a target resource based on one or more nodes in the plurality of clusters.

公开(公告)号：US10331802B2

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

申请号：US15057065

申请日：2016-02-29

Applicant: Oracle International Corporation

Inventor： Dustin Garvey ,  Uri Shaft ,  Lik Wong ,  Amit Ganesh

IPC: G06F17/30 ,  G06F17/18 ,  G06F21/55 ,  G06Q10/04 ,  G06N99/00 ,  G06Q10/06

Abstract: Techniques are described for characterizing and summarizing seasonal patterns detected within a time series. A set of time series data is analyzed to identify a plurality of instances of a season, where each instance corresponds to a respective sub-period within the season. A first set of instances from the plurality of instances are associated with a particular class of seasonal pattern. After classifying the first set of instances, a second set of instances may remain unclassified or otherwise may not be associated with the particular class of seasonal pattern. Based on the first and second set of instances, a summary may be generated that identifies one or more stretches of time that are associated with the particular class of seasonal pattern. The one or more stretches of time may span at least one sub-period corresponding to at least one instance in the second set of instances.

公开(公告)号：US10296462B2

公开(公告)日：2019-05-21

申请号：US13840811

申请日：2013-03-15

Applicant: Oracle International Corporation

Inventor： Juan Loaiza ,  Amit Ganesh ,  Roger Macnicol ,  Jesse Kamp ,  Allison Holloway ,  Adrian Ng ,  Vineet Marwah

IPC: G06F12/08 ,  G06F12/0875 ,  G06F16/22 ,  G06F16/2455

Abstract: A method for accelerating queries using dynamically generated columnar data in a flash cache is provided. In an embodiment, a method comprises a storage device receiving a first request for data that is stored in the storage device in a base major format in one or more primary storage devices. The storage device comprises a cache. The base major format is any one of: a row-major format, a column-major format and a hybrid-columnar format. Based on first one or more criteria, it is determined whether to rewrite the data into rewritten data in a rewritten major format. In response to determining to rewrite the data into rewritten data in a rewritten major format, the storage device rewrites at least a portion of the data into particular rewritten data in the rewritten major format. The rewritten data is stored in the cache.

公开(公告)号：US10204135B2

公开(公告)日：2019-02-12

申请号：US15146799

申请日：2016-05-04

Applicant: Oracle International Corporation

Inventor： Aurosish Mishra ,  Shasank K. Chavan ,  Allison L. Holloway ,  Jesse Kamp ,  Ramesh Kumar ,  Zhen Hua Liu ,  Niloy Mukherjee ,  Amit Ganesh ,  Tirthankar Lahiri ,  Vineet Marwah

IPC: G06F17/30

Abstract: Techniques are described for materializing pre-computed results of expressions. In an embodiment, a set of one or more column units are stored in volatile or non-volatile memory. Each column unit corresponds to a column that belongs to an on-disk table within a database managed by a database server instance and includes data items from the corresponding column. A set of one or more virtual column units, and data that associates the set of one or more column units with the set of one or more virtual column units, are also stored in memory. The set of one or more virtual column units includes a particular virtual column unit storing results that are derived by evaluating an expression on at least one column of the on-disk table.

公开(公告)号：US09910861B2

公开(公告)日：2018-03-06

申请号：US13826075

申请日：2013-03-14

Applicant: Oracle International Corporation

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

IPC: G06F17/30 ,  G06F3/06

CPC classification number: G06F17/30221 ,  G06F3/0649 ,  G06F17/30073 ,  G06F17/30289 ,  G06F17/30306 ,  G06F17/30312 ,  G06F17/30575

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

公开(公告)号：US09684682B2

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

申请号：US14922077

申请日：2015-10-23

Applicant: Oracle International Corporation

Inventor： Niloy Mukherjee ,  Amit Ganesh ,  Vineet Marwah

IPC: G06F17/30 ,  G06F3/06

CPC classification number: G06F17/30315 ,  G06F3/0604 ,  G06F3/064 ,  G06F3/065 ,  G06F3/0689 ,  G06F11/00 ,  G06F17/30312 ,  G06F17/30377 ,  G06F17/30595 ,  G06F2003/0697 ,  G06F2212/1021 ,  G06F2212/2542 ,  G06F2212/271 ,  G06F2212/283 ,  G06F2212/608

Abstract: Techniques are provided for sharding objects across different compute nodes. In one embodiment, a database server instance generates, for an object, a plurality of in-memory chunks including a first in-memory chunk and a second in-memory chunk, where each in-memory chunk includes a different portion of the object. The database server instance assigns each in-memory chunk to one of a plurality of computer nodes including the first in-memory chunk to a first compute node and a second in-memory chunk to a second local memory of a second compute node. The database server instance stores an in-memory map that indicates a memory location for each in-memory chunk. The in-memory map indicates that the first in-memory chunk is located in the first local memory of the first compute node and that the second in-memory chunk is located in the second local memory of the second compute node.

公开(公告)号：US20170031976A1

公开(公告)日：2017-02-02

申请号：US15146801

申请日：2016-05-04

Applicant: Oracle International Corporation

Inventor： Shasank K. Chavan ,  Aurosish Mishra ,  Amit Ganesh

IPC: G06F17/30 ,  G06F12/08

CPC classification number: G06F16/2454 ,  G06F12/0802 ,  G06F16/2255 ,  G06F16/2282 ,  G06F16/23 ,  G06F16/2393 ,  G06F16/2453 ,  G06F16/2455 ,  G06F2212/60

Abstract: Techniques are described for materializing computations in memory. In an embodiment, responsive to a database server instance receiving a query, the database server instance identifies a set of computations for evaluation during execution of the query. Responsive to identifying the set of computations, the database server instance evaluates at least one computation in the set of computations to obtain a first set of computation results for a first computation in the set of computations. After evaluating the at least one computation, the database server instance stores, within an in-memory unit, the first set of computation results. The database server also stores mapping data that maps a set of metadata values associated with the first computation to the first set of computation results.

Abstract translation: 描述了在存储器中实现计算的技术。 在一个实施例中，响应于接收到查询的数据库服务器实例，数据库服务器实例标识用于在执行查询期间进行评估的一组计算。 响应于识别该组计算，数据库服务器实例评估该组计算中的至少一个计算，以获得该组计算中的第一次计算的第一组计算结果。 在评估至少一个计算之后，数据库服务器实例在内存单元内存储第一组计算结果。 数据库服务器还存储将与第一计算相关联的一组元数据值映射到第一组计算结果的映射数据。