Methods and systems for data management and analysis
Provided are methods comprising receiving a query for information from a database, determining particular data element types and data element values that are the subject of the query, instantiating a query data structure containing the data element types and the data element values that are the subject of the query, identifying records within the database that contain one or more data element types and/or data element values that are included in the query data structure, and instantiating a results data structure comprising information relating to the identified records.
1. A method comprising:
generating, by a computing device, a final data structure based on a plurality of initial data structures, wherein the plurality of initial data structures are associated with a first query and comprise unique data element values associated with corresponding unique data element types stored in a plurality of database records, and wherein the final data structure is based on a non-redundant selection of one or more of the plurality of database records;
determining, based on a first search term and a second search term of the first query, a first data element type and a second data element type of the unique data element types, wherein the first search term is associated with a first unique data element value corresponding to the first data element type, and wherein the second search term is associated with a second unique data element value corresponding to the second data element type;
generating, based on the final data structure, a query data structure comprising: a first digit representing the first unique data element value, and a second digit representing the second unique data element value;
determining, based on the query data structure, a subset of the plurality of database records; and
storing, in a results data structure, information associated with the subset of the plurality of database records, wherein the results data structure facilitates query processing based on the information associated with the subset of the plurality of database records.
2. The method of claim 1 , further comprising generating, based on the first query, the plurality of initial data structures, wherein the first query comprises the first search term and the second search term.
3. The method of claim 1 , wherein the information associated with the subset of the plurality of database records comprises one or more of: the unique data element values or the unique data element types.
4. The method of claim 1 , wherein the first search term and the second search term are associated with the first query.
5. The method of claim 1 , wherein the information associated with the subset of the plurality of database records comprises one or more results of one or more functions associated with processing the first query.
6. The method of claim 1 , wherein the query data structure or the results data structure comprises a unique identifier associated with one or more of: the first query or the information associated with the subset of the plurality of database records.
7. The method of claim 6 , wherein one or more of:
the unique identifier is associated with the non-redundant selection; or
the unique identifier facilitates, when processing at least one second query, reuse of one or more of: the final data structure, the query data structure, or the information associated with the subset of the plurality of database records.
8. An apparatus comprising:
one or more processors, and
memory storing processor-executable instructions that, when executed by the one or more processors, cause the apparatus to:
generate, a final data structure based on a plurality of initial data structures, wherein the plurality of initial data structures are associated with a first query and comprise unique data element values associated with corresponding unique data element types stored in a plurality of database records, and wherein the final data structure is based on a non-redundant selection of one or more of the plurality of database records;
determine, based on a first search term and a second search term of the first query, a first data element type and a second data element type of the unique data element types, wherein the first search term is associated with a first unique data element value corresponding to the first data element type, and wherein the second search term is associated with a second unique data element value corresponding to the second data element type;
generate, based on the final data structure, a query data structure comprising: a first digit representing the first unique data element value, and a second digit representing the second unique data element value;
determine, based on the query data structure, a subset of the plurality of database records; and
store, in a results data structure, information associated with the subset of the plurality of database records, wherein the results data structure facilitates query processing based on the information associated with the subset of the plurality of database records.
9. The apparatus of claim 8 , wherein the processor-executable instructions further cause the apparatus to generate, based on the first query, the plurality of initial data structures, wherein the first query comprises the first search term and the second search term.
10. The apparatus of claim 8 , wherein the information associated with the subset of the plurality of database records comprises one or more of: the unique data element values or the unique data element types.
11. The apparatus of claim 8 , wherein the first search term and the second search term are associated with the first query.
12. The apparatus of claim 8 , wherein the information associated with the subset of the plurality of database records comprises one or more results of one or more functions associated with processing the first query.
13. The apparatus of claim 8 , wherein the query data structure or the results data structure comprises a unique identifier associated with one or more of: the first query or the information associated with the subset of the plurality of database records.
14. The apparatus of claim 13 , wherein one or more of:
the unique identifier is associated with the non-redundant selection; or
the unique identifier facilitates, when processing at least one second query, reuse of one or more of: the final data structure, the query data structure, or the information associated with the subset of the plurality of database records.
15. A non-transitory computer-readable medium storing processor-executable instructions that, when executed by one or more processors of a computing device, cause the computing device to:
generate, a final data structure based on a plurality of initial data structures, wherein the plurality of initial data structures are associated with a first query and comprise unique data element values associated with corresponding unique data element types stored in a plurality of database records, and wherein the final data structure is based on a non-redundant selection of one or more of the plurality of database records;
determine, based on a first search term and a second search term of the first query, a first data element type and a second data element type of the unique data element types, wherein the first search term is associated with a first unique data element value corresponding to the first data element type, and wherein the second search term is associated with a second unique data element value corresponding to the second data element type;
generate, based on the final data structure, a query data structure comprising: a first digit representing the first unique data element value, and a second digit representing the second unique data element value;
determine, based on the query data structure, a subset of the plurality of database records; and
store, in a results data structure, information associated with the subset of the plurality of database records, wherein the results data structure facilitates query processing based on the information associated with the subset of the plurality of database records.
16. The non-transitory computer-readable medium of claim 15 , wherein the processor-executable instructions further cause the computing device to generate, based on the first query, the plurality of initial data structures, wherein the first query comprises the first search term and the second search term.
17. The non-transitory computer-readable medium of claim 15 , wherein the information associated with the subset of the plurality of database records comprises one or more of: the unique data element values or the unique data element types.
18. The non-transitory computer-readable medium of claim 15 , wherein the first search term and the second search term are associated with the first query.
19. The non-transitory computer-readable medium of claim 15 , wherein the information associated with the subset of the plurality of database records comprises one or more results of one or more functions associated with processing the first query.
20. The non-transitory computer-readable medium of claim 15 , wherein the query data structure or the results data structure comprises a unique identifier associated with one or more of: the first query or the information associated with the subset of the plurality of database record, and wherein one or more of:
the unique identifier is associated with the non-redundant selection; or
the unique identifier facilitates, when processing at least one second query, reuse of one or more of: the final data structure, the query data structure, or the information associated with the subset of the plurality of database records.