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:
May. 21, 2019
Filed:
Mar. 15, 2013
Oracle International Corporation, Redwood Shores, CA (US);
Juan Loaiza, Woodwide, CA (US);
Amit Ganesh, San Jose, CA (US);
Roger Macnicol, Hummelstown, PA (US);
Jesse Kamp, Castro Valley, CA (US);
Allison Holloway, San Carlos, CA (US);
Adrian Ng, Mountain View, CA (US);
Vineet Marwah, San Ramon, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
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.