System and method of query processing with schema change in json document store

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 plurality of queries based on the plurality of schema changes, 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 a plurality of schema changes between respective 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 plurality of queries based on the plurality of schema changes, wherein each of the plurality of queries is organized in a respective 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 each of the plurality of queries, each query organized in a respective unique JSON schema version, on a respective one of the plurality of sets of JSON documents to provide a respective one of a plurality of query results, where the each of the plurality of sets of JSON documents is organized in the respective each unique JSON schema version;
• collecting the first query result and the plurality of query results into a collective set of query results;
• and
• returning the collective set of query results.

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 of sets of JSON documents 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 a plurality of schema changes between respective pairs of the plurality of unique JSON schema versions;
• translating the first query into a plurality of queries based on the plurality of schema changes, wherein each of the plurality of queries is organized in a respective 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 each of the plurality of queries, each query organized in a respective unique JSON schema version, on a respective one of the plurality of sets of JSON documents to provide a respective one of a plurality of query results, where the each of the plurality of sets of JSON documents is organized in the respective each unique JSON schema version;
• collecting the first query result and the plurality of query results into a collective set of query results;
• and
• returning the collective set of query results.