System and method to perform data indexing in a transaction processing environment
First Claim
Patent Images
1. A method for indexing data in a transaction processing environment, the method including:
- periodically extracting data, by a computer system, from at least one database server;
duplicating, by said computer system, a source database to obtain a duplicated database;
storing said duplicated database in a storage device, wherein said storage device is associated with an index server;
after storing said duplicated database in said storage device, updating said source database stored in said storage device with said extracted data to obtain an updated database;
re-indexing said updated database with said extracted data;
re-optimizing said updated database for searching; and
transmitting, by said computer system, said updated database after re-indexing and re-optimizing to at least one search server, wherein said at least one search server is different from said index server.
2 Assignments
0 Petitions
Accused Products
Abstract
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.
22 Citations
14 Claims
-
1. A method for indexing data in a transaction processing environment, the method including:
-
periodically extracting data, by a computer system, from at least one database server; duplicating, by said computer system, a source database to obtain a duplicated database; storing said duplicated database in a storage device, wherein said storage device is associated with an index server; after storing said duplicated database in said storage device, updating said source database stored in said storage device with said extracted data to obtain an updated database; re-indexing said updated database with said extracted data; re-optimizing said updated database for searching; and transmitting, by said computer system, said updated database after re-indexing and re-optimizing to at least one search server, wherein said at least one search server is different from said index server. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. An apparatus for indexing data in a transaction processing environment, the apparatus including:
-
a storage device to store a source database containing data related to a transaction processing application; and a processing device coupled to said storage device to duplicate said source database to obtain a duplicated database and store said duplicated database in said storage device, to periodically extract current data from at least one database server coupled to said processing device, to update said source database, after storing said duplicated database in said storage device, with said extracted current data to obtain an updated database, to re-index said updated database with said extracted current data, to re-optimize said updated database for searching, and to transmit said updated database after re-indexing and re-optimizing to at least one search server coupled to said processing device, wherein said at least one search server is different from said processing device. - View Dependent Claims (9, 10, 11, 12)
-
-
13. A tangible computer readable medium containing executable instructions, which, when executed in a processing system, cause said processing system to:
-
periodically extract data from at least one database server; duplicate a source database to obtain a duplicated database; store said duplicated database in said storage device, wherein said storage device is associated with an index server; after storing said duplicated database in said storage device, update said source database stored in said storage device with said extracted data to obtain an updated database; re-index said updated database with said extracted data; re-optimize said updated database for searching; and transmit said updated database after re-indexing and re-optimizing to at least one search server, wherein said at least one search server is different from said index server.
-
-
14. A system for indexing data in a transaction processing environment, said system including:
-
at least one database server to store data related to a transaction processing application; at least one index server coupled to said at least one database server, each of said at least one index server associated with a storage device to store a first database containing a version of said data; a designated search server coupled to said at least one index server to receive an updated database from said at least one index server; and at least one search server coupled to said designated search server to receive said updated database; wherein said at least one index server is configured to; extract said data periodically from said at least one database server; duplicate said first database to obtain a duplicated database; store said duplicated database in said storage device; after storing said duplicated database in said storage device, update said first database with said extracted data to obtain said updated first database; re-index said updated first database with said extracted data; re-optimize said updated first database for searching; and transmit said updated first database after re-indexing and re-optimizing to said designated search server; and wherein said designated search server is configured to distribute said updated first database to said at least one search server on a periodic or regular schedule.
-
Specification