Archival of objects and dynamic search

摘要

In one embodiment, a method determines data stored in a plurality of tables in a first database for archiving. The data is combined from the plurality of tables into a set of objects in a readable format where an object in the set of objects includes terms from the plurality of tables associated with the object. The method then stores the set of objects in the text format in a second database where a search query processor is able to search terms in the set of objects in the readable format. Then, the data stored in the plurality of tables in the first database is deleted in response to the archiving.

主权项

1. A method comprising:
determining, by a computer system, data stored in a plurality of tables in a first database formatted in a relational data model for archiving, the data including a plurality of terms that are stored as values in separate columns in the plurality of tables; performing, by the computer system, a database query to extract terms in the plurality of terms from the separate columns in the plurality of tables in the first database and combining the terms into a set of objects in a text format, wherein an object in the set of objects includes a set of terms from a set of values in separate columns in the plurality of tables that are associated with the object; storing, by the computer system, the set of objects in the text format in a second database formatted in an object model, wherein a search query processor is able to search terms in the set of objects in the text format; and deleting, by the computer system, the data stored in the plurality of tables in the first database in response to the archiving.