Archival of objects and dynamic search
View Patent ↗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.
2. The method of claim 1 , wherein the set of values from the plurality of tables are extracted from the database to be combined into the object.
3. The method of claim 1 , wherein combining the terms comprises converting the terms in the relational model to the set of objects in the object model.
4. The method of claim 1 , further comprising compressing, by the computer system, the set of objects in the text format after storing in the second database.
5. The method of claim 1 , further comprising generating, by the computer system, a search index of the set of objects based on terms in the set of objects, wherein the text search of the set of objects uses the search index to search for terms in the set of objects.
6. The method of claim 5 , wherein generating, by the computer system, the search index comprises indexing each term in the set of objects.
7. The method of claim 1 , further comprising:
receiving, by the computer system, a query including a search term;
searching, by the computer system, for the search term in the set of objects stored in the second database; and
returning, by the computer system, any objects in the set of objects stored in the second database that include the search term.
8. The method of claim 7 , wherein any objects returned include all terms in the objects.
9. The method of claim 1 , wherein each object in the set of objects is stored in an entry in a table in the second database.
10. The method of claim 1 , wherein each object in the set of objects is stored as a string in the second database.
11. The method of claim 1 , wherein the readable format is a format that can be parsed by the search query processor.
12. A non-transitory computer-readable storage medium containing instructions, that when executed, control a computer system to be configured for:
determining 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 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 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 the data stored in the plurality of tables in the first database in response to the archiving.
13. The non-transitory computer-readable storage medium of claim 12 , wherein combining the terms comprises converting the terms in the relational model to the set of objects in the object model.
14. The non-transitory computer-readable storage medium of claim 12 , further configured for compressing the set of objects in the text format after storing in the second database.
15. The non-transitory computer-readable storage medium of claim 12 , further configured for generating a search index of the set of objects based on terms in the set of objects, wherein the text search of the set of objects uses the search index to search for terms in the set of objects.
16. The non-transitory computer-readable storage medium of claim 12 , further configured for:
receiving a query including a search term;
searching for the search term in the set of objects stored in the second database; and
returning any objects in the set of objects stored in the second database that include the search term.
17. The non-transitory computer-readable storage medium of claim 16 , wherein any objects returned include all terms in the objects.
18. The non-transitory computer-readable storage medium of claim 12 , wherein each object in the set of objects is stored as a string in the second database.
19. The non-transitory computer-readable storage medium of claim 12 , wherein the readable format is a format that can be parsed by the search query processor.
20. An apparatus comprising:
one or more computer processors; and
a non-transitory computer-readable storage medium comprising instructions, that when executed, control the one or more computer processors to be configured for:
determining 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 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 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 the data stored in the plurality of tables in the first database in response to the archiving.