Database system and method
A method, computer program product, and computer system for a database system and method. In some embodiments, metadata associated with data stored in a non-relational database is generated. The metadata is based upon, at least in part, at least one of a location of the data, a state of data, and the data. The metadata is stored in a data structure in memory. A query for data stored in the non-relational database is received. The query is executed using the generated metadata to generate a metadata result set. A result set including data in the non-relational database is generated using the generated metadata result set.
1. A computer-implemented method comprising:
generating, by a computing device, metadata associated with data stored in a database to retrieve the data without searching all of the database;
storing, by the computing device, the generated metadata in a data structure in memory;
inspecting, by the computing device, the generated metadata for updates;
updating, by the computing device, the data stored in the database based upon, at least in part, the updates of the generated metadata;
receiving, by the computing device, a query for the data stored in the database;
executing, by the computing device, the query using the generated metadata to generate a metadata result set, wherein the generated metadata result set includes metadata specifying a path to the data in the database, and wherein generating the metadata result set includes combining a plurality of indexes in response to the query, wherein combining the plurality of indexes includes combining the plurality of indexes using one or more bitwise operations on the plurality of indexes;
generating, by the computing device, a result set using the plurality of indexes of the generated metadata result set including retrieving the data in the database from one or more devices using the metadata result set; and
transmitting, by the computing device, the result set to a requesting client, wherein the result set includes at least one of a link to the data stored in the database and a copy of the data stored in the database.
2. The computer-implemented method of claim 1 , wherein generating the result set includes: retrieving the data in the database from one or more devices using the metadata result set.
3. The computer-implemented method of claim 1 , further comprising:
inspecting, by the computing device, the generated metadata for updates.
4. The computer-implemented method of claim 1 , wherein the generated metadata includes one or more full text indexes of the data stored in the database.
5. The computer-implemented method of claim 1 , further comprising receiving the query over a switched fabric communication link.
6. The computer-implemented method of claim 1 , further comprising:
transferring, by the computing device, the data to a shard of the database on a second computing device; and
generating, by the computing device, metadata of the transferred data.
7. The computer-implemented method of claim 1 , further comprising:
storing, by the computing device, a database schema associated with a first instance of the database to a file; and
generating, by the computing device, a second instance of the database based upon the database schema.
8. A computer program product residing on a non-transitory computer readable medium having a plurality of instructions stored thereon which, when executed by a processor, cause the processor to perform operations comprising:
generating metadata associated with data stored in a database to retrieve the data without searching all of the database;
storing the generated metadata in a data structure in memory;
inspecting the generated metadata for updates;
updating the data stored in the database based upon, at least in part, the updates of the generated metadata;
receiving a query for the data stored in the database;
executing the query using the generated metadata to generate a metadata result set, wherein the generated metadata result set includes metadata specifying a path to the data in the database, and wherein generating the metadata result set includes combining a plurality of indexes in response to the query, wherein combining the plurality of indexes includes combining the plurality of indexes using one or more bitwise operations on the plurality of indexes;
generating a result set using the plurality of indexes of the generated metadata result set including retrieving the data in the database from one or more devices using the metadata result set; and
transmitting the result set to a requesting client, wherein the result set includes at least one of a link to the data stored in the database and a copy of the data stored in the database.
9. The computer program product of claim 8 , wherein generating the result set includes: retrieving the data in the database from one or more devices using the metadata result set.
10. The computer program product of claim 8 , further comprising:
inspecting, by the computing device, the generated metadata for updates.
11. The computer program product of claim 8 , wherein the generated metadata includes one or more full text indexes of the data stored in the database.
12. The computer program product of claim 8 , further comprising receiving the query over a switched fabric communication link.
13. The computer program product of claim 8 , further comprising:
transferring the data to a shard of the database on a second computing device; and
generating metadata of the transferred data.
14. The computer program product of claim 8 , further comprising:
storing a database schema associated with a first instance of the database to a file; and
generating a second instance of the database based upon the database schema.
15. A computing system including a processor and memory configured to perform operations comprising:
generating metadata associated with data stored in a database to retrieve the data without searching all of the database;
storing the generated metadata in a data structure in memory;
inspecting the generated metadata for updates;
updating the data stored in the database based upon, at least in part, the updates of the generated metadata;
receiving a query for the data stored in the database;
executing the query using the generated metadata to generate a metadata result set, wherein the generated metadata result set includes metadata specifying a path to the data in the database, and wherein generating the metadata result set includes combining a plurality of indexes in response to the query, wherein combining the plurality of indexes includes combining the plurality of indexes using one or more bitwise operations on the plurality of indexes;
generating a result set using the plurality of indexes of the generated metadata result set including retrieving the data in the database from one or more devices using the metadata result set; and
transmitting the result set to a requesting client, wherein the result set includes at least one of a link to the data stored in the database and a copy of the data stored in the database.
16. The computing system of claim 15 , wherein generating the result set includes: retrieving the data in the database from one or more devices using the metadata result set.
17. The computing system of claim 15 , further comprising:
inspecting the generated metadata for updates.
18. The computing system of claim 15 , wherein the generated metadata includes one or more full text indexes of the data stored in the database.
19. The computing system of claim 15 , further comprising receiving the query over a switched fabric communication link.
20. The computing system of claim 15 , further comprising:
transferring the data to a shard of the database on a second computing device; and
generating metadata of the transferred data.
21. The computing system of claim 15 , further comprising:
storing a database schema associated with a first instance of the database to a file; and
generating a second instance of the database based upon the database schema.