System and method to perform data indexing in a transaction processing environment
View Patent ↗A system and method to perform data indexing in a transaction processing environment are described. Data is periodically extracted from one or more database servers storing the data. A database stored in a storage device is then updated with the extracted data to obtain an updated database. Finally, the updated database is transmitted to one or more search servers.
1. A method for indexing data in a computer system that includes at least one processing device and storage, the method including:
extracting, by the computer system, data from at least one database server;
duplicating a source database to obtain a duplicated database;
storing the duplicated database in storage;
after storing the duplicated database in the storage, updating the source database with the extracted data to obtain an updated database;
re-indexing the updated database with the extracted data to obtain a re-indexed, updated database;
re-optimizing the re-indexed, updated database for searching; and
transmitting the re-indexed and re-optimized, updated database, by the computer system, to fewer than all of a plurality of search servers.
2. The method according to claim 1 , wherein the fewer than all of the search servers is configured to distribute the transmitted data to other search servers on a periodic or regular schedule.
3. The method according to claim 2 wherein at least one of the other search servers takes itself out of service in order to receive the updated data.
4. The method according to claim 1 , further including:
providing a pointer to the fewer than all of the search servers, the pointer referencing the updated database for the fewer than all of the search servers.
5. The method according to claim 1 , wherein the extracting further comprises: performing a plurality of database queries on the at least one database server.
6. The method according to claim 5 , wherein each database query of the plurality of database queries is performed using a predetermined database querying language.
7. The method according to claim 6 , wherein the predetermined database querying language is a structured query language (SQL).
8. A non-transitory computer-readable storage medium having embedded therein a set of instructions which, when executed by one or more processors of a computer causes the computer to execute the following operations:
extracting data from at least one database server;
duplicating a source database to obtain a duplicated database;
storing the duplicated database in storage;
after storing the duplicated database in the storage, updating the source database with the extracted data to obtain an updated database;
re-indexing the updated database with the extracted data to obtain a re-indexed, updated database;
re-optimizing the re-indexed, updated database for searching; and
transmitting the re-indexed and re-optimized, updated database to fewer than all of a plurality of search servers.
9. The storage medium of claim 8 wherein the fewer than all of the search servers is configured to distribute the transmitted data to other search servers on a periodic or regular schedule.