Invention Grant
- Patent Title: Techniques for automatic data placement with compression and columnar storage
-
Application No.: US14570199Application Date: 2014-12-15
-
Publication No.: US09165016B2Publication Date: 2015-10-20
- Inventor: Amit Ganesh , Vineet Marwah , Vikram Kapoor
- 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
- Agent Marcel K. Bingham
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F3/06

Abstract:
For automatic data placement of database data, a plurality of access-tracking data is maintained. The plurality of access-tracking data respectively corresponds to a plurality of data rows that are managed by a database server. While the database server is executing normally, it is automatically determined whether a data row, which is stored in first one or more data blocks, has been recently accessed based on the access-tracking data that corresponds to that data row. After determining that the data row has been recently accessed, the data row is automatically moved from the first one or more data blocks to one or more hot data blocks that are designated for storing those data rows, from the plurality of data rows, that have been recently accessed.
Public/Granted literature
- US20150149419A1 Techniques for Automatic Data Placement with Compression and Columnar Storage Public/Granted day:2015-05-28
Information query