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. 31, 2013
Filed:
Dec. 06, 2007
Subhransu Basu, Fremont, CA (US);
Harmeek Singh Bedi, Redwood Shores, CA (US);
Ananth Raghavan, San Francisco, CA (US);
Subhransu Basu, Fremont, CA (US);
Harmeek Singh Bedi, Redwood Shores, CA (US);
Ananth Raghavan, San Francisco, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
Techniques are described herein for partitioning a database table using a virtual column as the partitioning key. A virtual column is defined by the database to contain results of a defining expression. Partitioning can be performed using a variety of partitioning schemes, such as range partitioning and hash partitioning. The partitions are automatically updated to reflect changes to the values in the base columns upon which the virtual column depends. Partition pruning and parallel-wise partition joins can be performed on database tables which have been partitioned on virtual columns.