Patent ID: 8140517
Filing Date: 2012-03-20
Classification: G06F

Abstract:
1. A computer-implemented method of processing a database query in a database management system including at least one processor, the method comprising, in response to receiving a database query including a sort of textual information: determining with the at least one processor whether a shared weight index accessed by the database management system and associated with a column of a database table referenced by the database query can be utilized to optimize the database query, including determining whether the column includes at least one changed weight value and determining whether the database query references at least one changed weight value in the column; generating a sort sequence data structure associated with the shared weight index, wherein the shared weight index includes a plurality of entries, and wherein the sort sequence data structure includes a value correlation for each entry of the shared weight index; and utilizing the shared weight index to optimize the database query in response to determining that the shared weight index can be utilized to optimize the database query.