Patent ID: 7330859

Claim:
In a database including primary and secondary servers and a data replicator that copies database log entries from the primary server to the secondary server and updates the secondary server using the copied database log entries, an indexing method including: creating on the primary server a user-defined index of contents of the database, the user-defined index including at least user-defined routines and the creating including at least some operations that do not produce database log entries; obtaining on the primary server a lock on the user-defined index; constructing on the primary server a definitional data set containing information on the user-defined routines; transferring the definitional data set from the primary server to the secondary server; constructing on the secondary server secondary user-defined routines based on the definitional data set; transferring contents of the user-defined index from the primary server to the secondary server as transferred contents, the transferred contents in combination with the secondary user-defined routines defining a secondary user-defined index corresponding to the user-defined index created on the primary server; and removing the lock on the user-defined index.