DATABASE SYSTEM AND METHOD

• US 20120310878A1
• Filed: 05/04/2012
• Published: 12/06/2012
• Est. Priority Date: 05/05/2011
• Status: Active Grant

• Current Assignee: Reversinglabs International GmbH
• Original Assignee: Reversinglabs International GmbH
• Inventors: Vuksan, Mario, Zeba, Hrvoje, Novoselac, Vedran
• Granted Patent: US 9,405,802 B2
• Time in Patent Office: Days
• US Class Current: 707/609
• CPC Class Codes: G06F 16/2272 Management thereof
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/24575 using context
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/901 Indexing; Data structures therefor; Storage structures for retrieval from the web G06F16/951
• CPC Class Codes: G06F 16/90335 Query processing

Abstract

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.

Claims

1. A computer-implemented method comprising:

generating, by a computing device, metadata associated with data stored in a non-relational database, the metadata based upon, at least in part, at least one of a location of the data, a state of data, and the data;

storing, by the computing device, the metadata in a data structure in memory;

receiving, by the computing device, a query for data stored in the non-relational database;

executing, by the computing device, the query using the generated metadata to generate a metadata result set; and

generating, by the computing device, a result set including data in the non-relational database using the generated metadata result set.

2. The computer-implemented method of claim 1, wherein generating the result set including data in the non-relational database includes:

retrieving the data in the non-relational 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;

and

updating, by the computing device, the data stored in the non-relational database based upon, at least in part, the updates of the generated metadata.

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 non-relational 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 non-relational 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 non-relational database to a file; and

generating, by the computing device, a second instance of the non-relational database based upon the database schema.

8. A computer program product residing on a 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 non-relational database, the metadata based upon, at least in part, at least one of a location of the data, a state of data, and the data;

storing the metadata in a data structure in memory;

receiving a query for data stored in the non-relational database;

executing the query using the generated metadata to generate a metadata result set; and

generating a result set including data in the non-relational database using the generated metadata result set.

9. The computer program product of claim 8, wherein generating the result set including data in the non-relational database includes:

retrieving the data in the non-relational database from one or more devices using the metadata result set.

10. The computer program product of claim 8, further comprising

inspecting the generated metadata for updates;

and

updating the data stored in the non-relational database based upon, at least in part, the updates of the generated metadata.

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 non-relational 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 non-relational 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 non-relational database to a file; and

generating a second instance of the non-relational 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 non-relational database, the metadata based upon, at least in part, at least one of a location of the data, a state of data, and the data;

storing the metadata in a data structure in memory;

receiving a query for data stored in the non-relational database;

executing the query using the generated metadata to generate a metadata result set; and

generating a result set including data in the non-relational database using the generated metadata result set.

16. The computing system of claim 15, wherein generating the result set including data in the non-relational database includes:

retrieving the data in the non-relational 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;

and

updating the data stored in the non-relational database based upon, at least in part, the updates of the generated metadata.

18. The computing system of claim 15, wherein the generated metadata includes one or more full text indexes of the data stored in the non-relational 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 non-relational 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 non-relational database to a file; and

generating a second instance of the non-relational database based upon the database schema.

22. A computer-implemented method comprising:

generating, by a computing device, metadata associated with data stored in a database, the metadata based upon, at least in part, at least one of a location of the data, a state of data, and the data;

storing, by the computing device, the metadata in a data structure;

receiving, by the computing device, a query for data stored in the database;

executing, by the computing device, the query using the generated metadata to generate a metadata result set; and

generating, by the computing device, a result set including data in the database using the generated metadata result set.