System and method of query processing with schema change in JSON document store
First Claim
1. A computer-implemented method of managing a query to find a set of JavaScript Object Notation (JSON) documents in a JSON document store, the method comprising:
- receiving a first query to find at least one JSON document in a plurality of sets of JSON documents stored in a JSON document store, each set of JSON documents in the plurality being organized in a unique JSON schema version related to a unique JSON schema version of each other set of JSON documents in the plurality by at least one schema change, the first query being organized in a first unique JSON schema version from a plurality of unique JSON schema versions of the respective plurality of sets of JSON documents;
maintaining a schema change graph of schema changes between pairs of the plurality of unique JSON schema versions;
translating the first query into a second query based on the at least one schema change, wherein the second query is organized in a second unique JSON schema version from the plurality of unique JSON schema versions;
executing the first query, organized in the first unique JSON schema version, on a first set of JSON document in the plurality of sets of JSON documents to provide a first query result, where the first set of JSON documents is organized in the first unique JSON schema version;
executing the second query, organized in the second unique JSON schema version, on a second set of JSON documents in the plurality of sets of JSON documents to provide a second query result, where the second set of JSON documents is organized in the second unique JSON schema version;
collecting the first query result and the second query result into a set of query results; and
returning the set of query results.
1 Assignment
0 Petitions
Accused Products
Abstract
An information processing system, a computer readable storage medium, and a method of managing a query to find a set of JSON documents in a multi-schema JSON document store. A query engine receives a first query to find at least one JSON document in a plurality of sets of JSON documents stored in the JSON document store, each set of JSON documents being organized in a unique JSON schema version related to a unique JSON schema version of each other set of JSON documents by at least one schema change. The first query is organized in a first unique JSON schema version. A query translator translates the first query into a second query based on the at least one schema change. The first and second queries are executed to provide first and second query results which are collectively returned.
22 Citations
20 Claims
-
1. A computer-implemented method of managing a query to find a set of JavaScript Object Notation (JSON) documents in a JSON document store, the method comprising:
-
receiving a first query to find at least one JSON document in a plurality of sets of JSON documents stored in a JSON document store, each set of JSON documents in the plurality being organized in a unique JSON schema version related to a unique JSON schema version of each other set of JSON documents in the plurality by at least one schema change, the first query being organized in a first unique JSON schema version from a plurality of unique JSON schema versions of the respective plurality of sets of JSON documents; maintaining a schema change graph of schema changes between pairs of the plurality of unique JSON schema versions; translating the first query into a second query based on the at least one schema change, wherein the second query is organized in a second unique JSON schema version from the plurality of unique JSON schema versions; executing the first query, organized in the first unique JSON schema version, on a first set of JSON document in the plurality of sets of JSON documents to provide a first query result, where the first set of JSON documents is organized in the first unique JSON schema version; executing the second query, organized in the second unique JSON schema version, on a second set of JSON documents in the plurality of sets of JSON documents to provide a second query result, where the second set of JSON documents is organized in the second unique JSON schema version; collecting the first query result and the second query result into a set of query results; and returning the set of query results. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. An information processing system that can manage a received query to find a set of JavaScript Object Notation (JSON) documents in a multi-schema JSON document store, the information processing system comprising:
-
a memory; a JSON document store for storing a plurality of sets of JSON documents where each set of JSON documents in the plurality being organized in a unique JSON schema version related to a unique JSON schema version of each other set of JSON documents in the plurality by at least one schema change; a query engine for executing queries against the plurality of sets of JSON documents; a query translator for translating a first query into a second query based on the at least one schema change, the first query being organized in a first unique JSON schema version from a plurality of unique JSON schema versions of the respective plurality of sets of JSON documents; a schema tracker for maintaining a schema change graph of schema changes between pairs of the plurality of unique JSON schema versions; and a processor, communicatively coupled with the memory, the JSON document store, the query engine, the query translator, and the schema tracker, the processor, responsive to computer instructions, performing a method to find a set of JSON documents in a JSON document store, the method comprising; receiving the first query to find at least one JSON document in the plurality of sets of JSON documents stored in the JSON document store; translating the first query into a second query based on the at least one schema change, wherein the second query is organized in a second unique JSON schema version from the plurality of unique JSON schema versions; executing the first query, organized in the first unique JSON schema version, on a first set of JSON document in the plurality of sets of JSON documents to provide a first query result, where the first set of JSON documents is organized in the first unique JSON schema version; executing the second query, organized in the second unique JSON schema version, on a second set of JSON documents in the plurality of sets of JSON documents to provide a second query result, where the second set of JSON documents is organized in the second unique JSON schema version; collecting the first query result and the second query result into a set of query results; and returning the set of query results. - View Dependent Claims (10, 11, 12, 13)
-
-
14. A non-transitory computer readable storage medium, comprising computer instructions which, responsive to being executed by a processor, cause the processor to perform operations to find a set of JavaScript Object Notation (JSON) documents in a JSON document store, the operations comprising:
-
receiving a first query to find at least one JSON document in a plurality of sets of JSON documents stored in a JSON document store, each set of JSON documents in the plurality being organized in a unique JSON schema version related to a unique JSON schema version of each other set of JSON documents in the plurality by at least one schema change, the first query being organized in a first unique JSON schema version from a plurality of unique JSON schema versions of the respective plurality of sets of JSON documents; maintaining a schema change graph of schema changes between pairs of the plurality of unique JSON schema versions; translating the first query into a second query based on the at least one schema change, wherein the second query is organized in a second unique JSON schema version from the plurality of unique JSON schema versions; executing the first query, organized in the first unique JSON schema version, on a first set of JSON document in the plurality of sets of JSON documents to provide a first query result, where the first set of JSON documents is organized in the first unique JSON schema version; executing the second query, organized in the second unique JSON schema version, on a second set of JSON documents in the plurality of sets of JSON documents to provide a second query result, where the second set of JSON documents is organized in the second unique JSON schema version; collecting the first query result and the second query result into a set of query results; and returning the set of query results. - View Dependent Claims (15, 16, 17, 18, 19, 20)
-
Specification