Columnar caching in tiered storage

US10678788B2 · kind B2 · utility

Assignee

• Oracle International Corporation · US

Inventors

• Roger MacNicol · Hummelstown, US
• Viral Shah · Cupertino, US
• Xia Hua · Mountain View, US
• Jesse Kamp · Castro Valley, US
• Shasank K. Chavan · Menlo Park, US
• Maria Colgan · Menlo Park, US
• Tirthankar Lahiri · Palo Alto, US
• Adrian Tsz Him Ng · Redwood City, US
• Krishnan Meiyyappan · Fremont, US
• Amit Ganesh · San Jose, US
• Juan R. Loaiza · Woodside, US
• Kothanda Umamageswaran · Mountain View, US
• Yiran Qin · Beijing, CN

Key dates

• Filing date: Oct 21, 2016
• Grant date: Jun 9, 2020
• Expiry date: Jun 30, 2038

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F2212/225
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

Techniques are provided for storing in in-memory unit (IMU) in a lower-storage tier and copying the IMU to DRAM when needed for query processing. Techniques are also provided for copying IMUs to lower tiers of storage when evicted from the cache of higher tiers of storage. Techniques are provided for implementing functionality of IMUs within a storage system, to enable database servers to push tasks, such as filtering, to the storage system where the storage system may access IMUs within its own memory to perform the tasks. Metadata associated with a set of data may be used to indicate whether an IMU for the data should be created by the database server machine or within the storage system.