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:
Apr. 07, 2009
Filed:
Aug. 20, 2003
Sanjay Gupta, Poughkeepsie, NY (US);
Sanjay Gupta, Poughkeepsie, NY (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A method and system is provided that optimizes performance in non-relational databases. A method includes: sorting and categorizing a first set of columns within a view of the non-relational database; marking a second set of columns within the view as if the second set of columns were already sorted and categorized prior to actual sorting and categorizing of the second set of columns, the second set of columns including all columns exclusive of the first set of columns; sorting and categorizing at least one column of the second set of columns in response to performing a query on the at least one column; maintaining the first set of columns in a portion of cache; and maintaining the at least one column of the second set of columns in another portion of cache. In the method, the second set of columns is visible as collapsed data.