×

Refreshing a full-text search index in a partitioned database

  • US 8,620,924 B2
  • Filed: 03/06/2012
  • Issued: 12/31/2013
  • Est. Priority Date: 03/06/2012
  • Status: Expired due to Fees
First Claim
Patent Images

1. A method for refreshing a full-text search index for a table stored in a set of partitions of a database, wherein a portion of the table is stored in each of the partitions, comprising:

  • at a first point in time, with a processor of a computer, capturing table row distribution information and a table partitioning list identifying the set of partitions, wherein the table row distribution information has a slot for each table row and indicates a partition in which the table row is stored; and

    at a second point in time,in response to at least one of a partition being added and a partition being dropped from the set of partitions,moving table rows among the set of partitions to change table data row distribution; and

    updating the table row distribution information by updating the slot for each table row to indicate the partition in which the table row is stored;

    determining that an index refresh operation is to be performed due to the change in the table data row distribution;

    comparing the captured table row distribution information with current table row distribution information to determine whether there is at least one difference; and

    in response to the determining that there is at least one difference, re-aligning a text index distribution for any table rows that are affected by the change in the table data row distribution by;

    generating a new table partitioning list that the full-text search index is to be distributed over; and

    indexing documents associated with the table rows that moved from one partition in the captured table partitioning list to another partition in the new table partitioning list, wherein the documents associated with the table rows that did not move from one partition in the captured table partitioning list to another partition in the new table partitioning list are not re-indexed.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×