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:
Dec. 01, 2015
Filed:
Jun. 12, 2013
Oracle International Corporation, Redwood Shores, CA (US);
Lawrence J. Ellison, Woodside, CA (US);
Amit Ganesh, San Jose, CA (US);
Vineet Marwah, San Ramon, CA (US);
Jesse Kamp, Castro Valley, CA (US);
Anindya C. Patthak, Fremont, CA (US);
Shasank K. Chavan, Menlo Park, CA (US);
Michael J. Gleeson, Saratoga, CA (US);
Allison L. Holloway, San Carlos, CA (US);
Manosiz Bhattacharyya, San Jose, CA (US);
ORACLE INTERNATIONAL CORPORATION, Redwood Shores, CA (US);
Abstract
Techniques are provided for more efficiently using the bandwidth of the I/O path between a CPU and volatile memory during the performance of database operation. Relational data from a relational table is stored in volatile memory as column vectors, where each column vector contains values for a particular column of the table. A binary-comparable format may be used to represent each value within a column vector, regardless of the data type associated with the column. The column vectors may be compressed and/or encoded while in volatile memory, and decompressed/decoded on-the-fly within the CPU. Alternatively, the CPU may be designed to perform operations directly on the compressed and/or encoded column vector data. In addition, techniques are described that enable the CPU to perform vector processing operations on the column vector values.