Patent ID: 7516115

Claim:
A method for optimizing performance of a database, the method comprising: sorting and categorizing a first set of columns within a view of the 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; and 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, wherein the database is a non-relational database, the sorting and categorizing a first set of columns step includes assigning the first set of columns to a portion of a cache, the sorting and categorizing at least one column of the second set step includes sorting and categorizing the at least one column of the second set of columns in another portion of the cache, and the second set of columns is visible as collapsed data.