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:
Jul. 17, 2018
Filed:
Sep. 08, 2014
Oracle International Corporation, Redwood Shores, CA (US);
Vineet Marwah, San Ramon, CA (US);
Vikram Kapoor, Cupertino, CA (US);
Jesse Kamp, Castro Valley, CA (US);
Kam Shergill, Maidenhead, GB;
Roger MacNicol, Hummelstown, PA (US);
Sachin Kulkarni, Sunnyvale, CA (US);
Amit Ganesh, San Jose, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
A method and apparatus is provided for optimizing queries received by a database system that relies on an intelligent data storage server to manage storage for the database system. Storing compression units in hybrid columnar format, the storage manager evaluates simple predicates and only returns data blocks containing rows that satisfy those predicates. The returned data blocks are not necessarily stored persistently on disk. That is, the storage manager is not limited to returning disc block images. The hybrid columnar format enables optimizations that provide better performance when processing typical database workloads including both fetching rows by identifier and performing table scans.