- Patent Title: Tracking row and object database activity into block level heatmaps
-
Application No.: US13804884Application Date: 2013-03-14
-
Publication No.: US10678760B2Publication Date: 2020-06-09
- Inventor: Vineet Marwah , Sujatha Muthulingam , Amit Ganesh
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Becker Bingham LLP
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/185 ; G06F3/06 ; G06F16/21 ; G06F16/22 ; G06F16/27 ; G06F16/11

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.
Public/Granted literature
- US20140095438A1 TRACKING ROW AND OBJECT DATABASE ACTIVITY INTO BLOCK LEVEL HEATMAPS Public/Granted day:2014-04-03
Information query