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:
Feb. 04, 2014
Filed:
Apr. 28, 2010
Vikram Kapoor, Cupertino, CA (US);
Amit Ganesh, San Jose, CA (US);
Jesse Kamp, San Leandro, CA (US);
Sachin Kulkarni, Foster City, CA (US);
Vineet Marwah, San Ramon, CA (US);
Kam Shergill, Berkshire, GB;
Roger Macnicol, Hummelstown, PA (US);
Manosiz Bhattacharyya, San Jose, CA (US);
Vikram Kapoor, Cupertino, CA (US);
Amit Ganesh, San Jose, CA (US);
Jesse Kamp, San Leandro, CA (US);
Sachin Kulkarni, Foster City, CA (US);
Vineet Marwah, San Ramon, CA (US);
Kam Shergill, Berkshire, GB;
Roger Macnicol, Hummelstown, PA (US);
Manosiz Bhattacharyya, San Jose, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
A database server stores compressed units in data blocks of a database. A table (or data from a plurality of rows thereof) is first compressed into a 'compression unit' using any of a wide variety of compression techniques. The compression unit is then stored in one or more data block rows across one or more data blocks. As a result, a single data block row may comprise compressed data for a plurality of table rows, as encoded within the compression unit. Storage of compression units in data blocks maintains compatibility with existing data block-based databases, thus allowing the use of compression units in preexisting databases without modification to the underlying format of the database. The compression units may, for example, co-exist with uncompressed tables. Various techniques allow a database server to optimize access to data in the compression unit, so that the compression is virtually transparent to the user.