The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Jun. 09, 2020
Filed:
Oct. 21, 2016
Oracle International Corporation, Redwood Shores, CA (US);
Roger D. Macnicol, Hummelstown, PA (US);
Viral Shah, Cupertino, CA (US);
Xia Hua, Mountain View, CA (US);
Jesse Kamp, Castro Valley, CA (US);
Shasank K. Chavan, Menlo Park, CA (US);
Maria Colgan, Menlo Park, CA (US);
Tirthankar Lahiri, Palo Alto, CA (US);
Adrian Tsz Him Ng, Redwood City, CA (US);
Krishnan Meiyyappan, Fremont, CA (US);
Amit Ganesh, San Jose, CA (US);
Juan R. Loaiza, Woodside, CA (US);
Kothanda Umamageswaran, Sunnyvale, CA (US);
Yiran Qin, Emeryville, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
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.