Patent ID: 7526510

Claim:
A method for executing a search query, the method comprising: storing a plurality of current data entries in a current database by using a personnel directory application through a first database interface, wherein a current data entry of the plurality of current data entries is one of a new entry, a replacement data entry and a data deletion; storing a plurality of outdated data entries in a historical database by using the personnel directory application through a second database interface, wherein the current database and historical database are separate portions of a single database and the current database and historical database contain data entries that are mutually exclusive; determining an organizational position of a departing member from an existing data entry, locating a second existing data entry with the organizational position, and making the second existing data entry as the replacement data entry; determining a type of the current data entry, if the current data entry is one of the new entry and the replacement data entry then establishing logical associations between the current data entries in the current database and the outdated data entries in the historical database by using a rules engine, the rules engine further comprising a set of logic rules; automatically determine the replacement data entry according the logic rules if the current data entry is the data deletion then prompting for the replacement data entry via a graphical user interface and automatically assigning the replacement data entry from the plurality of outdated data entries to the current data entry; and in the graphical user interface, accepting the search query for a desired outdated data entry, in response to the search query, the graphical user interface presents the desired outdated data entry from the historical database and any associated current data entry from the current database.