CONTENT SEARCH FOR VERSIONED DATABASE DATA
Embodiments disclosed herein provide systems, methods, and computer readable media for searching content in versioned database data. In a particular embodiment, a method provides obtaining a first data version of database data and indexing the first data version to create a first index. The first index includes a time indicator corresponding to creation of the first data version. The method further provides incorporating the first index into a searchable index of one or more additional data versions. The searchable index includes one or more time indicators that each correspond to a respective one of the one or more additional data versions. Additionally, the method provides receiving a search query including at least one of an event, time, and/or time range parameter and returning information from the searchable index that satisfies the time parameter.
1 . A method of searching versioned database data, the method comprising:
obtaining a first data version of database data;
indexing the first data version to create a first index, wherein the first index includes a time indicator corresponding to creation of the first data version; and
incorporating the first index into a searchable index of one or more additional data versions, wherein the searchable index includes one or more time indicators that each correspond to a respective one of the one or more additional data versions.
2 . The method of claim 1 , further comprising:
receiving a search query including at least one of an event, time, and/or time range parameter; and
returning information from the searchable index that satisfies the query.
3 . The method of claim 1 , wherein indexing the first data version comprises:
indexing data items of the first data version that satisfy a quorum requirement across nodes of a database from which the database data is obtained.
4 . The method of claim 1 , wherein indexing the first data version comprises:
converting data of the first data version to first user searchable information; and
indexing the first user searchable information.
5 . The method of claim 4 , wherein the first user searchable information comprises information in a data field of each data item in the first data version.
6 . The method of claim 4 , wherein the user searchable information is associated with the time indicator.
7 . The method of claim 1 , further comprising:
deleting portions of the searchable index that correspond to data versions older than a threshold age.
8 . The method of claim 7 , further comprising:
deleting the data versions older than the threshold age.
9 . The method of claim 1 , further comprising:
storing the first data version to a version storage volume.
10 . The method of claim 1 , wherein the first data version includes data items from at least two different types of NoSQL databases.
11 . A system for searching versioned database data, the system comprising:
one or more computer readable storage media;
a processing system operatively coupled with the one or more computer readable storage media; and
program instructions stored on the one or more computer readable storage media that, when read and executed by the processing system, direct the processing system to:
obtain a first data version of database data;
index the first data version to create a first index, wherein the first index includes a time indicator corresponding to creation of the first data version; and
incorporate the first index into a searchable index of one or more additional data versions, wherein the searchable index includes one or more time indicators that each correspond to a respective one of the one or more additional data versions.
12 . The system of claim 11 , wherein the program instructions further direct the processing system to:
receive a search query including at least one of an event, time, and/or time range parameter; and
return information from the searchable index that satisfies the query.
13 . The system of claim 11 , wherein to index the first data version, the program instructions direct the processing system to at least:
index data items of the first data version that satisfy a quorum requirement across nodes of a database from which the database data is obtained.
14 . The system of claim 11 , wherein to index the first data version, the program instructions direct the processing system to at least:
convert data of the first data version to first user searchable information; and
index the first user searchable information.
15 . The system of claim 14 , wherein the first user searchable information comprises information in a data field of each data item in the first data version.
16 . The system of claim 14 , wherein the user searchable information is associated with the time indicator.
17 . The system of claim 11 , wherein the program instructions further direct the processing system to:
delete portions of the searchable index that correspond to data versions older than a threshold age.
18 . The system of claim 17 , wherein the program instructions further direct the processing system to:
delete the data versions older than the threshold age.
19 . The system of claim 11 , wherein the program instructions further direct the processing system to:
store the first data version to a version storage volume.
20 . The system of claim 11 , wherein the first data version includes data items from at least two different types of NoSQL databases.